Change/Importing contacts via CSV using curl: Difference between revisions
No edit summary |
No edit summary |
||
Line 4: | Line 4: | ||
=Importing contacts via CSV using curl= | =Importing contacts via CSV using curl= | ||
<hr> | <hr> | ||
{{KB|{{ZC}}|{{ZCS 8.8 | {{KB|{{ZC}}|{{ZCS 8.8}}||||}} | ||
{{WIP}} | {{WIP}} | ||
Line 12: | Line 12: | ||
When trying to import a contact via CSV file using curl. we get the following error in the mailbox.log file: | When trying to import a contact via CSV file using curl. we get the following error 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> | |||
====Solution==== | ====Solution==== | ||
* | * Ensure the CSV is in the following format: | ||
*:<pre> | |||
*::"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> | |||
* Import using this command: | * Import using this command: | ||
*:<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> | |||
Using the above command, the admin can import contacts for all users. Just change <code>user@example.com</code> to the relevant user's address. | |||
If you're using a valid SSL certificate, <code>-k</code> can be omitted. | |||
Using the above command, the admin can import contacts for all users. Just change | |||
Line 37: | Line 36: | ||
|} | |} | ||
{{Article Footer|ZCS 8.8 | {{Article Footer|ZCS 8.8|2020-04-13}} |
Revision as of 19:58, 28 April 2020
Importing contacts via CSV using curl
- This article is a Work in Progress, and may be unfinished or missing sections.
Problem
When trying to import a contact via CSV file using curl. we get the following error 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
Solution
- Ensure the CSV is 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","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
- 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 Shekhar Tewari |