AppleScript & Automator

I've seen several posts about similar problems but none seem to resolve my issue. i am trying to run an applescript to create a preview of a document using qmanage. this works perfectly fine when run from script editor but will not work using the run applescript command in filemaker. i've also tried send event command using 'script editor' as the application to use for running the script. neither create the preview png file. but it works fine if i run it in script editor. this is the script content: tell application "System Events" launch do shell script "chmod 777 " & "\"/Users/user/Documents/filename.docx\"" delay 1 do shell script "qlma…

In 2013 I had great help here from Comment and others configuring native AppleScript in a FM Advanced 14.0.6 in El Capitan 10.11.6. It worked fine, and still does to this day. Unfortunately, I need to switch to the latest Mac OS and FM. For reasons I do not comprehend, the AppleScripts no longer work in the new environment. This is a non-commercial research DB, and I would very much appreciate if anyone can help me fix this. Here's the script. THANK YOU! tell application "FileMaker Pro" set fName to cell "tbl_Photos::UserFolderFN_Photoset" of current record end tell property ChooseFolder : "Choose Photoset Folder" set SourceFolder to ("Serv…

As part of a much larger applescript, I create a new record in FM and then tell FM to go to the new record, as follows... tell application "FileMaker Pro" tell document "XYZ" set newrecord to (ID of (create new record) as integer) go to record ID newrecord end tell end tell This works fine on my machine. However, when I connect the database as a shared database on any other machine (being shared from my main machine), it creates the new record but does not go to the new record, with the following error message: error "Can’t make id of «class crow» id 3.1354E+4 of window \"XYZ (iMac2020)\" of application \"FileMaker Pro\" into type integer." number -17…

I have script which calls the contents of a cell eg set Proj_name to get cell "Project»DATA::project folder name" of current record It has been working fine recently but today I noticed it stopped working. if I run the scriptn directly in AppleScript I get "FileMaker Pro Advanced got an error: A privilege violation occurred." I have Allow Apple event and Active X turned on in extended Privileges. Recent events have been Catalina upgrade and moved the files to filemaker cloud but the script has worked since and I get an error on a local file too. Any ideas?

I am trying to create a calculated Applescript that imply renames a file in the Finder. The Applescript itself works fine: tell application "Finder" set fileAlias to (POSIX file "Users/username/test.jpg") as alias set the name of fileAlias to "test2.jpg" end tell but the calculated Applescript does not: " tell application \"Finder\"¶ set fileAlias to \(POSIX file \"Users\/username\/test.jpg\"\) as alias¶ -- test will be replace by a variable set the name of fileAlias to \"test2.jpg\"¶ end tell " (I have tried various iterations with escapes etc but none so far worked; I am using …

Hi there, I have been searching Adobe and Claris FileMaker forums to find out how to use AppleScript to open an image file in Photoshop. Ideally, what I need is a way to open a RAW image file in Adobe's Camera Raw. From what I have found online so far, this is not (no longer) possible. So I will settle for opening images (raw or jpg or psd) in Photoshop CC proper (I have 2018 and 2019). I have what I believe is the right path to the file in a variable. Following what you have recommended to others, my FileMaker script copies the value in the variable to a global text field. That field is on the layout that is active when the Perform Applescript step runs. …

Where would one put shell scripts or other unix command line script for MacOS X? Such as this script https://github.com/TyrfingMjolnir/FileMakerBackupRemoval in which I wrote to curate offline backups. This script would run anywhere in combination with an rsync # crontab -l 5 * * * * /usr/bin/rsync -av /Volumes/backup/fms03/* /Users/backup/fms03/ && /usr/bin/chown -R backup:staff /Users/backup/fms03 && /usr/bin/chmod -R 760 /Users/backup/fms03 this crontab is from a remote backup such as Synology, FreeNAS, Joyent SmartOS, docker, k8, linux, or other unixes such as MacOS X. Any nix flavour that runs SMB, SSH, or NFS really. What…

Hi, Piecing bits from other posts I've cobbled something that looks promising: ------------ tell application "Microsoft PowerPoint" activate repeat with slideNumber from 1 to count of slides of active presentation tell slide slideNumber of active presentation repeat with shapeNumber from 1 to count of shapes set shapeText to content of text range of text frame of shape shapeNumber set selFind to get find object of selection clear formatting selFind set highlight to false set forward to true set format to true set newText to my…

I'm trying to use the BaseElements plugin to execute an AppleScript a few seconds after the FileMaker script (the AppleScript creates a DDR using interface scripting and doesn't seem to work when using Perform AppleScript). This used to work, but I think the new security settings for macOS are preventing it from doing so now. The calculation being used to execute the AppleScript is BE_ExecuteSystemCommand ( $_cmd ; 0 ) where $_cmd has something like this: (sleep 2 ; osascript "/var/folders/2d/1p6b7tb14tl_g3rrfjyn_jp40000gn/T/S10/create_ddr.applescript") & If I paste that command into the terminal, it works fine, but Terminal has permission in Syst…

