CSV Importer Geocoder Exporter XML Exporter

From Documentation | Viadat Creations
Revision as of 00:12, 30 March 2010 by Admin (talk | contribs) (After uploading my addon files to the "addons/" folder, I'm not seeing the option to activate it on the "News & Upgrades" page)
Jump to: navigation, search

Installation

To use (before version 1.2.37):

  1. Put this directory into /wp-content/plugins/store-locator/addons/ folder
  2. Activate license on the 'News & Upgrades' page of the 'wp-admin' interface

To use (version 1.2.37 and later):

  1. Put this directory into /wp-content/uploads/sl-uploads/addons/ folder
  2. Activate license on the 'News & Upgrades' page of the 'wp-admin' interface

(This change in version 1.2.37 in the location of where you place addon folders allows you to update your main Store Locator plugin without worrying about losing your addons when updating process)

Frequently Asked Questions

Note: Before asking any questions, please be sure that you've read through and followed all the steps on the Upgrade Purchase Tips page.

Do I need to arrange the columns in my CSV file in any special order?

Nope! The best feature about this addon is that it allows you to match the columns in your CSV file to the fields in the store locator database

I need to upload thousands of locations, what's the limit of your CSV importer?

There is no limit specifically with the CSV importer's capabilities.

However, It appears that there is a limit of 15,000 geocodes per day per IP address, according to Google, so that's the main constraint to consider --- usually 15,000 is plenty for most people.

Suggestion: Consider breaking up your CSV file into smaller chunks of locations, and do your import in pieces. The speed and settings of your server may also sometimes affect how many locations can be handled at once.

After uploading my addon files to the "addons/" folder, I'm not seeing the option to activate it on the "News & Upgrades" page

When you extract you addon folder (e.g. "csv-xml-importer-exporter/") from your zip file, make sure that you upload the entire extracted folder and its contents to the "addons/" folder, not just the files. Your directory structure should look like this: "addons/csv-xml-importer-exporter/"

For details on where the proper "addons/" folder is for your version go here: http://docs.viadat.com/CSV_Importer_Geocoder_Exporter_XML_Exporter#Installation

I'm getting a "fatal error" message after uploading the folder. Why is that?

Make sure to upload the 'csv-xml-importer-exporter/' folder into your 'addons/' folder in 'binary' mode instead of 'auto' or 'ASCII' mode with your FTP program

It seems that my columns are all out of place and distorted after the initial step of the CSV import

This simply happens due to having symbols (&,#,", etc.) in your CSV file. Do the following:

  1. Open your CSV file and do a 'Find and Replace' (press Ctrl + H) … Then perform these following steps below in exactly this order …
  2. Replace all ampersand (&) symbols with it's character entity (&)
  3. Replace all pound (#) symbols with it's character entity (#)
  4. Replace all commas (,) with it's character entity (,) or with nothing ()
  5. Replace all apostrophes (') with it's character entity (') or with nothing ()
  6. Replace all colons (:) with it's character entity (:)
  7. Replace all hyphens (-) with it's character entity (.)
  8. Perform the import again, and you should get clean columns now