Export tickets as .csv (version 5.3)

richyaydon9621 · 2013-07-02T08:47:42.000Z

So, as you can probably see, we’re running a prehistoric version of spiceworks, developed by Neanderthals just after the meteor hit Earth, and we’re looking to upgrade soon!

My issue is that we’ve got a load of tickets that we want to copy over, but the plan will probably be to build a new Spiceworks installation and not have it clogged up with the inventory and other settings that bothered the current install. I’ve tried taking the db part of our backup and restoring it into the new install, but this copies just about everything over, user accounts, inventory, helpdesk tickets, all settings, user portal design… I don’t really want this much here.

I’ve already tried looking through the forums here and I’ve seen some suggestions, but a lot of it is quite recent and our version of Spiceworks is nearing antique. None of the SQL reports recommended aren’t working and I’m not comfortable poking around the raw database to extract the appropriate tables unless someone is willing to give me a full on idiot proof tutorial on doing it using a DB from the backups, rather than production.

Does anybody have any experience or leftover old reports to do this from around the 5.3 time?

antonyrowell · 2013-07-02T08:51:29.000Z

Could you not just backup your current db and copy it over the new one that’s created when you install Spiceworks for the first time ?

antonyrowell · 2013-07-02T08:52:30.000Z

http://community.spiceworks.com/how_to/show/207-import-tickets-into-spiceworks-from-a-csv-file?utm_campaign=app_general&utm_medium=app&utm_source=app_ui

richyaydon9621 · 2013-07-02T08:53:31.000Z

I think I’ve tried that… Everything is in 1 DB, so I get the inventory and a lot of other things coming through, that I don’t want.

I suppose I could go through and clear everything out that I don’t want, manually, but it overwrites just about everything I’ve done and basically pisses the time spent on the test server down the drain.

antonyrowell · 2013-07-02T08:56:43.000Z

From the looks of it, that just deals with the tickets side of it as the script you run just imports tickets

richyaydon9621 · 2013-07-02T08:56:57.000Z

And that’s just importing tickets in - I need to get them out, unfortunately.

antonyrowell · 2013-07-02T09:00:27.000Z

Yeah it mentions copying them from another database with a backup, so you could backup your current db, install Spiceworks where you like it, move the DB on to that server but not over the db then run the import script maybe

richyaydon9621 · 2013-07-02T09:01:56.000Z

One of the first things it says is that you need a CSV file with the data you want to import. Doesn’t have anything on extracting that data…

Thanks anyway, mate! I’ll have to keep digging