Data Logging
SECTION 11 Data Logging
177
11-6-5 Generation of Text Files
Whereas CSV files only contain limited information e.g. Breaks, Date, Time,
Milliseconds and Value, Text files contains all the information stored on
selected Items/Groups i.e. the expression, label, deadband etc. The multiple
selection rules apply as described in the previous paragraph, with the
exception that On Change items can be grouped together.
11-7
Data Logging
As well as the inbuilt datalogging features, it is also possible to log data
directly to an existing Database. This provides direct storage of data in third
party format, allowing for easy analysis using familiar tools, and there is no
need for scripts to export data. However slower speed means logging to a
database may be unsuitable for tasks with large data throughput or high
logging speed. Also, unlike the standard Datalog files, there is no standalone
viewer for instant viewing. The ADO interface used to access Data Sources
does not provide any mechanism for creating Databases or Tables, therefore,
it is not possible to automatically create a data source. Unpopulated data
sources for use in Database Logging, must first be created using the specific
software for your choice of data source e.g. "MS-Access".
To configure CX-Supervisor to log to a database:
•
Create an 'unpopulated' data source or 'template' for use in Database
logging.
•
Create a Database connection in the Workspace Database editor to the
database created above. Add a recordset with a read/write lock, and fields
with 'Field Property' configured as 'Add' so records can be added.
•
Create a Database Link in the Workspace Logging editor, by selecting
'Add Db Link…' from the popup menu to show the Add Database Link
dialog box.
•
Create Field Links for each field to log by selecting 'Add Db Field…' from
the popup menu to show the Add Field Link dialog box.
11-7-1 Add Database Link Dialog
The Add Database Link dialog box show below is show when the 'Add Db
Link…' menu option is selected from the Data Log editor, and the identical
Modify Database Link dialog box when the 'Edit' menu is selected.
11-7-1-1 Link Name
For convenience, a unique Database Link name is created automatically. This
can be changed to give a more meaningful description, if required.
Содержание CX-Supervisor
Страница 1: ...CX Supervisor Software Cat No W10E EN 01 User Manual Software Release 3 1...
Страница 3: ...Copyright Notice 2...
Страница 16: ...15...
Страница 17: ...16...
Страница 27: ...Tip of the Day SECTION 1 Graphics Editor 26...
Страница 35: ...CX Supervisor Preferences SECTION 2 Pages 34...
Страница 79: ...Responding to Events SECTION 5 ActiveX Objects 78...
Страница 115: ...Printing the Graphics Library SECTION 7 Graphics Library 114...
Страница 181: ...Data Logging SECTION 11 Data Logging 180...
Страница 201: ...Examples SECTION 12 Databases 200...
Страница 243: ...Performance Monitor SECTION 16 Application Analysis Performance Monitor 242...
Страница 253: ...Using with Omron s CX Server OPC SECTION 17 Using CX Supervisor as an OPC Cli 252...
Страница 259: ...Creating a CX Supervisor Client application SECTION 18 Connecting to a remote CX 258...
Страница 263: ...Adding a Point Linked to a Parameter SECTION 19 Connecting to Omron Industrial 262...
Страница 271: ...Data Logging SECTION 20 Best Practices 270...
Страница 275: ...Configuring a Server PC running Windows NT or 2000 Appendix A Configuring a PC 274...
Страница 277: ...Appendix B Frequently Asked Questions 276...
Страница 296: ...Appendix B Frequently Asked Questions 295...
Страница 297: ...Appendix B Frequently Asked Questions 296...
Страница 298: ...Appendix B Frequently Asked Questions 297...
Страница 299: ...Appendix B Frequently Asked Questions 298...
Страница 333: ...Revision history 332...