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

Groups > comp.sys.mac.databases > #84 > unrolled thread

XML to CSV converter

Back to article view | Back to comp.sys.mac.databases

Contents

  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

#84 — XML to CSV converter

Hi all,

is there any xml to csv (or xml to anything) converter which you could
recommend?

When I google around for "xml2csv mac" I find tons of them - which then
appear to be .exe

Excel from Microsoft Office 2007 is supposed to open .xml properly.
But that's the Win version. Office 2008 for Mac is not able to do so.

FileMaker offers the capability to write .xml - but its capabilities to
read .xml are more than limited.

LibreOffice does refuse to read .xml, as long as there is no proper .xsl
info first. I guess the same is true for OpenOffice.

Any idea?

Thanks,
Martin

[toc] | [next] | [standalone]

#85

On 2014-05-20, Martin Τrautmann <t-usenet@gmx.net> wrote:
> Hi all,
>
> is there any xml to csv (or xml to anything) converter which you could
> recommend?
>
> When I google around for "xml2csv mac" I find tons of them - which then
> appear to be .exe
>
> Excel from Microsoft Office 2007 is supposed to open .xml properly.
> But that's the Win version. Office 2008 for Mac is not able to do so.
>
> FileMaker offers the capability to write .xml - but its capabilities to
> read .xml are more than limited.
>
> LibreOffice does refuse to read .xml, as long as there is no proper .xsl
> info first. I guess the same is true for OpenOffice.
>
> Any idea?
>
> Thanks,
> Martin

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.

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

[toc] | [prev] | [next] | [standalone]

#87

On 20 May 2014 18:01:16 GMT, Jolly Roger wrote:
>  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.

- Martin

[toc] | [prev] | [next] | [standalone]

#92

On 2014-05-21, Martin Τrautmann <t-usenet@gmx.net> wrote:
> On 20 May 2014 18:01:16 GMT, Jolly Roger wrote:
>>  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>

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

[toc] | [prev] | [next] | [standalone]

#93

On 21 May 2014 15:35:45 GMT, Jolly Roger wrote:
>  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.

- Martin

[toc] | [prev] | [next] | [standalone]

#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

[toc] | [prev] | [next] | [standalone]

#99

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

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

- Martin

[toc] | [prev] | [next] | [standalone]

#102

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

[toc] | [prev] | [next] | [standalone]

#103

In article <slrnlnqv7c.70.t-usenet@ID-685.user.individual.de>, 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.

Then I'd get them to open it and resave it as a CSV ... that's probably
the easiest solution for something that is only done once a year. Maybe
by next year they can have their system fixed so it works properly
again.

Helpful Harry   :o)

[toc] | [prev] | [next] | [standalone]

#95

In article <slrnlnps9r.70.t-usenet@ID-685.user.individual.de>, Martin
Ԥrautmann <t-usenet@gmx.net> wrote:

> On 21 May 2014 15:35:45 GMT, Jolly Roger wrote:
> >  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.

I wouldn't be at all surprised if Microsoft has made their own XML
"standard" which doesn't match the established one everyone else uses.

Either way, it looks like you're going to have to create your own
solution, at least until the next version of Mac Office is released.

Helpful Harry  :o)

[toc] | [prev] | [next] | [standalone]

#97

On 2014-05-21, Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:
> In article <slrnlnps9r.70.t-usenet@ID-685.user.individual.de>, Martin
> Ԥrautmann <t-usenet@gmx.net> wrote:
>
>> On 21 May 2014 15:35:45 GMT, Jolly Roger wrote:
>> >  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.
>
> I wouldn't be at all surprised if Microsoft has made their own XML
> "standard" which doesn't match the established one everyone else uses.

It's called Open XML:

<http://en.wikipedia.org/wiki/Office_Open_XML>

> Either way, it looks like you're going to have to create your own
> solution, at least until the next version of Mac Office is released.
>
> Helpful Harry  :o)

That wholly depends on *what type of XML* it is. He hasn't yet told us
that. In fact he's told us extremely little about the file.

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

[toc] | [prev] | [next] | [standalone]

#101

On 21 May 2014 21:26:56 GMT, Jolly Roger wrote:
>  That wholly depends on *what type of XML* it is. He hasn't yet told us
>  that. In fact he's told us extremely little about the file.

That should not bother you. All I want is a reasonable xml to csv
converter.

The web solution that HH named did work on two smaller files. But it's
limited to 4 MB, while my current file is 24 MB and future files
probably will be much, much larger, due to the incredible overhead of
XML.

