Importing Orders from *.csv / Excel

Example files are available under this document. You can download them and modify according to your own data.

In order to import orders into logvrp by uploading CSV / Excel File:

  • When "Orders Tab" is selected, Click "Import" Button.                                                                                                                                                       
  • When you click the Import Button, "Import Orders From CSV / Excel" window will appear.                                                                                                                                                                                                                                                                                            
  • If stations are present, choose the first option.                                                                                                                                                                                                                                                                                                                             
  • Then select the *.csv or Excel file which contains your orders. The orders file content must be as described below.
  • Click "Import" to start importing. A confirmation message box will appear. Since importing orders will clear your order data, please make sure that the current data is saved.
  • If the import is successful, you will see your imported orders on Orders Tab and on the Map.

 

The order CSV or Excel file content must follow the following rules: 

  1. The CSV file must contain the order information at each line separated with semi-colon (;). No need in Excel format
  2. At each line only 1 order information
  3. User Order ID: consists of alpha-numeric characters without comma (,)
  4. From_Station_name (pick up location): consists of alpha-numeric characters without comma (,)
  5. To_Station_name: consists of alpha-numeric characters without comma (,)
  6. Load Amount: A floating point number with the following restrictions
    1. Format: pdddd.dddddddd, where d is [0-9] and p id [1-9].
    2. Use dot (.) as decimal point seperator
  7. Load / Service Type: Integer of load type, one of the following:
    1. Parcel: 1
    2. Passenger: 2
    3. Liquid: 3
    4. Gravel: 4
    5. Frozen: 5
    6. Flammable: 6
    7. Garbage: 7
    8. Fragile: 8
    9. Custom: -1
  8. loading_duration & unloading_duration: Format: "dd:hh:mm" where
    1. d is day
    2. h is hour
    3. m is minute
    4. if no value, use "00:00:00"
  9. tw_min_pick & tw_max_pick & tw_min_delivery & tw_max_delivery: Format: "YYYY-MM-DD hh:mm:ss" where
    1. Y is year
    2. M is month
    3. D is day
    4. h is hour
    5. m is minute
    6. s is second
    7. if no value leave empty

IMPORTANT NOTICE: 

When the orders are imported, the current order list will be cleared from the Orders Tab and Map. Therefore, please make sure you have saved order data before importing any data if you do not want to lose your data. Moreover, if your import type is either type 2 or type 3, then the station data will also be cleared. Because, new stations will be created from the addresses or coordinates. So, please make sure that you have saved your station data also.      

Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    Al Fedor

    Putting coordinates in again is just plain dumb.  Once depots and stations are entered, orders should be input simply by depot to station (use names) and have the program calculate everything else.

Please sign in to leave a comment.
Powered by Zendesk