XML generator for TL 1.9

[amkhullar]

Please find attached an XML generator for TL 1.9.5 , you can now write etst cases in XLS and then use this file to generate the XML for importing in the TL 1.9.5 version. Bugs welcome. mail@ amkhullar@gmail.com http://rapidshare.com/files/407777959/Test_Case_Template_-_TL.xls.html

[fman]

please open an issue on mantis and attach your code there

[amkhullar]

its an xls file with macro written in the background. No other source code.

[aksinghv]

Hi Amit,

The excel file is indeep very useful. You have saved my day. But, iMHO can you have the help about each column in the excel file? This way people can understand and use the excel file.

Regards,
Anjani Singh

[amkhullar]

HI Anjani,

I am planning to include this file in 1.9RC and will put a proper help along. Busy as of now with some major release in my company.

Thanks
Amit

[aksinghv]

Hi Amit,

Appreciate your effort. Will wait for 1.9RC.

Regards,
Anjani Singh

[aksinghv]

Hi Amit,

Now i see the CVS code to GA -Development build. Can you let me know when this would be available in the TL1.9?
If not possible to add, could you at least have a write up for usage.


Regards,
Anjani Singh

[threv]

Greetings!

I installed TL 1.9.5 on top of Windows Server 2003 using "UniformServer", a WAMP bundle:
http://www.uniformserver.com/

I have successfully installed and set up TL 1.9.5

I'm using MS Excel 2007.

I used the XML Generator noted in this thread, and clicked "Generate XML" (Note - I had to removed a missing reference in Tools -> References in the Visual Basic editor. When I ran "Generate XML" for the first time, I got a compile error that the macro is missing a library. I went to Tools -> References, and there was an entry for "MISSING: Microsoft Word 14.0 Object Library". When I unchecked that & ran "Generate XML" again, the XML was generated.)

I then went to TestLink, and created an "Import XML" Project. I navigated to Test Specification, clicked the empty "XML Import" link in the Test Specification left-hand pane. On the resulting right pane, I clicked "Import". I selected the generated XML: TestSuite-TL.xml. When I clicked "Upload File", a message box appeared saying: "Warning!! xml_load_ko", and was unable to upload the XML file.

I'm attaching the generated XML file below for debugging.

Thanks for your time, and keep up the great work.


====================================================================
TestSuite-TL.XML:

