Is there a list of known characters to remove before import?

This topic contains 2 replies, has 2 voices, and was last updated by Bob Randklev 8 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 27, 2016 at 4:58 pm #180143

Bob Randklev
Expired Member

Post count: 13

I tested my base list of 500 listings and the import worked great.

Next we started filling in columns like post_content and when we upload we get an error “87 items could not be uploaded due to blank title/invalid post type.”

With hundreds and eventually thousands of entires is there a list or excel function/command to remove all invalid characters before we upload.

There’s no way to know which ones failed so finding them means deleting and starting over or downloading and comparing..

just hoping someone has some tips to solve this

April 27, 2016 at 5:24 pm #180174

Paolo
Site Admin

Post count: 31206

Hi,

if the collation of the CSV file is correct, any charachter should be accepted, unless you are copying and pasting text from a file with a different collation.

We would need to look into the file that is giving you problem to tell you more.

Let us know,

Thanks

April 27, 2016 at 6:18 pm #180249

Bob Randklev
Expired Member

Post count: 13

It’s taking time but I’m finding special characters for things like trademark, registered mark, degree symbols that are copied from a website to csv.

It’s “hunt and peck” now but any ideas for cleaning a list would be great! 🙂 I’m re-looking at how we got the post content.
Author

Posts

Viewing 3 posts - 1 through 3 (of 3 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