Can I export custom field from test for all shown tests?
Hello,
we are playing with idea to make estimating test execution times for whole set of test, after they´ve been updated, easier and less time consuming in our company.
We are working with idea, to make custom field in QAComplete, where test owner will fill execution time for every test. Than, he can just update this custom field, whenever the test is changed. We just need to somehow be able to export this particular custom field for all shown tests (based on filter or folder) into excel file (or some other text file), so we can easily sum all the values and see the final execution time for whole field of test.
Is there any way, to easily export this particular custom field for all the tests at once? Or at least export all the fields in the way, that this particular custom field will be in one excel column, so we can work with it further?
Thanks for any suggestions
Hello Igni,
Thank you for your reply and the information. There is a known Comma and Semicolon Issue in Excel due to Regional Settings when opening CSV files.
What you could do is add your custom field
- Run the 'Ad-hoc Detail - Test Library Report'
- Select the columns you need including your custom field but don't add any Steps columns
-- The system generates a comma separated text file
-- Once you generate the .csv file, save it as a plain text file
-- Open up Excel
-- Go to the Data tab and select From Text which allows you to specify the delimiter when you open the text file
-- Try to select 'Delimited' > Next > uncheck the 'Tab' and check the 'Comma' field > Next, Finish, OkPlease visit: https://akbaraji.wordpress.com/2012/05/29/the-comma-and-semicolon-issue-in-excel-due-to-regional-settings-when-open-csv-file/ for more information regarding the Comma and Semicolon Issue in Excel Due to Regional Settings when opening CSV files.
Thank you,
Christiane