Data liberation: Difference between revisions

From OpenPetra Wiki
Jump to navigation Jump to search
Line 10: Line 10:


== OpenOffice file support (OpenDocument) ==
== OpenOffice file support (OpenDocument) ==
* http://www.codeguru.com/csharp/csharp/cs_data/xml/article.php/c16311 How to Read and Write ODF/ODS Files (OpenDocument Spreadsheets)
===Manual Way===
* http://opendocument4all.com/content/view/13/29/ "AODL has been started by Lars Behrmann as a independent C# library for all kinds of ODF processing and in February 2007 it has become the .net module of the OpenOffice.org ODF Toolkit project. The library is completly written in pure C# and can be used to extend your .net based software to support the OpenDocument Format."
The article [http://www.codeguru.com/csharp/csharp/cs_data/xml/article.php/c16311 How to Read and Write ODF/ODS Files (OpenDocument Spreadsheets)] explains the steps a C# programmer needs to make to have basic read and write capabilities for the OpenDocument Spreadsheet format. No external library is needed for that.
** project home: http://wiki.services.openoffice.org/wiki/AODL
 
===AODL .NET Library===
"AODL is the .net module of the ODF Toolkit. The library is completly written in pure C# and can be used to extend your .net based software to support the OpenDocument Format. To use AODL within your projects respectively software there is no need of a deep knowlegde of the OpenDocument Format itself. It would be helpfull to understand what's going behind the scenes and for writing your own extensions, but as mentioned before this isn't a fundamental requirement."
 
* Creating new documents in the text and the spreadsheet format.
* Loading and manipulating documents in the text and spreadsheet format.
* Initial support for Charts within Spreadsheet Documents.
* Export loaded or created documents into the HTML format (text and spreadsheet documents).
* Export loaded or created documents into the PDF Format. (this is in an early state of implementation and only available for text documents)
 
====Links====
* [http://odftoolkit.org/projects/aodl/pages/Home AODL Project Home]
* [http://odftoolkit.org/projects/aodl/pages/WikiFAQ FAQ's]
** According to the FAQ, AODL does ''not'' need an installed OpenOffice on the machine where it is executed and works on mono on Linux as well!
* [http://odftoolkit.org/projects/aodl/downloads Download of Sources and Binaries]
** The Mercurial Code Repository isn't working (as of 23 Dec. 2010), but the sources can be downloaded and they compile OK


== Microsoft Excel file support (Office Open XML) ==
== Microsoft Excel file support (Office Open XML) ==

Revision as of 07:13, 23 December 2010

Data liberation

The idea is that it should be easy to get data in and out of OpenPetra.org

XML/YML/CSV support

  • XML: advantages: easier to handle from external programs, they can transform the data
  • YML: advantages: easy to read and write for manual adjustments
  • CSV: advantages: edit long lists; problems: Excel reformats and may cut off account codes etc

OpenOffice file support (OpenDocument)

Manual Way

The article How to Read and Write ODF/ODS Files (OpenDocument Spreadsheets) explains the steps a C# programmer needs to make to have basic read and write capabilities for the OpenDocument Spreadsheet format. No external library is needed for that.

AODL .NET Library

"AODL is the .net module of the ODF Toolkit. The library is completly written in pure C# and can be used to extend your .net based software to support the OpenDocument Format. To use AODL within your projects respectively software there is no need of a deep knowlegde of the OpenDocument Format itself. It would be helpfull to understand what's going behind the scenes and for writing your own extensions, but as mentioned before this isn't a fundamental requirement."

  • Creating new documents in the text and the spreadsheet format.
  • Loading and manipulating documents in the text and spreadsheet format.
  • Initial support for Charts within Spreadsheet Documents.
  • Export loaded or created documents into the HTML format (text and spreadsheet documents).
  • Export loaded or created documents into the PDF Format. (this is in an early state of implementation and only available for text documents)

Links

  • AODL Project Home
  • FAQ's
    • According to the FAQ, AODL does not need an installed OpenOffice on the machine where it is executed and works on mono on Linux as well!
  • Download of Sources and Binaries
    • The Mercurial Code Repository isn't working (as of 23 Dec. 2010), but the sources can be downloaded and they compile OK

Microsoft Excel file support (Office Open XML)

Data Exchange between Software Services

This is quite different from the previous approaches, because it does not target the user, but the data exchange between software services and programs; one example could be an AJAX webclient that communicates with the server via JSON or XML.

JSON