It is highly recommended to follow the below instruction for the preparation of the valid data before performing any bulk update in TrakIT.

1. How to prepare the data for Events, Data, and Header Fields

How to get an Import Template (excel)?:

• Visit the Workflow > Shipments > Work Order Tab and apply the necessary filters.

• Choose the Relevant Header / Event / Data Fields which you want for bulk update, then Click on Export Button.

• Make use of this as an import template to perform the bulk update.

For the preparation of Data you need to follow the instructions given below in Points 2 and 3.

2. Steps to follow to ensure import template excel should have only that data which you want to get updated

Don't change the Column Titles in the downloaded excel file.

• If you want to bulk update the data at Work Order Level then keep the First Column as Work Order ID

• If you want to update the data only at T/D Level then keep the First Column as Transport Document

Highlight Cells with Yellow background which you want to get updated in the system. Make sure you keep only those rows and columns in excel which you want to get updated.

• Date Format should be in "dd mmm yyyy h:mm" format or a valid date format in excel.

3. Exclusion for Bulk Update (Very Important)

• Make sure Excel should has only one sheet.

• It should not contain any Closed Work Order / Shipments.

• Bulk Update never updates Transport Document / Depot List.

• If you don't want to update values with Blank then don't highlight blank cells with yellow.

• Bulk Update doesn't create new Work Orders, so don't keep new Work Orders in excel.

• Any reference Columns like Transporter / Customer / Entities / Etc. should exist in TrakIT, as it doesn't update data for missing references.

• Bulk Update doesn't update the Service as work order Event/Data applicability is dependent on the services and changing services do resetting of WO so that it shows only applicable Event/Data only.