Importing data from Go back into data stores
I have created a database in filemaker 12 which now successfully works on our ipads using FMGo.
This entry form allows workers (15) to collect observations whilst in the field, sending them back to be collected in our central database. This could easily lead to 100's of reports a day in future.
The problem i have is how i will get that data back into a database easily. My original plan was to create a script that exported the table as a .csv file then wiped the (GO) table data, leaving it ready for new data, before attaching it to an email and mailing to a mailbox. I would then pick up the files from this mailbox and import into our database to allow reporting etc.
The issues i am now finding are
So the question is, how do i
thanks in advance
Can you script the save at the end of the day to a DROPBOX folder from each iPad? From there a script runs to import. Save the files to an archive folder for each day, short term archive.