Path: csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail From: Helpful Harry Newsgroups: comp.sys.mac.databases Subject: Re: XML to CSV converter Date: Wed, 21 May 2014 19:10:02 +1200 Organization: Aioe.org NNTP Server Lines: 75 Message-ID: <210520141910022867%HelpfulHarry@BusyWorking.com> References: <210520140921117853%HelpfulHarry@BusyWorking.com> NNTP-Posting-Host: Afk/88HCWJFi2u/KyQ2Q+A.user.speranza.aioe.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: abuse@aioe.org User-Agent: Thoth/1.5.4 (Carbon/OS X) X-Notice: Filtered by postfilter v. 0.8.2 Xref: csiph.com comp.sys.mac.databases:90 In article , 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... > > > 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)