OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Howto Import a fully structured XML document into Base

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
Hans Bos
Newbie
Newbie


Joined: 09 Jun 2012
Posts: 1

PostPosted: Sat Jun 09, 2012 3:24 am    Post subject: Howto Import a fully structured XML document into Base Reply with quote

Hi all,
I have a fully XML structured text document.
For quite I while now I try to find a way to use the information that's in there.
Without success.

Next step in this quest:

Is it possible to import XML data files into openoffice Base?
If so? howto do this?

Thanks in advance.
Back to top
View user's profile Send private message
dacm
Super User
Super User


Joined: 07 Jan 2010
Posts: 769

PostPosted: Sun Jun 10, 2012 6:50 am    Post subject: Reply with quote

Perhaps convert to CSV:
http://www.luxonsoftware.com/opensource/xmltocsv
http://xmltocsv.codeplex.com/

THEN:
(1) open directly in Base as a Text file (Connect to existing database > Text)
-or-
(2) import into Calc to create a flat-file spreadsheet database for Base (Connect to existing database > Spreadsheet)
-or-
(3) drag&drop from Calc to Base (new embedded or preferably non-embedded database)
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Splitting 'Embedded databases'
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Jun 10, 2012 9:50 am    Post subject: Re: Howto Import a fully structured XML document into Base Reply with quote

Hans Bos wrote:
Hi all,
I have a fully XML structured text document.
For quite I while now I try to find a way to use the information that's in there.
Without success.

Next step in this quest:

Is it possible to import XML data files into openoffice Base?
If so? howto do this?

Thanks in advance.

It is possible to write an XSLT script for Calc, open the table in Calc and then copy the table into Base.

Base is not a database. It is just a frontend to several types of connectable databases. The type of database is indicated in the status bar. The built-in HSQLDB engine can not import XML.
If your favourite database engine can import XML, you can connect Base to that database. External database have by far more advantages than disadvantages.
The built-in database is very limited and poses a considarable threat to your data.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group