kexi project
Rapid Database Application Development
Development
"Microsoft Access for Linux"

Home Download FAQ Support Features Handbook Screenshots Screencasts Compile Kexi Development Authors Contact License Sponsorship Translate This Site

wiki navigation:

Front Page
[info] [diff] [login]
[recent changes]
[most popular]
You can donate
to Kexi Project:
Via PayPal

Spread the word about Kexi!
Get Kexi Now!

Built on the KDE technology
KDE

Member of the Calligra Suite

No Software Patents!

Developer Jobs : KOffice Integration Developer Jobs

Converting Kexi Data Table to KOffice document

 Creation date: 2004-12-10
 Docs maintained by: jstaniek

Table of Contents
   Objectives
   Sub-tasks
   Extensions
     Publishing commands

Objectives

We need a way to convert tabular data (a result of query execution) to common document formats:

  • KSpread
  • OASIS (openoffice.org) Calc
  • CSV (comma-separated value)

KSpread and oo.o formats could be handled in a very similar way.

^ toc

Sub-tasks

  • Check what GUI elements (dialogs?) could be adopted or shared from KOffice, especially for CSV (comma separated value)format. Note that most probably KOffice's csv filter and dialogs are too simplified compared to Kexi needs (Kexi is a DB app after all).
  • Make a non-GUI prototype for exporting kexi data table using KOffice filters
  • Make Test Suite containing many different use cases for data exporting and store it in a centralized place
  • Propose command line options to ease automatic tests. Most of these options could be also kept for end-users.
^ toc

Extensions

^ toc

Publishing commands

Add command like "Publish in spreadsheet" or "Publish in document". E.g. MSA names this explicity like "Publish it in Word": 1. .rtf file is created (in this case, for other cases e.g. spreadsheet file can be created) 2. associated application will be started and the created document will be loaded.

Note: In fact MSA is WRONG with "Publish it in Word" command name because, e.g. OO.org Writer can be associated with this docuemnt type. So let's not copy this hardcoded naming scheme.

TODO: more info



Kexi - "MS Access for Linux" ... and Windows
© 2002-2007 Kexi Team
This content is available under GFDL
Last edited: November 18, 2005 by js, visited 0 times.