Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.fsmpi.rwth-aachen.de!rt.uk.eu.org!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 09:21:11 +1200 Organization: Aioe.org NNTP Server Lines: 43 Message-ID: <210520140921117853%HelpfulHarry@BusyWorking.com> References: NNTP-Posting-Host: tNSpdas8gxwgZdXUGIYxBA.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:86 In article , Martin Ԥrautmann 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)