I'm finally going to go live with SimpleDesk after much preparation. The next thing I need to do is to rig up some sort of rudimentary search capability. I don't know what the future of SimpleDesk development will be, and I don't have the skill to develop it myself, so I'm looking for ideas that will get it done in another way.
I thought I'd execute a SQL query that returns the ticket ID number, date, Username, Subject and body, and I'd dump that to a TXT file. Then I'd find some 3rd party TXT file search utility... something like this: http://www.sadmansoftware.com/search/
I could use that for searching the tickets on my local machine. It would show me the ticket ID as the first column, which I could then use to jump to the ticket.
Hmmm... for that matter, I could maybe just dump it into Excel for the searching, which would preserve the columnar format.
A drawback is that the search won't find data newer than my last data dump, though I don't see that as critical if I create a reasonably simple way to refresh the local data. Note that this isn't just for me but for the boss and the accountant in particular. They're not particularly computer savvy, and so this needs to be simple to do.
Another drawback is that our customers won't be able to search their own tickets. Only staff.
Anyway... if you've got ideas to do this in some other way, or if you know of a superior search utility for this, I'm anxious to hear what they are.