Import of already written excel-testcases

The release 1.6 is going to be unsupported by Community. Because our effort moves ahead. However there are still valuable informations for you.

Import of already written excel-testcases

Postby Lucky-Joe » Mon Jan 02, 2006 6:38 pm

Hi at all,

I have already installed the testlin-system 1.6 and i am surprised about the system but i miss an import-functionality of already written testcases.
So does anybody have a solution how it could be possible to import excel-sheets ?

regards
Joe
Lucky-Joe
TestLink user
 
Posts: 3
Joined: Mon Jan 02, 2006 6:34 pm

Postby fman » Tue Jan 03, 2006 9:16 am

1. please read the documentation
2. import using CSV format
3. please don\'t use this evil tool (excel)
fman
Member of TestLink Community
 
Posts: 3063
Joined: Tue Nov 15, 2005 7:19 am

Postby havlatm » Wed Jan 04, 2006 4:27 pm

Hey, Francisco, I think that Excel is really good product. I studied Chemical technology and I used it really often. Of course it is proprietal. :(

Lucky-Joe,
Let us know, if you cannot use the current import solution. Maybe there is a problem for your case. But generally it should be working.

Regards,

Martin
havlatm
Member of TestLink Community
 
Posts: 940
Joined: Mon Oct 31, 2005 1:24 am
Location: Czech

About Excel

Postby fman » Wed Jan 04, 2006 5:42 pm

well, well talking about Excel. I\'m not saying it\'s not a good tool.
It\'s an SpreadSheet Tool, and may be the easier tool to write something
and export the contents as CSV.
I don\'t like is when is used as a word processor, or as the only tool
in the world.

enough about excel
fman
Member of TestLink Community
 
Posts: 3063
Joined: Tue Nov 15, 2005 7:19 am

Major rework required!

Postby scorpfromhell » Wed Feb 01, 2006 3:58 pm

Without getting on the topic of M$ is bad or Excel shud only b a spreadsheet (though I wud like a lot to discuss on this :twisted: ), here is the way to do it if you have your test cases already written in Excel:

1) Copy your excel to a new file (so that you have a backup)
2) Remove all your columns and keep only the columns corresponding to Component, Category, Summary, Steps & Expected results of TestLink.
3) Save this file as CSV file.
4) Import this file into TestLink.

