Versions Compared

Key

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

This article explains how to import shipments into IDS so that they can be optimized.

IDS Route is our Route Optimization Software which can be operated as a stand Client or plugged into IDS Core.

As such, features with (IDS Core) beside them mean you must be connected to IDS Core to work.

...

How to Import Shipments from the Dispatch Board (IDS Core)

How to Import Shipments from the Drivers Board (IDS Core)

Back to IDS Route Tutorial

...

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)

...

  1. From the Shipment Import pop up

  2. Click on “Browse”

  3. This will open the Windows File Browser pop up

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

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

  6. You will now see your file in the “Selected File Name” field

  7. Then click on the “Import” button

  8. Once the import has completed you will see the results

  9. 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

How to Import Shipments from the Dispatch Board (IDS Core)

adsfa

Back to the Top

How to Import Shipments from the Drivers Board (IDS Core)

asdf

Back to the Top