FM Easy Suite Framework

Hello, thanks to this forum I put succesfully the fm easy sync in my solution. All times went fine until I copy the solution in other iPads than mine. 😳 In first Ipad (whatever user goes in) all is succesfully (iPad pro 10,5, ios 11.3) but others (iPad 9,7, ios 11.3) "Unable to connect to the server". It is the same file copy in all iPads. Someone have an idea? Thank you in advance. EDIT: I DELETE THE FILEMAKER APP IN IPADS, REINSTALL ANDO NOW ALL OK

Hi everyone, I succesfully make the sync through easy sync. But with the next step I didnt found any info about the initial set up. How I set up in my solution the EasyDeploy method? Thank you in advance

Had to step away from this for a while, but now back with it. I have nailed up the two tables I want to sync, however, when try and sync, I get an error that reads Attempt to push data has failed (The message received from the server was : "201") I have two questions really. I don't need to push data, as no data will be allowed to be changed on the 'mobile' side, can I disable this, if this is what the issue is. What is a 201 error, and how can I identify which field is causing the issue?

Hi all, I've successfully deployed EasySync 1.3 and we're happy, but we'd be even happier if the sync were quicker. Since this deployment is strictly pulling a small data set and pushing a bunch of images, the suggestions elsewhere on this forum about using Javascript in a web viewer to do some processing don't apply, I'm pretty sure. By tweaking the "$$max_push_segment_size" client setting I was able to speed things up by ~25%, but my test data of 27 images still took ~9 minutes to upload. Does anyone have additional suggestions to speed things up? Thanks, Mike

I think there was some instructions somewhere, but I cannot find them . I have a created local file and server file. Both contain the exact same data. I want to deploy this solution, but I want to avoid a massive first-time sync. How can I avoid a massive first-time sync?

I see Tim has removed everything related to FM Easysync on his webpage I hope Easy Sync will continue to be developed as it would be a shame to trash somehting that good.

We are so close to going live with this system, but we've struck a brick wall and need advice. First some background: The original system was built several years ago and has 50+ tables. Only 31 of those need to be synced to the mobile version of the file, which will be loaded onto iPad's to take into the field. Of those 31 tables, only half contain data which will be modified in the mobile version. The resat are mainly resource tables. We managed to get the sync process working perfectly on copies of the main file, but it refuses to sync to the actual file. It's extremely frustrating because the copy it will sync to, is an exact backup copy of the database. But, w…

I just like to have your opinion regarding on the problem I have met in using EasySync. Problem: One Time Pull only Scenario: Sync FileMaker_Mobile in FileMaker_Server (Deployed in AWS) - 1st time successful sync Add or update records in FileMaker_Server Sync FileMaker_Mobile again, cannot get records in FileMaker_Server - Unsuccessful sync when pulling data Add records in FileMaker_Mobile, successful sync in FileMaker_Server - Successful sync when pushing data Then when I delete the FileMaker_Mobile and copy the original solution again, it syncs again properly, on the second time it wont retrieve records from the server. However if…

Hi EasySyncers! I'm having a bit of a brain freeze. Can someone please explain the purpose of $script_override to me? tia, Barbara

Hey again. In a previous thread I suggested using javascript in a webviewer to return the difference between the server and client UUID lists in order to increase the sync check speed. It was much faster, but the code I used included an algorithm with quadratic time complexity, meaning that as the size of the lists increased the time that sync check took would grow exponentially. @GisMo helped test confirm that this solution would not scale well. However I think I've found a bit of javascript that solves this issue and will scale linearly. I've changed the script from the previous thread to use this new code instead. If you are using this javascript method for list c…

Hi, I see that the system requirements state FM 13, but is anyone using it with a later version for instance FM14, 15 and perhaps even FM16? Regards Colin

Hi, Self confessed filemaker noob. Longtime programmer. After a few errors, I have a small custom single table solution running however modifications made on the server are not synced to mobile devices. I have triple checked everything and all seems to match the sample setup. I have successfully deployed the examples to our server and ipads. These work fine so I assume the problem exists with something *I* have done. I *know* I've done something wrong but would like some guidance as to where to focus my debug efforts. We are running on v15/windows Any help appreciated.

So I am new to EasySync, and trying to get the best from it. I am using it more to replicate a subset of a live database for external clients to access, but they will not be changing anything, so my only requirement is to pull data to my 'Mobile' dataset from my 'Hosted' dataset. At the moment the live database is approx. 120k records, but this grows daily between 100 and 300 records for the main customer view, and possible 3 times that for associated activity. I seem to have a serious speed issue, in that trying to sync the mobile version just locks everything up, trying to do an initial sync. I can manually pull the data over at the end of a day, the…

