ML
    • Register
    • Login
    • Search
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups

    Feature Request - Spiceworks ticket history import

    SodiumSuite
    8
    13
    1135
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • WLS-ITGuy
      WLS-ITGuy last edited by WLS-ITGuy

      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.

      NerdyDad 1 Reply Last reply Reply Quote 2
      • NerdyDad
        NerdyDad @WLS-ITGuy last edited by

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

        1 Reply Last reply Reply Quote 0
        • dbeato
          dbeato last edited by

          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-tickets

          If 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

          scottalanmiller 1 Reply Last reply Reply Quote 1
          • scottalanmiller
            scottalanmiller @dbeato last edited by

            @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-tickets

            If 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

            Hmmm... if you have to export a specific format, that might be easy to ingest.

            @QuixoticJeremy

            dbeato 1 Reply Last reply Reply Quote 1
            • dbeato
              dbeato @scottalanmiller last edited by

              @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-tickets

              If 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

              Hmmm... if you have to export a specific format, that might be easy to ingest.

              @QuixoticJeremy

              Yes it is as @NerdyDad stated JSON or CSV.

              1 Reply Last reply Reply Quote 0
              • QuixoticJeremy
                QuixoticJeremy last edited by

                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.

                travisdh1 1 Reply Last reply Reply Quote 0
                • travisdh1
                  travisdh1 @QuixoticJeremy last edited by

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

                  JaredBusch dbeato scottalanmiller 3 Replies Last reply Reply Quote -1
                  • JaredBusch
                    JaredBusch @travisdh1 last edited by

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

                    1 Reply Last reply Reply Quote 0
                    • dbeato
                      dbeato @travisdh1 last edited by

                      @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 🙂

                      1 Reply Last reply Reply Quote 2
                      • scottalanmiller
                        scottalanmiller @travisdh1 last edited by

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

                        1 Reply Last reply Reply Quote 0
                        • NerdyDad
                          NerdyDad last edited by

                          I do know 2 things about this:

                          1. They did release a diagram of the database a few years ago
                          2. I deleted my copy when I got off of SpiceWorks.
                          dbeato 1 Reply Last reply Reply Quote 1
                          • dbeato
                            dbeato @NerdyDad last edited by

                            @nerdydad said in Feature Request - Spiceworks ticket history import:

                            I do know 2 things about this:

                            1. They did release a diagram of the database a few years ago
                            2. 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.pdf

                            More information here:
                            https://community.spiceworks.com/support/desktop/troubleshooting/sql-reports

                            1 Reply Last reply Reply Quote 1
                            • NetworkNerd
                              NetworkNerd last edited by

                              Maybe these will help you:

                              https://community.spiceworks.com/topic/1995291-importing-csv-with-custom-attributes

                              https://community.spiceworks.com/how_to/67984-spiceworks-v7-importing-new-tickets-from-csv-including-assigned_to

                              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.

                              1 Reply Last reply Reply Quote 3
                              • First post
                                Last post