Difference between revisions of "Import"

From RouteXL
Jump to: navigation, search
(Additional fields)
m (Example)
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
The Import button is a powerful tool to add multiple destination addresses at once. You can copy addresses in any application and paste those in the Import textarea.
+
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.
  
=== Instructions ===
+
[[File:Import_dialog.png]]
  
1. Select the addresses in the origin application, e.g. Word, Excel or Outlook
+
== 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)
 
2. Copy all addresses using the correct keyboard combination (often Ctrl-c)
Line 17: Line 19:
 
=== Notes ===
 
=== Notes ===
  
* Each address should be on one line.
+
* Each single address should be on one single line. If an address is broken in several lines, each single line will be processed individually, resulting in multiple same destinations on the map and/or import errors.
  
* 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. If you only import partial addresses, e.g. postcodes, you may get several warnings that addresses were not precise. To preven this warning, deselect the address precise check in the [[options]].
  
* If there are problems, a message will be displayed after all addresses have been handled.
+
* If locations are not found, make sure to use the correct [[Address format]] or select another [[Geocoding]] service.
  
=== Advantages ===
+
* The import dialog accepts coordinates. 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.
  
Adding destinations via the [[Import]] tool has several advantages. Obviously, you won't need to enter each address in the search box one by one, which saves time. But next to that, placing the addresses on the map is also faster. Instead of sending each address to a [[Geocoding]] service, the route planners database is checked first.
+
* The import dialog accepts JSON too, but the format must match the [[API]] locations array. If you are using the API this is a great way to check the results.
  
 
== Additional fields ==
 
== Additional fields ==
  
You can also import names, time windows and comments with an address. These fields will be stripped from the input before [[geocoding]] and added to the location on the map.
+
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 @
 
* Names between @ and @
  
* Ready and due time before and after >>
+
* Service times in minutes between ( and )
 +
 
 +
* Ready and due time as hh:mm before and after >>
  
 
* Comments between { and }
 
* Comments between { and }
 +
 +
* Demand for [[Multiple rounds|capacity]] as number between ^ and ^
 +
 +
* Heading (angle of approach) in degrees between * and *
  
 
=== Example ===
 
=== Example ===
  
''Kennemerstraatweg 464, 1851 NG Heiloo, The Netherlands @Our office@ 09:00>>17:00 {Use the main entrance}''
+
''Kennemerstraatweg 464, 1851 NG Heiloo, The Netherlands @RouteXL headquarters@ (15) 14:00>>18:00 {Use the main entrance, leave the package at the front desk}''
  
 
== WEBFLEET ==
 
== WEBFLEET ==
  
If you have a [[WEBFLEET]] account a button is added to allow import of WEBFLEET orders.
+
If you have a [[WEBFLEET]] account a button is added to allow import of orders from the WEBFLEET platform.

Latest revision as of 14:24, 11 June 2020

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 single address should be on one single line. If an address is broken in several lines, each single line will be processed individually, resulting in multiple same destinations on the map and/or import errors.
  • If there are problems, a message will be displayed after all addresses have been handled. If you only import partial addresses, e.g. postcodes, you may get several warnings that addresses were not precise. To preven this warning, deselect the address precise check in the options.
  • The import dialog accepts coordinates. 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 JSON too, but the format must match the API locations array. If you are using the API this is a great way to check the results.

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 @RouteXL headquarters@ (15) 14:00>>18:00 {Use the main entrance, leave the package at the front desk}

WEBFLEET

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