Jump to content

Search the Community

Showing results for tags 'applescript'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 44 results

  1. Hello, the following is the essence of a problem I need to resolve. The code is AppleScript display dialog "Hello \"world\" " This code needs to run in FMP18 as a calculated applescript. I tried: Perform AppleScript [display dialog \"Hello "world" \"] Perform AppleScript [display dialog \"Hello \""world"\" \"] Perform AppleScript [display dialog \"Hello "\"world"\" \"] Perform AppleScript [display dialog \"Hello \""world\"" \"] and other permutations of 1 backslash and 2 quotation marks cause the calculation to be unsavable b/o error. Perform AppleScript [display dialog \"Hello \"world\" \"] results in "A identifier can’t go after this “"”." -- after the calculation is saved. (Yes, "A identifier") Perform AppleScript [display dialog \"Hello \"\"world\"\" \"] results in A “"” can’t go after this “"”. -- after the calculation is saved and an error message of -2740. Can anyone help me please?
  2. Using FMP12, I was trying to use applescript to launch FMP and and a remote file.. I got it to work except for the fact that the "Open New or Existing File" dialog box pops up and stops the script.. The checkbox to disable the dialog is gone now (Please bring it back!!), so anyone know a way to use applescript to "Cancel" the dialog? Also, just for Reference sake, it took me awhile to get the applescript syntax correct to remotely launch a database file: This actually terminates the FM process the tries to open a remote database that on startup runs a script. set app_name to "FileMaker Pro" set the_pid to (do shell script "ps ax | grep " & (quoted form of app_name) & " | grep -v grep | awk '{print $1}'") if the_pid is not "" then do shell script ("kill -9 " & the_pid) delay 10 tell application "FMPro" activate delay 10 getURL "Fmp://username:password@ipaddress/filename.fmp12" end tell
  3. I am trying to get FileMaker to extract the content of the inbox in mail. The code works on my computer but on my clients it has an issue. The code sets cell "g_Email_Inbox" and when I query that cell from applescript it returns its contents but within FileMaker on my client's machine NaDa. It displays as empty and any scripts within filemaker see the field as empty. I have attached the script for your use. Both new up to date machines. Client is running FM13 while I'm on 14. I will confirm that is not the issue but I suspect it is not. Really need so thoughts on this ... Im stumped Mail GetMessages.scpt
  4. I have written the following calculated AppleScript: "tell application " & Quote ( "Microsoft Word" ) & ¶ & "activate" & ¶ & "open" & Quote ( "Macintosh HD:Users:Shared:Guild_Word_Template.dotx") & ¶ & "set theDate to current date" & ¶ & "set text of active document to theDate as text" & ¶ & "save as active document file name " & Quote ( UIN_FOCUS::GT_WORD_FILE_NAME ) & ¶ & "end tell" & ¶ & "tell application " & Quote ( "System Events" ) & ¶ & "tell process " & Quote ( "Microsoft Word" ) & ¶ & "keystroke " & Quote ( "v" ) & " using {command down}" & ¶ & "set theRange to (create range active document start 0 end 23)" & ¶ & "end tell" & ¶ & "end tell" I have a problem with the line that starts "set theRange". I actually have two more lines after this that I've tested in Script Editor irreverent from FM and they work as expected. If I remove this line in FM my script works well. Any idea what's wrong with this line? Thanks, Agi
  5. I am trying to figure out how to write a FileMaker script, using AppleScript, that will allow me to select a folder full of QuickTime video clips and import the following from each clip: Clip Length (duration in hours, minutes, seconds, etc, such as “00:00:08.67") Frame Rate (in frames per second, such as “23.98”) Frame Size (such as “1920x1080”) This metadata would need to be imported into each correct record in FM that matches the Filename. Can anyone please point me in the right direction?
  6. Hi All, I've been successful in creating an Applescript that creates events in iCal based on my fields in my 'shows 2' table in Filemaker. I was wondering if anybody knows how to add an alarm to the newly created event (ideally to notify the user the day before). Many thanks Here's the code in my Perform Applescript function (calculated): "tell application "Calendar" ¶ tell calendar "Test Cal" ¶ set eventDate to date " & Quote ( shows 2::typeDate ) & "¶ set eventDateEnd to date " & Quote ( shows 2::typeDateEnd ) & "¶ set newEvent to make new event at end with properties {description:" & Quote ( shows 2::icsDescription ) & ", summary:" & Quote ( shows 2::icsSummary ) & ", location:" & Quote ( shows 2::location ) & ", start date:eventDate, end date:eventDateEnd} ¶ end tell ¶ end tell"
  7. We are working on a process for passing certain info nuggets out of a solution (FMP 13) in an encrypted method. For various reasons a version upgrade isn't feasible. So the plan is to encrypt the nuggets, then pass them into a format for transport. Currently, we're using Applescript to pass the particular fields into an AES-256-CBC encryption process in a calculated Applescript step, as follows : The problems which concern me here: 1. The password is "traveling" into Terminal in plaintext. Is there a way this can be viewed during the process (a 'ps' or some other method)?? 2. Is there a better method to accomplish this without running as an echo? I've tried various flavors of this process (successful encryption & transport, etc), but am most concerned about the potential vulnerability from within OSX.. I've run various flavors, then attempted to grep for any of the password strings in log files and Library/Application Support/ folders, but haven't found anything... Is this an unfounded issue, or should I be going a different direction?
  8. Is it possible to use AppleScript to open the Script Workplace, select a particular script and even scroll to a particular line? I looked through several AppleScript sources (there are not so many...) as well as the Dictionary of FIleMaker Pro Advanced 15, but all examples seem to deal with using the database (i.e. finding and manipulating records), not authoring. Why would be handy? I have an authoring database where I can store the scripts and scriptsteps of a solution. These are converted from FIlemaker XML using the MBS plugin, not that complicated. Then it's possible to select the scriptsteps that need attention. But locating these scripts in the original solution is quite time consuming, so an AppleScript would save me tons of time.
  9. I need some applescript help. I know nothing of Applescript and it is really hard to find tutorials... I'm not looking in the right place. Does anyone have an apple script that would take a value from my database and simply create a new folder? In my record I have the file path in one field, and the name of the new folder in another field. I want to execute an applescript to create a new folder at the end of that path. It is on a networked volume (not on workstation running databse). Gosh, any help you can give me would be so appreciated. Also, if you have any links to good training for applescript that'd be great too... I might have to go get applescript for dummies and actually read the book.... so 1980! Thanks again for any help you can offer. Steve.
  10. I have created the following script that runs within FM Pro 5.5 to move a folder from one location to another. tell application "Finder" move folder "folder to move" of folder "test scripts" of folder "Desktop" of folder "adamreece" of folder "Users" of startup disk of application "Finder" to folder "To Archive" of folder "job_folders" of disk "XSERVER" of application "Finder" end tell This works if run as a straightforward script step, but I want to be able to use a calculated field as I want to use a database field to specify the 'folder to move' name etc. We use FM to book in design jobs and invoice them when complete. The aim of this script will be to automatically move a job folder based on its unique job reference number (ie. 060378) when we run a script to invoice the job. Sorry in advance if I've not explained myself clearly, but I need help to get this working. Thanks!!
  11. This took some good google-fu for me to figure out, so I figured I'd post just in case anyone else is having the same problem. I had the following snippet that worked perfectly for the local database: This failed when I migrated the database to a remote server. Instead, I use this. The field in question ("Client matter number") is the third field in the layout. This is why I specify two "" in the data. I don't know why the former doesn't work for remote databases, but such is life! - Mike.
  12. I use FileMaker Pro 6 on an Apple MacBook running system 10.6.8 and I use AppleScript extensively. I modeled this statement directly from an example script which came with the app. tell application "FileMaker Pro" do menu menu item "New Record" of menu "Records" end tell When I run the script, I get the following error dialog: Does anyone know how to fix the problem or at least how I can find out what error -10000 means ?
  13. I've written the following applescript program to open my FileMaker Pro DBMS remotely. I get an AppleEvent time out error. Would someone know why? Thanks! tell application "FileMaker Pro" set openDBs to {} try set openDBs to name of every database end try if openDBs contains "dbms.fmp12" then show database "dbms.fmp12" else get remote URL "fmp12://batchuser@password/" end if end tell
  14. Hi all, Here's another little tutorial I figured I'd share. The last one I posted on this part of the forum was how to upload the contents of a container field to an FTP server, using AppleScript to use the cURL command-line tool. This is similar to that, in that it uses AppleScript to invoke cURL, but this script allows you to use cuRL similarly to wget, to specify an URL and a destination path and have filemaker download that file to that path. To use this function specify your URL and Download Path (ex: "/Users/yourusername/Desktop/filename.zip") separated by ¶ in the script parameter. This will only work on Macs. It should work at the very least under MacOS 10.6-10.8 since I have confirmed that cURL comes packaged with the OS under those versions. -------------------------------------- curlDownload[$url, $unixpath] -------------------------------------- Set Variable [$url; Value:GetValue(Get(ScriptParameter) ; 1)] Set Variable [$url; Value:Substitute ( $url; "&" ; "" & "&" )] Set Variable [$url; Value:""" & Substitute ( $url; "&" ; "" & "&" ) & """] Set Variable [$unixpath; Value:GetValue(Get(ScriptParameter) ; 2)] Set Variable [$script; Value: "set curlscript to "curl "& $url & " > " & $unixpath & """ & "¶" & "set curlresult to do shell script curlscript"] Perform AppleScript [$script]
  15. I've been trying for 3 days to figure out the syntax for an FTP Upload custom function (downloaded from briandunning.com), but I can't get it to work. It always fails with error -2740, "an unknown token can't go here," which tells me nothing. Anyone care to check out my script and offer some pointers? I'm sure there's a syntax error, but I can't find it. I want to hard-code the username and password, but the password contains special characters (parentheses), and I'm not sure how to escape them: i,e, ythr(i.K9)56 I've tried various escaping approaches: ythr(i.K9)56 , "ythr" & "(" & "i.K9" & ")" & "56", etc. FTPUpload (path, directory, file) " set thePath to quoted form of "ftp://<username>:<password>@ftp.remotehost.com/targetfolder/" do shell script "curl -T" path & "/" & directory & "/" & file thePath " Any ideas?
  16. fmp 14 last release. i put this applescript in a global field and also all the fmp field are global. i don't understand wy it doesn't work, if the applescript var are set as ... "set ServerDisk to "afp://" ... it work. Were i am wrong? Many thanks. set ServerDisk to field ("ServerDisk_as" as text) of table ("__AS" as text) set ServerFolder to field ("ServerFolder_as" as text) of table ("__AS" as text) set VarAccount to field ("VarAccount" as text) of table ("__AS" as text) set VarPw to field ("VarPassWord" as text) of table ("__AS" as text) tell application "Finder" display dialog ServerFolder if not (disk ServerDisk exists) then mount volume ServerFolder as text as user name VarAccount with password VarPw end if end tell
  17. I have a simple Applescript that works in Script Editor tell application "Keyboard Maestro Engine" do script "Search the Web" end tell I add this same script (with escape chars) to my RESOURCES::A_SCRIPT field inside FM. The RESOURCES table is not connected to the other tables in the graph. "tell application \"Keyboard Maestro Engine\" do script \"Search the Web\" end tell" I've tried this with this field being defined as a Global Storage Field or not. Similar problems with both. I have an FM Script called EXECUTE: Perform Applescript (RESOURCES::A_SCRIPT) When I run this FM Script I get an error message: "Error: -2741" / "Expected EOL but found Command Name" I've have tried rebooting my Mac. Any ideas?
  18. Hi All, I just thought I'd try to give back to the community that has given so much to me by writing a little tutorial. This technique is one I developed on Macs. Mac OS X has the curl command line tool as part of the default installation. Curl is like a web swiss army knife. You can fetch files, POST data, upload to or download from FTP servers etc... so it brings a lot of functionality to the table which isn't built into FileMaker. I make use of curl through the "do shell script" AppleScript command, which in FileMaker I use through the "Perform AppleScript" script step. Here's a simple 6 line script that lets you take the contents of a container field and upload it to an FTP site. Substitute your container field in the first and fifth lines and your FTP information in the $script variable to make it functional. This script could be extended by actually having variables for the FTP credentials/location too but I've kept it simple here just to demonstrate the technique. set variable [$file_name; GetAsText(YourTable::YourContainerField)] set variable [$path_temp; Get(TemporaryPath) & $file_name] set variable [$path_unix; Middle($path_temp ; Position($path_temp ; "/" ; 1 ; 2) ; Length($path_temp))] set variable [$script; "do shell script "curl -T " & $path_unix & " ftp://USERNAME:PASSWORD@FTP_HOST/FTP_DIRECTORY/" & $file_name &"""] Export Field Contents [YourTable::YourContainerField; "$path_temp"] Perform AppleScript [$script] Enjoy!
  19. bBox is a FileMaker plug-in providing easy integration with shell, AppleScript, Python, and Ruby scripts. Freely available with a comprehensive demo file. This version adds the following: bBox_PythonEvaluate function for quick call-backs from FileMaker "no wait" mode for Bash, Curl, and sort functions function descriptions (FileMaker 15 only) now with over 160 examples in demo file Requires FileMaker 12 or higher and Mac OS 10.7 or higher. The majority of its 34 functions are server-side and CWP compatible. Details and download at: https://beezwax.net/products/bbox.
  20. One thing I really like about FMP is that you can specify a "calculation" for a perform AppleScript script step. However, this does leave something to be desired. Before each quote in the AS, you have to do a backslash, and at the end of each line, the paragraph symbol. A problem I've had is that it's difficult to debug AppleScripts entered in FMP scripts. If the script is "static" -- i.e., you don't construct the script using various FM fields, etc. -- it's easy enough, because you can create the script in AppleScript editor, debug, and then copy and paste into FMP and enter the appropriate backslashes, etc. However, this doesn't work well if the script is "dynamic," where you're creating the script in a calculation field based on various FM fields. I have found a pretty good solution, however. First, create the script as a variable. Call it $script, for instance. So, the calculation field for the perform AppleScript would simply say $script. Now, insert a halt script command just prior to the perform AS command in your FM script And prior to that command, create a text file where the contents of the file are $script. I use the Troi File plug-in, but there may be another way to do that. At a minimum, with the Troi plug-in, you can open up the resulting text file in AppleScript editor, and execute it there. This is very beneficial, because the error handling is much better when executing an AS via the AS editor as opposed to directly through FM. Let me know if I'm explaining myself clearly, and/or if you have any questions. I will say that this saved me at least an hour of debug time today -- it's a worthwhile thing to do for complicated AS execution through FM.
  21. I successfully deployed SuperContainer (SC) via the Web Publishing Engine (WPE) of FileMaker Server 11 for years, on a Mac mini (2010) running OS 10.6.8 (Snow Leopard), with no problems. But I ran into the following problem with Mavericks and SC: I upgraded to more modern versions of OS X and FMS by doing a completely clean installation: Formatted the Mac mini's drive; Did a clean installation of OS X 10.9.1 (Mavericks); and Installed FileMaker Server 12v6 without problems. Next, I downloaded the latest SuperContainer from 360Works (v2.896). When I double-clicked the "Mac Installer.app" (also known as "SCInstaller") to deploy SC with FMS, as I did before with FMS11, I was surprised to see this alert pop up: "'Mac installer' is damaged and can't be opened. You should move it to the Trash." Mac Installer is damaged.tiff I tried downloading a fresh copy, using Safari and Firefox; same error. I’d never seen this message before when installing any software, and I found no reports of it in this forum or in TechNet. The icon displayed in the alert window indicated that it was originating from Mac OS Gatekeeper. So the solution I tried was to change the "Security & Privacy" System Preference of Mavericks, under the "General" tab, to "Allow apps downloaded from Anywhere", rather than the more restrictive "Mac App Store and identified developers" option. (Perhaps another option would have been just to control-click the app icon and then select “Open”, to exempt the app from Gatekeeper; I didn't test that.) Apple’s support article on Gatekeeper mentions this “Damaged” app warning message is an indication that “the app has been altered by something other than the developer.” I doubt that any “true damage” is present in the Mac Installer for SC. I think the message appeared because AppleScript scripts get modified after they’re signed. An Apple support article on Mavericks security states: “Some apps and tools, such as AppleScript applications and some legacy tools, modify themselves after signing. These types of apps cannot be opened unless the Gatekeeper setting in Security & Privacy preferences is set to Anywhere” I had only tried the SC Installer on Mavericks, but I suppose the same error might have occurred on Mountain Lion or Lion, since Gatekeeper was introduced with Lion. It appears, for now, that we may need to temporarily disable Gatekeeper (by choosing the "Anywhere" option) in order for SC's Mac Installer to work. David M. Hollander, MD Combined Fields Consulting
  22. I am trying to create a button that deploys a script that opens a corresponding server folder based on the value in a particular field of the current record card. Here is what I have so far, but I can't figure out why it is not working: Set Variable [ $jobno ; Value: Project File Server Locations::_4_digit_Job_No. ] If [ $jobno ≤ "100" ] Perform AppleScript [ "tell application "Finder" activate make new Finder window set target of Finder window 1 to folder "Projects 0001 - 0100" of disk "TRG Projects" end tell" ] Else If [ "100" < $jobno ≤ "200" ] Perform AppleScript [ "tell application "Finder" activate make new Finder window set target of Finder window 1 to folder "Projects 0101 - 0200" of disk "TRG Projects" end tell" ] Else If [ "200" < $jobno ≤ "300" ] Perform AppleScript [ "tell application "Finder" activate make new Finder window set target of Finder window 1 to folder "Projects 0201 - 0200" of disk "TRG Projects" end tell" ] Else If [ "300" < $jobno ≤ "400" ] Perform AppleScript [ "tell application "Finder" activate make new Finder window set target of Finder window 1 to folder "Projects 0301 - 0400" of disk "TRG Projects" end tell" ] Else If [ "400" < $jobno ≤ "500" ] Perform AppleScript [ "tell application "Finder" activate make new Finder window set target of Finder window 1 to folder "Projects 0401 - 0500" of disk "TRG Projects" end tell" ] Else If [ "500" < $jobno ≤ "600" ] Perform AppleScript [ "tell application "Finder" activate make new Finder window set target of Finder window 1 to folder "Projects 0501 - 0600" of disk "TRG Projects" end tell" ] Else If [ "600" < $jobno ≤ "700" ] Perform AppleScript [ "tell application "Finder" activate make new Finder window set target of Finder window 1 to folder "Projects 0601 - 0700" of disk "TRG Projects" end tell" ] Else If [ "700" < $jobno ≤ "800" ] Perform AppleScript [ "tell application "Finder" activate make new Finder window set target of Finder window 1 to folder "Projects 0701 - 0800" of disk "TRG Projects" end tell" ] Else If [ "800" < $jobno ≤ "900" ] Perform AppleScript [ "tell application "Finder" activate make new Finder window set target of Finder window 1 to folder "Projects 0801 - 0900" of disk "TRG Projects" end tell" ] Else If [ "900" < $jobno ≤ "1000" ] Perform AppleScript [ "tell application "Finder" activate make new Finder window set target of Finder window 1 to folder "Projects 0901 - 1000" of disk "TRG Projects" end tell" ] End If
  23. I am trying to get around merging files. I have a database of Matters in filemaker pro advanced. I have created a script in the matters file which uses applescript to open a word template file, rename it according to the name of the record I ran the script from and save it with the new name. This part of the script works fine. It is implemented by using a global field with the filename in it and setting a variable in applescript by reference to the global field: "get cell" The new file is a letter - I want to be able to extract the name of the matter from the filemaker database and place it at a specific location in the word document. My plan is to have a unique word on the document and to search for that word and replace it with a variable in applescript derived from a field in filemaker. I want to do this, if it can be done, without closing the document I have just created. after much trial and error i am getting the feeling that I may not be able to do this unless i close the document first and/or that you cant use defined variable in the search replace "command" (if that is what it is - forgive me I am not a programmer or anything) Thanks in anticipation.
  24. Hi, I am using filemaker 11 to copy customer info from excel into the database and then it would generate special keys in pdf allowing us to send the file to the customer. My access to the filemaker is non-admin, and the import function of customer info has been blocked. We are keying in the record one at a time, so we are looking at ways to automate this process. When I try to create a new record using applescript with just it was not allowed. There are data that require validation like date and auto-indexed record number. So, is there a way we could create new record and then using the set function to copy data into the report?
  25. This worked before >10.6 now it doesn't or it works sporatically. I have a script that grabs the metadata from a track in iTunes (including artwork) then creates a record in FM and sets specific field. It all works except for the container field I'm trying to set with the artwork. I get this error "error "FileMaker Pro Advanced got an error: Object or property is the wrong type." number -10001 to item" With the code to set the container field omitted, the script works great. Any help would be greatly appreciated. Here's my script that is run within FileMaker so the on MakerRecord does not have a tell application "FileMaker Pro" step. property FM_NAME : "" property FM_ARTIST : "" property FM_COMPOSER : "" property FM_ALBUM : "" property FM_GENRE : "" property FM_LOCATION : "" property FM_TIME : "" property FM_TRACKTOTAL : "" property FM_PLAYLIST : "" property FM_LABEL:"" property FM_CATALOG:"" property FM_CATEGORY:"" property FM_NOTES:"" property FM_YEAR:"" property FM_LYRICS:"" property FM_BPM:"" property FM_ARTWORK:"" property newData:{} activate tell application "iTunes" set thePlaylist to front window's view set FM_TRACKTOTAL to count tracks of thePlaylist set FM_PLAYLIST to name of thePlaylist repeat with i from 1 to FM_TRACKTOTAL set FM_NAME to name of track i of thePlaylist set FM_ARTIST to artist of track i of thePlaylist set FM_COMPOSER to composer of track i of thePlaylist set FM_ALBUM to album of track i of thePlaylist set FM_GENRE to genre of track i of thePlaylist set FM_TIME to time of track i of thePlaylist set FM_YEAR to year of track i of thePlaylist set FM_NOTES to comment of track i of thePlaylist set FM_LOCATION to location of track i of thePlaylist as string set FM_LYRICS to lyrics of track i of thePlaylist set FM_BPM to bpm of track i of thePlaylist try set FM_ARTWORK to data of artwork 1 of track i of thePlaylist end try set newData to {FM_NAME , FM_ARTIST , FM_CATALOG , FM_TIME , FM_ALBUM, FM_LABEL , FM_YEAR , FM_COMPOSER , FM_GENRE , FM_LOCATION, FM_NOTES , FM_LYRICS , FM_BPM , FM_ARTWORK} my MakeRecord(newData) end repeat if (exists of playlist "PTB Temp") then delete playlist "PTB Temp" end if end tell on MakeRecord(theData) create new record in layout "Import" in window "Publisher's Toolbox Creative System" with data theData end MakeRecord
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.