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

    Feature Request - Spiceworks ticket history import

    SodiumSuite
    8
    13
    1.5k
    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.
    • NerdyDadN
      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
      • dbeatoD
        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

        scottalanmillerS 1 Reply Last reply Reply Quote 1
        • scottalanmillerS
          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

          dbeatoD 1 Reply Last reply Reply Quote 1
          • dbeatoD
            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
            • QuixoticJeremyQ
              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.

              travisdh1T 1 Reply Last reply Reply Quote 0
              • travisdh1T
                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.

                JaredBuschJ dbeatoD scottalanmillerS 3 Replies Last reply Reply Quote -1
                • JaredBuschJ
                  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
                  • dbeatoD
                    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
                    • scottalanmillerS
                      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
                      • NerdyDadN
                        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.
                        dbeatoD 1 Reply Last reply Reply Quote 1
                        • dbeatoD
                          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
                          • NetworkNerdN
                            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
                            • 1 / 1
                            • First post
                              Last post