However, the web solution did recognize that multiple documents (or
tables or sheets) are part of the .xml file, which returned a folder
with the files

0025712.xml/AA_Empfaenger.csv 
0025712.xml/AX_Benutzungsauftrag.csv
0025712.xml/AX_FOLGEVA.csv
0025712.xml/Query.csv
0025712.xml/anforderungsmerkmale.csv
0025712.xml/empfaenger.csv
0025712.xml/folgeverarbeitung.csv


AA_Empfaenger contained:
direkt,empfaenger_Id
"true",0

Other files contained just some info whether the export was successful,
but nothing relevant to me.

So this converter did not mind about the origin of the .xml or whatever
might be relevant. It just checked the data and created multiple
separate .csv files.

It is what I expect. 

So instead of waiting for another Office version I would go to a Win
(virtual) machine instead.

But I would prefer a Mac only solution. I'm afraid that no one here does
know such a thing. 

- Martin

[toc] | [prev] | [next] | [standalone]

#100

On Thu, 22 May 2014 09:19:23 +1200, Helpful Harry wrote:
>  Either way, it looks like you're going to have to create your own
>  solution, at least until the next version of Mac Office is released.

I suppose I'll never take the next Mac Office release sind LibreOffice
is all I need.

- Martin

[toc] | [prev] | [next] | [standalone]

#86

In article <slrnlnm86e.uc4.t-usenet@ID-685.user.individual.de>, Martin
Ԥrautmann <t-usenet@gmx.net> wrote:
> 
> Hi all,
> 
> is there any xml to csv (or xml to anything) converter which you could
> recommend?
> 
> When I google around for "xml2csv mac" I find tons of them - which then
> appear to be .exe
> 
> Excel from Microsoft Office 2007 is supposed to open .xml properly.
> But that's the Win version. Office 2008 for Mac is not able to do so.
> 
> FileMaker offers the capability to write .xml - but its capabilities to
> read .xml are more than limited.
> 
> LibreOffice does refuse to read .xml, as long as there is no proper .xsl
> info first. I guess the same is true for OpenOffice.
> 
> Any idea?
> 
> Thanks,
> Martin


I have no idea how good / bad they are, but a quick Google search for
"convert xml to csv mac" does turn up these two suggestions:
http://mac.softpedia.com/get/Utilities/XSlicer.shtml
http://xmltocsv.codeplex.com/
(among others), or using an online service such as
http://www.luxonsoftware.com/



Do you have an example of the XML text and the CSV output you want? As
long as an individual XML line doesn't overwhelm a FileMaker field, it
should technically be possible to write a converter in FileMaker by
importing the XML as plain text.

There is also a new version of Mac Office due at some stage.

Helpful Harry  :o)

[toc] | [prev] | [next] | [standalone]

#88

On Wed, 21 May 2014 09:21:11 +1200, Helpful Harry wrote:
>  I have no idea how good / bad they are, but a quick Google search for
>  "convert xml to csv mac" does turn up these two suggestions:
>  http://mac.softpedia.com/get/Utilities/XSlicer.shtml

A Java tool for a text only conversion?
If nothing else helps...

>  http://xmltocsv.codeplex.com/
>  (among others), 

yes, there are many. many others. That's why I asked for a
recommendation.


>  or using an online service such as
>  http://www.luxonsoftware.com/

An online service looks inappropriate for files > 20 MB.

>  Do you have an example of the XML text and the CSV output you want? 

yes, I guess - I have the former csv version which is

type	blah	text	num
1	01	abc
2	0101	def	1
2a	0999	ghi	2


>  As
>  long as an individual XML line doesn't overwhelm a FileMaker field, it
>  should technically be possible to write a converter in FileMaker by
>  importing the XML as plain text.

Ouch, no thanks - I'd use perl instead.

>  There is also a new version of Mac Office due at some stage.

It's a ridiculous XML hype. Everything now is XML - but everyone does
use it for export only and no one cares about import. Including FMP.

- Martin

[toc] | [prev] | [next] | [standalone]

#89

On Wed, 21 May 2014 06:13:48 +0000 (UTC), Martin Τrautmann wrote:
>  On Wed, 21 May 2014 09:21:11 +1200, Helpful Harry wrote:
> >  I have no idea how good / bad they are, but a quick Google search for
> >  "convert xml to csv mac" does turn up these two suggestions:
> >  http://mac.softpedia.com/get/Utilities/XSlicer.shtml
> 
>  A Java tool for a text only conversion?
>  If nothing else helps...

