[rt-users] Easy way to import a CSV file into ticketing?

[Parish, Brent]

Agreed – CLI is a good way to go.

I wrote a Perl script to import the database from two other applications and that worked reasonably well.
One was a CSV export and the other was a MSSQL database we just connected directly to (two different cases that I munged into a single script)

I ran the importer against our test RT environment so I could continue to tweak it (and blow it away to start fresh) a number of times before going to prod – I highly recommend doing that!

Of note:  Importing into RT will automatically create new ticket numbers for the old data.  In our case, it was imperative that I kept the original ticket numbers from the one database import, so I ran it first (against an empty RT install) and set the ticket number, knowing it wouldn’t overwrite anything in a blank RT instance.

I have not looked at or updated the scripts for a long time now, but this may be helpful to get you started anyway:
http://parishnetworks.blogspot.com/2014/10/importing-into-rt-from-another-helpdesk.html





From: rt-users [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Eierschmalz, Bernhard
Sent: Monday, April 04, 2016 4:01 AM
To: Dave Florek <dave.a.florek at gmail.com>
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Easy way to import a CSV file into ticketing?

Hello Dave,

I import many kinds of CSV-files with bash scripts and rt-cli – maybe this would be an idea for you!


Mit freundlichen Grüßen,
Best regards,

Bernhard

Von: rt-users [mailto:rt-users-bounces at lists.bestpractical.com] Im Auftrag von Dave Florek
Gesendet: Donnerstag, 31. März 2016 21:22
An: rt-users at lists.bestpractical.com
Betreff: [rt-users] Easy way to import a CSV file into ticketing?

Good afternoon,

If I have a CSV file full of information that I need to import into RT that's not an asset, is there an easy way to do this? I'm looking at the information posted in Postgresql for the database, and it looks doable, however I'm not sure if I can do it with the UIDs that RT generates.

Any ideas?

Sincerely,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20160404/7e214a67/attachment.htm>