Jump to content

Sync order of tables


This topic is 2543 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

 

 

Link to comment
Share on other sites

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]

 

Link to comment
Share on other sites

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 by Carsten
Link to comment
Share on other sites

This topic is 2543 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.