Import CSV-file not working – despite debug
This topic contains 8 replies, has 3 voices, and was last updated by Guust 7 years, 3 months ago.
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket-
AuthorPosts
-
September 16, 2018 at 11:30 am #446621
Hello.
I am trying to import a csv-file with listings (CPT:Brautmode) the system keeps on telling me that none of the listings could be imported due to
a) missing title or unvalid CPT
and
b) unvalid address (address,city,region …)What I have done so far to find the error:
– I have created listings from the front end
– then exported these listings into a csv-file and saved it with Open Office -> UTF 8, German language, comma seperated
– on the basis of this exported csv-file I created the csv-file with all listings to be imported, providing all mandatory data just as provided from the exported csv.
– made sure the csv-file imported has exactly the same structure as the csv-file I had exported before, including all latitude/longitude information in the required format (55.5453453436, 10.45353534)
– installed the wp debugging as recommended in the trouble shooting, however the debug.log comes up with exactly the same information as already provided (see above).And I just do not see what the problem is, because all address data, title and cpt seem to be correct.
However, when I export the listings created in the front end, save the csv-file as recommended (Open Office, UTF 8, comma seperated …) and try to import exactly this file without making any changes, this also does not work. Again for the reasons above, even though – as far as I can see – all required information and columns are provided.
Any idea, what might be the problem?
Many thanks
BirgitSeptember 16, 2018 at 11:43 am #446623What happens if you just export and then re-import, without changing any CSV settings?
So do not “save as” but just use the file as exported.Please post URL and WP admin details in a private reply if we need to look at anything.
You can also add your CSV file you are trying to import.Thanks
September 16, 2018 at 12:09 pm #446628This reply has been marked as private.September 16, 2018 at 12:21 pm #446632You changed the column name of the first column, that should be post_id
Can you check that and let us know.
ThanksSeptember 16, 2018 at 3:49 pm #446640Hi Guust,
hm… well, the name of the first column in the attached csv is post_id
Or what do you mean what I have changed?Many thanks
BirgitSeptember 16, 2018 at 10:47 pm #446660Oops, my mistake, I was looking at the wrong thing.
I now have downloaded the CSV for that CPT and reimported it without any problem as I downloaded it.
SO there must be a mistake in the data you enter or the way you save the file.I’ll get someone else to have a look too.
You also have an error in your SSL certificate, see https://www.ssl247.com/kb/ssl-certificates/troubleshooting/apache/ssl-error-rx-record-too-long-firefox-apache-tomcat
Your site does not open in Chrome or Firefox, only in Internet Explorer.
Thanks
September 17, 2018 at 6:57 am #446689This reply has been marked as private.September 18, 2018 at 5:58 pm #446873Hi Kiran,
many thanks, it was a setting in Open Office. Import works now.
Regarding the SSL Error: I have contacted my host but we could not reproduce this mistake. We will keep our eyes open, thank you for this hint.Best regards
BirgitSeptember 18, 2018 at 9:55 pm #446896This is the error in your SSL certificate, see https://www.ssl247.com/kb/ssl-certificates/troubleshooting/apache/ssl-error-rx-record-too-long-firefox-apache-tomcat
Thanks
-
AuthorPosts
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket