We’d also be delighted for you to catch our Office Hours every first and third Thursdays where we can talk “in person” and dive into various FileMaker aspects that you’d like to know more about.ĭownload the Modular Export v1.2 demo and let us know what you think!įor history, you can see the original post from 9/27/19 here. has released new, more advanced templates There are three new free templates in the first batch: Job Tracking Event Management Memberships All three free templates incorporate more features than the standard FileMaker templates included with FileMaker Pro Client. If you have any questions about this or other FileMaker topics, send us a note below. If you have data in tables that have no table occurrence on the graph, it will not be exported.Īnd keep in mind that the limitations of this script that are documented in our original blog article in our original blog post still apply as well. It will not work properly in a file that has table occurrence names that are not SQL friendly - for example, having a period in the TO name.Īlso, the script is based on the existence of tables on the relationship graph. There are a couple of things to watch out for when using this script. These table names and fields are available in the three metadata tables: Table Names & Fields Available in the Three Metadata Tables The script now concludes with a dialog indicating that the export is done and where the files can be found. Two additional text files are now saved to the export folder containing a full list of base tables and base fields for the file. We’ve made a couple of additional changes to make the Modular Export script more bulletproof and more useful: The new BaseTableFields table allows us to do the SQL query for the fields in a table with a bit more efficiency than before. This is a single script that can be copied into any FileMaker file to perform a full CSV export of the data in all tables in the file. We’ve taken that update as an opportunity to again improve our modular export script. Rather than containing one record for each field in each table occurrence, the new table contains just one field for each base table that exists on the relationship graph. In FileMaker Pro 19.4, Claris introduced the new FileMaker_BaseTableFields table to the metadata tables accessible via the ODBC interface and the Execute SQL function. PLEASE DOWNLOAD THE CURRENT VERSION, MODULAR EXPORT v1.2, AT THE END OF THIS POST ** **IMPROVEMENTS HAVE BEEN MADE TO THE ORIGINAL DEMO FILE.
0 Comments
Leave a Reply. |