ProjectDBSync

This will perform a project DB synchronization. This macro element has no user parameters.

Note: This function is only avaible with SQL XAL Project integration module.

Example parameter configuration

To setup the DB connection and other general DB settings, go to Functions -> Settings -> Project Database integration.

Parameter descriptions

(* = configuration required)

cachePreparedStatements
If true = prepared statements will be cached. Use in cases where prepared statements should be recreated on every import. Used in combination with dynamicWhereClause.

calendarAfterNowHorizon
End time entered in days from now.

calendarBeforeNowHorizon
Start time entered in days before now.

doImport
If false only export will be performed. Also see “exportAfterImport” and “exportBeforeImport”.
Default true.

dynamicWhereClause
You may enter a dynamicWhereClause using normal SQL. It will then replace {6} in the query file – xalprjsql.properties.

excludeOrderStatesOnExport
Comma separated list of order states, which should be excluded on export.
Example:

10, 15, 80

Default empty.

10 = New
15 = Forecast
20 = Planned
30 = Released
40 = Start Possible
50 = Started
60 = Paused
70 = Cancelled
80 = Completed

exportAfterImport
If = true export is performed after import.
Default true.

exportBeforeImport
If = true export is performed before import.
Default true.

exportScriptFileName
FileName for Groovy-script containing custom integration. If a Groovy-script is selected it will be run instead of the macro and the parameters set on the macro will be ignored.

importAllProdData
If = true all production data will be imported.
If = false it will revert back to normal settings for DirectSQL.

importAllResource
If = true all data regarding resources will be imported.
If = false it will revert back to normal settings for DirectSQL.

importOrderCentric
Relates to project.
If = 1 operations per order will be imported.
If = 0 operations per project will be imported.

lastChanged
Internal use. Don’t change.

lastUpdated
Internal use. Don’t change.

type
Internal use. Don’t change.

useExportNotificationManager
If true, the export of changed orders will be carried out by the export notification manager which will notify the external ERP of changed orders and then trigger some business logic in the ERP system that will import the changes.