/build/static/layout/Breadcrumb_cap_w.png

Tickets import from legacy system

We've been migrating from SpiceWorks to KACE and decided initially not to do an import of legacy tickets, but start with a clean slate. Since then, we would like to get rid of the old Spiceworks database and decommission the old server it is on and would like to import the tickets as an archive into a separate KACE service desk queue for research and archive purposes.

I have been searching for a document on importing from a 3rd party system and found this:

http://www.kace.com/support/resources/kb/article/how-to-use-ticket-rules-to-import-tickets-from-a-csv-file

However, it has a version warning "This process will only work for K1000 series running software version 5.1.31327 to 5.3.53053."

We are on K1000 Systems Management Appliance v5.4.76847

Also I do not find a walk thru of the process in the admin guide.

Does anyone have a link or tip or document they can point me to that I am missing?

Thanks in advance, and as always.


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: nshah 10 years ago
Red Belt
2

Techically there is no way to import tickets into the KBOX helpdesk via the GUI. Some people export out of their current solutioin and import into assets management as a reference area for old tickets.

Some tried the link you provide on 5.4 and seems to work

http://www.itninja.com/question/importing-tickets-with-5-4

Dell offer professional services to do this as well on the backend. 


Comments:
  • OK, thanks for the help and additional link! - jschu67 10 years ago
Posted by: Wildwolfay 10 years ago
Red Belt
0

I've written a blog in regards to this.  The process DOES work (mostly) but you have to modify the insert into statement on HD_TICKET_CHANGE ticket rule (the first rule you run after your tickets have been turned into assets.)

 

http://www.itninja.com/blog/view/update-to-the-faq-for-importing-tickets-into-kace


Comments:
  • I have an additional question - how does KACE service desk handle ATTACHMENTS? I do not see any handling for importing attachments that were added as comments from the legacy system, and am wondering if anyone has any thoughts or assistance for that issue. Where do Attachments live in the directory structure of the KACE server? And if I know the directory structure, could I just copy over the directory structure from the old ticket system (which is just basically: ...\ticket no\attachment.doctype ) and then concatenate in a fully qual. url of the path to the attachment? Would that create a link in the Service desk comment?

    Thanks. - jschu67 10 years ago
    • It's not pretty:

      You have to get a patch from KACE support to unlock your attachments share drive. Once you can access them it gets ugly.

      The attachments are saved under folders that are named after their HD_TICKET_CHANGE.ID number. Now: without going into the database and physically looking at the hd_ticket_change data tables there really is no way to connect the ticket ID with the hd_ticket_change id. Unless you develop some kind of file moving service that queries the database, gets the TICKET ID for that folders HD_TICKET_CHANGE id and generates a folder and places it there.


      atleast this is what I've experienced :/ - Wildwolfay 10 years ago
      • Aha. Thank you for your information. Now we know why they offer professional services.... 8-/ - jschu67 10 years ago
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