large imports Archives - Documentation

Import using WordPress Store Locator Plus Power add-on

Posted by cici in FAQ, for WordPress, Locations, Power Add On, Professional, Troubleshooting

This page /information does not apply to SLP SaaS. This information is provided for the SLP do it yourself plug-in only

WPSLP Power add-on uses the built-in file up-loader provided by WordPress Core instead of a custom file import script. Look in the Media Library in WordPress. Make sure your install has not disabled the default WordPress media up-loader.

NOTE: As of July 2018, if you are using the WPSLP “do it yourself” plugin with Power add-on and you have not included the latitude and longitude and require geocoding , make sure you have a Google API account and have checked off the Maps and Geocoding APIs in your library.

What to look for when importing

Do you see the CSV file you just imported? If not then your site has disabled the WordPress media uploader.

If your file IS in the media library but never gets past the offset “0” setting check to make sure your server has not disabled the WordPress Cron .

WP CRON can be found under Forms WP environment

Check to see if your server is preventing the wp-cron.php from being triggered.

Check your import file in the media library by clicking on it. It should show what the file size is and the current offset. The offset is where the background process is shown while importing the file. If it is shown as “zero” then your WordPress Uploads directory for the media library has been set to non-standard restricted access meaning the background location import process is not allowed to open the file after it was uploaded.

Click on the file to see the file size and meta data

Troubleshooting Large scale Exports/Imports

Posted by cici in FAQ, Locations, Our Add Ons, Power Add On, Professional, Troubleshooting

Issue: Exports/Imports Incomplete

Multiple large-scale exports (export function is available with Power Add-on ) have been tested on the Store Locator Plus dev sites. On a relatively small server, a virtual machine with 2GB RAM running CentOS 6, we have been able to export 10,000 locations within 15 minutes with no issues. Special characters and extended data have also exported without issue.

If you are experiencing issues there are several things to check that can cause problems during an export:

Web Server Process Limits

Apache, and nginx have per-process limits. This is built into the web server to prevent “runaway” processes that eat up all of the CPU and memory on the server over time. On shared servers this limit is very low and typically allows 30 seconds to 2 minutes of processing time. Large data sets can use up to 5 minutes or more of processing time. Make sure your server has a high enough limit to allow the entire data export to complete execution.

Importing Large Lists into WP Store Locator Plus

Posted by cici in Locations, Our Add Ons, Professional

Hints for the WordPress Store Locator Plus stand alone, self managed plugin with Power add-on. Import features available with the Power Add-on

Load Data

If checked , use the faster MySQL Load Data method of file processing. Only base plugin data can be loaded, see the approved field name list.

This feature uses the MySQL Load Data command and is much faster than WordPress / PHP CSV file parsing, with the typical Google Geocoding limitations on performance and record counts (if you are not supplying, filling in the latitude/longitude data fields). This feature will only import basic location data. It does not import extended data fields or category data. If you use this along with per-entered latitude and longitude values you can import 100,000 locations in less than 10 minutes on a basic web server. The column headers must be included in the file and must match the basic fields. You do NOT need to include all columns.