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)

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

End time entered in days from now.

Start time entered in days before now.

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

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

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

10, 15, 80

Default empty.

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

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

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

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.

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

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

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

Internal use. Don’t change.

Internal use. Don’t change.

Internal use. Don’t change.

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.


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment