Suzie2

Hi, I have been testing with Easy Sync for sometime and everything so far seems to be working great! However I have been noticing that at times when I modify or update records on the Hosted File and then sync at the Mobile File - It does not seem to update the change at the Mobile File side. However all changes at the mobile side do go up to the hosted file. I usually test the sync just a few seconds after updating the records at the hosted file. To test whether this was a timestamp issue I tested again after maybe 5 minutes at the mobile side doing a sync and it then it actually updated the mobile side record with the hosted record changes. But I found out that if I synced within the first 1 minute of the change at the hosted side - the updates did not happen at the mobile file and nor did the updates ever sync down to the mobile file. I confirmed that all the settings are as per easy sync - have been testing easy sync for 2 months now - so have no doubt that the settings are as per the setup instructions. So I am wondering why updating records at the Hosted file side does not always sync down to the mobile or iPad file? Are there any extra settings that I'm missing? All my table relationships, scripts etc on both hosted and mobile are correct. And no errors at all. Also I do have the same mobile file sometimes on more than 1 iPad - so in such a scenario would correct updates syncing be compromised? Please help. Thanks

I am also trying to achieve the same thing where I want to filter down records depending on which device id is calling the sync. I want to use the prepare payload for client script - or the exclude. I am trying to filter records from the hosted file to client file while syncing based on which client device id is syncing. So I am trying to do this in the prepare payload for client script in the Hosted File database.I This is where I need to add my business rule, but am not sure how to manipulate the dyn sql variable there to include this business rule. I would like to check if the sync table is a particular table and if a particular client device is doing this sync and if that particular sync table has a field set to some value then that record should be pulled down. Otherwise not. Please advise on how I would achieve this....

Hi I am trying to filter records from the hosted file to client file while syncing based on which client device id is syncing. So I am trying to do this in the prepare payload for client script in the Hosted File database. This is where I need to add my business rule, but am not sure how to manipulate the dyn sql variable there to include this business rule. I would like to check if the sync table is a particular table and if a particular client device is doing this sync and if that particular sync table has a field set to some value then that record should be pulled down. Otherwise not. How exactly would I go about doing this? I have not seen any example manipulating dyn sql on this forum... and I need this for my conditional down syncing ......

Hi I am having an issue where I did a preload on the mobile database by importing all the records from the hosted database to the mobile database (about 5000 records) and made sure the record uuids on all the hosted as well as mobile database were the same so that it would not sync again. I also changed the es_lastpushtime and es_lastpulltime on the mobile easysyncpayloads table to a time greater than the import time. However after I tried to do a sync again on the mobile - it's taking a very long time and is stuck on the pushing payload to server status. I think it is overriding the the last pull/push time - Im not sure but think so. Could you please let me know exactly how to preload data to the mobile file. I seem to have done all that is mentioned on this link ... http://fmeasysync.co...c-integration/) but its not working. Also on the mobile easysyncpayloads table I added a record and then set that records last pull/push time to a greater time. I hope that is the correct way of doing it, please let me know if not.

Hi I am having a similar issue where I did a preload on the mobile database by importing all the records from the hosted database to the mobile database (about 5000 records) and made sure the record uuids on all the hosted as well as mobile database were the same so that it would not sync again. I also changed the es_lastpushtime and es_lastpulltime on the mobile easysyncpayloads table to a time greater than the import time. However after I tried to do a sync again on the mobile - it's taking a very long time and is stuck on the pushing payload to server status. I think it is overriding the the last pull/push time - Im not sure but think so. Could you please let me know exactly how to preload data to the mobile file. I seem to have done all that is mentioned on this link ... http://fmeasysync.com/docs-easysync-integration/) but its not working. Also on the mobile easysyncpayloads table I added a record and then set that records last pull/push time to a greater time. I hope that is the correct way of doing it, please let me know if not.

I downloaded the easy sync beta 8 version which has an example of an initial pull script, but am not sure exactly how to implement this initial pull script in my solution i.e where to place these scripts etc. I had already implemented the 1.2 easysync version and it was working but the initial sync was taking too long on the iPad, I had almost 7000 records, and it was taking 3 seconds per record for the initial sync so decided to download the beta 8 version but am not sure on how exactly to implement this in my solution. Any help appreciated.

Solved it.

Hi Its the process payload from client script in the easysync server folder of scripts, there in the "is the payload well formed" segment - thats where the -3 error originates, in my case a file link was missing in that area when I copied over the scripts from the easysynchosted file scripts ( To get the correct file missing you can check the easysynchosted file process payload script again to see if you copied all the lines properly over) - which gave that error ... but thats where you can look for code not well formed.

Hi I would like to know where to find the time of last successful sync for a particular table, I currently am not getting a value from the ES_Payloads table the ES_Last_Succesful_Sync field ... Thanks

Thank you so much, yes it was the "Process Payload from Client" script, there was a file link missing in that script. Works great now!

Hi I'm new to easysync and was able to pull data but now pushing data to the server is giving me error messages. I'm getting a "the attempt to push data to the server has failed- the message received from the server was -3" message. Does anybody know what this error means?