Client Identification Database (CID) platform site bulk upload procedures

Transport Canada's Client Identification Database Platform, herein referred to as TC CID Platform, addresses recommendations made by the Office of the Auditor General of Canada, that Transport Canada improve its knowledge of stakeholders involved in the importing, offering for transport, handling, or transportation of dangerous goods (DG) herein referred to DG activities. In response to this recommendation, the Transportation of Dangerous Goods (TDG) Directorate is introducing a new requirement for businesses involved in DG activities to register and provide information on their DG activities. For more detailed information, please visit the Canada Gazette, Part II Volume 157, Number 22.

On this page

• Getting started
• Download a workbook
• Create or update a workbook
• Upload a workbook
• Appendix A: Classes and division
• Appendix B: Compatibility groups for Class 1, Explosives

Getting started

While individual site registrations can be done one (1) at a time, utilizing the Site Bulk Upload Excel Workbook is a highly efficient and time-saving solution for registering or updating multiple sites simultaneously.

You have the option to name each site in the workbook, although it is not mandatory. However, each entry must include the following:

• site location, which can be specified using one (1) of the following:
  • mailing address; applicable to postal codes that do not start with a zero (0);
  • legal land description; only available for rural and remote areas of Manitoba, Saskatchewan, Alberta, British Columbia;
  • latitude and longitude;
• at least one (1) mode of transport;
• at least one (1) type of activity; and
• which classes and/or divisions apply to the site.

Download a workbook

1. Sign into the CID Platform
2. Select “Sites” from the left-hand menu
3. Select “Download Bulk Site Upload Workbook” and save it on to your computer
4. Open the workbook file

Create or update a workbook

1. Enter a unique name for each site (optional). This name is for your reference.
2. Enter the site's location using one (1) of these methods:
   • mailing address
     • enter the site's mailing address by completing the fields as marked;
     • in “Address Line 1” enter the street number, name, and abbreviated street type such as Dr, St, Cres;
     • for “Address Line 2” (Optional) enter any other information about the site, like a room number or specific entrance; and
     • for “Address Line 3” (Optional) enter any other relevant information, like your desk number or office cubicle.
   • legal land description
     • complete the fields as marked using the form's drop-down menus.
   • latitude and longitude
     • enter the site's latitude and longitude in decimal degrees using four (4) decimal points (e.g., 45.1234), you must include four (4) decimal points;
     • latitude must be between 40.0000 and 80.0000; and
     • longitude must be between -50.0000 and -150.0000.
3. Enter the types of activities occurring on the site. Select "Yes" from the drop-down menu if the site performs the listed type of work:
   • importing: you import dangerous goods into Canada. This doesn't apply when goods are being transported on a vessel or aircraft not registered in Canada.
   • handling: loading, unloading, packing, or unpacking dangerous goods in a means of containment.
   • offering for transport: choosing a carrier, and/or preparing dangerous goods for transport by a carrier.
   • transporting: moving dangerous goods from one place to another.
4. Enter the modes of transportation that are used to move dangerous goods to/from your site. If your site uses the mode listed in the column header, then choose “Yes” from the drop-down menu:
   • road: dangerous goods transported by road.
   • rail: dangerous goods transported by rail.
   • air: dangerous goods transported by air.
   • marine: dangerous goods transported by water where the means of containment is not the vessel, such as freighters, ferries.
5. Enter the classes/divisions of dangerous goods that your site handles:
   • separate each class/division with a comma;
   • for class 1, include the compatibility group for each division; and

   • for classes 2 to 6, compatibility groups are not required.

     Need help?

     • Find a list of classes and divisions in Appendix A
     • Find a list of compatibility groups for Class 1, Explosives in Appendix B
6. This field already displays the site status, indicating whether it's active or inactive.
7. Any information from previous workbooks can be copied and pasted on to a new workbook. You will have to copy/paste into the section between Column A (Site Name) and Column X (Class/Division) starting with row 7 and however many rows of input you have after row 7. (Row 7 is the first row for inputting sites.).

Upload a workbook

1. Save the completed workbook to your local folder
2. On the CID portal, select Choose File and select the workbook you saved on your local folder
3. Select Start Upload
4. You will receive an email confirmation once the workbook upload is completed
   • If the upload fails, you will receive an email that will outline the errors that need to be corrected
5. Select Next when your workbook is uploaded

Appendix A: Classes and divisions

Appendix B: Compatibility groups for Class 1, Explosives

When choosing Classes under Class 1, you must enter the class, division, and compatibility group.