Page 1 of 1
VLF-ONE Framework - Download iSeries Table to Excel
Posted: Thu May 28, 2020 5:03 am
by alphabeta13
Hi,
I have a requirement to download records that meet certain criteria from an iSeries table to excel when user clicks on a push button, without showing the records in an instance list.
Any idea on how to do this? I'm using VLF-ONE framework.
Thanks,
Taufik
Re: VLF-ONE Framework - Download iSeries Table to Excel
Posted: Sat May 30, 2020 10:42 am
by MarkD
There's several ways to do this.
(1) - Create a CSV file on server and return that file as the payload of your server module.
(2) - Create a CSV stream on the client from data returned by server module in a working list.
(3) - Create a real XLS file using LANSA Integrator.
Note: MS-Excel tends to open CSV formatted files easily.
Some resources / examples are:
For option (2) execute shipped demo framework and search for 'CSV' ...........
- Capture_1.PNG (24.73 KiB) Viewed 8980 times
For option (1) execute shipped demo framework and search for 'download' ...........
- Capture_2.PNG (23.51 KiB) Viewed 8980 times
Re: VLF-ONE Framework - Download iSeries Table to Excel
Posted: Sat May 30, 2020 10:47 am
by MarkD
A quick way to create a CSV file on the server is to use the TRANSFORM_LIST built-in function - use the "AU" or "OU" option.
https://docs.lansa.com/14/en/lansa015/i ... m_list.htm
Also, this is all just Visual LANSA stuff and nothing specific to VLF-ONE.
i.e. VLF-ONE is just a Visual LANSA application