Settings in Smart Materials - Intergraph Smart Materials - 2017 R2 (2.2) - Administration & Configuration - Hexagon

Intergraph Smart Materials EcoSys Integration 2017 R2 (2.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
EcoSys Integration
Search by Category
Administration & Configuration
Version Smart Materials Web API
2017 R2 (2.2)

You must specify the following DBA settings and project defaults to enable the Smart Materials EcoSys integration.

The following general DBA settings and project defaults are applicable for the entire integration.

DBA Settings

DBA Setting

Description

Default Value

ECO_PRODUCT_GROUP

Defines the Product Group, whose projects data you want to integrate with EcoSys.

-

ECO_UNIT_GROUP

Defines a unit group so that all the units present in the EcoSys gets integrated with Smart Materials.

For example, currency is a unit present in EcoSys, to have same
in Smart Materials, create a unit group and add units to it.

-

Project Defaults

Project Default

Description

Default Value

ZI_E_PROJ

Determines the EcoSys Project ID that must be mapped with Smart Materials,
to exchange project specific data between
EcoSys and Smart Materials.

-

ZI_E_PW

Determines the Password to login EcoSys application.

-

ZI_E_SURL

Determines the application server URL to connect EcoSys service.

Sample format: http://{host}/ecosys/api/restxml/

-

ZI_E_UN

Determines the Username to login EcoSys application.

-

The Smart Materials projects which are in open status are only considered for integration. The project status can be verified from the A.20.01.02 Project Information screen in Smart Materials classic.

The following DBA settings and project defaults are applicable for the account code integration.

DBA Settings

DBA Setting

Description

Default Value

ECO_ACC_ATTR_SET

It defines an attribute set which must be defined at Product Group level in
Smart Materials. Attributes in the attribute set appear in Smart Materials Screen
J.10.02 Maintain Account Codes.

-

ECO_ACC_FREQ

It defines the frequency (in hours) in which a scheduler runs and integrates
all the Account Codes of EcoSys
into Smart Materials.

SHARED Tip To start the job, run “BEGIN m_pck_ecosys.import_ecosys_acc_codes; END;”.

24

ECO_ACC_UK

It defines an attribute set that must be defined at Product Group level in Smart Materials.
Attributes present in this set are mandatory and are used to
identify unique key columns of EcoSys
like WBSPath ID, CostAccount ID, and so on.

In a set,
first attribute should be WBSPath ID followed by CostAccount ID
and later other attributes.

This sequence helps in smooth integration of other modules at later stage.

-

Project Defaults

Project Default

Description

Default Value

ZI_E_ACAPI

Determines the EcoSys Account Codes resource name
that transfers Account Codes from EcoSys to Smart Materials.
If necessary parameters are present in API, then append them with
the Account Code resource name.

Sample format:

{EcoSys API name}/?{EcoSys parameter}={ZI_E_PROJ}

Example: ApprovedBudgetDetails/?Project={ZI_E_PROJ}

-

ZI_E_ACSER

Manages EcoSys Account Codes integration with Smart Materials.
If value is set to Y, Account Codes transfer from EcoSys to Smart Materials,
and if value is N, then no data is transferred.

Only logged in project data gets transferred from Smart Materials
to EcoSys Project ID that is assigned to ZI_E_PROJ default.

N

ZI_E_ACSTR

Determines the Smart Materials Account Code Structure name,
that consists of all the account codes that are transferred from EcoSys
to Smart Materials and appear on screen J.10.02 Account Code Structure.

You can assign an existing Account Code Structure name or define a new one.
If a new name is defined, then application automatically creates the same
account code structure name in screens J.10.01/J.10.02.

-

In the EcoSys spreadsheet you can find the parameters required for an API as shown in the picture below.

EcoSys01