!!! Excel to TestLink XML HOW TO !!!

[Misima]

Thanks to edias now I know how to perform export from Excel to Testlink easily:

Excel to TestLink XML HOW TO:

1. You just need to create 1 or 2 testcases on using GUI.
2. Then export those testcases, the exported file is testcases.xml.
3. Open that .xml file with MS Excel.
4. When you open it, choose the option "Use the XML source task pane".
5. Then you will see the XML map in XML Source window.
6. Click and drag the elements to the excel sheet.
7. Eg. if you want name to be your first column, click and drag "name" element to 1A grid so that the column A will be "name" column.

After you try importing it

And it really works.
Hurray!

[edias]

I'm glad that worked for ya... I really got tired of searching for a comprehensive excel to import to testlink how to.

Enjoy!

[kidd]

i get HTTP 500 error when i choose an exported XML (a few KB only) and then import.

Provided my URL is "http://x.x.x.x/testlink182/index.php"

does "testlink182" this path will cause any problem ?

[Malte]

I can't find the option "Use the XML source task pane" in my (old) Excel. Is this something that was added in Excel 2007?

Thanks

[edias]

I dont use excel 2007 and see it on my excel 2003.. make sure you follow all steps properly

[Amaradana]

Hi, UI is changed in excel 2007 you need to import from the source option i guess... wait here you gooo you need to folloow the following steps
1. open excel > navigate to "Data" now from the option "from other source" you can have rom XML data import, and rest of things are as usal.

[gk1981]

Hi All,

I have written a macro that will generate the xml required for Requirements as well as test cases. I can share it with you all. Please let me know how to attach files here.

Regards,
GK

[Amaradana]

PLease upload somewhere and provide the link here.

[gk1981]

Hi All,

Please find the excel template and macro here.
http://testlink-import.blogspot.com/200 ... mport.html

Hope this helps!!!

Regards,
GK

[Amaradana]

Thank you, for the Macro I really need a lot right now ,but will see how far i can use and will let you know feedback for sure.

[zlatan24]

Today I opened my xls file and saw that all my records are empty.I entered in google and found there-excel 2007 corrupt file recovery msdn.Program to my surprise solved my issues in seconds and without payment.Moreover I saw how tool can open any file of xls format that is not accessible by Microsoft Excel.

[oileanach]

I got to step 7 above. When i try to save the file i get the following error. 'Cannot save or export the XML data. The XML maps in the workbook are not exportable'

Can anyone please help?

Thanks

[Gordon]

Hi oileanach,

Did you manage to solve this problem?
I'm having the same issue.

Thanks
Gordon

[KSlimi]

Does it work with TestLink 1.9 ??? I really have the same problem and cant find solution !
Help please !

[rwarren]

Does it work with TestLink 1.9 ??? I really have the same problem and cant find solution !

I am testing this on a new installation of TestLink, for evaluation purposes. Extremely frustrating time, and i havne't even turned it over to users yet.

The macro from gk1981 for test cases works (except steps are not imported). I fiddled slightly with the VBA to allow one step per case. the macro for requirements has to be imported from Requirement Operations, not from Requirement Specifications. so in requirements you have to create a folder (section) first and then do the import into it, no problem.

And they can be imported in either order, contrary to my earlier observation.