Min Occurs Element Property in XMLport

(0) Share

Report

Posted on by BlackPanther

I would like my XMLport to only show elements if a value is required. There is an element property called Min Occurs, and its value can be set to Zero. Unfortunately when I have set the property value to zero for an element, on running the XMLport, the exported XML records still show the element, even when there is no value. Have I misunderstood the purpose of this element property?

*This post is locked for comments

All responses (2)

Answers (1)

BlackPanther 10 on at

Like (0)

Report

RE: Min Occurs Element Property in XMLport

Thank you for answering my question. I will give your suggested work around a go.
Verified answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

RE: Min Occurs Element Property in XMLport

The MinOccurrs and MaxOccurs properties of an element control how NAV parses an XML document. If it's MinOccurs = 0 and MaxOccurs =1 then a valid XML document can contain the element 0 or 1 times only in the correct structure of the document.

Unfortunately when exporting an XML, NAV doesn't handle "nulls" and MinOccours is not validated. MinOccours works only for import.

My advice is to add post processing process that removes the nodes from xml file, something like:

xmlDoc := xmlDoc.XmlDocument;

xmlDoc.Load(FileName);

XMLNodeList := xmlDoc.SelectNodes('//YourEmptyNode[. = ""]');

FOR i := 0 TO XMLNodeList.Count - 1 DO BEGIN

XMLNode := XMLNodeList.Item(i);

XMLNode.ParentNode().RemoveChild(XMLNode);

END;

xmlDoc.Save(FileName);

where YourEmptyNodeis the name of your empty note.