Automatically export users using crontab <--> sync with Gmail

stevland

I know this should be possible ― but I don't have the expertise to know if it is possible ― or how to approach it. Maybe this will spark some ideas.I'd like to setup a crontab job to export a CSV copy of the user list / contact info daily at midnight.From there, I'd like to tap into a Google API to import that CSV file into my Gmail Contacts.Pipe dream?

Chefkeks

It's definitely possible, but haven't ever played around with exporting data from the osTicket database - maybe it's possible to use the cli?!

I read always some commits over at github regarding osTicket cli and import/export. But even without cli it's possible with a 'simple' SQL script to get the data from the database. You can take a look at the code I used in my osTicket add-on to get ldap data into osTicket, but also read data from the osTicket database prior inserting data to MySQL database to make sure the data from ldap is inserted at the right places and only if it's necessary.

Hope it helps ;)

Chefkeks

Oops, forgot the link to my github repo: https://github.com/Chefkeks/osTicket-Addons

Take a look especially at the file named update_user_info.php: https://github.com/Chefkeks/osTicket-Addons/blob/master/ldap_user_info/update_user_info.php

stevland

Thanks, Chefkeks! I've got some homework.