CSV Import Error

This topic contains 4 replies, has 3 voices, and was last updated by Paolo 8 years, 6 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Author

Posts
September 12, 2016 at 8:30 pm #265081

denniswork89120
Expired Member

Post count: 17

Hi,

We’ve created a CSV with Open Office and are still getting error messages when trying to import:

Total 815 item(s) found.
815 / 815 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).
1 / 815 item(s) could not be added due to blank title/invalid post type/invalid characters used in data.

September 13, 2016 at 1:11 pm #265374

Guust
Moderator

Post count: 29970

Can you post a Zipped CSV file here and also your URL and WP admin details so we can investigate (in a private reply). Thanks.

September 13, 2016 at 1:11 pm #265375

Guust
Moderator

Post count: 29970

Can you post a Zipped CSV file here and also your URL and WP admin details so we can investigate (in a private reply). Thanks.

September 13, 2016 at 5:11 pm #265555

denniswork89120
Expired Member

Post count: 17

This reply has been marked as private.

September 13, 2016 at 6:33 pm #265621

Paolo
Site Admin

Post count: 31211

Please correct row 409 of that file. The heading of the CSV file has been copied in it multiple times.
I would also avoid to enter the city names all caps, but I’m not sure that would cause the import to fail.
Let us know if that was it.

Thanks
Author

Posts

Viewing 5 posts - 1 through 5 (of 5 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket