[rt-users] import tickets from csv file

Landon Stewart lstewart at internap.com
Fri Sep 9 15:19:10 EDT 2016


If you formulate the email with the "From:" as the requestor it would set it accordingly in the ticket.  If RT is set to produce auto-replies though they'd get that auto-reply.

On Sep 9, 2016, at 11:51 AM, Dunbar, Brian <Brian.Dunbar at von.ca<mailto:Brian.Dunbar at von.ca>> wrote:

I can format the csv anyway as  desired but importing as email will make me the requester for every ticket?


From: Landon Stewart [mailto:lstewart at internap.com]
Sent: Friday, September 9, 2016 2:38 PM
To: Dunbar, Brian
Cc: rt-users at lists.bestpractical.com<mailto:rt-users at lists.bestpractical.com>
Subject: Re: [rt-users] import tickets from csv file

What kind of columns does the CSV have?  May it's possible to simply convert each record in the CSV to an email and use rt-mailgate?

On Sep 9, 2016, at 10:28 AM, Dunbar, Brian <Brian.Dunbar at von.ca<mailto:Brian.Dunbar at von.ca>> wrote:

Hello All,

I have a new 4.4 install of RT and I would like to import tickets from another ticket system (Spiceworks). I can get the ticket info in a csv file to import but I have not found a script that works to populate RT with the info. I found a script by Alister West (https://alisterwest.com/code/perl-rt-import-tickets) but it did not work and it was made for RT4.0 I do not know perl enough to write my own script. So hopefully there is something out there that works and can be shared.

Regards
Brian

---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Boston - October 24-26
* Los Angeles - Q1 2017

--
Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
📧 lstewart at internap.com<mailto:lstewart at internap.com>
🌍 www.internap.com<http://www.internap.com/>

--
Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
📧 lstewart at internap.com<mailto:lstewart at internap.com>
🌍 www.internap.com<http://www.internap.com>

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


More information about the rt-users mailing list