Import & Synchronization

How to import external data into Nearest!

Import

The initial task of synchronizing your data source with the Nearest! platform is called import.

Adding data

When importing data into the Nearest! platform all locations found in your data source which could be geocoded (or reverse geocoded) will be added to your data set.

Duplicates

After initially importing your data we automatically looking for duplicate locations. Lern more about de-duplication in the data-quality section.

Synchronization

After your initial import you can synchronize your location data with external sources such as Google Spreadsheets or API endpoints.

Synchronizing your data is only available if your locations have a unique id or field where we can identify it in external sources. > Learn more

Updating existing data

We check if the address information of your location has changed since the last synchronization or import. If so, we re-geocode that information otherwise we skip that task and leave the data as is. All other element information will be updated as found in the source. If the data of an existing element is missing, the data will be removed.

De-duplication

After synchronizing your data we automatically looking for duplicate locations. Lern more about de-duplication in the data-quality section.

Removing existing data

After synchronizing the data, we're checking if locations imported from that source in the Nearest! DB were missing in the actual synchronization task. If so the location will be set to deleted in the Nearest! DB.

Workflow

The steps of adding a new synchronization:

  1. Defining your data source (Google Docs, API or static file)

  2. Connect the source fields with your location elements

  3. Prepare the data before getting imported

  4. Select and configure the parser to transform your data

  5. Configure scheduled task for synchronization

  6. Analyze your data quality after synchronization