

In order to adapt and expand the gFM-Business ERP software, it is advisable to proceed in a structured manner, for example to be able to quickly find everything again in the event of subsequent changes and to be able to quickly transfer the changes to a new version in the event of an update. Based on many years of experience, this article will give you a brief overview of which strategy has proven successful in the past.
Fields:
It is best not to create new fields directly in FileMaker Pro, but in gFM-Business under [Settings > Preferences > Fields]. The fields created here are automatically created in the new version before the import when importing into a new version. In this way, the data can also be imported automatically in the fields you have created yourself as part of an update data transfer.
We are already working on an extension that will make it possible in future to create your own tables directly in gFM Business, which will then also be created automatically as part of the update data transfer and the data will then be imported automatically. In all previous versions, new tables with all fields must be created in the new version before the data transfer and the data from the old version must be imported manually from the old version after the data transfer.
Scripts:
In all existing scripts to which you make changes, it is best to create a new area in the upper section
############### Customizing
You can now create all new subscripts related to your customizations and extensions in this area. In this way, you can update the developer module under [Settings > Administration > Scripts] search for the term "Customizing" and you will see a list of all scripts whose "Customizing" sub-script areas you need to copy into the new version. At this point, please remember to only copy your own sub-scripts into the existing scripts of the new version and not the entire script, as the new version could contain changes to the respective main script.
Relationships:
Newly created data relationships must be added manually in the new version.
Layouts:
If you make changes to layouts, I recommend doing so with developer mode switched on, which you can find under [Settings > Administration] can be activated. Each time you switch from layout mode to browse mode, a dialog now appears with a screenshot before and after the change and a note field in which you can enter notes on the change.
- If it is an unimportant change, click on the [Discard].
- If it is an important change, save the change and add a comment if necessary.
With a properly maintained log, you will always have a list from which you can see which layouts you have made changes to. Please note the following points when updating:
You can completely copy your own new layouts. Create the layout in the new solution and, if necessary, add areas in the same position as in the old layout. In the old solution, press [cmd-a] on the layout and copy everything to the clipboard. In the new solution, click once with the mouse in the top left-hand corner and then paste the complete layout from the clipboard.
Changes to existing layouts that also exist in the standard version of gFM Business must be transferred manually from the old version to the new version. It is therefore best to make a note in the development log of exactly which changes you have made to which layout.
If you have created multilingual screen layouts, please remember to transfer the corresponding language set from the old to the new version.
Navigation and main menu:
To transfer your standard definitions from the old version to the new version, it is best to import all data records from the tables [gui] and [Main menu] from the file [gFMw_System] from the old version to the new version. Then transfer the navigation and the main menu to the users.
Value lists:
You can simply transfer new value lists from the old version to the new version. Please note the sequence. If you have new layouts that use new value lists, first transfer the value lists and then the layouts from the old version to the new version.
Custom Functions:
You can simply transfer new custom functions from the old version to the new version. Please note the sequence. If you have new fields or scripts that use new custom functions, transfer the custom functions first and then the fields and scripts from the old version to the new version.
Order of transfer
If you are updating from one version to another, you should generally follow the following sequence:
- Custom functions (if new ones have been created)
- Value lists (if new ones have been created)
- Tables (if new ones have been created)
- Fields (if new ones have been created)
- Relationships (if new ones have been created)
- Scripts and partial scripts
- Layouts
- Navigation and main menu
Greetings from Kirchhatten
Markus Schall
gofilemaker.com - MSITS
The forum for the Claris FileMaker-based gFM-Business ERP software with CRM, merchandise management system and invoicing for Apple Mac, PC and iOS. It serves the exchange between users, developers and gofilemaker.de. The forum boards are divided into overarching topics and modules such as customer management, merchandise management or invoicing. Anyone interested is welcome to actively participate in the forum.


