[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