Clone the code to your local folder. The code can be found at https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/CAMIS Report Generator. From some developer’s experience: Cloning the code inside C:\user\{userId} will cause errors. It is recommended to clone the code outside ‘user’ folder such as C:\Projects\CAMIS_autoweekly\ |
|---|
Open the project in Visual Studio.
Run the application.
Select
Production User Database. Click Next.
Keep the defaults in “Step 2: Select Util function” (don’t change anything). Click Next.
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 ReportsWait while the script runs again for the all regions (total of 7 regions).
A popup saying that the “Incoming eMER report and auto-accept script done!” should appear. Click OK,
You should now have 7 Excel files in the folder as well as 7 scripts.
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.
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
...