Change/Importing contacts via CSV using curl: Difference between revisions

(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...")
 
No edit summary
Line 9: Line 9:
Message showing in the mailbox.log file
Message showing in the mailbox.log file


<pre>
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,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
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
 
</pre>


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


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




<h2>Solution:</h2>
<h2>Solution:</h2>


1. Make the CSV in the following format:
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","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
 


<pre>
2). Import using this command:
"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","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
</pre>


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


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




Line 41: Line 36:




Shashank Shekhar Tewari
Submitted by:  Shashank Tewari
 
"Shashank Tewari" <stewari@zimbra.com>

Revision as of 01:43, 19 August 2017

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.


Submitted by: Shashank Tewari

Jump to: navigation, search