This script was designed to be placed in the ‘Start-Up Items’ folder of a Mac, which was used to host FileMaker Pro 5 Unlimited. FMP did not have an auto-launch facility built into it, to allow for the computer to automatically launch certain databases upon start-up, so, with some help from various forums, I built this one.
Within the FileMaker Folder, I created a sub-folder called “Web Databases”, and within that folder, I created individual folders for each of my hosted database solutions (ie 'Stock" containing files ‘Inventory’, ‘Location’, etc.)
This script will allow the user to abort it within the first 10 seconds of starting up, but if allowed to proceed, will open every file matching a certain file type (set in the script) which is found in the 1st teir of sub-folders within the Web Databases folder. Any files within sub-sub-folders (ie Web Databases:Stock:Archive) will not be launched.
At the end of the run, a summary is displayed, advising how many folders were checked and how many files were launched.
This script may be a bit rough (it’s one of my first), but it works.
OS version: Any
-- User-defined Base Folder set filemakerRootFolder to "Macintosh HD:Applications:Filemaker Pro 5 Folder:Web Databases" -- User-defined File Type set filemakerFileType to "FMP5" -- Initialise Counters set countOfFolders to 0 set countOfFiles to 0 tell application "Finder" activate -- Allow User to Override Script, handy if run as part of StartUp Items set promptResponse to display dialog "FileMaker StartUp Application" & return & "You have 10 Seconds to abort" buttons ["Abort", "Continue"] default button "Continue" with icon caution giving up after 10 if promptResponse is not equal to "Abort" then -- Make a list of Folders within the Base Folder set filemakerFolderList to folders in folder filemakerRootFolder set countOfFolders to number of items in filemakerFolderList -- Access Each of these Listed Folders individually repeat with i from 1 to the number of items in filemakerFolderList set filemakerFolder to item i of filemakerFolderList -- Make a list of Items within the Folder of the Type specified earlier set filemakerFileList to (files in filemakerFolder whose file type is filemakerFileType) -- Update Counter to show Running Total Number of Matching Files set countOfFiles to countOfFiles + (number of items in filemakerFileList) repeat with j from 1 to the number of items in filemakerFileList open item j of filemakerFileList end repeat end repeat tell application "Finder" activate -- Show Summary of Actions, with Number of Folders Accessed and Number of Files Launched display dialog "FileMaker StartUp Application" & return & "Launch Completed" & return & return & "-- Summary of Actions --" & return & " " & countOfFolders & " Folders searched" & return & " " & countOfFiles & " FileMaker Pro files opened" buttons ["OK"] default button "OK" with icon note giving up after 5 end tell else -- Show Abort Acknowledgement display dialog "FileMaker StartUp Application" & return & "Aborted by User" buttons ["OK"] default button "OK" with icon stop giving up after 5 end if end tell