0000473: Auto refresh-able excel/calc exports

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0000473

sigmah

[All Projects] General

public

2012-07-06 11:11

2012-07-10 17:33

Reporter

sherzod

Assigned To

Priority

normal

Severity

feature

Reproducibility

N/A

Status

new

Resolution

open

Platform

OS Version

Product Version

1.2

Target Version

unplanned

Fixed in Version

Summary

0000473: Auto refresh-able excel/calc exports

Description

If users start to develop some graphics in an Excel sheet from a exported file, it will be good if they could update their diagrams easily. Thus, data in excel should be refreshed from excel file.

When making a global excel export(which is triggered from project list dashboard) user can set an option telling if he wants his outputted Excel file to be able to be refreshed automatically from Excel. Refresh from Excel could be, according to user’s will:

refresh from last automatic exportation
refresh from last live data
refresh from a past exportation selected by user [optionnal]

This feature later should be applied to project and orgunit exports.

The issue is separated from issue 0000388.

Additional Information

Limitations and issues regarding automatic refresh :

1.Not sure that you can set up an Excel ODBC / Calc JDBC connection automatically when building an Excel / Calc file from the server-side

2.Because of this feature, it is harder to have a full common development both for Excel and LibreOffice Calc.

3.Security issue... how much is secured the database login/password in Excel file, and in Calc file ?

4.Idea by Ideia : adding a new option in the sigmah.properties configuration file which tells whether or not exportation of automatically refreshable file is allowed by the admin. (so admin can then allow the feature if security is perceived as sufficient and if database will be accessible for planned users through network)

5.Check the risk that a poor Internet connection could corrupt the Excel file if the transmission to the central database is lost during a transfer

Specific issues regarding LibreOffice Calc

1.being sure that the user of the generated Calc file will have access to the relevant JDBC Driver class

2.finding a way to deal with the lack of database password remembering system in the .odb file... every time the file is refreshed (or the .odb file is opened), password will be requested to connect to the production DB.

Tags

No tags attached.

User Report URL

Windows XP

Other OS

Browser

Mozilla Firefox 3.0 (Gran Paradiso)

Other browser

ScreenURL

(ActivityInfo) Noticed in revision

Attached Files

Relationships

related to

0000388

assigned

Guerline

Export to Excel

Notes
(0001006) sherzod (developer) 2012-07-06 11:31	Draft implementation plan: For excel Creating add-in to call remote service with user defined excel functions. xllop (http://xlloop.sourceforge.net/ [^]) tool is a candidate to implement. for libre calc There was not tool to create add-in for libre calc. Instead, Libre Base file could be some kind of datawarehouse to be exported to have a pointer to the database from libre calc. But there are limitations see additional information. Some more info here http://stackoverflow.com/questions/11283601/modify-excel-with-apache-poi-that-has-connection-configured-to-postgresql [^]

Issue History
Date Modified	Username	Field	Change
2012-07-06 11:11	sherzod	New Issue
2012-07-06 11:13	sherzod	Description Updated	View Revisions
2012-07-06 11:13	sherzod	Additional Information Updated	View Revisions
2012-07-06 11:31	sherzod	Note Added: 0001006
2012-07-06 11:33	sherzod	Description Updated	View Revisions
2012-07-10 17:32	osarrat	Relationship added	related to 0000388
2012-07-10 17:33	osarrat	Product Version	unplanned => 1.2
2012-07-10 17:33	osarrat	Target Version	1.2 => unplanned