Page Comparison

1. Open the project in Visual Studio.

   Open frmSelectUtilFunction.vb file and update line 1902 to the file path for your folder.

   Code BlockDim directoryPath As String = "C:\Users\lemi\Desktop\CAMIS Auto-Generated Reports\" + DateTime.Now

   .

   ToString("yyyyMMdd")

2. Run the application.

   If you are getting errors building the project, you may be missing some files that can be found here: \tc4s0a\Groups\AARA\AARAD\CAMIS\CAMIS Report Generator

3. Select Production User Database. Click Next.

   

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

5. Navigate to the folder specified in step 2 and into the folder for today’s date. Click Save.

6. Popup Image Added

7. The app will automatically create a folder, with the current date, in the “c:\Users” folder for your account:
   Example: C:\Users\dertinn\Desktop\CAMIS Auto-Generated Reports\20230515

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

9. A popup saying that the “Incoming eMER report and auto-accept script done!” should appear. Click OK,Wait while the script runs again for the next region (total of 7 regions).

10. Repeat steps 6-8 until “done” popup appears.

    

11. You should now have 7 Excel files in the folder as well as 7 scripts that have opened up.

12. 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.

13. 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

      Code Block

      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 #
Example:
\\Tc4s0a\groups\AARA\AARAD\CAMIS\developer documents\CAMIS_Weekly_Auto-Accept\261463

13. Permanently delete the files from your local drive.