Mantis Bugtracker 

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0005872TestLinkContribution Maintained BY USERpublic2013-08-22 09:012017-03-02 20:39
Assigned To 
PlatformOSOS Version
Product Version1.9.7 (2013 Q2 - bug fixing) 
Fixed in Version 
Summary0005872: User contribution : Req Based Report in MS Excel format
DescriptionAll provided modifications have been done from stable version TL 1.9.7.

TestLink is able to provide Requirement Based report in HTML format.
The content of the attached files "" add the ability to export all the information in MS Excel format.
In "cfg/reports.cfg.php", just add ",format_xls" on line 176 (Req Based Report section) to activate Excel Export.

The attached file "NewStrings.txt" provide new lines that has to be created to display the new functionnality. You have to update the file "strings.txt" in the folder "locale\en_GB\".
The attached PNG file is provided to show how to access the functionnality in TL GUI.
TagsNo tags attached.
Database (MySQL,Postgres,etc)Tested with MySQL
PHP Version
QA Team - Task Workflow StatusTBD
Attached Fileszip file icon [^] (16,558 bytes) 2013-08-22 09:01
txt file icon NewStrings.txt [^] (128 bytes) 2013-08-22 09:01 [Show Content]
png file icon TL-1.9.7_ReqBasedReportExcel.PNG [^] (9,099 bytes) 2013-08-22 09:02

png file icon HTML.PNG [^] (130,705 bytes) 2013-09-09 09:57

xls file icon SandBox_test_spec-2013-09-09.xls [^] (11,827 bytes) 2013-09-09 09:58

- Relationships
related to 0003786closedfman Ability to export requirements based report in xls format 
related to 0006886new Export "Requirements based Report" to a spreadsheet 
child of 0005870closedfman User contribution : Req Based Report in MS Excel format, Query Metrics and Group TestCases by Coverage in Add/Remove Testcases 

-  Notes
redpiyo (reporter)
2013-09-02 06:35

Currently , if there are no requirements generated testcases, selecting this report will generate a blank page, it would be useful to display some notification
fman (administrator)
2013-09-03 18:19

In order to evaluate if this feature will be added, I need to have complete details about what the feature provides.
Report has been changed ?
new columns added ?
Please provide:
1. sample of HTML report
2. sample of same report but on XLS format
Mr.Bricodage (updater)
2013-09-09 10:14

Two files uploaded.
The HTML report hasn't been modified.
The Excel export provide the same information in an other format.
fman (administrator)
2013-09-09 11:32

Please confirm this:
in the EXCEL report I see a column with info about BUGS that I'm not able to find in the HTML.

That is what I've seen reviewing the code.
Mr.Bricodage (updater)
2013-09-09 11:50

Correct. I didn't understand that you asked about Excel column, sorry.

We didn't want to modify HTML export, but the bug information related to each requirement is usefull for us (and maybe for others?), so we added it but only in XLS export.
Maybe the information should be added to HTML report too? Your vision is needed on that point.

fman (administrator)
2013-09-28 11:01

added the additional info just in one report format is IMHO wrong and confuse users.

I will try in future to understand if this info need to be added

- Issue History
Date Modified Username Field Change
2013-08-22 09:01 Mr.Bricodage New Issue
2013-08-22 09:01 Mr.Bricodage File Added:
2013-08-22 09:01 Mr.Bricodage File Added: NewStrings.txt
2013-08-22 09:02 Mr.Bricodage File Added: TL-1.9.7_ReqBasedReportExcel.PNG
2013-09-01 17:16 fman Product Version => 1.9.7 (2013 Q2 - bug fixing)
2013-09-01 17:26 fman Relationship added child of 0005870
2013-09-02 06:35 redpiyo Note Added: 0019472
2013-09-03 18:19 fman Note Added: 0019485
2013-09-03 18:19 fman Status new => feedback
2013-09-09 09:57 Mr.Bricodage File Added: HTML.PNG
2013-09-09 09:58 Mr.Bricodage File Added: SandBox_test_spec-2013-09-09.xls
2013-09-09 10:14 Mr.Bricodage Note Added: 0019579
2013-09-09 10:14 Mr.Bricodage Status feedback => new
2013-09-09 11:32 fman Note Added: 0019580
2013-09-09 11:50 Mr.Bricodage Note Added: 0019581
2013-09-28 11:01 fman Note Added: 0019714
2017-03-02 20:38 Mr.Bricodage Relationship added related to 0003786
2017-03-02 20:39 Mr.Bricodage Relationship added related to 0006886

Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker