CAMIS Report Generator

Open the project in Visual Studio.

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

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

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

Select Production User Database. Click Next.

Click Next.

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

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

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

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

Run each script using CAMIS_DATA_ADMIN@CAMISP, making sure to commit the changes.

Send an encrypted email to the clients to let them know.

• Attach all the Excel documents.

• Send to

  • 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