Delete Attribute in xml file

Mrinmay · 2010-07-22

Hi Expert,

i have a xml file. the data is like below :

xml version="1.0" encoding="UTF-8" standalone="no" ?>
- <Envelope xmlns="http://edavki.durs.si/Documents/Schemas/DDV_O_7.xsd" xmlns:edp="http://edavki.durs.si/Documents/Schemas/EDP-Common-1.xsd" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://edavki.durs.si/Documents/Schemas/DDV_O_7.xsd">
- <edp:Header xmlns:edp="http://edavki.durs.si/Documents/Schemas/DDV_O_7.xsd">
- <edp:taxpayer>
<edp:taxNumber>77777777</edp:taxNumber>
<edp:taxpayerType>PO</edp:taxpayerType>
<edp:name>CRONUS International Ltd.</edp:name>
<edp:address1>5 The Ring</edp:address1>
<edp:address2>Westminster</edp:address2>
<edp:city>London</edp:city>
<edp:postNumber>1</edp:postNumber>
<edp:postName>London</edp:postName>
<edp:maticnaStevilka />
<edp:resident>true</edp:resident>
</edp:taxpayer>
<edp:responseTo />
<edp:domain />
</edp:Header>
<edp:Signatures xmlns:edp="http://edavki.durs.si/Documents/Schemas/DDV_O_7.xsd" />
- <body>
<edp:bodyContent xmlns:edp="http://edavki.durs.si/Documents/Schemas/DDV_O_7.xsd" />
- <DDV-O>
...............
.............

Now i want to delete the attribute in element <EDP:Header>(Bold portion). means i want to modify
<edp:Header xmlns:edp="http://edavki.durs.si/Documents/Schemas/DDV_O_7.xsd"> to <edp:Header> only.
i am using Automation.

Please help me to remove the attibute & let me know how to do it?

Thanx in advance.

Regards,
Mrinmay

kine · 2010-07-23

I am sure that you can use the XSLT to do that (transformation). But how, I do not know, but there are examples on web how to remove namespaces form the XML through the XSLT. May be you will be able to modify it to remove only the one attribute you need.

pduck · 2010-07-23

If I remember rightly, you cannot delete elements / attributes inside a DOM document with the DOM methods using Navision Automation. You need to create a second DOM document and copy your XML structure without the attribute which you want to delete. Or use the xsd transformation.

kriki · 2010-07-23

[Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]

Mrinmay · 2010-07-26

kine wrote:

I am sure that you can use the XSLT to do that (transformation). But how, I do not know, but there are examples on web how to remove namespaces form the XML through the XSLT. May be you will be able to modify it to remove only the one attribute you need.

Hi Kine,

Thank you for your reply. Can you please let me know how to do it with xslt? Is there any document which i can refer?
because i am not getting how to use xslt in Nav using automation.

Regards,
Mrinmay

pduck · 2010-07-26

Hi, sorry I have not found any code for this anymore. Check this http://www.w3.org/DOM/faq.html at topic "How do I move a Node from one document to another?". You can use the importNode or (with Dom v3) the adoptNode to copy the relevant Nodes from you source XML in a new XML document.

You schould also try the removeAttributeNode method before. Maybe it works?!

On the other hand, if copying is the only solution and you don't want to waste time any more then keep it simple. Open the xml File as Textfile, search for the unwanted string xmlns:edp="http://edavki.durs.si/Documents/Schemas/DDV_O_7.xsd", delete it and replace the original file.

Maybe, I didn't tried it, you can do this manipulation inside a stream and then load the stream directly inside you XML document without the need to save it before on disk.

vaprog · 2010-07-30

Please have a look at Codeunit 403 Application Launch Management, Function LaunchApp, to see an example of how to do it programmatically from NAV.

Howdy, Stranger!

Quick Links

Categories

Delete Attribute in xml file

Comments