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

1.8 related questions and discussions.
Please upgrade to LATEST 1.9.x.
No more fixes for 1.8.

Moderators: Amaradana, TurboPT, TL Developers

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

Postby Misima » Wed Jul 22, 2009 10:22 am

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! :D
Misima
TestLink user
 
Posts: 9
Joined: Tue Apr 28, 2009 2:07 pm

Postby edias » Wed Jul 22, 2009 8:51 pm

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

Enjoy!
edias
Advanced user
 
Posts: 34
Joined: Mon Jun 08, 2009 8:59 pm

Postby kidd » Tue Aug 25, 2009 9:24 am

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 ?
kidd
TestLink user
 
Posts: 1
Joined: Tue Aug 25, 2009 9:21 am

Can't find this option in Excel 2002

Postby Malte » Fri Oct 02, 2009 7:33 am

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
Malte
TestLink user
 
Posts: 12
Joined: Wed Apr 22, 2009 1:48 pm

Postby edias » Mon Oct 05, 2009 5:50 pm

I dont use excel 2007 and see it on my excel 2003.. make sure you follow all steps properly
edias
Advanced user
 
Posts: 34
Joined: Mon Jun 08, 2009 8:59 pm

Postby Amaradana » Mon Oct 05, 2009 10:06 pm

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.
Thanks,
TesterWorld
Http://amartester.blogspot.com
Amaradana
Member of TestLink Community
 
Posts: 398
Joined: Mon Feb 16, 2009 11:19 am

Macro for XML generation

Postby gk1981 » Tue Nov 10, 2009 2:13 am

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
gk1981
Advanced user
 
Posts: 20
Joined: Wed Sep 24, 2008 8:59 am

Postby Amaradana » Tue Nov 10, 2009 1:48 pm

PLease upload somewhere and provide the link here.
Thanks,
TesterWorld
Http://amartester.blogspot.com
Amaradana
Member of TestLink Community
 
Posts: 398
Joined: Mon Feb 16, 2009 11:19 am

Postby gk1981 » Fri Nov 13, 2009 2:10 pm

Hi All,

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

Hope this helps!!!

Regards,
GK
gk1981
Advanced user
 
Posts: 20
Joined: Wed Sep 24, 2008 8:59 am

Postby Amaradana » Fri Nov 13, 2009 2:19 pm

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.
Thanks,
TesterWorld
Http://amartester.blogspot.com
Amaradana
Member of TestLink Community
 
Posts: 398
Joined: Mon Feb 16, 2009 11:19 am

Postby zlatan24 » Fri Dec 04, 2009 3:40 pm

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.
zlatan24
TestLink user
 
Posts: 1
Joined: Fri Dec 04, 2009 3:34 pm

Re: !!! Excel to TestLink XML HOW TO !!!

Postby oileanach » Thu Jan 13, 2011 10:24 am

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
oileanach
Advanced user
 
Posts: 17
Joined: Wed Sep 08, 2010 3:03 pm

Re: !!! Excel to TestLink XML HOW TO !!!

Postby Gordon » Tue Mar 29, 2011 9:49 am

Hi oileanach,

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

Thanks
Gordon
Gordon
TestLink user
 
Posts: 3
Joined: Thu Mar 24, 2011 1:32 pm

Re: !!! Excel to TestLink XML HOW TO !!!

Postby KSlimi » Wed Jul 20, 2011 7:24 am

Does it work with TestLink 1.9 ??? I really have the same problem and cant find solution !
Help please !
KSlimi
TestLink user
 
Posts: 3
Joined: Tue Jul 19, 2011 2:27 pm

Re: !!! Excel to TestLink XML HOW TO !!!

Postby rwarren » Mon Jul 25, 2011 8:24 pm

KSlimi wrote: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.
rwarren
TestLink user
 
Posts: 1
Joined: Tue Jul 05, 2011 2:53 pm
Location: Montreal, Quebec, Canada

Next

Return to TestLink 1.8 (OBSOLETE => EOL)[LOCKED]



Who is online

Users browsing this forum: No registered users and 6 guests

cron