Videos are now being made available on our YouTube Channel. See videos link above.
This technique demo file is provided as is for you to pick apart.
Techniques range from the simple one-step "Set field" button to passing JSON as a parameter to a script that clears as many fields as you want. A similar script sets fields to (randomly generated) default values, including container fields. The scripts are well commented and once you start looking at it, the techniques should be self-evident.
The following techniques can be learned in the file:
IT Director, Qlik & FileMaker Developer
Location for the DBCache folder is:
The following FileMaker script is an AppleScript to get the size of the DBCache Folder into the clipboard:
try do shell script "du -sm ~/Library/Caches/FileMaker/DBCache/" set theresult to the result set the clipboard to theresult end try
Our script to check and exit with a result on the next action you wish to take is below (Check DBCache Folder).
Note: I wish we didn’t need to paste the results but only way we have managed this to work. We also monitor for a bot to reboot if it runs over 999 scripts since last reboot.
This FileMaker AppleScript tells our bots to reboot:
tell application "Finder" restart end tell
On Reboot we run an AppleScript to clear the DBCache Folder
Note: I am not responsible for deleting your data, please check this command and Folder location is correct before running as this command is recursive
do shell script "rm -r ~/Library/Caches/FileMaker/DBCache/*"
Check DB Cache Folder
Available to long-standing members only. Use the same password as before, or ask Jul.