I wrote a quick applescript to upload an image to a server and then insert it into a container in a new record. I'm sure this has been done a million times by other developers, but I couldn't find an existing script. The problem is that I get an error message: filemaker got an error: Data is being accessed by another user, script, or transaction Unknown Error -10011 The error stops showing up for a while if I swivel my office chair around quickly and then scratch my head, then execute the script. Is there a good way to take the voodoo out of this? Thanks! Matt Applescript: property filepath "" property filename : "" property ima…

I'm familiar with utilizing Calculated AppleScript or setting a global field to a value and then reading it from AppleScript. But is there a direct method for AppleScript to get a FM global variable from outside of the FM application, ie. for AS app, is there a way to say: tell application "FileMaker Pro" to tell database "myDB" to set v to { get filemaker global variable named "gv" }

Don't suppose anyone has found a way to pass a script parameter with the applescript "do script" command?

Is there a way in AppleScript to trap if the connection is lost and have an AppleScript act on this? At the risk of asking and answering myself( AppleScript below ) repeat tell application "FileMaker Pro" try database "db" on error do shell script "sudo shutdown -r now" with administrator privileges end try end tell delay 59 -- 59 secs end repeat

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 i…

We recently upgraded our FM server from 11 to 14. I have an Applescript that I moved from a 10.8 mac to a 10.10 mac. The client is FM14. It has some odd behavior that I had to deal with, but one step Im stuck at. I have a simple step that checks if there are records in the database and if there are it deletes them. show database "databasename" delay 1 if (count of every record) ≠ 0 then delete every record The apple script fails with the above error: error "FileMaker Pro got an error: The event failed." number -10000 and it highlights the "delete every record" part. I've tried various ways of changing this line, but the script seem…

so, i have a filemaker database that i built for work. i have the database where you can import pictures. but to keep everything 'uniform', i wrote an applescript that will check the file that is being added to see if it is a jpg. if it is, it will rename it, move it to our server drive and import it to filemaker. if it's not a jpg, it will convert the file to jpg using image events, then continue the process with the jpg that was just created. it works like a charm in script editor. but when i add it to filemaker, it works for the firsts time i run the script, but on the second and all following times, i get a -1708 error that image events can't continue launch. i…

i'm about to pull my hair out here. i've got an applescript that works perfectly in the applscript editor, but when i try to add it to filemaker as a calculated value, i get that error. i'm not finding what quote i'm missing. any help would be greatly appreciated. this is the script editor version: and here is the filemaker version: I have to think it's on the "execute javascript \"document.forms['Form1']['ddlAffiliateList'].value = '\" & strippedNumber & \"'\"" & ¶ &" line, but i've tried everything and can't seem to figure it out. please help!

Greetings, all. I have been researching for a few weeks now with few results, so hopefully someone here might be gracious enough to help me out. I have an event database that, after setting the event date for the new record, will auto-populate a number of fields with due dates for a bunch of different tasks. My understanding is that I should be able to use AppleScript for this, but I have not been able to figure out how. My first question: is there a way to have Filemaker add an event to my Mac Calendar once I set the event date and start and end times in the record? I'd like it to be added to a particular calendar - that is, the "Business" calendar in the Calendar a…

I could really use some help! I'm in a crunch and need a solution fast. Any Applescript FileMaker gurus out there? My client sends me (usually weekly) batches of excel documents... hundreds of them. I've created import scripts and parsing scripts to get the data from the excel document into FileMaker, but I need a solid way of batching the import process. Below I'll explain what I currently have, but it's very clunky and errors out quite often, so I could really use some guidance. I can look at applescripts and for the most part understand what they are doing, but I'm no scripter. Basic need: Trigger import process in which one at a time, the excel documents are importe…

Hi, I'm a pure newbie to Mac (Mac OS X 10.8.3) and trying to a folder based on field data under a fixed path, but without any luck: set dirName to cell "fk_person_id" of current record set targetPath to quoted form of ("/Volumes/Macintosh/cluster5/medistic/media/" & dirName) do shell script "mkdir -p " & targetPath The above returns the below errors: Object not found. Unknown error: -1728. What is wrong with my script, please help...

Has anybody had success deploying multiple instances of Filemaker via either ARD or Network Install? It's supposedly supported but I can't for the life of my get the package to build using the shell script that they provide. This has been a feature that's been around for a while, however in their tech documentation they refer to a link that cannot be found on their website for the 'fmp_osx_deployment.zip' file (which I obtained from their support people) and the Shell script contained within the file doesn't do anything as best as I can tell. I'm no expert in Shell scripting so its entirely possible that I'm doing something wrong here. The ACTUAL code should read sud…

I am wondering if there is a way, probably using Applescript, to Quicklook an object (file, graphic, sound, etc.) that is stored in a container field. It seems that would be a very desirable function.

I am trying to find method for reducing a PDF Currently I have a script that export a PDF to the temp folder and then attaches that file to an email. I was thinking I could add a AppleScript step in between to reduce the file first.

I have a form letter that I frequently send. Presently, I click a button on Filemaker and it opens the form letter. Then I have to manually put in the address and client information. I believe this process could be automated, as it is also stored on Filemaker. I don't want to do a "merge" and would rather accomplish this with applescript. The reason for this is because I don't want to have to do a "search" to limit my records, rather I want to just be "inside" that particular record - click the associated button I have that opens the document in word, and have it "find and replace". I have tried this: set thematter to cell "Mattername" tell appli…

