Command line export addressbook ??????

[ziotibia81]

Hi!!!

Where I work we have one user ( centralinist ) who share a contacts folder. This folder have many subfolders containing all public contatcts (all customers, all emplyes ecc ecc.).

My old but very big boss don't want to use PC and I have to print addressbook for him.

Zimbra print output isn't usefoul and I have to make a layout customized but It's no possible in zimbra.

So I need to a batch procedure that nighly export all contacts in some format (and later import it into a database and create a with same report manager a customized report).

Is possible to make a similar export as CSV or something similar from command line?

[mmorse]

as root or zimbra:
/opt/zimbra/bin/zmmailbox -z -m user@domain.com getRestURL "/Contacts?fmt=csv" > /tmp/user-contacts.csv


or via:

https://user@domain.com.com:thepass@srv.domain.com/zimbra/home/user@domain.com/Contacts.csv

(with or without their password depending on how your authing; previous token, as admin, etc)

[ziotibia81]

Originally Posted by mmorse

as root or zimbra:
/opt/zimbra/bin/zmmailbox -z -m user@domain.com getRestURL "/Contacts?fmt=csv" > /tmp/user-contacts.csv

It's that I need but don't work....

I've just run it without redirection to file and reply is one empty row.

structure is:

Contacts (empty) -
                  -> "Public Folder" (shared but empty) - 
                                                         -> Customers
                                                         -> Banks
                                                         -> Employed
                                                         -> ecc ecc

[mmorse]

Adjust your search a little:
/opt/zimbra/bin/zmmailbox -z -m user@domain.com getRestURL "/?fmt=csv&query=under:Contacts" > /tmp/user-contacts.csv

Bug 15161 - add a 'recursive' option for REST fetch

In the below example email2@domain.com is in /Contacts/Test

# /opt/zimbra/bin/zmmailbox -z -m user@domain.com getRestURL "/Contacts?fmt=csv"
"email","firstName","fullName","lastName","middleN ame"
"email@domain.com","first","first middle last","last","middle"

vs

# /opt/zimbra/bin/zmmailbox -z -m user@domain.com getRestURL "/?fmt=csv&query=under:Contacts"
"email","firstName","fullName","lastName","middleN ame"
"email2@domain.com","f2","f2 m2 l2","l2","m2"
"email@domain.com","first","first middle last","last","middle"

[ziotibia81]

Ok, partially solved....

"Public folder" was at the same level of contacts so:

/opt/zimbra/bin/zmmailbox -z -m user@domain.com getRestURL "/?fmt=csv&query=under:Public folder"

but empty space between "public" and "folder" is a problem.This don't work:

/opt/zimbra/bin/zmmailbox -z -m user@domain.com getRestURL '/?fmt=csv&query=under:Public folder'

as this:

/opt/zimbra/bin/zmmailbox -z -m user@domain.com getRestURL "/?fmt=csv&query=under:Public%20folder"

so renaming it into "PublicFolder" I could see csv.

there is a way to customize CSV output?
I need to know if a row is under publicFolder/Banks, or PublicFolder/Customers ecc ecc.