Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Expand
titleTable Of Contents

Table of Contents
printablefalse

...

FileDatabase

Contract Time

  • Do not use contract time.
  • Use the configured contract timeEnter the appropriate Contract Hour and Minute.
  • Use the meter’s contract time (Default). Uses defined contract time per the Protocol or Meter object.

Single Precision

(Select Default or Custom) enter a value for Precision if Custom is selected. See Numeric Precision.

Double Precision 

(Select Default or Custom) enter a value for Precision if Custom is selected. See Numeric Precision.

File

Name for the published file. Tokens are allowed. Default = $$Meter.Name$$.cfx. 

Path

Name for the published file. Tokens are allowed. Default = \HistoryData\ 

To add additional tokens, click on Property Specific and select the appropriate Token under Insert Token Item.

Provider String

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.  View the Maintenance Section of the User Guide for more information.

Table Name

Table name to use. Tokens are allowed.

Cursor Position

Select the appropriate Cursor Position per the database configuration requirement.

  • Client-side. Some database configurations require a client-side cursor. SQL Server generally works well with a client-side cursor.
  • Server-side (Default). Some database configurations require a server-side cursor. 

Use Custom Query / Custom Query

Default = Not selected. Use the custom insert query text instead of the insert command when publishing the XML document.

Insert Command

Default = insert into $$Table$$ (MeterName, XmlData) values ('$$Meter.Name$$', '@XmlData') Command used for inserting new records.

Document Filter

Default = $$Meter.Name$$.xml. Use tokens to filter record into separate publish documents.

...

Info
titleTokens

To add additional tokens, click on the field to bring up 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

Records Tab

History Period Time

Select the time period of the record types to be written to the file.

  • All (Default)
  • Hourly
  • Daily
  • Other

Period Time

Default = 60 (minutes). If "Other" is selected above, the publisher will use this value to publish only those records that have a matching period value.

Check all required record types to be published

...