Support Center

Import lists of Orders: Excel, CSV, API

Last Updated: Nov 05, 2013 10:56AM EST
There are three ways to import lists of Orders:

  • You can upload an Excel file (see below for correct format and templates)
  • You can upoad a CSV file (see below for correct format and templates)
  • You can automate the import/export process by integrating the Viamente Route Planner API with your system. API stands for "Application Programming Interface" and it allows your system to communicate with the Viamente servers. Read more about how to automate the process here and download technical documents and programming examples at this link.

Your Excel/CSV file or the data sent via API will list the Addresses and all the other parameters you can use to define your Orders.

All parameters are described in this article: how are Orders defined?


EXCEL Templates


To upload an Excel file, you should use one of these two templates.
     

Single-field Address format:     

    Complete Address in one cell       

  Download Template      

Multi-field Address format:     Street  |   ZIP  |   City  | State           Download Template     


Important notes:
  • Only the Address fields are mandatory, all other fields are optional
  • You can add custom columns (e.g. Invoice nr., Order nr.)
  • The order of the rows does not matter
  • Learn the meaning of all Order fields following this link.

You can also generate, customize and download a template directly from within your Viamente account. Read more about our template generator.


​CSV Templates


To upload a CSV file, you should use one of these two templates.
 
Single-field Address format:

Address;Name;Service Time;Eligible Days;Time Window Start;Time Window End; Time Window 2 Start;Time Window 2 End;Order Type;Load;Load 2;Load 3;Required Driver;Required Skills;Banned Skills; Importance; Notes

1672 Mariani Dr, 94087, Sunnyvale, CA;Alice McBain;5;1-3;8.00;11.00;;;;2;;;;;;;Check back door

1534 Sandpiper Ct, 94087, Sunnyvale, CA;Bob Aprick;5;8.00;12.00;13.00; 16.00;;1;;;;;;;Deliver newspapers

Multi-field Address format:

Street; City; State;ZIP;Country; Name;Service Time;Eligible Days;Time Window Start;Time Window End; Time Window 2 Start;Time Window 2 End;Order Type;Load;Load 2;Load 3;Required Driver;Required Skills;Banned Skills; Importance; Notes

1672 Mariani Dr;Sunnyvale;CA;94087;USA;Alice McBain;5;1-3;8.00;11.00;;;;2;;;;;;;Check back door

1534 Sandpiper Ct;Sunnyvale;CA;94087;USA;Bob Aprick;5;8.00;12.00;13.00;16.00;;1;;;;;;;Deliver newspapers

 
Important Notes:
  • Only the Address fields are mandatory, all other fields are optional
  • You can add custom columns (e.g. Invoice nr., Order nr.)
  • The order of the rows does not matter
  • Learn the meaning of all Order fields following this link.
  • Field values must be enclosed in double quotes if they contain the field-separator character (e.g.: "phone;door on the left;ring bell #5")

Contact Us

http://assets0.desk.com/
false
ViamenteRouting
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete