null

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14

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

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

YES

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

YES

Company Name

Sender Contact Name

Text

30

Steve McGuy

Sender Address 1

Text

30

YES

123 Fake St

Sender Address 2

Text

30

C/O That Place Co.

Sender Suburb

Text

30

YES

Melbourne

Sender State

Text

3

YES

VIC, NSW, etc.

Sender Postcode

Numeric

4

YES

3000

Sender Country Code

Text

2

YES

AU

Sender Phone

Numeric

10

0398785548

Sender Email

Text

50

stevemcguy@email.com.au

Sender Is Residential

Text

3

YES

Yes or No

Receiver Name

Text

30

YES

Customer Co

Receiver Contact Name

Text

30


John Johnson

Receiver Address line 1

Text

30

YES

456 Real St

Receiver Address line 2

Text

30

C/O That Other Place PTY LTD

Receiver Suburb

Text

30

YES

Glen Waverley

Receiver State

Text

3

YES

VIC, NSW, etc.

Receiver Postcode

Numeric

4

YES

3150

Receiver Country Code

Text

2

YES

AU

Receiver Phone

Numeric

10

0359687458

Receiver Email

Text

50

john.johnson@email.com.au

Receiver Is Residential

Text

3

YES

Yes or No

Authority to Leave

Text

3

YES

Yes or No

Delivery Instructions

Text

60

Please leave in mailbox

Special Instructions

Text

250

Items

Numeric

999

YES

101

Description

Text

250

YES

Carton, Pallet, etc.

Weight (KG) in Total (not per item)

Numeric

0.01 - 10000

YES

0.3 = 300g 

Volume (m3) in Total (not per item)

Numeric

0.001 - 10000

YES

0.004

  • No labels