How To Import Jobs Across Different Dates

Instead of importing your jobs on a daily basis, you can import your jobs across days in one CSV or Excel manifest. You can also import collections and deliveries in one file. 

To import jobs across days via an Excel or CSV file, you need to create 2 mandatory columns for “Type” (referring to job type, either Delivery or Collection) and “Date”. For the “Date” column in your Excel or CSV file, you need to populate the dates in a consistent format; with the default format being YYYY-MM-DD (on your Detrack Dashboard > Jobs > Import Jobs).

DATE FORMAT

If you would like to change the date format, you can do so at Settings Job > Options > Date Format, from there you can select between 7 formats in the drop-down menu.

USE OF COLLECTION HEADERS

By default, the headers settings will take reference from your Delivery settings for importing.

If you wish for the systems to separately take the Delivery and Collection headers for importing your file, navigate to Settings > Collection > Switch on “Use collection headers for cross date import” > Save.

Thereafter, when the “Detrack Job Type” (either “Delivery” or “Collection”) is being specified, it will take reference from the Delivery or Collection headers respectively.

To import jobs across different dates:

  1. Click on Jobs > Import Jobs.
  1. Click on the box to upload your file.
  1. Click Save to import the file.
  1. The results will appear in the Import Results section.

Refer to <a “https://www.detrack.com/tutorials/v2/how-to-download-sample-csv-excel-template-for-import-across-different-dates/”>How To Download Sample CSV / Excel Template For Import Across Different Dates