Import of CSV or xls file

prabhat · Post by **prabhat** » Wed Apr 18, 2007 11:49 am

Can we import csv or xml file. Like if i had already have test cases written in excel sheet, so can i import that.

Post by **fman** » Wed Apr 18, 2007 6:00 pm

use TL-XML format

drew · Post by **drew** » Fri Apr 20, 2007 10:09 pm

So is all .csv functionality gone in 1.7? This is kind of bad for me, because I had a really nice script for creating .csv files that worked great in TL1.6 from my custom data.

I looked in the config file and did not see any way to enable .csv, I have not looked at the TL1.7 code yet. Got a .csv to xml converter script that worked for 1.6.x import schema .csv files?

Post by **fman** » Sat Apr 21, 2007 8:29 am

I think we can add CVS import but just for Test Cases without ANY infor about Test Suite, or may be just parent Test suite.

Due to the new N-level container feature, CVS format is not a solution,
because is very difficult to express a variable number of levels.

Apologize, but we think N-level with XML is a better feature

prabhat · Post by **prabhat** » Mon Apr 23, 2007 4:40 am

I think CSV feature should be added, there should not ab any prob, if it is not having any info about the test suit. Because a user can inherit that test cases to some other test suit also(which is already there).

drew · Post by **drew** » Sat Apr 28, 2007 9:27 pm

All i need is to be able to import the individual test cases via csv under the individual suites. I'll select the suite manually, and import the individual test cases. Otherwise does anyone have a csv to xml converter which took the test case scheme from 1.6x as an input and outputs a xml file with 1.7.x format?

aTestLinker · Post by **aTestLinker** » Thu May 03, 2007 7:33 am

fman wrote:use TL-XML format

What format is TL-XML format? I'm totally stuck on importing my test cases to TL 1.7.
I already have test cases written in Excel. I save the sheet as XML spreadsheet and try to import that file to TL 1.7. But after I browse the file and click import, only a white screen comes up and nothing gets imported. Exactly what kind of XML format do I need to import testcases? I check out your mantis site, but I'm not able to find an example of the required XML format.
Thanks.

Post by **fman** » Thu May 03, 2007 8:29 am

right now our documentation is not good.
To understand what is TL-XML format you just need to do this:

create a testproject, several test suites and several test cases.
use the XML export function on:
whole test project
a test suite
a test case

then you will have the XML file with the right format.

Exporting excel files on XML format, will not solve your problem

aTestLinker · Post by **aTestLinker** » Fri May 04, 2007 1:57 am

Thank you so much for your fast reply.
I followed your suggestion and I've managed to transform my excel sheet to TL-XML format. It works when I upload the file on your demo site. However, on my site, after I click upload, nothing comes up. Just a white screen appears on that right pane (where we upload file), and no test cases get uploaded.
What else do I need to configure to get the uploading working?

aTestLinker · Post by **aTestLinker** » Fri May 04, 2007 4:48 am

aTestLinker wrote:Thank you so much for your fast reply.
I followed your suggestion and I've managed to transform my excel sheet to TL-XML format. It works when I upload the file on your demo site. However, on my site, after I click upload, nothing comes up. Just a white screen appears on that right pane (where we upload file), and no test cases get uploaded.
What else do I need to configure to get the uploading working?

I'm using PHP 5.1.6, by the way.

drew · Post by **drew** » Tue May 08, 2007 7:35 pm

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.

aTestLinker · Post by **aTestLinker** » Thu May 10, 2007 7:28 pm

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.

mspaul · Post by **mspaul** » Fri Jun 22, 2007 11:04 pm

I have the same problem.

I tried uploading test cases and get a blank page.

Although, working on the Demo site.

Is there some configuration that need to be setup for this functionality to work?

Post by **fman** » Sat Jun 23, 2007 7:48 am

You need to check is you have ALL PHP XML extension loaded.
Please do some search in this forum and in mantis about XML and import,
and you wll find some hints

aTestLinker · Post by **aTestLinker** » Sun Jun 24, 2007 10:07 pm

mspaul wrote:I have the same problem.

I tried uploading test cases and get a blank page.

Although, working on the Demo site.

Is there some configuration that need to be setup for this functionality to work?

I got the import working. My problem was that I had dom disabled in PHP configuration. I would suggest to try to print out phpinfo() and see if you have dom, xmlreader and xmlwriter enabled. If not, reconfigure your php with those enabled and reinstall php. Good luck!