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) 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

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@internap.com]
Sent: Friday, September 9, 2016 2:38 PM
To: Dunbar, Brian
Cc: rt-users@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?

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@von.camailto:Brian.Dunbar@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@internap.com]
Sent: Friday, September 9, 2016 2:38 PM
To: Dunbar, Brian
Cc: rt-users@lists.bestpractical.commailto:rt-users@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@von.camailto:Brian.Dunbar@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! Training — Best Practical Solutions

  • Boston - October 24-26
  • Los Angeles - Q1 2017

Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
:e-mail: lstewart@internap.commailto:lstewart@internap.com
:earth_africa: www.internap.comhttp://www.internap.com/

Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
:e-mail: lstewart@internap.commailto:lstewart@internap.com
:earth_africa: www.internap.comhttp://www.internap.com

Thank you I think you have a great suggestion.On Sep 9, 2016 3:19 PM, Landon Stewart lstewart@internap.com wrote:
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@von.camailto:Brian.Dunbar@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@internap.com]
Sent: Friday, September 9, 2016 2:38 PM
To: Dunbar, Brian
Cc: rt-users@lists.bestpractical.commailto:rt-users@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@von.camailto:Brian.Dunbar@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! Training — Best Practical Solutions

  • Boston - October 24-26
  • Los Angeles - Q1 2017

Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
:e-mail: lstewart@internap.commailto:lstewart@internap.com
www.internap.comhttp://www.internap.com/

Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
:e-mail: lstewart@internap.commailto:lstewart@internap.com
www.internap.comhttp://www.internap.com

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@von.camailto:Brian.Dunbar@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! Training — Best Practical Solutions

  • Boston - October 24-26
  • Los Angeles - Q1 2017

Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
:e-mail: lstewart@internap.commailto:lstewart@internap.com
:earth_africa: www.internap.comhttp://www.internap.com

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.

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!
BrentFrom: rt-users [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Dunbar, Brian
Sent: Friday, September 09, 2016 1:28 PM
To: rt-users@lists.bestpractical.com
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-ticketshttps://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