@rdd2 said in Manipulating categories via GRAPI:

Are there any plans to implement setting categories via GRAPI?

Yes - we add features to GRAPI as we need them for our apps or for customer projects.

Normally it should take the color of the last added category.
if you use the new categories you can define anything you like in the color value it will just copy over that value so this also works "color": "rgba(255, 0, 0, 0.5)", , but a color needs to be set otherwise it will use gray as default color.

Hi @ThiefMaster,

yes that is something we also would like to do and have discussed a few times already, sadly it’s not that easy.

python-kopano also depends on some of our c libraries, so even if you compile it yourself (which is possible) you won’t have much use for it if there are not also Kopano packages for your chosen distribution.

If your distribution does not have Kopano packages, when using a container could be an alternative. Our docker project includes a container that has just python3-kopano and its dependencies installed (on a Debian base). You can find it at https://hub.docker.com/r/kopano/kopano_python.

Sorry, this was in deed a stupid question.

It is simple as that:

server = kopano.Server(auth_user='userXY') for f in server.public_store: print(f)

@torsten17
Many thanks for your script. I love it.

@rgsell said in python add category to contact:

Struct.py, line 266:
<class ‘tuple’>: (<class ‘TypeError’>, TypeError(“unhashable type: ‘list’”,), None)

The hash() is a built-in python method, used to return a unique number . This can be applied to any user-defined object which won’t get changed once initialized. This property is used mainly in dictionary keys .

TypeError: unhashable type: ‘list’ usually means that you are trying to use a list as an hash argument. This means that when you try to hash an unhashable object it will result an error. For ex. when you use a list as a key in the dictionary , this cannot be done because lists can’t be hashed. The standard way to solve this issue is to cast a list to a tuple .

Hi Bastian,

@bmachek said in kopano-virusd:

I change the subject, and if configured the infected attachment is removed, and a dummy .txt attachment is created. btw Outlook also still is able to access the attachment…

like I said, Outlook over ActiveSync requests the whole RFC message (headers + body) in AirSyncBase:Data which comes either from PR_EC_IMAP_EMAIL property or is built by mapi_inetmapi_imtoinet function. Either way if Outlook itself parses the RFC message to get the necessary information, it’s not enough to just change the subject and remove attachment. You’d also have to manipulate PR_EC_IMAP_EMAIL or whatever properties mapi_inetmapi_imtoinet uses to put the RFC message together.

Manfred

Hi,

