I would look at the various 3rd party sync tools that are available. They would provide a much more robust and automatic sync solution.
By 'append' to you mean simply add the records? Or will the process require any kind of synchroniztion, to ensure the records from each mobile device do not clash with records added on the desktop, added by other devices, or modified before the last sychronization?
If you merely need to add the records, the only change I can think of from the way you'd do it on a purely desktop setup is to use UUID's as primary keys, since auto-incremented serial numbers generated on unconnected devices will create dupes.
If, on the other hand, you need synchroniztion out-of-the-box, you'll want a commercial product such as GoZync (http://gozync.com).
Hi thnaks for the response
For now all I need to do is just "add" records to the host database from each iPad to compile a set of data. My issue is most forms I have built require a relational data model with several tables. Is it possible to "add" data to all the tables all at once or do I need to add data one table at a time? I am surprised at how difficult it is to compile data with Filemaker Pro Advanced from multiple iPads and that I need anther $400.00 add on to do this. I thought this is what this software was designed for?? Seems like I am missing something obvious.
Move the data back table by table. In other words, if you have generated 5 sales invoices on the iPad, with each invoice containing line items as child records, write the invoice records back to the host in a loop and then write the line items back to the host in another loop.
This isn't the only method, and there are a variety of ways to 'write back', including setting global fields on the host to text stacks that are then parsed out into their respective tables by a script on the host.
But it's more likely that the tables on the iPad have matching tables on the host. You can add records to those host tables using a relationship where 'Allow creation of related records' is checked. Play around with that method to learn how it works.
In any event, it's really not that difficult once you become familiar with the environment, and it doesn't sound like you need to spend that $400.
If you post back with further questions, it would help if you described a bit more about what you are trying to do.
Syncing is not a built in function.
I think commercial syncing solutions are overkill. They're expensive and take time to learn and then configure a solution. I bet you'd be better off making your own sync process using Import script steps.
I'll let others decide if commercial solutions are overkill ;-) but I don't think you want to build a sync solution around import scripts steps. Details and a demo of why imports will bite you can be found here: http://www.seedcode.com/cant-sync-import-records/
(Thanks to Todd Geist for the demo.)
Hope that helps,
You might take a look at the httppost functionality in FM 13. Since you really aren't "syncing" anything, but adding new records, this would be simliar to submitting a form on the web. You can create your own web (php) script to handle those submissions.
If prior to FM 13, there are other options. There's more than one way to submit information to a web script
Hope this helps.