Is there a way in AppleScript, when communicating with FM (i.e., an AS triggered from outside of FM) to tell FM to freeze the window?

Hi, I'm having problems with an applescript that tells Phone Amego to initiate a phone call. I've got it to work with a phone number hard coded into the script, but I can't get Filemaker to insert the field's content (phone number) into the script. Table name: PhoneAmego test Telephone number field (text): PhoneNumberGen Mac OSX Mountain Lion Filemaker 11 adv. The plain applescript is: tell application "Phone Amego" getURL "tel:555-555-xxxx" end tell I tried to write a calculated applescript: "tell application "Phone Amego"¶ getURL "tel: (PhoneAmego test::PhoneNumberGen) "¶ end tell" It will launch Phone Amego and display the sc…

Hi, hoping someone can help. I had a couple of AppleScripts, set up to run on a button, that would create a folder in the Finder and a Mailbox in Mac Mail using data from fields in a given record. Since updating to Yosemite these scripts no longer work. I get error messages as per below; For the Finder folder: "Finder got an error: You don't have permission to create a folder here." "Unknown Error: -10000." For the Mailbox: "Mail got an error: AppleEvent handler failed." "Unknown Error: -10000." Here is the AppleScript that would create the Finder folder. set FolderName to cell "Docket Folder Name" of current record set FolderPath to cell "Docket Folder Path" of c…

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 ap…

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.

I need to import a number of files into fielmaker. Can I 'write' a file reference to an filemaker import script? If not can I use applescript to repeat through the files and import them one by one? Thanks

Can anyone suggest how one can generate an Outlook for Mac meeting invitation via Scriptmaker's 'Perform Applescript'. It needs to manage variables such as date, time, duration, subject, attendees, scheduling, etc (I have a pretty basic grasp of Applescript!)

Hello Just need help on using applescript to open a filemaker file. Sounds like simple but spend sometime to look around and found nothing easy to follow. Following is a snap of script want to use and not sure how to script the open file statement. I need to access to a file under a document folder and what could the syntax be looked like. tell application "FileMaker Pro Advanced" open file "Drive:filename.fp7" end tell Many thanks,

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:" …

