Python Script that checks OTRS CSV exports against Google Calendar
May.09, 2011 in
Python Scripting
Wheeeee it runs! I made a working Python/Google API script for something I needed. What this basically does, you export OTRS help desk queries to a CSV file, then run this python script against that CSV file, and it uses the Google API to do a Full Text Search against the Google Calendar, in which you will get a return of any events found on a calendar of your choice. This can be tweaked for use on Any file, any query system, but I needed to check for Ticket numbers against Google Calendar and see if they existed or not…
Video Rating: 5 / 5
rigid body dynamics in houdini. “castle” created using hou module and external python file
Incoming search terms:
- otrs google calendar
- otrs python
- otrs csv export
- outlook 2010 vba date compare
Related posts:
May 9th, 2011 at 7:31 am
Oh it can pretty much run from anything, but what you see is Linux terminal
May 9th, 2011 at 7:37 am
Heyyy….Soo, What are you using to run that, I mean, it looks like cmd, but i know cmd can’t go full screen… o.o
May 9th, 2011 at 7:38 am
@TrinaryOuroboros It truly is *wraps arm around* it truly is *sniff*
May 9th, 2011 at 8:16 am
@MrApplseed (sniff) its a Kodak moment. :’-)
May 9th, 2011 at 8:38 am
Wow, I have no Idea what OTRS is, but seeing that code running by, made me cry tears of joy O.O
May 9th, 2011 at 9:13 am
@alfridokiller1 Thanks, I’m now working on using the same script to directly check the OTRS MySQL DB instead, should be very efficient.
May 9th, 2011 at 9:33 am
amazing discovery