MantisBT - TestLink
View Issue Details
0004576TestLinkExport/Importpublic2011-06-05 19:222012-09-01 19:59
kinow 
kinow 
normalminoralways
closedfixed 
2.0 (planned) 
1.9.4 (2012 Q3 - bug fixing) 
mysql Ver 14.14 Distrib 5.1.41, for Win32 (ia32)
Mozilla Firefox 4.0
PHP 5.2
0004576: Unable to import requirement using CSV file
Hello, I'm unable to import requirement operations using CSV files. I attached the CSV files that I am using. One of these files I copied from the tl-file-formats.pdf document. As I never used CSV to import entities into TestLink, I may be doing some dumb mistake, could somebody with karma have a look if the files are valid, please?
1. Select import from the requirement operations screen
2. Use one of the files enclosed to this issue
No tags attached.
png 007.PNG (43,784) 2011-06-05 19:22
http://mantis.testlink.org/file_download.php?file_id=2389&type=bug
png

csv sample_reqs.csv (67) 2011-06-05 19:22
http://mantis.testlink.org/file_download.php?file_id=2390&type=bug
csv sample_reqs_2.csv (95) 2011-06-05 19:23
http://mantis.testlink.org/file_download.php?file_id=2391&type=bug
png Screenshot from 2012-06-14 13:32:00.png (36,321) 2012-06-14 16:48
http://mantis.testlink.org/file_download.php?file_id=2712&type=bug
png
Issue History
2011-06-05 19:22kinowNew Issue
2011-06-05 19:22kinowFile Added: 007.PNG
2011-06-05 19:22kinowFile Added: sample_reqs.csv
2011-06-05 19:23kinowFile Added: sample_reqs_2.csv
2012-02-21 10:33mretallackNote Added: 0016401
2012-02-29 21:49kinowNote Added: 0016408
2012-02-29 21:49kinowAssigned To => kinow
2012-02-29 21:49kinowStatusnew => assigned
2012-06-12 14:51kinowStatusassigned => work in progress
2012-06-14 16:47kinowNote Added: 0016882
2012-06-14 16:48kinowFile Added: Screenshot from 2012-06-14 13:32:00.png
2012-06-14 16:50kinowStatuswork in progress => acknowledged
2012-06-14 16:51kinowNote Added: 0016883
2012-06-14 16:51kinowStatusacknowledged => resolved
2012-06-14 16:51kinowFixed in Version => 1.9.4 (2012 Q3 - bug fixing)
2012-06-14 16:51kinowResolutionopen => fixed
2012-09-01 19:59fmanNote Added: 0017341
2012-09-01 19:59fmanStatusresolved => closed

Notes
(0016401)
mretallack   
2012-02-21 10:33   
Hi, We have also found this issue,

We are running 1.9.2.

The problem turned out to be the number of fields used in the CSV file. The documentation states that the following format is accepted:

ENG-0001,Terrestrial Propulsor,
ENG-0002,Main Deflector,"

Main deflector bla, bla, bla.

"

However, from the code, 7 fields are needed:

"docid","title","description","type","status","expected_coverage","node_order"

If a lines does not have all 7 fields, then it is ignored.
Hope this helps

Mark.
(0016408)
kinow   
2012-02-29 21:49   
Hi Mark!

I will have a look on this issue again this next weekend.

Sorry for taking long to comment here.

Bruno
(0016882)
kinow   
2012-06-14 16:47   
Fixed in f27dd3d

Simple test done, see attached screenshot for new behaviour when syntax errors occur.

Thanks!
(0016883)
kinow   
2012-06-14 16:51   
Fixed in f27dd3d
(0017341)
fman   
2012-09-01 19:59   
1.9.4 released