So I have a working native applescript already: set stringToFind to """ set stringToReplace to "" set theFile to choose file set theContent to read theFile as «class utf8» set {oldTID, AppleScript's text item delimiters} to {AppleScript's text item delimiters, stringToFind} set ti to every text item of theContent set AppleScript's text item delimiters to stringToReplace set newContent to ti as string set AppleScript's text item delimiters to oldTID try set fd to open for access theFile with write permission set eof of fd to 0 write newContent to fd as «class utf8» close access fd on error close access theFile end try I want to eliminate the "choo…

We have created a FM interface file that contains a master script to open the solution files and run a series of scripts in several of the solution files. The function of the scripts is to send emails with PDFs, some of which are existing, some of which need to be created and attached to the email. We want this to run on Windows Server 2012, Standard; we are using admin accounts in FileMaker as well as the server. We have scheduled a task in the Windows Task Scheduler to open the FileMaker file, which it does. The interface file is programmed to run the master script using the OnFirstWindowOpen script trigger. The master script is set to run with full privileges. …

After generating an email WITH an auto attachment via Filemaker script I want the user to add extra attachments of their choice. the following script has two problems; 1: Deletes the auto generated attachment 2: Will only add one email (multiple selections not allowed) set the_files to (choose file with prompt "Select file to attach to Email. Sorry, ONE FILE ONLY." without invisibles) tell application "Mail" tell front outgoing message make new attachment with properties {file name:the_files} at before the first paragraph set visible to true end tell activate end tell Any thoughts? thanks

Hey guys, I posted a question on applescript example of adding a reminders. Thanks, what you sent in was awesome. The next question I have is if anyone has an example of adding an iCal calendar item from applescript. I would like to add and iCal event the name, date, time start, and end time. Any help would be awesome.

Is it possible, using AppleScript, to have changes made in FMP reflected in iCal the instant they are made? Much like Apple sync services. IF so what am I overlooking here. I'm able to exchange data between the 2 apps. No Problem. I'd like to know how to trigger a script that will sync the two apps once a Change in Filemaker occurs. (w/o user intervention)

hoping someone might be able to help me here. here's the basic story, i do a lot of applescript work inside of my filemaker databases. and over time, i've come to HATE having to convert all of my applescripts to calculated applescripts inside of filemaker simply because i always end up missing a quote mark somewhere, or a slash, etc. so i have to go back through all the code and diagnose. so, i came up with the idea to build an applescript conversion database. you paste in the code, and poof, the calculated script spits out. it works like a champ for the applescript to filemaker conversion. now i'm working on the reverse so that if i need to take an calculated appl…

Hey group, I have an application where I am trying to do an applescript to the reminder app. Once I create the work order I would like it to automatically add to the reminder. Any ideas on how to do that. Can somebody send me a sample on this.

When running this applescript from filemaker i get these errors: Expected end of line but found identifier., Unknown Error: -2741. The calculated applescript looks like this: "tell application "Finder"¶ set filestart to "" & $path & "" as string¶ set fileend to ""& $ftp & "" as string¶end tell¶tell application "Adobe Photoshop CS6"¶ open file filestart showing dialogs never¶ set myOptions to {class:Photoshop save options, embed color profile:false, save spot colors:false, save alpha channels:false, save annotations:false, save layers:false}¶ set openimg to current document¶ resize image openimg resolution 150.0 resample method bicubic¶ set myOpt…

Hey guys, I ‘d like some help with this. I am refering to of course the mac, windows and ios. Mac: That’ s the easiest because you can have os x trigger the vpn when a program starts, the fm client in this case. But I have not figured out how to script the open remote database and optionally provide the client credentials too. Ios Am I correct in assuming that If I want the same triggering behaviour under some provisions when fm go starts, do I need to jailbreak the iPad, and if I do so is there a solution? Windows If someone’ s made a batch file with all the above requirements, vpn trigger and opening remote, I ‘d love to hear about it.

Relatively new to FileMaker Pro and using version 10. I have googled the topic and spent many hours researching solutions and tried 3 different approaches, all with erroneous results. The database manages employee records. I want to create a script that automatically creates a folder, named by the fields CREW::FirstName & " " & CREW::LastName and located in Documents/Personnel/Crew/Current, after completing the last name field of a new record (i.e. activated via script trigger on this field) and I do not want it to replace a folder of the same name. Latest attempt: Calculated Applescript step - "do shell script \"mkdir /Macintosh HD:Users/…

Here is a part of the old code that gets hung up. It gives the error "Data is being accessed by another user, script, or transaction" when it gets to "set adState" to cell "list State" of current record." tell application "FileMaker Pro" tell document "2015 Database" go to layout "Spec Ads" do script "Find all records" show (every record whose cell "Spec Ad Number" = docName) set adState to cell "List State" of current record if adState = "" then activate beep 2 display dialog "There is no Ad State for this record." buttons {"OK"} default button 1 with icon 1 giving up after 10 …

Loaded Acrobat Pro X onto my Lion machine to discover that there is a big change to the menu structure So if anyone is interested here is some Applescript to Reader Enable a form/ file Requires the file to be open first. Feel free to improve on replace_chars(this_text, search_string, replacement_string) set AppleScript's text item delimiters to the search_string set the item_list to every text item of this_text set AppleScript's text item delimiters to the replacement_string set this_text to the item_list as string set AppleScript's text item delimiters to "" return this_text end replace_chars -- make this whatever path you want set tar…

I want to be able to restrict user to specific Finder folders for import into Filemaker. I also need to rename and move, from a designated folder, Finder folders, from within Filemaker. So far, this is my feeble attempt in AppleScript. I don't know how to be able to work with folders within folders. Thanks for any help. ------------------------------------------------------------ tell application "FileMaker Pro Advanced" set fName to cell "tbl_Doc::UserFolderMN_DocuSet" of current record end tell property ChooseFolder : "Choose Document Folder" try choose folder with prompt ChooseFolder set TargetFolder to the result as alias set SourceFolder to ("…

I have a different document for each product in out inventory. We don't always have this document. The image prints out by using a web viewer layout. This works fine but wastes a lot of paper (when the document is not on the server) and has low resolution. I would like to make an apple script that downloads the jpeg image to a specified folder. At that point I will just setup folder watching and whenever a file hits the folder it prints. I know I can do this with automator but I would like to use applescript so that I can pass the ID number of each unique product. Thanks for help steering me in the right direction. Drew

Hello, I've upgraded from FMP Advanced 11 to 12. In FMP 11 the easy script: Send Email [send via E-mail Client] with its reference email address field was working with e-mail client EUDORA 6.2. without problem. In FMP 12, the script does not connect to Eudora while it works when using Apple own e-mail client "Mail". I know Eudora is an old product but there are reasons why until possible I would like to keep using it, it's there a way to have FMP 12 communicating with Eudora 6.2 to send the command ? Thank you Caronte II Testing that has been performed: Unistall and reinstal FMP 12. Working on: Mac OS: HD:Library:Application Support:FLEXnet Publisher…

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 …

Is it possible to have appleScript push a notification to Mountain Lions notification center?

Hi, I have a script that maker a folder based on the product ID (always unique) and then generates several PDF certificates from a FM record. I then have a script that I can choose the folder (choose folder/set result) to combine all the PDF files inside it into 1 file. I'm looking to automate this process fully, by removing the user step of having to choose the folder. I thought it would be a reality simple process of setting the variable FolderName to the ProductID as I have for making the folder, but I'm getting -1727 errors, parameter is not an object specifier. I feel that I'm quite close to a working solution, but I'm stumbling on something. …

I need to Zip/Compress a local folder with 3 files so they can be attached to a scripted email sent by FileMaker. 360Works plugin is not available to me. I've figured out that I can set a FM script step to perform an AppleScript. I've seen that AppleScript can Compress folders/files. What I can't figure out is this: Where can I find step-by-step AppleScript instructions for zipping multiple files in a folder and can I just paste it into the Perform AppleScript script step? I've located instructions for single files but that doesn't help me. This is all so foreign to me I need the most basic explanations on how to do this. Files will be named differently…

The following script works fine with MacOS 10.6 and Mac Word 2004. My client has moved to MacOS 10.8 and Mac Word 2011 and the script is not working. Can anyone suggest what is required to be changed? I have tried changing 'do Visual Basic' to 'run VB macro macro name' but that wasn't the whole answer. "tell application "FileMaker Pro"¶ tell database "ContactSystem"¶ tell table "ContactSystem"¶ set user_name to cell "ExportMyName"¶ set user_fullname to cell "ExportMyFullName"¶ set user_position to cell "ExportMyPosition"¶ set user_phone to cell "ExportMyPhone"¶ set user_fax to cell "ExportMyFax"¶ set user_email to cell "ExportMyEmail"¶ set policy_…

Im using FM12 and wish to export some data into iCal ver.6 which comes with Mountain Lion. Been playing around with: and managed to get it to work with a button on my layout that will run this script. Is there a way to show on the layout that the button has been clicked and also is there a way to stop multiple clicking, because every time its clicked the script runs and creates another copy in iCal. Thanks in anticipation

Hi Does anyone know of a way to get admin access through an applescript if you already know the Administrators password. I am trying to access a privilege set from applescript

Greetings all, long time reader, first time caller, etc. I've been thinking of the best forum to put this post and it seemed like this is the one for my problem, since it involves extensive use of AppleScript. Perhaps I would get better visibility elsewhere on the board, but I figured why not start here and work from there. In plain english, I'm trying to do the following: 1) select a special text file defined by user input 2) run a perl script that generates an .svg graphic based on that text file 3) insert the .svg into a filemaker image container (not as reference) 4) insert the text file path into a filemaker text field 5) delete the .svg I…

Hi all, here's what I want to do: 1. Executing an AppleScript from FileMaker that will send an iMessage through OSX's Messages: I'm using this simple AppleScript from FileMaker: Open this Scriplet in your Editor : tell application "Messages" send "tobias testar" to buddy "+46709123456" of service "E:[email protected]" end tell It works just fine by itself. 2. Then have Messages.app to report back to FileMaker if the message was sucessfully sent (sometimes I don't know if a certain cell phone number is registered with iMessages or not). This reporting back to FileMaker from Messages is done with setting up Messages to perfo…

(Posted the same question at MacScripter, but it is very specific about FileMaker 12.) Background: A plug-in for some other software (“RagTime”) retrieves data from FileMaker via AppleEvents. With FileMaker 12, I have got a problem. Imagine a simple FileMaker database “contacts” with two tables, “companies” and “employees”. There is a FileMaker layout displaying the address data for a company and in portal rows, the employees are listed. First script example: set fm_db to "contacts" tell application "FileMaker Pro" tell window 1 of document fm_db set my_result to (get data of current record) end tell end tell my_result This returns all values…

Could someone give me some pointers for getting an Applescript to run from within FM to open Messages and address a new message to a phone number (or an email address) extracted from my database. I have tried this tell application "Messages" activate set myid to get id of first service set theBuddy to buddy "téléphone::no_de_telephone" of service id myid end tell Could the same person or another also tell me how to modify a native Applescript for it to run as a Calculated Applescript?

I wrote this bash script #!/bin/bash URL="http://images.server.com/print/1.jpg" RESULT=$( curl ${URL} --head --write-out %{http_code} --silent --output /dev/null servername) if [[ $RESULT = *404* ]]; then echo 404 else curl $URL | lp -o fitplot fi this works in AppleScript editor do shell script " #!/bin/bash URL="http://images.server.com/print/1.jpg" RESULT=$( curl ${URL} --head --write-out %{http_code} --silent --output /dev/null servername) if [[ $RESULT = *404* ]]; then echo 404 else curl $URL | lp -o fitplot fi " I tried to execute with Do AppleScript step but ran into trouble escaping the quotes around the url when defining the calculation…

I am trying to edit a working AppleScript but when I try to save the changes, I get: Expected end of line but found â��"â�� I took the script and dumped it into my AppleScript Editor and it compiles just fine and like I said, this script is running in a FM 10 database app just fine. So, I cancel out and reopen for editing and hit OK and even without changing anything, I get the same error: Expected end of line but found â��"â�� The application was created in FileMaker 10 and I am trying to edit the script with FileMaker Pro Advanced 11, in case that matters. Not sure what to try next... Here is the complete script: -- Ca…

I'm writing an applescript to automate copying data between two databases of different FM versions (11 & 12). I've run into a snag though, which is that I'm unable to determine through AS whether a given field is writable or not. To clarify, I have written code (below) to check whether Filemaker reports the field as being writeable, but it seems that it will report that a calculation field (or cell) is writeable even if it isn't. The two cases I found where this is the case (so far) are if "prohibit modification during data entry" is set on the field, and if it's a calculation field. Are there any workarounds for this? --check cell can be written …

I have a FileMaker server with a couple databases, and I have a few AppleScript scripts to output some of the info into files. My syntax to read a value from a field is tell application "FileMaker Pro Advanced" set type to get data cell "Example Field" of record 1 of window "Example-DB" end tell The window is fine, and I have other lines of script that look like this that work fine. However this line throws an error: error "FileMaker Pro Advanced got an error: Your access privileges do not allow this action." number -10004 The documentation states that (from http://help.filemake...le-event-errors) This doesn't make much sense, as all I'm …

I'm trying to add a header to my bank statement to import it into Filemaker properly, but my script overwrites the first four characters before adding the desired text. I'm quite green with Applescript, and I can't see my mistake. Any help would be appreciated. Here's the beginning of the file before the script (date, amount, transaction type, transaction detail) is run 4/30/12,-63.00,000000399,"Cheque","" and after: ,,, /12,-63.00,000000399,"Cheque","" I wanted to add the ",,, " What's happened to "4/30" ? Here's my script: tell application "Finder" open for access "Macintosh HD:Users:johnnolan:Documents:RandB database FM1…

Hi All, I'm doing an export where some records in my filemaker table will result in the creation of 2 or 3 records in the export, so rather than creating records in an export table, I just appended all my output into a single field and I export field contents as FileName.tab on the desktop. The problem is, the file type/creator tells the OS this is a text file. I'd much rather it be identified as an Excel file, because it opens up perfectly in Excel. Since FileMaker can't do that, I figured maybe I could just use AppleScript to fix the file so it opens in Excel. Can anyone help me out with this? Thanks!

Hi, I have an Applescript that checks to see if FIlemaker Pro is running, and tells it to quit if it's running. Often the script doesn't work for some reason, for example Filemaker is stuck showing a a dialog box and can't receive the quit command. So I am trying to have another part of the script that double checks to see if FMP is still running, like this tell application "Finder" set process_list to the name of every process whose visible is true end tell if "Filemaker Pro" is in process_list then do shell script "killall 'Filemaker Pro'" end if The issue is that *nothing* seems to make "killall" in terminal kill Filemaker Pro, and I alwa…

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) …

Edit: ALTERNATIVE IN NEXT POST. I've tried a few different scripts, but i cannot find the answer to this. using terms from application "FileMaker Pro" tell application "FileMaker Pro" show database "caller" end tell end using terms from The error it gives is "Expected end of line, etc. but found identifier." and highlights database word. What i want is a way to open the required database, and paste in the phone number. I am using BluePhoneElite 2 to get the number, so here is all my code so far. using terms from application "BluePhoneElite 2" on incoming call theCaller with event "ringing" …

Anyone out there know if such a thing should exist either as an AppleScript or a shell command? thanks - Anatole

Hi everyone I apologise - I suspect I am posting this in the wrong place, but I wasn't sure where would be better. I open an image in Preview using this script, but is there any way to control where the image opens? Perform AppleScript ["tell current record try set m to cell "c_Mac_path" tell application "Preview" to open m end try end tell "] Perform AppleScript ["tell application "Preview" activate end tell"] Thanks for any suggestions Milt Mac Snow Leopard Filemaker V11

I would like to have a button in FileMaker that would pass various parameters to Preview or Image Capture for scanning (resolution, flatbed or feeder, color or b/w, scan size, duplex and scan-to location and filename), but these applications don't seem to be scriptable. Is there any way to do this? I did notice in another thread an application called "ScanTango", which is scriptable, but it seems it only works with certain high-speed scanners.

Hi, I'm not sure this is the right forum for this, but didn't really see one that fit better. I'm trying to find a way to have an alias or other file that opens the runtime solution inside its folder, but when I then burn all of that to a CD the alias stops working. I want to do this because my target customers for this runtime solution aren't terribly tech savvy and if I don't basically give them one button that says "click this" (as opposed to trying to tell them to go inside the runtime folder and open the exact file they need to open) they'll get confused. I downloaded DMG Packager, which works great to create the dmg file (in which the alias does work …

I have a multi-user database in Filemaker. I frequently use AppleScript to automate tasks between several databases. tell application "Filemaker Pro" tell document "theDatabase.fp7" tell layout "National Geo" go to set artNumber to cell "NG_ArtID" end end end When I run the above script as a user, I get "Filemaker Pro got an error: Your access privileges do not allow this action." The user account has full access to that layout and to the table that ALL of the fields on that layout are from. When I run as an admin, I do not get the error. Any idea what access privilege might not be set properly?

I have an AppleScript running without problem until I upgraded my OS to Lion. Now it gives me error code -2740. Have anyone encounter similar error ?

I'm working on an applescript to return data to filemaker, and I'd like to be certain that it's absolutely positively going back to the right record. Originally I was using the "record number" and the applescript syntax "tell record ###" and that seemed to be working. But occasionally the result isn't returned so in troubleshooting this sporadic issue I found that the "record id" should be a unique specifier for the record and "record number" is not. I thought using the "record ID" would be the preferred way to do make sure I'm calling the correct record, since the "record number" is relative to the current found set and in theory *could* change. So I be…

Hi Is there any way (Applescript, SQL via Filemaker ODBC or anything else) to automate the modification of a Filemaker database schema? I know that SQL CREATE TABLE and ALTER TABLE are possible but I am also looking at creating/modifying RELATIONSHIPS between tables. I do not think this is possible via SQL. The purpose is to automate the upgrade of a Filemaker database (vs. repeating each change manually using the "Manage Database..." dialogs). Thanks!

Can some one please help me. I have a filemaker script which is used to scan documents into a folder. I do not have any applescript skills and don't know how to pass FM script variables to applescript. I have a variable $Scanpath which determines the path to the file and another $Filename which gives it a name How can I pass these values to Applecript My attempt which does not work is: set theScannerSetup to "Scan SS 1 BW US Letter Page" set pathToFolder to "$Scanpath" set fileNameBase to "$Filename" set fileNumber to 1 tell application "ScanTango" -- Scan a document scan with setup (scanner setup theScannerSetup) -…

Dear friends, I am trying to work with 'Color Palette'. But I am unable to work with it. Actually my need is that. I need a color palette, from where I can select the color. The color must be viewable in a container field. Or I want to set the font color or background color of a text field, dynamically on the layout only in browse mode. Please help me. I am not getting any logic regarding that. Thanks in advance.

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 apples…

New to filemaker, and applescript for that matter, here and I have run into a problem while trying to make sense of some of the old scripts. There is a problem with one of the applescripts within the fm scripts. I will paste the script below but basically it is looking for a folder on the users desktop and copying it to another drive and vice versa, this part seems to work fine. It seems to have a problem when a flag field in the database is set, using “set cell”, to indicate if the folder was found or not. I’m getting an “object not found” error. The odd thing is that we are upgrading from FM 5.5 to 11 and it works for the users using 5.5, but only gives me the error…

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…

I'm trying to setup an error capture method for catching errors from an AppleScript that will be called from FileMaker. The test script is listed below. This script works fine using Apple's Script Editor but I get an error trying to add this script to the Perform AppleScript step in FileMaker. I'm trying to enter the exact script into the Native AppleScript field in the Perform AppleScript step but get the following error on the write command: "Expected end of line, etc. but found """. Does the write command need a different syntax than the normal AppleScript syntax? try return 100 / 0 on error set fp to open for access file "Macintosh:User…

