We're using Filemaker 9.0 and our server is UNIX with PHP/MySql. I need a method/script to accomplish the following:
1. Export / Import information between my computer and the server database. i can export/import in comma or tab separated format.
2. We wish to offer book sales tracking for authors, so my Filemaker database will have author name, ISBN, quarterly and YTD sales, returns. So that is two text fields followed by three number fields (they don't need to do any calculations). The ISBN field would be the key field.
3. Each author will have their private login to see just their information.