! Introduction - >> Video [9 min] (please watch first)
To display the corresponding help, click on the icon in the menu bar.
Scope of functions : P100-Addressvalidation
(Standard) features: (OSM (Openstreet Maps) + Google Web Search (no batch))
if you want to use the batch geocoding option of Google and/or BING, you will need an additional API key in each case.
- Trial version (max. 10 addresses, duration 1 month) - free of charge
- 3 month license - subscription, expires automatically if not renewed
- 1 year license - subscription, expires automatically if not renewed
You purchase an unlimited user license for one computer for the selected subscription period. Unrestricted, as long as you use
the addresses you edit exclusively for internal purposes. Selling or renting the addresses is prohibited and will result in the deactivation
of the program via our license server. In this case there will be no refund of the rental price. If you also want to use BING or Google for
batch geocoding besides OSM (OpenStreetMaps), you have to confirm their usage rights and purchase the respective API additionally.
The functionality of the program can change at any time (update) without prior notice.
Structure of the Excel table (Microsoft Excel 2013 and higher - 32 Bit)
The Excel table - must begin - in the first row with the column headings. All columns must be labelled.
The addresses must start sequentially from the 2nd line and blank lines are not allowed between start and end row.
Blank lines and blank columns outside the address block must be removed.
Optimum set up
The first two columns ( A + B) should contain a consecutive number (for example, SAP number) and the name (for example, company).
The columns ( C + D + E + F + G ) contain necessary address information, but these can be distributed in the Excel table as required.
Please note that the street name must comply with the house number and the country code is in ISO format (US - UK - DE - CH - UK).
The postcode should be complete, e.g. - 5 digits - for USA, Germany, France, Italy, - 4 digits - for Austria, Switzerland, Netherlands etc.
Further information is optional, e.g. telephone, e-mail, web address, sales, employees, imprint etc.
All addresses are checked for plausibility. For example, post boxes instead of street names, missing house numbers, missing postal codes or city names.
In this way, corrections can be made in the master data in advance.
Attention: The Excel table must not contain empty columns or missing column captions. The column captions must be made in the first table row.
All selected actions, e.g. Web Search, Batch Geocoding: - , refer to the entire Excel file.
Attention: The Excel table must not contain empty lines (inside and at the end).
All selected actions, e.g. Web Search, Batch Geocoding: - , refer to the selected rows.
Address search via OpenStreet Maps, BING Maps and Google Maps. Different views are applicable: Street, Satellite, Birds Eye.
Manual (move) adjustment of addresses. Internet (web search) for all address fields and their combinations.
(Almost) any number of address fields can be displayed, searched for and updated via Copy and Paste.
Selection for Batch search:
Default setting for the batch search.
The status FIlter shows the quality of the address data found.
: one or more filters are set for batch post-geocoding or web search.
The auto filter is switched on or off for all columns.
To compare the address requests and the results found (marked with *) directly, all columns that are - not address-relevant - are hidden.
You can copy the addresses found by OSM - BING - or Google to the original file (Excel). Incorrect spellings can thus be easily corrected.
Geocoded addresses can be displayed on an Internet web map, e.g. Google Earth. All or selected addresses.
The column assignment is the most important step after completion of the "settings".
Here you define the address-relevant fields as well as all Excel fields that are to be used for display, search and change.
Basic settings, such as default country or languages, Google or BING for web search and registration of Google or BING API keys can be done here.
Also which quality characteristics should be displayed, can be defined by selecting the respective fields.