sorry for the late reply, i’d forget to watch my own topic :-((.

With your suggestion it work’s like a charme.

Is it planed to apply them automatically ?
In my used version V8.6.9 here it does not.

best regards and many thanks for you help
Michael

I got some help from a kopano developer to get this running. Maybe the result is interesting for someone here.

First thing to know is that the categories are stored for each user separately. So you need to do this for everyone, who should have access to the new categories. My example script here does it just for one, but can easily adopted to run for several or all users.

What you need to get is a special property. If it’s not there, then the user never changed something in his or her category settings and the property needs to be created.

import kopano from MAPI.Tags import PR_EC_WEBAPP_PERSISTENT_SETTINGS_JSON import jsbeautifier import json import io import copy server = kopano.Server() user = server.user('kopano-user') list_cats = list() kopano_cats = list() cat_language = 'english' cat = user.store.get_prop(PR_EC_WEBAPP_PERSISTENT_SETTINGS_JSON) if cat: cat = user.store.prop(PR_EC_WEBAPP_PERSISTENT_SETTINGS_JSON).value cat = cat.decode() parsed_json_cat = json.loads(cat) list_cats = parsed_json_cat['settings']['kopano']['main']['categories'] else: print('No custom setting done yet') print('Setting default values') if cat_language == 'german': with io.open('default_cats_german.json', mode='r', encoding='utf-8') as f: parsed_json_cat = json.load(f) print('Using german category names') else: with open('default_cats_english.json') as f: parsed_json_cat = json.load(f) print('Using english category names') user.store.create_prop(PR_EC_WEBAPP_PERSISTENT_SETTINGS_JSON, json.dumps(parsed_json_cat).encode()) new_cats = ['01/Custom Category', '02/Another custom category', 'utf8 Example: Aufzüge'] print(' ') print(' ') print('Kopano Categories before: ') print(' ') for item in list_cats: print(item['name']) kopano_cats.append(item['name']) print(' ') print(' ') print('JSON before: ') print(' ') pretty_cat = jsbeautifier.beautify(str(parsed_json_cat)) print(pretty_cat) json_cat = json.dumps(parsed_json_cat) old_parsed_json_cat = copy.deepcopy(parsed_json_cat) for new_cat in new_cats: if new_cat not in kopano_cats: parsed_json_cat['settings']['kopano']['main']['categories'].append({"name": new_cat, "color": "#BDC3C7", "quickAccess": False}) print(' ') print(' ') print('Kopano Categories after: ') print(' ') list_cats = parsed_json_cat['settings']['kopano']['main']['categories'] for item in list_cats: print(item['name']) print(' ') print(' ') print('JSON after: ') print(' ') pretty_cat = jsbeautifier.beautify(str(parsed_json_cat)) print(pretty_cat) if old_parsed_json_cat != parsed_json_cat: json_cat = json.dumps(parsed_json_cat) json_cat = json_cat.encode() user.store.prop(PR_EC_WEBAPP_PERSISTENT_SETTINGS_JSON).value = json_cat else: print('Nothing changed, exiting.')

And these are the default categories in english:
(so, just put the content in a file called default_cats_english.json before running the script on users, who didn’t change the cat settings)

{ "settings": { "kopano": { "main": { "categories": [{ "name": "Red", "used": false, "quickAccess": true, "sortIndex": 0, "color": "#e40023", "standardIndex": 6 }, { "name": "Orange", "used": false, "quickAccess": true, "sortIndex": 1, "color": "#f99406", "standardIndex": 2 }, { "name": "Yellow", "used": false, "quickAccess": true, "sortIndex": 2, "color": "#f7ca17", "standardIndex": 4 }, { "name": "Green", "used": false, "quickAccess": true, "sortIndex": 3, "color": "#5ab556", "standardIndex": 3 }, { "name": "Blue", "used": false, "quickAccess": true, "sortIndex": 4, "color": "#0f70bd", "standardIndex": 5 }, { "name": "Purple", "used": false, "quickAccess": true, "sortIndex": 5, "color": "#912887", "standardIndex": 1 }, { "name": "Birthday", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#DCB6E9", "standardIndex": "" }, { "name": "Business", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Competition", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Favorites", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Gifts", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Goals/Objectives", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Holiday", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#EBDA6C", "standardIndex": "" }, { "name": "Holiday Cards", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Hot Contacts", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Ideas", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Important", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#F4B7B5", "standardIndex": "" }, { "name": "International", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Key Customer", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Miscellaneous", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Personal", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#D9E9B6", "standardIndex": "" }, { "name": "Phone Calls", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Phone Interview", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#C1E9B6", "standardIndex": "" }, { "name": "Preparation Required", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#B6B6E9", "standardIndex": "" }, { "name": "Required", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#E9DAB6", "standardIndex": "" }, { "name": "Special Date", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#E9BBB6", "standardIndex": "" }, { "name": "Status", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Strategies", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Suppliers", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Time & Expenses", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Travel Required", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#B6DDE9", "standardIndex": "" }, { "name": "VIP", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Waiting", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#BDC3C7", "standardIndex": "" }, { "name": "Work", "used": "", "quickAccess": false, "sortIndex": 100000, "color": "#B6CAE9", "standardIndex": "" }] } } } }

My example script does not delete categories, if you make the new_cats list smaller at any time. If you want that, you need to make some changes.

Yes! Indeed!
Variable, checkbox or whatever!
Seems to be excluded from migration…

sorry for the late reply.

we recently added a check to 8.6 for when dststartmonth==0, so here it almost has to be larger than 12… :S

would it be possible to give us the value of the local variable ‘tz_data’, as it’s possibly corrupted?

I usually do this by copying /usr/lib/…/kopano locally, and adding a print statement in there.

you could also print(self.subject, self.start) in appointment.py, line 102 or so, to check out which appointment we are dealing with.

PS you can also use datetime(2018, 1, 2) if you’re not aware, so no need for strptime

PS2 user.calendar can also be used instead of user.store.calendar (and anything else this way which is not ambiguous)

It has been solved by the Kopano support due a error on a dependency that doesn’t was updated successfully.
Run the command “yum update libmime-kopano” has solved the problem

I have found a workaround that works for me. I do the request in PostDelivery and delete the mailitem in PHP MAPI.