Differences

This shows you the differences between two versions of the page.

--- software:information_systems [2023/09/24 19:21] – ↷ Page moved from shoptechs:information_systems to software:information_systems smartin015
+++ software:information_systems [2024/05/29 00:45] (current) – smartin015
@@ Line 1: / Line 1: @@
 ====== Information Systems Explainer ======
-{{ :shoptechs:tech_stack_diagram.png?600 |}}
+[[https://youtu.be/sP8dIfBBVHs|Software Tech Talk, May 2024]]
+===== Hosting =====
+We host via NameCheap - we have a Red Hat linux server running our WordPress page, DocuWiki, and Booked reservation system.
+There's also an IONOS shared VPS that hosts custom python code for automation tasks and custom dashboards/interfaces.
 ===== Neon One CRM =====
@@ Line 52: / Line 58: @@
 Zapier is an automation service that takes data from Airtable and performs actions in Asana and Discord. This includes:
-* Running the membership check bot ("Bender")
+  *  Posting shift reports and tool reports to Discord
-* Posting shift reports and tool reports to Discord
+  *  Auto-generating Asana tasks for scheduled maintenance and purchase requests
-* Auto-generating Asana tasks for scheduled maintenance and purchase requests
 ===== Booked Scheduler =====
@@ Line 85: / Line 90: @@
 There is a patch to one of the oauth files in the wiki software to make sign-ins work with neons oauth.   that patch is up on the protohaven github here: https://github.com/protohaven/systems-integration/tree/main/neon-dokuwiki-oauth
+===== Sheets automation =====
+We use AppScript for automating some data management for payroll and member sign in:
+Payroll is done through the Master Instructor Hours and Clearance Log - https://docs.google.com/spreadsheets/d/1dM_b1O7Uzj4qwyyJ-uMTmrE6sIcWowYnzYxhhpcWbGI/edit#gid=1037366967
+Member check:
+https://docs.google.com/spreadsheets/d/1YOdSUxjE5bb9ola9CB0LCq5ElDd1WCKx-6UBR-JzLuM/edit#gid=677739698
+Pulls from Protohaven welcome and waiver form responses sheet:
+https://docs.google.com/spreadsheets/d/1UrLZV1uAxW4ziLdy02kSXg15jidRYpktgQP8D5qz2rU/edit#gid=306631776
+Which has appscript for annotating membership status and clearances (in neon and in the instructor hours and clearance log sheet)