It's all about the answers!

Ask a question

RQM Excel Importer - Formating removed in Test Script Expected result, Description


Dinesh Sivaji (111) | asked Sep 22 '15, 6:00 a.m.
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



permanent link
Reshma Ratnani (1.1k1) | answered Sep 22 '15, 7:31 a.m.
JAZZ DEVELOPER
Hi Dinesh,

Try using RichText modifier instead

https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Modifiers_of_data_Used_to_the_ri

permanent link
Dinesh Sivaji (111) | answered Sep 22 '15, 7:57 a.m.
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


Register or to post your answer.