Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Jolly Roger <jollyroger@pobox.com>
Newsgroups: comp.sys.mac.databases
Subject: Re: XML to CSV converter
Date: 21 May 2014 19:38:58 GMT
Organization: People for the Ethical Treatment of Pirates
Lines: 38
Message-ID: <bu4dmiFfeibU1@mid.individual.net>
References: <slrnlnm86e.uc4.t-usenet@ID-685.user.individual.de> <bu1jjcFroppU1@mid.individual.net> <slrnlnogm1.70.t-usenet@ID-685.user.individual.de> <bu3vehFcfv9U2@mid.individual.net> <slrnlnps9r.70.t-usenet@ID-685.user.individual.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
X-Trace: individual.net YsVOdOszr4P8vY7MjeS7bQocKP9NgS6zU9MREveTv76+Ek4edn
Cancel-Lock: sha1:E7oQPJ1PJtFfeIhxzL+VMWm1NMA=
X-Face: _.g>n!a$f3/H3jA]>9pN55*5<`}Tud57>1<n@LQ!aZ7vLO_nWbK~@T'XIS0,oAJcU.qLM dk/j8Udo?O"o9B9Jyx+ez2:B<nx(k3EdHnTvB]'eoVaR495,Rv~/vPa[e^JI+^h5Zk*i`Q;ezqDW< ZFs6kmAJWZjOH\8[$$7jm,Ogw3C_%QM'|H6nygNGhhl+@}n30Nz(^vWo@h>Y%b|b-Y~()~\t,LZ3e up1/bO{=-)
User-Agent: slrn/1.0.1 (Darwin)
Xref: csiph.com comp.sys.mac.databases:94

On 2014-05-21, Martin Τrautmann <t-usenet@gmx.net> wrote:
> On 21 May 2014 15:35:45 GMT, Jolly Roger wrote:
>> On 2014-05-21, Martin Τrautmann <t-usenet@gmx.net> wrote:
>>> On 20 May 2014 18:01:16 GMT, Jolly Roger wrote:
>>>>
>>>> [Restored deleted quoted content below for context]
>>>>
>>>>  There are many, many flavors of XML. You'll need to figure out
>>>>  what type of XML markup it is and then use an XSL transform to
>>>>  convert it to CSV.
>>>
>>> I have that kind of XML which can be opened directly by Excel.
>>>
>>> I guess that removing all overhead would return a proper .csv - but
>>> I'm afraid that some data would be incomplete, thus giving random
>>> truncation of rows.
>>
>> If it's an Office XML document, and you want to open it in Office
>> 2008, you need the Open XML File Format Converter:
>>
>> <http://www.macworld.com/article/1134138/officeupdates.html>
>
> I did get the converter, but it's not an Office XML and the converter
> can't handle it.

You said it is: "the kind of XML which can be opened directly by Excel".
That could be an indication that it's an Office XML document, which is
why I mentioned it. Now we know it's not Office XML, but still don't
know what type of XML it is. Obviously, more information about the XML
document is required here. So can you tell us more about this mysterious
XML file?  Where did it come from? What application created it? What
else do you know about it?

-- 
E-mail sent to this address may be devoured by my ravenous SPAM filter.
I often ignore posts from Google. Use a real news client instead.

JR