Bulk ticket input?

[knischan]

Is there any way to do bulk tickets? I have some techs and they have like 20 tickets to put in and they asked me if there were any way to do like a CSV import or even just a SQL insert to create at ticket.

Wasn't sure, figured I'd ask. Any ideas?

[crythias]

You could use the API or a webform to submit the tickets on behalf of the customer.

Considering what is involved in submitting a ticket, the "easier" options start with piping as if it's an email from the customer, either via a generic webform or something else...
cat /opt/otrs/doc/sample_mails/test-email-2.box

Code: Select all

From darthvader@otrs.org  Fri Dec 21 23:55:24 2001
Return-Path: <darthvader@otrs.org>
Received: (from darthvader@localhost)
        by avro.de (8.11.3/8.11.3/SuSE Linux 8.11.1-0.5) id f3MMSE303694
        for martin@localhost; Fri, 21 Dec 2001 23:55:24 +0200
Date: Fri, 21 Dec 2001 23:55:24 +0200
From: System Tester II <darthvader@otrs.org>
To: skywalker@otrs.org
Subject: test 2
Message-ID: <20011221002814.A3599@avro>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
X-Operating-System: Linux 2.4.10-4GB i686
X-Uptime: 12:23am  up  5:19,  6 users,  load average: 0.11, 0.13, 0.18
X-CVS: $Id: test-email-2.box,v 1.1 2010/06/15 12:47:42 mg Exp $
Content-Length: 139
Lines: 11

This is the second test.

Cordially

  Darthvader

--
System Tester II - <darthvader@otrs.org>
--
"The number of Unix installations has grown to 10, with more expected."

Do not do the following unless you want a sample email as a new ticket.
From INSTALL:
cat /opt/otrs/doc/sample_mails/test-email-1.box | /opt/otrs/bin/otrs.PostMaster.pl

[knischan]

Thanks!