FM Easy Suite Framework

Hello, I know this topic has been discussed. I read the whole of that topic and my issue still not resolved. I downloaded the latest fmeasysync file. I have enabled the networking sharing on the hosted file. I have add the following external sources to the mobile file: fmnet:/*/FM_Surveys_Hosted filewin:/C:/EasySync/FM_Surveys_Hosted I can see the hosted file from the ipad, i can even open it and use it. I have not made any changes at all to the demo files. I am simply trying to get the demo working. Can someone please help me with this. I have been battling with this for hours now. Thanks.

Hi All, I'm new to EasySync and just started looking at syncing a simple one table database with two container fields before I move onto some of the more complicated databases i'm looking to use EasySync for. For these container fields i've created the two B64 calculation fields as requested in the setup documentation. The sync itself has completed successfully however when looking at the container fields I can see an encoded string returned rather than the data found in the container field I was expecting (These container fields are capturing a photo from an IOS device and a signature). I can see in the troubleshooting that this can be caused by the compress opt…

Hi Tim and others, Does anybody have experience with a situations where EasySync is going crazy because of some Table occurrences changes AND RESETS? I'm mean, while testing I added some table occurrences, try to hook up more tables to sync. I broke the EasySync function. I tried to get back to the old situation but things got worse by the minute. A lot of 201 and 106 error for apparently no reason. I have seen Filemaker doing that before with ExcecuteSQL. I than had to replace occurences to have this fixed... but today seems a bad day and noting helps :-(... Yes I did do a Wipe and reset and di clean the sync dates Hope to here from you Jeroen

Let me start with a question. Do either or both the hosted and mobile databases have to be on a server, FMS13? I ask because I have made all the modifications as set out in the documentation to both my hosted and mobile databases and tried syncing both locally and when both are on the server. I have also checked the path to the hosted version on the mobile. Whatever I do I always get, when I try to sync, 'Unable to connect to server' Any suggestions would be gratefully received Many thanks Tony

I just started working with Easy Sync this weekend. I'm using it for tracking locations of tools with iPods and IPhones. The idea is that changes to tool locations are entered and then when have access to servers sync back. It is a database with about 826 records. Following is the test I ran: 1. In Mobile file - made a change to a field on a single record 2. In Hosted file - using a different computer made a change to field on a different record from the one in the mobile file. After the sync: 1. In Mobile file - have a new record that is a duplicate ES_Record_UUID of the record changed in the hosted file. 2. In Hosted file - …

I originally developed EasySync for use in projects that I was working on for my clients, and found that it was very easy to implement. It provided a good mix of simplicity and flexibility, and gave me a way to provide a reliable and affordable sync solution to clients. Its flexibility meant that I could easily modify it to meet my various clients' business rules and needs. When I released EasySync as an open source solution back in May, I did so with the hope that the FileMaker community would find it to be of value. From what many developers have told me, they've found it easy to integrate EasySync into their solutions. For most, EasySync "just works" right out of the…

Hi Tim, I have been looking at EasySync from day one and I'm happy ;-) I think it's a great job. I had implemented my own similar sync but yours I way more charming. What I need though and wonder how to this could be done best is the following: - In have a server file from which 'Collectors' with their iPad pull about 700 personal (name=collector) records weekly; - Records that are ready to pull have a status "iPad" which sets your 'exclude' to 0, others 1; - During the days of the week, Collectors update the records while on the road (locally - no wifi); - At the end of the day Collectors sync back the records they have updated as soon as they have wifi; Tim, whats…

I've implemented this in an existing solution and it works great; thanks. However one of our clients do not have FileMaker Server. Apart from the performance hit does EasySync work without FM Server? If so is it as easy as changing the 'Perform Script on Server' steps to regular 'Perform Script' steps? Thanks, James

After my first sync, I now have duplicate records in all synced tables. Question: in the setup guidelines, it says to update all records so there is data in the ES_Record_UUID field using Get(UUID). It also says to do this on the mobile database setup... should the mobile database have different UUID's in this field than the hosted database? Seems to me that these should line up so the sync knows which record to work with, otherwise it's going to think the record was newly added and create a new one (hence all the dupes). I'm wondering if it would have been better to setup the hosted database first, then pull down a copy for offline and set that one up following…

Tim, I am experiencing very long file open times for the hosted file - up to 5 minutes over UK 3G. After this the actual sync works fine in a sensible time. Any thoughts.... Thanks Paul Jansen

this query should select from the table only the records of the group set by the variable $PrivGroup, the query work fine without the red part, please were i am wrong? Var $dyn_sql : -------------------------------- "SELECT " & $dyn_sql & ", '" & $$record_delimiter & "'" & " FROM "" & $sync_table & """ & " WHERE " & " ( ES_PrivGroup = "" & $Privgroup & "" ) " & " AND ( COALESCE ( ES_Exclude, 0 ) = 0 ) ) " & If ( ( $$sync_method = "Merge" ) and ( $last_pull_utc > 0 ); "AND ( ES_UTC_Time > " & $last_pull_utc & " ) " & "AND ( COALESCE ( ES_Device_ID, 'X' ) <> '" &am…

Hi Tim, We currently have separation on both server (desktop administrative UI and DATA) and IOS (IPad users UI and DATA). I am seeking the best combination of files and I was wondering if you've had a chance to test various configurations for stability or speed? Fewer files will be simpler to administer of course but if there is an issue during the sync, I would rather corrupt the sync file instead of the data file. I have not heard of any crashes with EasySync but we've had iPad files crash during imports so I want to be especially gentle with the iPad data file ( with least amount of interaction). Do you think EasySync should be in its own file and versionin…

Hi Tim and the rest of the team, at first I also want to thank you for making EasySync available to the community! I have a problem since the last friday with the synchronisation. After I ran a succesfull and complete synchronisation without any trouble, i changed the names of my tables to "ES_PUSH_Tablename". Now i have the problem, that only the last added record of a table-dataset synchronizes. For example, i have a table "CAR" witch has a relationship with a "CAR_error"-table. If i add a new car with more than one failure and push this records to the server, i will only see the last added failure of the "CAR_error"-table. The same problem occurs, if I add more t…

I am considering using your solution, but one of the questions in my mind is what will be involved in implementing the new version once it is released? Will it require going through the initial setup stages again with the new files? Thank you!

First off, thanks for making this available to the community! I am in the "wow, what a great resource - how can I get it to work in my solution" stage of testing. I have a project that requires my users to have access to data on their mobile devices for read-only purposes (they are not editing the data, only viewing it). The data changes from time to time so I want the mobile device to "pull" the data from the hosted file but not push any changes back to the hosted file. I have followed the instructions to set up EasySync and have been able to get the process to complete successfully when I use "ES_TableName" in the relationship graph. When I set up my t…

Won't set field by name. Looks like the field names have been set by your script to be "first_Name[1]" - The bracketing makes the field not readable. Thanks, CJ Watson

Just started looking at the EasySync mechanism and am familiarising myself with the FM_Survey files using the Mobile file on my desktop with the Hosted file on FM Server I modified a piece of information in the mobile file, clicked on the sync button and it successfully pushed the change to the hosted file I then modified a piece of information in the Hosted file and then ran the sync from the Mobile file but the data did not get pulled to the Mobile For clarity: FM_Survey_Hosted is hosted on FM Server FM_Survey_Mobile is stand alone on my desktop I made both sets of changes to the data from my MacBook opening 'Mobile' from the desktop and 'Hosted' from …

I have just started to configure a hosted database and have added EasySync fields to 2 tables A and B that are related on the Relationship Graph through appropriate ID fields. As there are data in both tables I have updated the records in both tables using the 'Replace Field Contents' following the instructions in EasySync Documentation. The values of the ES_Record_UUID field are identical in both tables. The same is true for the ES_UTC_Time fields Is this expected? Is it significant? If so what can I do about it? Many thanks for any advice

Hi, Just a little feedback on the documentation for the EasySync Demo which I tried out. In The ReadMe says: However after setting the External Data Sources as per paragraph 1 above, the two remote scripts (Perform Script on Server) worked with no help from me. The Documentation page says, In my case testing the Demo files, both of the lines mentioned were fine as is (after I set the external data source). I did notice that these scripts got messed up if I logged into the mobile version with a new account that I added that was not in the hosted version. :-) Doug

Tim, Thanks for the great free solution to sync filemaker and filemaker go. I have for the moment a problem with syncing repeating fields. Only the first repetition field is synced Kind regards Patrick

FM EasySync, After fixing some of the other issues I ran into, I am now meeting error "-2.1" when trying to "sync with server". This happens during the push function, and while I've tried enabling debugging on certain scripts, it always happens right after the segment creation on the client side to send to the server. SOME of the records get sent to SOME of the tables, but not all. The full message is as follows: The attempt to push data to the server has failed. (The message received from the server was "-2.1") Any help would be appreciated!

First, thank you Tim for EasySync! I am a beginner/intermediate developer and I was able to set it up in a matter of minutes on my solution. I have a question about using EasySync with the data separation model. I have a solution with two files (App.fmp12 and Data.fmp12). With EasySync, this would in effect leave me with four files: App Hosted.fmp12, App Mobile.fmp12, Data Hosted.fmp12, Data Mobile.fmp12). Are there any special considerations in setting up EasySync? Or can I simply configure EasySync on the data files (i.e. Data Mobile and Data Hosted? Thanks, Matt.

Tim, I am still waiting (after 10 minutes on a wired DSL connection for a synccheck to process ) The issue is that I have a dozen records on the mobile device and over 200,000 on the Server! Obviously this is going to be a serious performance hit! Do you have any bright ideas? Thanks Paul Jansen

A quick note that EasySync v1.2 is now available. This version adds support for using "additional info" in the Sync Check phase, a few bug fixes, and minor changes to the UI. You can download EasySync v1.2 here: http://fmeasysync.com/download/ Thanks! -- Tim

Just a quick note: EasySync v1.1 is now available. It includes a few performance enhancements (one of which reduces the memory used by FileMaker Go during syncing by about 50%) and minor bug fixes. You can download EasySync v1.1 here: http://fmeasysync.com/download/ Thanks! -- Tim

The first "official" version of EasySync is now available: http://fmeasysync.com Thanks to everyone who helped during the beta! -- Tim

Hi everyone. Just a quick note that EasySync Beta 10 is now available. Beta 10 introduces a new method for handling deleted records. It also includes "EasyDeploy," an open source deployment solution that integrates nicely with EasySync to help make deploying upgrades to your mobile users easier. For details, please visit: http://fmeasysync.com/beta/ -- Tim

Hi everyone. I didn't think that there would be another beta release, but here goes: Beta 9 is now available: http://fmeasysync.com There is only one change in this release, but it is significant. We've introduced a "Device ID" to the fields that EasySync uses to sync tables. As a result, we can now eliminate the need to "round trip" records during the sync process. This means that records that are pushed to the server do not need to be included in the "pulled" payload that follows. It also fully resolves issues encountered by users who sync from multiple devices. Thanks. -- Tim

Having been involved with beta testing for a while and having had the opportunity to dig into the code, I wanted to express my gratitude to Tim his huge effort in developing EasySync to this point. I love the fact that it's so easy to implement even to a existing database solution and the fact that it is 'open source' is fantastic. For a good number of scenarios, I expect the release version 1.0 the be pretty much ready for use in a production environment. It is also a great foundation for developers to tailor to their own requirements. I am convinced that EastSync has the potential to get sync to a much wider audience and I am very excited at the prospect. I …