[SOLVED] - Importing xml, xls using /doc/util

[aostad]

I have been using Testlink for almost 3 years in my previous company. Recently, I have joined another company which never used any test case management before. I have suggested them to go for TL. they agreed, if I could upload their 3000+ test cases in xls format.

After installing TL 1.9.3, I tried to import test cases to TL but didn't work. I've used a couple converters to convert XLS/XML to XML/XLS. I always get warning in opening xls files and exporting to xml file. The generated xml file is not accepted by testlink after all.

It looks like a coule bug have been reported and TL community decided to not resolve this issue. It was suggested by one of the TL community member that we use the utility in /doc/util to generate xml file from xls.

Now, the problem is that I'm not sure how the 2 utilities "RequirementXLSTOXML.xls" and "TestCaseXLSTOXML.xls" work. There are two buttons inside the xls files called "check column" and "generate xml". I click on them and get some visual basic errors.

Any help/hint is much appreciated.
AO

[istream]

Hello,
Did you ever manage to resolve the VB errors you were receiving. I am facing the same issue, clicking on either of the buttons causes an error.
Tried to correct the VB->Tools->references "Missing" library (my case Missing: Microsoft Word 14.0 object library) gives different error.
I am using Microsoft Office Excel 2007. I am not sure if this utility really functions.

[asgzl]

I use the xls in /docs/utils, both "check columns" and "generate XML" give error, does anybody ever use the script successfully?

Now what I have is a xml sheet, which can import testcase name, summary, pre-conditions, step to TL successfully,
while the problem is it only support ONE STEP and does not support multiple lines (must add <BR> in the end of line)

[asgzl]

After I uncheck the Microsoft Word 14.0 object library and check Microsoft Word 10.0 object library, and the xmls files generated.

[amkhullar]

see issue http://mantis.testlink.org/view.php?id=3949 and http://mantis.testlink.org/view.php?id=4011 to resolve your problem

Another post that will also help. Read it completely.

http://www.teamst.org/forum/viewtopic.p ... 8&start=15