ouch, that's not actually for Mac

> >  http://xmltocsv.codeplex.com/
> >  (among others), 
> 
>  yes, there are many. many others. That's why I asked for a
>  recommendation.

and I had checked several of them before.

> >  or using an online service such as
> >  http://www.luxonsoftware.com/
> 
>  An online service looks inappropriate for files > 20 MB.

However, it worked on a smaller sample - its limit is 4 MB. 
Unfortunately, this conversion showed one proper data.csv, but some more
garbage files, which where included within the .xml, but are not helpful
for my work.

- Martin

[toc] | [prev] | [next] | [standalone]

#90

In article <slrnlnoh0s.70.t-usenet@ID-685.user.individual.de>, Martin
Ԥrautmann <t-usenet@gmx.net> wrote:

> On Wed, 21 May 2014 09:21:11 +1200, Helpful Harry wrote:
> >  I have no idea how good / bad they are, but a quick Google search for
> >  "convert xml to csv mac" does turn up these two suggestions:
> >  http://mac.softpedia.com/get/Utilities/XSlicer.shtml
> 
> A Java tool for a text only conversion?
> If nothing else helps...
> 
> >  http://xmltocsv.codeplex.com/
> >  (among others), 
> 
> yes, there are many. many others. That's why I asked for a
> recommendation.

Those were the two suggestions by someone answering the same question
in a forum topic the Google search turned up, but the Google search
also turned up more links for downloading a converter (some of which
may well simply have been those two at different download websites).



> >  or using an online service such as
> >  http://www.luxonsoftware.com/
> 
> An online service looks inappropriate for files > 20 MB.
> 
> >  Do you have an example of the XML text and the CSV output you want? 
> 
> yes, I guess - I have the former csv version which is
> 
> type   blah  text  num
> 1   01 abc
> 2   0101  def   1
> 2a  0999  ghi   2

What does the incoming XML file look like?




> >  As long as an individual XML line doesn't overwhelm a FileMaker 
> >  field, it should technically be possible to write a converter in
> >  FileMaker by importing the XML as plain text.
> 
> Ouch, no thanks - I'd use perl instead.

Once the FileMaker solution is made, it then becomes just a matter of
Import->Process->Export to get the CSV each time ... assuming you need
to do regularly of course.

You can of course do the same thing in Excel if the lines fit within a
cell. Then there are various text processors like Grep which could
possibly be automated to do it.

I did create something along those lines a few years ago for importing
the phonebook from a "dumb" cellphone into a database (and vice versa),
where it had to ditch a load of extra garbage and tweak the data.



> >  There is also a new version of Mac Office due at some stage.
> 
> It's a ridiculous XML hype. Everything now is XML - but everyone does
> use it for export only and no one cares about import. Including FMP.

There's lots of things that are changed for little / no real reason,
often simply because corporates are trying to sell a new product to
customers, or wanting to look "cutting edge", rather than it actually
being better.


Helpful Harry  :o)

[toc] | [prev] | [next] | [standalone]

#91

On Wed, 21 May 2014 19:10:02 +1200, Helpful Harry wrote:
> > yes, there are many. many others. That's why I asked for a
> > recommendation.
> 
>  Those were the two suggestions by someone answering the same question
>  in a forum topic the Google search turned up, but the Google search
>  also turned up more links for downloading a converter (some of which
>  may well simply have been those two at different download websites).

I know that google does exist, and xml2csv was not my only search
string.

>  What does the incoming XML file look like?

<?xml version="1.0" encoding="utf-8"?>
<AX_Bestandsdatenauszug
xsi:schemaLocation="http://www.adv-online.de/namespaces/adv/gid/6.0
NAS-Operationen.xsd"
xmlns:gss="http://www.isotc211.org/2005/gss">
  <erlaeuterung>&lt;?xml version="1.0" encoding="utf-8"?&gt;&lt;Protocol
