Page Comparison

...

1. Open the project in Visual Studio.

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

   Code Block
   Dim directoryPath As String = "C:\Users\lemi\Desktop\CAMIS Auto-Generated Reports\" + DateTime.Now.ToString("yyyyMMdd")

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

4. Select Production User Database. Click Next.

   

5. Click Next.

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

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

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

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

   

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

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

12. Send an encrypted email to the clients to let them know, choose “Protected B”

    • 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

...