- This topic has 6 replies, 3 voices, and was last updated 10 years ago by
.
-
Posts
-
as title says.. I found that WP CSV to DB 2.0 is truncating the descriptions of my products. It has happen a couple times now.
When I export the table via myPHP the descriptions are not truncated.
our descriptions do contain nested divs and short code situations…. perhaps there is a character that breaks the data in csv to db?
Although come to think of it, it truncates descriptions that only contain text too.
How many characters (roughly) are we talking about for the description? I am just thinking that there maybe a limit on that.
actually the amount of text that is retained varies sometimes a few words sometimes most of a sentence up to two lines.
ah, taking a closer look, comparing the successful version to to the csv to db version, it appears that the first comma in the description is where the truncating occurs.
ah, taking a closer look, comparing the successful version to to the csv to db version, it appears that the first comma in the description is where the truncating occurs.
CSV = Comma-separated values
Try replacing the commas with —> & # 4 4 ; <— (ampersand pound four four semicolon) instead.
yep, not very “intuitive” for client though, who will write descriptions and have to use the code in place of commas in the writing. I’ll just use myPHP from now on for bulk work.
thanks.
Try the code anyway, to see if that fixes the problem. If it works, then it means the addon needs to sanitize the data some more.
- You must be logged in to reply to this topic.