Difference between revisions of "User:DrewJensen/XML export"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
m
Line 3: Line 3:
 
The default database , HSQLDB, as incorporated into Base currently has no XML generating capabilities
 
The default database , HSQLDB, as incorporated into Base currently has no XML generating capabilities
  
In parallel with the work on the CSV export I purpose to work on a simple XML export also.  This effort will utilize parts of the basic library being created for the later. The effort here will be therefore to produce the first implementation in OOBase as much as a prototype as anything.
+
In parallel with the work on the CSV export I propose work on a simple XML export also.  This effort will utilize parts of the basic library being created for the former. This effort will be therefore to produce the first implementation in OOBasic as much as a prototype as anything.
  
Much of the information needed to handle this function is identical to that required for any export. It will mimic the filing naming scheme used by the CSV export. This would be a type of flat data dump in other words.
+
Much of the information needed to handle this function is identical to that required for any export. It will mimic the filing naming scheme used by the CSV export.  
  
 
The XML export should support a number of different modes.  
 
The XML export should support a number of different modes.  
  
At it simplest it would generate a file containing  a sequence of XML tags and values mirroring the data format in an CSV file.
+
At it simplest it would generate a file containing  a sequence of XML tags and values mirroring the data format in an CSV file. This would be a type of flat data dump in other words.
 
   
 
   
 
Another mode would be a simple group oriented nested output. This might be simply an object named <ExportObjectName><Row Name><seq>Columns</seq></RowName></ExportObjectName> format.
 
Another mode would be a simple group oriented nested output. This might be simply an object named <ExportObjectName><Row Name><seq>Columns</seq></RowName></ExportObjectName> format.

Revision as of 09:22, 17 September 2006

CSV file formatted data is still commonly used and is arguably the first required format for any database export utility. However, XML is rapidly approaching a par as being the other first required data export format.

The default database , HSQLDB, as incorporated into Base currently has no XML generating capabilities

In parallel with the work on the CSV export I propose work on a simple XML export also. This effort will utilize parts of the basic library being created for the former. This effort will be therefore to produce the first implementation in OOBasic as much as a prototype as anything.

Much of the information needed to handle this function is identical to that required for any export. It will mimic the filing naming scheme used by the CSV export.

The XML export should support a number of different modes.

At it simplest it would generate a file containing a sequence of XML tags and values mirroring the data format in an CSV file. This would be a type of flat data dump in other words.

Another mode would be a simple group oriented nested output. This might be simply an object named <ExportObjectName><Row Name><seq>Columns</seq></RowName></ExportObjectName> format.

Finally a mode using a mapping file to represent more complex data structures. One possibility of a format for this would be an XSD file.

Personal tools