Problem importing the " character

💬 General Discussion
1

I am trying to import data from a CSV that uses the “ character as a shorthand for inches. However the imported data appears in Suitecrm as an & and not the expected “. How can I fix this?

2

3

Solved it. I imported the character as “““. Sure enough it appeared in Suitecrm as &&&. I then exported the database, replaced &&& with “, and reloaded database. It works fine.

4

Hello Rufus,

probably too late now …
Next time, you can use different delimiter and field separator.
LibreOffice can produce the right output and you can then configure details during your import in Suite:

image
image2842×569 56.3 KB