1

I am a newbie with Python and I'd like to remove below element from a xml file using python .

<action name="error_mail">...........</action>

Input File :

    <action name="error_mail">
        <email xmlns="uri:oozie:email-action:0.1">
          <to>[email protected]</to>
          <cc>[email protected]</cc>
          <subject>Batch Failed</subject>
          <body>Batch Failed at ${node}</body>
        </email>
        <ok to="killjob"/>
        <error to="killjob"/>
      </action>
    <action name="succeed_mail">
        <email xmlns="uri:oozie:email-action:0.1">
          <to>[email protected]</to>
          <cc>[email protected]</cc>
          <subject>Batch Succeed</subject>
          <body>Batch completed</body>
        </email>
        <ok to="end"/>
        <error to="end"/>
      </action>
Improve this question
3
  • Which element? Are you trying to convert this to an object? Commented Dec 9, 2020 at 1:57
  • Hi @ArthurHarduim Harduim , Looking to remove element <action name="error_mail"> Commented Dec 9, 2020 at 2:05
  • Does this answer your question? How to remove elements from XML using Python Commented Dec 9, 2020 at 2:28

2 Answers 2

Reset to default
0

Using ElementTree module

import xml.etree.ElementTree as ET

xml = '''<r> <action name="error_mail">
        <email xmlns="uri:oozie:email-action:0.1">
          <to>[email protected]</to>
          <cc>[email protected]</cc>
          <subject>Batch Failed</subject>
          <body>Batch Failed at ${node}</body>
        </email>
        <ok to="killjob"/>
        <error to="killjob"/>
      </action>
    <action name="succeed_mail">
        <email xmlns="uri:oozie:email-action:0.1">
          <to>[email protected]</to>
          <cc>[email protected]</cc>
          <subject>Batch Succeed</subject>
          <body>Batch completed</body>
        </email>
        <ok to="end"/>
        <error to="end"/>
      </action></r>'''

root = ET.fromstring(xml)
action = root.find(".//action[@name='error_mail']")
root.remove(action)
ET.dump(root)

output

<r xmlns:ns0="uri:oozie:email-action:0.1"> <action name="succeed_mail">
        <ns0:email>
          <ns0:to>[email protected]</ns0:to>
          <ns0:cc>[email protected]</ns0:cc>
          <ns0:subject>Batch Succeed</ns0:subject>
          <ns0:body>Batch completed</ns0:body>
        </ns0:email>
        <ok to="end" />
        <error to="end" />
      </action></r>
Improve this answer
Sign up to request clarification or add additional context in comments.

4 Comments

I am looking to remove both elements "error_mail" and "succeed_mail" from this xml file using python script .There are around 100 similar xml files stored in a directory .These xml files need to read from path = /c/xml_files/*.xml . All XML files need to get rid of below elements . Sample_input.xml <workflow name="test" > <action <action name="error_mail"> -- -- </action> <action name="succeed_mail"> -- -- </action> </workflow> Desired output from xml files :- <?xml version="1.0" ?> <workflow name="test" > <action -- -- -- </action> </workflow>
In the question you have asked you are talking about error email. So this what the code does. Edit the question if you have other needs or try to extend the answer to your needs. Did you try it? Did it work for you?
Yes , that's worked as magic for single file! But have an additional requirement to delete the element from multiple xml files from a specific path location. Would appreciate if you could please help me with python script to remove just the error email (i will change the script for succeed email) from multiple XML files . Thanks in advance !
You have challenges: 1) loop over multiple xml files 2) for each of those files - remove the elements you need to remove. Start by taking the code I have submitted and see how you remove all you need to remove from a single file
0

Try this.

from simplified_scrapy import SimplifiedDoc, utils

files = utils.getSubFile('/c/xml_files/',end='.xml') # Get all xml file
for f in files:
    xml = utils.getFileContent(f) # Get file content
    doc = SimplifiedDoc(xml)
    error_mail = doc.select('action@name=error_mail')
    if error_mail:
        error_mail.remove() # Delete node
        utils.saveFile(f, doc.html) # Save file
Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.