Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.mac.databases > #102

Re: XML to CSV converter

Show all headers | View raw

On 2014-05-22, Martin Τrautmann <t-usenet@gmx.net> wrote:
> On 21 May 2014 19:38:58 GMT, Jolly Roger wrote:
>> > 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. 
>
> The sender claimed that it could be opened by Excel.

Which tells us nothing.

> I don't know which kind of xml can be handled, but I can send you a
> screenshot how it would look like after an import.

That won't help determine what flavor of schema the XML is. Only
examining the XML itself will tell us that. Care to send a sample XML
file to me via email for examination?
 
>>  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?
>
> I don't know how all of this would help. But if you do insist, it's from
> a government organization their data which was given to us in former
> times as .csv. Now they migrated to a newer system where .xml is its
> output format.

Again, there are many, many flavors of XML. 

There's no such thing as a universal XML converter. You have to know
what DTD or schema is required to correctly convert (transform) XML data
from one format to another (CSV).

-- 
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

Back to comp.sys.mac.databases | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

XML to CSV converter Martin Τrautmann <t-usenet@gmx.net> - 2014-05-20 09:30 +0000
  Re: XML to CSV converter Jolly Roger <jollyroger@pobox.com> - 2014-05-20 18:01 +0000
    Re: XML to CSV converter Martin Τrautmann <t-usenet@gmx.net> - 2014-05-21 06:08 +0000
      Re: XML to CSV converter Jolly Roger <jollyroger@pobox.com> - 2014-05-21 15:35 +0000
        Re: XML to CSV converter Martin Τrautmann <t-usenet@gmx.net> - 2014-05-21 18:32 +0000
          Re: XML to CSV converter Jolly Roger <jollyroger@pobox.com> - 2014-05-21 19:38 +0000
            Re: XML to CSV converter Martin Τrautmann <t-usenet@gmx.net> - 2014-05-22 04:28 +0000
              Re: XML to CSV converter Jolly Roger <jollyroger@pobox.com> - 2014-05-22 05:40 +0000
              Re: XML to CSV converter Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-05-22 18:24 +1200
          Re: XML to CSV converter Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-05-22 09:19 +1200
            Re: XML to CSV converter Jolly Roger <jollyroger@pobox.com> - 2014-05-21 21:26 +0000
              Re: XML to CSV converter Martin Τrautmann <t-usenet@gmx.net> - 2014-05-22 04:41 +0000
            Re: XML to CSV converter Martin Τrautmann <t-usenet@gmx.net> - 2014-05-22 04:29 +0000
  Re: XML to CSV converter Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-05-21 09:21 +1200
    Re: XML to CSV converter Martin Τrautmann <t-usenet@gmx.net> - 2014-05-21 06:13 +0000
      Re: XML to CSV converter Martin Τrautmann <t-usenet@gmx.net> - 2014-05-21 06:50 +0000
      Re: XML to CSV converter Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-05-21 19:10 +1200
        Re: XML to CSV converter Martin Τrautmann <t-usenet@gmx.net> - 2014-05-21 07:29 +0000
          Re: XML to CSV converter Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-05-22 09:21 +1200
  Re: XML to CSV converter Martin Τrautmann <t-usenet@gmx.net> - 2014-05-22 09:39 +0000

csiph-web