Controlling application list outside of QC workflow?
| ♥ 0 |
We are looking for a way to be able to change the application list used for defects outside of the QC workflow. Application values change frequently, and updating the list across hundreds of projects is time consuming. We have tried to read from a file on a shared drive location to populate the list, but this has proven to be flaky and is impacting the user experience.
Marked as spam
|
Posted by |
Private answer
This is a classic issue, and it can be solved through workflow by reading in a flat (csv) file, but may be slow or sometimes inaccessible. You could try using an ODBC connection (DSN stored on machine doing reading), and point it to an Excel spreadsheet or a DB that also lives on the same SQL-Server as the QC Projects. We do NOT recommend storing additional tables or columns inside your QC-related Databases. We also do not recommend direct manipulation of data in those databases. Here are some posts related to the issue and some coding ideas: https://community.softwaregrp.com/t5/Quality-Center-ALM-User/Getting-data-from-excel-via-qc-workflow/m-p/1078582 https://stackoverflow.com/questions/3117121/reading-and-writing-value-from-a-textfile-by-using-vbscript-code https://www.experts-exchange.com/questions/26826803/VBscript-read-data-from-input-file-and-from-a-specific-column.html Marked as spam
 Posted by pt-barnum (Questions: 4, Answers: 509) Answered on September 14, 2018 6:43 pm
|