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
In NAV 2016, how can I get the XMLport to save a file without any interaction from the user?
vimo
Member Posts: 14
Hello!
I have an XMLport that exports a report to a CSV file. No issues there. When the XMLport runs, I would like the file to be saved to the export folder without the Export File Dialog box opening and asking: “Do you want to open or save this file?” See Image1. There is a checkbox that I can uncheck “Always ask before opening this type of file.” But when I uncheck it,the Export dialog box still opens up, see Image2, with the correct export folder automatically selected, but I still need to click the Save button.
How can I get the XMLport to Save a file without any interaction from the user? Image3 shows the properties of the XMLport.
Thanks!
I have an XMLport that exports a report to a CSV file. No issues there. When the XMLport runs, I would like the file to be saved to the export folder without the Export File Dialog box opening and asking: “Do you want to open or save this file?” See Image1. There is a checkbox that I can uncheck “Always ask before opening this type of file.” But when I uncheck it,the Export dialog box still opens up, see Image2, with the correct export folder automatically selected, but I still need to click the Save button.
How can I get the XMLport to Save a file without any interaction from the user? Image3 shows the properties of the XMLport.
Thanks!
0
Best Answer
-
Options
ftornero
Member Posts: 522
You can create a report without any DataItem , with the propierties UseRequestPage = No and ProcessingOnly = Yes
And put thos code in the
OnPreReport()
// FileMgt codeunit 419
// FileName Text
// OutFile File
// OutS OutStream
// Xmlp your XMLPort
FileName := FileMgt.ServerTempFileName('CSV');
OutFile.CREATE(FileName);
OutFile.CREATEOUTSTREAM(OutS);
Xmlp.FILENAME(FileName);
Xmlp.SETDESTINATION(OutS);
Xmlp.EXPORT;
OutFile.CLOSE;
FileMgt.DownloadToFile(FileName, 'c:\output\ExportFile.csv');
And execute the report.
You can create a codeunit too with the same code if you like it more.
Regards.1
Answers
Do it this way, it will help you for sure.
https://msdn.microsoft.com/en-us/library/hh166529(v=nav.90).aspx
dynamicsuser.net/nav/f/106/t/72355
dynamicsuser.net/nav/f/106/t/69123
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/
And put thos code in the
OnPreReport()
// FileMgt codeunit 419
// FileName Text
// OutFile File
// OutS OutStream
// Xmlp your XMLPort
FileName := FileMgt.ServerTempFileName('CSV');
OutFile.CREATE(FileName);
OutFile.CREATEOUTSTREAM(OutS);
Xmlp.FILENAME(FileName);
Xmlp.SETDESTINATION(OutS);
Xmlp.EXPORT;
OutFile.CLOSE;
FileMgt.DownloadToFile(FileName, 'c:\output\ExportFile.csv');
And execute the report.
You can create a codeunit too with the same code if you like it more.
Regards.