RQM Excel Importer - Formating removed in Test Script Expected result, Description
Hi all,
I have a problem importing test script from a spreadsheet into RQM using the RQM Excel Import tool.
I attempt to import test script with steps(Description, Expected Result) to RQM from Excel. Import was successful but text formats(underlined, strike-through) are removed.
Eg:
This is my sample text
After import:
This is my sample text (underline was removed)
I tried below thing is configuration file:
testscript.steps.description= Pre(T)
testscript.steps.expectedResult= Pre(T)
and
testscript.steps.description= Div(T)
testscript.steps.expectedResult= Div(T)
But still the format is not preserved. What am I doing wrong ?
Thanks!
I have a problem importing test script from a spreadsheet into RQM using the RQM Excel Import tool.
I attempt to import test script with steps(Description, Expected Result) to RQM from Excel. Import was successful but text formats(underlined, strike-through) are removed.
Eg:
This is my sample text
After import:
This is my sample text (underline was removed)
I tried below thing is configuration file:
testscript.steps.description= Pre(T)
testscript.steps.expectedResult= Pre(T)
and
testscript.steps.description= Div(T)
testscript.steps.expectedResult= Div(T)
But still the format is not preserved. What am I doing wrong ?
Thanks!
2 answers
Hi Reshma,
Thanks for your answer.
I tried with RichText() , encountered an error.
My:
RQM Server Version: 5.0.2
RQMExcelimporter : 5.0.2.39710
Error:
************** Exception Text **************
System.Runtime.InteropServices.ExternalException: Requested Clipboard operation did not succeed.
at System.Windows.Forms.Clipboard.ThrowIfFailed(Int32 hr)
at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy, Int32 retryTimes, Int32 retryDelay)
at System.Windows.Forms.Clipboard.Clear()
at Mso2Rqm_Common.ArtifactFactory.converRangeToHtml(Range range)
at Mso2Rqm_Common.ArtifactFactory.getVal(String sCurRow, Worksheet worksheet, Target target)
at Mso2Rqm_Common.ArtifactFactory.reduceCells(Target[] lines, Worksheet worksheet, String sCurrentRow)
at Mso2Rqm_Common.ArtifactFactory.reduce(Target line, Worksheet worksheet, String sCurrentRow)
at Mso2Rqm_Common.ArtifactFactory.getVal(String sCurRow, Worksheet worksheet, Target target)
at Mso2Rqm_Common.ArtifactFactory.fillRefs(Worksheet currentWorksheet, Int32 iCurRow, PreferenceStore artifactDefs, String sType, Artifact artifact)
at Mso2Rqm_Common.ArtifactFactory.fixUpReferenceArts(Worksheet currentWorksheet, Int32 iCurRow, PreferenceStore artifactDefs, Artifact parentArt, Artifact refArt)
at Mso2Rqm_Common.ArtifactFactory.getArtifactsFromWorksheet(PreferenceStore artifactDefs, String sType, String origArtPath, Worksheet currentWorksheet, String& artPath, List`1 artsInWorksheet, Hashtable linksMap)
at Mso2Rqm_Common.ArtifactFactory.createArtifacts(String configFile, Workbook workbook, String sProjectName)
at RQMExcelExporter.ExcelExportRepositoryDialog.handleExportToRepository(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5485 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
RQMExcelImporter
Assembly Version: 5.0.2.39710
Win32 Version: 5.0.2.39710
CodeBase: file:///C:/Program%20Files%20(x86)/IBM/RQMExcelImporter/RQMExcelImporter.dll
----------------------------------------
Extensibility
Assembly Version: 7.0.3300.0
Win32 Version: 7.00.9466
CodeBase: file:///C:/Windows/assembly/GAC/Extensibility/7.0.3300.0__b03f5f7f11d50a3a/Extensibility.dll
----------------------------------------
Mso2Rqm_Common
Assembly Version: 5.0.2.39709
Win32 Version: 5.0.2.*
CodeBase: file:///C:/Program%20Files%20(x86)/IBM/RQMExcelImporter/Mso2Rqm_Common.DLL
----------------------------------------
Microsoft.Office.Interop.Excel
Assembly Version: 12.0.0.0
Win32 Version: 12.0.6600.1000
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.Office.Interop.Excel/12.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll
----------------------------------------
office
Assembly Version: 12.0.0.0
Win32 Version: 12.0.6425.1000
CodeBase: file:///C:/Windows/assembly/GAC/office/12.0.0.0__71e9bce111e9429c/office.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5485 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5491 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5491 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5485 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5483 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5491 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
CustomMarshalers
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5483 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
----------------------------------------
Thanks for your answer.
I tried with RichText() , encountered an error.
My:
RQM Server Version: 5.0.2
RQMExcelimporter : 5.0.2.39710
Error:
************** Exception Text **************
System.Runtime.InteropServices.ExternalException: Requested Clipboard operation did not succeed.
at System.Windows.Forms.Clipboard.ThrowIfFailed(Int32 hr)
at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy, Int32 retryTimes, Int32 retryDelay)
at System.Windows.Forms.Clipboard.Clear()
at Mso2Rqm_Common.ArtifactFactory.converRangeToHtml(Range range)
at Mso2Rqm_Common.ArtifactFactory.getVal(String sCurRow, Worksheet worksheet, Target target)
at Mso2Rqm_Common.ArtifactFactory.reduceCells(Target[] lines, Worksheet worksheet, String sCurrentRow)
at Mso2Rqm_Common.ArtifactFactory.reduce(Target line, Worksheet worksheet, String sCurrentRow)
at Mso2Rqm_Common.ArtifactFactory.getVal(String sCurRow, Worksheet worksheet, Target target)
at Mso2Rqm_Common.ArtifactFactory.fillRefs(Worksheet currentWorksheet, Int32 iCurRow, PreferenceStore artifactDefs, String sType, Artifact artifact)
at Mso2Rqm_Common.ArtifactFactory.fixUpReferenceArts(Worksheet currentWorksheet, Int32 iCurRow, PreferenceStore artifactDefs, Artifact parentArt, Artifact refArt)
at Mso2Rqm_Common.ArtifactFactory.getArtifactsFromWorksheet(PreferenceStore artifactDefs, String sType, String origArtPath, Worksheet currentWorksheet, String& artPath, List`1 artsInWorksheet, Hashtable linksMap)
at Mso2Rqm_Common.ArtifactFactory.createArtifacts(String configFile, Workbook workbook, String sProjectName)
at RQMExcelExporter.ExcelExportRepositoryDialog.handleExportToRepository(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5485 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
RQMExcelImporter
Assembly Version: 5.0.2.39710
Win32 Version: 5.0.2.39710
CodeBase: file:///C:/Program%20Files%20(x86)/IBM/RQMExcelImporter/RQMExcelImporter.dll
----------------------------------------
Extensibility
Assembly Version: 7.0.3300.0
Win32 Version: 7.00.9466
CodeBase: file:///C:/Windows/assembly/GAC/Extensibility/7.0.3300.0__b03f5f7f11d50a3a/Extensibility.dll
----------------------------------------
Mso2Rqm_Common
Assembly Version: 5.0.2.39709
Win32 Version: 5.0.2.*
CodeBase: file:///C:/Program%20Files%20(x86)/IBM/RQMExcelImporter/Mso2Rqm_Common.DLL
----------------------------------------
Microsoft.Office.Interop.Excel
Assembly Version: 12.0.0.0
Win32 Version: 12.0.6600.1000
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.Office.Interop.Excel/12.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll
----------------------------------------
office
Assembly Version: 12.0.0.0
Win32 Version: 12.0.6425.1000
CodeBase: file:///C:/Windows/assembly/GAC/office/12.0.0.0__71e9bce111e9429c/office.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5485 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5491 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5491 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5485 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5483 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5491 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
CustomMarshalers
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5483 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
----------------------------------------