Hi I think the file format for the Base database is mainly a zipped set of SQL statements (with added metadata in some XML files too). So you'd need a way to transform the SQL to XML. Would it not be better just to export it as SQL? That might be doable (but I never tried).
Steve On 04/10/2007, Marcin Miłkowski <[EMAIL PROTECTED]> wrote: > Hi, > > this is a nice idea - I also wanted something like repeating XML > "database rows" in XForms in OOo. However, my rows can get pretty > complex, and can contain a lot of optional fields that can contain other > optional fields etc. Lots of recursive structures. > > From the conceptual point of view, this kind of XML should be available > via database component in OOo, and editable through forms in the > database. Yet we lack a standardized XML JDBC driver for direct editing, > I'm afraid. And here goes my question: maybe we could export to XML > using XSLT? Is that possible? > > Best regards, > Marcin > > Stephen Green pisze: > > Hi > > > > How about just using a Calc spreadsheet with a filter so that you can > > use 'Save As' to convert your spreadsheet into the output you want? > > > > I've not tried this with a spreadsheet but intend to do so soon (my > > employers have already standardized on Star Office). I hope it is > > easy enough (we have XSLT skills). Our intended output is flat > > file (fixed width, ideally) but the same should apply as for XML. > > > > Using the spreadsheet, I'm thinking, will give the option of the > > repeated rows where needed. I guess it means mapping from the > > ODF spreadsheet format to the desired output. > > > > Complex bindings, by the way, seem to be difficult to handle by > > the alternative office technologies too in my experience. > > > > Best regards > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Stephen Green Partner SystML, http://www.systml.co.uk Tel: +44 (0) 117 9541606 http://www.biblegateway.com/passage/?search=matthew+22:37 .. and voice
