Export from Xpages using Lotus script

Question

I need some enlightenment in using Xpages and Lotusscript.

I have an export button in Xpages, that takes the ID as parameter sends it to Lotus script agent, which than uses that id to fetch data from web service and exports it to .csv. The agent was tested and is working. And when i run the Xpages in notes and try to export data it's working, the file is shown in folder that is designed to. But when the Xpage is running from the browser (chrome, mozilla) and export is pushed nothing happens. Do i have to use some other way to export data?? Can you give me some explanation how to export data from browsers

Paul Stephen Withers Paul Stephen Withers · Accepted Answer · 2015-05-18T09:45:29

Where are you testing the agent and where are you looking for the file?

When XPages runs from a browser, all that can ever run on the browser is client-side JavaScript. Any of your back-end code (SSJS etc) runs on the server, the LotusScript agent will also run on the server. So if the LotusScript agent is creating and saving a CSV file to a folder, it will save it to that folder on the server.

Exports running from a browser will typically return HTML or other content that the PC can interpret as needing to be opened in a certain program, e.g. Excel. But you would need to save the code in a Notes Document, then access the document and print the result back to the browser.

There are open source projects like OpenCSV that have Java libraries for outputting a stream of CSV data for a browser. (It's not Apache-licensed, so can't be put on OpenNTF under the Apache license.)

Export from Xpages using Lotus script

4 Answers