Versions Compared

Key

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


Expand
titleTable Of Contents

Table of Contents
printablefalse

...

General Configuration

XML Tab

Image Added

Output Type

  • Database
  • File (Default)

This table displays the Output Type configuration options that show for each selection choice.

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

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

Path

\HistoryData\ (Default) . Destination path for published files. Tokens 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 BuilderView 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
 (Default)
  • . Some database configurations require a client-side cursor.
If your configuration is stored in Microsoft SQL Server, use this setting
  •  SQL Server generally works well with a client-side cursor.
  • Server-side (Default). Some database configurations require a server-side cursor.
If your configuration is stored in Microsoft Access, use this setting.
  •  

Use Custom Query / Custom Query

Default = Not Selectedselected. 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

Image RemovedImage Added

History Period Time

...

  • 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

Event Type Source

The record property to use when creating the event type attribute for raw event data bytes.

...