Import issue

This topic contains 3 replies, has 3 voices, and was last updated by Kor 6 years, 7 months ago.

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

Open Support Ticket

Tagged: import

Author

Posts
April 12, 2018 at 2:21 pm #426264

shanker
Full Member

Post count: 31

Hello,

When i try to do a test import of 5 items, i’m getting the following issue

///

Total 48 item(s) found ???.

48 / 48 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).

48 / 48 item(s) could not be added due to blank title/invalid post type/invalid characters used in data.

///

Find below the csv file i use.

Thank you for your help

April 12, 2018 at 2:22 pm #426265

shanker
Full Member

Post count: 31

This reply has been marked as private.

April 12, 2018 at 3:46 pm #426274

Paolo
Site Admin

Post count: 31206

hi,

you are saving the file with wrong delimiters.

If I open the file with the correct settings (comma and double quotes) data is all mixed up. (see image capture.jpg)

If I open the file with wrong settings (semicolon and double quotes) data is almost correct. (see image capture1.jpg)

I say almost because there are still wrong characters (letter with accents pasted with wrong collation visible in capture1.jpg).

To correct delimiters pls see: https://wpgeodirectory.com/support/topic/bulk-csv-importer-now-working/#post-131913

To correct special characters you can use the search and replace tool.

Hope this helps.

Let us know,

April 12, 2018 at 3:46 pm #426277

Kor
Moderator

Post count: 16516

This reply has been marked as private.
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

Hurry! Get your 20% discount before it expires. Get 20% Discount