xmlns="http://www.aed-sicad.de/namespaces/va"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;auftragsid&gt;AMGR000000025712&lt;/auftragsid&gt;&lt;profilkennung&gt;lv13neug&lt;/profilkennung&gt;&lt;antragsnummer&gt;090_4281_14_Lagekatalog&lt;/antragsnummer&gt;&lt;nasoperation&gt;Bestandsdatenauszug&lt;/nasoperation&gt;&lt;status&gt;beendet&lt;/status&gt;&lt;startzeitreal&gt;2014-05-08T08:10:55.9231345+02:00&lt;/startzeitreal&gt;&lt;endzeitreal&gt;2014-05-08T08:11:31.5227909+02:00&lt;/endzeitreal&gt;&lt;statistik&gt;&lt;objektmenge
objektart="AX_Bundesland"&gt;&lt;objektanzahl&gt;16&lt;/objektanzahl&gt;&lt;/objektmenge&gt;&lt;objektmenge
objektart="AX_Gemeinde"&gt;&lt;objektanzahl&gt;439&lt;/objektanzahl&gt;&lt;/objektmenge&gt;&lt;objektmenge
objektart="AX_KreisRegion"&gt;&lt;objektanzahl&gt;13&lt;/objektanzahl&gt;&lt;/objektmenge&gt;&lt;objektmenge
objektart="AX_LagebezeichnungKatalogeintrag"&gt;&lt;objektanzahl&gt;20689&lt;/objektanzahl&gt;&lt;/objektmenge&gt;&lt;objektmenge
objektart="AX_Regierungsbezirk"&gt;&lt;objektanzahl&gt;3&lt;/objektanzahl&gt;&lt;/objektmenge&gt;&lt;FeatureZähler&gt;21160&lt;/FeatureZähler&gt;&lt;/statistik&gt;&lt;Message&gt;&lt;Category&gt;NOTHING&lt;/Category&gt;&lt;MessageLevel&gt;Info&lt;/MessageLevel&gt;&lt;MessageObject&gt;&lt;FeatureClass
/&gt;&lt;Id /&gt;&lt;/MessageObject&gt;&lt;MessageText&gt;Das Ergebnis
wurde mit der 3A-Version 6.3.10.10
erstellt.&lt;/MessageText&gt;&lt;ProcessingTime&gt;2014-05-08T08:10:55.9231345+02:00&lt;/ProcessingTime&gt;&lt;/Message&gt;&lt;Message&gt;&lt;Category&gt;BASIC&lt;/Category&gt;&lt;MessageLevel&gt;Info&lt;/MessageLevel&gt;&lt;MessageText&gt;Xml
Validierung erfolgreich
durchgeführt&lt;/MessageText&gt;&lt;ProcessingTime&gt;2014-05-08T08:10:56.0167357+02:00&lt;/ProcessingTime&gt;&lt;/Message&gt;&lt;Message&gt;&lt;Category&gt;NOTHING&lt;/Category&gt;&lt;MessageLevel&gt;Info&lt;/MessageLevel&gt;&lt;MessageText&gt;Bestandsdatenauszug:
Anzahl gefundener Features für Portion 1: 16 für
AX_Bundesland&lt;/MessageText&gt;&lt;ProcessingTime&gt;2014-05-08T08:11:31.5227909+02:00&lt;/ProcessingTime&gt;&lt;/Message&gt;&lt;Message&gt;&lt;Category&gt;NOTHING&lt;/Category&gt;&lt;MessageLevel&gt;Info&lt;/MessageLevel&gt;&lt;MessageText&gt;Bestandsdatenauszug:
Anzahl gefundener Features für Portion 1: 439 für
AX_Gemeinde&lt;/MessageText&gt;&lt;ProcessingTime&gt;2014-05-08T08:11:31.5227909+02:00&lt;/ProcessingTime&gt;&lt;/Message&gt;&lt;Message&gt;&lt;Category&gt;NOTHING&lt;/Category&gt;&lt;MessageLevel&gt;Info&lt;/MessageLevel&gt;&lt;MessageText&gt;Bestandsdatenauszug:
Anzahl gefundener Features für Portion 1: 13 für
AX_KreisRegion&lt;/MessageText&gt;&lt;ProcessingTime&gt;2014-05-08T08:11:31.5227909+02:00&lt;/ProcessingTime&gt;&lt;/Message&gt;&lt;Message&gt;&lt;Category&gt;NOTHING&lt;/Category&gt;&lt;MessageLevel&gt;Info&lt;/MessageLevel&gt;&lt;MessageText&gt;Bestandsdatenauszug:
Anzahl gefundener Features für Portion 1: 20689 für
AX_LagebezeichnungKatalogeintrag&lt;/MessageText&gt;&lt;ProcessingTime&gt;2014-05-08T08:11:31.5227909+02:00&lt;/ProcessingTime&gt;&lt;/Message&gt;&lt;Message&gt;&lt;Category&gt;NOTHING&lt;/Category&gt;&lt;MessageLevel&gt;Info&lt;/MessageLevel&gt;&lt;MessageText&gt;Bestandsdatenauszug:
Anzahl gefundener Features für Portion 1: 3 für
AX_Regierungsbezirk&lt;/MessageText&gt;&lt;ProcessingTime&gt;2014-05-08T08:11:31.5227909+02:00&lt;/ProcessingTime&gt;&lt;/Message&gt;&lt;/Protocol&gt;</erlaeuterung>
  <erfolgreich>true</erfolgreich>
  <antragsnummer>090_1234_56_xxxxkatalog</antragsnummer>
  <allgemeineAngaben>
    <AX_K_Benutzungsergebnis>
      <folgeverarbeitung>
        <AX_FOLGEVA>
          <datenformat>1000</datenformat>
        </AX_FOLGEVA>
      </folgeverarbeitung>
      <empfaenger>
        <AA_Empfaenger>
          <direkt>true</direkt>
        </AA_Empfaenger>
      </empfaenger>
    </AX_K_Benutzungsergebnis>
  </allgemeineAngaben>
  <koordinatenangaben>
    <AA_Koordinatenreferenzsystemangaben>
      <crs xlink:href="urn:adv:crs:ETRS89_UTM33" />
      <anzahlDerNachkommastellen>3</anzahlDerNachkommastellen>
      <standard>true</standard>
    </AA_Koordinatenreferenzsystemangaben>
  </koordinatenangaben>
  <enthaelt>
    <wfs:FeatureCollection gml:id="FC73">
      <gml:boundedBy nilReason="inapplicable">
        <gml:Null />
      </gml:boundedBy>
      <gml:featureMember>
        <AX_Bundesland gml:id="DESNALK03A00000g">
          <gml:identifier
