XMLPORT(Export) save in a destination automatically

bassouma · 2014-07-16

Hello everyone,

I create an XMLPORT to export some information from navision 2013 R2, I want when i run the XMLPORT, it will saving automaticaly in a destination that it is alreadey setup.
How can i do this?
I write this in OnPreXmlPort:

currXMLport.FILENAME(InterfaceSetup."Export Contract Comete Folder" + FileName + '.csv');
But when i run i have the dialog box to save.
I would like that should saving automatically in this folder.

geordie · 2014-07-16

You need to use an OutStream variable to export automatically the file generated by XmlPort, running the process it from a calling codeunit. For instance:

IF EXISTS(XmlFileName) THEN
  ERASE(XmlFileName);

XmlFile.CREATE(XmlFileName);
XmlFile.CREATEOUTSTREAM(OutStreamVar);
XMLPORT.EXPORT(XMLPORT::"Your XmlPort",OutStreamVar); 
XmlFile.CLOSE;

bassouma · 2014-07-17

When i create this file(.csv).
If Exist(XmlFileName)
I don't like to ECRASE it I would like to create another with a postfix variable.
How can i do this ?

geordie · 2014-07-17

Change the code in:

XmlFileName := 'Outputfile';
XmlFileNameExt := '.xml';

IF EXISTS(XmlFileName + XmlFileNameExt) THEN
  XmlFileName += '_1'; 

XmlFile.CREATE(XmlFileName + XmlFileNameExt);
XmlFile.CREATEOUTSTREAM(OutStreamVar);
XMLPORT.EXPORT(XMLPORT::"Your XmlPort",OutStreamVar); 
XmlFile.CLOSE;

In case insert the the file check in a repeat-until loop to find a proper suffix to use.

bassouma · 2014-07-17

With This:
IF EXISTS(XmlFileName + XmlFileNameExt) THEN
XmlFileName += '_1';
I will have all the time XmlFileName + '_1' but i want that the first time it 1, the second 2,3,4..

geordie · 2014-07-17

REPEAT
  Suffix += 1;
  XmlFileName := 'Outputfile_' + Suffix + '.xml';
UNTIL (NOT (EXISTS(XmlFileName)));

bassouma · 2014-07-17

Thanks

maheshroyal34 · 2017-04-19

Hi geordie,

Have some filters in XML port, but when i running it from codeunit able to export the file to a particular location but not able to set the filters in XML . is there any solution to set the filters of XML-Port when running form codeunit.

SuD · 2017-04-22

bassouma wrote: »

Thanks

Dont forget to marked answerd it..

Howdy, Stranger!

Quick Links

Categories

XMLPORT(Export) save in a destination automatically

Comments