We have installed same version of uCommerce Sync on 2 Umbraco + uCommerce installations. We are trying to sync uCommerce data from one site to other.
For that we choose 'Export' option which will export all data. We then copied files and tried to import data on another installation. In the import process we are facing issues.
When we looked into the issues, we found that: 'uCommerce Sync' is NOT generating XML for data for row in table whose 'Deleted' column value is 'True'. But while generating data for foreign table its NOT excluding rows where deleted flag id is referred.
For example, we have table in database named 'uCommerce_DefinitionField', whose data looks like
During data generation for this table tool excludes rows with 'DefinationFieldId' values 2, 4, 5 because 'Deleted' column value is 'True'.
But now when it generates data for 'uCommerce_CategoryProperty' table who refers 'DefinationFieldId', it does NOT exclude rows where 'DefinationFieldId' values are 2, 4, 5.
Because of this when tool imports data it fails.
Can you please suggest us how to handle such situation?
Data Sync issue: Does not sync data whose 'Deleted' flag is true in database
Hello,
We have installed same version of uCommerce Sync on 2 Umbraco + uCommerce installations. We are trying to sync uCommerce data from one site to other.
For that we choose 'Export' option which will export all data. We then copied files and tried to import data on another installation. In the import process we are facing issues.
When we looked into the issues, we found that: 'uCommerce Sync' is NOT generating XML for data for row in table whose 'Deleted' column value is 'True'. But while generating data for foreign table its NOT excluding rows where deleted flag id is referred.
For example, we have table in database named 'uCommerce_DefinitionField', whose data looks like
During data generation for this table tool excludes rows with 'DefinationFieldId' values 2, 4, 5 because 'Deleted' column value is 'True'.
But now when it generates data for 'uCommerce_CategoryProperty' table who refers 'DefinationFieldId', it does NOT exclude rows where 'DefinationFieldId' values are 2, 4, 5.
Because of this when tool imports data it fails.
Can you please suggest us how to handle such situation?
Thank you for your help!
Hey. I'm able to reproduce this problem now. I'll see about fixing it when I can find the time...
Until then you should be able to work around it by skipping the import of product categories.
-Kenn
Alright this has been a long time coming, sorry for the wait. It should be fixed in 0.6.0.3.
is working on a reply...