Warning, such "synch" processes are anything but simple if it is possible for the same record to be modified on more than one distributed copy of your database.
To do what you request, Add a text field with this auto-entered calculation:
IDField & " " & MOdificationTimeStampField
Set a unique values, validate always validation rule on this field.
Then, during import, the records that duplicate this matching value will be excluded.
Add a new field (type text) maybe called IDmodified and set the auto-enter calculation with:
ID & "|" & Modification TimeStamp
Be sure to uncheck 'do not replace existing value' so it will update when modifications happen. Set this field's validation tab to: Validate data 'always' and uncheck 'allow user to override' and specify Unique,
Now the import ... set it to ADD records only. If the record exists in target table with same ID and Modification TimeStamp, it will not be imported. Also note that you do not need to Show All Records for this to work ... validation takes place at the table level so all records are checked during this import.
Thanks people, I'll try both suggestions and get back to you.
It's the same suggestion, though LaRetta did a much better job of describing the method. (I left out some details she kindly included.)
Your post wasn't there when I responded, LOL. I was going to delete it but noticed a sentence or two additional so I decided to leave all of it; more out of laziness. :-)
To avoid the issue completely, can you not host the file with FM and let the iPad users log on to it, live, so no synchronisation needed?
[To avoid the issue completely, can you not host the file with FM and let the iPad users log on to it, live, so no synchronisation needed?]
That's an interesting concept. Do you need the server version?
I haven't been down the road of posting on the web, which I presume you'd need to do. The iPad users are on the road so would need to have ready access (via 3G). This is doable?
I still haven't tested your import method, but it sounds eminently doable. Christmas holidays got in the way!
You need the server version only if you are going to have more than 9 simultaneous guests. You don't 'post' the file to the web as such, you simply make the file available to internet-connected users from your server. You set up your network's router to forward incoming traffic to the workstation hosting the FM file.
As far as the connected users are concerned they can have the same facilities and features that are available if they connect inside your network (subject to the limitations of FM Go, obviously.) The iPad remote users need wi-fi or 3G access, or similar. They can't use the file off-line.
Did you ever get this working?
This is what I have been looking for .... only problem is I am using FMP12 and the instructions are for FMP11 - I have sort of got it working, but it will only re-import exisiting entries, rather than excluding them from the import and allowing new entries to go through.
I have attached a few screen shots... have I got a setting wrong?
Thanks in advance.
p.s. LaRetta's answer seemed to make more sense