Hallo,
We uses for simple xml import a French made
(www.StarExpert.fr)mportfilter "xml2calc" i do
not now about new/better
versions but google for xml2calc and try if its handles you
xml
hopes it help a bit
Fzernand
Gannon Dick wrote:
> An OO import filter is hard work for the smart, I'm
told, not being one
> of those. An XSL transform to a file format scalc
understands (try
> CSV, it's simple) is not so bad.
>
> BTW, what you have is the xml put out by a MS SQL
Server data base.
> You shouldn't get the idea that all xml is so complex.
The complexity
> comes more from data base issues than from the
content.
>
> Good Luck,
> Gannon
> --- Oliver Brinzing <Oliver.Brinzing gmx.de> wrote:
>
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Hi,
>>
>> you can try to build a xslt import filter ...
>>
>> http://www-128.ibm.com/developerworks/xml/library/x-o
ocalc/
>>
>> Oliver
>>
>> Am 09.10.2007 17:19 schrieb Richard A. DeVenezia:
>>
>>> I have received an xml file and don't know the
rituals needed to
>>>
>> get to
>>
>>> appear in calc
>>>
>>> The file looks like this:
>>>
>>> <?xml version="1.0"
standalone="yes"?>
>>> <NewDataSet>
>>> <xs:schema id="NewDataSet"
xmlns=""
>>> xmlns s=&qu
ot;http://www.w3.
org/2001/XMLSchema"
>>>
xmlns:msdata="urn:schemas-microsoft-comml-ms
data">
>>> <xs:element name="NewDataSet"
msdata:IsDataSet="true"
>>> msdata:UseCurrentLocale="true">
>>> <xs:complexType>
>>> <xs:choice minOccurs="0"
maxOccurs="unbounded">
>>> <xs:element
name="Table">
>>> <xs:complexType>
>>> <xs:sequence>
>>> <xs:element
name="MemberID" type="xs:int"
>>>
>> minOccurs="0" />
>>
>>> <xs:element
name="LastName" type="xs:string"
>>>
>> minOccurs="0"
>>
>>> />
>>> <xs:element
name="FirstName" type="xs:string"
>>>
>> minOccurs="0"
>>
>>> />
>>> <xs:element
name="MiddleName" type="xs:string"
>>>
>> minOccurs="0"
>>
>>> />
>>> <xs:element
name="LeagueRating" type="xs:short"
>>> minOccurs="0" />
>>> <xs:element
name="Rating" type="xs:short"
>>>
>> minOccurs="0" />
>>
>>> <xs:element
name="ExpirationDate"
>>>
>> type="xs:dateTime"
>>
>>> minOccurs="0" />
>>> <xs:element
name="Sex" type="xs:string"
>>>
>> minOccurs="0" />
>>
>>> <xs:element
name="Email" type="xs:string"
>>>
>> minOccurs="0" />
>>
>>> </xs:sequence>
>>> </xs:complexType>
>>> </xs:element>
>>> </xs:choice>
>>> </xs:complexType>
>>> </xs:element>
>>> </xs:schema>
>>> <Table>
>>> <MemberID>906675</MemberID>
>>> <LastName>Abraham</LastName>
>>> <FirstName>Byron</FirstName>
>>> <MiddleName />
>>>
<LeagueRating>663</LeagueRating>
>>> <Rating>0</Rating>
>>>
<ExpirationDate>2007-07-25T00:00:00-07:00</Expirati
onDate>
>>> <Sex>M</Sex>
>>> <Email />
>>> </Table>
>>> ... lots more <table> for each row
>>> </NewDataSet>
>>>
>>> Any help or pointers is appreciated.
>>>
>>> TIA,
>>>
>>> Richard A. DeVenezia
>>>
>>>
>>>
>>
------------------------------------------------------------
---------
>>
>>> To unsubscribe, e-mail: dev-unsubscribexml.openoffice.org
>>> For additional commands, e-mail: dev-helpxml.openoffice.org
>>>
>>>
>> - --
>>
>> GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06
4E2C AB40 CFD0
>> 4A45
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.7 (MingW32)
>> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>>
>>
iD8DBQFHC6l3TiyrQM/QSkURAjAkAJ0ceutwqXq6eoMeXCXD0Wuce+puIwCf
faMi
>> grIpIzXxiWRRtkQBr1bttcY=
>> =PZtY
>> -----END PGP SIGNATURE-----
>>
>>
------------------------------------------------------------
---------
>> To unsubscribe, e-mail: dev-unsubscribexml.openoffice.org
>> For additional commands, e-mail: dev-helpxml.openoffice.org
>>
>>
>>
>
>
>
>
>
____________________________________________________________
________________________
> Looking for a deal? Find great prices on flights and
hotels with Yahoo! FareChase.
> http://farechase.yahoo.co
m/
>
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: dev-unsubscribexml.openoffice.org
> For additional commands, e-mail: dev-helpxml.openoffice.org
>
------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribexml.openoffice.org
For additional commands, e-mail: dev-helpxml.openoffice.org
|