[Question] Update contacts field directly in mysql

🍱 Features & apps 📇 Contacts
1

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?

2

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

3

Thanks
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?

4

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