Parse XML and save as txt

Question

0.00/5 (No votes)

See more:

I want to parse a xml file and save it as a txt file.

My XML-File looks like follows:

I am just interested in the attribute type inside the class ATTRIBUTE. I want just to display the values Demonstration and Portfolio in a text file

<ADOXML adoversion="Version 5.1" username="Admin" database="adoxxdb" time="10:39" date="21.10.2019" version="3.1">
<MODELS>
<MODEL version="" applib="ADOxx 1.5 Dynamic Experimentation Library" libtype="bp" modeltype="Ressource Model" name="Ressource Model - new" id="mod.47204">
<MODELATTRIBUTES>
<INSTANCE name="Collection of written documents-49041" id="obj.49041" class="Collection of written documents">
<ATTRIBUTE name="Position" type="STRING">NODE x:7cm y:1.5cm index:1</ATTRIBUTE>
<ATTRIBUTE name="External tool coupling" type="STRING"/>
<ATTRIBUTE name="Comment" type="STRING"/>
<ATTRIBUTE name="Description" type="STRING"/>
<ATTRIBUTE name="Referenced Document" type="PROGRAMCALL">ITEM "" param:""</ATTRIBUTE>
<ATTRIBUTE name="Display file name" type="INTEGER">0</ATTRIBUTE>
<ATTRIBUTE name="Type of written documents" type="ENUMERATIONLIST">Demonstration;Portfolio</ATTRIBUTE>
</INSTANCE>
</MODEL>
</MODELS>
</ADOXML>

The output should just look like:

Klassen:
Demonstration
Portfolio

My code looks like follows:

What I have tried:

import xml.etree.ElementTree as ET

tree=ET.parse(r"C:\Users\benni\Google Drive\MASTER\Masterarbeit\Coden\Resource.xml")

with open(r"C:\Users\benni\Google Drive\MASTER\Masterarbeit\Coden\Output88.txt", "w")as f:
    f.write("Class\n")
    for instance in tree.findall(".//ATTRIBUTE"):
        f.write(f"{instance.get('type')}\n")

However, I do not get the results I wanted. I just get the attribute ENUMERATIONLIST, but I want the values of this.

Posted 20-Oct-19 23:28pm

3razOr1993

Updated 20-Oct-19 23:43pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2019-10-20T23:43:00

Solution 1

I just ran your code with the corrected* XML and it lists all the entries named ATTRIBUTE.

*the tag <MODELATTRIBUTES> does not have a corresponding closing tag, so I removed it from the file.

Posted 20-Oct-19 23:43pm

Richard MacCutchan

Comments

3razOr1993 21-Oct-19 6:34am

Yes that is right, but I just need the values Demonstration and Portfolio as an endresult

Richard MacCutchan 21-Oct-19 6:40am

Then parse for the values once you have found the correct node. See 19.7. xml.etree.ElementTree — The ElementTree XML API — Python 2.7.17 documentation[^] for further information.

3razOr1993 21-Oct-19 7:10am

I read the further information but I still do not get it sorry.
My problem is I do not know how to get the values Demonstration and Portfolio, because I cannot get it with .find(xx).text or .get(xx)

Richard MacCutchan 21-Oct-19 7:17am


    if instance.get('type') == "ENUMERATIONLIST":
            print(instance.text)