- Run Operation Export to File

This [EE] feature can be useful for many scenarios where you want to transfer data by storing the file at a location on the machine that hosts your Tomcat server. Data may be transferred from a WOW operation in CSV, JSON or XML formats.

By placing the PJMRCLASS=planetj.magic.OperationToFileRequest within the URL, the operation will automatically download file as specified by parameters below. The colors are for demonstration purposes and to help the reader identify the parameters. Your URL will look similar to this example:

http://apps.planetjavainc.com/wowADDONDEV/run?PJMRCLASS=planetj.magic.OperationToFileRequest&opid=161&_pj_lib=wow_tmp&file=D:/temp/test.csv&type=CSV&email=wow@test.com&pass=wow

Parameters of the request will include the following within the URL:

Steps to enable the WOW operation to write to a file on your Web Server’s drive:

• 1. Create a WOW operation to return the data you need in your report. It is very important that you make sure your operation is set with a high enough row count to return all of the rows; otherwise, all of the data will not save to the file.

  2. Create the URL required and put into a Windows Task Scheduler (or just run the URL from a web browser if you don't need a reoccurring write).

  3. Set up a Windows Task in the Task Scheduler to run this URL every x minutes, hours, days (depending on your requirements).

  4. This feature is set up to overwrite the file each time, so no data synchronizing is necessary.

Tags: Direct to file , output to file, generate Excel / CVS file automatically, webservice to create file