Hi I have a strange error when I try to sync from my iPad to my Server if I create a new record in a specific table 'Echanges' at the next sync I got this error... "Field ES_Echanges is missing. FileMaker Error Code 102..." The thing is ES_Echanges, is the name of the relationship in the easysync context, none of my fields are named close to that... I have triple checked my fields and the relationships - no clues Any idea ?

I've looked everywhere and I can't find the user name and password to login to the databases. The EasyDeploy doesn't ask for a user name and password, but everything is locked and grayed out. The Sample Databases (Host and mobile) both ask for a user name and password.

Greetings All I am looking to add a line into the following code into the 'prepare payload for client' section to select only records that match the following criteria I have a variable set called: $additional_settings The field that needs to match with $additional_settings is called _kf_uuid_companys the code that i have already is as follows, i need to add a line into this code to pick records where the field _kf_uuid_companys matches $additional Settings. Any help would be greatly appreciated: "SELECT " & $dyn_sql & ", '" & $$record_delimiter & "'" & " FROM \\"" & $sync_table & "\…

Hi everyone. I'm happy to announce that FMEasyWeb is finally available for beta testing. With EasyWeb, you can provide Web-based access to your FileMaker databases without needing to write code. It's a convenient way to quickly publish data to the Web and make it available to either the general public or to authorized users. And like many of my other FileMaker solutions, EasyWeb is being made available via an open source license. For more information about EasyWeb, or to download it, please visit: http://fmeasyweb.com Thanks! ~ Tim

Hi, has anybody ever tried setting up more at least two servers and using FM EasySync to keep the data synchronized on them? As far as I understand this would require some kind of separate sync worker machine to keep some kind of master DB. Regards Franz

Hello there, I've set up 2 files syncing with Easysync. I've set up just a single table in sync called ES_TRIP (without pull or push, because I want to sync in both directions, is that correct). I put the same cfg on mobile and on host file and the process start working but it throws me an error: "The attempt to push data to the server has failed. (The message received from the server was: "111A01C0-27AE-414B-AC1C-DC56C83F877E" The hosted file is on a fm server 15 that is reachable and working - I've tried the hosted link and it is correctly working. The TRIP child table is set to add record (but not delete) on both files. What should I check…

I'm trying in vein to incorporate google map directions into Tim Dietrich's EasyMaps, and have tried about a dozen or more methods, none of which seem to work. Basically, I work with a not-for-profit that buses minors home after some after school activities, that typically finish around 11pm. To make life easy for the bus driver, I'm hoping to be able to generate the map with directions, and then email it directly to the bus driver, who opens it up on his smart phone, and follows the directions. As I said, I've tried a number of methods, and none of them are working for me. Being a not for profit, spending on operations like Seedcode's ProMaps is out of the qu…

Hi, So I've been using Tim Deitrich's fmEasyMaps Beta embedded in my file for a while now, and it works fantastically, I'm currently mapping over 3000 addresses. But my inner perfectionist has gotten the better of me, and now I'm wondering weather it's possible to add in directions using waypoints. The idea is that I want to do a few drop offs to multiple addresses in a local area, for kids after participating in a school activity that finishes around midnight. I saw this announcement HERE about EasyMaps, but have been unable to get anywhere since I can't find any place where the new version was ever released. Since Tim is now no longer developing in File…

Hi guys, Not sure if any of you has had this issue before. I set up FM Easy Sync following the documentation and for the most part things work. Nonetheless, I'm getting a strange error when pulling the data set from the server (roughly 2600 records). Somehow data from "field 1" is getting imported into "field 2" (my table has 95 fields but a good portion are unstored fields I'm not trying to sync). I checked the relationships on both my host and mobile files and my server data and everything checks out. Any thoughts on what could be the cause for this? Thanks.

Somehow my current and last 7 backups are corrupted and unable to be recovered via FM. Ugh. What's the best way to rebuild the server database from the clients' data such that it's minimal impact to clients? Anyone have step-by-step instructions to reseed the database client data and make sure everything gets synced properly?

When I either change the names of the different accounts (admin, employees or employee) in the security and then click on the button to view the month view does not show all the weeks. I am looking to have a very simple calendar to allow employees to log in with individual logins and see everyones days off but no be able to edit them. Then have a setting to see everyone but just be able to edit their own. Thanks for any help. Gary

Our application just started giving Push Failed errors on sync from mobile devices. However, an older version was not failing on the same iPhone, leading me to think its not a server issue. The error text: "The attempt to push data to the server has failed. (The message received from the server was: "-2.1") In our application, though, we have no data to actually push - no one is allowed to update records on the mobile device. However, the sync process has to go through all its motions in order. I will start to troubleshoot (the NGS directory app), but if you had something I could check first that would be great. I don't think I changed anything on the sync…

