Question About Deletions

Help, Tips, and Tricks for deploying GoZync: our "sync" engine for FileMaker Go.
Posts: 41
Joined: Mon Nov 11, 2013 11:12 am
PostPosted: Fri Feb 28, 2014 7:57 am
I'm syncing three tables: Clients -> Categories -> Questions. I bring down the full set of records in an initial sync. (4 clients, 41 categories, 432 questions) and there are cascading deletes set between the tables in my mobile file.

When I do a subsequent Clients pull, it finds the 4 records (Show All) and recognizes that none have changed. There have also not been any changes to the categories and questions. BUT it's deleting the 41 categories and 432 questions during the Clients pull. See the line in the log entry below.

At what part of the process would GoZync delete those records even though there have been no changes? I feel like I must have a setting wrong. Any assistance appreciated!

Thanks!
Jason


0:00:00 - 0:00:13 - STARTING CLIENTS PULL


0:00:00 - 0:00:13 - Starting Pull
0:00:00 - 0:00:13 - Starting to Pull "gzh_Clients"
0:00:00 - 0:00:13 - Last Time Zync: "2/28/2014 10:32:04 AM"
0:00:00 - 0:00:13 - FLM is OFF
0:00:00 - 0:00:13 - Starting TO Filter - "gzh_Clients"
0:00:00 - 0:00:13 - Found 4 Records in the filter
0:00:00 - 0:00:13 - Looking for record to Delete
0:00:00 - 0:00:13 - No records to delete in "gzm_Clients"
0:00:00 - 0:00:13 - Deleting 41 records from "gzm_Categories"
0:00:01 - 0:00:14 - Deletion Complete
0:00:00 - 0:00:14 - Constraining filter records by last time zync
0:00:00 - 0:00:14 - Found 0 records that have changed since last zync
0:00:00 - 0:00:14 - Done Pulling "gzh_Clients"

0:00:00 - 0:00:14 - Pull Complete

0:00:00 - 0:00:14 - ENDING CLIENTS PULL
SeedCode Staff
SeedCode Staff
Posts: 475
Joined: Wed Jan 02, 2013 11:47 am
PostPosted: Fri Feb 28, 2014 10:14 am
Hi Jason. GoZync deletes any records on the mobile device that don't "belong" to that user, i.e., records that don't match the filter criteria you have set up for those tables in the "Filter Records To Sync" script in GoZyncMobile. Read about how GZ handles deletes and how to work with filtering on these two pages:

http://www.seedcode.com/pmwiki/pmwiki.p ... c4.Deletes
http://www.seedcode.com/pmwiki/pmwiki.p ... gFoundSets

HTH... Jeff
Posts: 41
Joined: Mon Nov 11, 2013 11:12 am
PostPosted: Tue Mar 04, 2014 7:01 am
Thanks, Jeff. In this case these three tables are not specific to the user. I do have other tables in the solution that are user specific, but these three contain information that all users need to access so the find is set to "show all".

I'm working around this by no longer setting the Categories table as a child of Clients, but it seems like it shouldn't have been deleting the Categories/Questions if no changes were made to the Clients.
SeedCode Staff
SeedCode Staff
Posts: 475
Joined: Wed Jan 02, 2013 11:47 am
PostPosted: Tue Mar 04, 2014 7:30 am
I'm not sure why those records would have been getting deleted, but I may be misunderstanding your setup. If you'd like for me to take a look at your files send them to [email protected]
Posts: 41
Joined: Mon Nov 11, 2013 11:12 am
PostPosted: Tue Mar 04, 2014 7:41 am
Thanks for the offer. I'm working around it right now so I think I'm ok for the time being. I won't really gain any value by having Categories be a child of Clients so I'll let it go. Bigger fish to fry right now :)

Jason

Return to GoZync

Who is online

Users browsing this forum: No registered users and 3 guests

cron
(855) SEEDCODE
[email protected]
Follow us: