Remove heading on XMLport output?

what is the reason for removing this?

You need to load the xmlfile after xmlport has been run and remove it through xmldom

Also notice that you are running it in UTF-16

UTF-16 make sometime problems, all depends on how the XML is used...

it's nav specific. If you are using message queue if I'm remembering correctly.

As far as request take a look at this thread.

viewtopic.php?f=23&t=31648&hilit=never+forget

you can't do it with xmlport. you need to do it afterward.

you can pass a blank string to the function processingInstruction. Thus removing it. It doesn't hurt to try it.

kine wrote:

Or you can pass the XML into XMLDom and just remove the first node and you are done...

We have similar issue, that customers webservice does not accept the first line.

I've port that exports xml file and I'm sending it to the webservice by automation,

You say pass xml into XMLDom, how you remove first node? I'm not sure how to select it,.. this did not work fex:

CREATE(XmlDoc);
XmlDoc.async := FALSE;
XmlDoc.load(Tiedosto); // <-- the xml file



// This does not work???
XmlNode := XmlDoc.selectSingleNode('XML');
XmlDoc.removeChild(XmlNode);



IF ISCLEAR(XmlHttp) THEN
  CREATE(XmlHttp);

XmlHttp.open('POST', Url, FALSE);

kine wrote:

lauXmlDom.load(Stream);

lauXmlNode := lauXmlDom.firstChild;
lauXmlDom.removeChild(lauXmlNode);

Agh stupid me, it was a property #-o

Thanks Kine :thumbsup:

You would have to do it through xmldom. Basically write a generic function that loops through all the children and call it recursively.
You would in the function checked the value of each node and if it's blank, remove the child.

gbierkens wrote:

I have a simular problem (trying to delete the <xml>-tag) but I'm not familuar with using the the XML automation objects. Can someone help me where to put the above sollution in my code.
(using NAV 2009 SP1 classic)

//XML Export
XMLfile.CREATE('F:\Outbound\PO.xml');
XMLfile.CREATEOUTSTREAM(OutStreamObj);

XMLPORT.EXPORT(50007,OutStreamObj,gRecPurchaseHeader);
XMLfile.CLOSE;

I tried to do the following:
After "XMLfile.CREATEOUTSTREAM(OutStreamObj);" add the code:

XMLfile.CREATE('F:\Outbound\PO.xml');
XMLfile.CREATEOUTSTREAM(OutStreamObj);

CREATE(lauXmlDom);

lauXmlDom.load(OutStreamObj);
lauXmlNode := lauXmlDom.firstChild;
lauXmlDom.removeChild(lauXmlNode);

XMLPORT.EXPORT(50007,OutStreamObj,gRecPurchaseHeader);
XMLfile.CLOSE;

What would be the right way to do this?

I'm not 100% sure but the second code seems okay to me or if the remove child does not work then the problem might be in the process queue.

First the load thingy needs the file or stream of string (xml data) where the remove child selects the first element, first child. then remove child nukes the first tag which is probably the <xml> and last the file exports out.

I hope you get it working. It took me a week to get this done first time

I would try it a little differently than what you have...

VAR
   gRecPurchaseHeader : Record 38
   XMLDOMDocument : Automation :'Microsoft XML, v6.0'.DOMDocument;
   XMLNode : Automation :'Microsoft XML, v6.0'.IXMLDOMNode;
   TempBlob : Record 99008535;
   OutStreamObj : OutStream;
   InStreamObj : InStream;

IF ISCLEAR(XMLDOMDocument) THEN BEGIN
  CREATE(XMLDOMDocument);
  XMLDOMDocument.async := FALSE;
END;

TempBlob.Blob.CREATEOUTSTREAM(OutStreamObj);

XMLPORT.EXPORT(50007,OutStreamObj,gRecPurchaseHeader);

TempBlob.Blob.CREATEINSTREAM(InStreamObj);

XMLDOMDocument.load(InStreamObj);
XMLNode := XMLDOMDocument.firstChild;
XMLDOMDocument.removeChild(XMLNode);
XMLDOMDocument.save('F:\Outbound\PO.xml');

This works, I would probably add some more logic in that would give an error/message if there was nothing to do and maybe parameterize the file name for the save though.