I’m creating a new database by dragging a text file onto the FMP19 start-up screen. This process quickly creates a new file, table, and associated fields. However, this process does not create the standard “housekeeping” fields (primary key, et al). Is there a way to automate creation of the housekeeping fields?
This is done with the FMDefaultfields.xml file. You can find out more about them here Default Fields and in the help files https://help.claris.com/en/pro-help/content/database-tables.html. When you read that documentation be aware that the file name changed from DefaultFields.xml to FMDefaultFields.xml with v19.2.
Thanks. Unfortunately, I believe the housekeeping fields need to be added manually (copied from another file) in this scenario. There is no way to automate this.
Yes. Obviously it's easy to copy them in, but there will always be a couple of steps.
1 Like
I wrote a FileMaker file as a by-product of a job, which can be used to create an FMDefaultFields.xml from the XML copy of a FileMaker file, which is then stored in /Users/Shared/FileMaker/Shared/. You create the fields in "Manage Database" in the table "MyDefaultFields" - with your own settings. My file then creates the FMDefaultFields.xml with your new default fields that FileMaker subsequently creates when a new table is created.
The file is almost ready. I can provide it here in tomorrow or the day after tomorrow.
The file needs a free plugin which my file installs. Afterwards the plugin can be uninstalled again. (2empowerFM Text Toolkit by dracoventions.com)
The file will work on WIN and Mac.
__
Edit: I got the idea from this article on soliantconsulting.com: How to Customize Default Fields in FileMaker Pro 19
The described steps can be automated by using regular expressions. Therefor I need the mentioned plugin.
2 Likes
There is a lengthy thread and a demo file here:
https://community.claris.com/en/s/question/0D50H00006dsk3hSAA/default-fields-xml-generator
Remember that the "DefaultFields.xml/FMDefaultFields.xml" is language dependent! If you run FM in e.g. English and another copy in e.g. French you have to create/update both FMDefaultFields.xml
1 Like
I have not found a file for FMP19 in the thread. Did I miss it? The old file no longer works for the new format. At least when I had tried it the last time a few months ago.
With my file it will be possible to keep several tables with standard fields for different projects or customers. Then you can exchange the FMDefaultFields.xml at any time in a flash. These tables with default fields are created in my file as usual under "Manage Database". Via "Save copy as XML" I read out the properties and then assemble the correct XML - based on the FMDefaultFields file belonging to the system language.
I'm a little tight on time right now. But I hope to be done with it until tomorrow. The XML creation is already working and tested. I'm still working on the rest of it.
1 Like
Unfortunately I have not found the time yet to finish my announced file. My current project was too time consuming. It will take me a few more days to finish the file. Sorry …
3 Likes