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

  • When "Stations Tab" is selected, Click "Import" Button.                                                                                                                                                                                           
  • When you click the Import Button, "Import Stations From CSV / Excel" window will appear.                                                                                                                                                                                                                                                                                                                                                                                                
  • In Import Stations Window choose import type.
    • If the coordinates of your stations are correct, choose "Use coordinates as the station location". In this case, the addresses of the stations will no be used for determining the location of the station.
    • If the addresses of your stations are correct, choose "Use addresses as the station location". In this case, the coordinates of the stations will not be used for determining the location of the station. Since the addresses may not represent a location exactly in geocoding the address into coordinates, we suggest you to use coordinates. If an address of a station can not be geocoded into coordinates, then that station will be listed with a prompt. You can either try again or import. If you choose import when there are unkown addresses, then those stations will be placed onto coordinates (0,0), i.e. south west of Africa.                                                                                                                                                                                                                                              
  • Then select the *.csv or Excel file which contains your stations. The stations file content must be as described below.
  • Click "Import" to start importing. A confirmation message box will appear. Since importing stations will clear your station data and order data, please make sure that the current data is saved.
  • If the import is successfull, you will see your imported stations on "Stations" Tab and on the Map. 

 

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

  1. The CSV file must contain the station information at each line separated with semi-colon (;). No need in Excel
  2. At each line only 1 station information
  3. Each station information must be in the exact order: station_name, is_active, is_depot, Longitude (X coord), Latitude (Y coord), "station_address"
  4. station_name: consists of alpha-numeric characters without comma (,)
  5. is_active: only true or false
  6. is_depot: only true or false
  7. Longitude (X coord): A floating point number with the restrictions defined below. This field can be 0 (zero) if you DONT know the coordinates (latitude, longitude) and you know the address and choose "Use addresses as the station location" when importing
    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)
  8. Latitude (Y coord): A floating point number with the restrictions defined below. This field can be 0 (zero) if you DONT know the coordinates (latitude, longitude) and you know the address and choose "Use addresses as the station location" when importing
    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)
  9. station_address: consists of alpha-numeric characters without comma (,). This field can be optional if you know the coordinates (latitude, longitude) and choose "Use coordinates as the station location" when importing

Sample CSV File Content

Depot; true; true; -73.9857; 40.6896; "2-30 Hoyt St Brooklyn NY 11201 USA" 
St 1; true; false; -74.0122; 40.7190; "32-98 Harrison St New York NY 10013 USA" 
St 2; true; false; -74.0048; 40.7261; "26 Vandam St New York NY 10013 USA" 
St 3; true; false; -73.9511; 40.7235; "78-80 Nassau Ave Brooklyn NY 11222 USA" 

IMPORTANT NOTICE:

 When the stations are imported, the current station list and order list will be cleared from the Station Tab, Order Tab and Map. Therefore, please make sure you have saved stations and order data before importing any data if you do not want to lose your data.

 

 

Have more questions? Submit a request

3 Comments

  • 0
    Avatar
    Dezhan Pi

    Very detailed documentation on the import process. Good job!

  • 0
    Avatar
    Al Fedor

    It would be very helpful to input the addresses and have the program calculate the coordinates.  Doing it your way now requires much extra time to look up coordinates.  In my business the addresses, except for the depots, change every day.

     

  • 0
    Avatar
    logvrp

    Al Fedor,

    If you look at the documentation, you will see that you can import from addresses also. You do not have to know the coordinates. Please read first!

Please sign in to leave a comment.
Powered by Zendesk