SeedCode Support Forum

Hi,

I've been using GoZync for a couple of days now and seem to be (slowly) getting my head around it!

I've been tasked with creating an offline sync solution for a customers existing Filemaker db, so far I've successfully managed to "zync" from the host to the mobile but not the other way around. I've checked all the parameters and scripts (I followed the GoZync integration guide) and it all appears to be in order, but as I'm new to this I could be missing something glaringly obvious!

Any help or advice would be much appreciated.

Regards,

James

Hi James. Are you saying you can pull but you can't push? Make sure the ID field in your mobile file has been populated (not empty). If that's not it, send more details and I'll try to think of other ideas. -Jeff

Hi Jeff,

Yes that's it exactly, the pull works great but the push fails to update the host database. I've checked the ID fields are populated, but it probably is something simple that I'm missing! I don't get any errors and I've attached the Zync log info below.

6/20/2014 9:14:17 AM - Started

Split Total
---------------------------------------------------------
0:00:00 - 0:00:00 - Connecting to server...
0:00:02 - 0:00:02 - Getting settings from Host...

---------------------------------------------------------
0:00:00 - 0:00:02 - STARTING PROPERTY MANAGEMENT SHEET ROUND TRIP

0:00:00 - 0:00:02 - Starting Push
0:00:00 - 0:00:02 - Starting to Push "gzm_Property Management Sheet"
0:00:00 - 0:00:02 - FLM is OFF
0:00:00 - 0:00:02 - Found 0 records to push
0:00:00 - 0:00:02 - Done Pushing "gzm_Property Management Sheet"

0:00:00 - 0:00:02 - Push Complete

0:00:00 - 0:00:02 - Starting Pull
0:00:00 - 0:00:02 - Starting to Pull "gzh_Property Management Sheet"
0:00:00 - 0:00:02 - Last Time Zync: "6/19/2014 5:24:26 PM"
0:00:00 - 0:00:02 - FLM is OFF
0:00:00 - 0:00:02 - Starting TO Filter - "gzh_Property Management Sheet"
0:00:00 - 0:00:02 - Found 27 Records in the filter
0:00:00 - 0:00:02 - Looking for record to Delete
0:00:00 - 0:00:02 - No records to delete in "gzm_Property Management Sheet"
0:00:00 - 0:00:02 - Deletion Complete
0:00:00 - 0:00:02 - Constraining filter records by last time zync
0:00:00 - 0:00:02 - Found 0 records that have changed since last zync
0:00:00 - 0:00:02 - Done Pulling "gzh_Property Management Sheet"

0:00:00 - 0:00:02 - Pull Complete

0:00:00 - 0:00:02 - ENDING PROPERTY MANAGEMENT SHEET ROUND TRIP
---------------------------------------------------------


0:00:00 - 0:00:02 - All Done

Hi Jeff,

Had a bit of a breakthrough, I've discovered that if I hit 'reset' on the mobile dashboard before I zync, then the push/pull works perfectly. If I try to zync without resetting it then only the pull works.

Any idea what might be the cause of this?

Thanks,

James

Nice troubleshooting, James. "Reset" makes the database think it's never been synced by wiping out the last sync time. SO... if push only works after hitting reset it's because GoZync doesn't think the mobile records have been modified. Maybe they haven't? I'd check two things...

- Compare the fields you added to your tables with those in our example files and make sure they match exactly. These are the gz_ fields.

- If you're syncing related records, read this: http://www.seedcode.com/pmwiki/pmwiki.p ... RecordMods

Let us know what you find!

- John

Hi John,

I thought I was getting somewhere but got a bit ahead of myself and now i'm getting problems everywhere! If you can bear with me I'll break down what I need to achieve and hopefully you can advise.

I have a property database created in Filemaker 12, made up of several smaller db's which provides data such as tenant details, landlord details etc. However, the only details I want to sync are the property address and the inventory of that property, so that the customer can visit the location, complete the inventory on an iPad, then sync to the main database when they're back at the office.

The inventory fields are held in a separate Filemaker 12 db to the property address details - would this need to be set up as a relationship field in GoZync?

You'll have to forgive my lack of knowledge in this area, I'm still very much a novice but getting a GoZync solution up and running is currently my top priority as the intention is to roll GoZync out to a lot of our customers.

Many thanks,

James

Sounds like you might want to "flatten" your data when syncing to the mobile device. You could create calculated fields in your hosted file for things like the landlord's phone number to get those value from the related record, then just pull that field into corresponding local text fields in the mobile file. If there are multiple related inventory records, you could do something similar with a calculation field in the hosted file using the "List(related_table::field)" function, then sync that to a text field in the mobile file. Here's more info about how to do custom transformations like these: http://www.seedcode.com/pmwiki/pmwiki.p ... eldMapping

That's great, I'll give that a try, thanks Jeff.