Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
FWINT HEAD
FWINT HEAD
nopaneltrue

Return to Sage Timberline Sales Estimating Document Integration
Article Index

Table of Contents


The following outlines the settings for Sage for Sage Timberline Sales Estimate Document integration 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

the Framework Integration Mapping database.

Setting: 

FworkSQLIntMap

ODBCConnect_IntMapping

Description:

ODBC DSN connection string for

the Framework Integration Mapping

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 

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