Hi all, I have a hosted database with department, order and order_items tables which are synced to mobile devices. We have three departments, each department has a mobile device for order picking. Orders are always owned by exactly one of those departments, order_items are related to orders, orders are related to departments, nothing fancy. Due to time and my limited knowledge I started last year by syncing all records to all three devices and restrict the records the users can actually see. This makes the process slow, it's getting slower over time and confuses people when they see that records are being synced when they themselves did…

I was running some speed tests with EasySync recently and was surprised to see how long a sync took after I added a few images to the the sample record set that ships with EasySync. It was taking over 5 min. to download those records from FileMaker server which was installed on the same machine as FileMaker Pro. A competitor's product was doing the same sync in under 10 seconds. The interesting part was that all records in the sync took much longer to process, once the images were added. In other words, the fact that I added some images to record #1 made records #2-100 take exponentially longer to process. So, I did some digging and found that the entire payload was bein…

Hi, In order to use the ES_Exclude fonction, I need to send some value list to the server for the calculation. (I am filtering the customers according to 2 lists : department and job ). Is there anybody who can explain how to send these list to the server ? I think I can't use the $$additional_pull_info because the list items are separated with carriage return right ? Btw can we have a debug mode for the the server scripts ? thanks and have a good day ! Jonathan

Hi, Can you tell me how long is the step ""EasySync is go for launch..." on your solution ? When I try to sync with Joshua files (sync check improvement part 2), It looks very fast, but when I used exactly the same script on my solution I have to wait 20 seconds. Do you have any idea why ? Best regards

When I'm logged in as Admin only the first 2 rows of the month view are displayed (see screenshot). This issue started when I created a new user. The month view displays correctly when logged in with the new account. Does anyone have any pointers as to what may be causing this and how I can fix it? Thanks in advance (:

Hi, I have a db ~27Mb. Using EasyDeploy As Is takes very long to complete (~20 minutes). Each segment takes around 10 seconds and there can be anywhere 90 to 300+ depending on the $segment_size. I modified the EasyDeploy file by adding a table occurrence for the hosted file's EasyDeploy table and then replacing the script's loop with a simple Set Field that copies the B64 data from the host's field and decodes it locally into the container field. The new wait time is < 1 minute. Soooo... My question is why use this looped Get (ScripResult) method instead of simply grabbing the data through a relationship and then closing the EasyDeploy file when done? I…

Hey fellow syncers, stepping back from any method, I was wondering if there's an issue that all sync solutions have. The issue is this: Client A pushes a payload, and it's processed and ready for ClientB to receive...all nice and transactional. However, ClientB gathers records to pull a table at a time. Couldn't ClientB gather Orders - ClientA's processing completes - and ClientB gathers Order Line Items (thus, missing the parent record of some of those Order Lines since ClientB has already pulled Orders for his payload?). We're seeing this and wondering if it's a design flaw in EasySync or indicative of any sync solution that allow multiple users to sync a…

