[Solved] Ex-/Import of a public Adressbook

dimamr

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

robing

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

segro

@robing
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>
    main()
  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?

Illuvatar

Hi,
is it possible to export categories? When i run the script, everything works well, but the .csv file doesn’t show any categories/labels.

Jonas

markb

@segro are you running python 2.6 perhaps ?

segro

it sounds like I should an other version? kopano is on Centos6 / webapp on Centos7 with php56
[root@mail ~]# python -V
Python 2.6.6
[root@mail ~]# ssh webapp
[root@webapp ~]# python -V
Python 2.7.5
[root@webapp ~]#

markb

The script is using a .format syntax which is only supported on python 2.7 or higher.
You could fix it yourself though
Replace {} with {0} in the line should do the trick.

segro

it seems to be a little difficult on centos6.
first I installed python 2.7 from redhat

yum --enablerepo=centos-sclo-rh -y install python27
...
[root@mail kopano]# python2.7 contacts2csv.py --user username --export
Traceback (most recent call last):
  File "contacts2csv.py", line 13, in <module>
    import zarafa as kopano
ImportError: No module named zarafa

also I tried python33 from that repo, but :

please install python3-kopano

but there is no python3-kopano package for Centos-6 :-(

Replacing all {} with {0} finaly works, but I have to comment out the two lines with Wedding and birthda (how to solve this?)

export is working with that, but import is still with error:

 python contacts2csv.py --public --folder TEST --import test_contacts.csv
running script for 'Public store'
Traceback (most recent call last):
  File "contacts2csv.py", line 308, in <module>
    main()
  File "contacts2csv.py", line 237, in main
    new_item.mapiobj.SetProps([SPropValue(getattr(MAPI.Util,headers[num]), value)])
  File "/usr/lib/python2.6/site-packages/MAPICore.py", line 289, in SetProps
    def SetProps(self, *args): return _MAPICore.IMAPIProp_SetProps(self, *args)
UnicodeEncodeError: 'ascii' codec can't encode character u'\xdf' in position 10: ordinal not in range(128)
[root@mail kopano]#```

thanks,
Sebastian

markb

@segro

It seems you have a unicode issue there is a ß somewhere in your csv, I am not sure if value.encode(‘utf-8’) will fix your issue you could give it a try.

segro

thank you for the quick response, … where should I put the value.encode in the script?
line 237
new_item.mapiobj.SetProps([SPropValue(getattr(MAPI.Util,headers[num]), value.encode(‘utf-8’))])
but did not fix:

  File "contacts2csv.py", line 237, in main
    new_item.mapiobj.SetProps([SPropValue(getattr(MAPI.Util,headers[num]), value.encode('utf-8'))])
AttributeError: 'int' object has no attribute 'encode'

smguenther

Just in case someone stumbles across this old thread:

Adding

reload(sys)
sys.setdefaultencoding('utf-8')

right after the

import(sys)

solved the problem for me.

Regards,

Stefan