This could cause you problems if you have carriage returns in the text in your excel cells. If you have such cells (text with carriage returns) dont bother, just copy your test cases manually. :( Sadly, this is how we had to move nearly 4500 test cases from Excel to TestLink. But now that it is done, we are very happy :D
Regards,
Prem
--------------------------------
[url]http://j.mp/prem_k[/url]
scorpfromhell
TestLink user
 
Posts: 7
Joined: Thu Nov 17, 2005 1:42 pm
Location: Hosur, India

documentation of import feature

Postby pyang » Sat Feb 04, 2006 12:38 am

Hi all,

From what documentation could I get detailed description of import feature? I read the 5.4.1 Import requirements in User Manual, but it\'s kind of vague.

Can anybody provide a sample file?

Thanks a lot

Paul
pyang
Advanced user
 
Posts: 18
Joined: Sat Feb 04, 2006 12:28 am

Postby sgray » Thu Feb 09, 2006 3:05 pm

I could use help with this too. What format is the CSV supposed to be in, meaning, How many columns is it expecting? Which columns relate to which values?
sgray
TestLink user
 
Posts: 1
Joined: Thu Feb 09, 2006 2:49 pm

Postby havlatm » Tue Feb 21, 2006 12:40 pm

I\\\'m sorry the late answer. I created page for you:

http://www.teamst.org/index.php?option=com_content&task=view&id=20&Itemid=2

Martin
havlatm
Member of TestLink Community
 
Posts: 940
Joined: Mon Oct 31, 2005 1:24 am
Location: Czech

Postby JeroenDockx » Thu Mar 09, 2006 10:14 am

I\'ve studied the documentation and the forum but I\'m still not able to import test cases. Not even your examples.
When I click the Upload file button, I can see the browser searching for tcImport.php for a millisecond. But, besides the file-location inputfield being cleared, nothing happens.
Am I missing something here?
JeroenDockx
TestLink user
 
Posts: 6
Joined: Wed Jan 11, 2006 2:13 pm

Postby havlatm » Thu Mar 09, 2006 1:51 pm

Could you verify that import files is not disallowed by your system (php, apache)?
1.6.0 is working fine for me.

Martin
havlatm
Member of TestLink Community
 
Posts: 940
Joined: Mon Oct 31, 2005 1:24 am
Location: Czech

Did any of you resolve this?

Postby rhutchinson » Wed Apr 26, 2006 5:31 pm

I cannot import test cases or requirements either. Have any of you resolved this? Is there a place to find error messages that I am missing?

I have mediawiki installed on the same machine (using php) and uploads work fine with it.
rhutchinson
TestLink user
 
Posts: 6
Joined: Wed Apr 26, 2006 5:00 pm

Postby havlatm » Thu Apr 27, 2006 10:14 am

1. Be more descriptive, what you experience
2. Set logging to Debug mode and look if there is not some interesting info.
havlatm
Member of TestLink Community
 
Posts: 940
Joined: Mon Oct 31, 2005 1:24 am
Location: Czech

Postby rhutchinson » Thu Apr 27, 2006 2:22 pm

I see the same thing JeroenDockx was seeing on March 9. The page refreshes attempting to load /lib/testcases/tcimport.php but nothing changes and the page that says \"Choose a local File to Upload\" is still displayed.

I set logging to debug and no errors are thrown that I see. Here are the logfile contents. If there is other log information you need, let me know where it is.


basehref|s:18:\"http://10.0.0.253/\";locale|s:5:\"en_GB\";user|s:8:\"testlink\";userID|s:2:\"20\";email|s:21:\"XXXXatXXXX.com\";roleId|i:8;role|s:5:\"admin\";productID|s:1:\"1\";productName|s:9:\"Member ST\";productColor|s:7:\"#99FFFF\";productOptReqs|s:1:\"1\";productOptPriority|s:1:\"1\";filter_tp_by_product|i:1;testPlanId|s:1:\"2\";testPlanName|s:16:\"Revenue Deferral\";



OS= Windows Server 2003 Standard Edition
Webserver = Apache 2.0.55
PHP = 5.1.2

I just looked it up and found that PHP 5 isn\'t officially supported. Could this be the issue?
rhutchinson
TestLink user
 
Posts: 6
Joined: Wed Apr 26, 2006 5:00 pm

Postby CotAle » Fri Apr 28, 2006 3:42 pm

I also have same problem. I am not expert of Apache, PHP and MySql. I could install everything and I am really happy of TestLink. But I really need the import functionality working, as I already have lot of test cases already prepared.

I guess we have some problems in server configuratio. How can we verify that import files is not disallowed by our system (php, apache)?
Thank you
CotAle :roll:
CotAle
TestLink user
 
Posts: 1
Joined: Fri Apr 28, 2006 3:37 pm

Log File for failed import

Postby rhutchinson » Tue Jun 27, 2006 9:24 pm

THere are two log files created when I turn DEBUG on in testlink

The first is userlog21.log and the 2nd is userlog0.log The contents of each are below. One other thing to note is that I have mediawiki installed and uploads work fine with it and it uses the same php/apache installation.

I have given \"everyone\" full permissions to the temp folder c:\\windows\\temp and to the testlink installation folder.



userlog21.log:
------------------------------------------------------------------------
[06/Jun/27 16:12:33][DEBUG][/lib/testcases/tcImport.php][rhutchinson][9o3e6l8e76cf222hb24blefte2]
test /lib/testcases/tcImport.php
[06/Jun/27 16:12:33][DEBUG][/lib/testcases/tcImport.php][rhutchinson][9o3e6l8e76cf222hb24blefte2]
SQL [3] executed [took 0.00098399999999998 secs][all took 0.002067 secs]:
SELECT rights FROM rights WHERE role=\'admin\'
[06/Jun/27 16:12:33][DEBUG][/lib/testcases/tcImport.php][rhutchinson][9o3e6l8e76cf222hb24blefte2]
$myrowGetRights=> tp_execute,tp_create_build,tp_metrics,tp_planning,tp_assign_rights,mgt_view_tc,mgt_modify_tc,mgt_view_key,mgt_modify_key,mgt_view_req,mgt_modify_req,mgt_modify_product,mgt_users
[06/Jun/27 16:12:33][DEBUG][/lib/testcases/tcImport.php][rhutchinson][9o3e6l8e76cf222hb24blefte2]
Sufficient rights for c:/testmanagement/testlink/lib/testcases/tcimport.php





Userlog0.log
------------------------------------------------------------
[06/Jun/27 16:12:33][DEBUG][/lib/testcases/tcImport.php][][]
SQL [1] executed [took 0.00035499999999999 secs][all took 0.00035499999999999 secs]:
SET CHARACTER SET utf8;
[06/Jun/27 16:12:33][DEBUG][/lib/testcases/tcImport.php][][]
SQL [2] executed [took 0.00072800000000006 secs][all took 0.0010830000000001 secs]:
SET collation_connection = \'utf8_general_ci\';
rhutchinson
TestLink user
 
Posts: 6
Joined: Wed Apr 26, 2006 5:00 pm

Next

Return to TestLink 1.6 (closed)



Who is online

Users browsing this forum: No registered users and 1 guest