Forum Discussion

Igni's avatar
Igni
New Contributor
9 years ago
Solved

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

CGangloff's avatar
CGangloff
Moderator

Hello Igni,

 

Yes you can create a Custom Field for the execution time, but you cannot export just that one particular field.

You would do an export of all fields and simply remove the not needed columns. Please see my example video

attached and let me know if you have any other questions.

 

Best Regards,
Christiane

Igni's avatar
Igni
New Contributor
9 years ago

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