Databuild Purchase Order Integration - Profile Configuration

IntegrationType

Description: 

Specifies the type of integration to be performed. This is a fixed value that should not be changed.

Setting: 

Databuild Ordering

UseWizard

Description: 

Specifies whether Integration will be run manually or automatically.

Setting: 

0: Integration will be run based on the values in the ini file and can be run automatically without user intervention.

1: Integration will be run using a wizard allowing users to modify the details of the integration.

ODBCConnectionType

Description: 

Indicates if the Databuild database is SQL Server or Microsoft Access.

Setting: 

1: SQL Server

2: Microsoft Access

YieldMilliSeconds

Description: 

Length of time to pause the program in milliseconds.

Setting: 

0 (default)

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_DataBuildSys

Description:

ODBC DSN name for the Databuild system database.

Setting:

FworkDBuildSys

DatabaseName_DataBuildSys

Description:

Databuild system database name.

Setting:

DataBuildSys

ODBCConnect_DataBuildSys

Description:

ODBC DSN connection string for the Databuild System database.

Setting:

"uid=enterUserName;pwd=enterPassword"

ODBCDSN_DataBuildJob

Description:

ODBC DSN name of the Databuild Job database.

Setting:

FworkDBuildJob

DatabaseName_DataBuildJob

Description:

Databuild Job database name.

Setting:

DataBuildJob

ODBCConnect_DataBuildJob

Description:

ODBC DSN connection string for the Databuild Job 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 : Databuild Ordering"

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)

CriteriaMethod

Description:

Determines which data for Databuild Ordering is updated.

Setting:

1: CostCentre

2: Entity

3: Items

4: Orders

5: All

OrderCriteria

Description:

Criteria for selecting which jobs are updated.

Setting:

1: AllJobs

2: ByConstructionManager

3: BySupervisor

4: SingleJob(JobNumber)

OrderCriteriaID

Description:

The ID for the construction manager, supervisor, or single job as indicated in the OrderCriteria.

Setting:

0 (default)

Context

Description:

The Region Division ID if users only want to process Integration for a certain context.

Setting:

0 (default): All Region Divisions will be processed.

ProcessApprovals

Description:

The type of process approval process.

Note: Only applies if the CriteriaMethod is 4 or 5.

Setting:

1: OrdersAndApprovals

2: OrdersOnly

3: ApprovalsOnly

Note: If the setting is 1 or 3 then orders in Framework that are not found in Databuild will have their status in Framework set to Cancelled.

OnlyIntegrateNew

Description:

Instructs Integration to only process job orders that have dates within the range specified below.

Setting:

True: Only records within the date range will be included.

False: All records will be included.

StartIntegrationDate

Description:

If OnlyIntegrateNew is True (above), then we retrieve Databuild orders with dates >= to the StartIntegrationDate.

If StartIntegrationDate is None, then Integration continues as if OnlyIntegrateNew was set to False.

Setting:

None

dd/mm/yyyy

EndIntegrationDate

Description:

If OnlyIntegrateNew is True (above), then we retrieve Databuild orders with dates <= EndIntegrationDate.

If EndIntegrationDate is None, then today's date will be used.

Setting:

None

dd/mm/yyyy

LinkPOsToLogisticsItems

Description:

1. Unlinks cancelled Orders from uncalled Construction Logistics Activities.

2. Links valid Orders to Construction Logistics Activities based on criteria.

Setting:

True: Link function is switched on

False: Link function switched off

ApproveReceiptedInvoices

Description:

The Payment Approval status for a Purchase Order made on the Construction Logistics tablet is automatically set to Payment Authorisation in Databuild.

Setting:

True: Approval function is switched on

False: Approval function switched off