Parsing XML to text file using python

Question

I have a source section in an XML from which I am trying to fetch the values in this way to a text file.

source1, ipset-1, IPSet, true

source2, ipset-2, IPSet, true

XML section:

<sources excluded="false">
    <source>
        <name>source1</name>
        <value>ipset-1</value>
        <type>IPSet</type>
        <isValid>true</isValid>
    </source>
    <source>
        <name>source2</name>
        <value>ipset-2</value>
        <type>IPSet</type>
        <isValid>true</isValid>
    </source>
</sources>

Currently, my code gives me everything in one line.

import xml.etree.ElementTree as ET
tree = ET.fromstring(xml_file)
for node in tree.iter('source'):
    print('\n')
    with open("source.txt", "a") as file:
        for elem in node.iter():
            if not elem.tag==node.tag:
                file.write("{},".format(elem.text))
                print("{}: {}".format(elem.tag, elem.text))

Andrej Kesely · Accepted Answer · 2021-06-01 10:28:49Z

1

A solution using beautifulsoup:

from bs4 import BeautifulSoup

xml_doc = """
<sources excluded="false">
    <source>
        <name>source1</name>
        <value>ipset-1</value>
        <type>IPSet</type>
        <isValid>true</isValid>
    </source>
    <source>
        <name>source2</name>
        <value>ipset-2</value>
        <type>IPSet</type>
        <isValid>true</isValid>
    </source>
</sources>
"""

soup = BeautifulSoup(xml_doc, "lxml")

with open("source.txt", "w") as f_out:
    for tag in soup.select("source"):
        print(",".join(t.text for t in tag.select("*")), file=f_out)

Creates source.txt:

source1,ipset-1,IPSet,true
source2,ipset-2,IPSet,true

answered Jun 1, 2021 at 10:28

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parsing XML to text file using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related