Importing Vehicles 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 vehicles into logvrp by uploading CSV / Excel File:

  • When "Fleet Tab" is selected, Click "Import" Button.                                                                                                                                                                         
  • When you click the Import Button, "Import Vehicles From CSV/Excel" Window will appear.                                                                                                                                                                                                                                                                   
  • Choose vehicle import type. If stations are present, choose "Match station names and use current stations" option in the import window.                                                                                                                                                                                                                                                                                                                                                               
  • Then select the *.csv or Excel file which contains your vehicles. The vehicles file content must be as described below.
  • Click "Import" to start importing. A confirmation message box will appear. Since importing vehicles will clear your vehicle data, please make sure that the current data is saved. Moreover, if your import type is either type 2 or type 3, then the station data and associated order 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 and order data also.
  • If the import is successful, you will see your imported vehicles on "Fleet" Tab.
  • If the import type is either type 2 or type 3, then you will also see new stations are created from the imported vehicles on "Stations" Tab and on the Map.

 

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

  1. The file must contain the vehicle information at each line seperated with comma (,)
  2. At each line only 1 vehicle information
  3. vehicle_name: consists of alpha-numeric characters without comma (,)
  4. is_active: only true or false
  5. load_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
  6. capacity: 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. per_distance_cost: 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
  8. fixed_cost: 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
  9. average_speed: 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
  10. starting_station_name: consists of alpha-numeric characters without comma (,)
  11. stopping_station_name: consists of alpha-numeric characters without comma (,)
  12. starting_station_address: consists of alpha-numeric characters without comma (,)
  13. starting_station_address: consists of alpha-numeric characters without comma (,)
  14. starting_station_longitude & stopping_station_longitude (X coord): A floating point number with the following restrictions
    1. Format: d.dddddddd or -d.dddddddd or pd.dddddddd or -pd.dddddddd or pdd.dddddddd or -pdd.dddddddd, where d is [0-9] and p id [1-9].
    2. Use dot (.) as decimal point seperator
    3. Must be between -180 and 180
    4. Valid example 1: 0.02478
    5. Valid example 2: -2.78956
    6. Valid example 3: 29.98340
    7. Valid example 4: -123.45678
    8. Invalid example 1: 05.02478 (because there is a zero (0) before the non-decimal part)
    9. Invalid example 2: +2.78956 (because there is a plus (+) sign
    10. Invalid example 3: 29,98340 (because comma (,) is used as decimal seperator)
    11. Invalid example 4: 321.98340 (because it is bigger than 180)
  15. starting_station_latitude & stopping_station_latitude (Y coord): A floating point number with the following restrictions
    1. Format: d.dddddddd or -d.dddddddd or pd.dddddddd or -pd.dddddddd or pdd.dddddddd or -pdd.dddddddd, where d is [0-9] and p id [1-9].
    2. Use dot (.) as decimal point seperator
    3. Must be between -90 and 90
    4. Valid example 1: 0.02478
    5. Valid example 2: -2.78956
    6. Valid example 3: 29.98340
    7. Valid example 4: -123.45678
    8. Invalid example 1: 05.02478 (because there is a zero (0) before the non-decimal part)
    9. Invalid example 2: +2.78956 (because there is a plus (+) sign
    10. Invalid example 3: 29,98340 (because comma (,) is used as decimal seperator)
    11. Invalid example 4: 321.98340 (because it is bigger than 90)
  16. tw_min_available: minimum time vehicle will be available. 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

An examle vehicles.csv file content might be:

Vehicle - 1;true;1;4;0.3;50;30;Depot Station;Depot Station;2010-08-27 07:07:00
Vehicle - 2;true;1;4;0.3;50;20;Depot Station;Depot Station;2010-08-27 07:07:00

 

IMPORTANT NOTICE: 

When the vehicles are imported, the current vehicle list will be cleared from the Fleet Tab. Please make sure you have saved vehicle data before importing any data if you do not want to lose your data. 


Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk