Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Table of Contents | ||||
---|---|---|---|---|
|
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 |
Template
Download:
View file | ||
---|---|---|
|
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 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 |
| 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 |
| Company Name | ||||||
Sender Contact Name | Text | 30 | Steve McGuy | |||||||
Sender Address 1 | Text | 30 |
| 123 Fake St | ||||||
Sender Address 2 | Text | 30 | C/O That Place Co. | |||||||
Sender Suburb | Text | 30 |
| Melbourne | ||||||
Sender State | Text | 3 |
| VIC, NSW, etc. | ||||||
Sender Postcode | Numeric | 4 |
| 3000 | ||||||
Sender Country Code | Text | 2 |
| AU | ||||||
Sender Phone | Numeric | 10 | 0398785548 | |||||||
Sender Email | Text | 50 | stevemcguy@email.com.au | |||||||
Sender Is Residential | Text | 3 |
| Yes or No | ||||||
Receiver Name | Text | 30 |
| Customer Co | ||||||
Receiver Contact Name | Text | 30 | John Johnson | |||||||
Receiver Address line 1 | Text | 30 |
| 456 Real St | ||||||
Receiver Address line 2 | Text | 30 | C/O That Other Place PTY LTD | |||||||
Receiver Suburb | Text | 30 |
| Glen Waverley | ||||||
Receiver State | Text | 3 |
| VIC, NSW, etc. | ||||||
Receiver Postcode | Numeric | 4 |
| 3150 | ||||||
Receiver Country Code | Text | 2 |
| AU | ||||||
Receiver Phone | Numeric | 10 | 0359687458 | |||||||
Receiver Email | Text | 50 | john.johnson@email.com.au | |||||||
Receiver Is Residential | Text | 3 |
| Yes or No | ||||||
Authority to Leave | Text | 3 |
| Yes or No | ||||||
Delivery Instructions | Text | 60 | Please leave in mailbox | |||||||
Special Instructions | Text | 250 | ||||||||
Items | Numeric | 999 |
| 101 | ||||||
Description | Text | 250 |
| Carton, Pallet, etc. | ||||||
Weight (KG) in Total (not per item) | Numeric | 0.01 - 10000 |
| 0.3 = 300g | ||||||
Volume (m3) in Total (not per item) | Numeric | 0.001 - 10000 |
| 0.004 |