Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Run XMLPort import without manual file selection
Supremenerd88
Member Posts: 21
Hi,
i need your help. My customer need to schedule ad XMLport to import a file downloaded from remote FTP server. At the moment i've a page whit an action. This action download the remote file and run the XMLport without request page:
When i perform this action FTP download work fine but XMLport ask me to select file to import.
I suppose that i cannot schedule this code in a codeunit, so how can skip file selection and perform direct imput?
Thanks a lot.
i need your help. My customer need to schedule ad XMLport to import a file downloaded from remote FTP server. At the moment i've a page whit an action. This action download the remote file and run the XMLport without request page:
// I.20160303
L_RSetup.GET();
L_RSetup.TESTFIELD("FTP Code");
L_RFTPSetup.RESET();
L_RFTPSetup.SETRANGE("Function code", L_RSetupViridex."FTP Code");
IF L_RFTPSetup.FINDFIRST() THEN BEGIN
// L_RFTPSetup.Elaborate: performe remote file download
L_RFTPSetup.Elaborate('');
// i'm setting XML path and file name
L_XImport.FILENAME := L_RFTPSetup."Local path" + 'import.csv';
L_XImport.RUN();
// this instruction was a test...
//XMLPORT.RUN(XMLPORT::"Remote Credit Limit Import",FALSE,TRUE,Rec);
CurrPage.UPDATE();
END;
// F.20160303
When i perform this action FTP download work fine but XMLport ask me to select file to import.
I suppose that i cannot schedule this code in a codeunit, so how can skip file selection and perform direct imput?
Thanks a lot.
Giorgio Gandolfi
0
Best Answer
-
OptionsSupremenerd88
Member Posts: 21
Solved:
// I.20160303 L_RSetup.GET(); L_RSetup.TESTFIELD("FTP Code"); L_RFTPSetup.RESET(); L_RFTPSetup.SETRANGE("Function code", L_RSetupViridex."FTP Code"); IF L_RFTPSetup.FINDFIRST() THEN BEGIN // L_RFTPSetup.Elaborate: performe remote file download L_RFTPSetup.Elaborate(''); L_GImportFile.OPEN(L_RFTPSetup."Local path" + 'import.csv'); L_GImportFile.CREATEINSTREAM(L_GStream); XMLPORT.IMPORT(XMLPORT::"Remote Credit Limit Import",L_GStream); L_GImportFile.CLOSE(); CurrPage.UPDATE(); END; // F.20160303Giorgio Gandolfi5
Answers
// I.20160303 L_RSetup.GET(); L_RSetup.TESTFIELD("FTP Code"); L_RFTPSetup.RESET(); L_RFTPSetup.SETRANGE("Function code", L_RSetupViridex."FTP Code"); IF L_RFTPSetup.FINDFIRST() THEN BEGIN // L_RFTPSetup.Elaborate: performe remote file download L_RFTPSetup.Elaborate(''); L_GImportFile.OPEN(L_RFTPSetup."Local path" + 'import.csv'); L_GImportFile.CREATEINSTREAM(L_GStream); XMLPORT.IMPORT(XMLPORT::"Remote Credit Limit Import",L_GStream); L_GImportFile.CLOSE(); CurrPage.UPDATE(); END; // F.20160303