Help with import !

[babybidou]

Hello,

I have seen many posts saying that import is a painful task in Sugar... agreed !

I managed to clean my CSV data and it is imported correctly... until I want to edit the data.
This seems incredible, but the accounts that I have imported are displayed correctly, but when I want to edit them, I see the edition form without any data except for the first character of the account name !!!

A quick look at MySql tables show that the 'accounts' table is filled correctly. So what went wrong ??

I have re-installed SugarCRM a second time but it behaves in the same way.

This only happens to imported data : accounts created in Sugar can be edited properly.

How can I fix this ?

Thanks !


Note : After checking the MySql databases again, I see that a manual input creates an entry in the `tracker` table, while importation does not. Is this the source of the problem ?

[cerhorn]

I've recently imported tens of thousands of records with no issues at all. Could you provide more detail on version of Sugar and the process you are following to import, what the records are like, etc.

[babybidou]

After many trials and investigations, I finally found the problem !!!

My CSV data was encoded in Unicode (2 bytes/character) : the second byte was 0x00, and apparently was understood as an end of string... It was displayed correctly, but bad for textual edition !

Maybe it could be interesting to have a note on this somewhere (or a check in the import script).

Thanks anyway for your feedback.
Have a good day !

[labanjohnson]

my god it must have taken a while to find that explanation, I wouldn't have known to look at the encoding of the file! I hope this thread helps some people in the future.

What encoding is working best, UTF-8?

[babybidou]

Indeed, I had to check the exported content of the database to find it !

UTF-8 works quite well, if you don't forget to set it correctly in the admin section !!!

My next request to the developers would be to have a button to cleanly empty the database when you import 100+ times in the same day !!

Thanks !