Page Comparison

IntegrationType

Specifies the type of integration to be performed. This is a fixed value that should not be changed.

Setting: 

BizPrac Accounts

ODBCDSN_Framework

ODBC DSN name for

the Framework ECM database.

Setting: 

FworkSQLEcm

ODBCConnect_Framework

ODBC DSN connection string for the Framework database.

Setting: 

None

ODBCDSN_FrameworkLicense

ODBC DSN name for the Framework Licence database.

Setting:

FworkSQLLic

ODBCDSN_IntMapping

ODBC DSN name for

the Framework Integration Mapping database.

Setting: 

FworkSQLIntMap

ODBCConnect_IntMapping

ODBC DSN connection string for

the Framework Integration Mapping database.

Setting: 

None

ODBCDSN_Destination

ODBC DSN name for the BizPrac Accounts database.

Setting:

FworkBizPrac

ODBCConnect_Destination

ODBC DSN ID and password for the BizPrac Accounts database.

Setting:

None

Mail_System

Email delivery method.

Setting: 

• 0: No email will be sent.

• 1: Email will be sent using MAPI.

• 2 (default): Email will be sent using SMTP.

Mapi_Profile

Microsoft Outlook user profile name.

Setting:

(default): Outlook

Mail_From

Name or email address of who or where the email is being sent from.

Setting:

FrameworkIntegration

Mail_Recipient

Mail recipients of the integration logs. Multiple addresses can be added if separated with a semi-colon (;). Spaces are not necessary before or after the semi-colon.

Setting:

enterRecipientEmail@yourDomain.com.au;integrationsupport@insulagroup.com.au

Mail_Subject

Email subject heading for the integration logs.

Setting:

"Framework

Integration : BizPrac Accounts"

SMTP_Server

If using Mail_System 2 (SMTP), add the SMTP Server name.

Setting:

enterSMTPServerName (replace this text with your SMTP Server name)

SMTP_UseSecurity

Security status of the SMTP server.

Setting:

• 0 (default): A username and password is not required.

• 1: A username and password is required. If this setting is used, the SMTP_UserName and SMTP_Pwd fields must have a valid username and password.

SMTP_UserName

Valid username for the SMTP server.

Setting:

enterUserName (replace this text with a valid SMTP Server User Name)

SMTP_PWD

Valid password for the SMTP username.

Setting:

enterPassword (replace this text with a valid SMTP Server Password)

CriteriaMethod

Job selection criteria for retrieving records

from Framework ECM to process.

Setting:

• 1: Single region/division

• 2: Single job

• 3: Single team.

• 4 (default): All jobs

• 5: Accounts entity

CriteriaData

Input criteria data for the criteria method.

Setting:

insert number; for example, if using CriteriaMethod 2, the setting for CriteriaData will be the specific job number to integrate on.