When an import fails, the side panel will display the following message: "Data could not be imported because it did not meet the minimum import requirements." Failure is defined as 0 records able to be imported from the source CSV file. Failure can occur for any of the following reasons:
-
All records failed validation
-
All records failed to be geocoded
-
Some records failed validation and the rest failed to be geocoded
Validation Failures
Records can fail validation for different reasons depending on the import type.
If the type of import chosen was "Upload CSV," records can fail validation for the following reasons:
-
Missing person id
-
Missing first name and last name
If the type of import chosen was "Address" which can be used for hotspot, records can fail validation for the following reasons:
-
Missing City, Street Name, and Street Number (if no latitude/longitude is provided)
-
Missing City and Street Name (if latitude/longitude is provided)
Geocoding Failures
Records can fail geocoding for the following reasons:
-
Not enough address information was provided to associate it with a latitude/longitude
-
The address information provided was misspelled or otherwise incorrect and does not actually exist
-
Google does not have data on the provided address (more common in extremely rural areas)
Archive a Failed Import
Click the down arrow at the end of the failed import row to archive it.
To resolve the causes of import errors, follow these steps:
-
If an import fails, click on it to open the right side panel which contains additional information.
-
Under "Import Summary" in the right side panel, expand the line that contains "Total Records Failed."
-
Download the link(s) with the text "View Details" next to the invalid records count and/or the geocoding errors count.
-
Open the file(s) in a CSV viewer (such as Microsoft Excel or Google Sheets) and correct the validation errors and/or geocoding failures.
-
Re-import the corrected CSV file(s).