Hello,
I am pulling data out of saved searches in RT (http://bestpractical.com/rt/) and importing them into excel. I need to do 2 things:
1. (most difficult) Figure out a way to automate the importing of multiple .tsv files (RT output) into excel spreadsheets on a weekly and monthly basis. There is an excel extension for RT, but it has a known unresolved bug where it pulls all fields and not just what is contained in the saved search display. I'm trying to simplify things by just automating the import once I've pulled the .tsv files. I've recorded a macro to open the file, but would like to automate it for multiple files into multiple worksheets.
2. Once in excel I need to perform calculations on dates. I have tried to format the date many different ways, but cannot get this to work. The default date format coming out of RT is Tue Apr 30 08:50:25 2013. The format once imported into excel is "general". I need to be able to do time and date calculations. (ie figure out the difference in time and days) My end goal is to use conditional formatting automate the coloring of cells to reflect whether an issue was addressed in the right amount of time based on agreed upon service levels.
I hope I didn't leave anything out. Please let me know if any more info is needed.
Thanks...
Bookmarks