How to remove the <html> tags from extracted test scripts in excel for Silk Central v19 - Micro Focus Community

Lynda321 · ‎2019-06-24

Hello,
Hoping you could assist? We are trying to extract test scripts from Silk Central v19 into excel, but the extracted scripts are embedded in <html> tags, and is totally unreadable.

Is there a tool or function available for Silk v19 we could use to remove all the <html> tags from the exported test scripts ?

Hubert Inreiter · ‎2019-06-26

Hi @Lynda321

Do you use the action "Export to Excel" for the export? This action does not change the HTML formatting to allow you to use the Excel file for import/update with the same description.

Could you give some more background? What do you do with the exported tests/steps?

Regards,
Hubert

Lynda321 · ‎2019-06-27

Hi @Hubert Inreiter

Yes, we are using the "Export to Excel" option. We have noticed that this issue occurs when the scripts being exported from Silk contains any type of font formats e.g. bold, underline, italics, tables, bullet points etc. The <html> tags then appears within all the exported scripts.

Is there a tool or query we could use to remove all of these <html> tags ?

Hubert Inreiter · ‎2019-07-15

Hi @Lynda321 ,

What do you do with the exported tests?

I ask because there is no such tool within SC. However, if you want to run these tests, you could use the download for offline execution function in the "Manual Tests Assigned to Me" panel. This will create an Excel for a running test with the tags removed.

Regards,

Hubert

rjf · ‎2019-07-22

We just upgraded to Silk Central v20 an I was hoping there was a better answer for this since we would like to review the tests before they are deployed in order to update the test cases before they are added to an execution plan and deployed.

There are other issues created when you export to run manually -- another run id is created when you update the test cases online and then metrics get all messed up with two instances per test.

I thought I saw a comment that a fix for this was going to be part of the 15.5 upgrade but apparently not. Is there an option in Excel that would let you reformat that column?