The following outlines the settings for Sage Timberline Sales Estimate Document integration .ini file profiles.
Default initialisation filename:
- Int_TimberlineDocument_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 Documents |
UseWizard | Description: n/a Setting: 0 |
DefaultRegionDivision | Description: Specifies the default region/division (PKID - Primary Key ID). Setting: Must be retrieved from the database. |
UseStaging | Description: Use an intermediate disk folder to perform integration (i.e., not in the destination folder). Setting: 1: Enable Staging 2: Disable Staging |
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_TLItems | Description: ODBC DSN name for the Timberline Items database. Setting: FworkTLPrecItems |
| ODBCConnect_TLItems | Description: ODBC DSN connection string for the Timberline Items database. Setting: None |
| ODBCDSN_Staging | Description: ODBC DSN name for the Staging database. Setting: FworkTLPrecStaging |
| ODBCConnect_Staging | Description: ODBC DSN connection string for the Staging database. Setting: None |
| ODBCDSN_Destination | Description: ODBC DSN name for the Timberline Claims database. Setting: FworkTLPrec |
| ODBCConnect_Destination | Description: ODBC DSN connection string for the Timberline Claims 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 Documents" |
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) |
Timberline Settings
Key | Description/Setting |
|---|---|
GroupCodeIntegration | Description: n/a Setting: * 000.000 |
PhaseCodeErrorItem | Description: n/a Setting: * 000.001 |
PhaseCodeCustomItem | Description: n/a Setting: * 000.002 |
PhaseCodeModifiedItem | Description: n/a Setting: * 000.003 |
PhaseCodeStandardItem | Description: n/a Setting: * 000.004 |
File/Path Location
Key | Description/Setting |
|---|---|
PathBlankDocEstimate | Description: Path to the blank document. Setting: x:\Data\Precision\Blank |
BlankDocEstimate | Description: n/a Setting: Blank.pee |
PathEstimateDestination | Description: Path to the estimates where the new estimate will be added to all the other existing estimates. Setting: x:\Data\Precision\ |
PathEstimateStaging | Description: Path to the staging folder where the processing will be done. Setting: x:\Data\Precision\Staging |
PathDAOLinkDB | Description: Path to a temporary access database used in the creation of the estimate. Setting: x:\Data\Precision\LinkDB |
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 |
Documents
Key | Description/Setting |
|---|---|
NAText | Description: n/a Setting: N/A |