CSV Importer Geocoder Exporter XML Exporter - Revision history

Admin: How to use v4.0 and later

2018-11-30T15:58:02Z

How to use v4.0 and later

Admin: /* 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 */

2017-04-24T21:45:08Z

‎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

Admin: /* Installation */

2017-04-24T21:27:07Z

‎Installation

Admin: /* How to prepare your CSV file */

2015-06-16T18:43:57Z

‎How to prepare your CSV file

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

2015-06-16T18:41:33Z

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

Admin: /* How to prepare your CSV file */

2015-06-16T18:34:42Z

‎How to prepare your CSV file

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

2015-05-03T15:49:08Z

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

Admin: /* 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 */

2015-01-22T18:40:18Z

‎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

Admin: /* 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 */

2015-01-22T18:39:36Z

‎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

Admin: /* 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 */

2014-10-20T15:34:25Z

‎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

← Older revision		Revision as of 21:45, 24 April 2017
Line 70:		Line 70:

	=== 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 ===		=== 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 ===
		+
		+	'''(Note: This issue was resolved in CSV Importer/Exporter v1.5 & [[CSV_Importer_Exporter_G2\|CSV Importer/Exporter G2]] v1.5 (both released Feb. 27, 2016), so if you've purchased after this date or updated to v1.5+ for either addon, you shouldn't encounter this issue)'''

	Click the "Dashboard" tab in your Store Locator's admin area (Store Locator v2.0+), and click the 'Server Capabilities' link --- what version of PHP are you on? If it's greater than or equal to PHP v5.3.9 and your web host uses cPanel (or at least isn't GoDaddy) ...		Click the "Dashboard" tab in your Store Locator's admin area (Store Locator v2.0+), and click the 'Server Capabilities' link --- what version of PHP are you on? If it's greater than or equal to PHP v5.3.9 and your web host uses cPanel (or at least isn't GoDaddy) ...

@@ Line 1: / Line 1: @@
 == Installation ==
-===How to use (before version 1.2.37)===
+===How to use (before Store Locator v1.2.37)===
 # Put this directory into '''/wp-content/plugins/store-locator/addons/''' folder
 # Activate license on the 'News & Upgrades' page of the 'wp-admin' interface
-===How to use (version 1.2.37 - 1.9.7)===
+===How to use (Store Locator v1.2.37 - 1.9.7)===
 # Put this directory into '''/wp-content/uploads/sl-uploads/addons/''' folder
@@ Line 13: / Line 13: @@
 (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 in the updating process the plugin)
-===How to use (version 2.0 and later)===
+===How to use (Store Locator v2.0 and later)===
 # Put this directory into '''/wp-content/uploads/sl-uploads/addons/''' folder

← Older revision		Revision as of 18:43, 16 June 2015
Line 23:		Line 23:

	# 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)".
−	# Step #1 above should be sufficient. However, if you happen to still have distorted columns after Step #1, [~~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	+	# Step #1 above should be sufficient. However, if you happen to still have distorted columns after Step #1, [[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

@@ Line 53: / Line 53: @@
 === 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:
@@ Line 62: / Line 64: @@
 # Replace all apostrophes (') with it's character entity (&amp;#39;) or with nothing ()
 # Replace all colons (:) with it's character entity (&amp;#58;)
-# Replace all hyphens (-) with it's character entity (&amp;#46;)
+# Replace all hyphens (-) with it's character entity (&amp;#45;)
 # Perform the import again, and you should get clean columns now

← Older revision		Revision as of 18:34, 16 June 2015
Line 23:		Line 23:

	# 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)".
−	# [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	+	# Step #1 above should be sufficient. However, if you happen to still have distorted columns after Step #1, [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

@@ Line 38: / Line 38: @@
 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.
+However, It appears that there is a limit of 2,500 (since Google Maps V3) <s>15,000</s> geocodes per day per IP address, according to Google, so that's the main constraint to consider.
-'''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.
+'''Suggestion #1:''' 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 ===

@@ Line 65: / Line 65: @@
 === 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 ===
-<div style='padding-left:45px'>Click the "Dashboard" tab in your Store Locator's admin area (Store Locator v2.0+), and click the 'Server Capabilities' link --- what version of PHP are you on? If it's greater than or equal to PHP v5.3.9 and your web host uses cPanel (or at least isn't GoDaddy) ...
+Click the "Dashboard" tab in your Store Locator's admin area (Store Locator v2.0+), and click the 'Server Capabilities' link --- what version of PHP are you on? If it's greater than or equal to PHP v5.3.9 and your web host uses cPanel (or at least isn't GoDaddy) ...
 a) Add the following to the 'php.ini' file in your website's root directory, '/public_html/' (or create the 'php.ini' file if it doesn't exist):<br>
@@ Line 79: / Line 79: @@
 '''</Files>'''
-PHP 5.3.9 created a restriction on the max array size that can be handled in PHP to a default of 1000 array elements (city, state, zip, etc) (Ref. #1: http://stackoverflow.com/questions/9807100/post-max-array-size | Ref. #2: http://anothersysadmin.wordpress.com/2012/02/16/php-5-3-max_input_vars-and-big-forms/).  When importing many locations, you usually need a lot more than 1000, so the above steps increases your limit to 50000 array elements --- so you should now be able to do your imports. Alternatively, you would just need to break up your big CSV import file into smaller approx 9KB files [~1000 array elements]</div>
+PHP 5.3.9 created a restriction on the max array size that can be handled in PHP to a default of 1000 array elements (city, state, zip, etc) (Ref. #1: http://stackoverflow.com/questions/9807100/post-max-array-size | Ref. #2: http://anothersysadmin.wordpress.com/2012/02/16/php-5-3-max_input_vars-and-big-forms/).  When importing many locations, you usually need a lot more than 1000, so the above steps increases your limit to 50000 array elements --- so you should now be able to do your imports. Alternatively, you would just need to break up your big CSV import file into smaller approx 9KB files [~1000 array elements]
 === I'm receiving a "404 File Not Found" / "404 Page Not Found" error message on export ===

@@ Line 66: / Line 66: @@
 . '''Most likely solution:'''
-<div style='padding-left:45px'>Go to your pull-out admin dashboard (Store Locator v2.0+), and click the 'Server Properties' link --- what version of PHP are you on? If it's greater than or equal to PHP v5.3.9 and your web host uses cPanel (or at least isn't GoDaddy) ...
+<div style='padding-left:45px'>Click the "Dashboard" tab in your Store Locator's admin area (Store Locator v2.0+), and click the 'Server Capabilities' link --- what version of PHP are you on? If it's greater than or equal to PHP v5.3.9 and your web host uses cPanel (or at least isn't GoDaddy) ...
 a) Add the following to the 'php.ini' file in your website's root directory, '/public_html/' (or create the 'php.ini' file if it doesn't exist):<br>