Second sync deletes records from one TO...

Help, Tips, and Tricks for deploying GoZync: our "sync" engine for FileMaker Go.
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Wed Oct 16, 2013 8:16 am
Hi,
I'm using the "Zync It - Public API - ( TOName ) { Action ; RecordID }" script to sync TOs using the following script parameter:

"TOName = Address¶AlarmCo¶Arc¶Employees¶Incidents¶JoinPeopleSite¶KeyDetails¶KeyHolding¶KeyHubs¶KeySeals¶MobilePatrols¶People¶Police¶Site¶StaticGuarding¶VoidPropertyInspections ; Action = Pull"

This works perfectly with a 'cloned' Mobile file and a 'Reset' gzMobile. However, if I run the sync again, all records in the "Incidents" TO are deleted.

Looking through the zync log, the section for Incidents is identical to all the others except it states Deleting 4494 records from gzm_Incidents"

Any suggestions on how to stop this from happening?

Thanks
Brian.
SeedCode Staff
SeedCode Staff
Posts: 475
Joined: Wed Jan 02, 2013 11:47 am
PostPosted: Wed Oct 16, 2013 9:37 am
There's either something wrong with how one of the "Incidents" TOs is configured on the Relationships Graph in GoZyncMobile, or you have some special filtering set up in the "Filter Records to Zync" script, or possibly the primary key field in the Incidents table in the hosted file isn't correctly populated for existing records. Double-check those things and if you still have trouble, send me your files and I'll have a look. Send them to [email protected] and include any full-access passwords I'll need.
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Wed Oct 16, 2013 10:45 am
Thanks Jeff, I've checked the first two suggestions and they look ok to me. I also had a quick look at your third suggestion but am unsure of what I'm supposed to be looking for.

The files and password are on their way across to you...

Brian.
SeedCode Staff
SeedCode Staff
Posts: 475
Joined: Wed Jan 02, 2013 11:47 am
PostPosted: Thu Oct 17, 2013 10:55 am
Thanks for sending your files. I think I found your problem. The "gzm_Incidents" branch in your GTRR script is using the wrong relationship (see screen shot). Fix that and try synching again.
Attachments
Screen Shot 2013-10-17 at 12.53.09 PM.png
Screen Shot 2013-10-17 at 12.53.09 PM.png (103.06 KiB) Viewed 7006 times
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Thu Oct 17, 2013 12:32 pm
Excellent, many thanks Jeff...

Return to GoZync

Who is online

Users browsing this forum: No registered users and 4 guests

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