[Question] Update contacts field directly in mysql

I want to integrate the contacts app with external MS Access database. I import the contacts from Access by vcard, but want a closer integration to get any updates from Access directly. In teh future probably vice-versa
In the first place I want to know exactly where are the contacts fields located in the mysql database?

Have a look at field carddata in table oc_cards (your table prefix might be different)

Found that the data (vcard) is stored in carddata in longblob format. Is it possible to access specific fields in such a file? Are there some indicator-variable? Or are the fields stored anywhere else?

No theyโ€™re not. :slight_smile:
Some of them are extracted into the oc_cards_properties, but not all of them.