Hi. I noticed that when using EasyDeploy, the new file will not pull records the client pushed just before updating. This is because the client will not pull records that have the same ES_Device_ID despite their ES_UTC_TIME being greater than the last sync timestamp of the updated file (file stored in 'database_container' on server's EasyDeploy table). i.e. Client A has version 1 and new version is listed as 1.1. Client A pushes a record to server and then updates his file with EasyDeploy The new file opens and does not contain any of the records created by Client A after the last sync stamp of the updated file. Even after syncing again, Cli…

Hello, When I sync the demo file every thing is fine but when I try to launch the sync process on my personal base with the same connection I always get this message. Is there a setting which can be optimized ? Jonathan

Hello, I am new, and i am work fine with FMEasyMaps, i am show a lot of locations in my map, but i want to know if is posible to show my actual gps position? Thanks.

Hello, Sorry I am new with FMEasySync, I try to integrate this tools in my database but when I sync, it delete my records and don't send it to my hosted base. Then If I want to pull the records from the hosted base, nothing happen even if I reseted... I am working on that since severals hours. Any body can help ? Jo

I have two, of many tables, which simply do not sync with EasySync Each apparently for different reasons. All the other tables sync just fine. I have created a known working scaffold of the EasySync example to test the tables themselves. The problem occurs here also. FMEasySync v1.3 Test see attached Process: Add two tables to easy sync survey example "Form 3" and "Possible Means To Reduce Stream Sedimentation" Setup and instance of each table and relate to EasySync tables Set in mobile settings version to 1.2 to avoid easy deploy issues for now set EasySync Settings push debug to 1 so we can see what is going on. delete layouts have not been installed to isolate…

Hello, I am discovering FMEasysync and it looks wonderfull. I can make the demo files works from my computer but when I try to use it with my iPhone I got an error from server : 6. Anyone can help me please ?

If a user of a mobile device set the clock of his device wrongly, say year 2015 becomes 2014, and do a sync with EasySync, would it mess up data in the FMS13 server? If so, what would be the best strategy to avoid such incidence. In general, how can we synchronize the clock of the server and the mobile devices BEFORE a sync action is done by EasySync?

Hi there. Glad to get into FMEasyWeb and do some testing. Thanks Tim, for this contribution! Uploaded database and PHP files the servers (FMS and Webserver). However, I have renamed the including folder to 'FileMaker_PHP_Code'. Using link to web server as: http://<webserver_IP>/<path>/FileMaker_PHP_Code/index.php Question: In the settings.php file, what to enter at 'xxxxxxxxxxxxxx' (see below) and what format? I tried the FMServer ip address, but it did not work as expected. // --------------------------------------------------------------------------- // DATABASE-RELATED SETTINGS // ----------------------------------------------------------…

Hey Fellow Easy Sync-ers. I have an idea for improving the speed of the Sync Check step. Instead of comparing UUID lists in loops, we can retrieve a UUID list from server, and compare it to the client UUIDs using a couple lines of JavaScript in a webviewer. I've tested this and my Sync check time comparing ~23000 records, over 18 sync tables on a shared server has gone from 5-10 minutes down to a few seconds. No plugins necessary. Process: Get UUIDs_client. Get full UUIDs_host list from server Format both as JavaScript arrays and put them into a web viewer to be compared using 'filter' Have the webviewer call another script using FMP url…

When EasySync encounters an error it passes the error back, which is great. When there is a 102 error it tells us that a field is missing. But from which table? It would help to know where we should start to look. In the Server Side scripts at about line 295 in "Process Payload from Client" I've modified the value of the $LastError variable returned for an 102 error to this: "Field " & $field_name & " is missing from table " & $table_name & ". FileMaker Error Code 102." It provides the user with better information. The result of the error is something like this: Field BranchName is missing from table ES_Memberships. FileMaker Error Code…

Have been using easySync for a while, but recently I have a problem where Close File ["Hosted_Database"] does exactly that on OS X but leaves the server open on iOS. OS X: FM Pro 14 & 15 iOS: FMGo 14 & 15 Tired adding a Close File ["Hosted_Database"] in line 136 of "Sync With Server" at the beginning of #restore user interface but this just generates an error 301: which is record is already in use. But of course the error only occurs on FMGo. I must have done something simple to cause this but not sure what… any ideas are most welcome.

I have a solution that syncs at the end of a "shift". The shift report says what happened during the shift. But I want to add a time card component that syncs when anyone starts work and ends work which doesn't always match the "shift" that one or two guards are covering. So, I want to keep the main Sync with Server script intact for the end of shift report but I want to dupe it, rename it and hardcode it to sync one or maybe 2 tables only. Since there will be only 1 or 2 records it should be fast. That way the timecards are always up to date and the shift reports are sent as a whole. I'm going to try and edit line 4 of "Sync with Server" to look for a Table …

Is it bad to delete all the records in the EasySync_Payloads table? It's kind of building up.

I use EasySync for several different clients, all with nearly identical solutions hosted on FMS14. For one client, EasySync is taking longer and longer to sync, and I'm having trouble pinpointing the problem. When I first setup the mobile database and did the initial sync, it took 1-2 minutes. But now, it is taking at least 15min on the first sync, second sync (done immediately after the first) will take 30min+, and 3rd is an hour, and 4th is two hours. All of these sync's were done back to back at night when there is quite literally NO data changes happening on the mobile or server. Any ideas on what I should be looking for? Thanks, Ryan

Hi, Is there any way in EasyAudit of knowing that if a user modified/deleted a record or a script ran on server? Regards,

Good day all, On commit log, the UUIDs variable get value of "?" and therefore it pulls "?" in filed name, field value and table name and the EasyAudit table. It is working on the sample file of Easy Audit and also on a test file I made but when i run it on an existing file, it does pull "?". Any thoughts? Regards, Siroos

I tried to incorporate just the FM easy calendar Beta 2. I went through the instructions and the trouble shooting guide. I have a table:Appointment, and Field:lastname, Field: Firstname, Field:Name(calculation). I checked the trouble shooting guide and Im still getting (?)s. Any help is appreciated. Thank You!!

Hi all, Does any one know where do I find setup documentation for FM EasyAudit? it seems that it is not available on Github any more. Regards,

Hi all, On hosted file, date fields show "?" in them after syncing. It is not font or field small to show the text, it is a pure "?" in the field. Any help would be highly appreciated. Thanks.

Good day all, I checked this : But I did not get my answer yet. I have 2 different tables on my iPad file. The first one pushes only to server, the second one push/pull to/from server. What I need to do is to limit the second table to only pull relevant records from server to iPad based on the account name used for logging in on ipad. So if I log in on iPAd, then I should be able to only see my records pulled from server and not others records. My question is how do I modify "WHERE" clause on the script step that sets $dyn_sql to include this filtering criteria based on account name? Unfortunately I know nothing about SQL …

Hi All, On occasion, not all of the records are being pulled down to the client upon a sync. The only way I'm able to remedy this is to go to the hosted file and "jiggle" the records that weren't pulled(usually by a date range) which will cause the update time to change and then re-sync the clients. This is terribly inefficient. I'm having trouble debugging this issue. Is there a way I can force a pull of records? For Example, modifying ES Last Pull Time to an earlier date? to get it to re-pull records in ....Upon checking the Push and Pull scripts, it looks like it uses the Last Pull Time to determine what records to PUSH and Last Push Time to determine what …

The instructions say the easiest way to add the 5 ES_fields to each table is to simply copy and paste from the Demo database. I realized tonight that in one Table, "Surveys", the ES_Recod_UUID has the AutoEnter set to "Do not replace existing value of field if any" checked. But the other 2 tables, Survey_Hobbies and Survey_Documents do not have it checked. This is in both the Hosted and Mobile files. Which is correct? The instructions just mention unchecking it on US_UTC_Time. Dan

Hi, First I'd like to thank the developers of FM Easy Sync for sharing this great and usefull solution free of charge ! I have successfully set up FM easysync to sync with tables set to both Push/Pull Two tables in my solution, I only want to push from the mobile solution to the hosted DB (to avoid pulling non relevant data to the specific user) As stated in the instructions, I set the prefix on the two tables to ES_PUSH in both the mobile and the hosted DB. It seems this does not make any difference as all the data in the two tables are being both pulled and pushed. Does anyone have an idea if I have missed anything. Maybe I need to update …

Dialog Displayed: “The Pull request has failed. No Payload was received from the server.” All tables are push ( labeled ES_Push_tablename ) there is no pull tables or other tables… In "Pull Payload" if the result of "Prepare Payload For Client" is empty then it is assumed to be an error and an alert box is displayed. In this case where there is no payload to pull from the host to the client empty is just fine, unless I have missed a check for pull or sync tables somewhere.... In "Prepare Payload For Client" "Get all the tables to be synced" it seems that the SQL statement should come back empty ( $sync_tables ) if there are only PUSH tables and yet... we do not …

Hi all, I am getting this error message on a file which has no ES_PULL table. Any thought? " The Pull request has failed. No Payload was received from the server. " Thanks,

I've just been thinking about how we can better collaborate on making changes and updates to FMEasySync. Dan Smith's forked copy seems like the starting place: https://github.com/dansmith65/FileMaker-EasySync This is great, but filemaker doesn't lend itself well to code-sharing/github. Someone would have to make the change and adjust the entire file versus updating a script and using a pull request to merge the new script. One thought I had was to break out all of the separate scripts in the mobile and hosted file on git hub into text. That way we can see and talk about the changes and look directly at the scripts. together. This become more transparent this wa…

I'm having some difficulty tracking down this issue. The whole setup was working correctly, then I seeded the mobile database with the hosted database data(exact duplicate of the data). Then I made a change to one record and deleted another using the easy sync delete function and tested the sync.. Now I received the error message: "The sync check's call to the server has failed". I've enabled Sync Check debug and disable PSOS for sync check, but I am still having trouble getting this to work correctly. I can't actually debug/step through the Sync Check script in the Hosted_Database and it seems to run endlessly on the Sync Check script when running locally. At the Per…

Hi anyone has step by step instructions to install the easysync been looking around however i see http://timdietrich.me/ doesn`t have it anymore. anyone used it and had good experience with it , would love to hear.

Hi all, All of a sudden, I receive this error "Unable to connect to server." on all iPads. I did check all other posts about it and could not figure it out. Any Idea please? Regards,

I integrated easy deploy to my files and receiving this error when I try to upgrade my iPad file. After I run the "Sync with server" script, it closes my current iPad file and open the "EasyDeploy" database letting me to upgrade. But when I push the upgrade button, I receive this error: "Process Halted An error accured during the segment pull. Filemaker Error Code 401" Any Ideas? Your time and advise is highly appreciated. Regards, Siroos.

Hello again! my databases have been operating very well for the past two months! I do have a question now, is it possible to only sync down data that matches a certain criterion? The situation is this, I have 10 stores testing out this database and I want my master server to accept data from all of them but only sync back down their data (in the event that I send them a new file, or they get a new ipad), i've attached a diagram of sorts. I have three ipads at one location that i have setup doing a full sync to a server, and i have the other locations that dont sync at all, but now when i am wanting to update their database, I have no way of getting their data,…

Hi everyone. Just a quick note that, after 4 months of being in beta, I'm now working on the first official release of FM EasyMaps. The next version, which I'm hoping to release in early March, will add support for directions, waypoints (routing), and language localization. Details are here: http://timdietrich.me/blog/fm-easymaps-version-1-announcement/ I want to thank everyone who has been using the EasyMaps and providing me with feedback, suggestions, and feature requests. - Tim

I've had to disable the native delete records sync because it takes WAY too long to do the DIFF with large tables. I've been looking at other ways to try to sync the delete and would like to table an idea that I have. The process would be something like this: Each table would get a flagField called "delete". Initial value=0 or empty When a record is deleted on the client by the user, the flag field gets marked for deletion(value=1). Maybe with some UI logic, we can hide these flagged records User1 Sync with server push the flagged for deletion records to the server. After the Sync is complete, the User1 client runs a script to actua…

I've had pretty good success using FMEasySync with pushing. I've got multiple users in the field pushing in records everyday. No problem. The issue I have is that there are some inspection records that everyone needs to get back to their Mobile. Each user is doing a monthly inspection. They need to have the record from the previous inspection to calculate how many "cycles" have occurred since the last inspection. It's never the same person going back. The issue I have had is that when Pushing from the server not everyone gets the necessary records. It seems like only those to created the original records get them back. Or one user will get the record and anyone after tha…

Good day all. Happy new year and I hope you had lovely festive season. I receive attached error message from easysync script. I don't have a table called "ES_surveys" table neither in host file or ipad file. I do appreciate your time and help. Warm regards Siroos Jafary

Hi everyone, I just checked the Server log file after running Easy Sync. The sync seems to work fine however there is an error in the server log "Prepare Payload for client - admin 37" Scripterror (3) "Prepare Payload for Client : Show Custom Dialog" I guess since the script is running from server, it does not support "Show Custom Dialog". I'm just afraid the message could be an important error message I miss due to this. I have not altered the Payload script in any way so it must be an error in the original code. Any ideas ? Thanks Jens

I am getting an error on push to the server "The attempt to push data to the server has failed (The message received from the server was 504)" Error 504 is: Value in field is not unique as required in validation entry options The only field in the server data base that requires uniqueness is my ID. This is an auto enter UUID. There is also the ES_Record_UUID field, but this seems to not be set to require uniqueness by default.

I am conducting an initial test of FM easy sync. I am working on a system that I have in production with synchronization logic that I scripted myself (to iPads from FM Server). The sync to the iPads using my logic is rather ponderous, so I am researching alternates to speed things up. I carefully applied the changes described in the FMEasySync setup document to my server file & the client file. I cleared all data from the client file - anticipating it would then do a full synchronization from the server to the client. The primary table has over 150,000 records, so I did not expect it to be quick, but I am puzzled at what happened. It seemed to run witho…

I have set up and had sync working with one file on my server, however I have now changed the hosted file, set everything up the same and am getting an error of Unable to connect to server. Could this be a security issue with the second file. Filemaker go and my desktop can both connect and open both files with no issue. I hope someone can help me with this, many thanks in advance.

Can't seem to get any records to sync.. i get a "?" on the bug report layout. Any idea why this shows and what it means? Thanks

Hi, I'm loving EasySync, and props to Tim for making it so...easy. However, I'm experiencing a container issue: I have a solution that uses both OS X and iOS clients syncing to Server. I want the mac and server to use external storage but FM Go requires embedded storage (please correct me if I'm wrong). When I try to sync the FM Go file (using embedded storage) with the server (using external open storage), the containers on server display only the filename. When I then sync the mac, only the filename appears in the mac containers as well. Notes: I am unable to export the container contents from the server or the mac and GetContainerAttribute reveals the file ha…

The containers are filled with images. Then there are also some records where there is a html text doc in the container. which might have caused havoc to the es record uuid fields following. Some contain html like div tags. I am almost certain that i did not overwrite the uuid fields by hand. What could have brought this about? Also. should i abstain from storing text-like html in containers? Any comment would be much appreciated.

Ok why is the sync routine creating new copies of the record i am syncing every time a change is made on mobile. ie I can end up with 4 copies of same record if 4 changes and syncs occur. Not what I am expecting. I thought it would just update the current record so only 1 copy exists on the host. Also if I have ID field set to unique it doesnt create a new record and it doesnt update current it just throws a 504error

If you're looking up GPS co-ordinates for addresses with not much detail ( e.g only containing city, county), then google will actually send a few co-ordinates as part of the api response. FM Easy Maps by default always grabs the first pair, which can often be far from accurate. I've tweaked the script steps to be more accurate in these situations, whilst still working the same way on 'full' addresses: For Latitude: Let ( [ $API_Result = Evaluate ( "EasyMaps::EM_Global" ); $loctype = If ( PatternCount ( $API_Result ; "\"location_type\" : \"APPROXIMATE\"," ) ; 3 ; 1 ) ; $Start = Position ( $API_Result ; "\"lat\" : " ; 1 ; 1*$loctype ) + Length…

Having trouble getting the fmGetContrainerURL to work correctly, my current error message is: Notice: Undefined offset: 1 in /.../.../.../container-get-url.php on line 132. I looked at the container-get-url.php file and see were the [1] value is set but don't know what to do about it. I have been a long time working with FM, and very short time with php. My DB only has one container and it will always be on a single record when it is accessed. My file is hosted on Server 14 and the container is stored externally with FM Secure Storage. Any help is greatly appreciated. Thanks, Paul

Hello to all, First of all, thanks to Tim for his brilliant work. I wonder if we can force the syncing script to sync only those records which are added to the mobile file, after the last successful sync. Those records which are synced once, should not be pushed to the hosted file, even if they are removed from the hosted file already. Perhaps, we can add a on option to put them back in the syncing list, in case needed to be synced again. Any thoughts? My aim is too keep the data on mobile file for 7 days after they are pushed to the hosted file, and thereafter, they supposed to be removed automatically to prevent having a big mobile file on Ipad. Warmest regards, …

Hello, I am a new FileMaker user/developer although I am not new to database and client development in general. I have FM Pro Adv 14 and Server 14 along with FM Go 14. My intention is to develop some databases to manage our work here in Papua New Guinea and offline app use and sync'ing is a must. I have wired up EasySync/EasyDeploy with the Contacts starter solution to give it a try. When deploying a 7.7MB database with EasyDeploy it is at 75K segments and counting. It is also taking a long time to transfer. Is there a way to increase the segment size and speed up the transfer. If not, is there a recommended file size to stay under to keep the deployment transfers quick…

Can anyone point me in the direction of documentation on how to set up and use FMEasyWeb, please? Apart from setup help, I also need to know if it can embed javascript and link this to a filemaker database. I am doing this using FMStudio at present but am finding it very slow progress. Many thanks, George

We've taken the free FileMaker starter solutions and added FM Easy Sync. You can find them here: http://www.neocodesoftware.com/about-us/starter-sync-solutions/

What's the best way(or correct way) to pre-load the Hosted and Mobile Databases with the same data so that way the first sync will only add the new records from the mobile devices?

receiving a 101 error on pulled payoad (which is a missing record). if i run under full access account no problems but accounts that are not full access get this error any thoughts.

I have a vertical market application that uses a php modale that gives mobile users access to their agenda (FM11). Currently I am rewriting this application from fp7 to fmp12. As part of this upgrade I want to offer mobile users an off-line module on iPads. Mainly because mobile users complain that they do not always have a good internet connection when on the road, so the performance is not always acceptable. I have implemented FM EAsySync in my application on a test server and on a small scale this looks good (Tim awesome job in setting up this framework). However, on this forum I noticed some comments about the processing time of synced records, so I am wondering if …

I've started getting a error message while processing the pull payload - 101: record is missing. Browsing old threads I've seen some issues with typos in the TOs. Double checked all of those details and still no luck. Any other troubleshooting thoughts would be appreciated! Thanks!

Ok, Slowly but surely, I am working through issues with easysync. I have just a few questions though. 1. when i can get it to sync it sends back changes on a mobile device and duplicates a record in the host. i.e. i end up with 2 copies of a record 1 without the change(the original that was synced to the device and an updated copy (one that was synced from the device). Am I misunderstanding the way this should work? I assume that itwould makechangesto thecurrent record as it needed so therfore therewould beonly 1 copy of the record reflected in either host or device. 2. I have trouble with getting sync to work when you are not the administrator with full access priv. I …

Can anyone give me an idea of where to look to troubleshoot? Everything is working flawlessly for pulling data to the mobile device - new records, modifications, etc, however, it is not pushing back to the hosted database. No errors are reported. I am using my computer for the hosted database, and an iPad (also tried with my laptop) for the mobile database. I am sure I have a typo or other error somewhere, but having some direction of where to look would be appreciated. Thank you in advance.

So, after heaps of frustration I am almost there. However the one sticking point I am getting is the return of data to the host creates a duplicate record with the updated data. I suppose the question is Is that the way this is supposed to work? I would have thought there would have been just an update to the existing table data to reflect the changes. Now I have checked to make sure that the ES_Record_UUID is not empty and no both hosted and remote (read mobile) version have identical IDs ie one on mobile being child record UUID. So my next question is what could possibly be the answer to this. I have re invented the whole db. and started from scratch and same result so …

Hello all, Bit of a problem here. We have a app working and syncing for some time now. My coworkers don't have data connecton during the day but sample data and when they get in the office use wifi to connect and synchronise. Everybody happy until a few days ago when it stopped syncing. I can see we have still connection to the server on filemaker server. I can log on to the solution from my filemaker pro desktop and that seems all right. On the filemaker server one cpu gets locked up at 100% and the logfile shows activity in the 'send payload segment to client' script: see illustration. There seems to be a loop where connection and database continuously are opened and…

Everything seems to be syncing properly in both directions with the exception of changes that are made to fields in the hobby portal. If I add new records to this portal they sync properly but if I make a changes on my Desktop client the iPad ignores it. If I make changes on the iPad they do not transfer to the hosted file. I am running FileMaker 14 on everything. Is there a fix for this problem?

I have finally nutted out all aspects of FMeasysync and it is working well under full access from mobile device. However if i change to a restricted access privilege set it doesnt want to work. (At least I am thinking that it is the access issue that is causing the problem as if I changeback to full access it works!) It throws a Push failed -2.1. if restricted access. I have read the other post on the forum and as per Tims instructions i have checked scripts for the correct references and all seems ok. Am i on the right track with my theory in that could this be a possible cause? Any ideas or suggestions or feedback would be greatly appreciated as this is the last …

I am Having trouble sorting out an error - Pull Error - An error occurred when attempting to process the pulled payload (errorcode 103). I know filemaker 103 error is relationship is missing but from what i can see both the mobile and host are set up as they should be in that there does not appear (at least to me) any relationship error and all table occurrences are identical in each database. Any ideas would be helpful right at this point as I just dont get it.

To start off this is by far an awesome addition to the PHP side of Filemaker. I have been so frustrated with Filemaker's own PHP Api and how little information there is available. This has given me almost everything I need to build a larger system with Filemaker as the main db access and the PHP to support the users who really don't need anything but some data stored on the system. I am using version 13e of FMWebFrame I have installed the demo application and after fighting with the settings here and there I have a working demo system. I think an easier approach is to build set framework locations (similar to CodeIgniter/Cake PHP and just have the end user put all of th…

FM Maps is a great tool, and first of all I have to thank Tim for his great work and specially to share it with all of us. I have successfully installed the map into my database but I am not able to figure out why I get the coordinates with no "coma" when I run in that mode. Coordinates are completely ok but they have just lost the comma so the value is not working. For now I have to fix it manually as the place of the coma changes and I suspect this may have to do with the language and number setup of the database so that when the script is returning the number it is adapting it to the numeric setup of the field of my database which causes it to lose the comma. This is…

I have just attempted my first integration and it went great. Everything is working except a strange visual problem. In month view only the record that is selected (one week) shows the fields as formatted in the inspector. Any of the beginning and end dates that run to the previous and next months have conditional formatting and they always display properly. I have checked all the formatting for all states on the "Dx_Text" fields and everything is properly setup. I have also made sure that in the body section both use active state and alternatre rows are off. I copied it straight from the example file and have gone back and forth and everything looks the same. I have post…

I am syncing data from 10 tables from host to an iPad The tables range from 20 felds up to 190 fields I have denormalised these tables so that they contain and absolute minim of calculation fields and have removed indexing from those fields that do not need it The collection of the data to load onto iPad is quick but it then takes several hours to process approx 5k records received as a payload ! I have potential datasets which could reach 15k-20k of records in total ! The iPad(s) are remote and cannot be preloaded as they manage data for tours and the tours change which means that the user has to wipe the device and then go and get the new tours which have been acti…

Please be gentle and explain in simple terms, I've only been using Filemaker for 2 months. I'm running Filemaker Pro Advanced 14 and Server 14. I have a relatively large (128 mb) database that I'm trying to deploy. I have the hosted and mobile database the same. It steps into Push Payload and it starts running through my tables and field but then hangs and shuts down the whole program. I get a sync error : "Server did not receive payload segment 1." The debugger states 513: No validation was specified but data cannot fit into the field. I have increased both max push and pull segment size to 999999, and the ping time to 999999 also. I'm not a developer so I'm at a lost …

I don't know why, but every - Single - time i try to import a 3rd party database option into filemaker, it just doesn't work. I have a large Table with over 1000 items, all the fields are set, there's even a relationship set between EasyCal and the current table, but when ever I try to run the script it complains that 1) there is a record missing, and 2) it leaves the event field blank. I even imported the "Contacts" table from the demo database file and it STILL doesn't do anything. . What do I have to rename so that it stops Skipping the entire events entry section? I have a Data::Item field that is being used for event description but it just creates multiple blank ro…

Is it possible to sort the contents of the calendar. By That I mean by start time. I know you can enter a variable start time but what does that exactly do to the calendar. I have tried to find out where it works but I don't see it. (Hope this makes sense) as far as I can see it just defaults to the last entry as the top of the list.

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…