Forum Discussion

Igni's avatar
Igni
New Contributor
9 years ago

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...
  • CGangloff's avatar
    CGangloff
    9 years ago

    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, Ok

     

    Please 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

Igni's avatar
Igni
New Contributor

Hello Christiane,

 

your video doesn`t help. There are 2 problems with your solutions.

A) When we export listed test. we don`t have such nice table. We don`t get every field into seperate column, but they are all in one column for every testp step, only separated by comma. So it`s more work to edit the table to some usable form, than to copy listing view into excell manually.

B) We wanted to use excel than to sum execution time from all the test in listed view, but with your solution, we can´t use that, as the time is duplicated by test steps. I know, we could than delete all the steps but one for every test, but this would again make this solutions useless, as it would be as time demanding as present system we are using.

 

Imagine, you have 30 * 100 tests, 10 steps each. We need fast solution, so we could for every one group from these 30 get time execution for all it`s tests (medium 100 of them). We wanted to make it more user friendly for test garants, so they could only updated execution time for changed test and QAC administrator would easilly export those execution times and sum them, so we could get execution time for whole set of test.

 

Thanks for any more ideas for this problems.

 

Igni 

CGangloff's avatar
CGangloff
Moderator
9 years ago

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, Ok

 

Please 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

  • Igni's avatar
    Igni
    New Contributor
    9 years ago

    Hello Christiane,

     

    thank you very much for your replay. This is not as fast and easy as I would like, but it´s definitly solution for our problem and we will probably use your instructions to make execution time estimation more easier.

     

    Have a nice day,

     

    Igni