Data import is normally a straight forward process, but if you've run into issues, it may well be one of the issues addressed below.

First, let's determine at what point in the import process did the issue arise:

  • Upload - once you've selected the file you want to import, but prior to assigning column headings
  • Processing - while you're assigning column headings
  • Reading - the first 30% of the import process after you've begun import. Ecanvasser is simply converting your to a format it can make sense of
  • Inserting - between 30 - 100% of the remaining import process. Ecanvasser is actively adding voters to your database
  • Geocoding - displaying your addresses on the Ecanvasser map

Upload

Is your file over 50mb:

  • If so, you might want to consider 'chopping' it into two separate files for processing

I uploaded my file, but in the next screen, the loading wheel continued to spin:

  • Is your voter file password protected - If so, remove this requirement prior to upload. 
  • Is your data stored in a table within the spreadsheet (commonly represented by the data being stored in rows of contrasting columns) - copy and paste the data to a new workbook, saving it as a .CSV, and then upload this file
  • Is your voter file quite large (maybe 100,000 voters with 100 data points)? Consider removing unnecessary data points prior to upload, and saving the document as a CSV in excel prior to upload (if it is currently an XLS/XLSX); or else breaking your file into two separate files for processing.

I uploaded my my file, but all the data is appearing in a single column

  • It sounds as if the file is actually a .TXT file, regardless of any other file type being referenced at the end of it's name. If you open your file in excel, you'll find you receive a warning indicating that your file may be corrupted. To resolve this, simply click to open the file, and then select File -> Save As, and choose to save it as a .CSV, while also removing any reference to .CSV/.XLSX/.XLS from the files name. This version of the file should now be good to upload.

Processing

All of my data is displaying in one column:

  • It sounds like you're data file is saved as a .TXT file (even it appears as an excel file on your desktop - open the file in excel and select to Save As, remove any reference to .XLS or similar from the end of the file name, and choose to save as a .CSV

When assigning address columns, I seem to have two different versions of this in my spreadsheet:

  • Different data vendors provide their data in different formats. For example, some might have Street as something as 'North Crescent Avenue', while another may have columns structured as: Street Direction: North, Street Name: Crescent, Street Type: Avenue - Ecanvasser provides flexibility for importing such varying files. Visit Formatting Your File for an exact outline

Reading

I reloaded the import page, and the estimate provided as to current progress is not displaying, or is displaying as 0%:

  • When you reload the import page, the estimate needs to be re-calculated, and this can take a minute or so - Sit tight and it will update!

Inserting

I reloaded the import page, and the estimate provided as to current progress is not displaying, or is displaying as 0%:

  • When you reload the import page, the estimate needs to be re-calculated, and this can take a minute or so - Sit tight and it will update!

The Import Status is indicating a Processing Error occurred

  • Something has gone wrong during the process whereby we write your voter file to your campaign. As a result, some of your voters may have already been written, and are present within your database - Click on your voter file to re-process it by assigning column headings again. Assign columns in the exact same manner as previous. If you data file does not contain a Voter ID, after your click Start Import, switch the import option from New to Merge to avoid duplicating those records already in your database.

Geocoding

I included Longitude and Latitude when importing, but all my Houses are displaying in the incorrect place on the map.

  • It sounds as if you may have mis-assigned the Long/Lat columns during import - Drop us a line via the chat function and we'll fix this for you!

My import has reached 100%, but my Houses aren't appearing on my Map page yet

  • If your file didn't contain long/lat, we have to translate the written address into long/lat - most files complete mapping in 6 - 24 hours, feel free to check in with us via chat for an estimate on your particular file.

My mapping has completed, but I'm not happy with some of the locations

  • We use Google Maps for our geocoding who are the market leaders in this area. As such, you'll get the best possible results for mapping by address, for your data. That said, if you would like to work with your data to improve the mapping process, you might want to consider Mastering Geocoding.
Did this answer your question?