Versions Compared

Key

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

Stop!

Are you uploading more than 200 consignments?

Uploading a large file can put a lot of strain on the system and can take quite some time to load. It is not recommended to load more than 200 cons at a time. It is best practice to break large numbers of cons into 200 cons or less

Step 1: Accessing the Import Consignments page

In OneFlo, click on the settings cog ⚙ in the top right hand corner of the page > Click Import Consignments

Step 2: Selecting the file

Note

Please note: The file will need to be in a .csv format. Please use the attached template as it will make the next step easier

select First row in header > Click browse to select the file that is to be uploaded and

Step 3: Mapping the file

The page should look like this, though there could be some small differences:

The top section is for editing any errors:

And the bottom section is for mapping the headings. If there are any --Select File Column-- In the second column, click on the drop down boxes and match them to the first column appropriately:

Step 4: Importing the file

After mapping the file headers, click Import Data t the top of the screen.

This will take you to a new screen where, if there are any errors, they can be corrected here. Refresh the page after a while to see if any errors appear, or if they have processed. If there are a large number of consignments, this may take some time to process.

Clicking the green triangle (blue star) will show what the errors are, if there are any.

This screen is where most of the errors can be fixed. For example, Receiver Location is invalid is because either the postcode or suburb is incorrect.

Mandatory Fields

Field Name

Type

Character Limit

Mandatory

Examples

Released

DateTime

8

Status
colourRed
titleYES

DD/MM/YYYY

Service

Text

20

TP02

Reference

Text

20

123ABC

3rd Party Account

Text

10

DEF456

Cost Centre

Text

10

Sender Name

Text

30

Status
colourRed
titleYES

Company Name

Sender Contact Name

Text

30

Steve McGuy

Sender Address 1

Text

30

Status
colourRed
titleYES

123 Fake St

Sender Address 2

Text

30

C/O That Place Co.

Sender Suburb

Text

30

Status
colourRed
titleYES

Melbourne

Sender State

Text

3

Status
colourRed
titleYES

VIC, NSW, etc.

Sender Postcode

Numeric

4

Status
colourRed
titleYES

3000

Sender Country Code

Text

2

Status
colourRed
titleYES

AU

Sender Phone

Numeric

10

0398785548

Sender Email

Text

50

stevemcguy@email.com.au

Sender Is Residential

Text

3

Status
colourRed
titleYES

Yes or No

Receiver Name

Text

30

Status
colourRed
titleYES

Customer Co

Receiver Contact Name

Text

30


John Johnson

Receiver Address line 1

Text

30

Status
colourRed
titleYES

456 Real St

Receiver Address line 2

Text

30

C/O That Other Place PTY LTD

Receiver Suburb

Text

30

Status
colourRed
titleYES

Glen Waverley

Receiver State

Text

3

Status
colourRed
titleYES

VIC, NSW, etc.

Receiver Postcode

Numeric

4

Status
colourRed
titleYES

3150

Receiver Country Code

Text

2

Status
colourRed
titleYES

AU

Receiver Phone

Numeric

10

0359687458

Receiver Email

Text

50

john.johnson@email.com.au

Receiver Is Residential

Text

3

Status
colourRed
titleYES

Yes or No

Authority to Leave

Text

3

Status
colourRed
titleYES

Yes or No

Delivery Instructions

Text

25060

Please leave in mailbox

Special Instructions

Text

250

Items

Numeric

999

Status
colourRed
titleYES

101

Description

Text

250

Status
colourRed
titleYES

Carton, Pallet, etc.

Weight (KG) in Total (not per item)

Numeric

0.01 - 10000

Status
colourRed
titleYES

0.3 = 300g 

Volume (m3) in Total (not per item)

Numeric

0.001 - 10000

Status
colourRed
titleYES

0.004