I have been using OTRS for a while and have not read anything about a command line iinterface.  However, looking at your question, my first thought would be to write a Perl program to do the sql queries and then still in Perl, generate and send an email to OTRS that then could put the request in to the correct queues for you based on subject lines.
 
But then again I could be missing something here.
 
 
Greg Horne
GEH
-----Original Message-----
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]On Behalf Of Partington, Eric
Sent: Tuesday, June 12, 2007 1:20 PM
To: otrs@otrs.org
Subject: [otrs] Command line query

I am very interested in using OTRS and possibly ITSM as a ticketing/ workflow management utility to remove many of the manual processes we currently use.

I have a few questions that I would like answers for to help make a decision on what to use:

I understand that you can create tickets via the customer interface/ the admin interface and via email… is there a way to create a ticket via a commandline interface?

        -What I am trying to do is create tickets based on sql queries of an external database that changes on a weekly basis. Once the information has been extracted from the external DB I would like to create a ticket for each one and insert it into a preliminary queue in OTRS. 

I have been investigating RT as well and am intrigued by the scip functionality they use.  Is there the ability to run a similar event when a ticket moves into or leaves a queue automatically?

I have read that the ITSM manual isn't complete yet, hopefully once that comes out I will be able to RTFM and solve these questions by myself, but until then does anyone have any suggestions.

Thanks

Eric 

_______________________________________________________________________

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations.
Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized.
If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.  

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent.
Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite.
Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.