Are you enjoying the extensions? Did you like the support? Help others decide.

Leave a review

file Import of contact data does not work

More
9 years 6 months ago #4230 by admin
Replied by admin on topic Import of contact data does not work
Hello Ruth,

The summary field was introduced with Trombinoscope Extended v2.2, it is not available in v2.1. That is probably why you cannot import the summary field into your contacts.
Olivier.
The following user(s) said Thank You: bsbad

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #4231 by bsbad
Replied by bsbad on topic Import of contact data does not work
Hello Olivier,

thanks for the quick answer. I try to get v2.2.

I face another problem with the character encoding of the data of the import file. My import file is utf8 without BOM, my database has the utf8-general-ci encoding. But after import the ö of the file is a Dö in the database.
I put an example import file in the attachement.
Attachments:

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #4232 by admin
Replied by admin on topic Import of contact data does not work
Ruth,

when I try your sample file, it is not in utf8. Once I save it in utf8, the import does work for me. Make sure you really are using it in utf8. If you save a file in utf8 then save it again, it may loose the character encoding, depending on your text editor.
Olivier.
The following user(s) said Thank You: bsbad

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #4233 by bsbad
Replied by bsbad on topic Import of contact data does not work
Hello Olivier,

notepad++ shows encoding as utf8 without bom. If I convert it to utf8 with notepad++ and try to import the file, I get the message SQL Error 1064 Charlie_HD got too.

I fixed the problem with a csv-Export of the original Excel-Table to iso-8859-1. Now everything works fine. The values in the database are correct.

Thamk you very much for your helpful quick answers.

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #4234 by admin
Replied by admin on topic Import of contact data does not work
You are welcome! I am glad you were able to make it work.
Olivier.

Please Log in or Create an account to join the conversation.