<?xml version="1.0" encoding="UTF-8"?>
<testcase name="PSLMCLXXX-1">
<summary><![CDATA[Test that we can connect and disconnect multiple client for same service e.g. SERVICE_SE_BIN simultaneously]]></summary>
<execution_type><![CDATA[2]]></execution_type>
<steps>
<step>
<step_number><![CDATA[1]]></step_number>
<actions><![CDATA[ Create N ps clients for SERVICE_CAE_BIN.]]></actions>
<expectedresults><![CDATA[ N number of clients should be connected to PS Server.]]></expectedresults>
</step>
<step>
<step_number><![CDATA[2]]></step_number>
<actions><![CDATA[ Connect these N clients simaultanesouly to ps server.]]></actions>
<expectedresults><![CDATA[ After Disconnecting all the cleints should be disconnected properly.and Socket should be closed by PS Server]]></expectedresults>
</step>
<step>
<step_number><![CDATA[3]]></step_number>
<actions><![CDATA[ Now Disconnect these N clients]]></actions>
<expectedresults><![CDATA[ ]]></expectedresults>
</step>
</steps>
<keywords>
<keyword name="Stress"><notes><![CDATA[Stress]]></notes></keyword>
<keyword name=" LoadTest"><notes><![CDATA[ LoadTest]]></notes></keyword>
</keywords>
<custom_fields>
<custom_field>
<name><![CDATA[Sanity]]></name>
<value><![CDATA[Yes]]></value>
</custom_field>
<custom_field>
<name><![CDATA[Feature ID]]></name>
<value><![CDATA[GRE-340]]></value>
</custom_field>
<custom_field>
<name><![CDATA[CF_ESTIMATED_EXEC_TIME]]></name>
<value><![CDATA[50]]></value>
</custom_field>
</custom_fields>
<requirements>
<requirement>
<req_spec_title><![CDATA[Requirement Title 1]]></req_spec_title>
<doc_id><![CDATA[Req 1.1]]></doc_id>
<title><![CDATA[Title of Req 1.1]]></title>
</requirement>
<requirement>
<req_spec_title><![CDATA[Requirement Title 1]]></req_spec_title>
<doc_id><![CDATA[Req 1.2]]></doc_id>
<title><![CDATA[Title of Req 1.2]]></title>
</requirement>
<requirement>
<req_spec_title><![CDATA[Requirement Title 2]]></req_spec_title>
<doc_id><![CDATA[Req 2.1]]></doc_id>
<title><![CDATA[Title of Req 2.1]]></title>
</requirement>
</requirements>
</testcase>
<testcase name="PSLMCLXXX-2">
<summary><![CDATA[Test that we can connect and disconnect multiple client of different service]]></summary>
<preconditions><![CDATA[PSLMCLXXX-1]]></preconditions>
<execution_type><![CDATA[2]]></execution_type>
<steps>
<step>
<step_number><![CDATA[1]]></step_number>
<actions><![CDATA[ Create N, M ps clients for SERVICE_CAE_BIN and SERVICE_SE_BIN respectively.]]></actions>
<expectedresults><![CDATA[ N, M number of clients for CAE and SE should be connected to PS Server.]]></expectedresults>
</step>
<step>
<step_number><![CDATA[2]]></step_number>
<actions><![CDATA[ Connect these N,M clients simaultanesouly to ps server.]]></actions>
<expectedresults><![CDATA[ After Disconnecting all the cleints should be disconnected properly and socket should be closed by PS Server]]></expectedresults>
</step>
<step>
<step_number><![CDATA[3]]></step_number>
<actions><![CDATA[ Now Disconnect these N,M clients]]></actions>
<expectedresults><![CDATA[ ]]></expectedresults>
</step>
</steps>
<keywords>
<keyword name="Stress"><notes><![CDATA[Stress]]></notes></keyword>
<keyword name=" LoadTest"><notes><![CDATA[ LoadTest]]></notes></keyword>
</keywords>
<custom_fields>
<custom_field>
<name><![CDATA[Regression]]></name>
<value><![CDATA[Yes]]></value>
</custom_field>
<custom_field>
<name><![CDATA[Feature ID]]></name>
<value><![CDATA[GRE-341]]></value>
</custom_field>
<custom_field>
<name><![CDATA[CF_ESTIMATED_EXEC_TIME]]></name>
<value><![CDATA[120]]></value>
</custom_field>
</custom_fields>
<requirements>
<requirement>
<req_spec_title><![CDATA[Requirement Title 1]]></req_spec_title>
<doc_id><![CDATA[Req 1.2]]></doc_id>
<title><![CDATA[Title of Req 1.2]]></title>
</requirement>
</requirements>
</testcase>
<testcase name="PSLMWMRXXX-1">
<summary><![CDATA[Verify that all the modules like cae, se etc, can read and write bins simultaneously.]]></summary>
<preconditions><![CDATA[PSLMCLXXX-2]]></preconditions>
<execution_type><![CDATA[2]]></execution_type>
<steps>
<step>
<step_number><![CDATA[1]]></step_number>
<actions><![CDATA[Create ServerSocket for writing bins of each service type say caeServer, seServer etc.]]></actions>
<expectedresults><![CDATA[PS should be able to read bins of each service type requested and able to write each bin sent by each ps client.]]></expectedresults>
</step>
<step>
<step_number><![CDATA[2]]></step_number>
<actions><![CDATA[Create psClients for each service type say caeClient, seClient.]]></actions>
<expectedresults><![CDATA[PS should be able to send bins requested by each client.]]></expectedresults>
</step>
<step>
<step_number><![CDATA[3]]></step_number>
<actions><![CDATA[Call requestPersistence for each client and start sending bins of each service type thorugh their respective ServerSocket created in step#]]></actions>
<expectedresults><![CDATA[All the bins of each type retrieved should be same as written.]]></expectedresults>
</step>
<step>
<step_number><![CDATA[4]]></step_number>
<actions><![CDATA[Call requestRetrieval for each ps client and start retrieving bins ]]></actions>
<expectedresults><![CDATA[ ]]></expectedresults>
</step>
</steps>
<keywords>
<keyword name="Stress"><notes><![CDATA[Stress]]></notes></keyword>
<keyword name=" LoadTest"><notes><![CDATA[ LoadTest]]></notes></keyword>
</keywords>
<custom_fields>
<custom_field>
<name><![CDATA[Sanity]]></name>
<value><![CDATA[Yes]]></value>
</custom_field>
<custom_field>
<name><![CDATA[CF_ESTIMATED_EXEC_TIME]]></name>
<value><![CDATA[30]]></value>
</custom_field>
</custom_fields>
<requirements>
<requirement>
<req_spec_title><![CDATA[Requirement Title 1]]></req_spec_title>
<doc_id><![CDATA[Req 1.1]]></doc_id>
<title><![CDATA[Title of Req 1.1]]></title>
</requirement>
<requirement>
<req_spec_title><![CDATA[Requirement Title 1]]></req_spec_title>
<doc_id><![CDATA[Req 1.2]]></doc_id>
<title><![CDATA[Title of Req 1.2]]></title>
</requirement>
</requirements>
</testcase>
<testcase name="PSLMWMRXXX-2">
<summary><![CDATA[Verify that all the modules like cae, se etc, can read and write bins simultaneously.]]></summary>
<preconditions><![CDATA[PSLMWMRXXX-1]]></preconditions>
<execution_type><![CDATA[1]]></execution_type>
<steps>
<step>
<step_number><![CDATA[1]]></step_number>
<actions><![CDATA[ Now Disconnect these N,M clients]]></actions>
<expectedresults><![CDATA[ Now Disconnect these N,M clients]]></expectedresults>
</step>
</steps>
<keywords>
<keyword name="Functional"><notes><![CDATA[Functional]]></notes></keyword>
</keywords>
<custom_fields>
<custom_field>
<name><![CDATA[Feature ID]]></name>
<value><![CDATA[GRE-341]]></value>
</custom_field>
<custom_field>
<name><![CDATA[CF_ESTIMATED_EXEC_TIME]]></name>
<value><![CDATA[35]]></value>
</custom_field>
</custom_fields>
<requirements>
<requirement>
<req_spec_title><![CDATA[Requirement Title 1]]></req_spec_title>
<doc_id><![CDATA[Req 1.2]]></doc_id>
<title><![CDATA[Title of Req 1.2]]></title>
</requirement>
</requirements>
</testcase>
<testcase name="PSLMWMRXXX-3">
<summary><![CDATA[Verify that all the modules like cae, se etc, can read and write bins simultaneously.]]></summary>
<execution_type><![CDATA[1]]></execution_type>
<steps>
<step>
<step_number><![CDATA[1]]></step_number>
<actions><![CDATA[ Now Disconnect these N,M clients]]></actions>
<expectedresults><![CDATA[ Now Disconnect these N,M clients]]></expectedresults>
</step>
</steps>
<keywords>
<keyword name="API"><notes><![CDATA[API]]></notes></keyword>
</keywords>
<custom_fields>
<custom_field>
<name><![CDATA[Regression]]></name>
<value><![CDATA[Yes]]></value>
</custom_field>
<custom_field>
<name><![CDATA[Feature ID]]></name>
<value><![CDATA[GRE-342]]></value>
</custom_field>
<custom_field>
<name><![CDATA[CF_ESTIMATED_EXEC_TIME]]></name>
<value><![CDATA[25]]></value>
</custom_field>
</custom_fields>
<requirements>
<requirement>
<req_spec_title><![CDATA[Requirement Title 1]]></req_spec_title>
<doc_id><![CDATA[Req 1.2]]></doc_id>
<title><![CDATA[Title of Req 1.2]]></title>
</requirement>
</requirements>
</testcase>
</testsuite>
</testsuite>
</testsuite>

[amkhullar]

This is an error in your generated XML , since you disabled the required object in the references. See this bug for more details on this issue.http://mantis.testlink.org/view.php?id=3949

You could have chosen a lower version as per the Msoffice version you have. Also as a best practice before importing the test case XML please open it in a browser like IE to see such errors ( < Testsuite> tag is missing in your case)

[ananthnrk]

Hello,

I am unable to access / download the file from http://rapidshare.com/files/407777959/T ... L.xls.html. Is there any way that i can access / download this file?

Thanks,

~ ananth

[amkhullar]

Guys Please use the link http://mantis.testlink.org/view.php?id=3949 to download the latest link with a few bug fixes.

[amkhullar]

viewtopic.php?f=11&t=3664&start=0

Good news for all the TL users. The utility has been updated to Export the Requirement Specs also from the same sheet.

Updated sheet with both Test Case and Requirements Specs generator available at http://mantis.testlink.org/view.php?id=4011


~amit

[sdmeijer]

I'm using this Excel-sheet (from the 1.9.0-releasepackage), but the 'check columns'-functions doesn't work.
The fontcolor isn't changed and because of that the XML-file is invalid.

I'm using Office 2007 (Dutch).

I hope someone can help me.

[amkhullar]

The functionality of the Check Column function is not to color the columns but to detect the suites by colors , please apply the same format as in the eg. file I have created to each of the Test Suite columns for proper functioning.

[sdmeijer]

I found the problem.
The font.color-function didn't work.

I searched for all the font.color-functions and then changed them to Font.ColorIndex-functions and it works!

e.g.
I changed:

Code: Select all

If Sheet1.Cells(3 + i, 5).Font.Color = wdColorBlue Then

To:

Code: Select all

If Sheet1.Cells(3 + i, 5).Font.ColorIndex = 5 Then

The ColorIndex-codes are:
wdColorBlue = 5
wdColorPlum = 18
wdColorGreen = 10
wdColorDarkBlue = 11
wdColorBlack = 1