Controlling application list outside of QC workflow?

  • Questions
  • Controlling application list outside of QC workflow?
Question ID: 108616
0
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 (Questions: 91, Answers: 6)
Asked on September 14, 2018 6:40 pm
5 views
Answers (1)
0
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 (Questions: 3, Answers: 466)
Answered on September 14, 2018 6:43 pm