Versions Compared

Key

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

...

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 for the published file. Tokens are allowed.

Path

\HistoryData\ (Default)  To . Destination path for published files. Tokens are allowed.

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

Table Name

Table name to use. Tokens are allowed.

Cursor Position
  • Client-side (Default). Some database configurations require a client-side cursor. If your configuration is stored in Microsoft SQL Server, use this setting.
  • 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 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.

...