[pa]

NOW I can suddenly reply in this thread… wth.

And do NOT manually add commas and quotes to fields. I do not know where in documentation you see add quotes and commas.

I never said I manually added any commas. In the documentation it clearly states: “Export to a CSV format. Comma delimited not tab delimited and quoted strings if given the option.“. This is what I said I did.

We always suggest using Google sheets and download as csv file format, it will put the commas etc in for you. Do not try to create your own csv file.

Where are you getting this “manually” from? I never said I did any of that. I said I used Open Office and ticked in “use commas” and “quote all text strings”. Like it says to do.

upload your Open office file to Google Sheets
Open it and look at the data.

Is it clean? No special characters in the fields? No quotes or rogue commas that shouldn’t be there?

The file is fine. Export from Google sheets yields a file identical to the one I uploaded. I checked with DiffMerge.

could you tell us how many locations you are importing.

191 locations.

Like I said before, the downgrade to previous version made the import work perfectly, so obviously there is SOME difference to the import process.

Paul, we really need to see your SLP Plugin environment, it will show us versions, including which version of WP you are using, PHP, SQL… cannot troubleshoot properly without that information. WP version changed so lance had to write two separate codes , one to work with pre WP 4.8.3 and one to work with WP 4.9 and higher

Who’s Paul? 🙂
My name is Patrik.

Here’s the environment currently:

Store Locator Plus:4.8.7
Power:4.8.6
Site URL:https://www.————-.com
This Info Cached:1513256284
Network Active:No
WordPress Version:4.9
PHP Version:5.6.32
MySQL Version:5.5.5
PHP Limit:256M
WordPress General Limit:256M
WordPress Admin Limit:256M
PHP Peak RAM:53 MB
PHP Post Max Size:8M

[pa]

For the time being, I have opted to revert to an old version and the import worked flawlessly.

[pa]

Hello,

I know that Excel produces some weird results, which is why I don’t use it 🙂
I used OpenOffice and made sure to “quote all text within cells” and use comma for separation, just like the documentation says to.
I used an identical file for import before upgrading to the latest version and that worked great.

How do I get rid of the old (failed) imports?

[pa]

This is the data in the media file btw:

Data Type: location_csv
Status: Being processed.
Next process time: Thu, 14 Dec 17 13:00:31 +0000
Last Processed Record: 0
Reading Offset: 0

And this is AFTER I set the entire wp-content/ directory to 777. Should be sufficient. And wp-cron is running.

[pa]

Further testing shows… the error persists, but now with an https:// URL instead.

And I can’t find any sources saying that the CA files are bad, and the LE certs generated all check out.

*sigh*

[pa]

I have found the error. And it’s beyond stupid (on my part).

After transferring the site to it’s new server and away from the dev-environment, I had to change the URL. The easiest way to do that is to use update_option( 'siteurl', '...' ) and update_option( 'home', '...' );
Since the site hadn’t been moved DNS wise and therefore had no SSL cert yet, I set it to http.
Later on when I changed the url to https in the settings, I failed to realize that it switched back immediately because of the update_option()’s.

Oops.

This was a while ago, btw. I have since started simply editing these values directly in the database when I need to.

[pa]

The URL checks out, no 404 here. (I already checked that obviously…)

I was unaware of this SSL debacle. I’ll look into it as soon as I can figure out how to update those files 🙂

[pa]

It’s newly issued Let’s Encrypt. I mean, it should be fine, I think. The checkmark is green so I doubt my browser dislikes it.

[pa]

The file was located in the Media Library. I removed it after I reverted back to the previous version and I dindn’t think to check anything called “offset”. However the file had been there for several hours at that time, and no locations had been added at that time.

Afaik WP Cron should be running just fine.

[pa]

Update: I reverted to the previous version, and now it works just fine.

[pa]

I am getting this too, but on a Mac.

MACHINE NAME:project_slp patrik$ unzip slp-power.zip
Archive:  slp-power.zip
End-of-central-directory signature not found.  Either this file is not a zipfile, or it constitutes one disk of a multi-part archive.  In the latter case the central directory and zipfile comment will be found on
the last disk(s) of this archive.

unzip:  cannot find zipfile directory in one of slp-power.zip or slp-power.zip.zip, and cannot find slp-power.zip.ZIP, period.

In short; the zip-file is broken.

[Author]

Posts