Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

.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.
Make sure you get no compile error.

  1. Open the project in Visual Studio.

  2. Run the application.

  3. Select Production User Database. Click Next.

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

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

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

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

  8. You should now have 7 Excel files in the folder as well as 7 scripts.

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

  10. Send an encrypted email to the clients to let them know, choose “Protected B”, replace the signature in the template with your own info.

...