Sage Timberline Sales Estimating Document Integration - Profile Configuration

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

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_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)

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

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

NAText

Description:

n/a

Setting:

N/A