Create And Edit an Export Configuration

The Meridian Asset Management SAP Connector can work with multiple export configurations that are each stored in separate files.

Each export configuration comprises:

  • SAP Plant Maintenance server connection parameters

  • Item filter parameters

  • Output destination parameters

You can create and load export configuration files from within the SAP Connector user interface.

ClosedCreate New Export Configuration

To create a new export configuration:

  1. Start C:\Program Files\BC-Meridian\Program\SAP AMM Connector\BlueCieloECM.SAPInfoConnector.exe.

    The Accruent SAP Connector window opens.

  2. On the File menu, click New config.

    The Settings dialog box appears.

  3. Click options or type values using the descriptions in the following table.

Export configuration options

Group

Option

Description

Filtering

Export Functional Locations

Always set to True to include functional location items in the export.

Filtering

Export Equipment

Always set to True to include equipment items in the export.

Filtering

Date modified after

The date after which the modified items will be included in the export. Leave empty to include items with any dates. This option has no effect if Incremental update is set to True.

Filtering

Functional location starts with

The beginning characters of the identifiers of the functional locations to include in the export.

Filtering

Extra conditions

Additional filter conditions separated by AND or OR. Each condition must contain a column name in SAP Plant Maintenance, an operator abbreviation, and the value to match surrounded by single quotation marks ('). The supported operator abbreviations are listed in the following list. Use the tilde (~) character to break up expressions longer than 70 characters.

  • EQ — equals

  • LT — less than

  • LE — less equal

  • LIKE — like

  • GT — greater than

  • GE — greater than or equals

  • NE — not equals

Example of a short expression: IWERK EQ '1000' OR IWERK NE ''

Example of a long expression:  WERK LIKE '12%' AND ERDAT LT '20120501' ~ AND AEDAT LT '20120501'

Import Parameters

Incremental update

Set to True to include only matching items that have been modified since the date in LastSuccessfulImport. Set to False to export all matching items.
Import Parameters

LastSuccessfulImport

The date and time of the last successful export. This can also be manually reset in the configuration file (for example, 0001-01-01T00:00:00 or 2015-09-03T14:45:21.498+02:00).

Source SAP System

Application server

The URL or IP address of the SAP Plant Maintenance server from which to export items.

Source SAP System

System number

The number of the SAP Plant Maintenance instance from which to export items.
Source SAP System

System ID

The system ID of the SAP Plant Maintenance instance from which to export items.

Source SAP System

Client

The code of the client context from which to export items.
Source SAP System

Language

The language with which to connect to the SAP Plant Maintenance server.

Source SAP System

User name

The SAP Plant Maintenance account name with which to connect to the SAP Plant Maintenance server.
Source SAP System

Password

The password for the account specified in User name.

Source SAP System

Confirm password

The password for the account specified in User name.
Source SAP System

Pool size

The number of concurrent connections to use to the SAP Plant Maintenance database. The default is 1.

Target Database

ExportDBFilename

The fully-qualified path and filename of the Microsoft Access database to which to save the exported items. The substitution variable %1 may be specified to pass the filename as a parameter in the command line.

ClosedEdit Existing Export Configuration

To edit an existing export configuration:

  1. Start C:\Program Files\BC-Meridian\Program\SAP AMM Connector\BlueCieloECM.SAPInfoConnector.exe.

    The Accruent SAP Connector window opens.

  2. On the File menu, click Open.

    The Open Import Settings File dialog box appears.

  3. Select the export configuration file (*.sapexp) that you want to edit and then click Open.

    The configuration file is loaded.

  4. On the Tools menu, click Settings.

    The Settings dialog box appears.

  5. Click options or type values using the descriptions in the above table.

  6. Click OK.

ClosedSave Export Configuration as a Different File

To save the current export configuration as a different file:

  1. On the File menu, click Save As.

    The Save Export Settings File dialog box appears.

  2. Modify the file name and click Save.

2023