Is this working server-side as well? I need to run a script once a day
to export a particular address book.
Regards, Burkart
On 09/06/2012 05:09 PM, Christian Mack wrote:
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
--
[email protected]
https://inverse.ca/sogo/lists
