[turba] Importing contacts from thunderbird
Estela Macías
emacias at usb.ve
Tue Apr 24 18:19:27 UTC 2007
> Zitat von Estela Macías <emacias at usb.ve>:
>
>> Hi,
>> When i try to import contacts from thunderbird, turba show "DB Error",
>> my database
>> charset in postgres is UTF-8 por default and i configured sources.php
>> file in sql source
>> with the same (UTF-8).
>> I think that is incompatibility in Character Encoding between
>> thunderbird and turba,
>> specifically with accents and other characters like 'ñ'.
>
> Unlikely, unless you've chosen a wrong charset in the import window.
> Even then you probably won't get a DB Error.
> Check your logs.
>
> Jan.
Well, i had problem importing contacts using comma separating values
but i resolved installing pear/File. Later, i probe importing contacts
in this case from Thunderbird and excelent, i resolved one problem but
importing with tab separating values is not working:
Nombre Apellidos Nombre mostrado Apodo Direcci?e correo electr?o
principal Direcci?e correo
fanny ter?fanny ter? fteran at hotmail.com
Last example shows wrongs characters in accents.
Finally get error "DB Error: unknown error" and logs shows:
Apr 24 14:12:54 HORDE [error] [turba] DB Error: unknown error: SELECT
object_id, owner_id, object_type, object_members, object_uid,
object_name, object_email, object_title, object_company,
object_homephone, object_workphone, object_cellphone, object_fax,
object_homeaddress, object_workaddress, object_notes FROM
turba_objects WHERE (owner_id = 'emacias' AND (object_name ILIKE
'%fanny ter?n%')) [nativecode=ERROR: secuencia de bytes no válida
para codificación «UTF8»: 0xe16e25] [on line 126 of
"/var/www/html/horde/turba/lib/Driver/sql.php"]
Thanks for your help
More information about the turba
mailing list