Puppy Linux Discussion Forum

[scsijon]

before I start to try to build it! I am NOT a good base coder, although I can adapt existing code fairly well.

Does anyone already have a script that can take a xml file and turn it into a comma deliniated file. I'm starting on a opensuse2ppm script similarly to barryk's mageia2ppm and would like to start with a automated step1 as there are 19098 packages in the opensuse set at the moment(, up from 18880 last month). I'm actually thinking of stripping out lines we don't need as step0 as the source filesize is some 76meg and that should make it quicker to process the rest.

source xml is in this format if anyones interested:

[amigo]

Yeah, before trying to build -parsing xml is 'heavy lifting'. A search would have gotten you lots of hits:
https://duckduckgo.com/?q=convert+xml+to+CSV

[scsijon]

[amigo]

Using xslt would be the most obvious:
http://stackoverflow.com/questions/2516858/convert-xml-file-to-csv

Other standard XML tools are: XMLStarlet, xsltproc and perl xpath


This is interesting:
http://www.freesoftwaremagazine.com/articles/convert_xml_csv_ugly_way_unix_utilities_linux

http://stackoverflow.com/questions/893585/how-to-parse-xml-in-bash

[musher0]

Hello, scsijon.

If you're into java, you may want to try one of these :

http://www.wenzlaff.de/xmltocsv.html
or
http://code.google.com/p/xml2csv-conv/

Best regards.

musher0

[seaside]

scsijon.,

You may find the following xml utilities of interest. Below is a quote from the simple-icon-tray thread weather program made with xml-printf.

[technosaurus]

xml is the most ridiculous format, I've no idea how it caught on.

That being said, if you are dealing with one tag per line, awk is pretty useful

awk '
BEGIN{FS="<|>"}
/<name>/{name=...}
/<arch>/{pkgs[$name][arch]=...}
/ var=/{pkgs[$name][var]=...}
END{}
' file

[scsijon]

thank you all, and I agree technosaurus.

Unfortunately it's the best of two worlds for opensuse's packages! The other requires three sql files to be opened and integrated, before extraction for ppm and together they build 300meg+.

I think I have a lead from one of amigo's new links for something that will work easily. Thank you.

But i'm not marking this solved quite yet!

[jamesbond]

I'm a little late to the game. But this is the tool that I use for getting stuff out of xml data: http://www.ofb.net/~egnor/xml2/. Converts XML into a flat file format which you can grep sed awk on.

[scsijon]

thanks all,

I have changed methods and feel more than a bit of a fool after it was pointed out to me that all I need to do is modify the rpm2ppm script to match the opensuse format.