FM Easy Suite Framework
Open Source Framework: EasySync, EasyAudit, EasyWeb, WebFrame, EasyCalendar, EasyMaps
The original developer that released fmEasySync and the other "Easy" products is no longer involved in the FileMaker community. His business has changed, so there is no active development on it, except the few forks on GitHub that other developers have picked up. But even those do really have any active changes to them recently.
The original developer released them not as a supported product like GoZync, MirrorSync, etc. They were merely "Open Source" tools that you could build on and use.
Subforums
-
Discussions using PHP in relation to the SmartPill plug-in by Scodigo.
- 80 posts
229 topics in this forum
-
Round Tripping from beta 8 2014 http://www.timdietrich.me/blog/easysync-beta-8-released/ (One possible solution - and perhaps something you'll see in a future version of EasySync - is to add an additional EasySync field that will track the specific device that last updated a record.) Has this been done or are we still round tripping as noted in the link above? I have two versions of client: 1. Data Entry Only 2. View Data Only When they are run on the same iPad and data is entered with Data Entry Only and Sync'd all is well. When View Data Only is used on another iPad the data sync's nicely. But, When View Data Only is used on the same iPad the record previously …
-
- 0 replies
- 1k views
-
-
Hello, I just uploaded "FM_Survey_Hosted_v1r3.fmp12" on my new FM 14 server and installed mobile version on ipad as well. Tested & everything works great but I'm getting warning Event 661 on the server every time I connect to my remote server from Filemaker Pro 14 Advanced. Client "..." authentication failed on database "FM_Survey_Hosted_v1r3.fmp12" using "...[fmapp] Security settings for clients on the server: Filemaker accounts only and I didn't configure Directory Server Please advise.k Best regards, Vlad
-
- 2 replies
- 2.2k views
-
-
I have a solution where users in the field add records in FM Go on their iPhones. That data is then synced to the server. No data needs to go back to the mobile device. I followed the instructions and named the TO's with the prefix ES_PUSH_ on both tables in both the hosted and mobile files. However, when I run it, it transfers all of the data on the server down to the mobile device. Is there something I've missed? Why is it pulling data when it should only push it? Marc
-
- 0 replies
- 951 views
-
-
Hi there, I just got everything working on easyMaps within my solutions......or so I thought. I originally had the map displaying 2 related sites for the same company. Once I had this working correctly, I added a new company with a related site and ran the ShowMap parameter from this record. The problem I am having is that the 2 sites I originally entered are still showing in the map layout. I can't figure out how to make the new site come up on the map instead. Any ideas as to what I have done wrong?
-
- 0 replies
- 1.4k views
-
-
Hi there, I am using EasyMaps and trying to integrate into my own solution. I am loving it so far, however, I have run into issues when trying to create infoWindow on Marker Click. I had it working within maps as a standalone setup in my database before I integrated EasyMaps but now i can only load a blank screen. Here is my code. I know it's flawed, I just don't know where lol. "<!DOCTYPE html>¶ <html>¶ <head>¶ <meta name=\"viewport\" content=\"initial-scale=1.0, user-scalable=no\">¶ <meta charset=\"utf-8\">¶ <title>FMEasyMaps " & Get ( CurrentTimestamp ) & "</title>¶ <style>¶ html, body, #map-canvas {¶ height: …
-
- 1 reply
- 2k views
-
-
I have a requirement for three different database access mechanisms. A Collection db for field use which collects and sends data to the server but does sync from the server to the mobile. A Viewer db which syncs all data from the server but cannot change or delete records A Management db which can both read, write and delete records and syncs both ways. Ideally this would be a single db with different login ID, but… I looked at the business rules section of FMSync and it seems to deal only with pull. So based on login, I could use it to block pull of all data for Collection db, or I though perhaps use appropriate privilege sets to differentiat the three types of access,…
-
- 1 reply
- 1.3k views
-
-
Just wondering about compatibility of EasySync and EasyDeploy with Filemaker Pro, Go and Server 14 ?
-
- 0 replies
- 2k views
-
-
I am new to EasySync and am developing my first solution with it and so far it is working great. Thank you Tim Dietrich! So far I have a simple form with records ADDed on the Mobile side with a simple PUSH on rows from three tables. Like I imagine most developers, I began my EasySync project by duplicating my solution and renaming the files for Host/Mobile versions. Also like I imagine most developers I have a set of Auto-Enter fields that I include in every table for things like Creation Timestamp, Modification Timestamp, Account Name, Username, etc. I can see how this MIGHT be an issue on the Host side with a conflict between EasySync trying to write to those…
-
- 1 reply
- 1.1k views
-
-
EasySync: Any Way To Sync Found Set? GZync does this is there a way to do this within FM Easy Sync? Perhaps I am missing the obvious. "Folks use this to deliver just one user’s records–usually very specific things like “my customer visits for today” or “my active orders in this territory”.… To control which records are pulled down to your iPads and iPhones: GoZync will look within the results of a find request for records that have changed since the last sync. If you can write a find request, you can sync that found set down to your users." In the application I am working on it would be useful to just pull data for a specific region, since a full sync of the database m…
-
- 2 replies
- 2k views
-
-
Hi Tim, I was wondering why you seemed to have backed away from deleting the EasyDeploy file once it has been used, and instead set a flag "consumed?" Did you feel that the "Export Empty to delete a file technique" was not reliable? Also, at the top of the Upgrade Solution script in the EasyDeploy file, you have an Installer OnTimer Script [Interval: 0] script step. That might be a left over from attempts at a 1-click update, because I do not see any previous OnTimer sets. Can you confirm? Thanks, Barbara
-
- 0 replies
- 1.3k views
-
-
Hi all, after successfully implementing ES in a solution on a MAC I seriously struggle getting the same success on a Windows 7/FM13 machine. In EasyDeploy/Upgrade Solution, the scriptstep "PSOS [Return Requested Deployment Segment]" returns a 3 ALTHOUGH it works perfectly on a Mac. The called script on the Server works fine itself… I was thinking of a "$segment_size" being too large (and Win 7 not being able to handle that amount of text) and set the value to 10.000 but to no avail. I also checked the FireWall etc. but it doesn't seem that there's anything running. QUESTION: 1) Might this be a Windows 7 related problem? 2) Has anyone experienced the same (and has…
-
- 3 replies
- 1.1k views
-
-
I've noticed in my Filemaker Server logs the following 'information' crops up every time a remote user triggers a sync... Schedule "Prepare Payload for Client - east 799" scripting error (3) at "sgfhlp : Prepare Payload for Client : Show Custom Dialog" Why does this keep showing? Should I be concerned about this and can I (should I) make some change or other to prevent these messages from continually popping up in the logs?
-
- 1 reply
- 1.8k views
-
-
Whilst syncing appears to have been working well within the solution I built, I have a situation whereby a number of records weren't pushed to the host from the remote client: Changes made on day 1 - sync appeared to run OK, host data updated Changes made on day 2 - sync appeared to run OK, data on host not updated Changes made on day 3 - sync appeared to run OK, host data updated I have no idea why the sync on day 2 would appear to have worked fine yet on later inspection of the data it transpires that record updates were not actually pushed to the host... I realise the remote client can run the 'reset' script and then sync but am I not right in thinking th…
-
- 0 replies
- 1.1k views
-
-
FM EasyMaps (Beta1) works great on the demo file. However, after trying to integrate into my test solution, I get this error message in the web viewer: Error encountered when retrieving address information. The SQL used was: SELECT "Latitude", "Longitude", "Icon", "Info", "Address_Tooltip" FROM "TA_1010_Checklist_Jobs_MS" WHERE ( "Latitude" IS NOT NULL ) AND ( "Longitude" IS NOT NULL ) AND ( ( "T_001_JOBS::_MS_UUID_JOB" IN ( A83497B2-7B3A-413D-B10F-75293814F3BA, AD64ED2E-93A1-4404-B900-4D7BECF6CE84, 140CEEC1-EF74-4448-9446-3799E2807CAE, 5FB18315-8E23-4E6B-96BD-BD094A4CCB3D, 423052C2-F607-4C68-9C7F-105D4F149B1C, DC70DFA2-FC56-48A5-A4DB-461683B01358 ) ) ) Any hel…
-
- 2 replies
- 1.7k views
-
-
I'm trying to find the exact settings for these in both the mobile and hosted files. The demo files seem to be slightly inconsistent. Also, As far as I can tell from the documentation, ONLY UTC_time should be Replace and all other fields(below) should be checked Can someone definitively tell me which, Replace or Do Not Replace Existing Value for each of the fields below. Thank you. Hosted File: Record_UUID UTC_Time Device_ID Mobile File: Record_UUID UTC_Time Device_ID
-
- 0 replies
- 1.3k views
-
-
We've experienced some issues with corrupted documents in container fields which were included in the sync process. This affects PDF's and JPG's. This hasn't affected every record as far as we can tell. The files were inserted into the container fields in the main database on the server with external (Open) storage. They were transferred to the mobile device via a sync and were not modified on the mobile device, so should not have synced back to the main database. The corruption is in both the server and mobile files. I did read in another thread about an incompatiubility with the Compress option in the insert file dialog, but this seems unlikely as the end users aren…
-
- 0 replies
- 1.3k views
-
-
Can't find anything definitive on this, but should indexing be disabled for ALL Easy Sync Fields? My intuition says yes,disable indexing, but I want to know the ramifications of them being indexed.
-
- 0 replies
- 1.2k views
-
-
Firstly, I'm new here so 'hi' everyone and thanks Tim for your EasySync solution... it looks like it will save me hours of head scratching! I appeared to have successfully integrated EasySync into my current project – I was delighted when everything looked like it functioned as expected and I was able to do a remote first-time sync and pull everything from the Server into my (blank) Client file, however I think I need a bit of help... The solution I'm working on has ~1500 records in the parent 'contact' table, with an equivalent number of child records ('data' table) plus there is also a 'photos' table which will potentially contain multiple related records altho…
-
- 5 replies
- 2.2k views
-
-
Hi All, Just attempting my first integration of FMEasySync and have hit a bit of snag. It occurs when the mobile file is attempting to push data to the server. Anyone seen this error code? I went through the Troubleshooting section on FMEasySync but see no reference to it. Thanks. Doug
-
- 2 replies
- 1.5k views
-
-
Please forgive me if this is a stupid question but I woke up in the middle of the night thinking about it... (sad I know, but this project is stressing me out!) If I give mobile users the ability to create new records, will these be added to the host on sync..? I was worried that because EasySync identifies records using a Get (UUID) auto-enter calculation that there was a possibility that this field could end up having non-unique values if the records were generated on different devices... However, my rational head this morning says it looks like since the ES_Record_UUID field auto-enter calculation is set to Do not replace existing value then it will work... h…
-
-
- 9 replies
- 2.2k views
-
-
Hi I tested the EasySync demo files on my FM Server and iPad and the time taken to download the 106 pre-installed records is a mere 10 seconds which is great. I then moved on to a full integration into my FM solution, a Patient Management System for Aesthetic Clinics. There are 60 tables ranging in size from 10 fields up to 874 fields although the majority fall below 150 fields per table. Approx 50 tables require sync capability. Once I had completed the EasySync integration I set the sync into motion having added a single Patient record in my Patient table. The sync took a staggering 33 minutes. To try and identify why the sync was taking so long I delet…
-
- 7 replies
- 3.3k views
-
-
I have started to look how the sync proces works. I have uploaded the hosted file to de FM server, and a mobile version. I'm working with the demo file from the site. First sync was working as expected, i added a new tabel to the file to see how this was working. So i copyd al the ES fields that are needed to the new tabel Made a connection to the payload relation The New tabel has no relation to the other tabels. Sync is not happening for the records i but in the hosted file, or visa versa. What do i miss here ?
-
- 2 replies
- 1.4k views
-
-
Hi, Folks. I almost has this a couple of hours ago...actually was getting the sync from one table. After I "fixed" what O thought the problem was, I am getting a new error. After I click the Synch with Server button, the host file closes and the message pops up: "The attempt to push data to the server has failed. (The message received from the server was: 504)" I'll continue to fiddle with it -- any thoughts would be welcome. Thank you, Covita
-
-
- 7 replies
- 3.1k views
-
-
Hi Tim, Congratulations on fmeasysync - it's a wonderful thing that you and others have shared in this way. I'd just started experimenting and had a little hiccup; at this stage I don't know if it's an fmes thing, or it's related to server issues. I was setting up the fields etc on a file that is hosted (FMS 13). The file includes an Images table with around 13k images. (All quite small, kb-wise) When I first entered the Base64 calc field, it took quite a while to process - obvious in retrospect but since I'd been following the instructions to the letter, I didn't think ahead. That's not the real problem tho'. Thereafter, I attempted to insert an image. …
-
- 3 replies
- 1.5k views
-
-
I have a solution where all work is done in off-line mode. The users make changes and sync them up to the server. Other users sync to pull down those changes. It seems to be working nicely on all devices but one. That computer is not showing the changes after the sync. No error messages are displayed. Any ideas on what I could be looking for?
-
- 0 replies
- 1.2k views
-
-
I have a table for images, it is set to push from the client. I want to make a script that will let me send a select statement to the host that will get the related images for a record and pull just those records to the client. Can you point me in the right direction to create this? I want to make sure that I do not reinvent the wheel if there is already a hook somewhere to do this. Also if you can think of any things to look out for such as preventing the regular sync process from deleting records that I have pulled?
-
- 3 replies
- 1.9k views
-
-
I have a solution with twenty tables, most of them with small record sets, up to a few hundred. One table has 4000 records and one has 60000 records. I'm able to set up the sync process for all the smaller record sets, including the 4000 records. Everything is OK. I can make changes to a few records and Sync takes about 20 seconds. As soon as I add the large table to the process things fail. I've read previous posts. I have populated all the ES_ fields and then duplicated the file, to ensure that records are matching UUIDs and timestamps. I have used the reset script to update the global fields on the mobile side. Without making any changes the sync…
-
- 4 replies
- 1.7k views
-
-
If I were to sync my client on my desktop and use that file with all the records as my deployed file is there anything I need to do to that file first or will all the clients just pick up the new records from there with no conflicts?
-
- 0 replies
- 1.3k views
-
-
Hi all, second post here. I heard about EasySync for the first time on Monday, decided to give it a go as I am struggling with sync for months now. My endusers carry devices but are often not able to call into the office, not to mention they can't reach the central server. I had to search for a bit as pull worked right away but push didn't do a lot. Using the debugger and the data viewer revealed much of how the scripts work but I couldn't find the problem, I decided to call for help here and composed a document describing in detail what worked, what didn't work, using pictures and quotes and such. This way I noticed my error so you helped me solving my proble…
-
- 0 replies
- 1.3k views
-
-
Hi, i am trying to implement Tim Dietrich "EasySync" utility to enable users to work on the system while in areas with poor connection and then sync when back to the office. I know that there is a part of this forum where people discuss only the "EasySync" but i think that my issue is somehow more related to the client - server connection and Psos than to Tims scripts as such. The scripts are using and seam dependent on PSOS feature. First time i installed the demo files and configured the features as per given tutorial it worked fine and processed whatever it was supposed to process. After a few successful intentions the script suddenly stoped working giving…
-
- 8 replies
- 4.1k views
-
-
Hi Tim  I played a bit more with FMWebFrame's Container Uploading. It works smoothly (nice!) on a one-machine FMS config (12Adv on Mac), but on two separate two-machine configs (12Adv Mac & 12Adv Win), the uploaded file gets ".html" tacked onto the end of the filename.  Have you tried this on a two-machine FMS install? (That's the only real similarity I can think of between these two failing machines.)  I'll do some troubleshooting myself, but thought maybe this might raise a flag for you...  Thanks, -Joel looks like my screenshot didn't make it. trying again...
-
- 3 replies
- 2.2k views
-
-
Not quite sure what to make of this, everything was working so well. I would not have expected ES_PUSH table sync to delete data from the client during sync. Perhaps my assumptions are wrong in this regard. Should just PUSH data from client to server. "EasySync supports both "push-only" and "pull-only" tables. To indicate that a table is to be pushed from the mobile device, but not pulled, use an "ES_PUSH_" prefix for the table occurrence's name. To indicate that a table is to be pulled from the host, but not pushed from the mobile device, use an "ES_PULL_" prefix for the table occurrence's name." I am finding that the last record entered is deleted from the…
-
- 0 replies
- 1.7k views
-
-
I've had to reverse engineer other sync solutions and have installed a couple GoZyncs with no problem. This is my first attempt at using EasySync. Broke my solution into 2 files pulled in everything as the instructions say and got it to work. I then started cleaning up my 2 new files so that one was more "mobile" and the other more "server." (different layouts and navigation). Now nothing works. I can get new files to push from Mobile but I can't get anything to Pull from server. New or old. I have an empty mobile file and want all the server files on mobile. I turned on debugging and if I read it correctly it's finding nothing to sync. I've checked the TO's a dozen tim…
-
- 5 replies
- 1.7k views
-
-
Is there a method to exclude a specific field from the sync process? I assume that EasySync always excludes calc and summaries and probably globals (does it exclude globals?) and only lets through numbers, text, dates, times and containers etc. If there are some trigger fields on the mobile solution that have no bearing on the hosted files is there a way to tell the syncing process to ignore a field so that you don't have to add that structure on the host file? Thanks.
-
- 1 reply
- 1k views
-
-
For the "B64" container fields, what should our recommended storage options on those be? Without paying attention, I left it on the default of "Indexing / All" which was obviously a huge problem, but should I have "Do not store calculation results" checked? The reason I ask is my 2Gb DB doubled in size after adding these fields.
-
- 5 replies
- 2k views
-
-
When I setup the FM_Surveys example files for testing and change the version number in the mobile to test easy deploy... Pulling segment 12204 and counting. Standard segment size • Have put server ref into easy deploy db • Have dragged in easy deploy db into container in mobile solution • Have dragged in mobile solution to container in hosted solution • changed the version number in mobile solution to test deployment I see that EasyDeploy is looking for /<b64> in the current segment as an exit condition. Looks like it is not finding it for some reason. I supposed this might happen if there were no file in container, but there is. or... Missing t…
-
- 2 replies
- 1.4k views
-
-
I've got everything sync'ing, fantastic! I'm having one issue, however. If I sync from FM Pro, there are no issues. But when sync'ing from my iPad with the same mobile file, I get a "Unable to connect to the server" error UNLESS I have the hosted database open in another window. Is that normal behavior? I was hoping to make this more seamless for my end user. Should I open the host file from the sync script? Thanks, Ryan
-
- 1 reply
- 1.2k views
-
-
Does anyone have any reusable/elegant solutions for deleting the Parent Record and all of its Child Records by wrapping come code around EasySync Delete Record?
-
- 1 reply
- 1.4k views
-
-
I've went through the setup and everything seems to be connected up correctly. When I sync the local file I get no errors, but no changes appear on the server. Also, If I change a record on the server, the change is not pulled into the local record. I'm syncing a table Named "ES_Data". I've enabled the debugs in the Settings script, but I'm not sure what I'm looking for. Nothing really stands out other than the Dialog Box: "Records From ES_Data" ? It just shows a question mark. Digging a little deeper in the Push Payload Script: $dyn_sql = SELECT 'ES_Data', '' || "__DataID"[1], '' || "NameFirst"[1], '' || "NameLast"[1], '' || "_UserID"[1], '' || "ES_Record_…
-
- 7 replies
- 2k views
-
-
What is the best way to "re-setup" my mobile and host databases for testing purposes? As I add tables, have problems, remove tables, fix problems, add tables again, I'm finding that I am having to do a lot of strange things to "reset" the host and prepare for my next test. Combine that with the DeviceID and the need to "setup" my host on a separate device, I really feel like I am doing this the hard way. Are there some suggestions? The problems that are manifested: I will do a sync... 545 records will come over (yay!) and then I'll have an error (boo). So I start debugging and when I think I fix the problem, I will clear my mobile data (including Payloads) and then it…
-
- 1 reply
- 1.1k views
-
-
Having a difficult time getting $$Event_Filter to work. My event table has id_event_type. I have a global field that filters an event list by this value. Any help incorporating $$Event_Filter? I even tried hard-coding the $$Event_Filter by setting it to "id_event_type = "1F7CED2C-D153-45FC-AFD5-DA796FAF4F28" and still just ?s. Here is what I see in the data viewer: SELECT "event_description", "EzCal_Text_Color", '', "start_time", "end_time" FROM "event" WHERE ( ( NUMVAL ( "start_date" ) = [[DATE]] ) OR ( ( NUMVAL ( "start_date" ) < [[DATE]] ) AND ( NUMVAL ( "thru_date" ) >= [[DATE]] ) ) ) AND ( id_event_type = "1F7CED2C-D153-45FC-AFD5-DA796FAF…
-
-
- 4 replies
- 2.3k views
-
-
I have gotten about 10 of my 30 something tables to properly sync, but I've run into 2 tables in particular that will not sync for some reason. When I add them to the relationship graph on the host and in the mobile, and modify a record on the host, it will cause a sync error on the mobile. The specific error says: Pull Error An error occurred when attempting to process the pulled payload. (Error code:106) With the debugger on, these are the four dialogs that I see prior to the error: Payload Record 1 ?[[bR]]ES_Job Notes 8882 1340 1/6/2015 11:18:29 PM Table Name for Payload Record 1 ?[[bR]]ES_Job Notes Field Names for Payload Record 1 ? E…
-
- 7 replies
- 2.2k views
-
-
Thought I should post an experience I had with using EasySync (which I love by the way), and pasted text containing hidden characters, that can cause an issue with synchronized data. The issue observed :: Upon doing an initial sync, I noticed some fields in the recipient db had text in fields that did not correspond with that in the master database. Looking at the master data, I noticed a "notes" field contained text that looked like it was pasted from another source (in most fields I control the text input, cleaning it to remove things like, formating and spaces and returns at the end of single line data fields). This "notes" text was part of the data that was end…
-
- 1 reply
- 2.2k views
-
-
Hey Tim Thanks so much for EasyCalendar, it's really pretty awesome. I've played with it a bit on a project I'm working on that has a table of Events. A few comments/questions that I've got: a) My Events table has 3 date fields (EventDate, SignupDeadline, CancelDeadline) and EasyCalendar works well to include all of them -- so it seems you could change/clarify "from multiple tables" in your documentation into "from multiple fields". b ) Before I dive into it myself & potentially reinvent your wheel, have you thought about allowing 'hard-coded' or static text for some of the settings instead of having them come from fields? e.g. with some set delimiter, allow …
-
- 6 replies
- 2.7k views
-
-
Tim, I'm working with the beta 2 version with a solution that contains a very complicated import routine. The routine imports a CSV file and then pushes data to various tables, creating child records as needed, while also checking the folder the original file was found in and importing specifically named image files into a Documents table. As an example, a CSV file with 18 rows ended up creating almost 600 records in various tables. My first pass at logging all of these record creations was to commit the new records and then call the "EasyAudit - Commit - Client" script. However, when I did this, I would get repeated (i.e., 40+) dialog boxes explaining that the hos…
-
- 1 reply
- 4.1k views
-
-
If a remote client has data which has not yet been synced to the server but chooses to update using easy deploy, is the data on the original client database lost in this process? Or, is there some check to ensure that Sync is complete before easy deploy updates the client database? It would be interesting to then Reset the updated client database so the times are current although perhaps this should be done before embedding the client update in the easy deploy layout container on the server. I wonder how hard it would be to then sync only the records that where originally in the client database back to the new version. Perhaps this is already happening &a…
-
- 1 reply
- 1.5k views
-
-
It seems like it would be possible, in the interests of maintaining a single code base, to configure EasyDeploy as a single database that could be renamed and the appropriate EasyDeploy layout container filled before deployment. That is, there is a server and client EasyDeploy table, they are different but with no similarly named fields so they could be combined perhaps. Likewise, with the EasyDeploy layout fields in both could be combined into a single layout. Deployment would start with a database where the helper file is in the appropriate EasyDeploy layout container. This is the client file. Copy the client file and call it the server file. The client file …
-
- 0 replies
- 1.2k views
-
-
I've got a project that requires this easy sync capability. Also, the database being discussed also benefits from the Separation Model(UI/Script File and a Data Only File) I'm just looking for general pointers on this setup with regards to getting the data onto the server and how this generally works with a separation model..(external data sources, etc) One particular thing is that I'd like to be able to do is development and interaction with the UI file on the live server and then be able to distribute the updated UI file to the syncing clients when it's ready. As a developer, I don't need the sync capability and to carry the data locally, but I do need to editing ab…
-
- 0 replies
- 1.1k views
-
-
Lovely code and very well thought out : ) Thank you Tim. This is perhaps a very obvious issue but I am missing it somehow. error 5 after first Perform Script in Ping Server. Respond to Client Ping resulting in alert box "Unable to connect to server" I can use my domain name to connect with the console on my server. I can open my server database remotely using my domain name Also can upload to server with same domain name. When I try to add ( add button ) a File Menu | Manage | External Data Sources, as required for easy sync, it does not show any of the available databases on the server to select from as I would have expected, through WAN, files do sh…
-
- 1 reply
- 2.2k views
-
-
Sanity Check Please : ) • “EasySync Settings” and “Sync Check” are in both Mobile and Hosted versions, but are quite different. If I change their names to “EasySync Settings Server”, “EasySync Settings Client”, “Sync Check Server” and “Sync Check Client” I believe that references to those names will change automatically. • This would allow both Server and Host Scripts to be maintained in the same database version that could then be deployed as Server or Client, the Sync button only appearing in the mobile version. ( i.e. if on FMGo show Sync button ) • This is for a deployment where the mobile version has only Push Tables and access to …
-
- 1 reply
- 1.5k views
-
-
Hello, Think before you start. I am thinking of developing a hosted FM solution, where 1000 users share a database. Each user should control a few hundred records, so the total number of records could come close to a million. The user only has to see his own records, and all other records should be hidden for him. Offcourse I am planning to use FM go to add mobility and so I created the need for sync. My question is, what are recommended techniques to use to prevent the synchronisation of All records. If the user uses the same databas on his iPad as the hosted version, he would have to carry around and sync too many data. So how to best design this, so a use…
-
- 1 reply
- 1.3k views
-
-
Dear Tim Dietrich, first of all: Thank you for this awesome little software. I got following problem: Only one record is proceeded at a time. I check with Debug and found out on download all records are processed and downloaded, but only one is afterwards is the mobile database. Do you have an idea how to solve this? Thank you in advance, 51m0n
-
-
- 13 replies
- 2.3k views
-
-
Hello Tim, first i want to congratulate you for all the fmeasy series. You are doing an excellent job (specifically with fmeasy sync) I am testing easymaps and of course it works just fine. My question is if it is possible when clicking an pin in the map inside the info window to show the picture from the corresponding records container field. Thanks again for the great job
-
- 1 reply
- 1.8k views
-
-
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.
-
- 4 replies
- 1.6k views
-
-
If a commit log times out the timeout value is not written to the log entry for the timeout. This is caused by the incorrect global variable name in the set field calculation for the EasyAudit::Note field In the "EasyAudit Commit - Server" script. You can find this step towards the end of STEP 1 section of "EasyAudit Commit - Server". To fix, change the step to the following (step in red, change in bold): # #If EA timed out waiting for changes to be committed to the database... If [ $e > $$ea_timeout_seconds ] #Log the timeout. New Record/Request Set Field By Name [ "EasyAudit::Transaction_ID"; $Transaction_ID ] Set Field By Name [ "EasyAudit::Entry_Typ…
-
- 0 replies
- 1.3k views
-
-
A Pull Error just started coming up when trying to sync our mobile directory to the server, using perform script on server. The error reads, Server did not send payload segment 1. I'll troubleshoot, but if you have any suggestions I'd appreciate it. Thanks, Tom Tom Puckett NGST SE
-
- 2 replies
- 1.5k views
-
-
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 manipulatin…
-
- 0 replies
- 1k views
-
-
I’ve succeeding in syncing an empty “fresh” mobile db on my iPad with my hosted populated db on a server hosted by a 3rd party. It works very nicely. I’ve also succeeded in removing records from the hosted database and re-syncing from the mobile db and found that it synced correctly; i.e., the records deleted from the host were also deleted from the mobile. So far so very good. Now, I changed some of the record-level data on the hosted db and re-synced from the mobile and found that none of the record level changes were made in the mobile db. Am I expecting too much? Also, since my hosted db gets replaced on the server on a daily basis with a fresh copy wi…
-
- 3 replies
- 1.2k views
-
-
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 exac…
-
- 0 replies
- 1.1k views
-
-
Love the solution so far. Once I figured everything out, it seems to work rather well. However, using the EasySync "Sync with Server" script, it seems to take ~2 seconds per record. I have ~30k records, so doing the math, it will take ~16 hours to sync the entire database. This seems a bit extreme, am I doing something wrong? There are no container fields in the database, so this should be a fairly straightforward process. I also want to note that I could not get any of the scripts to work when they were run on the server side, and had to change the mobile settings to run on the client side. Edit: I want to note that I just deleted a few records from the "mobile" …
-
- 5 replies
- 1.8k views
-
-
Tim Dietrich is on a tear: he's releasing innovative and useful products on a daily basis…where does he find the time? ;-) I just cracked open FMEasyAudit and wanted to record my first impressions. I've used FMDataGuard and SyncDek for auditing, and attended Wim Decorte's excellent Devcon session on native audit logging in FileMaker. I'm going to implement audit logging in a new solution, so I am particularly interested in EA to see how it compares with the other solutions I've used/seen. I love: That it's a native solution. Reducing third party dependencies simplifies things. Well-commented, easy to understand code. I'd like to see some of the following impro…
-
- 5 replies
- 3k views
-
-
I've been working with the beta this weekend and really liking it. Logging record views is particularly good to see as I've always wanted to be able to provide stats for this sort of thing to managers, so they can see how their users behave. I've made a couple of changes to the version I have in my current solution and thought I'd post them here in case anyone else was after the same functionality. I've tried to stay true to the coding style in the framework and implemented the changes via the settings script and existing scripts. These work for me but I've not tested extensively so proceed with caution. Changes Omitting EA fields when you have changed their …
-
- 0 replies
- 1.4k views
-
-
I have tables that will be PULL only, tables that are PUSH only and several that are PUSH-PULL. Is that a scenario that EasySync will handle?
-
- 1 reply
- 1.1k views
-
-
I have 11 tables I'm attempting to sync. I believe it's all configured correctly. However, three of these tables are > 800,000 records or more. I'd like to "comment out" these tables from the sync o see if the others are working ok. Can I simply removed the ES_tablename1, ES_tablename2, ES_tablename3 TOs from the graph and have it still sync up the others? Thanks Scott
-
- 1 reply
- 999 views
-
-
Hi Everything works well on my developpement server but after installation on production server I have an error "The sync check's call to the server has failed." (Sync Check Script - line 55) debugger told me I have a prior 513 error FM_Surveys_Hosted_v1r3 works on production server... so the problems must come from my file but I don't see where... any ideas ? thanks
-
- 1 reply
- 1.4k views
-
-
Hello I am trying to do sync over 6,000 records using easysync from hosted db to mobile db on ipad. It is very very slow, its almost 3 secs per record while pulling data. Would it be the ipad version issue? I am interested in finding the initial pull script as mentioned in this link which will speed up the initial pull process. http://timdietrich.me/blog/easysync-initial-sync-preview/ the link above mentions beta 8 version so can i use it? if yes where can i find it? thanks for all you help Bab
-
- 0 replies
- 1.1k views
-
-
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 curre…
-
- 6 replies
- 2.3k views
-
-
Is it possible that the example files are configured to update only from the mobile up to the server? I can get changes I make on my mobile version to go up to the server, however any changes I make on the server vesion don't seem to come down to the mobile version. I changed the Host DataSource - allseems to run ok - it just never brings down the changes Imake to the server version. Scott
-
- 3 replies
- 1.3k views
-
-
I've meticulously followed the directions. My solution host file has been uploaded to a remotely hosted FM13 server at 888, which supports Easy Sync. My solution mobile file is on my iPad2. I am assuming that I should run the "Sync to Server" script in the mobile database on the iPad to trigger the sync. When I do, I get an "Unable to Connect to Server" error message. Any clues to what I may have missed? Thanks.
-
- 0 replies
- 1.1k views
-
-
I'm attempting to implement the sync tool in an existing environment, and I'd like for all records to be sync'd with the client, not just those records that are created by the specific user. I'm not seeing where the ES_Account field is being used to limit the records that are pulled to the client during a "Sync with Server" script usage. Thanks for the help! -EP
-
- 1 reply
- 986 views
-
-
Just a quick note: EasyAudit Beta 2 is now available. This release: • Breaks what had been one large EasyAudit script into several smaller scripts • Adds support for user-definable "EA_" fields. • Resolves issues where a base table did not have a similarly named table occurrence on the relationship graph. • And more. More info about Beta 2 can be found in this blog post. You can download Beta 2 here: http://fmeasyaudit.com/application/download.php Thanks! -- Tim
-
- 2 replies
- 1.9k views
-
-
Coming back to my rather large project. I have taken my hosted database and copied it to be my mobile database so all table definitions are the same, etc. I've recreated my relationship table and right now I am only trying to sync one table. It is also my largest table (in terms of number of fields). The first time that I try to sync, I get "Push Failed" and the message received from the server was 502. This was a direct copy, so my first bit of confusion is... why is it trying to push anything? The data should all be the same including the UUID and times. Second, is there any way to figure out how to determine which field this is? I tried doing EXCL_ on all …
-
- 5 replies
- 1.4k views
-
-
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 = “…
-
- 8 replies
- 1.9k views
-
-
My initial run of the baseline revealed an assumed requirement that I don't see mentioned in the setup instructions: That table occurrences exist that are named identically to the table names. This wasn't the case in the solution I tried integrating the audit log into. Similar to how there's been a request for the ability to personalize field names, I'd request the ability to personalize table occurrence names that should be included in such scripts. Alternatively, perhaps the ability to specify a prefix or suffix to base table names ("DEV_" in my case). Or, of course, a mention of this requirement in the setup instructions. Thanks, Chuck
-
- 4 replies
- 1.8k views
-
-
I want to create workflow solutions between an office and the customers with an offline FMGO solution which talks when cell signal is good. Users will only see their records obviously. Example function: Office sends an opportunity to filtered customers meeting a criteria on the customers position. The customer declines or accepts . Container data would need to be exchanged, updated. Market pricing would update through the day and be pushed to customers. I assume this sort of solution would involve buying a max number of concurrent connections for FMS or does it bypass? Thanks in advance
-
- 5 replies
- 1.5k views
-
-
As far as I can tell, the use of Perform Script on Server isn't a requirement to the functionality of the audit log, but is used to increase performance for end users. But for developers, especially during this beta stage, the ability to step through the code would be useful. Perhaps at the top of the main script there can be an override variable that will use local execution instead. Set Variable [$local_execution; True] Then each of the calls to Perform Script on Server would be replaced with conditional code like the following: Set Variable [$parameter; Substitute ( Get ( ScriptParameter ); "Baseline"; "Baseline Server" )] If [$local_execution] Perform Script…
-
- 1 reply
- 1.7k views
-
-
First of all, Tim, thanks so much for this effort. I'm hoping that I can be of some assistance in contributing to its final release. I'd like to reiterate the request for the ability to customize field names. The script step you point out for doing this manually isn't the only place the field names are referenced. For example, like 446 has a SQL statement that references EA_UUID, and I'm sure there are others. While I'm not experienced with publishing FileMaker modules that can be added to existing systems, my own initial idea for accomplishing this would be to include at the top of the script a set of variables that will hold the names of the relevant fields a…
-
- 1 reply
- 1.7k views
-
-
example: Tables: Works workidpk workerid WorkItems _workidfk data If I filter the sync of the Works table (using the exclude field) to be the works of only the workerid associated with the device how do I get Easysync to sync the related workitems records only ? Do I have to store the workerid in the workitems table and filter it accordingly with the exclude field or is there a more efficient way of dealing with that ? Can I link a workitems occurrence to the ES_Works occurrence ? Thanks
-
- 3 replies
- 1.2k views
-
-
We require a user-friendly serial auto-enter in our orders table. Order are created by mobile users. Obviously, only the hosted file will be able to assign this number so that there are no duplicate serial values (it is NOT used as a relationship key...just a display value), all relationship keys are UUIDs. At first I thought, "simple, just set to auto-enter serial on the hosted file only," but then realized that because of the round-trip issue, my iPad user would not receive the serial value. Must I add a server-scripted process to populate serial fields and set the Device_ID to that of the server's? And then, two syncs would be required for a mobile user to rece…
-
- 2 replies
- 1.1k views
-
-
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
-
- 1 reply
- 973 views
-
-
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?
-
- 4 replies
- 1.6k views
-
-
Tim Having trouble getting fmExecuteSQL to retrun anything except a ?, I have reduced the SQL query to something very basic. I have run the query in FM using ExecuteSQL statement. Here is the message I get: "Warning: Illegal string offset 'Result_Rows_Found_Count' in /home4/wimlibby/public_html/esvw.com/portal/dashboard/dashboard-meetings-committed.php on line 31" I think I installed FMWebFrame properly (Version 13e) and have tested using some of the FM-to-PHP translators to make sure settings were correct and they work. Only thing I have not done is tried to install 404.php - just thought it was needed for containers so waiting until I need it. Any idea…
-
- 2 replies
- 1.8k views
-
-
I have a container field that's configured to use External Secure storage in the hosted file. When I sync a PDF that's stored in that field in the mobile file, it gets pushed up to the hosted file without any problems. But if I then modify that record on the hosted file, for example by changing a value in one of the text fields, and then sync again, the record gets pulled down to the mobile file, but the container data (in the mobile file) gets corrupted. When the container data is valid, GetAsText ( MyTable::MyContainerField ) returns something like this: remote:Transfer Request.pdf PDF :Secure/0D/63/4D03FB8E/064665D1/C08FFD43/C64C After the sync, it returns…
-
- 4 replies
- 1.7k views
-
-
I have a copy of the demo host and client. I have one new table and have deleted the other tables. Here is what is happening. What Works The first sync will pull the records. Changing a record on the client will send the changes to the host. Creating new records on the client will create a record on the host What doesn't Work Changing a record on the host will not send to the change to the client. Creating a new record on the host will not cause that record to create on the client. Any thoughts?
-
-
- 5 replies
- 1.7k views
-
-
Using the approach of copying my hosted solution for my mobile database, I am getting the above error when doing the sync. The online troubleshooting guide says this is a problem with the table names and that I should check the names of the TOs. I have narrowed it down to one table that is giving me trouble (my Employees table) and the TO name for both is exactly correct (ES_Employees_TO). Could there be another cause for this error? Thanks, Ryan
-
- 3 replies
- 1.5k views
-
-
Dear FMF, during the sync with EasySync the FileMaker Go App Crashes. During debugging I recogniced it allways crashes during the Process Payload Step. This Problem doesn't happen in FileMaker Advanced. Does anyone got the same problem or a solution. Best regards and thanks for your help, 51m0n
-
- 2 replies
- 1.6k views
-
-
Any ideas on the best way to troubleshoot an error code 502 on my first sync?
-
- 2 replies
- 1.3k views
-
-
Hi, EasySync looks to me as a great solution and i am tr(d)ying hard to get it to work for my client but unfortynatilly not getting it right yet. here is my latest frustration, i am wondering did anybody experience this yet and what could be the cause. DESCRIPTION: I downloaded and installed the demo files, placed them correctly on the server (Windows 2012) and on the iPad (iOS 8), setup the external data source, tested - and it WORKED just fine. Than i went over all the steps suggested to prepare the real working database. I obviously got something wrong as it was taking ages to do something and didnt work at the end. I got stuck on various kind of message…
-
- 6 replies
- 2k views
-
-
I've integrated EasySync into an existing solution and it works very well. However I'm having trouble pulling changes form the host file to the mobile file. The initial pull from the host file to the mobile file worked and changes to the mobile file are pushed to the host file (including new records). However changes to the host file (including new records) are not being pulled into the mobile file. The 'ES_UTC_Time' field is being updated when I make a change to the host record. My table names use the 'ES_TableName' convention. I see that the 'Prepare Payload for Client' script is returning 0 which I guess means it didn't find any changed in the hosted file? …
-
-
- 4 replies
- 1.5k views
-
-
I configured EasySync inside my big project (a lot of tables, occurrences and scripts). I created a table just for testing the sync. Testing configuration: Hosted Database: Dedicated server, windows , filemaker server 13 Mobile Database: My personal Imac, Filemaker 13 Pro Advanced Filemaker quits unexpectedly quite often when I'm trying to sync the database. It happens most of the time when I click OK on the "Successful Sync" message dialog at the end of the sync but sometimes it will crash a little bit before that dialog box. Edit: Actually it now crashes every time (I got the sync to work a couple of times before but now it always crashes) …
-
- 11 replies
- 1.5k views
-
-
Hi Tim Just testing out FM WebFrame for my first time, starting with Container Uploading. I'm using your Demo (on my server) and when I first loaded the site in my browser, I got Notice: Use of undefined constant nickname - assumed 'nickname' in /Library/WebServer/Documents/FMWebFrameDemo/FMWebFrame/settings.php on line 91 & similar for lines through 95. Wrapping each of those keys in quotes seems to fix the Notice. (I also got: Warning: date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function.…
-
- 2 replies
- 2.2k views
-
-
Just a quick note: EasySync v1.3 is now available. This release resolves a few issues that have been reported over the past several months. A detailed list of the changes that have been made can be found in the change log, which is in the EasySync zip file. Also, I've also posted a summary of the changes on my blog: http://bit.ly/10aAjRZ You can download the new version from the EasySync Web site: http://fmeasysync.com Thanks! -- Tim
-
- 3 replies
- 1.4k views
-
-
Hi I have a file that has 2 container fields set to capture images on FileMaker Go. Normally the second container won't be used. They are both setup with Base64Encode fields in the same way. When the file is synced the record comes across with the photo in the first container but in the second container, rather than being empty, EasySync inserts a blank jpg file named with the date and time. Is there a way of avoiding this? Thanks
-
- 1 reply
- 982 views
-
-
Tim and whoever else is involved - thanks for making EasySync available for free. I turned the ES_Exclude field into an unstored calc (per instructions in http://fmeasysync.com/docs-easysync-integration/) so that certain records can be excluded from the sync based on the user's privilege set and account name. However, now if user A logs in on their iPad and syncs, and then user B logs in on that same iPad and syncs, there may be some records whose ES_Exclude values will now be 0, but they won't get picked up if nothing else about that record changed, because the ES_UTC_Time field won't have been updated. (It gets updated when a record is modified, but since we cha…
-
- 2 replies
- 1k views
-
-
Finally I finished the test. IT WORK. I add this future: A) The same file for hosted and remote. Differents kind of sync, some table are synched for all the records, other only the records related to the privilege setting. The final result is that all the groups have common informations, but each group has specific informations related to it. Let say thank you to all the people that made me possible to do this. My best regards Franco
-
- 2 replies
- 1.2k views
-
-
Hi Tim, Can I create one database with both the hosted and mobile scripts, layouts, etc., and just copy it to my iPhone or do I need two separate databases? Thanks, Peter
-
- 15 replies
- 2.2k views
-
-
Hello, We have implemented FMEasySync in our solution. We have 21 tables, each table has over 15 fields. I followed all the instructions in the guide. The sync even worked once but it took over 1/2 hour. But now it just keeps going on and on saying "pushing payload to server" and never returns. there is only about 100 records to sync. There are no container fields they are all text fields. So i cant imagine being alot of data. i have hosted the main database in filemaker pro advanced 12 and i am using filemaker go 12 as a client. I have disabled the PSOS in the client file. I would really appreciate a pointer on how i can debug this and get our sync to work.…
-
- 1 reply
- 1.3k views
-
-
Hello. Thank you for the marvel that is FmEasySync! It is exactly what we needed for our relatively simple sync needs, and I truly appreciate the thought that has gone into creating it. I am only seeking help because our application is made complex by some security requirements, and I have run out of ways I can think of to troubleshoot it. I'm hoping someone else can offer a suggestion that will knock this loose for me. Our application is an "observations" database that runs in Go on the iPhone. It allows our managers to make safety observations and sync them to a central database for later review. In addition, if what they are observing needs to be addressed…
-
-
- 8 replies
- 3.9k views
-
-
I read everything I could and still do not know where to put the EasyDeploy file. I have the hosted surveys on File Maker Server and the mobile on iPad and they work but where does deploy go? On server or mobile device? Also Tim, your files are great.
-
- 1 reply
- 1k views
-
-
Hello I understand the documentation for this sync says the hosted file needs to be on filemaker server. However if we disable the perform script on server features then will this work on filemaker pro 12. Filemaker server with 5 concurrent iPads is very expensive. But you can have 5 users with filemaker pro 12 included in license. Thanks appreciate any feedback.
-
- 6 replies
- 2.5k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online