CAMIS Report Generator: performing the weekly auto-accept (Transferred to Wiki)

1. Open the project in Visual Studio.

2. Run the application.

3. Select Production User Database. Click Next.

   Open

   

4. Keep the defaults in “Step 2: Select Util function” (don’t change anything). Click Next.
   
   

   Open

   

    

5. The app will automatically create a folder, with the current date, in the “c:\Users” folder for your account:
   Example: C:\Users\dertinn\OneDrive - TC TC\_AAIR_2 (5)\CAMIS Auto-Generated Reports

6. Wait while the script runs again for the all regions (total of 7 regions).

7. A popup saying that the “Incoming eMER report and auto-accept script done!” should appear. Click OK,

9. You should now have 7 Excel files in the folder as well as 7 scripts.

10. Run each script using CAMIS_DATA_ADMIN@CAMISP, making sure to commit the changes after running each script. Also make sure you don’t run a script twice.

11. Send an encrypted email to the clients to let them know, choose “Protected B”, replace the signature in the template with your own info.

    • Attach all the Excel documents.

    • Send to AkiiYah.Walker@tc.gc.ca; gale.kapetis@tc.gc.ca; brenda.lee@tc.gc.ca; maria.santos@tc.gc.ca; terry.carter@tc.gc.ca; aouab.walialami@tc.gc.ca; mary.ferrer@tc.gc.ca; michelle.tan@tc.gc.ca

      • Walker, Akii Yah <AkiiYah.Walker@tc.gc.ca>

      • Kapetis, Gale <gale.kapetis@tc.gc.ca>

      • Lee, Brenda <brenda.lee@tc.gc.ca>

      • Santos, Maria <maria.santos@tc.gc.ca>

      • Carter, Terry <terry.carter@tc.gc.ca>

      • Wali Alami, Aouab <aouab.walialami@tc.gc.ca>

      • Ferrer, Mary <mary.ferrer@tc.gc.ca>

      • Michelle Tan <michelle.tan@tc.gc.ca>

    • CC: Baptiste, Daniel <Daniel.Baptiste@tc.gc.ca>

    • Subject: 20210908 Weekly Auto-Accept eMER completed

    • Message

      Good afternoon, The weekly auto-accept for your region has been run and completed with the following parameters: eMERs that are: • external and submitted • renewed by CAME • not in diabetes or SSRI • not deferred to RAMO • not initial applicant Please see attached for the report. Thank you, Michelle Le A/Team Lead, Application Development Solution Centre, Digital Services Directorate Transport Canada / Government of Canada michelle.le@tc.gc.ca Chef d'équipe p.i., Dévelopment des applications Centre des solutions, Direction générale des services numériques Transports Canada / Gouvernement du Canada michelle.le@tc.gc.ca

12. Backup the files to the shared location, similar to the example, but with its own corresponding task #

to \\Tc4s0a\groups\AARA\AARAD\CAMIS\developer documents\CAMIS_Weekly_Auto-Accept\

Example:
\\Tc4s0a\groups\AARA\AARAD\CAMIS\developer documents\CAMIS_Weekly_Auto-Accept\261463

13. Permanently delete the files from your local drive.

Open