Change/Importing contacts via CSV using curl

Revision as of 06:47, 17 August 2017 by Nbhagwat (talk | contribs) (Created page with "===<h1>Importing contacts via CSV using curl</h1>=== <hr> <br> <h2>Problem:</h2> Contact isn't imported via CSV file using curl. Message showing in the mailbox.log file <p...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Importing contacts via CSV using curl



Problem:

Contact isn't imported via CSV file using curl.

Message showing in the mailbox.log file

2016-01-22 13:31:04,844 INFO  [qtp509886383-729:https://localhost:7071/home/user@example.com/Contacts?fmt=csv [name=admin@zcs.va;mid=9;ip=127.0.0.1;] UserServlet - POST: https://localhost:7071/home/user@example.com
2016-01-22 13:31:04,845 INFO  [qtp509886383-729:https://localhost:7071/home/user@example.com/Contacts?fmt=csv] [name=admin@zcs.va;mid=9;ip=127.0.0.1;] mailbox - UserServlet received file unknown - 195 request bytes

CSV File :

"fullName","lastName","firstName","email","email2","mobilePhone","mobilePhone2","jobTitle","company","namePrefix"
"John Doe","John","Doe","John.Doe@example.com","","","","","",""


Solution:

1. Make the CSV in the following format:

"First Name","Last Name","Display Name","Nickname","Primary Email","Secondary Email","Screen Name","Work Phone","Home Phone","Fax Number","Pager Number","Mobile Number","Home Address","Home City","Home County","Home Post Code","Home Country","Work Address","Work City","Work County","Work Post Code","Work Country","Job Title","Department","Organisation","Web Page 1","Web Page 2","Birth Month","Custom 1","Custom 2","Custom 3","Custom 4","Notes"
"John","Doe","John Doe","John","John.Doe@example.com","","","","","","","","","","","","","","","","","","","","","","","","","","","",""

2. Import using this command:

curl -k -u admin@example.com:admin_pass --upload-file /tmp/contact.csv https://localhost:7071/home/user@example.com/Contacts?fmt=csv


Using the above command, the admin can import contacts for all users. Just change 'user@example.com' to the relevant user's address. If you're using a valid SSL certificate, '-k' can be omitted.


Shashank Shekhar Tewari

"Shashank Tewari" <stewari@zimbra.com>

Jump to: navigation, search