"No tickets found..." when trying to import tickets from CSV
I've followed the document here: http://www.kace.com/support/resources/kb/article/How-To-Use-Ticket-Rules-To-Import-Tickets-From to import tickets from our old helpdesk (Spiceworks) into KACE. I have verified all field names in the CSV and the asset type I created match what is in the documentation. I've also made sure that all the values in the CSV are mapped correctly and contain valid values. When I go to run the rule (step 4) and click on "View Ticket Search Results" for the Select Query it comes back with no tickets. Also when I click on "Run Now" I get "selected 0 rows." Any suggestions on what to try next?
Answers (2)
The FAQ for this should be updated now, check here: http://www.kace.com/uk/support/resources/kb/article/How-To-Use-Ticket-Rules-To-Import-Tickets-From-A-CSV-File
Comments:
-
I did get this to work and the document now is correct. - blainer 12 years ago
That article was written for version 5.1. It appears that it doesn't run for 5.3 as I get the same results:
45:55> Starting: Tue, 26 Aug 2012 11:45:55 -0400
45:55> Executing Select Query...
45:55> selected 0 rows
