The following outlines the settings for Sage Timberline Initial Estimate integration .ini file profiles.

Default initialisation filename:

Int_TimberlineEstimating_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 Estimation

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_IntMapping	Description: ODBC DSN name for the Framework Integration Mapping database. Setting: FworkSQLIntMap
ODBCConnect_IntMapping	Description: ODBC DSN connection string for the Framework Integration Mapping database. Setting: None
ODBCDSN_Destination	Description: ODBC DSN name for the Timberline Estimation database. Setting: FworkTLPrec
ODBCConnect_Destination	Description: ODBC DSN connection string for the Timberline Estimation database. Setting: None

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 Estimation"
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.

File/Path Location

Key	Description/Setting
PathEstimateBlank	Description: Path to the blank estimate file we use to base the new estimation. Setting: x:\Framework\Data\IntData\Blank
PathEstimateDestination	Description: Path to the estimates where the new estimate will be added to all the other existing estimates. Setting: x:\Precision\
PathDAOLinkDB	Description: Path to a temporary access database used in the creation of the estimate. Setting: x:\Framework\Data\IntData
FileDAOLinkDB	Description: The Microsoft Access database used to creating the estimate. Setting: IntTLPrecLink.mdb
DestFileSuffix	Description: Suffix appended to job table name that results in the name of the estimate created. For example, 989346_pp_pee_estimate_coverpg_setup (see the _pp suffix in the job table name example). Setting: _pp

Browser not supported