[Solved] Ex-/Import of a public Adressbook

We have a ERP-System. The should be the “Master-Database” of our Contacts. From time to time we want to import the data to Kopano as a public Adressbook.

Which programm I can use to export a public Adressbook (to see, which fields we are needed) and how can i import the generatet data to Kopano without using of Outlook (we will in near future only use WebApp/DeskApp)

The Contacts2Csv working only with Contacts of a user - not with public folders. I try it with the user “system”, but i don´t have access to the public folder Adressbook

I try it with “Public Folders\Intern” and “Public Folders\Adressbuch Intern” and “Public Folders” - but every time came up the “NotFoundError”

Hi @MyKey0815 ,

Please try the new version of https://stash.kopano.io/projects/KSC/repos/core-tools/browse/contacts2csv.
We added an option to export from the public store.

Regards Robin

Thanks for you addition. I have try it but they dont work.

The show only follwing Error:

root@SE69J4H32ZA2:~# python export2.py --public --folder "Intern" --export --delimiter ";"
running script for 'Public store'
Traceback (most recent call last):
  File "export2.py", line 237, in <module>
  File "export2.py", line 110, in main
    contacts = store.folder(options.folder)
  File "/usr/lib/python2.7/dist-packages/kopano/store.py", line 301, in folder
    return self.subtree.folder(path, recurse=recurse, create=create)
  File "/usr/lib/python2.7/dist-packages/kopano/folder.py", line 376, in folder
    raise NotFoundError("no such folder: '%s'" % path)
kopano.errors.NotFoundError: no such folder: 'Intern'

In Outlook the Folder is shown as “Adressbuch Intern”

but then you should run

python export2.py --public --folder "Adressbuch Intern" --export --delimiter ";"```

YES!!! Now the export is working fine

I have subfolders. Unfortunately these are not synchronized. Can you do something there?


You need to add the root folder, so if you subfolder in under the default contacts folder then you need to do

python contact2csv.py --user username --folder "Contacts/subfolder" --export 

Hi robin,

when i try to run the script I get 2 Errors:

[root@server kopano-python]# python contact2csv.py --public --folder "All_Adressen" --export
Traceback (most recent call last):
  File "contact2csv.py", line 243, in <module>
  File "contact2csv.py", line 109, in main
    print('running script for \'{}\'').format(user)
ValueError: zero length field name in format

what is wrong here?
and, what should I do with the two date values?
PR_WEDDING_ANNIVERSARY and PR_BIRTHDAY need to be converted to Epoch timestamp.
how do I convert them?

Log in to reply

Looks like your connection to Kopano Community Forum was lost, please wait while we try to reconnect.