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

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

Re: XML to CSV converter

Show all headers | View raw

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)

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