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