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 <[EMAIL PROTECTED]> 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-oocalc/
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:xs="http://www.w3.org/2001/XMLSchema";
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<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</ExpirationDate>
<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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
- --
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+puIwCffaMi
grIpIzXxiWRRtkQBr1bttcY=
=PZtY
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
____________________________________________________________________________________
Looking for a deal? Find great prices on flights and hotels with Yahoo!
FareChase.
http://farechase.yahoo.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
