Feature Request - Spiceworks ticket history import
-
I know I asked this before and this has been noted in another thread. But I figured I'd make it an official request. Ticket history import from spiceworks. I only need the info like email (user) and ticket data. Most of my users do not match to a machine in SW for some reason.
-
@wls-itguy said in Feature Request - Spiceworks ticket history import:
I know I asked this before and this has been noted in another thread. But I figured I'd make it an official request. Ticket history import from spiceworks. I only need the info like email (user) and ticket data. Most of my users do not match to a machine in SW for some reason.
I had that problem with SW too. I went to their support. They blew me off, saying that I must have been the only person having that problem. The problem didn't exist until I applied an update.
I suspect this could be done either through JSON export/import or csv export/import.
-
The problem with exporting tickets from Spiceworks, it is just not complete as you can see below:
https://community.spiceworks.com/support/help-desk/docs/import-ticketsIf you want the ticket data you need to run a report and then export it to CSV that includes the comments on each tickets.
Sometimes I use these reports:
From Yasaf Burshan
https://community.spiceworks.com/appcenter/app/shared_report_1214
From Ben at SW
https://community.spiceworks.com/appcenter/app/shared_report_961
-
@dbeato said in Feature Request - Spiceworks ticket history import:
The problem with exporting tickets from Spiceworks, it is just not complete as you can see below:
https://community.spiceworks.com/support/help-desk/docs/import-ticketsIf you want the ticket data you need to run a report and then export it to CSV that includes the comments on each tickets.
Sometimes I use these reports:
From Yasaf Burshan
https://community.spiceworks.com/appcenter/app/shared_report_1214
From Ben at SW
https://community.spiceworks.com/appcenter/app/shared_report_961Hmmm... if you have to export a specific format, that might be easy to ingest.
-
@scottalanmiller said in Feature Request - Spiceworks ticket history import:
@dbeato said in Feature Request - Spiceworks ticket history import:
The problem with exporting tickets from Spiceworks, it is just not complete as you can see below:
https://community.spiceworks.com/support/help-desk/docs/import-ticketsIf you want the ticket data you need to run a report and then export it to CSV that includes the comments on each tickets.
Sometimes I use these reports:
From Yasaf Burshan
https://community.spiceworks.com/appcenter/app/shared_report_1214
From Ben at SW
https://community.spiceworks.com/appcenter/app/shared_report_961Hmmm... if you have to export a specific format, that might be easy to ingest.
Yes it is as @NerdyDad stated JSON or CSV.
-
Yep, I'm here taking some notes, might be time to raise the priority on this request. Definitely not the first time this has been requested. Let me think this over in the morning.
-
@quixoticjeremy said in Feature Request - Spiceworks ticket history import:
Yep, I'm here taking some notes, might be time to raise the priority on this request. Definitely not the first time this has been requested. Let me think this over in the morning.
Back around 4.5, they were using nosql for the database. If they still are, I bet that file wouldn't be to hard to parse. I'd offer to take a look myself, but I don't have an install available, and I'm not going to pay for a server license just for that.
-
@travisdh1 said in Feature Request - Spiceworks ticket history import:
@quixoticjeremy said in Feature Request - Spiceworks ticket history import:
Yep, I'm here taking some notes, might be time to raise the priority on this request. Definitely not the first time this has been requested. Let me think this over in the morning.
Back around 4.5, they were using nosql for the database. If they still are, I bet that file wouldn't be to hard to parse. I'd offer to take a look myself, but I don't have an install available, and I'm not going to pay for a server license just for that.
You can install it on anything. If you are not using it, you never violate any license agreements.
Also MS has 6 month trials of all server operating systems.
-
@travisdh1 said in Feature Request - Spiceworks ticket history import:
@quixoticjeremy said in Feature Request - Spiceworks ticket history import:
Yep, I'm here taking some notes, might be time to raise the priority on this request. Definitely not the first time this has been requested. Let me think this over in the morning.
Back around 4.5, they were using nosql for the database. If they still are, I bet that file wouldn't be to hard to parse. I'd offer to take a look myself, but I don't have an install available, and I'm not going to pay for a server license just for that.
They are using SQLite still
-
@travisdh1 said in Feature Request - Spiceworks ticket history import:
@quixoticjeremy said in Feature Request - Spiceworks ticket history import:
Yep, I'm here taking some notes, might be time to raise the priority on this request. Definitely not the first time this has been requested. Let me think this over in the morning.
Back around 4.5, they were using nosql for the database. If they still are, I bet that file wouldn't be to hard to parse. I'd offer to take a look myself, but I don't have an install available, and I'm not going to pay for a server license just for that.
It's always been relational, that never changed.
-
I do know 2 things about this:
- They did release a diagram of the database a few years ago
- I deleted my copy when I got off of SpiceWorks.
-
@nerdydad said in Feature Request - Spiceworks ticket history import:
I do know 2 things about this:
- They did release a diagram of the database a few years ago
- I deleted my copy when I got off of SpiceWorks.
See the diagram below:
https://static.spiceworks.com/attachments/post/0016/8600/database_schema_diagram.pdfMore information here:
https://community.spiceworks.com/support/desktop/troubleshooting/sql-reports
-
Maybe these will help you:
https://community.spiceworks.com/topic/1995291-importing-csv-with-custom-attributes
Keep in mind there are two ways to import: through the GUI or via the script that some of these posts mention.
I was actually writing a blog about this but stopped because someone at SW corrected my thought process (I had made some errors in it that needed correcting).
If you PM me, I will e-mail you a PDF of that unfinished post and comments from SW support on it.
