Import of CSV or xls file

The release related discussions, plans and questions.

Postby Trenskow » Wed Sep 12, 2007 7:12 am

aTestLinker wrote:
drew wrote:Can you post or send a sample excel sheet with some sample data so that I can see how you formated the excel sheet? I'm trying to do the same thing as you, and I have not had any free time yet to make a .csv to tl-xml converter, it might be faster to go the same route as you're doing at this point.


You just need to create 1 or 2 testcases on using GUI. Then export those testcases...say, the exported file is testcases.xml. Open that .xml file with MS Excel. When you open it, choose the option "Use the XML source task pane". Then you will see the XML map in XML Source window. Click and drag the elements to the excel sheet. 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, please tell me if that works. Importing still doesn't work on my site, although it works on TL demo site. It's still showing the blank white screen after i click upload to import.


Hi
I need some help on this matter.
I have created 2 testcases, and exported them to a xml file.
Then i have opened the XML file in Excel, and choose "Use the XML source task pane". Then i get a threeview in the right hand side, but then, when i drag elements from the tree, to ie. 1a or 2a. Nothing happens.

What am i doing wrong?

Regards
Trenskow
Advanced user
 
Posts: 20
Joined: Wed Sep 12, 2007 7:09 am

Postby DakotaRob » Tue Oct 02, 2007 6:15 pm

Trenskow wrote:
aTestLinker wrote:
drew wrote:Can you post or send a sample excel sheet with some sample data so that I can see how you formated the excel sheet? I'm trying to do the same thing as you, and I have not had any free time yet to make a .csv to tl-xml converter, it might be faster to go the same route as you're doing at this point.


You just need to create 1 or 2 testcases on using GUI. Then export those testcases...say, the exported file is testcases.xml. Open that .xml file with MS Excel. When you open it, choose the option "Use the XML source task pane". Then you will see the XML map in XML Source window. Click and drag the elements to the excel sheet. 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, please tell me if that works. Importing still doesn't work on my site, although it works on TL demo site. It's still showing the blank white screen after i click upload to import.


Hi
I need some help on this matter.
I have created 2 testcases, and exported them to a xml file.
Then i have opened the XML file in Excel, and choose "Use the XML source task pane". Then i get a threeview in the right hand side, but then, when i drag elements from the tree, to ie. 1a or 2a. Nothing happens.

What am i doing wrong?

Regards


I'm having this exact problem as well. I exported a smaller test (60 cases or so) from Testlink 1.7 to an XML file.

Then opened that XMP in Excel and chose to use the XML source task pane. The tree appears, but dragging the elements of the tree like 'name' 'summary' 'steps' into a blank excel sheet doesn't seem to be doing anything.
DakotaRob
TestLink user
 
Posts: 1
Joined: Tue Oct 02, 2007 6:12 pm

Postby Nogem » Tue Nov 13, 2007 10:59 pm

DakotaRob:
When you drag and drop the items (like name) from your XML map you are telling excel where to pull it's data for that column. It won't display anything until you tell it to refresh the data, at which point it will go and pull data from the areas in the XML you told it to use.

Anyone:
The biggest issue I've encountered is that Steps and Expected Results are each one huge XML field. This means that Excel chokes on attempting to display their contents.

A friend and I will be working on a solution to this over the next few days. It the TL folks are interested we'll toss it into Mantis. Basically, we're going to adjust the php so that each of step and result will get it's own tag. Most likely we'll include a metadata identifier for each. This gives the ability to tell excel to pull steps and have each displayed, with rows automatically added for each one. Of course, this also means the templates for viewing these items will have to be adjusted for the change.

If anybody else has already done this please chime in. I would hate to sit over here re-inventing your wheel.
Thanks
Nogem
Advanced user
 
Posts: 21
Joined: Tue Nov 13, 2007 10:53 pm

Postby fman » Wed Nov 14, 2007 8:07 am

There is a contribution added to CVS HEAD, to import just testcases from XLS
fman
Member of TestLink Community
 
Posts: 3012
Joined: Tue Nov 15, 2005 7:19 am

Postby Nogem » Wed Nov 14, 2007 4:33 pm

That contribution sounds neat, but present need is the ability to export the entire test plan to Excel. The present exported format of steps and expected results prevents this (as does Excel's inability to handle html table or object list tags). Working on this presently. We get this sorted out we'll contribute the solution and post our companies since at that point we'll start actively using TL. We're both fairly dependant on that being worked out before we can put TL into active use.
Nogem
Advanced user
 
Posts: 21
Joined: Tue Nov 13, 2007 10:53 pm

Postby havlatm » Sat Nov 17, 2007 6:33 pm

I updated information about the current import in:
http://www.teamst.org/index.php?option=com_content&task=view&id=20&Itemid=2

The request for reimplementation of the functionality in the next version is:
http://www.testlink.org/mantis/view.php?id=1186
havlatm
Member of TestLink Community
 
Posts: 940
Joined: Mon Oct 31, 2005 1:24 am
Location: Czech

Postby edias » Fri Jul 17, 2009 5:46 pm

aTestLinker wrote:
drew wrote:Can you post or send a sample excel sheet with some sample data so that I can see how you formated the excel sheet? I'm trying to do the same thing as you, and I have not had any free time yet to make a .csv to tl-xml converter, it might be faster to go the same route as you're doing at this point.


You just need to create 1 or 2 testcases on using GUI. Then export those testcases...say, the exported file is testcases.xml. Open that .xml file with MS Excel. When you open it, choose the option "Use the XML source task pane". Then you will see the XML map in XML Source window. Click and drag the elements to the excel sheet. 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, please tell me if that works. Importing still doesn't work on my site, although it works on TL demo site. It's still showing the blank white screen after i click upload to import.


thanks for this info... this should be part of the of the original TL documentation!
edias
Advanced user
 
Posts: 34
Joined: Mon Jun 08, 2009 8:59 pm

Previous

Return to TestLink 1.7 (Closed)



Who is online

Users browsing this forum: No registered users and 2 guests