My import failed. What do I have to do?
access_time 5 MIN | fiber_manual_record INTERMEDIATE | label DATA IMPORT FAILED, FAILED IMPORT, IMPORT ERROR
Importing data and trying to turn data (like an excel/csv) into a map is a difficult process. The problems that may occur during an import process depend on the type of import you want to do. Do you want to import a dataset (shapefile, geoJSON, csv/excel WITH a geometry, KML etc.)? Or do you want to import a csv/excel WITHOUT a geometry and do you want the Spotzi Geocoder to add a geometry to your data to plot the data on the map? Both cases need another approach:
Do you want to import a dataset (shapefile, geoJSON, csv/excel WITH a geometry, KML etc.)?
If you want to import a dataset with a geometry and your import fails. Then perhaps some of the following tips might help:
- Are you trying to upload a zipped shapefile and do you get a decompression error? Try to compress your zip file again.
- A zipped shapefile should contain at least a .shp, .shx and .dbf file.
- Have you tried to import a KML without a style ID.
- A KML can also include a link to another KML with the data. To solve this, you have to extract the URL from this KML and try to import it.
- We can only import GeoJSON formated JSON files. See if the source of this data supports GeoJSON or another file format for download.
- Our system can be unable to detect the encoding or projection of a shapefile. Try converting the file to UTF-8 and a 4326 SRID.
- Are you trying to upload quite a large dataset? Then perhaps the dataset is too big. Try to split the dataset into smaller parts. A big file may also cause an import time out.
- Make sure your zipped shapefile doesn’t contain an ogc_fid field. This is a reserved column name that isn’t supported by the Spotzi Mapbuilder.
- The Spotzi Mapbuilder does not support imports of Excel/CSV files with more than 250 columns.
- Spotzi supports (Shapefiles, XML, XLS(X), CSV, GeoJSON, KML). Got another file format, please contact us.
Do you want to import a csv/excel WITHOUT a geometry and do you want the Spotzi Geocoder to add a geometry to your data to plot the data on the map?
If you want to import a csv/excel without a geometry (geocoder) and your import fails. Then perhaps some of the following tips might help:
- Are you trying to geocode a csv/excel with a large amount of rows? Then perhaps the geocoding process timed out. Try to make this list smaller and try to upload this dataset again.
- The XLS/XLSX archive could not be opened or contains data that cannot be imported. Try exporting it into csv and uploading the csv instead.
- In some cases, it might help to save your CSV as CSV (MS-DOS).
- Do you have a some hidden fields in your excel? This also might cause some issues with the importing process.
- Do you have an Excel with multiple tabs? Keep in mind that the Spotzi Geocoder only geocodes the data from the first tab.
- Make sure that the table headers in your CSV/Excel does not contain special characters (%, &, @) or numbers. Using text-only table headers might help to make the geocoding of your CSV/Excel work.
- Make sure that the first row contains the right headers, so the Spotzi Geocoder knows which fields contain the right information. For more information about how this geocoding process works, please visit our page about importing location data.
- Got a file with just ZIP codes? Add an extra country column to your Excel/CSV. This country column gives the Spotzi Geocoder more information and gives better geocoding results.
Check the documentation about importing addresses and data here.