Demo

Title	Data logger - Overview
Duration	08:51
Size	5,08 MB
Title	Data logger - data parsing
Duration	06:48
Size	4,94 MB
Title	How to add a data notification (by way of example of Printer Monitor)
Duration	05:27
Size	3,14 MB
Requirements	Events notification plug-in

Tutorials

Examples and tutorials for parsers

Parsers are most important part of the program. If you will not configure it, then you can't use data export modules.

• Parsing data from barcode scanner and writing to a log file with a date/time stamp (data at fixed positions, no data packet signatures);
• Processing data from barcode scanner (data at fixed positions, data packets with the end signature);
• Parsing data with help of regular expressions (complex data format, regular expressions, data filter);
• Receiving and parsing data from aircraft engine monitor (usage example, custom data parser);
• Processing data from the lab equipment (simple data format, regular expressions);
• Receiving and parsing data from Garmin Geko301 GPS receiver (simple data format, data at fixed positions, data packets with both signatures);
• Parsing data from the filling machine (simple data format, delimited data, data packets with the end signature, data filter);
• Parsing and processing data from PBX (simple data format, data at fixed positions, data packets with the end signature, data filter);
• Logging and parsing data from an intellectual pressure measuring device (sending requests to the device, simple data format, data at fixed positions, data packets with the end signature, data filter);
• Serial data acquisition in the Checkweigher Management Information System (complex data format, regular expressions, filtering data);
• Serial port data aggregation. Combine a data of two different com-ports (simple data format, data at fixed positions, data packets with the end signature, data filter);
• Weight data logger. Parsing weight data from scales (simple data format, data at fixed positions, data packets with the end signature, data filter).
• Send data to a port from a file (data requests, send data by a schedule).

Examples and tutorials for data filter plug-ins

• Redirecting COM port data to anoter COM port after transformation (ASCII data parser, filter plugins, log files).
• Controlling PLC coil registers status using MODBUS TCP (MODBUS data parser, custom scripts, events generating and handling).

Examples and tutorials for data export plug-ins

To export data to the necessary format, please, click on the corresponding link below:

• RS232 to Excel. Four methods to send data from RS232 to Excel;
• Writing data to a CSV text file with help of "Local database" plug-in;
• Writing data to an XLS file without Excel with help of "Local database" plug-in;
• Sending data to Excel through the DDE interface with help of "DDE Server";
• Exporting data and charting in Excel in real-time with help of "Direct Excel Connection" plug-in;
• Writing data to an XLS file without Excel with help of "Local database" plug-in (variant #2);
• Export data to Microsoft SQL Server 2000 with help of "ODBC Database" plug-in;
• Export data to the MySQL database with help of "SQL Database Professional" plug-in;
• Write data to Microsoft Access with help of "ODBC Database" plug-in.
• How to display serial port's incoming data on a dashboard with guages, indicators, charts, etc.

Examples

For execute examples it is necessary to download test application who will emulate data transfer. The given program can transfer data strings as with usage of the cable connecting two serial ports, and to transfer the data directly in the program.

Download serial device emulator now.

Direct Excel Connection

This example shows how to export data to Microsoft Excel through OLE (direct access method), therefore Microsoft Excel should be installed on your PC. This example writes data to rows and columns and shows how to configure ASCII data parser module.

Setup includes: Windows registry files with parser's and data publication module configuration.

Installation:

1. Close Advanced Serial Data Logger, if it's started;
2. Download all necessary files (serial device emulator, plugin's setup file, example Zip-archive file);
3. Install "Direct Excel Connection" data publication plugin;
4. Install Serial device emulator;
5. Next unpack all files from Zip-archive in any folder on your disc and remember location;
6. Double click in the Windows Explorer on direct-excel-connection.reg, which you have unpacked from archive. After that you'll see the following message: 'Information in direct-excel-connection.reg has been successfully imported into the registry';
7. Double click in the Windows Explorer on serial-device-emulator.reg, which you have unpacked from archive. After that you'll see the following message: 'Information in serial-device-emulator.reg has been successfully imported into the registry';
8. Run Serial device emulator;
9. Run Advanced Serial Data Logger;
10. The example configuration uses COM1 as a default serial port. If this port exists in your system simply go to the step 14, otherwise read next step;
11. Select Options->Manage configurations and select a configuration with "Unknown" name. Then click the "Change port configuration" menu item and select any existing port name from a ports list;
12. Click the "OK" button;
13. Please, set a corresponding serial port in Serial device emulator;
14. Click the "Start" button in Serial device emulator.

Download example (Zip archive, 1 kB) | Download plugin for Advanced Serial Data Logger

ODBC database

This example shows how to export data to Microsoft Access through ODBC connection, therefore ODBC driver should be installed on your PC. Typically this driver is being installed with Microsoft Office installation.

Setup includes: Microsoft Access sample database, Windows registry files with parser's and data publication module configuration.

Installation:

1. Close Advanced Serial Data Logger, if it's started;
2. Download all necessary files (serial device emulator, plugin's setup file, example Zip-archive file);
3. Install "Direct Excel Connection" data publication plugin;
4. Install Serial device emulator;
5. Next unpack all files from Zip-archive to the "C:\Examples" folder;
6. Double click in the Windows Explorer on odbc-alias.reg, which you have unpacked from archive. After that you'll see the following message: 'Information in odbc-alias.reg has been successfully imported into the registry';
7. Double click in the Windows Explorer on odbc-database.reg, which you have unpacked from archive. After that you'll see the following message: 'Information in odbc-database.reg has been successfully imported into the registry';
8. Double click in the Windows Explorer on serial-device-emulator.reg, which you have unpacked from archive. After that you'll see the following message: 'Information in serial-device-emulator.reg has been successfully imported into the registry';
9. Run Serial device emulator;
10. Run Advanced Serial Data Logger;
11. The example configuration uses COM1 as a default serial port. If this port exists in your system simply go to the step 15, otherwise read next step;
12. Select Options->Manage configurations and select a configuration with "Unknown" name. Then click the "Change port configuration" menu item and select any existing port name from a ports list;
13. Click the "OK" button;
14. Please, set a corresponding serial port in Serial device emulator;
15. Click the "Start" button in Serial device emulator.

Download example (Zip archive, 10 kB) | Download plugin for Advanced Serial Data Logger