[rt-users] Bulk load tickets

Dan Shoop dan.shoop at usts.com
Thu Mar 11 20:35:03 EST 2010


On Mar 11, 2010, at 4:08 PM, Andre Mello wrote:

> Hi there,
>  
> I am new to RT and I would like to know if it’s possible to bulk load tickets into RT from a source (eg: a csv file)?  I currently have some 30 tickets in a Sharepoint List and was wondering if there’s a more efficient way of transferring these tickets, other than manually.  Many tickets contain attachments.

When we need to do this we write some perl code that reads Excel files using Spreadsheet::ParseExcel (if you have csv you won't need this, you can just split) and then use the RT::Client::REST module to create the ticket. AFAIK this module doesn't let you attach to a ticket, but the CLI for RT, which can easily be scripted [also within perl] can attach files. Using the CLI would be another way to script this without using the RT::Client::REST module. 

We use these techniques to import several hundred tickets daily and have used it to load in whole legacy systems from spreadsheet files. 

-d

------------------------------------------------------------------------
Dan Shoop
Computer Scientist
U.S. Technical Services

dan.shoop at usts.com
GoogleVoice ............... 1-646-402-5293 *
Nextel .................... 1-714-363-1174
Operations TOC (24/7) ..... 1-866-901-USTS
USTS Offices .............. 1-714-374-6300

For immediate response or urgent matters please speak to the Duty Officer at the USTS Tactical Operations Center (above)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100311/e7be56c8/attachment.htm>


More information about the rt-users mailing list