Hello Burkart Orlowsk
On 2012-09-06 14:29, Burkart Orlowski | Onlinehelp24 wrote: > > I am looking for a solution to export a particular addressbook into a > CSV file. > > mysql sogo --user=*** --password=*** < mysql2csv.sql > > mysql2csv.sql => > SELECT * FROM sogob***0012ca32195_quick INTO OUTFILE > '/tmp/adressen_aktuell.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED > BY '"'; > > This is working pretty fine but unfortunately the exported address book > fields are not complete. It lacks the address fields (street, ZIP, ...) > for example. Any ideas how to export all address book information into a > single CSV file? > Why don't you use the export in LDIF format and convert it to csv afterwards? Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- [email protected] https://inverse.ca/sogo/lists
