Skip to main content

Set up Data Log Models

  1. Open the FactoryTalk View SE Studio from the Rockwell Software or FactoryTalk View program group then open the current application.

  2. Under the Data Log folder in the Explorer, select the Data Log Models icon.

  3. Under the Setup tab,

    image1.png

  4. Add a Description and Log File Identifier String.

  5. Set the Storage Format to ODBC database.

  6. For ODBC Data Source click the browse pushbutton […]

Select the System Data Source tab. Use an existing DSN or select New to create a new one. For a new DSN,

image2.png

  1. Select System Data Source.

  2. Click Next.

  3. Select the driver to make the connection the data source.

image3.png

SQL Server/SQL Express Configuration

It is highly recommended to use SQL Server or SQL Server Express as the data source for the Data Log Model. SQL Server Express is a free and downloadable from Microsoft’s website. For SQL Server or SQL Server Express,

image4.png

  1. Enter a Name, Description and select Server. If the Server is not listed, enter it manually.

  2. Click Next.

image5.png

  1. Select the authentication type

    image6.png

  2. Click Next

  3. Select the default database.

  4. Click Finish.

The DSN configured should now be set as the ODBC Data Source.

image7.png

  • Click Create Tables.

Note

Under the Paths tab the ODBC Backup Path can be enabled so that if the database is unavailable, data is not lost.

image8.png

The total number of characters and spaces allowed for the path and name is 255.

Note

Under the File Management tab, the Purge Oldest Records in ODBC Database option is available to periodically remove old historical data from the database.

image9.png

Under the Log Triggers tab,

image10.png

  1. Specify how the logging of tag values will be triggered i.e., periodically, on change or on demand.

    The On Demand option will log data when the DataLogSnapshot command is issued. This command can be issued from anywhere that commands and macros are supported. For example, it could be typed in the command line or specified as the action for an event. If Periodic or On Change is selected, on demand logging can still be used whenever it is appropriate.

Under the Tags in Model tab,

image11.png

  1. Specify the tags to be logged.

    The maximum number of tags that can be logged by one data log model is 10,000.

  2. Close the dialog.

On close the Save dialog is opened.

image12.png

Start Data Log

To start the data log when FactoryTalk View SE starts, access the HMI Properties dialog.

image13.png

  1. Right click on the application and select Properties.

Under the Components tab,

image14.png

  1. Check Data Logging and select the data log model.

If more than one data log model needs to be started, they can be started using the command:

DataLogOn “Component name”

Where “Component name” is the data log model name. If the model’s name has a space in it, enclose the name in quotes. The command can be issued from the command line or from a startup or login macro. For example:

DataLogOn"Power Station"

Note that in FactoryTalk View SE, an HMI server can have up to 20 data log models running at one time.

In this section: