Synchronization steps: Difference between revisions

Jump to navigation Jump to search
Line 19: Line 19:
== Uploading local changes ==
== Uploading local changes ==


The application logs all local changes to a table, <code>rs_changelog</code>.
The application logs all changes of the local database to two special tables:
* <code>rs_changelog</code> - changes in entity tables
* <code>rs_changelognn</code> - changes in relationship tables


Entities are sorted before upload, so that forward references are minimized. This is not always possible, for example in case of circular references. So, whenever possible, we upload parent records (quote, invoice...) before child records (quotedetail, invoicedetail...).  
Entities are sorted before upload, so that forward references are minimized. This is not always possible, for example in case of circular references. So, whenever possible, we upload parent records (quote, invoice...) before child records (quotedetail, invoicedetail...).  
Line 25: Line 27:
{{Note|By modifying ChildParentMap (i.e. adding new parent-child relation) you can influence the upload order.|Tip}}
{{Note|By modifying ChildParentMap (i.e. adding new parent-child relation) you can influence the upload order.|Tip}}


Records within an entity are uploaded sorted either by creation date (Woodford: <code>UploadRecordsInChronologicalOrder</code>) or by last modification date (default).
Records within an entity are uploaded sorted either by creation date (UploadRecordsInChronologicalOrder - Woodford [[Configuration]]: '''Upload Order''') or by last modification date (default).
* ExecuteMultipleRequests - 100 records in a batch
* ExecuteMultipleRequests - 100 records in a batch
* Questionnaires need increase to 500 records/batch
* Questionnaires need increase to 500 records/batch

Navigation menu