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_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.
