Difference between revisions of "CSV Importer Geocoder Exporter XML Exporter"

From Documentation | Viadat Creations
Jump to: navigation, search
(Installation)
Line 1: Line 1:
 
== Installation ==
 
== Installation ==
  
'''To use (before version 1.2.37):'''
+
'''How to use (before version 1.2.37):'''
  
 
# Put this directory into '''/wp-content/plugins/store-locator/addons/''' folder
 
# Put this directory into '''/wp-content/plugins/store-locator/addons/''' folder
 
# Activate license on the 'News & Upgrades' page of the 'wp-admin' interface
 
# Activate license on the 'News & Upgrades' page of the 'wp-admin' interface
  
'''To use (version 1.2.37 and later):'''
+
'''How to use (version 1.2.37 and later):'''
  
 
# Put this directory into '''/wp-content/uploads/sl-uploads/addons/''' folder
 
# Put this directory into '''/wp-content/uploads/sl-uploads/addons/''' folder
Line 16: Line 16:
  
 
# Make sure to save your file in "Windows Comma Separated" format instead of "Common Format CSV" (for more recent versions of Microsoft Excel).  In older versions of Excel, pick the option of "CSV (Comma delimited)".
 
# Make sure to save your file in "Windows Comma Separated" format instead of "Common Format CSV" (for more recent versions of Microsoft Excel).  In older versions of Excel, pick the option of "CSV (Comma delimited)".
# Follow [http://docs.viadat.com/CSV_Importer_Geocoder_Exporter_XML_Exporter#It_seems_that_my_columns_are_all_out_of_place_and_distorted_after_the_initial_step_of_the_CSV_import these steps] to avoid having distorted columns on import
+
# [http://docs.viadat.com/CSV_Importer_Geocoder_Exporter_XML_Exporter#It_seems_that_my_columns_are_all_out_of_place_and_distorted_after_the_initial_step_of_the_CSV_import Follow these steps] to avoid having distorted columns on import
  
 +
'''What to set your FTP program to:'''
 +
 +
# [http://docs.viadat.com/CSV_Importer_Geocoder_Exporter_XML_Exporter#I.27m_getting_a_.22fatal_error.22_message_after_uploading_the_folder._Why_is_that.3F Follow this step] to avoid a "fatal error" message or a blank screen (when PHP error reporting on your server is turned off)
  
 
== Screenshots ==
 
== Screenshots ==

Revision as of 18:56, 5 June 2010

Installation

How 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

How 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)

How to prepare your CSV file:

  1. Make sure to save your file in "Windows Comma Separated" format instead of "Common Format CSV" (for more recent versions of Microsoft Excel). In older versions of Excel, pick the option of "CSV (Comma delimited)".
  2. Follow these steps to avoid having distorted columns on import

What to set your FTP program to:

  1. Follow this step to avoid a "fatal error" message or a blank screen (when PHP error reporting on your server is turned off)

Screenshots

Export Links & Import Form

caption

Import Steps

caption


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?

No, the best feature about this addon is that it allows you to match the columns in your CSV file to the fields (which are database columns) 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 steps below in the following 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

If you still receive distorted columns, even after the above steps, continue to search your CSV spreadsheet for any non-alphanumeric characters (anything that is not A-Z, a-z, or 0-9) and convert these non-alphanumeric characters into their proper entity symbols. A good place to search for a specific entity symbol is Google.com.

When I try to upload a CSV file, nothing happens, I get no error message and remain on the "Add Locations" page, or I get a blank screen

  1. chmod the '/store-locator/' folder to 775
  2. Or perform Step #3 here
  3. Other Troubleshooting Steps You Can Take:
      • Make sure your '/tmp/' folder is writeable
      • Also, to debug, in 'add-locations.php' you can add the line:

        print_r($_FILES);

        before the line:

        if (move_uploaded_file($_FILES['csv_import']['tmp_name'], "$newfile")) {

        if you see "[error] => 0″ in the array, then the upload is occuring properly, and it has something to do with your server, otherwise, you can find information are uploaded files error codes here: http://www.php.net/manual/en/features.file-upload.errors.php

      • Add the line "define('WP_DEBUG', true);" to the "wp-config.php" file in your WordPress root directory (this may provide additional error messages, details as to what may be occuring. Make sure to comment out this line after you have finished debugging).

I'm receiving a "404 File Not Found" / "404 Page Not Found" error message on export

Option 1:

In your store-locator/mgmt-buttons-links.php file …


… Copy & paste the following line:

$sl_real_base=$sl_base; $sl_base=$sl_upload_base;


… Before this line (approx line 9):

include($sl_upload_path."/addons/csv-xml-importer-exporter/export-links.php")


… then, after the above line (line 9), copy & paste:

$sl_base=$sl_real_base;


Option 2:

Undo the coding changes in Option 1, then copy & paste the CSV Importer folder from the "uploads/sl-uploads/addons/" folder to the "plugins/store-locator/addons/" folder so that you have it in 2 places


(Note: it appears that this affects versions 1.2.37 - 1.2.39.3, so should be fixed by the next version after 1.2.39.3)