Versions Compared

Old Version 17

changes.mady.by.user Michael Standal

Saved on

compared with

New Version Current

changes.mady.by.user Emma Fullilove

Saved on

Key

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

...

titleTable Of Contents

...

General Configuration

Table of Contents
maxLevel3
minLevel3
typeflat
printablefalse

Configuration

General Tab

separatorpipe

Info
See the General Object Configuration guide for assistance configuring the General tab.  

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 time. Enter 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 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   (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. 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

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

  • All (Default)
  • Hourly
  • Daily
  • Other

Period Time

Default = 60 . Period Time in minutes to determine the resolution of the output data(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.

...