|Anonymous | Login | Signup for a new account||2013-05-22 11:06 CEST|
|Main | My View | View Issues | Change Log | Roadmap | My Account|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0000473||sigmah||[All Projects] General||public||2012-07-06 11:11||2012-07-10 17:33|
|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:
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|
|Browser||Mozilla Firefox 3.0 (Gran Paradiso)|
|(ActivityInfo) Noticed in revision|
Draft implementation plan:
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 [^]
|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|
|Copyright © 2000 - 2010 MantisBT Group|