Leo Di Croce

Hi Tim, It works! Thank you for the advice. The $$additional_sync_check_info did the trick. You made my weekend! Thanks again, =L=

***UPDATE*** The problem appears to be Sync Check, which deletes the User record. I stepped through the sync process again (this time more fervently) using the unstored dynamic calculation for ES_Exclude. All appeared to be OK... until Sync Check. During the pull process, everything was cool. I checked and confirmed that the User record was created on the Mobile file. (Yay!) But then Sync Check deleted the record. (Boo!) When the Sync Check script compared Mobile with Hosted UUIDs, the $diff showed one UUID (approx line 60), representing the one User record that the pull process created on the Mobile file. Then the Sync Check script proceeded to delete the User record. How can I stop this from happening? Strange that there is no $diff when the calculation is "hardcoded". Thanks, =L=

Thank you. Unfortunately, the changes you suggested for the Set Variable $dyn_sql (reference your line 10) result in "?" later, when script step evaluates the ExecuteSQL statement (reference $temp_recs in Prepare Payload for Client script).

Hi Tim, Yes, ES_Exclude is an unstored calculation. =L=

Hi, I've spent several hours trying to debug this one. At first I thought it was because I was running the hosted and local files on the same machine. But the problem persists even after having moved the hosted file to another machine. The Goal: Exclude User records — that don’t match the “System” User ID — from being pulled. Background: The local file contains a System table and a User table. The System table has a User ID global field. The User table has a User ID key field. The hosted file also contains a User table with a User ID key field. What works: Hardcoded calculation for ES_Exclude on hosted file. For example, ES_Exclude = not ( User::ID_User = “C659FBEF-1C4F-49A5-9551-923F7D96A71B” ) What doesn’t work: Dynamic calculation for ES_Exclude on hosted file. For example, ES_Exclude = not ( ID_User = $$client_UserID ) The setup: 1. EasySync Settings on local file - sets variable equal to User ID. That is, EasySync Settings script step (approx line 32): Set Variable $$additional_pull_info = System::ID_User. 2. Prepare Payload for Client on hosted file - sets global variable for User ID. That is, Prepare Payload for Client script step ADDED after (approx line 25): Set Variable $additional_settings = GetValue ( Get ( ScriptParameter ); 12 ) Set Variable $$client_UserID = $additional_settings 3. ES_Exclude field in hosted User table changed to calculation: not ( ID_User = $$client_UserID ) The result: No records are pulled using dynamic calculation for ES_Exclude. Expected result: One record pulled matching $$client_UserID . Any suggestions are much appreciated. Thanks, =L=

Brilliant! Your suggestions worked. I tried them both, "Reset" and "Wipe". New record appeared after doing so. Very Cool. Thanks Tim, =L=

Hi Tim, I'm still having difficulty with Easy Deploy... After the new version of the Mobile opens, I don't see any new records on the Mobile file. The Hosted file has them, but they don't sync. You had suggested at the recent SOFA Meetup to sync again. I tried this but the Mobile records don't change. I assembled a series of screenshots to illustrate the point... Please link to my DropBox. Thanks, =L=

Records should be synced before the Mobile file is updated, right? Otherwise, data from the current Mobile file would be lost. Plus, the records should be synced again, after the update, because the new version inside the EasyDeploy container doesn't necessarily have all the data. I tested the sample files, including EasyDeploy, which contained a new version of the Mobile file. Unfortunately, modifications to the current Mobile file were lost during sync, I think because the Mobile file was replaced before it could sync with the host. Can you confirm please if I'm on the right track here... The sequence for sync should be: 1. Sync with host. 2. Replace current Mobile file if update is available. 3. Sync with host again if Mobile file was just updated. Thanks, =L=

Hi Jonathan, Thank you posting this. I think it's exactly what I'm looking for, but I'm having trouble implementing. The function returns 0, and the containers fail to "export". I'm trying to write two container fields to a server's temporary folder. The variable that defines the folder: $PATHfolder = /private/var/folders/g6/3h4y328x1q5gc59q4hr_4xjr0000gn/T/tempKMZ_9A1902/ The variables that define the file paths: $PATHxml = /private/var/folders/g6/3h4y328x1q5gc59q4hr_4xjr0000gn/T/tempKMZ_9A1902/sample.xml $PATHpng = /private/var/folders/g6/3h4y328x1q5gc59q4hr_4xjr0000gn/T/tempKMZ_9A1902/19-tag.png Does that look right? Or could it be an error in my ScriptMaster module? I pasted your code, downloaded Apache Commons IO, and added five jars: commons-io-2.4-javadoc.jar commons-io-2.4-sources.jar commons-io-2.4-test-sources.jar commons-io-2.4-tests.jar commons-io-2.4.jar Not sure how to attach a screenshot, but it would show five Commons-Io selected in the Jars tab of the "Edit Script" layout. Thanks again for the module. Any further help is greatly appreciated. =L= _____ Leo Di Croce Feb 19, 2014 - Found a solution here.