Having issues with “import and geocode” and troubleshooting steps

Steps to troubleshoot.

Firstly, it could be the limit that you’re IP address or server IP address is having from geo-coding, you may need to wait or try from another IP address. Also refer to the Geo Coding limit article available here.

Next, try the sample csv (available for download at the import/export page or Download Sample CSV),  if the sample works, follow the next step to troubleshoot.


A. If sample CSV works

Edit your csv in Notepad++ instead of Excel/spreadsheet tool and make a comparison against the sample csv, you need to ensure that the format is the same i.e comma, quotes, etc

Notice: If you’re using Mac, you can also refer to this articles below:

TextEdit has separate plain text and rich text modes. You’ll have to select Format > Make Plain Text or set the default format to plain text first.

YA8O4

Reference link:

1) https://s2member.com/kb-article/how-do-i-save-the-importexport-csv-with-excel-on-mac-os-x/

2) https://discussions.apple.com/thread/4431147?tstart=0

Google Docs

Alternative Tool that works is Google Docs (https://docs.google.com)

B. If the sample CSV doesn’t work

Check the following with your server provider:

1. cURL library is turned on

2. /php/tmp folder on your server is writable

http://stackoverflow.com/questions/12531408/setting-php-tmp-dir-php-upload-not-working

3. Check with your hosting provider on max file upload size settings on your server

4. Check your addresses that are not successfully geocoded at http://www.latlong.net to see if the format is correct

 

7+

Users who have LIKED this post:

  • Sofia (Support Team)
  • avatar
  • avatar
  • avatar