Tutorials - Advanced OPC Data Logger
Note. Our data loggers use one engine and identical plug-ins. All tutorials and demos are recorded for Advanced Serial Data Logger, but can be useful for other our data loggers users too!
Video Tutorials
- Installing And First Steps How to install the logger and create a base configuration.
- Adding OPC Groups And Tags How to configure the logger to read data from your OPC server.
- Logging Data To a CSV File How to log data from your OPC server to a CSV file.
- Logging To File How to create a log file for incoming data. Various data logging modes.
- Installing Plugins How to download and install a plugin for your task.
- Exporting Data To Excel How to export data to an Excel file (simple method).
- Exporting Data To Database How to export data to an ODBC database (simple and universal method).
- Generating And Handling Events How to control incoming data and generate simple alerts.
Additional tutorials for Advanced OPC Data Logger
- Inserting OPC data to MS Access database through ODBC (features: adding groups and items, inserting to an ODBC database)
- Adding a timestamp in the CSV file (features: OPC groups)
- How to log OPC data to a SQL database.
- OPC to MSSQL: Writing a lot of OPC tags to MS SQL 2008 database
- OPC to MSSQL: Writing several OPC tags to separate columns
- OPC to MySQL: Writing OPC tags to MySQL 5 database
- OPC to a database: Writing OPC tags to a database
- OPC to Excel: Writing OPC data to Excel
- Filtering data by a tag value and write data to a database only when the value will change
- Filtering data out if an OPC tag value is not equal to a specified value
- Processing or storing OPC data by an event from the OPC server
- Aggregating data from multiple servers to one OPC server
OPC and DCOM Configuration on Windows 2008 and Windows 7
- Part 1. Installing OPC Core Components.
- Part 2. OPC and DCOM Configuration. Creating a user and giving access permissions.
- Part 3. Configuring the Windows 2008 and Windows 7 firewall for DCOM and OPC.
- Part 4. DCOM Configuration. Dcomcnfg.
- Part 5. OPC and DCOM Configuration. Typical problems and solutions.
OPC and DCOM Configuration on Windows 10, 11, Windows Server 2019, 2022
- Part 1. Installing OPC Core Components.
- Part 2. OPC and DCOM Configuration. Creating a user and giving access permissions.
- Part 3. Configuring the Windows 10, 11, Windows Server 2019, 2022 firewall for DCOM and OPC.
- Part 4. DCOM Configuration. Dcomcnfg.
- Part 5. OPC and DCOM Configuration. Typical problems and solutions.
Note. The parser for this software is already configured and embedded in the program. You don't need to set up it. All parser items are ready for exporting!
Examples and tutorials for data filter plugins
- Redirect COM port data to another COM port after transformation Tags: filter plugins, log files. Plugins: Expressions, Data redirecting.
- Detect data timeout using our data loggers and sending alert emails Tags: filter and events plugins, event notification. Plugins: Data timeout, Events notification.
- Replace alarm line printers. Custom events for alarms and notifications Tags: generate custom events. Plugins: Events generator, Events notification, Data timeout.
- Extract and Modify Lab Instrument Data for Excel Export Tags: regular expressions, data modification, direct excel connection. Plugins: ASCII Data Query and Parser, Expressions, Direct Excel Connection.
Examples and tutorials for data export plugins
- RS232 to Excel. Four methods to send data from RS232 to Excel Plugins: Various.
- Write data to a CSV text file Plugins: Local database, DDE Server.
- Write data to an XLS file without Microsoft Excel installed Plugins: Local database.
- Send data to Excel through the DDE interface Plugins: DDE Server.
- Export data and update charts in Excel in real-time Plugins: Direct Excel Connection.
- Export real-time data and draw charts in OpenOffice or LibreOffice Calc Plugins: Direct OpenOffice/LibreOffice Connection.
- Write data to an XLS file without Excel Tags: advanced export, text format, many options. Plugins: Excel Export Pro.
- Export Weight Data to Excel Scales without Excel Tags: variant #2. Plugins: Local database.
- Export data to Microsoft SQL Server 2015-2022 Tags: through the ODBC interface. Plugins: ODBC Database.
- Export data to the MySQL database Tags: direct database connection, flexible SQL statements. Plugins: SQL Database Professional, Aggregator, ODBC database.
- Export data to the SQL database using a stored procedure Tags: direct database connection, SQL stored procedures. Plugins: SQL Database Professional.
- Write data to Microsoft Access Tags: through the ODBC interface, importing table structure. Plugins: ODBC Database.
- How to display serial port's incoming data on a dashboard Tags: OPC Scada Viewer: gauges, indicators, charts, etc.. Plugins: OPC Server.
- OPC server for intelligent length meter Plugins: OPC Server, OPC UA Server, ASCII Data Query and Parser.
Related topics: Advanced OPC Data Logger
hereOPC Logger RS232 pinout and signals Cables and signals Data monitor cables