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! |
2 answers
Hi Dinesh,
Try using RichText modifier instead https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Modifiers_of_data_Used_to_the_ri |
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 ---------------------------------------- |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.