[Libreoffice] When can we import xml data

[Fernand Vanrie]

Hi Michael ,

Thanks for your interest, With xml-data i mean a data-dump from a SQL 
database. Where records becomes rows and fields becomes columbs. MS Exel 
can flawless open this xml-files.
The xml structure depends on the Table of the database but mostly its 
something like:

<?xml version='1.0'?>
<NewDataSet>
<Table>
<id>1</id>
<linkid>76497</linkid>
<TextBox>ANC</TextBox><Type>Week</Type>
<Formaat>Executive - 148x210mm</Formaat>
<Formaatuitz />
<Kaft>ik heb reeds een kaft</Kaft>
<email>anc at pmg.be</email>
</Table>
<Table>
<id>2</id>
<linkid>76502</linkid>
<TextBox>SAF</TextBox>
<Type>Dag</Type>
<Formaat>Executive - 148x210mm</Formaat>
<Formaatuitz />
<Kaft>ik heb nog geen kaft</Kaft>
<email>saf at pmg.be</email>
</Table>

The StarXpert import filter clould handles this dumps at condition that 
"all" fields (also empty radio buttons etc..)  where represented by a tag.

Hope it helps

Fernand


> Hi Fernand,
>
> On Wed, 2011-04-13 at 10:29 +0200, Fernand Vanrie wrote:
>> I am just a humble advanced user, The extentsion from StarXpert is a
>> scrumbled jar file.
> 	:-) with no source code ? if so, hard to deal with.
>
>> Its not the Extension who is faulty, its simple a lack of XML
>> import for Calc in LO and OO .
> 	We import lots of styles and dialects of XML - what would really help
> is a well-formed report: what kind of XML do you want to import ? where
> is it specified ? is there an example set of files etc. ?
>
>> Just hoped to find here a coder who can/will make this happen or can
>> rewrite the StarXpert java Code into a nex etxtension.
> 	Well, importing some sort of XML sounds pretty trivial to me - we could
> make it an easy hack, if it is a popular dialect, and there are good
> docs I guess. Can you file a bug with all the relevant details, and
> reply to this mail with the number ?
>
> 	Thanks,
>
> 		Michael.
>