Can you import new data into existing tickets
We are adding some new fields to our Service Desk screens. Is it possible to use a .csv file to upload values for the new fields in the old tickets?
Answers (4)
In short No, not directly anyway.....
The only way to do this is to create a dummy asset type as HELPDESK_DATA or whatever
Add to the asset type how ever many fields you need, make sure one of the field is the Ticket ID.
Then use the Asset Import functionality to import the data.
Finally create a ticket rule to copy the data from the Asset table into the Ticket table, when the ID is the asset field is the same as the Ticket ID in the asset field.
Finally clear up by deleting all your HELPDESK_DATA assets and then the asset type itself
Indigo Mountain is a Quest Silver + partner, operates as KACE professional services in the UK market place and has over a decade of KACE Service delivery
Top Answer
Yes, but you have to know SQL pretty good or else you can mess up your data.
First, you would need to create an Asset Type that would contain your Ticket ID and the columns of data you want to update and upload the CSV to the Asset
Next you would need to use a query tool to connect to the KACE database to find the ASSET_DATA_XXXXX table that was created for your data.
Next, create an update query for updating the HD_TICKET fields you want to update.
Lastly you create a new Ticket Rule using SQL where your Select rule returns 1 result (Like Select HD_TICKET.ID From HD_TICKET Where HD_TICKET.ID = 1) and the update query would be the query you designed to update the values. Run the rule to update the tickets.