[rt-users] Re: Getting data from Excel into RT?

[Steve_McStravick at BreconRidge.com]

I found http://wiki.bestpractical.com/index.cgi?ManualApprovals as a good
source for the format you are looking for, it gives a list of Acceptable
fields.
You'll have to parse the Excel data somehow.  When I did it I took a
flatfile and imported into a database table, then wrote a query that output
the correct format.
Once you have the format you can use the "Offline" feature in RT.  Make
sure you turn off the RT mail server before starting the import, otherwise
all of the ticket requestors will get mail sent to them.

Basically the format for using the "Offline" feature is :

===Create-Ticket: <identifier> (basically here I just used a sequential
number, it doesn't relate to the RT ticket #)
Subject: <subject>
Queue: <RT_Queue name> (you can leave this out and identify the queue on
the Offline screen if they're all going to the same queue)
Requestor : <email address>
.... (here you can add whatever other items you want to populated (Owner,
Status, CustomField-<id#>, etc..whatever you see in the "Acceptable fields
" from the document)
Content-Type: text/plain
Content:
<the text portion of your ticket>
ENDOFCONTENT

Steve




                                                                           
             rt-users-request@                                             
             lists.bestpractic                                             
             al.com                                                     To 
             Sent by:                  rt-users at lists.bestpractical.com    
             rt-users-bounces@                                          cc 
             lists.bestpractic                                             
             al.com                                                Subject 
                                       RT-Users Digest, Vol 34, Issue 70   
                                                                           
             01/31/2007 06:25                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             rt-users at lists.be                                             
              stpractical.com                                              
                                                                           
                                                                           




>Greetings,

>We've got a spreadsheet (hand-produced, not created by RT) that has a
>number of projects which we would like to convert into RT tickets. I've
>searched the RT users mailing list to see if anyone has attempted
>something like this, and I have found a few messages where people
>suggest using the "offline" feature in RT. However, I haven't been able
>to find any documentation on how to make use of this feature. Can anyone
>give me some pointers on either where to look for more detailed
>information, or suggestions on another way to get Excel data into RT?

>Thanks,

>Peter