The AutoSol EFM Database facilitates direct publishing of collected records to a configured set of tables in a specific format.
See the General Object Configuration guide for assistance configuring the General tab. |
Used for the connection to the database. Entering this information is currently a manual process in ACM, but the Database Provider String Builder can be used. This can be found in: Start > Programs > AutoSol Communication Manager > Database Provider String Builder. Reference the Maintenance section of the User Guide for more information.
Default = Select. Will create a database if the named one does not exist.
Select the appropriate Cursor Position per the database configuration requirement.
Floating point numbers (numbers with a fractional part, like "1.25") use a specific format in the computer's memory. There are certain values that can't be represented meaningfully e.g.-'infinity' or 'negative zero'. Occasionally ACM will receive one of those values from a field device. Since those values can't be used in any logical fashion, databases frequently can't accept them. This option tells ACM what to do when it has one of those values.
This setting determines whether timestamps are left as provided by the flow computer or all records are converted to leading time stamps.
Store the server (computer) name with each record inserted into a table.
Text for ServerID column in database tables.
Default = Not selected. Select to store the meter name with each record inserted into a table (in addition to the unique Meter ID).
Default = Not selected. Select to store the record source (device name) with each record inserted into a table.
Default = Not selected. Select to write the insert statement to a file if the database insert fails. If checked, select the appropriate location and file name to store the logs in Failed Inserts File Name.
Default = tblAsiEFMAlarmRecords
Default = tblAsiEFMConfigRecords
Default = tblAsiEFMEventRecords
Default = tblAsiEFMHistoryRecords
Default = CREATE TABLE [$$Table$$] ($$Columns$$)
Default = insert into [$$Table$$] ($$Fields$$) values ($$Values$$)
Default = Selected. Select to prefix field names with a string.
Default = Selected. Select to suffix field names with a string.
To add additional tokens, click on the Field to bring up the Property Specific option in the tool bar, click on Property Specific and select the appropriate Token under Insert Token Item. The listing of available tokens and how they can be used is covered in the article called Substitution Tokens |
Select the time period of the record types to be written to the file.
Default = 60. Period Time in minutes to determine the resolution of the output data.