| Anonymous | Login | Signup for a new account | 2013-06-20 01:59 CEST |  |
| Main | My View | View Issues | Change Log | Roadmap | My Account |
| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |
| 0000110 | sigmah | Project | public | 2011-03-23 19:29 | 2013-05-27 18:46 | |
| Reporter | osarrat | |||||
| Assigned To | sherzod | |||||
| Priority | normal | Severity | feature | Reproducibility | N/A | |
| Status | closed | Resolution | fixed | |||
| Platform | OS | OS Version | ||||
| Product Version | ||||||
| Target Version | 1.2 | Fixed in Version | 1.2 | |||
| Summary | 0000110: Logframe Excel export | |||||
| Description | In order to share and print more easily the logical framework, it would be convenient to be able to export it as a MS Excel file (and optionnally under the OpenOffice Calc format as well) | |||||
| Additional Information | In the logframe view: - column Risks and Hypothesis should be merged into a single one "Risks & Hypothesis" column as those 2 columns should be joined (see 0000189) - indicators should be presented with their name and in brackets their value and the target value (ie: "Number of NFI kits distributed (1382/4500)") - if the logframe is exported along with other project information in a full project export (see "Export at the project level" in Additionnal information of 0000388), then the name of the indicators could be transformed as hyperlink to the full definition of the indicator in the indicators tab An empty logframe example is attached to give a basis for a general layout. | |||||
| Tags | No tags attached. | |||||
| User Report URL | ||||||
| OS | NA | |||||
| Other OS | ||||||
| Browser | NA | |||||
| Other browser | ||||||
| ScreenURL | ||||||
| (ActivityInfo) Noticed in revision | ||||||
| Attached Files |  LogFrameEmpty.xls [^] (31,744 bytes) 2012-07-09 15:50 ExcelExport_20120712172317.xls [^] (23,552 bytes) 2012-07-12 10:24 ExcelExport_20120712172317-corrected.xls [^] (35,840 bytes) 2012-07-13 09:51 | |||||
 Relationships |
||||||||||||||||
|
||||||||||||||||
 Relationships |
|
Notes |
|
|
(0001009) sherzod (developer) 2012-07-12 10:30 |
This is (http://www.sigmah.org/issues/file_download.php?file_id=46&type=bug [^]) auto-generated excel file for Log frame. I am doing same format style for Open document spreadsheet, just want to know if current layout of the spreadsheet is ok. Please share your feedback. NOTE: it is impossible make auto re-sizable row height when cells are merged. Thus, row heights should be set statically. |
|
(0001010) osarrat (administrator) 2012-07-13 09:54 |
Congrats for the work done, and for the very nice layout! I've corrected a few things regarding solely the headings in the content cells. What to be removed is in the red, and in green is the example of a cell completely correct. Thanks again! |
|
(0001027) svn_mantis-robot (developer) 2012-07-24 14:54 |
Patch by sherzod : log frame export (fixes issue 0000110, fixes issue 0000188, fixes issue 0000189). Added : /trunk/sigmah/src/main/java/org/sigmah/server/Translator.java Added : /trunk/sigmah/src/main/java/org/sigmah/server/UIConstantsTranslator.java Added : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/exporter Added : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/exporter/LogFrameExporter.java Added : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/exporter/ProjectReportExporter.java Added : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/spreadsheet Added : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/spreadsheet/ExcelUtils.java Added : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/spreadsheet/ExportConstants.java Added : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/spreadsheet/data Added : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/spreadsheet/data/LogFrameExportData.java Added : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/spreadsheet/template Added : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/spreadsheet/template/ExportTemplate.java Added : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/spreadsheet/template/LogFrameCalcTemplate.java Added : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/spreadsheet/template/LogFrameExcelTemplate.java Modified : /trunk/sigmah/src/main/java/org/sigmah/client/i18n/UIConstants.properties Modified : /trunk/sigmah/src/main/java/org/sigmah/client/page/orgunit/reports/OrgUnitReportsView.java Modified : /trunk/sigmah/src/main/java/org/sigmah/client/page/project/logframe/ProjectLogFrameGrid.java Modified : /trunk/sigmah/src/main/java/org/sigmah/client/page/project/logframe/ProjectLogFramePresenter.java Modified : /trunk/sigmah/src/main/java/org/sigmah/client/page/project/logframe/ProjectLogFrameView.java Modified : /trunk/sigmah/src/main/java/org/sigmah/client/page/project/logframe/grid/IndicatorListWidget.java Modified : /trunk/sigmah/src/main/java/org/sigmah/client/page/project/reports/ProjectReportsView.java Modified : /trunk/sigmah/src/main/java/org/sigmah/public/sigmah.css Modified : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/Exporter.java Modified : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/SigmahExportServlet.java Modified : /trunk/sigmah/src/main/java/org/sigmah/server/policy/ProjectModelPolicy.java Modified : /trunk/sigmah/src/main/java/org/sigmah/server/policy/ProjectPolicy.java Modified : /trunk/sigmah/src/main/java/org/sigmah/shared/domain/logframe/ExpectedResult.java Modified : /trunk/sigmah/src/main/java/org/sigmah/shared/domain/logframe/LogFrameElement.java Modified : /trunk/sigmah/src/main/java/org/sigmah/shared/domain/logframe/SpecificObjective.java Modified : /trunk/sigmah/src/main/java/org/sigmah/shared/dto/ExportUtils.java Modified : /trunk/sigmah/src/main/java/org/sigmah/shared/dto/logframe/ExpectedResultDTO.java Modified : /trunk/sigmah/src/main/java/org/sigmah/shared/dto/logframe/LogFrameElementDTO.java Modified : /trunk/sigmah/src/main/java/org/sigmah/shared/dto/logframe/SpecificObjectiveDTO.java Modified : /trunk/sigmah/src/test/java/org/sigmah/server/endpoint/gwtrpc/LogFrameIntegrationTest.java Removed : /trunk/sigmah/src/main/java/org/sigmah/client/page/project/logframe/ProjectLogFrameLabels.java Removed : /trunk/sigmah/src/main/java/org/sigmah/client/page/project/logframe/grid/IndicatorListWidget.ui.xml Removed : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/ExportFormat.java Removed : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/LogFrameExporter.java Removed : /trunk/sigmah/src/main/java/org/sigmah/server/endpoint/export/sigmah/ProjectReportExporter.java |
|
(0001033) svn_mantis-robot (developer) 2012-07-30 11:59 |
Updates POM (issue 0000110). Modified : /trunk/sigmah/pom.xml |
|
(0001200) svn_mantis-robot (developer) 2013-05-27 17:16 |
Added test case LF10 "Export a logical framework" to test resolution of issue 0000110 on wiki page TestScenario4LogicalFramework through web user interface. Modified : /wiki/TestScenario4LogicalFramework.wiki |
|
(0001206) osarrat (administrator) 2013-05-27 18:46 |
Issue closed because correct behavior checked in v1.2-rc1 through integration test case http://code.google.com/p/sigma-h/wiki/TestScenario4LogicalFramework#LF10 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-03-23 19:29 | osarrat | New Issue | |
| 2011-03-23 19:31 | osarrat | Relationship added | related to 0000034 |
| 2011-09-28 12:57 | osarrat | Target Version | unplanned => 1.5 |
| 2011-09-28 13:12 | osarrat | Relationship added | child of 0000388 |
| 2012-06-28 13:44 | osarrat | Assigned To | => sherzod |
| 2012-06-28 13:44 | osarrat | Status | new => assigned |
| 2012-07-05 19:43 | osarrat | Target Version | 1.5 => 1.3 |
| 2012-07-09 15:50 | osarrat | Additional Information Updated | View Revisions |
| 2012-07-09 15:50 | osarrat | File Added: LogFrameEmpty.xls | |
| 2012-07-09 15:51 | osarrat | Relationship added | related to 0000189 |
| 2012-07-12 10:24 | sherzod | File Added: ExcelExport_20120712172317.xls | |
| 2012-07-12 10:30 | sherzod | Note Added: 0001009 | |
| 2012-07-13 09:51 | osarrat | File Added: ExcelExport_20120712172317-corrected.xls | |
| 2012-07-13 09:54 | osarrat | Note Added: 0001010 | |
| 2012-07-24 14:54 | svn_mantis-robot | Checkin | |
| 2012-07-24 14:54 | svn_mantis-robot | Note Added: 0001027 | |
| 2012-07-24 14:54 | svn_mantis-robot | Status | assigned => resolved |
| 2012-07-24 14:54 | svn_mantis-robot | Resolution | open => fixed |
| 2012-07-26 09:52 | osarrat | Target Version | 1.3 => 1.2 |
| 2012-07-30 11:59 | svn_mantis-robot | Checkin | |
| 2012-07-30 11:59 | svn_mantis-robot | Note Added: 0001033 | |
| 2013-05-27 17:16 | svn_mantis-robot | Checkin | |
| 2013-05-27 17:16 | svn_mantis-robot | Note Added: 0001200 | |
| 2013-05-27 18:46 | osarrat | OS | Windows Vista => NA |
| 2013-05-27 18:46 | osarrat | Browser | Mozilla Firefox 3.6 (Namoroka) => NA |
| 2013-05-27 18:46 | osarrat | Note Added: 0001206 | |
| 2013-05-27 18:46 | osarrat | Status | resolved => closed |
| 2013-05-27 18:46 | osarrat | Fixed in Version | => 1.2 |
|
Issue History |
| Copyright © 2000 - 2010 MantisBT Group |
 |