Configure Tag Synchronizer

The behavior of Tag Synchronizer can be configured on the Edit Configuration and Meridian Cloud tabs.

The options that are saved in the configuration file are summarized in the following tables.

Tag Synchronizer configuration settings
Category	Setting	Description	Default	Remarks
ExportDB	Command	Stored procedure name in the maintenance management system database.		Optional
ExportDB	Connection string	Connection string to the maintenance management system database where the stored procedure exists.		Optional
VaultInfo	DatastoreName	Datastore name of the destination vault.		Required
VaultInfo	MachineName	EDM Server service computer name.		Required
VaultInfo	RootFolder	Root folder in Meridian Enterprise for creating the tags.	\	Required
VaultInfo	TagDocExt	Meridian Enterprise extension of the imported tag.	.object	Required
VaultInfo	TagDocType	Meridian Enterprise document type of the imported tag.	tagObject	Required
VaultInfo	TagIDProperty	Meridian Enterprise property to be used to uniquely address a tag in the vault. If not configured then the display name is used. Note: Invalid characters \ / : * ? " < > \| appearing in the value are replaced by an underscore character _		Required
VaultInfo	VaultName	Name of the Meridian Enterprise destination vault.		Required
Config	AddressSMTPServer	Address of an SMTP server for sending email messages.		Optional
Config	LogDirexctory	Folder for storing the error log files.		Optional
Config	LogErrorEmail	Email address for reporting errors.		Optional
ImportDB	ActionAdd	Semicolon separated list of strings that trigger an import action.
ImportDB	ActionField	Column in the intermediate file that specifies the action to be taken. If no action is specified, then the application will import tags instead of retire them.		Optional
ImportDB	ActionRetire	Semicolon separated list of strings that trigger a retire action.
ImportDB	ConnectionString	Connection string to the maintenance management system database from which to import tags.		Required
ImportDB	DatabasePath	Path to the exported intermediate file.		Required
ImportDB	Field<X>	A column in the intermediate file to map to the corresponding Meridian Enterprise property specified in Property<X>. Possible formats include: Field<X>=<ColumnName>, <Size> Field<X>=//<Value> Where <ColumnName> is the name of a column in the intermediate file, <Value> is a fixed value to use and <Size> is an optional integer to restrict to a number of characters.
ImportDB	ImportDBFieldName	Column in the intermediate file that specifies the name of the imported tag.		Required
ImportDB	ImportPathField	Path to a content file to import for a new tag. Not applicable to existing tags.		Optional
ImportDB	NumFields	Number of additional properties to map. Ensure that at least a mapping between TagIDProperty and ImportDBFieldName exists.	N
ImportDB	Property<X>	Meridian Enterprise property to map to the corresponding intermediate file column Field<X>. The value is must contain both the Meridian Enterprise property set name and the property name in the format <PropertySet>.<PropertyName>.
ImportDB	ResultFail	Message to insert in the column specified by ResultField if the import or retire action fails.
ImportDB	ResultField	Column in the intermediate file for displaying the result of the action.		Optional
ImportDB	ResultOK	Message to insert in the column specified by ResultField if the import or retire action succeeds.
ImportDB	SelectionCommand	SQL SELECT statement for the intermediate file. The value can contain a placeholder {0} for the modification date time. See also SkipModifiedArgument.		Required
ImportDB	SkipExisting	Imports only new records.	0	Optional
ImportDB	SkipHeaderRecords	Integer value specifying the number of header records in the result set to be ignored.	0	Optional
ImportDB	SkipModifiedArguments	If True, the statement in SelectionCommand is expected to not contain a placeholder for the modification date and time.	False	Optional
ImportDB	SkipNonExisting	Only synchronizes existing tags.	0	Optional
ImportDB	SubFolderField	Column that contains a subfolder path where to import tags. Note: Invalid characters \ / : * ? " < > \| appearing in the value are replaced by an underscore character _		Optional
ImportDB	SubFolderFieldIsParent	Boolean value that specifies how to interpret the SubFolderField setting. Set to True if SubFolderField specifies the parent folder of the imported tag. Set to False if SubFolderField specifies the path to the tag (including the tag name). In that case the tag name is stripped from the value.	True	Optional
ImportDB	VersionField			Optional

Note:

If the SkipModifiedArgument setting is True, then the application expects a query that needs a modification date as an input parameter. This date should have the format YYYY/MM/DD hh:mm:ss.

For example:

Select * FROM <ImportDatabase> Where <ModificationDate> =%1

Where <ImportDatabase> is the name of the import database and <ModificationDate> is the date of the modification.
The ConnectionString setting in the ImportDB section may contain %1 as a placeholder for the intermediate filename. If so, then the user interface dialog will provide the option to specify the name manually. Do not use this feature when running in unattended mode.
After import, the import date and results are recorded in a text file and will be used in the next import. The name of the text file is Lastimport-<ConfigurationFileName>.log. The file will be located in the same folder as the application. If a mapped property is a part of the Field-Path definition, invalid characters \ / : * ? " < > | appearing in the value are replaced by an underscore character _

To configure Tag Synchronizer to import tags to your Meridian Cloud tenancy, set options on the Meridian Cloud page using the descriptions in the following table.

Meridian Cloud options
Option	Description
Meridian Cloud API URL	URL of the Create Asset endpoint as provided by the Accruent API Developer Portal. This allows the you to import into specific environments (Stage or Production, for example) as required.
Subscription Key	Subscription key as provided by the Accruent API Developer Portal. You must have already signed up for access and already subscribed to the Meridian Asset product.
Asset Property Mapping	The import destination properties. For each destination property, enter in the matching field in the intermediate file. GlobalId – Unique identifier of the asset TagNumber – Asset number TagType – Asset type (Work-Order, Equipment, or Location) TagStatus – Asset status TagDescription – Description of the asset FunctionalLocation – Location of the asset

Configure Tag Synchronizer

Rate this topic: