Import Listings

This topic contains 3 replies, has 2 voices, and was last updated by Paolo 7 years, 9 months ago.

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

Open Support Ticket

Author

Posts
May 31, 2017 at 1:56 pm #380945

John Marston
Full Member

Post count: 170

Testing this several times and cant get listings to import

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

I open the exported .csv in open office calc and save as .csv because I don’t own MS Excel. The character set is utf8 and language is default English USA. Is open office reformating the csv?

May 31, 2017 at 5:10 pm #380999

Paolo
Site Admin

Post count: 31211

Hi,

Are you importing them for the 1st time or are you trying to edit them? Because I see the post_id and that should only be there if you are editing.

Please attached the CSV file and we will have a look at it.

Thanks

May 31, 2017 at 5:36 pm #381006

John Marston
Full Member

Post count: 170

This reply has been marked as private.

May 31, 2017 at 5:48 pm #381013

Paolo
Site Admin

Post count: 31211

Hi,

the file is not formatted correctly, you are using tab as separator instead of comma.

You need to open the file and save it with the correct separators. Please see: https://wpgeodirectory.com/support/topic/bulk-csv-importer-now-working/#post-131913

If you tell the system to skip listings with ID it will skip them, but it’d be better if you removed them, it will speed up the import.

Thanks
Author

Posts

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

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

Open Support Ticket