4
Vote

Wrong format in the outcome excel file

description

:

"1.<HTML><BODY><P><SPAN>Use TimDb; Select DiscountCashValue from TimDb.dbo.Discount_Value where SaleChannel = 2 and DiscountVersionId = (senaste) and paycode = 4</SPAN></P></BODY></HTML>
2.<HTML><BODY><OL STYLE=""margin:0;padding:0;""><LI><P STYLE=""text-align:left;font-size:14.6666666666667px;font-family:calibri;margin:0 0 1 0;""><SPAN>UseTimDb; Select TariffVer from TimDb.dbo.Tariff_version where TariffVer = (select max(TariffVer))</SPAN></P></LI></OL></BODY></HTML>"

All the cells in the columns Action and Expected Result shows the above format but not
the Title and other columns.

I hope I can get some help about this issue.

comments

jorXant wrote Mar 22, 2013 at 10:48 AM

I forgot to say that we are using TFS 2012 at my company but I'm using MTM 2010 when writing my test cases. Perhaps is this a compatibilty issue because the tool worked nice before we migrated to TFS 2012.

wrote Jun 19, 2013 at 5:33 PM

shwetapatwardhan wrote Jul 8, 2013 at 9:24 PM

I am having the same issue. My exported test cases have HTML code in action and expected results.
I am using VSTF 2012 Ultimate along with MTM 2012. We have not gbeen able to use the extractor to extract test cases from MTM. Please help us with this issue.
Here is the snippet from action:
1.<steps id="0" last="3"><step id="1" type="ValidateStep"><parameterizedString isformatted="true"><DIV><P>1. Turn ON the 3 Emergency Messages in the Configuration Manager. Set C2C_Deflect in 1st slot, Chat deflection in 2nd slot and ForgotLiveID in 3rd EM slot. Deploy the configuration. </P></DIV></parameterizedString><parameterizedString isformatted="true"><DIV><P>1. CM with 3 EMs ON deployed. </P></DIV></parameterizedString><description></description></step><step id="2" type="ValidateStep"><parameterizedString isformatted="true"><DIV><P>2. Dial in the UAT TFN, enter 10 digit ANI, enter DNIS 75328</P></DIV></parameterizedString><parameterizedString isformatted="true"><DIV><P>2. أه

wrote Jul 8, 2013 at 9:25 PM

wrote Aug 21, 2013 at 7:54 AM

daria_l wrote Jan 5, 2014 at 11:19 PM

I also have the same problem. Here is the python-script solving formating problem
https://github.com/s1ider/tfs-export-parser/blob/master/parse_tfs.py
Put the resulted excel-file with the wrong "steps" column to the folder with the script, check if the name of the input excel-file correspond to that in the script and run it.