Ask Your Question
0

export xml file

asked 2017-12-19 07:42:36 +0200

clintonwp gravatar image

I'm switching from OpenOffice to LibreOffice. Almost everything I know about databases has been gleaned from the internet so my knowledge is very patchy, and I need answers in simple English please.

I need to generate an XML file from a collection of data (tables or spreadsheets), preferably a relational database which I'll create.

Is there an "elegant" way to do this?

In OpenOffice Base I have used a Select statement to achieve this (conditionally wrapping the xml tags around items from tables), but then needing to import into a spreadsheet, save as csv, open in a reader app, replace tabs with carriage returns, and so on.

I've also tried doing it as a Mail Merge scenario but it is also very messy.

I reckon there must be something I just haven't discovered yet, because this scenario seems such a basic thing for a database (or other) to be able to do.

Within reason, I'm capable of doing a basic level of programming I think this task should require.

I'd very much appreciate a point in the right direction, before I spend a lot of time researching many possibilities.

So far it appears to me that I'm going to have to write an export filter. Is there a simpler solution?

Thanks in advance.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-12-19 22:56:32 +0200

m.a.riosv gravatar image

Maybe you can find help in XML Filter Settings

edit flag offensive delete link more

Comments

My query is about what direction I need to take, rather than how to do it :)

clintonwp gravatar imageclintonwp ( 2017-12-19 23:39:39 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-12-19 07:42:36 +0200

Seen: 1,091 times

Last updated: Dec 19 '17