I have run across an issue where unicode characters cause data fields to be truncated. For example, if I was importing a field called "Description", and one of the rows read "Check out our new Amazo® Product", only ""Check out our new Amazo" is imported from that field.

I have tested this with tab and comma delimited and got the same results. I think the issue is with unicode characters because I see it happening with trademarks, copyrights, etc, but not ampersands and other more basic characters.

Comments

froboy’s picture

froboy
he/him
Primary language English
Location Chicago, IL
commented

Check the encoding that the file is saved as. Is it encoded as "Unicode (UTF-8)" or something else like "Western". I also had issues until I changed the encoding to UTF-8, at which point my import proceeded fine.

twistor’s picture

twistor commented
Issue summary: View changes
Status: Active » Closed (outdated)