How To Append A Prefix To The Run Number In Your CSV Export

If you need to add a Prefix to your run number after planning, you may specify the text for the wordings to be appended.

This tutorial will show you the steps to adding a Prefix to the Run number for CSV Export or when sending your planned stops back to your Detrack account.

How To Set Up

  1. Navigate to Settings > General.
  2. Scroll down to Export Run Prefix and enter your desired text, e.g. Prefix.
  3. Click Save when done.

Screenshot Of Planned Stops

Example CSV Export Without Prefix
Name Address 1 Address 2 Address 3 City State Postal Code Country Latitude Longitude Depot Assign To Run No. Sequence ETA Exception
Suntec City 3 Temasek Blvd Singapore Singapore 038983 Singapore 1.2946918 103.859158 Mandai Depot Vehicle1 1 1 8:00 AM
Singapore Expo 1 Expo Dr Singapore Singapore 486150 Singapore 1.3352329 103.959893 Mandai Depot Vehicle1 1 2 10:00 AM
Junction 8 9 Bishan Pl Singapore Singapore 579837 Singapore 1.35059015 103.848745 Mandai Depot Vehicle1 1 3 11:00 AM

After adding in the Prefix text, all the Run No. will have Prefix word appended to it.

Example CSV Export With Prefix Added
Name Address 1 Address 2 Address 3 City State Postal Code Country Latitude Longitude Depot Assign To Run No. Sequence ETA Exception
Suntec City 3 Temasek Blvd Singapore Singapore 038983 Singapore 1.2946918 103.859158 Mandai Depot Vehicle1 Prefix1 1 8:00 AM
Singapore Expo 1 Expo Dr Singapore Singapore 486150 Singapore 1.3352329 103.959893 Mandai Depot Vehicle1 Prefix1 2 10:00 AM
Junction 8 9 Bishan Pl Singapore Singapore 579837 Singapore 1.35059015 103.848745 Mandai Depot Vehicle1 Prefix1 3 11:00 AM

For changing of the headers for your CSV export, refer to How To Export Planned Stops To CSV.

Back To Tutorials