Need to import data from web in xml format?

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
Gabe
Posts: 2
Joined: Mon Mar 03, 2008 11:09 pm

Need to import data from web in xml format?

Post by Gabe »

Hi All -

I use a script feed in XML that is provided to me from service provider, which in the past I have use in excel template. I used the command in excel under the "data" insert from web - inport into excel and reformat for my effort. Rearrange colums and rows....

I'd like to use OpenOffice to try and to the same thing...any ideas/help? I can send sample if that would help.

Many Thnaks-

Gabe

http://statfeed.statfox.com/webservices ... =2/29/2008 this is the linkI would like to import and maintain headings etc.
hol.sten
Volunteer
Posts: 495
Joined: Mon Oct 08, 2007 1:31 am
Location: Hamburg, Germany

Re: Need to import data from web in xml format?

Post by hol.sten »

Gabe wrote:any ideas
You can try to create your own XSLT import filter for OOo. Read more on this topic for example here:
- [solved] Calc is crashing while loading XML-file: http://www.oooforum.org/forum/viewtopic.phtml?t=51387
- German: XML Datei importieren die Integerwerte enthält: http://de.openoffice.info/viewtopic.php ... hlight=xsl
- Again only german: Problem mit der Zahlenformatieren nach XML Import: http://de.openoffice.info/viewtopic.php ... slt#p68337
OOo 3.2.0 on Ubuntu 10.04 • OOo 3.2.1 on Windows 7 64-bit and MS Windows XP
Post Reply