| Expand | ||||
|---|---|---|---|---|
| ||||
|
...
ImportFolder The location the service will use to look for new files to process. The service checks for new files every 10 seconds. The files found are processed one at a time in alphabetical order by file name.
ArchiveFailedFolder The location the service will use to move files that failed to process.
ArchiveCompletedFolder The location the service will use to move files that processed successfully.
Info title When Is A File Considered Successful? In order for a file to be considered successful, at least one request in that file must have resulted in a valid request entry to be processed (In other words it was entered in the database). Therefore, it is possible for multiple requests from a file to fail as valid request entries but have the file archived as successful. A failed file is one for which no requests resulted in valid request entries.
ValidationTolerance This value is used when the mole components are totaled up and allow a tolerance window to be valid for processing. 100 would let any sum validate. 0 would require a perfect 100%. Example: A value of 10 would result in a range tolerance of 90% to 110% for the final total of all mole components.
MeterResolutionMode This value is used to determine how the Gas Analysis Write File Service resolves the meter associated with data in the file. A value of RecordField indicates that a column in the delimited file contains the metername/number that corresponds to a meter configuration object present in the ACM configuration data base. Each file line is evaluated as a separate request with the value present in this column. A value of FileName indicates that the name of the file (what precedes the file extension) contains the metername/number that corresponds to a meter configuration object present in the ACM configuration data base. Each file line is evaluated as a separate request but the filename will be used to resolve the metername/number for all lines in the file. If your files contain data to be sent to multiple meters and devices, then it is recommended to use the RecordField mode. For more information, please refer to the section on Meter Mapping Between Systems below.
FieldMapping This value stores the column mapping scheme used by the service to determine the meaning of data in each column of the file. Please refer to the section on Field Mapping for more information on how to configure this setting.
FieldDelimiter This value is used to indicate what character is expected to delimit files imported by the service. The default is a comma. The valid delimiters are comma ",", tab "\t", pipe "|", and semicolon ";".
HasColumnHeaders This value is used to signal the service to skip any attempt to process the first row of the file as a request record if the file contains the column headers or descriptions on the first row of the file.
...
The meter object name in ACM matches the value of the mapped GCIDENTIFIER column.
The External GC property of a device meter object matches the value of the mapped GCIDENTIFIER column.
Validation Tolerance
Mole sum validation is used to validate the sum of the mole components of a request record before it is submitted to ACM. The tolerance is a +/- value range the sum must fall between to be considered valid. To disable validation, the tolerance can be set to a value of 100 which allows a wide range. If the file mole component values are a percentage of 100, then apply a tolerance to compliment. If the values are decimal number of 1 (such as .95), then use a tolerance value with a decimal.