mibuso.com

Hi guys,

I am stuck at one point while using XMLPORTS. I have created an XMLPORT and a Codeunit for importing the data from an xml file. When I run the Codeunit locally, the data gets imported and everything looks fine.

The problem is, when I try to run the same Codeunit using Web Service, the XMLPORT.IMPORT function fails and returns the exception "Import Unsuccessful". Any ideas resolving the same would be highly appretiated.

Awaiting on the responses. Thanks in advance.

Following is the code that I am using for Import.

SendOrderDetails() FileExists : Boolean
IF EXISTS('C:\inetpub\wwwroot\Import Files\OrderDetails.xml') THEN
BEGIN
IF TestFile.OPEN('C:\inetpub\wwwroot\Import Files\OrderDetails.xml') THEN
BEGIN
TestFile.CREATEINSTREAM(VarInStream);
IF XMLPORT.IMPORT(50007,VarInStream) THEN
FileExists := TRUE
ELSE
ERROR('Import Unsuccessful');
END ELSE
ERROR('Error Opening file');
TestFile.CLOSE;
END ELSE
FileExists := FALSE;

A XML-Port look for 'C:\inetpub\wwwroot\Import Files\OrderDetails.xml' at the server where the service tier is running. So when you try to run this code it won't find the path because it is not there.

You can use the UPLOAD function to copy the file to a temp folder on the service tier and try to import it from there (store the path in a variable).

I recommend do not use XML file stored on a disk (if it is possible). Be sure a function in the published codeunit can have parameter - type XMLport. In this case you can use this simple code in codeunit (InsertIncident is name of published method):
InsertIncident(VAR parXmlPort : XMLport XMLport50015)
parXmlPort.IMPORT();

Hi Ploeg,

Thanks for the response.

I guess, that should not be the problem based on below two assumptions.

1. The TESTFILE.OPEN function returns true in the same code, which means it is able to open the file from the path. It just fails when calling the IMPORT function of the XMLPort after the xml file has been read from the path and hence throws the exception "Import Unsuccess". If there is problem in finding the path, the exception should have been "Error Opening File" which is mentioned as error msg in the sample code.

2. Secondly, I am using the following code for export which works fine with the webservice call.

TestFile.CREATE('C:\inetpub\wwwroot\Export Files\LoginDetails.xml');
TestFile.CREATEOUTSTREAM(TestStream);
XMLPORT.EXPORT(50004,TestStream);
TestFile.CLOSE;

Thanks again.

It is indeed the IMPORT function that is the trouble. IMPORT and EXPORT are two completely different things.
You could try the following code:

Hi Ploeg,

Since I am exposing the codeunit as a web service, hope I cannot use UPLOAD function as it promts for a dialog box for selecting the file.

Instead I have tried using the below code:


The above code works fine when run locally but I am really stuck why the web service call cannot run the varxml.import function and it throws the exception "Import Unsuccessful". Really stuck

Going mad

Try to call the import out of IF-Then to let NAV throw the original runtime error.

Hi Kamil,

In that case, the web service throws the exception as shown in the attachment. I doesnt have any clue why is this happening when the same is working fine locally.

THis exception means that you have confirm or dialog used in the code, but it means definitely, that the code is called at all...

Thanks Kamil for the reply.

But the XMLPORT which I am using for IMPORT doesnt have any set of code. Any idea where the confirm or dialog possiblities would come while using IMPORT??

May be some OnValdiate or OnInsert is called in some table? How is the XMLPort called? It is as parameter of the function? Or through local variable?

Is called through local variable.

Also for testing, I am trying to import only the primary key value of the table. And the table doesnt have any set of code in the OnIsert() and OnValidate() of the field which I am using in the XMLPORT.

Still the problem is same

Run the code from classic client or rtc client and see what the callback is (a confirm, a form/page, etc). then search for that.

May be the XMLPort is asking for the file name?

I solved the same error several moths ago. Unfortunately I can't remember what reason was that. I'm not sure but I have feeling that temporary table (Temporary property) and something around this was the cause.