pfry

OK it is my fault 😂 I upload an sync offline file on the HUB, and I just forgot to delete the mirrorsync records before. This is why the sync results was so strange.

I just make a try with a sync layout with only three fields : Primary key / Creation timestamp / Modification timestamp I am still having the same issue, the Modification timestamp change during the sync process.

Hello, I have the same issue : I have a single modification timestamp field on my sync layout but the sync process change the modification timestamp ... Any idea ?

I also try to add a "static" field with auto enter field based on : If ($$Sync = "On", Sefl, modification date) But I failed to success.

Thanks for you reply. Sorry but I don’t know how I can do that. If I create a script triggered from the timestamp modification to input a static field, it will create a loop ? Do you have any suggestion ?

Hi Ocean thanks for you answer. If the field is not on the sync layout, it will not be pushed to the server ? I am working on a multi-user database, and am looking for modification date and modification user. Any idea ?

Hello, Is it possible to keep the user modification date for the record ? For example when Mirrorsync insert a record, the modification date is the sync date not the real user modification date. Thanks

Thanks Tsiry, I just saw your message and I find my mistake during the sync process.

Hello, I am evaluating mirror sync for my company and have some questions about the script personalization. I created some rules for syncing successfully, but my problem is that if I need to change the rules it does no work and I need to make another initial sync from a new file which is very long in my situation. Is there a way to initialize the rules ? Is there a way to create some personalize rules for pull up and push up ? Now if I clearly understand, the personalization sync will ever push up to the server but only pull up according to our rules ? thanks in advance !

Hi Joshua, When do your recommandation the "EasySync Settings Client" close the script after the line : #If there are no UUIDs in the sync tables... So I don't achieve the Server Sync Check Process Any idea ?

Hi Joshua, I think I am missing something, I run the pull script in debug mode, without PSOS, and the ES_Exclude calculation looks ok but all my records are deleted ... Here are the client and hosted files, can you tell me what is wrong ? Jonathan FM_Surveys_Mobile_jMod3.fmp12 FM_Surveys_Hosted_jMod1.fmp12

Hi Joshua, I think I don't really understand the way to use this exclude fonction. I thought that the exclude process was during the “Prepare Payload for Client" because of this : "#Add this table's fields to the SELECT statement. #Note: This is the SELECT statement that is used to select the data for the payload. #You can add your own custom business rules here to determine what data is sent to the user, by looking at things like the table name being worked on, the user / device that has requested the data, etc. Dynamically add your conditions to the WHERE clause." So I use the $$additional_pull_info, then edit the “Prepare Payload for Client" script to get back my value list in a global variable to do the ES_Exclude calculation. But I must admit that I have some strange results... Now I understand that you are talking about the "Process Payload From Client" script, and I was surprised because I thought this script was not include in the exclude process. Can you please confirm which scripts are used for this exclude fonction and need the $$additional_settings ? I also have another little question : if a user make a mistake and delete a record. This record will not be pulled after that if the ES_Device_ID was this user_device. Is there any way to prevent about that ? Thanks a lot

Thanks a lot Joshua. Your support to integrate fm easy sync is really appreciated !

Ok I replace the carrier return by another symbol and it works perfectly. Thanks !

Excuse me Joshua, I am not sure to understand what you mean about the end tag "</setting>". For example I saw that the the exclude action was done in the "Prepare Payload for Client" script. I can see that the parameter script is : Evaluation ( "EasySync_Payloads::ES_Last_Pull_UTC_Time" ) & ¶ & Evaluation ( "EasySync_Payloads::ES_Last_Push_UTC_Time" ) & ¶ & Obtenir ( IDPersistant ) & ¶ & $$client_version & ¶ & Substituer ( Obtenir ( AdresseIPSystème ); ¶; ", " ) & ¶ & Substituer ( Obtenir ( AdresseNICSystème ); ¶; ", " ) & ¶ & Obtenir ( PlateformeSystème ) & ¶ & Obtenir ( VersionSystème ) & ¶ & Obtenir ( Appareil ) & ¶ & Obtenir ( ProtocoleRéseau ) & ¶ & Obtenir ( TypeRéseau ) & ¶ & $$additional_pull_info What am I supposed to input in the $$additional_pull_info ? 1st list & "</setting>" & 2d List & "</setting>" ?