Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #78950
| X-Received | by 10.182.143.39 with SMTP id sb7mr2898669obb.47.1412944420178; Fri, 10 Oct 2014 05:33:40 -0700 (PDT) |
|---|---|
| X-Received | by 10.140.105.71 with SMTP id b65mr8656qgf.15.1412944420147; Fri, 10 Oct 2014 05:33:40 -0700 (PDT) |
| Path | csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!h18no4233990igc.0!news-out.google.com!i10ni77qaf.0!nntp.google.com!dc16no1830398qab.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
| Newsgroups | comp.lang.python |
| Date | Fri, 10 Oct 2014 05:33:40 -0700 (PDT) |
| In-Reply-To | <mailman.14752.1412943619.18130.python-list@python.org> |
| Complaints-To | groups-abuse@google.com |
| Injection-Info | glegroupsg2000goo.googlegroups.com; posting-host=160.33.195.21; posting-account=SNTpkQoAAABh0coIbAtpwGzzOeONd_Yy |
| NNTP-Posting-Host | 160.33.195.21 |
| References | <9bb1f027-dc72-43c1-9301-e2105225f75a@googlegroups.com> <mailman.14752.1412943619.18130.python-list@python.org> |
| User-Agent | G2/1.0 |
| MIME-Version | 1.0 |
| Message-ID | <e360dd2a-8cfe-4b49-ada2-55806acf68ae@googlegroups.com> (permalink) |
| Subject | Re: Parse bad xml file |
| From | David Jobes <david.jobes.sony@gmail.com> |
| Injection-Date | Fri, 10 Oct 2014 12:33:40 +0000 |
| Content-Type | text/plain; charset=ISO-8859-1 |
| Xref | csiph.com comp.lang.python:78950 |
Show key headers only | View raw
On Friday, October 10, 2014 8:21:17 AM UTC-4, Peter Otten wrote:
> David Jobes wrote:
>
>
>
> > I was given a badly or poor formatted xml file that i need to convert to
>
> > csv file:
>
>
>
> There are no "badly formatted" XML files, only valid and invalid ones.
>
> Fortunately following looks like the beginning of a valid one.
>
>
>
> > <?xml version="1.0"?>
>
> > <resultset xmlns:dyn="http://exslt.org/dynamic">
>
> > <table name="SIGNATURE">
>
> > <column name="ID" type="String"> </column>
>
> > <column name="NUM" type="Integer"> </column>
>
> > <column name="SEVERITY_ID" type="Integer"> </column>
>
> > <column name="NAME" type="String"> </column>
>
> > <column name="CLASS" type="String"> </column>
>
> > <column name="PRODUCT_CATEGORY_ID" type="Integer"> </column>
>
> > <column name="PROTOCOL" type="String"> </column>
>
> > <column name="TAXONOMY" type="String"> </column>
>
> > <column name="CVE_ID" type="String"> </column>
>
> > <column name="BUGTRAQ_ID" type="String"> </column>
>
> > <column name="DESCRIPTION" type="String"> </column>
>
> > <column name="MESSAGE" type="String"> </column>
>
> > <column name="FILTERTYPE" type="String"> </column>
>
> > <data>
>
> > <r>
>
> > <c>00000001-0001-0001-0001-000000000027</c>
>
> > <c>27</c>
>
> > <c>2</c>
>
> > <c>0027: IP Options: Record Route (RR)</c>
>
> > <c>Network_equip</c>
>
> > <c>10</c>
>
> > <c>ip</c>
>
> > <c>100741885</c>
>
> > <c>2001-0752,1999-1339,1999-0986</c>
>
> > <c>870</c>
>
> > <c></c>
>
> > <c></c>
>
> > <c></c>
>
> > </r>
>
> >
>
> >
>
> > I have been able to load and read the file line by line,
>
>
>
> XML doesn't have an idea of lines, so don't do that. Instead let a parser
>
> make sense of the document structure.
>
>
>
> > but once i get to
>
> > the r line and try to process each c(column) that is where it blows up. I
>
> > need to be able to split the lines and place each one or the r (row) on a
>
> > single line for the csv.
>
> >
>
> > i have a list set for each one of the headers based on the col name field,
>
> > i just have been able to format properly.
>
>
>
> Here's a simple script using ElementTree, to introduce you to basic xml
>
> handling with Python's stdlib. If you are lucky it might even work ;)
>
>
>
> import csv
>
> import sys
>
> from xml.etree import ElementTree
>
>
>
> SOURCEFILE = "xml_to_csv.xml"
>
>
>
> tree = ElementTree.parse(SOURCEFILE)
>
> table = tree.find("table")
>
> column_names = [c.attrib["name"] for c in table.findall("column")]
>
> writer = csv.writer(sys.stdout)
>
> writer.writerow(column_names)
>
> for row in table.find("data").findall("r"):
>
> writer.writerow([field.text for field in row.findall("c")])
That did it, thank you, and in a lot fewer lines of code than i had, i was trying to use strings and regex. i will read up more on the xml.etree stuff.
Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Parse bad xml file David Jobes <david.jobes.sony@gmail.com> - 2014-10-10 04:46 -0700
Re: Parse bad xml file Peter Otten <__peter__@web.de> - 2014-10-10 14:20 +0200
Re: Parse bad xml file David Jobes <david.jobes.sony@gmail.com> - 2014-10-10 05:33 -0700
Re: Parse bad xml file Rustom Mody <rustompmody@gmail.com> - 2014-10-12 01:37 -0700
csiph-web