Sync order of tables

[Carsten]

Hi,

in which order are the tables synced when MirrorSync starts?
Is this done in the order how they occur in the "sync" Layout folder?

We are syncing quite a few tables and use filters in the customization script to reduce the amount of records to be synced.

We want to start syncing the relevant projects, then only the relevant phases of these projects and then only the relevant tasks of these phases ...
That is why we need to synchronize in this order ...
project-phase-task

If we start the customization script (MirrorSync Customization) from the different sync Layouts in the "right" order of the tables all filters work fine.

My question from the beginning is one of my first steps to look for my mistake :-)

 

Kind regards from Germany

Carsten

 

 

[Tsiry360Works]

Hi Carsten,

If you have not set relationships between layouts on MirrorSync config client (foreign key mapping) then the sync order will follow the alphabetic order of the layouts. With relationships, sync order is different and basically MirrorSync will insert/update parent table before children table. For deletion, it is the reverse, children then parent.

Thank you.

Tsiry Ranaivoarisoa
Apprentice Developer
[email protected]

 

[Carsten]

Thanks Tsiry

then I will reduce the amount of relationships in the MirrorSync config client to get a parent child logic which is necessary for syncing.

A few relationships there are not really necessary for this case (value lists, more or less)

Kind regards

Carsten

Edited April 12, 2017 by Carsten