Filemaker Server is not required. The requirement for server has to do with the number of concurrent users connected to the database. Filemaker can host the database. The iPads would need to be on the same local network or have internet access to connect to the hosted database.
You copy a database to dropbox but it is not designed to share a filemaker databases. Dropbox would be used to store a backup and or used to move the database to a device.
If you are not on the same network or do not have an internet connection then you will have to design a sync system or purchase a sync system that has already been designed.
Thank you for such a clear answer, I really appreciate your help.
WE don't want to pay anything ongoing, so it looks like developing something would be the only way, however it looks like it is way out of my capabilities so we might be back to emailing excel spreadsheets every night.
Most of the syncing solution are a one time buy.. We have over 200+ iPads running the Gozync solution.. Syncing is definitely the way to go..
Thanks Jason, looking at that it is still probably a bit cost prohibitive.
Is there not any way of just emailing the database from iPad an office administrator who has access to the main database? If I did it this way, would it require a complex sync system to update new records?
Another option perhaps, what about using a mac server? Again the key here is that the engineers will not have access to an internet connection whilst inputting the data. As an apple house, so would like to utilise any hardware/software already purchased if possible.
Also, the iTunes sync, could this be done using multiple iTunes accounts? (i.e. engineers having their own iTunes account on the iPad)?
Yes, you can email the database and them import them when you receive them.
or use iTunes..
Then import the data..
This would be the not so fun option..
So 5 engineers could have the database sent to their iPads. At the end of the days work they could email the database to the office administrator who could upload the data received into the master database.
When uploading the emailed data, could it be set up to just add new records or does it delete the original and especially make a new database every time?
I presume iTunes can become a bit painful to use with FM?
The import would be something you would want to script. You could have a button on a layout to import the database then use scripts to loop through the records and import the data.. You can choose to update existing records, add new ones, etc..
Make sure you test your import routine well before implementing..
And if this is all in one Factory, you also have the option of setting up the needed hardware for a good WiFi connection and then your users can use their iPads to enter data directly into the hosted database. The number of users described here (5) can be supported when using FileMaker Pro to host the database. FileMaker Server, while nice to have, would not be necessary.
Could you (or anybody) be kind enough to check my list below and make sure I have everything right?
- single FMP license on office administrators Mac
- 5 engineers using FMG on iPad, accessing the main database that has been emailed to them
- Engineers will work with no internet connection
- End of each day when linked to wifi, they can press a button (with a script behind it) to send all new/ammended records via email to the office administrator
- Office administrator can run an upload script for each of the engineers emails, and the main database will be updated with all new results from that day
- Is the only way for the engineers to see the full new database, to have it emailed back to them by the office administrator?
Sounds a little clunky. Hmmmm. Maybe I do need a third party sync tool...
Just saw your post Phil
There are various factories unfortunately and no access to WiFi, otherwise this would be ideal.
Seedcode has a free version that will sync one table, so you can test it out.