[horde] Export of address book
Ralph Ballier
ballier at mail.schule.de
Sat Oct 15 08:20:50 UTC 2016
Zitat von Jan Schneider <jan at horde.org>:
> Zitat von Ralph Ballier <ballier at mail.schule.de>:
>
>> Zitat von Jan Schneider <jan at horde.org>:
>>
>>> Zitat von Ralph Ballier <ballier at mail.schule.de>:
>>>
>>>> Hello,
>>>>
>>>> I tried to export an address book. Unfortunately, a RETURN is in
>>>> the middle of a record. Therefore, there are problems to import
>>>> this CSV file into Excel.
>>>>
>>>> Below I added two records. From this four lines have become. I
>>>> clearly marked the wrong RETURNs.
>>>>
>>>> What can I do?
>>>
>>> Nothing, it's a valid CSV file, and if Excel cannot import it,
>>> it's badly broken. Try a different application.
>>>
>>>> "firstname","lastname","middlenames","namePrefix","nameSuffix","name","alias","yomifirstname","yomilastname","birthday","anniversary","spouse","phototype","homeStreet","homePOBox","homeCity","homeProvince","homePostalCode","homeCountry","homeAddress","workStreet","workPOBox","workCity","workProvince","workPostalCode","workCountry","workAddress","otherStreet","otherPOBox","otherCity","otherProvince","otherPostalCode","otherCountry","otherAddress","department","manager","assistant","timezone","email","homePhone","homePhone2","homeFax","workPhone","workPhone2","cellPhone","carPhone","radioPhone","companyPhone","assistPhone","fax","pager","title","role","company","logotype","notes","website","freebusyUrl","pgpPublicKey","smimePublicKey","imaddress","imaddress2","imaddress3"
>>>> ,"Name1",,"Frau",,"Miss
>>>> Name1",,,,,,,,,,,,,,,"Walter-Friedrich-Str. 16-18",,"13125
>>>> Berlin",,,"DE","Walter-Friedrich-Str. 16-18[RETURN]
>>>> 13125
>>>> Berlin",,,,,"13125",,"13125","03K10",,,,"Name1 at hufeland-schule.berlin",,,,,,,,,,,,,,,"Hufeland-Schule",,,,,,,,,
>>>> "Firstname2","Name2",,,,"Firstname2
>>>> Name2",,,,,,,,,,,,,,,"Erich-Weinert-Str.
>>>> 70",,"Berlin",,"10439","DE","Erich-Weinert-Str. 70[RETURN]
>>>> Berlin,
>>>> 10439",,,,,,,,,,,,"Firstname2.Name2 at wvk-gemeinschaftsschule.de",,,,,,,,,,,,,,,"Wilhelm-von-Humboldt-Schule",,,,,,,,,
>>>>
>>>>
>>
>> It is not due to Excel. If I open the CSV file with Wordpad or with
>> MS Word, then I see the additional line break.
>
> The linebreak is fine. Not being able to import this linebreak
> correctly is not.
>
I need to use Excel. So I removed the part with the "\ n" from
turba/config/backends.local.php (homeAddress, workAddress,
otherAddress). Now the export works correctly.
More information about the horde
mailing list