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.
U.S. Technical Services
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)