Issue
Often data is required to be exported out from the Continuum system for record keeping or for further analysis, what keywords can be used to help with this?
Environment
- Cyberstation Plain English programs - all versions.
- Microsoft Excel
Product Line
Andover Continuum
Cause
Specific help is available in the product for specific keywords but how can these be put together to export data to .CSV format.
Resolution
As we do not advocate 3rd party system trying to directly extract data from the Continuum database, you should create a Plain English program in a Workstation that can export logged data directly from the controllers out to a .CSV or .TXT file.
Keywords to use for this purpose are:
- OpenFile
- WriteFile
- CloseFile
Details of the above Keywords are available in the Cyberstation internal help pages.
The attached example dump file could be run on a daily basis to extract temperature logs from a controller and save them to files with a date stamped naming convention.
Click to download the example WriteFile dump file.