Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0002118TestLinkReportspublic2009-02-16 17:092009-02-23 18:54
Reporterpsyquest 
Assigned To 
PrioritynormalSeverityfeature requestReproducibilityN/A
StatusacknowledgedResolutionopen 
PlatformOSOS Version
Product Version1.8 RC 4 
Fixed in Version 
Summary0002118: Custom reporting: creating one huge excel export
DescriptionMany systems use excel to import data. The current project management system in use in my company can import excel sheet containing data pertaining to test campains. The problem is that the data exported by default in any of the current reports in testlink are inadequate as is.

The requirement is to have a huge excel file with the following:

top: summary of all test executed/results/failures/blocked etc.

Main data with following columns:
Test case title | test case link | Build | test case status | assigned user |Description | Bugs Titles with configurable separators |Bug links with configurable separators | bug status with configurable separators
Additional InformationDrill down feature.

make available a direct url link to a specific test campaign.

Click this link opens a summary to the test campaign.

Click an expand button on the summary, opens a list of all tests cases pertaining to this campaign with their status / bugs /titles etc.
clicking on any test cases opens the test case with its result/description/notes
TagsNo tags attached.
Database (MySQL,Postgres,etc)
Browser
PHP Version
TestCaseID
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
(0005503)
mhavlat (reporter)
2009-02-16 17:29

I do not understand a purpose of this dump. Could you explain using?
(0005511)
psyquest (reporter)
2009-02-16 21:37

the purpose of this dump is to allow integrating test results in systems that allow excel parsing of data.

If all the information is dumped into one excel sheet then all this data can easily be customised in excel for easy parsing by the system.

example: we are using focal point for project management. focal point can allow us to parse an excel sheet and populate its database with data from testling pertaining to a test plan.

As is no export currently avaible allows for an easy import into Focal Point. however if the dump was more "complete" a couple of excel macros later we could have data imported easily.
(0005588)
mhavlat (reporter)
2009-02-23 18:54

A cheaper way is use the CSV format instead of excel. We have not integrated excel library. In addition it should work also for OpenOffice Calc.

Implementation notes:
User could select generated fields in the report.

Acknowledged without target release.

- Issue History
Date Modified Username Field Change
2009-02-16 17:09 psyquest New Issue
2009-02-16 17:29 mhavlat Note Added: 0005503
2009-02-16 17:29 mhavlat Status new => feedback
2009-02-16 21:37 psyquest Note Added: 0005511
2009-02-23 18:54 mhavlat Note Added: 0005588
2009-02-23 18:54 mhavlat Status feedback => acknowledged



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker