EXPEDIENT SOFTWARE

Going beyond software performance.

Release 130213 – NZ Forwarding – Sea Job Import and Export (Load Container Details File)

This release provides an option to load container details from a CSV file directly into the Import and Export Sea Job Registration screens in New Zealand.

Sea Import Job Registration

You are able to load a CSV file from your desktop directly into the Container Details tab, as long as the data conforms to the required format documented below.

To use this feature: Register the Import Sea Job and click on the button that appears at the bottom of the Container Details tab. You can then browse to the required .CSV file and click on the Open button. The load process will advise you if the load was successful. Click on Exit to see the containers loaded into the screen. If there is an error in the file, e.g. there is missing information which is mandatory, you will get a message explaining the problem.

The file format must be:

A comma separated values (.csv) file (easily created in Microsoft Excel)

The data must be in the following order:

Column Description Validation Field Format
A Bill Number Mandatory General
B Load Type

accepted codes

F – FCL

L – LCL

B – Bulk

E – Empty

P – Pallet

Mandatory General
C Container Number Mandatory General
D Seal Optional General
E Type Mandatory General
F Size Mandatory General
G Pieces Optional General
H Pack Type Optional General

A file example:

BILL NUMBER 1,F,ABCD1234567,12345,15,20,23,BC

E.g.

 

Sea Export Job Registration

You are able to load a CSV file from your desktop directly into the Container Details tab, as long as the data conforms to the required format documented below.

To use this feature: Register the Export Sea Job and click on the button that appears at the bottom of the Container Details tab. You can then browse to the required .CSV file and click on the Open button. The load process will advise you if the load was successful. Click on Exit to see the containers loaded into the screen. If there is an error in the file, e.g. there is missing information which is mandatory, you will get a message explaining the problem.

The file format must be:

A comma separated values (.csv) file (easily created in Microsoft Excel)

 

The data must be in the following order:

Column Description Validation Field Format
A Bill Number Mandatory General
B Container Number Mandatory General
C Load Type

accepted codes

F – FCL

L – LCL

E – Empty

P – Pallet

S – Separate

Mandatory General
D Type Optional General
E Size Mandatory General
F Seal Optional General
G Net Wght Optional General
H Gr Wght Optional General
I Pieces Optional General

A file example:

BILL NUMBER 1,ABCD1234567,F,15,22G0,12345,55,7500,900

 

E.g.

 

 

Updated: June 22, 2015 — 10:59 pm
EXPEDIENT SOFTWARE GUIDE © 2015