Ken, Sound like a worthy project!
We do this in our system. We use SOAP for the connection (cause it's an old system, before Objects and Http Request in 4D) NOTE: You should use "Alpha" fields as your ID fields Have each remote use their own Alpha-Prefix for the field value This is an "EXTREMELY" shortened summary The "Remote" systems are the same structure as the "master" System 1. Create a table: e.g. [Synch_Records] 2. As record on the "Remote" system is saved In the Trigger (could be otherwise) Determine all fields in the table that have been modified Store an array of field Numbers in the Synch table 3. Upon connecting to the "master system" network 1 Synch record at a time (in case of disconnect) Get the field values of the record for the field numbers stored Pack it all into a BLOB (or Object) a. Record ID Number b. Table Number c. Array of field Numbers d. Array of Field Values 4. Lookup the table/record Id in the master system Update the master system record (or create it) Send a confirmation to the remote that this record has been updated Set a "complete" flag on the remote system for that record Rinse and Repeat 5. You could do this for records coming from the Master to the remote as well. Randy Engle, Director XC2 Software LLC – XC2LIVE! -----Original Message----- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Kenneth Geiger via 4D_Tech Sent: Monday, October 1, 2018 5:00 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Kenneth Geiger <kgeiger....@gmail.com> Subject: Thoughts and Suggestions? Hi All, I’m in the initial stages of discussing a potential new 4D Database with a client. It will be Client/Server (5 to 10 users) in a Mac environment. The issue is that they will have people working outside in the woods where they are virtually guarantied not to have Internet access via cell-service or otherwise. These people need to take notes and record data during their field-work using iPads. Then, once they get back to “civilization”, this data needs to be uploaded to the Database. Obviously, they would not like to have to re-enter the data. Any thoughts or suggestions on how to structure this and/or what tools might be employed would be greatly appreciated. TIA Ken Geiger ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************