Import of CSV or xls file

[Trenskow]

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

[DakotaRob]

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.

[Nogem]

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

[fman]

There is a contribution added to CVS HEAD, to import just testcases from XLS

[Nogem]

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.

[havlatm]

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

[edias]

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!