search

chri55w / QuickBooks-Timer

Savantech QuickBooks Timer - Issue Tracking / Wiki ONLY
3 stars 0 forks source link

Database Synchronization Improvement #85

Closed chri55w closed 8 years ago

chri55w commented 8 years ago

Add a new columns 'UPDATED_LOCALLY' and 'LAST_UPDATED' to the tables TIME_LOG and TIME_LOG_TEMPLATE.

When a Time Log or Time Log Template is Changed set the 'LAST_UPDATED' value to the current Server time if online, otherwise set the value 'UPDATED_LOCALLY' to true and set 'LAST_UPDATED' to DateTime.UtcNow

When a Time Log or Time Log Template is Created whilst offline set the 'UPDATED_LOCALLY' value to true and set the 'LAST_UPDATED' value to DateTime.UtcNow

At the start of each synchronization process adjust any local Time Logs or Time Log Templates where 'UPDATED_LOCALLY' is true to account for time differences between the current server time and current PC time

chri55w commented 8 years ago

issue has been addressed and changes are currently being tested

chri55w commented 8 years ago

Issue appears fixed and has been released in Version 1.2.1