mrwatson-de / fmSetupAssistant

A tool to setup your FileMaker workstations

MIT License

2 stars 0 forks source link

fmSetupAssistant: Update #55

Open mrwatson-de opened 1 year ago

mrwatson-de commented 1 year ago

fmSetupAssistant has no update mechanism.

This feature is needed before the tool can be effectively used.

mrwatson-de commented 1 year ago

Implementation idea:

Update via export & import

(This is the current standard method For fmWorkMate tools.)

Method 1 - XML

Using simple Export/Import Records [ XML ]

Export found Settings

Exports current Settings found set to 'fmSetupAssistant_Settings.xml'

Export found Configs

Export current Configs found set to 'fmSetupAssistant_Configs.xml'
Go to related records [ Matching, _ConfigSettings ]
Export current _ConfigSettings found set to 'fmSetupAssistant_ConfigSettings.xml'
Go to related records [ Matching, _Settings ]
Export current _Settings found set to 'fmSetupAssistant_ConfigSettings.xml'

Can Import occur Import matching UUIDs?

Method 2 JSON

As 1 but with JSON

mrwatson-de commented 8 months ago

Both methods are in process.

First fields names have been cleaned up and standardised.

Custom functions have been developed to automatically convert between UpperCamelCase field names and lower_snake_case json key names.

Important an automatic 1:1 conversion from lower_snake_case to (fake) UpperCamelCase is not possible if field names use a mix of spaces and underscores!

Best solution: Spaces not allowed - then underscores remain underscores

mrwatson-de commented 8 months ago

Both methods are in process.

First fields names have been cleaned up and standardised.

Custom functions have been developed to automatically convert between UpperCamelCase field names and lower_snake_case json key names.

Important an automatic 1:1 conversion from lower_snake_case to (fake) UpperCamelCase is not possible if field names use a mix of spaces and underscores!

Best solution: Spaces not allowed! underscores can remain underscores