It would definitely take some work to get it set up for your environment and CSV fields, but I wrote a script to import another system a while ago. http://parishnetworks.blogspot.com/2014/10/importing-into-rt-from-another-helpdesk.html
I wish I had written it in a more generic, easy to adapt form, but I never expected to use it again or share it! I STRONGLY recommend running it in a dev environment first until you can work out the details and get it importing correctly. Good luck! Brent From: rt-users [mailto:[email protected]] On Behalf Of Dunbar, Brian Sent: Friday, September 09, 2016 1:28 PM To: [email protected] Subject: [rt-users] import tickets from csv file 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<https://urldefense.proofpoint.com/v2/url?u=https-3A__alisterwest.com_code_perl-2Drt-2Dimport-2Dtickets&d=DQMFAg&c=VCWpAYkS3z1bOCIxc-BPGZarCq9MRCAVxZJE051VqH8&r=luSRdPePk6fhFa3rH2PFBzWEtgcJguY0a__6vpfaX-I&m=VHAaOOOlld1cZzscrMo26vR7JYQzmpMBlOpT7HLqGw8&s=FYC6tWnEu8dsq1G47wm71bz1masrvetafeaOcW8u4q0&e=>) 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