How should this SendEvent be coded for Mac users? Thanks.

Hello, I am trying to write a calculated AppleScript. The AppleScript I am using is as follows: set theTime to 5 do shell script "osascript /Applications/BioasysSendMail.scpt " & theTime & " &> /dev/null &" If I run this as a native AppleScript in a PerformApplescript script step it runs just as expected. However I want to be able to calculate the number (in this example 5) in the first line from a time field on one of my layouts. I am essentially converting the time into total seconds. Here is the code I am using which converts the time into seconds: Let([ totTime = BioasysScriptProgressMonitor::OneSD; hourSec = Hour(totTime) * 360…

I have this script that works ok when Ii run it from Applesript editor. It brings ne the pdf box I´m after. I want to run this script inide Filemaker, but can´t get it to work.. What am I missing here.. ?? Thanks for any tips on how i can make script like this work. ------------ on run set fs to choose file of type "com.adobe.pdf" with prompt "Select one or more PDF files to process:" with multiple selections allowed my process_files_(fs) end run on open fs my process_files_(fs) end open on process_files_(fs) repeat with f in fs tell application "System Events" to set finfo to the properties of f if kind of finfo i…

Hello, I have a database that runs every weekday which takes about 14 hours to run. I have a layout that monitors the progress of each of the multiple scripts (38 in total) in my database. This progress monitor layout has a field for each script in the database so that when each of the 38 scripts is completed the corresponding field is marked with a timestamp. In addition to the completion timestamp field each script also has a field that that upon completion of the previous script an estimated completion time of the current script is calculated and placed in the estimated completion time field. The purpose of this is to be able to monitor the progress of the multiple scr…

I have been developing a script that employs a couple of small AppleScripts to drive 'manage layouts' actions within FileMaker that are not currently scripted (pushing the boundaries a bit again)! The process is to duplicate a layout and rename it, storing the layout details (ID & name) in a table list of all the layouts. The problem I have is that the script I have written runs perfectly step-by-step in the debugger, but usually fails* if I let it run through normally. Even if I put great pauses between each step in the script it still fails. The problem seems to be down to any scripting that I place after running the first AppleScript. Without any complex …

Hi Not sure if anyone else is having this issue. I have many send event steps which relate to applescript apps. Everything has been fine and worked on Snow leopard I have since had to rewrite a couple of scripts and recompiled them in Applescript 2.3 (Snow Leopard) Since then I cant get the Send Event script step to specify the application. It still recognises previous apps but not the recently compiled ones Any answers greatly appeciated?

I wrote / rewrote the script below, which dumps the FM contact into Address Book. It stopped working (not sure if it was when I upgraded to FM advanced 11?) Any ideas why? I have another script that dumps info in iCal and that still works fine. -- grab the data from Filemaker tell application "FileMaker Pro Advanced" tell current record set theFirstName to cellValue of cell "Customer FirstName" set theLastName to cellValue of cell "Customer LastName" set thePhoneMobile to cellValue of cell "Phone_Mob" set thePhonehome to cellValue of cell "Phone Home" set thePhonework to cellValue of cell "Phone work" set theEmail to cellValue o…

Hi, I need help... I have this applescript in a calculated field in filemaker: "tell application \"Finder\"¶" & " delete file \"Snow Leopard:Users:ton:Desktop:blabla:blaimport.txt" &"\" ¶ end tell" What is the syntax to replace this file path with a fieldvalue or filemaker variabele???

Sorry I posted in the wrong forum before: Is there a way to trigger already working Applescripts for QT in a FM database using container as a results? Example: [Applescript] property TimeOffset : 0 tell application "QuickTime Player 7" tell document 1 to set {currentTime, timescale, theDuration, FrameCount} to {current time, time scale, duration, count (every frame of track "Video track")} end tell set INPoin to currentTime [/Applescript] How to put the various results: currentTime timescale theDuration FrameCount in different fields in fields in FM Pro 11 System events allows dealing with QT7 without opening the f…

Is there a way to trigger already working Applescripts for QT in a FM container? Example: property TimeOffset : 0 tell application "QuickTime Player 7" tell document 1 to set {currentTime, timescale, theDuration, FrameCount} to {current time, time scale, duration, count (every frame of track "Video track")} end tell set INPoin to currentTime How to put the various results: currentTime timescale theDuration FrameCount in different fields in fields in FM Pro 11 System events allows dealing with QT7 without opening the file. Is it possible to call SYS EV from FM scripts including the appropriate Applescript and transfer t…

Hiya Have posted this in this forum and also on a mac one... I need a script that will open all the FileMaker files in a specified folder logging in with specific credentials. I've written the Applescript shown below however I'm still being prompted for a username and password despite explicitly scripting it in and I get no errors from the script... Script is below: set thefolder to choose folder tell application "Finder" set numberoffiles to count every file in folder thefolder set thefiles to the files of folder thefolder whose name contains ".fp7" set accountdetails to "Hanna" repeat with thisfile in thefiles tell application "File…

I have an Applescript that moves data from FMP to Address Book. It works fine, except when data is missing in FMP. Here is the Applescript: tell current record set theFirstName to cellValue of cell "name_first" set theLastName to cellValue of cell "name_last" set theTitle to cellValue of cell "title" set theOrg to cellValue of cell "company_name" set theAdd to cellValue of cell "shipping_address_1" set theAdd2 to cellValue of cell "shipping_address_2" set theCity to cellValue of cell "shipping_city" set theState to cellValue of cell "shipping_state" set theZip to cellValue of cell "shipping_zip" end tell tell application "Address Book" …

Dear All, I have created applescript till the point from "fetch data from filemaker fields to address book and get id of that person to filemaker database and also delete that particular contact by using Person ID. Now the thing is that i want to find particular contact by using Person id and then modify all fields of contact like first name, last name, organization, phone number etc. Please give me applescript code for that. i have lots of tried for that. …

Does anyone know how to change the syntax of this shell script to use it in a calculated AppleScript in FileMaker? #!/bin/bash # change to internet plug-ins directory cd /Library/Internet\ Plug-Ins/ if [ -e "AdobePDFViewer.plugin" ] then # if viewer exists move it to disabled plug-ins directory # (create directory if needed) mkdir -p Disabled\ Plug-Ins mv AdobePDFViewer.plugin Disabled\ Plug-Ins/ echo "plug-in has been moved" else echo "nothing to be done" fi The AppleScript should probably look something like this: List ( "set fileMoved to false"; "try"; "do shell script (.....)" …

Hi everyone... When writing an applescript embedded in a "Perform AppleScript" step, is there any reliable way to address the FileMaker application in a tell block or similar? The problem is that if you tell application "FileMaker" or tell application "FileMaker Pro" or tell application "FileMaker Pro Advanced" and the end user does not have that exact version of FileMaker, the AppleScript system will ask the user to pick the intended application. The situation is even worse if you're trying to make a runtime application. I thought I had come up with a working solution as follows: tell application "System Events" set appname to name …

Has anyone used AppleScript to attach multiple images to an outgoing mail message? I'm exporting multiple images to the user's temp folder in FileMaker 9, so I know the paths. I can create the message with the first file attached using the Send Mail script step. I thought for once I'd ask if anyone has done this before I attempt it on my own. I know basic AppleScript, but it never seems to work quite the way I expect it to. I'm pretty sure it can do this. (I'm open to non-AS ideas too.)

Dear All, I want to know "is it possible by using applescript directly we can export all the records from address book of Mac system to Filemaker ?" Although i have implemented this solution by using "Address book Exporter" tool which first convert Address book into .Txt file and i just opened this .txt file into Filemaker, and it is working but this is not the way that i want to do. i just want by only button click it do all this export work all. Thanks in Advance,

Hello, I am trying to write an AppleScript script that takes the contents of my clipboard and creates a text(.txt) document from it. I have tried using the built in "Save a Copy As" filemaker script step but it converts the text document into some type of Unicode format that the Python script I am running the .txt document on doesn't recognize. So I have written an AppleScript script which compiles and runs correctly when run from the AppleScript Editor but gives an error message if I try to compile it within the "Perform AppleScript" Script step in FileMaker. Here is the AppleScript: set theText to (get the clipboard as text) set theFile to (open for access file …