XML generator for TL 1.9

[amkhullar]

It seems that the Word object library is missing in ur project references.

Please see this bug for more details about the objects to be selected

http://mantis.testlink.org/view.php?id=3949

[oileanach]

Hi,

When i run the check columns function i get an error saying 'Empty Row found @ 14,7 Please Check'

'Microsofy word 14 library' was missing so i choose 'microsoft word 11 object libraray'

Can someone help me?

[oileanach]

Hi,

When i run the check columns function i get an error saying 'Empty Row found @ 14,7 Please Check'

'Microsofy word 14 library' was missing so i choose 'microsoft word 11 object libraray'

Can someone help me?

RESOLVED. That is just showing that its the end of the file. You can generate XML once you get that error and can be imported ok

[amkhullar]

Your observation is correct. Its meant to search for empty lines in between the test cases / suites etc which is an error if found else it will take u to the last line which is correct for generation of the XML.

[felixlu]

I met the "xml_load_ko" error too.
I found out that the reason is the XML used System Default encoding, rather than the same as the declaration "UTF-8".
After re-saving the generated XML as UTF-8 encoding, it can be successfully imported into TL.
Many thanks for the excellent script.

[Matt]

I'm getting the 'xml_load_ko' error with my exported file. I've tried all the steps here but still can't get it to import. Anybody else had a similar issue and happened upon a resolution?

[amkhullar]

Just an intermediate step there might be something in your xml which might be causing the XML to break, check for the xml being proper by opening it in the IE and see all content is displayed and there are no errors, if everything is fine then you will not get an xml_ko error. or you can even use a tool by microsoft called xml notepad 2007 something like that
that will help you diagnose the xml file before importing in the TL .

[amkhullar]

FYI I have fixed some error cases in the current xls also but they wont be apparent as such as bugs, so u can pick the updated file from this bug id and this will be available in the 1.9.2 build also.

http://mantis.testlink.org/view.php?id=4011

[Amaradana]

now i understand why many people point out in querying about the xml genrator, i see lot of pain in it, for a moment i thought the old format was easy, but the elmintaion of excel import was a huge loss. Now iam planning to lower my upgradation to 1.8.5 in implementing.

[phmaire]

Hi,
how are you update testcases via xml from Excel ? I don't need Testsuite, ect..
Thank
Phil

[rangalatika]

Hi,

When i open the visusal basic editor and trying to add the 'Microsofy word 14 object library' but it shows

'Missing :Microsofy word 14 object library' so i choose 'microsoft word 11 object libraray'. but still now i cant able to run the xml generator. if any one having solution for this .

please help me to resolve this issue.
Thanks in advance...

[amkhullar]

Just one more added info for the xml generator, you need to create an ODBC Connection in your system which connects to the Database you use, because I am using the same connection in the macro code in XML to verify the existing test cases in the Testlink DB to avoid any duplication of test cases while importing.

Please change the user name and password in xml macro function accordingly for accessing your database


Function CheckTCExist(strTestCaseName As String, intRow As Integer) As Boolean

If (strTestCaseName <> "") Then
conn.Open "Driver={MySQL ODBC 5.1 Driver};" & _
"Server=deepthought;" & _
"Database=testlink_19;" & _
"Uid=amit;" & _
"Pwd=amit"

and

Function CheckReqExists(strreqdoc As String, strreqid As String, intRow As Integer, intCol As Integer) As Boolean

conn1.Open "Driver={MySQL ODBC 5.1 Driver};" & _
"Server=deepthought;" & _
"Database=testlink_19;" & _
"Uid=amit;" & _
"Pwd=amit"

[vincam]

Hi all,

I´m trying download a last version updated, without bugs, but I can´t access the link´s.

Someone could help me send to my e-mail the XML generator for TL 1.9 updated.

It´s need use a especific library to execute in Excel XML generator for TL 1.9???

Thanks in advance,

Vinicius Camacho

[Amaradana]

You will have the files in the testlinkfolder/docs/utils folder

[amkhullar]

Guys I have come up with a new version which has some more features/fixes as below in the Help Document. Please read the help for more clarity. Email me if any bugs.

https://rapidshare.com/files/1944590140 ... _Help.docx

https://rapidshare.com/files/3027192298 ... ate-TL.xls