Exporting Test results from Excel
Can I do the following:
1. Export test sets (along with all steps of all test cases) to Excel?
2. Update the execution results in Excel and upload them back in to Test Director?
Re: Exporting Test results from Excel
I have exported test sets (along with all steps of all test cases) into Excel via ODBC. I did not have read access via ODBC to the Oracle server so I created a local MSAccess database instead.
I used it to produce my own pivottable reports as TD reports did not address the level I needed. I ended up spend a whole night to dawn session reverse engineering the tables so I could maintain the hierachy in excel.
I never did update spreadsheet ans see if the the MS Access database was also updated but it should work whetehre its Access, Oracle or whatever.
Suggest you test it and create a local MS Access copy of your TD database, connect via ODBC and update a number of fields and see if they are also updated in Access.
If this works then it would / should work with direct ODBC to any database.
My main conern doing this would be data integrity as you may corrupt your database so test test test. Good luck