Difference between revisions of "Import"

From RouteXL
Jump to: navigation, search
m (Removed check in database)
m (Notes)
Line 20: Line 20:
  
 
* Each address should be on one line.
 
* Each address should be on one line.
 +
 +
* If there are problems, a message will be displayed after all addresses have been handled.
  
 
* If locations are not found, use the correct [[Address format]] or select another [[Geocoding]] service.
 
* If locations are not found, use the correct [[Address format]] or select another [[Geocoding]] service.
  
* If there are problems, a message will be displayed after all addresses have been handled.
+
* The import dialog accepts coordinates and JSON too. Coordinates must be in the format ''<lat>,<lng>'' and have a precision of at least 4 decimal places. Coordinates can be combined with additional fields.
 
 
* The import dialog accepts coordinates and JSON too.
 
  
 
== Additional fields ==
 
== Additional fields ==

Revision as of 12:12, 1 October 2018

The Import button is a powerful tool to add multiple destination addresses at once. You can copy addresses in any application and paste in the Import textarea. Each address is sent to a Geocoding service to locate it on the map.

Import dialog.png

Instructions

1. Select the addresses in the origin application, e.g. Word document, Excel spreadsheet or Outlook email

2. Copy all addresses using the correct keyboard combination (often Ctrl-c)

3. In RouteXL, press the Import button

4. Select the textarea and paste the addresses (often Ctrl-v)

5. Press the Import button

6. Wait until all addresses have been added

Notes

  • Each address should be on one line.
  • If there are problems, a message will be displayed after all addresses have been handled.
  • The import dialog accepts coordinates and JSON too. Coordinates must be in the format <lat>,<lng> and have a precision of at least 4 decimal places. Coordinates can be combined with additional fields.

Additional fields

With the address you can also import names, service times, time windows and comments. These additional fields will be stripped from the input before geocoding and added to the location on the map.

  • Names between @ and @
  • Service times in minutes between ( and )
  • Ready and due time as hh:mm before and after >>
  • Comments between { and }
  • Demand for capacity as number between ^ and ^
  • Heading (angle of approach) in degrees between * and *

Example

Kennemerstraatweg 464, 1851 NG Heiloo, The Netherlands @Our office@ (15) 09:00>>17:00 {Use the main entrance}

WEBFLEET

If you have a WEBFLEET account a button is added to allow import of orders from the WEBFLEET platform.