1 / 10

OpenDocument Format (ODF) SpreadSheet Emitter for BIRT

OpenDocument Format (ODF) SpreadSheet Emitter for BIRT. Santosh Kumar IBM India Software Labs ksantosh@in.ibm.com. BIRT. Business Intelligence and Reporting Tools Eclipse-based open source reporting framework

hop-moss
Download Presentation

OpenDocument Format (ODF) SpreadSheet Emitter for BIRT

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. OpenDocument Format (ODF) SpreadSheet Emitter for BIRT Santosh Kumar IBM India Software Labs ksantosh@in.ibm.com

  2. BIRT • Business Intelligence and Reporting Tools • Eclipse-based open source reporting framework • Provides core reporting features such as report layout, data access and scripting. • Outputs reports in different formats • HTML, PDF etc. Different emitters used for each format

  3. What is ODF, the OpenDocument Format? • An XML-based specification describing the content and formatting of a document. • The open standard developed by a multi-vendor committee at OASIS and an ISO standard. • The default document format in prominent office suites including OpenOffice.org, Google Docs, IBM Lotus Symphony and IBM Productivity Tools in Notes 8. • The option that gives the most choices for interoperability and future-proofing information.

  4. Why ODF SpreadSheet Emitter • Standardized XML file format : Provides control over documents • Multi Platform Support - Supported on Windows, Linux and Mac • Better interoperability : Separation of document from application Document can be processed by other applications • Provides choice, freedom of action, cost effectiveness, access to innovation and greater control over the use of documents • Once the data is in Spreadsheet, it can be manipulated using Spreadsheet functions/formula's.

  5. ODF Basics • Filename extensions OpenDocument documents .odt for word processing (text) documents .ods for spreadsheets .odp for presentations • Basic anatomy of ODF file • Zip container • Manifest, mimetype and streams • Content.xml • Meta.xml • Styles.xml

  6. ODF SpreadSheet Emitter for BIRT • Implementation of ODS (Open Document Spreadsheet) custom BIRT emitter. • Creates ODF Spread-Sheets from BIRT reports • Prototype supports extraction of data and basic styles into spreadsheet. • Work in progress to match original layout of the report and output images.

  7. BIRT IBM Symphony ODF SpreadSheet Emitter

  8. Emitter Extension ODF DOM API (Java) BIRT ODS Spreadsheet Basic Design • Leverage BIRT emitter extension point to read report design and data. • ODF DOM API to create the ODF model representation of ODS Spreadsheet.

  9. The Challenge : Need of programming frameworks • Programming the ODF as XML DOM elements requires mastery of ODF specification. There is need of an ODF API that exposes a higher level abstraction of ODF to application developers • Odf4j in ODFToolkit intends to provide programming framework in Java for creating and processing ODF document. Odf4j is still in early stages. • Initial prototypes of ODF based emitter are based on Odf4j with added extensions.

  10. References • General information on ODF available at: • http://opendocument.xml.org • http://odfalliance.org • Odf4j • http://odftoolkit.openoffice.org/source/browse/odftoolkit/odf4j/

More Related