First of the Month Process for ARM Reports

The Recharge Report consists of two scripts: run.py and export.py

• Run is the gather that can be run as frequently as desired and updates the bank table in the MySQL DB with the data from the SiteWatch DB.

• Export combines the info from employee, and bank to show a more human readable report and exports the csv to the netserver.

• As long as the pc where the script is being executed has DSN's for the SiteWatch DB and the Bank DB (CSAS-SQL) and has x86 Python we can execute the gather for this report.

• Note: The recharge report codebase was changed from PHP to Python in Q2 2021

Process

• 1) Log into CSAS-SQL

• 2) Open Pycharm

• 3) Open the Tasks repository

• 4) Navigate to C:\git\Tasks\Home\Reports\Recharge\

• 5) Open the run.py file and check TODO's

• 6) When ready, execute run.py

• A) Reminder: You have to use x86 python to connect to the firebird DB

• 7) When complete, open export.py and check TODO's

• 8) When ready, execute export.py

• A) The file dump out here: \\NETSERVER\IT-Department\Documents\Web Reports\FastPass Sales Reports\csv

• 9) Navigate to \OneDrive - Spotless Brands\Documents - Information Technology\General\Convert\Reports\Fastpass Recharge Reports and duplicate the file from last month and rename YY-MM-recharge-report.xlsx

• 10) Open your new file

• 11) Duplicate the most recent tab

• 12) Copy the contents of the csv file created by export.py into the table

• 13) Scroll to the bottom and delete any extra records that may have been left over

• 14) Go to the Data tab, choose Sort, and click ok to sort by Site then Name

• 15) Save the file as this will be the one, we want to send the Ops team.

Process

• 1) Log into DRB-RPWL

• 2) Open Sublime Text as administrator

• 3) Update the date under the TODO and Manual Override in C:\Tasks\Home\Reports\Status\updatePrevMonth.php

• 4) Update the sites list in C:\Tasks\Resources\Sites.php if necessary - If adding a new site, check site id by running the following SQL query on SWODB or other database tool (Flame Robin on Q2): select * from V_SITE - Additionally, run the following query to get recharge terminal ID: select * from v_terminal where site=X and terminaltype=9 (where X is the site ID in question from the first query)

• 5) Run cmd as admin

• 6) Cd to C:\Tasks\Home\Reports\Status\

• 7) In your elevated command prompt run: "C:\Program Files (x86)\PHP\v7.3.4\php.exe" updatePrevMonth.php

• 8) You can monitor the progress of this script in the logs under C:\Tasks\Home\Reports\Status\Log. ETA is usually ~7 hours so you can move to the other report while this runs

• 9) Once it's done, log back into CSAS-SQL

• 10) Open Pycharm

• 11) Open the Tasks repository at C:\git\Tasks

• 12) Navigate to C:\git\Tasks\Home\Reports\Status\

• 13) Open export.py and check TODO's

• 14) When ready, execute export.py

• A) The file will dump out here: \\NETSERVER\IT-Department\Documents\Web Reports\Unlimited Status Reports\csv

• 15) Navigate to \OneDrive - Spotless Brands\Documents - Information Technology\General\Convert\Reports\Unlimited Status Reports and duplicate the file from last month and rename Reconcile-Sheet-YY- MM.xlsx

• 16) Open your new file

• 17) Copy the contents of the csv file created by export.py into the last sheet of the new file

• 18) Double check to make sure that everything matches up and no new sites need added to the sheets.

• 19) Save the file as this will be the one, we want to send the Ops team.

Steps

• 1) Find the email thread subject: Fastpass Recharge and Status Reports

• 2) Copy the message from last month

• 3) Reply all

• 4) Update the message with appropriate content for the month the reports are for

• 5) Attach files

• 6) Triple check

• 7) Send to everyone!

Tidying Up

• If you made any major changes to the files in C:\Tasks or D:\webroot\rewards\htdocs, make sure to update the repo’s on Github.