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

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

Re: XML to CSV converter

Show all headers | View raw

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)

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