XMLPort do not show element if value is blank

jwilder

I have an XMLPort that exports some Sales Comments Line records. I have a custom field that I have added to the Sales Comment Line table called "User ID". Older records do not have a value in this field since I just added it.

Here is the XMLPort:
Node Name, Node Type, Source Type, Data Source
OrderComment, Element, Table, OrderComments(Order Comments)
LineNo, Element, Field, OrderComments::Line No.
CommentText, Element, Field, OrderComments::Comment Text
CommentDate, Element, Field, OrderComments::Comment Date
UserID, Element, Field, OrderComments::Comment User ID


In my XMLPort I do not want to show the Element (User ID) if the value is blank. I set the property MinOccurs to "Zero" but this did not work. How can I only show this field in the xml file if there is a value?

ara3n

You cannot do that with xmlport. You need to use MSXMLDom, or after the xmlport is created load it into xmldom and then get rid of the element.

NixPt

i think the problem when you have a field blank the xml port don't open the tag but uses this <Tag/>, i search in the forum and i found this post http://www.mibuso.com/forum/viewtopic.php?f=23&t=18042 and works for me.

Regards.