[rt-users] import tickets from csv file

[Dunbar, Brian]

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

Re: [rt-users] import tickets from csv file

[Dunbar, 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:lstew...@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?

On Sep 9, 2016, at 10:28 AM, Dunbar, Brian 
mailto:brian.dun...@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 ®
📧 lstew...@internap.com<mailto:lstew...@internap.com>
🌍 www.internap.com<http://www.internap.com>

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

Re: [rt-users] import tickets from csv file

[Landon Stewart]

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 
mailto:brian.dun...@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:lstew...@internap.com]
Sent: Friday, September 9, 2016 2:38 PM
To: Dunbar, Brian
Cc: rt-users@lists.bestpractical.com<mailto: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 
mailto:brian.dun...@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 ®
📧 lstew...@internap.com<mailto:lstew...@internap.com>
🌍 www.internap.com<http://www.internap.com/>

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

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

Re: [rt-users] import tickets from csv file

[Dunbar, Brian]

Thank you I think you have a great suggestion.

On Sep 9, 2016 3:19 PM, Landon Stewart  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 
mailto:brian.dun...@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:lstew...@internap.com]
Sent: Friday, September 9, 2016 2:38 PM
To: Dunbar, Brian
Cc: rt-users@lists.bestpractical.com<mailto: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 
mailto:brian.dun...@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 ®
📧 lstew...@internap.com<mailto:lstew...@internap.com>
� www.internap.com<http://www.internap.com/>

--
Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
📧 lstew...@internap.com<mailto:lstew...@internap.com>
� www.internap.com<http://www.internap.com>


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

Re: [rt-users] import tickets from csv file

[Landon Stewart]

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 
mailto:brian.dun...@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 ®
📧 lstew...@internap.com
🌍 www.internap.com

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

Re: [rt-users] import tickets from csv file

[Parish, Brent]

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:rt-users-boun...@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-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