| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Return to Sage Timberline Variation Comparison Integration
Article Index
| Table of Contents |
|---|
The following outlines the settings for Sage for Sage Timberline Variation Comparison integration Comparison integration .ini file profiles.
Default initialisation filename:
Int_TimberlineVariations_Default.ini
Settings
Key | Description/Setting |
|---|---|
IntegrationType | Description: Specifies the type of integration to be performed. This is a fixed value that should not be changed. Setting: Timberline Variation Comparison |
Databases
Key | Description/Setting |
|---|---|
ODBCDSN_Framework | Description: ODBC DSN name for the Framework database. Setting: FworkSQLEcm |
ODBCConnect_Framework | Description: ODBC DSN connection string for the Framework database. Setting: None |
ODBCDSN_FrameworkLicense | Description: ODBC DSN name for the Framework Licence database. Setting: FworkSQLLic |
ODBCDSN_Destination | Description: ODBC DSN name for the Timberline Accounts database. Setting: FworkTLGold |
ODBCConnect_Destination | Description: ODBC DSN connection string for the Timberline Accounts database. Setting: "uid=enterUserName;pwd=enterPassword" |
Mail Configuration
Key | Description/Setting |
|---|---|
Mail_System | Description: 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 | Description: Microsoft Outlook user profile name. Setting: (default): Outlook |
Mail_From | Description: The name or email address of who/where the email is being sent from. Setting: FrameworkIntegration |
Mail_Recipient | Description: These are the mail recipients of 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 | Description: Email subject heading. Setting: "Framework |
Integration : Timberline Variation Comparison" | |
SMTP_Server | Description: If using Mail_System 2 (SMTP), add the SMTP Server name. Setting: enterSMTPServerName (replace this text with your SMTP Server name) |
SMTP_UseSecurity | Description: Is security used for the STMP server? Setting: 0 (default): A username or 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 | Description: A valid username for the SMTP server. Setting: enterUserName (replace this text with a valid SMTP Server User Name) |
SMTP_PWD | Description: A valid password for the SMTP username. Setting: enterPassword (replace this text with a valid SMTP Server Password) |
Criteria
Key | Description/Setting |
|---|---|
CriteriaMethod | Description: Job selection criteria for retrieving records from Framework to process. Setting: 1: Single region/division 2: Single job 3: Single team 4: All jobs 5: Accounts entity |
CriteriaData | Description: 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. |
Timberline Settings
Key | Description/Setting |
|---|---|
TLJobNumberFormat | Description: Job number format for referecing a Framework client in Timberline. Setting: 0: Not formatted 1: 00-00 2: 0-0000-00 3: 00-0-0000 4: 00.0000 5: 00-0000 6: 0000-000-000 |