[Imported] Pulling data from analogue point and save to csv file every 15min.

[sbeadle]

>>Message imported from previous forum - Category:Scripts and Tips<<
User: mchartrand, originally posted: 2018-10-19 19:50:41 Id:161
This is a re-posting from the obsoleted (October 2018) "Schneider Electric Telemetry & SCADA" forum.

-------------------------------

**_jayyuen:
I'm sorta new to clearscada. but i want to know how to extract the data from a analogue point every 15min and save to a csv file.
i think i found some old topics, says that you need to write a VB Script._**

-------------------------------

JesseChamberlain:
You shouldn't need to, create a SQL export object and run the export method from a schedule.

______________

**_jayyuen:
Like i said earlier. i'm quite new with clear scada.
i dont think the database in clear scada is linked to SQL in my case..
is it possible to write a ST script and get that certain analogue point data and save to csv ?_**

_______________

andrewscott:
The **SQL Export** object (see 'Create New / Other / SQL Export') isn't related to Microsoft SQL Server (or any other product), it's just a feature of ClearSCADA that allows you to run an SQL query and export the results to a CSV or TSV file on the server. The SQL query just needs to get the analogue point data that you require.

Combined with a schedule that triggers the export periodically will do what you asked.

______

**_jayyuen:
Finally got it working, thanks._**