codeSpace="http://www.adv-online.de/">urn:adv:oid:DESNALK03A00000g</gml:identifier>
          <lebenszeitintervall>
            <AA_Lebenszeitintervall>
              <beginnt>2013-10-25T11:37:10Z</beginnt>
            </AA_Lebenszeitintervall>
          </lebenszeitintervall>
          <modellart>
            <AA_Modellart>
              <advStandardModell>DLKM</advStandardModell>
            </AA_Modellart>
          </modellart>
          <anlass>000000</anlass>
          <schluesselGesamt>10</schluesselGesamt>
          <bezeichnung>Saarland</bezeichnung>
          <schluessel>
            <AX_Bundesland_Schluessel>
              <land>10</land>
            </AX_Bundesland_Schluessel>
          </schluessel>
        </AX_Bundesland>
      </gml:featureMember>
      <gml:featureMember>
        <AX_Bundesland gml:id="DESNALK03A00000d">
          <gml:identifier
codeSpace="http://www.adv-online.de/">urn:adv:oid:DESNALK03A00000d</gml:identifier>
          <lebenszeitintervall>
            <AA_Lebenszeitintervall>
              <beginnt>2013-10-25T11:37:10Z</beginnt>
            </AA_Lebenszeitintervall>
          </lebenszeitintervall>
          <modellart>
            <AA_Modellart>
              <advStandardModell>DLKM</advStandardModell>
            </AA_Modellart>
          </modellart>
          <anlass>000000</anlass>
          <schluesselGesamt>02</schluesselGesamt>
          <bezeichnung>Freie und Hansestadt Hamburg</bezeichnung>
          <schluessel>
            <AX_Bundesland_Schluessel>
              <land>02</land>
            </AX_Bundesland_Schluessel>
          </schluessel>
        </AX_Bundesland>
      </gml:featureMember>
      <gml:featureMember>
        <AX_Bundesland gml:id="DESNALK03A00000b">
          <gml:identifier
codeSpace="http://www.adv-online.de/">urn:adv:oid:DESNALK03A00000b</gml:identifier>
          <lebenszeitintervall>
            <AA_Lebenszeitintervall>
              <beginnt>2013-10-25T11:37:10Z</beginnt>
            </AA_Lebenszeitintervall>
          </lebenszeitintervall>
          <modellart>
            <AA_Modellart>
              <advStandardModell>DLKM</advStandardModell>
            </AA_Modellart>
          </modellart>
          <anlass>000000</anlass>
          <schluesselGesamt>04</schluesselGesamt>
          <bezeichnung>Freie Hansestadt Bremen</bezeichnung>
          <schluessel>
            <AX_Bundesland_Schluessel>
              <land>04</land>
            </AX_Bundesland_Schluessel>
          </schluessel>
        </AX_Bundesland>
      </gml:featureMember>
      <gml:featureMember>
        <AX_Gemeinde gml:id="DESNALK03A00003U">
          <gml:identifier
