FileMaker 18 Database Cache Clearance
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