Export to XML flat data table?

Discuss the spreadsheet application

Export to XML flat data table?

Postby inaction_figure » Wed Oct 10, 2012 11:49 pm

Hi,

In order to generate simple flat XML data tables, I'd like to be able to export a table from Calc to XML. I'm thinking of the "Developer" Export to XML functionality in M$ Excel.

I'm using Linux Mint 12 and LibreOffice 3.4.4.

If I'm going about this the wrong way, please point me in the right direction.

Thanks in advance,
Eric
LibreOffice 3.4.4 on Linux Mint 12
inaction_figure
 
Posts: 2
Joined: Wed Oct 10, 2012 11:44 pm

Re: Export to XML flat data table?

Postby Villeroy » Thu Oct 11, 2012 12:11 am

$ unzip foo.ods content.xml
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28641
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Export to XML flat data table?

Postby inaction_figure » Wed Oct 17, 2012 12:56 am

Well, yes, that IS an XML file. So, thank you, but I should have been more specific.

Is there a way, besides creating XSLT transformations to use with the "XML Filter Settings", to export from a table in Calc to an XML with a schema with named records and fields?

For that matter, is there an easy way to create the XSLT stylesheet?

Thanks,
Eric
LibreOffice 3.4.4 on Linux Mint 12
inaction_figure
 
Posts: 2
Joined: Wed Oct 10, 2012 11:44 pm

Re: Export to XML flat data table?

Postby Robert Tucker » Wed Oct 17, 2012 4:00 pm

Have you read this thread from the other forum:

http://www.oooforum.org/forum/viewtopic.phtml?t=6809

You could also have a look at iReport:

http://community.jaspersoft.com/project ... t-designer

though writing an xslt might be easier than getting through their tutorials!
LibreOffice 6.x.x on Fedora 32 and Ubuntu 20.04 (Dual Boot)
User avatar
Robert Tucker
Volunteer
 
Posts: 1247
Joined: Mon Oct 08, 2007 1:34 am
Location: Manchester UK

Re: Export to XML flat data table?

Postby Villeroy » Wed Oct 17, 2012 5:09 pm

Robert Tucker wrote:Have you read this thread from the other forum:

http://www.oooforum.org/forum/viewtopic.phtml?t=6809


That topic on oooforum.org is a perfect example of what goes wrong when people refer to meta file formats as if they were file formats. Just like CSV, XML is not a file format. XML is a standard about how to write your own file formats (csv is not even a standard).
Someone who names himself "Dave_is_sexy" insists in some magic feature to perform the type of conversion he needs right now in the most convenient manner (how unsexy!). He does not drop a single line of input data to be transfered nor any example about the actual output format he needs. At least he could mention some other application which is supposed to import the exported XML. Sexy Dave wants to find some useful idiot to do all the coding for him. Having found one, he is not even able to analyse and debug the code that has been given to him and that is the end of that topic. It's not difficult to imagine how he behaves in sex life.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28641
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: Bill and 20 guests