codeSpace="http://www.adv-online.de/">urn:adv:oid:DESNALK03A00003U</gml:identifier>
          <lebenszeitintervall>
            <AA_Lebenszeitintervall>
              <beginnt>2013-10-25T11:37:10Z</beginnt>
            </AA_Lebenszeitintervall>
          </lebenszeitintervall>
          <modellart>
            <AA_Modellart>
              <advStandardModell>DLKM</advStandardModell>
            </AA_Modellart>
          </modellart>
          <anlass>000000</anlass>
          <schluesselGesamt>14729230</schluesselGesamt>
          <bezeichnung>Stadt Kohren-Sahlis</bezeichnung>
          <gemeindekennzeichen>
            <AX_Gemeindekennzeichen>
              <land>14</land>
[...]
> > Ouch, no thanks - I'd use perl instead.
> 
>  Once the FileMaker solution is made, it then becomes just a matter of
>  Import->Process->Export to get the CSV each time ... assuming you need
>  to do regularly of course.

No, it's a once per year job only. I've done plenty of text reformatting
in FMP, including plenty of line merging and text replacement.

XML conversion is definitely somethin which I don't want to do in FMP -
walking recursively through records, checking which records to merge
etc.

Yes, it can be done in FMP. But FMP is not only painfully slow for that
job. It does lack essential processing power, such as regular
expressions. 

FMP is just the wrong tool. I'd use perl instead - or others would use
python etc.

>  You can of course do the same thing in Excel if the lines fit within a
>  cell. Then there are various text processors like Grep which could
>  possibly be automated to do it.

There's no special need. Excel for Win obviously has a proper xml import
filter, since the export format was designed and verified to work with
Excel, even without some proper structure XSL

>  There's lots of things that are changed for little / no real reason,
>  often simply because corporates are trying to sell a new product to
>  customers, or wanting to look "cutting edge", rather than it actually
>  being better.

You do need some buzzwords like CGI, SQL and XML on the package - even if
those are actually implemented far from useful.

- Martin

[toc] | [prev] | [next] | [standalone]

#96

In article <slrnlnolem.70.t-usenet@ID-685.user.individual.de>, Martin
Ԥrautmann <t-usenet@gmx.net> wrote:
> On Wed, 21 May 2014 19:10:02 +1200, Helpful Harry wrote:
> [...]
> > 
> >  Once the FileMaker solution is made, it then becomes just a matter of
> >  Import->Process->Export to get the CSV each time ... assuming you need
> >  to do regularly of course.
> 
> No, it's a once per year job only. I've done plenty of text reformatting
> in FMP, including plenty of line merging and text replacement.
> 
> XML conversion is definitely somethin which I don't want to do in FMP -
> walking recursively through records, checking which records to merge
> etc.
> 
> Yes, it can be done in FMP. But FMP is not only painfully slow for that
> job. It does lack essential processing power, such as regular
> expressions. 
> 
> FMP is just the wrong tool. I'd use perl instead - or others would use
> python etc.

For once a year, you're right. It's probably not worth doing in
FileMaker.



> >  You can of course do the same thing in Excel if the lines fit within a
> >  cell. Then there are various text processors like Grep which could
> >  possibly be automated to do it.
> 
> There's no special need. Excel for Win obviously has a proper xml import
> filter, since the export format was designed and verified to work with
> Excel, even without some proper structure XSL

Have you tried the online MS Office 365 apps?? It would be an expensive
solution just for this though, although not quite as expensive as
buying Parallels, Windows and PC Office to run on the Mac.


Helpful Harry  :o)

[toc] | [prev] | [next] | [standalone]

#104

On Tue, 20 May 2014 09:30:52 +0000 (UTC), Martin Τrautmann wrote:
>  is there any xml to csv (or xml to anything) converter which you could
>  recommend?

I suppose I'll have to write one of my own.

The data now is much more specific, giving different value types to
certain data. But all I need where 
      603 604 of 
   24 185 033 bytes 
which contained the data I was looking for.  

- Martin

[toc] | [prev] | [standalone]

Back to top | Article view | comp.sys.mac.databases

csiph-web