Import TestCase from Word Document

[quangnp]

Hi there,

I intend to use TestLink for a project that have already about 4K test cases. These test cases now is in Word file.

Can I import them to TestLink automatically or by script, not by hand? How if I can?

Thanks,
Quang

[edias]

I dont think there's an option to convert a word doc to test link unless someone has one out there, what you can do is convert that word document to csv or excel directly then convert from excel to xml and you're good to go!

In some of my previous posts I described how to convert from excel to TL xml!

[quangnp]

Hi edias,

Thanks for your reply.

How to convert word doc to excel ?

Thanks,
Quang

[edias]

I will not be able to help you with that.. i dont know how your document is structured and whether you use tables or not.... you might need to massage that document manually to excel, from there onward I'll be glad to help you!

Cheers,

[quangnp]

Hi edias,

We use a table to store all test cases, 1 test case/row. Below is the structure:

No. || Requirement || Step || Expected Result
XXX1 || [YYY-ZZ] || ... || ...

The much data imported, the best for me.

Thanks by advances,
Quang

[edias]

If you can extract your TC's in that format you're almost done.

1. extract/copy to a flat file e.i txt or .csv
2. global replace all you commas to something else
3. global replace any special characters just to be safe
4. global replace || with commas
5. save as csv
6. open in excel
7. follow directions on how to convert to TL XML

good luck

[quangnp]

|| is stand for a cell of a table.

All test cases are store in a table with the above format.

When I copy to a txt file, it copies all content, without any comma or semicolon. I can not convert to a cvs file. That's the problem

Thanks,
Quang

[edias]

you need to have your test cases in a single line in order to be properly formated to open in excel, be sure to remove all unwanted commas or it will off set the columns.

[quangnp]

Hi edias,

It's quite simple now. I just open the doc file and copy all tables of test case (to clipboard), open an excel blank page, paste and it well done.

Thanks very much for you help !

Thanks,
Quang

[edias]

Hi edias,

It's quite simple now. I just open the doc file and copy all tables of test case (to clipboard), open an excel blank page, paste and it well done.

Thanks very much for you help !

Thanks,
Quang

I'm happy to hear that worked well for ya!

[nyik]

Hi!

Sorry to resurrect this thread.

Has anyone run into the issue where in the word doc, the test steps are in all one cell, but when you copy the table and paste into excel, excel separates each step into separate cells?!

I need to put the steps into one cell for TL to import the cases properly!

Thanks!!
Nelson

[edias]

Hi!

Sorry to resurrect this thread.

Has anyone run into the issue where in the word doc, the test steps are in all one cell, but when you copy the table and paste into excel, excel separates each step into separate cells?!

I need to put the steps into one cell for TL to import the cases properly!

Thanks!!
Nelson

remove your commas, they will split your data into multiple cells

[mutu26]

I dont think there's an option to convert a word doc to test link unless someone has one out there, what you can do is convert that word document to csv or excel directly then convert from excel to xml and you're good to go!



In some of my previous posts I described how to convert from excel to TL xml!

Couple weeks ago I was at my friend's house. It was a party there, but moreover I knew that he had a power PC with great number applications. One of the others interested me - word recovery tools. To my great surprise the software worked out my old issue with damaged word documents. I am glad for it has helped me.