Versions Compared

Key

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

Table of Contents

...

The file import will have the following format (red are required fields):

Account – (customer account) Must match an existing Account in IDS Core.

...

Caller Email (Caller Email)

PU Company Name (Pick Up - Address Company). If the Company Name doesn’t exist for the customer account IDS will create a new address. But if the “PU Location Bcode” in the import file matches an existing address then existing address will be updated.

...

PU Suite (Pick Up – Address Suite)

PU Street (Pick Up – Address Street)

PU City  (Pick Up – Address City)

PU Prov/State (Pick Up – Address Prov/State)

PU Country (Pick Up – Address Country)

PU Postal/Zip (Pick Up – Address Zip/PostalCode)

PU Notes (shipments pick up notes)

DEL Company Name (Delivery - Address Company). If the Company Name doesn’t exist for the customer account IDS will create a new address. But if the “PU Location Bcode” in the import file matches an existing address then existing address will be updated.

...

DEL Suite (Delivery – Address Suite)        

DEL Street (Delivery  – Address Street)

DEL City (Delivery  – Address City)

DEL Prov/State (Delivery – Address Prov/State)

DEL Country (Delivery – Address Country)

DEL Postal/Zip (Delivery – Address Zip/PostalCode)

DEL Notes  (shipments Delivery notes)

Service Level (Shipment Service Level)  - must match an existing service.

...

Due By  (shipment Due Time) format will be: 01/01/0001 12:00 AM +00. If blank, then the time will be when the shipment was imported.

Package (Shipment Package Type)  - must match an existing package type.

Piece (shipment Piece)

Weight (shipment Weight)

Length  (package’s length)

...

View file
nameexamplefileimport.csv

Back to the Top

How to Import the File

To import a file, please do the following:

  1. From the Shipment Import tab

  2. Click on “Browse”

    Image Added
  3. This will open the Windows File

...

  1. Browse pop up

    Image Added

  2. Navigate and find the file you wish to import.

  3. When you have found the file, click on the file, then click “Open”.

    Image Added
  4. You will now see your file in the “Selected File Name” field

    Image Added
  5. Then click on the “Import” button

    Image Added
  6. Once the import has completed you will see the results

    Image Added
  7. If there are any issues or failures, they will appear in the window. Failures can include:

    1. Service Level doesnt exist. You will need to either change the service level in the file to match an existing service level as is found in IDS or create the service level in IDS.

    2. Package Type doesnt exist. You will need to either change the package type in the file to match an existing service level as is found in IDS or create the package type in IDS.

    3. Account doesnt exist. You will need to change the account in the file to match an existing account as is found in IDS or create the account in IDS.

    4. Once you have made your fixes you can:

      1. remove successfully imported shipments from your file.

      2. then re-import you file.

Back to the Top