We have Filemaker server, and the techs in the field are sometimes in areas where the wifi/cellular service is sketchy at best. I was wondering what the best solution would be. I guess put the database on the devices (iPads) themselves and then create a script to import the offline data? I heard there are plugins to sync the data with the server.
Just thought I'd throw it out there and see what experience other people have had.
I have already posted here:
and have some thoughts in mind, but I will copy what I put in there, here.
Avoid FMGo Connection Interrupted
Server Timeout Disconnect
In the attached links, it goes back to questions that I had that dealt with a file on an iOs device, making sure it stays live and up to date.
So what I have done is worked on a local file that syncs to the one on the server.
That seemingly works, however there is a problem that just recently came up when I was testing. When the local file tries to reach the file on the server, it doesn't always connect.
In talking with others there is two consensus of what might be the cause:
The Wireless access point is blocking access File security permissions are not working (File Access tab in Security) "Reset All" temporarily works (on the server file) Deauthorizing and Authorizing sometimes works (on the server file) Turning off the File Access requirement doesn't seem to help (on the server file) I do have File Access on the local file, but I haven't tried turning that off.
Since I can't debug exactly what is going on, on the iPad this makes it harder. (I have put in some custom dialogs to see some things.)
The local file with the syncing to the server file works on my desktop, but that is a wired connection. (I could try the same wireless connection.)
It could be that I'm making a duplicate of the local file and putting that on the iPad, which makes the file not work.
(I put on the duplicate file on the iPad newly each time for testing, because I need a file without certain info on it, which will be filled later [dealing with Get(PersistentID)].)
Is there something I'm not thinking of?
To my knowledge, it had been working until recently.
I'll try a few more things, but hopefully get answers in the meantime.
URGENT...Our Zulu has completely stopped working with Google...it's not syncing in either direction.By HALBURN
Our Zulu has completely stopped working with Google...it's not syncing in either direction.
We have rebooted the server but it has not corrected the problem.
By Eden Morris
I feel like I'm missing something obvious. I'm trying to write some SQL to get an ID list for deleted records in a syncing solution. I'm finding that its slower than I'd like and this method feels like it's not efficient at all, anyone have a better idea?
To explain what I'm doing I'm getting a list of ID's where the creation timestamp is before the last sync and then I check to see if it doesn't exist in the other file. The problem is that for every record I'm running rather large select statement within the EXISTS().
The table SP stands for Sync Projects and Q stands for Questions, I'm using SP to get only the questions that are attached to the projects on the client file.
Get the ID's in the local file:
ExecuteSQL("SELECT id FROM Q WHERE zCrTS < ? AND NOT EXISTS(SELECT * FROM H_Q WHERE Q.id=H_Q.id)";""; ""; $$LastSync) Get the ID's in the hosted file:
ExecuteSQL("SELECT H_Q.id FROM H_Q , SP WHERE zCrTS < ? AND H_Q.id_project = SP.id AND NOT EXISTS(SELECT * FROM Q WHERE H_Q.id=Q.id)";""; ""; $$LastSync)