ftp gateway data as csv

[PhilG]

For Factory automation I use a product called Wonderware Intouch.  Currently I get data into this system from third party systems through a Windows VB application I created that screen scrapes HTML web pages from those systems and writes the data I want into a csv file which is read into Wonderware Intouch at intervals of 1 hour to 15 minutes.

I want to get Gateway data into Intouch and am considering the following options:

• My preference would be to modify the gateway so it could generate a csv file at regular time intervals, for the data I am interested in, and ftp it to my server
• Screen scrape the Gateway webpage - but the login presents a problem for me in my vb app.  I would need to get my vb app to load the gateway web page without a login prompt.
• go about the full blown MQTT route and do a full integration with OpenHAB which I am seeing many people talk about.

Can anyone help me get started in how to modify the gateway to generate a csv file at intervals of once an hour and if possible ftp the file?

[Felix]

If you remove the http auth from nginx, there will be no login but your gateway is now exposed. If this is inside a LAN its not a problem.
The periodic FTPing will require custom coding some javascript.