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. |
|---|
...
Open the project in Visual Studio.
...
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") |
...
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
Make sure you get no compile error. 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.
Navigate to the folder specified in step 2 and into the folder for today’s date. Click Save.
Popup
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,
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 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 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.
| View file | ||
|---|---|---|
|