Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.sys.mac.databases > #91
| From | Martin Τrautmann <t-usenet@gmx.net> |
|---|---|
| Newsgroups | comp.sys.mac.databases |
| Subject | Re: XML to CSV converter |
| Date | 2014-05-21 07:29 +0000 |
| Organization | slrn user |
| Message-ID | <slrnlnolem.70.t-usenet@ID-685.user.individual.de> (permalink) |
| References | <slrnlnm86e.uc4.t-usenet@ID-685.user.individual.de> <210520140921117853%HelpfulHarry@BusyWorking.com> <slrnlnoh0s.70.t-usenet@ID-685.user.individual.de> <210520141910022867%HelpfulHarry@BusyWorking.com> |
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><?xml version="1.0" encoding="utf-8"?><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"><auftragsid>AMGR000000025712</auftragsid><profilkennung>lv13neug</profilkennung><antragsnummer>090_4281_14_Lagekatalog</antragsnummer><nasoperation>Bestandsdatenauszug</nasoperation><status>beendet</status><startzeitreal>2014-05-08T08:10:55.9231345+02:00</startzeitreal><endzeitreal>2014-05-08T08:11:31.5227909+02:00</endzeitreal><statistik><objektmenge
objektart="AX_Bundesland"><objektanzahl>16</objektanzahl></objektmenge><objektmenge
objektart="AX_Gemeinde"><objektanzahl>439</objektanzahl></objektmenge><objektmenge
objektart="AX_KreisRegion"><objektanzahl>13</objektanzahl></objektmenge><objektmenge
objektart="AX_LagebezeichnungKatalogeintrag"><objektanzahl>20689</objektanzahl></objektmenge><objektmenge
objektart="AX_Regierungsbezirk"><objektanzahl>3</objektanzahl></objektmenge><FeatureZähler>21160</FeatureZähler></statistik><Message><Category>NOTHING</Category><MessageLevel>Info</MessageLevel><MessageObject><FeatureClass
/><Id /></MessageObject><MessageText>Das Ergebnis
wurde mit der 3A-Version 6.3.10.10
erstellt.</MessageText><ProcessingTime>2014-05-08T08:10:55.9231345+02:00</ProcessingTime></Message><Message><Category>BASIC</Category><MessageLevel>Info</MessageLevel><MessageText>Xml
Validierung erfolgreich
durchgeführt</MessageText><ProcessingTime>2014-05-08T08:10:56.0167357+02:00</ProcessingTime></Message><Message><Category>NOTHING</Category><MessageLevel>Info</MessageLevel><MessageText>Bestandsdatenauszug:
Anzahl gefundener Features für Portion 1: 16 für
AX_Bundesland</MessageText><ProcessingTime>2014-05-08T08:11:31.5227909+02:00</ProcessingTime></Message><Message><Category>NOTHING</Category><MessageLevel>Info</MessageLevel><MessageText>Bestandsdatenauszug:
Anzahl gefundener Features für Portion 1: 439 für
AX_Gemeinde</MessageText><ProcessingTime>2014-05-08T08:11:31.5227909+02:00</ProcessingTime></Message><Message><Category>NOTHING</Category><MessageLevel>Info</MessageLevel><MessageText>Bestandsdatenauszug:
Anzahl gefundener Features für Portion 1: 13 für
AX_KreisRegion</MessageText><ProcessingTime>2014-05-08T08:11:31.5227909+02:00</ProcessingTime></Message><Message><Category>NOTHING</Category><MessageLevel>Info</MessageLevel><MessageText>Bestandsdatenauszug:
Anzahl gefundener Features für Portion 1: 20689 für
AX_LagebezeichnungKatalogeintrag</MessageText><ProcessingTime>2014-05-08T08:11:31.5227909+02:00</ProcessingTime></Message><Message><Category>NOTHING</Category><MessageLevel>Info</MessageLevel><MessageText>Bestandsdatenauszug:
Anzahl gefundener Features für Portion 1: 3 für
AX_Regierungsbezirk</MessageText><ProcessingTime>2014-05-08T08:11:31.5227909+02:00</ProcessingTime></Message></Protocol></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
Back to comp.sys.mac.databases | Previous | Next — Previous in thread | Next in thread | Find similar
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