AppleScript & Automator

I am trying to find a way to script in to filemaker the ability to start and stop a screen recording session. All of my users are Mac, which means I'll probably be using Quicktime X's native desktop recording ability to accomplish this. I have been struggling with Applescript Editor for hours now trying to put together a test script that simply Opens Quicktime, starts a screen recording, pauses 2 seconds, stops the screen recording, and then saves the resulting movie file into the /temp directory. I have everything working fine except for the save portion. Sadly, Apple's documentation on Applescript Editor is woefully lacking on the dictionary for Quicktime X. Af…

I have a applescript that use to work but is no longer working, very simple. property DB : "CBA Jobs.fp7" property aPO : "046860" tell application "FileMaker Pro Advanced.app" activate try show (every record of DB whose cell "Media_Bank_PO_Number" is aPO) on error show (every record of DB whose cell "Media_Bank_PO_Number" = aPO & " - Datatrak") end try end tell The po exists on the database. I can do a manual search. But when I trace the code it jumps to on error. Any help will be greatly appreciated. Sam 10.5.8 server FileMaker pro advanced 9.0v3 I tried FileMaker pro 11 as well with no luck DB is remote

When I open the file "matters.fp7" or run this script: tell application "FileMaker Pro Advanced" activate open "Macintosh HD:Fees_Program:Fees Data:matters.fp7" end tell I get the message: "FileMaker cannot share files because another user is already sharing files using FileMaker Pro on this computer." Clicking "OK" opens the file and it appears full functional, but, of course, the script hangs because of the dialogue...... I am not running FM Pro Server - I tried to install a trial and struck problems. I have uninstalled it using appzapper (makes a great noise!). What's the John Dory (i.e. story)?

Has anyone been successful at applescripting iTunes to load FM databases to Filemaker Go?

This script works when executed within AppleScript. However, I am having an error when I try to run it in FileMaker. FileMaker Pro does not let me save it. It signal an error with the Write statement. If I put the write statement a COMMENT "--", I do not have an error. set theEVEclient to {} set theStart to 1 set theEnd to 4 repeat while (theEnd is less than or equal to length of theEVE) set theEVEclient to theEVEclient & (text theStart thru theEnd of theEVE) set theStart to theStart + 5 set theEnd to theEnd + 5 end repeat try set fileRef to open for access file theOrder with write permission …

Dear All, I have to import all addresses from TO and CC, of Outlook email to Filemaker any field or any excel file. Please tell me the applescript for this. Thanks you so much... :

I am reading a folder and want to add in a FileMaker Pro table "inFIle" a record for each file found in the selected folder. A cell called N°Prefix is to be initialize using characters 5 thru 8 of a filename. However, there are instances where the content of N°Prefix might already exist in the "inFile". Before creating a new record I would like to verify if that record already exist. N°Prefix is to be unique and could also be indexed. What would be the syntax for verifying if a record already exist? or where could I read/find more information about this. Also, could this script be triggered by clicking a button inside filemaker pro? Thanks! Dani…

Does anyone see where the syntax in this calculated Apple Script is off? It returns two errors: 1. "Expected """" but found unknown token 2. Unknown Error -2741 Here's what the code looks like: List ( "set fileExists to false"; "try"; "do shell script \"-e '" & $path & "'\""; "set fileExists to true"; "end try"; "tell me to set cell \"result\" of layout \"Developer_Settings\" to fileExists" ) What I'm trying to accomplish is simply check if a file exists in a certain location. The $path consists of: Get (FileMakerPath) & "\Extensions\Troi_File.fmplugin

Dear Forum Members I am trying to create a simple iCal integration with FileMaker. I think it must be fairly easy to: -request available calendars -create an appointment in that calendar The main goal is to sync iCal to the iPhone / iPad My sample file hangs somewhere - my AppleScripting knowledge is low. Any help about this? Thank you so much, cheers

Does anybody know how to write an apple script that would check if particular FileMaker file is open at the moment? Thank you !!!

Hello All, I am working on application that will connect with FileMaker and for this I want to Automate following tasks in FileMaker: 1) Create Database 2) Insert data in database tables. I have idea of automation on MS Access on Windows but as application is being developed on Mac OS and I am new in Mac so I could not find anything about Filemaker Automation. Plz help me out.......... As I am struck at initial point .......... Waiting 4 soon reply Thanks Aarti

is it possible to use the data from a photo taken from an iPhone in filemaker pro to get location data?

It's a pitty that the open URL function doesn't have a Blank option (without the http://). This way it would have been possible to use URL launch codes like these: ymsgr:sendim?USERNAME (Yahoo) aim:goim?screenname=USERNAME (AIM) trying to gather more... These do work within a webbrowser but not using the FM script open URL. A pitty because it would be both platform compatible. For the mac there might be an Applescript solution. But I'm not so experienced in it. Perhaps it's easy and you can help me launching it.

Brand spanking new to the forum and to FM. I've spent quite a bit of time here already and have learned a ton already - Great Community! Worth mentioning...I did search forums but was unsuccessful. My basic need: I am trying to figure out how to keep a script running in FM (which I have created) while other apps are being used (i.e. FM running in "background). The script runs, loops, and functions while FM is my active app without any issues. More detail: Specifically, I have an attendance component on my database. As part of this I have barcodes generated, these barcodes are scanned generating an attendance record in a table. *This much, with help from this f…

Hi everybody! I am pretty new on mac and filemaker developping, I need to read the GPS exif data from a picture to fill in a cell in my database in filemaker. The plan was to use Imagine photo through an applescript and execute it with the 'Perform Applescript' in Filemaker. When I run the applescript in the Applescript editor, it works correctly. When I try to copy past the applescript, in filemaker, with the 'Perform Applescript' option, checking the box 'native applescript', I get an error of sintax on the script. Let's try with the following simpler script, I get the error "Expected end of line, etc. but found identifier" on the word 'graphic' of …

I am trying to debug an applescript that I would like to work automatically with Mail rules. I have a manual version of the script that works perfectly. So would anyone know why in the following script tell application "FileMaker Pro Advanced" activate say "FileMaker opened" if exists database ¬ "•_reservations_Petit_Globe" then say "file opened" show database "•_reservations_Petit_Globe" else getURL "FMP7://[email protected]/•_reservations_Petit_Globe" delay 10 say "file opened" end if show layout "import" say "layout opened" try delete every record end try say "deleted" end tell this work…

Hello , By using Applescript script step i want to copy all files from folder name "anj"(Folder name is constant)which is onto Public folder & paste all files into another folder having name "anj" which is in Library folder .if any file is existing then without giving any message it will overwrite that file. Thanks,

How do i open cash drawer using filemaker. I have a printer connected to cash drawer. All i have to do is send DEC(7) to the printer so that the cash drawer will open. Any idea on how to do that?

I am trying to have FM run an applescript then wait for the script to finish before continuing. I tried using "Pause Script" but then it's the problem of waiting to long or to short depending on server traffic, memory, blah, blah...I also tried running the script using "Send Event" and run the script as an application (only because of the Wait for Event feature) . It lets me choose the script/app in the finder but it does not carry into the "Send Event" Options. I know there has to be a way to do this but I'm stumped. Any help would be greatly appreciated.

HELP!!! : I have a converted solution that uses AppleScript to send emails via Entourage. It seems to fail when trying to pass a value back to FileMaker. Here's the original applescript code where the failure is occurring: set cell "g_num" of (current record of database "Correspondence.fp5") to theValue I played around a little and found that if I changed it to something like this: set field "g_num" of table "Correspondence" of database "Correspondence" to theValue I have been able to create a scratch file where I get this to work, but I can't seem to pass a value back to the hosted "converted" file. Any help would be greatly apprec…

Hi There, Does anyone know if it is possible to return an automated filename and filepath for the file selected in a container? It currently has to be entered manually - which can be laborious? It would also be helpful to be able to select the creation and modification date (guess this is asking the impossible) but it would make life really easy if I know how. Your help is very much appreciated as I am fairly new to FM and programming.

Hi, We just installed a new mac mini server which will be used to host our FM files. The files were before on a Windows server with FMS11. There was a VBScript that copied the backup files which were local to a remote folder. Is there way I can use the same script? or I need to redo the script with AppleScript? I really don't know anything about AppleScript. Is there a more developer friendly language, i.e. a standard scripting language (VB, JavaScript, C, ...) Thanks

Hi everyone, I'm looking for a way to create thousands of folders in Finder, which will be named after an ID Field in Filemaker. I have a contacts database,with a unique ID, and i'd like to create one folder for each contact to store in the emails and other documents. Every contact folder would have the same structure : 000001 (root folder, named after contact_id field in filemaker) -->2009 -->2010 -->2011 After the first creation of folders, the script would create a folder everytime a contact is created, and therefore , delete it everytime the contact is not found. Is there a Filemaker Script? or Applescript? Many many thanks in…

I am trying to find out the best way to process, in a script, whether a network file path is valid. Can I do this natively in Filemaker or am I going to have to do this in Applescript?

I'm trying to command a fairly long external Applescript to run from within FileMaker. Tried using a calculated Applescript like > "Run script ". This works however FileMaker will wait for the script to complete before continuing with the local FileMaker script. This is a problem as the external AS sends events back to FM - which won't respond until the AS finishes. Catch 22. Thought about compiling the script as an app and 'opening' it but the script seems to 'hard code' file paths when saved as an app - making path references in the AS invalid on deployed systems. Any Ideas?

how can we develop plugins in file maker. is there any document or guidelines is available. please help me out.

Is there a way to automatically open a FMP file remotely? It is a little cumbersome for users to: >go to file >open remote >choose host >choose file Would like to automate all this for the user upon computer startup. Any ideas on how to do this? Most of us are on OS X v.10.5.8 Thank you for your help! :)

One of the great features of Filemaker Pro Advanced is using the clipboard to copy and paste field definitions, table definitions, scripts, and script steps. Filemaker uses XML to structure the clipboard contents. You can read the contents of the FileMaker clipboard and convert it to text and place it in a field. You can also take properly formatted text and put it back on the clipboard so that it can be pasted into field, script, or table definitions. The technique described here requires applescript Here is how to get data from the clipboard and pop it into the field "XML" -- script start -- get FileMaker clipboard -- put as text in fi…

Hi I am using an Apple Script to make a Calendar event in a particular calender and all works fine in Mac OS however I cannot seem to get it to work in the FM database. All of the variable like current date, Event Description, Event name will come from fields in a the database. Any help will be greatly appreciated. thanks Duncan Apple script is below. tell application "iCal" tell calendar "Contracts" set theDate to date "Thursday, 27 May 2010 00:00:00" make new event with properties {description:"Event Description", summary:"Event Name", location:"Location", start date:theDate, allday event:true} tell application "Finder" …

Video of my session on applescript + FileMaker at PauseOnError/Portland.

HI, can we count the number of records using apple script of any other application like Address book,number of mail in apple mailer etc. plz help me out. Regards, John

code is as set a to field "Accession_Number" of table "RIS_PatientRegisteration_Mst" of database "RIS" as text tell application "Finder" Tell Application "Osirix" to activate end tell tell application "System Events" tell process "OsiriX" Try tell menu bar item "File" of menu bar 1 click tell menu item "search" of menu "File" to click end tell end try set b to 0 keystroke a set b to count Studies ----this is the line where i want to show no. of records of osirix--------- say b if b exists then say "anjali found" else say "not Found record ok" end if end tell end tell

I am able to push data from FMP to Address Book via AppleScript: tell application "FMPA 11" tell current record set theFirstName to cellValue of cell "name_first" set theLastName to cellValue of cell "name_last" set theOrg to cellValue of cell "company" end tell end tell tell application "Address Book" etc. But what happens if the Company is not in the current record, but is a Parent Record (e.g. one company has many people). Is it possible to set a variable to a Parent Record? tell application "FMPA 11" tell current record set theFirstName to cellValue of cell "name_first" set theLastName to cellValue of cell "name_last" se…

I have a rudimentary AppleScript that sends data from FMP to AddressBook (using Perform AppleScript/Calculated AppleScript): Let ([ _qt = Individual::Qmk; //Quotation Marks _fn = _qt & Individual::name_first & _qt; _ln = _qt & Individual::name_last & _qt]; "tell application "Address Book"¶ set newPerson to make new person with properties {first name:" & _fn & ", last name:" & _ln & "}" & ¶ & "save "addressbook" ¶ set AddressBookId to id of newPerson¶ end tell¶ delay 1¶ tell application "FMPA 11" ¶ set cell "AddressBookID" of current record to AddressBookID¶ end tell" ) (There i…

We're looking to improve our help system in Filemaker. We think the best solution is to have the relevant page in our pdf manual open when help is invoked for a button or layout. My question: is there a way to tell Preview (the pdf viewer app in OSX, not the Filemaker mode) to go to a certain page once we tell the finder to open the doc via applescript? I'm reading that Preview is not fully Applescript supported, so not sure if its possible. Any other simple solutions to this would also be appreciated. We really don't want to embed the help system in Filemaker at this point unless there is no other choice.

Here is what i would like to happen. User Clicks on a File say FileName.ext The opening of the file FileName.ext triggers to opening of MyDatabase.fp7 and runs a ScriptMaker Script (The same one every time) and the ScriptParameter of that script is the file path of the file that was opened. (so i the file can import it). Ideally i would love to do this on both platforms but OS X is primary. Have no idea if is really possible. Is an Apple script App the way to go? Any thoughts on any part are welcome Thanks

Hi, I try to add some external functions to my filemaker project. Using AppleScript. When i want to calculate my script i keep running to that i can't use " as a text. I made it now working with a text field with " in it. But is there a more commen way to do this ..?

I'd like to set the default printer using applescript, so that I can print w/o the dialog from a script in filemaker. I'm using FM 9 & 10 in snow leopard. I came across the following script, but cannot get it to work properly. Can someone please help!!! tell application "Printer Setup Utility" set printerlist to name of printers set oldprinter to name of current printer end tell set printerchoice to (choose from list printerlist with prompt ¬ "Which printer to be default?" default items oldprinter) set myprinter to (printerchoice as string) tell application "Printer Setup Utility" to set current printer to myprinter

Hello, I am trying to create an applescript that will embed an image into a thumbnail field. I currently have a script that "links" an image to the thumbnail field, but I need it to be embedded. (My script is run from within Filemaker Pro.) tell application "FileMaker Pro" set documentID to cell "Doc_ID_D" of current record set documentIDfile to documentID & ".jpg" end tell tell application "Finder" set thumb_file to "Macintosh HD:Users:moomoo:Desktop:_THUMBNAILS_MASTER:" & documentIDfile as alias end tell tell application "FileMaker Pro" activate set cell "Thumbnail" of current record to thumb_file end tell Tha…

Situation: I'm calling an applescript to create and save a new Word Document with a calculated filename. Now I would like to store this file (just the reference) directly to FM into a Container field. Problem: First I tried with FM script "Insert File" but I don't know how to define the source File, because the filename is based on a calculation Second thought was to store the reference with applescript but there is the same problem. any ideas? by ChiSao

hey, I am a newbie on applescript and I need some help. I need an applescript to be able to grab the filename and its related path from a folder and place it in a filemaker variable script step. also the applescript or fm script will need to be able to run if there are more than one file in that folder. help please? thanks

How do get a Filemaker script to wait while I have a Perform Applescript step convert a long audio file using iTunes. I need filemaker to wait because the rest of the filemaker script uses the results of the applescript step. I would like to do this without user input. thanks for any ideas

Just what to know if this is possible. We currently have multiple FM layouts that the user fills in. From this information we create spec packs for China, these can contain anywhere from 10 to 20 PDF pages. We had an issue where in the print process it would start flashing between layouts as it was creating the appended PDF spec pack. We nullified this by making the print happen in a 5px X 5px square stuck in the upper left corner. When it was done everything would go back to normal. My questions would be.... 1. Can this printing be done via Applescript? 2. If so how involved would it be? 3. Would this eliminate the layout flashing? 4. Is it possible to "SUBMI…

I am trying to run an applescript (below) from within a filemaker script where the first set of quotes (which is the patch "David:Documents:test:xfer") is the value of a filemaker field. I have done this before with: set x to cell "myField" of current record... and a do shell script command, but that does not seem to work here. Any help here would much appreciated. Also should I be using Native AppleScript of Calculated AppleScript? set folder_to_alias to "David:Documents:test:xfer" as alias tell application "Finder" to make new alias file at desktop to folder_to_alias

Hello, I am trying to execute an AppleScript using a Shell command (via Troi File), because the "Perform AppleScript" command in ScriptManager is not server compliant. While I can execute other Shell commands I can't get 'osascript ' to work in a server script. It works as expected in a client script. Has anybody got success with calling AppleScript from a server script? Regards, Mogens

Hi everyone! Does anybody know if it's possible to mark an event in my FMP9 database and sync automatically with iCal? I want to mark a new event in a calendar field that i have and make iCal (from MAC OSX) automatically create a new event at the exactly day. All be very glad if you guys help me! Thanks a lot!

The file I am using is stored on our work server. It is accessed by those using Macs and PCs. For PCs the script works fine without any problems saving to the server, but I cannot get it to save to the server using a Mac. The FileMaker Script I used for PCs is: Set Variable [$date; Valule:Let (today = Get (CurrentDate); Year (today) & "_" & Month (today) & "_" & Day (today))] Set Variable [$time; Valule:Let (time = Get (CurrentTime); Hour (time) & "_" & Minute (time) )] Set Variable [$filename; Valule:Get ( FileName ) & "-" & $date & "-" & $time & "-" & Get ( AccountName ) & ".fp7"] Set Variable [$outputpath…

Hi sir, i want to make installer for a filemaker file. just like when we open installer of filemaker set up or any other application. how can i make such type of installer in mac.

My applescripts don´t work after converting from FM 6 In FM 6 something like this worked: tell application "Filemaker Pro" set Mappenavn to cell "Ordrenr" of current record as string In FM 10 this doesn´t work unless the field "Ordrenr" is on the layout that are visible when the script runs.. This is quite funny since the "Ordrenr" of current record is unique?? I have to be able to call this field from any layout??

Hi there, I'm posting this here because I *THINK* it's a job for Applescript but I'm not sure... I have a portal with file references in it-- between 3-12 file references depending on the record. I'd like to give the user a button that will export all the files that are referenced to one zip file. Any ideas about how I could pull this off many thanks in advance! :(

Hello, I've been digging but can't seem to find a solution, so hopefully someone can help. Thanks, in advance! In a folder, I've got several csv's and many more jpg's. Each csv contains about 40 fields of data. Each csv is followed by 1-10 jpg's, most have 10. The files are all in the same convention: _data_yyyymmdd_hhmmss.csv _yyyymmdd_hhmmss.jpg I've played around and got an automator thing setup to bring all the data csv files together, and then I import into FileMaker. However, rather than doing that, I'd like to have a script run through the whole folder: 1- import data csv 2- import jpg's into photo containers in that record. If importing a …

I am running a pretty simple applescript which counts the items in a folder that it is passed from a filemaker record, then returns the value to a cell. the script is tell application "FileMaker Pro Advanced" set mybox to cell "path" of current record end tell tell application "Finder" activate set numberfiles to count of (files in folder mybox whose name extension is "emlx") end tell tell application "FileMaker Pro Advanced" activate set cell "number" of current record to numberfiles end tell This works when I run it with script editor but returns error 10011 (Data is being used by another user, script or transaction) …

Hi. I'm trying to integrate a type of CMS into my database. On a click of a button I want to create a folder from the relative path of the current database file. I'm pretty advanced in applescript so I'm not asking how to create a folder/file, but I can't seem to find a property or function for FileMaker to retrieve the current DB path. If I could get that I would be able to extract the relative path. Has anybody ever crossed this path?

Hi I need to have a text field displaying a folder path and a simple button to open that folder in finder. My problem is that I don't want to just type the path in the field. I need to be able to select the folder in finder. And then, of course, use the button to open it. I haven't use applescript before and I don't know where to start. Any help?

I am trying to use an FM10 runtime to launch an application from the MAC 'Downloads' folder using the 'Perform AppleScript' script step and the 'Calculated' option. When executed, I get an error message "Access Not Allowed". How can I get around this? TIA

Does anyone know of a way to link an email (Mac Mail) to a filemaker record? Ideally I would like to view one or many connected emails by clicking and having the email show up in a container field, or the text content being displayed?

Hey there, In one of my solutions I offer the user to insert a file into a Filemaker record. Each of my users has his own folder from where he can choose the files that he wants to insert. To make sure that every user can choose from his own folder, I attached an AppleScript that gets called from a Filemaker script: AppleScript opens the correct folder (based on the user's name), tells Filemaker what file the user has chosen, and Filemaker does the rest. (This technique is based on Fenton's work (http://fmforums.com/forum/showtopic.php?tid/199641/). One thing is fairly annoying though: Every now and then, while the AppleScript is being executed and the Choo…

I have a few different email accounts and need only a certain one for FileMaker emails. How do I change the account using Applescript? TIA

The following Applescript step will insert a reference to a file into a container field > set cell "MessageData" of new_rec to file aPath where aPath is defined as > set aPath to "file:../../../" & POSIX path of aFile Is it possible to script FileMaker to insert 'the data' of a file into a container field rather than just a reference.

I have the following line in my script: click menu item "QuickTime…" of menu 4 of menu bar item "Insert" of menu bar 1 But this doesn't work. This is the error: error "System Events got an error: Can’t get menu 4 of menu bar item "Insert" of menu bar 1 of process "FileMaker Pro Advanced". Invalid index." number -1719 from menu 4 of menu bar item "Insert" of menu bar 1 of process "FileMaker Pro Advanced" Could someone tell me the what am I'm doing wrong here?

Hi, I have a database where I imported a list containing various several files from different applications I use. I am tring to create a script which will allow me to open one of these file with its corresponding application. However I am unable to do so from FMP I think I need to create an applescript where using the parameters I have in different fields of the db will tell the finder to open the file I choose. I have the file name in my first field and the complete path in another, so I think in my script I need to tell applescript to open something like /Volume/Pathfiled/Filename is this a correct? ( I never used applescript so I don't know how) Thanks…

Hi-- I have the following AS I'm trying to use in a script to download audio mp3's from my jott account. Here's what I have so far, under Send Event: "set the target_URL to " & jotts::listenURL & "¶set the destination_file to " & ""'Macintosh HD/Users/jeffrey/Downloads/'"" & jotts::Title & "mp3"" & "¶tell application " & ""URL Access Scripting"" & "¶download target_URL to file destination_file replacing no" & "¶end tell" I then specify the Application as Apple Script Utility. But when I run this nothing happens. I then tried to run the same thing in AS itself, using real url's instead of the fields, and I get …

Hey all, I'm trying to set variables in AppleScript as properties of the message that is currently visible in the preview pane (currently selected). Here's what I've got. tell application "FileMaker Pro Advanced" activate open "path:FILES.fp7" end tell on open theDropped repeat with oneDrop in theDropped tell application "Finder" set thePath to oneDrop as string end tell if thePath contains "apple.mail.drag" then tell application "Mail" activate set theSender to sender of message end tell display dialog theSender end if tell application "FileMaker Pro Advanced" …

This used to work under 10.5.x, it would list all the local and networked printers when executed as a calculated applescript: "tell application " & Quote("FileMaker Pro") & ¶ & "set theDoc to item 1 of (documents whose name starts with " & Quote(Get ( FileName )) & ")" & ¶ & "set cell "& Quote("LocalPrinterList") & " of current record of layout " & Quote("devOfficeLocations") & " of theDoc to do shell script " & Quote("lpstat -a") & ¶ & "end tell" Now I get "A "" can't go after this identifier." Unknown error -2740. HOWEVER, if I take that script, paste it into FileMaker's Data Viewer it sho…

Hey, I use AppleScript to insert files from specific user folders into our Filemaker solution. The AppleScript (taken from the calc box of Filemaker) looks like To make it clearer, gFilePathAppleScript was: ... :2009/08 GPS:GPS.pdf The result of my calc was accordingly: ... /2009/08 GPS/GPS.pdf However, what I would have needed was: ... /2009[color:red]%2F08 GPS/GPS.pdf So, my question is, how can I convert AppleScript file paths into Filemaker file paths including slashes? My solution so far is a new calculation: "set Mac_path to (choose file without invisibles default location alias "Macintosh HD:Users:MJ:Documents:") as Unico…

The technique demonstrated here is quite cool: http://www.macosxautomation.com/applescript/linktrigger/index.html The idea is that you create a little applescript app, set it up with a special protocol, and then trigger the applescripts with special URLs. The applescript app is an OSX package. Inside the resource folder are script files that get called by the main script file. All very cool, and you can have it talk to FileMaker if you write a bit of applescript. Then I realized, well, the Resource folder is full of these little script thingies. Fine. How about I create a runtime FileMaker app and put THAT in the folder, and call it appropriately with scr…

This is a very basic question, I know, but I am having a devil of a time using Applescript to send field contents to another application. I have a field called Applescript1 which is a Global field and it contains the first part of the Applescript code: tell application “Dialectic” dial number “ I'm using a script parameter to capture a phone number field. Here is the Calculated Applescript: Dash::Applescript1 & Get ( ScriptParameter ) & Dash::Applescript2 Here is the contents of the field Applescript2: “ end tell When I run the script I get the message: "Expected end of line but found class name" Unknown Er…

Can I take the outcome of an AppleScript script step directly to a viable in any way. I am using do shell script "curl http://myserver/someinfo.php" and would like to perform a calculation on the result without having to take the result to a field. Thanks, ft.

Is there a way to set the File Options for an FMP database using Applescript? Specifically, I need an automated process to check "Log in using:" and then enter an account name and password.

Our database has a script that adds a PDF file to a record so it can be sent by email (via the mail.it plug-in). The AppleScript is very simple: tell application "FileMaker Pro" set theFilePath to cell "InvoicePDFAttachment" of current record set the cell "InvoicePDFAttachmentContainer" of current record to (file theFilePath) end tell One of our client computers was upgraded to Snow Leopard and this script now fails when it gets to the Perform AppleScript step, the error says: FileMaker Pro got an error: Object or property is the wrong type. If I try to edit the AppleScript in the script step on the client running Snow Leopard it error…

This is an example file which can get the files (and optionally) folders of a chosen folder. It can then optionally Insert them into a container field, using [x] As reference only. I wanted to get both the size of the files and the dates. I have done this with regular AppleScript, and it works, but is kind of slow; very slow if the folder is large (thousands of files). This one uses Unix commands, in a do shell script, and is many times faster (my entire Home folder, 77,820 lines, in 4 seconds; this is just writing the text file; new computer :-). There are cons however. It does not handle "files" which are actually folders as expected; like "rtfd". It sees the…

This exact information is unavailable elsewhere. I've played with multiple picture import routines, scripts, applescripts, etc. AND have purchased commercial plug-ins over the past five years and I have NOT had success importing from iPhoto on a Mac directly. The ImageBrowser and other SYSTEM WIDE graphic functions are unavailable to Filemaker. What a sad oversight. I guess it's one way to keep your plug-in developers happy. But here's a link to the key information: Automator World Script Menu Plug-in Anyway, one more look and I got it working with Automator in OS 10.5 and FM7+ Download and install Filemaker's Automator Actions. Filemaker …

I have a few different email addresses and want to ensure that I use the correct one for emails sent from FileMaker. How do I ensure the correct email address is used - which is not the default email account. TIA

Hello, I am trying to find out how to write an applescript that when an email is received it would cause a FileMaker script to run. Should be easy, right? I tried to Google this and you'd think it be easy to find but I can't. Everytime I Google it I find articles on how to make FileMaker run an Applescript, but I need the opposite. I apologize if this is very basic and a 'dumb' question. Vandy. Here's what I need to happen... Apple Mail receives a mail and based on rules in mail it would run an applescript that would tell a certain filemaker file (there might be more than one open at one time) to execute a filemaker script.

Ok I have a fairly simple problem I think. I have a filemaker database where designers can import 10 photo's... I'm sure you can see where this is going.... I would an applescript that would... I need the image to be fairly High resolution but the quality can be 60% or there abouts.. Size Image should be resized to fit a box... Y high and X wide Copy the Chosen file to the temp folder. Perform a conversion of the file so it is no longer massive, write the new file to the temp folder.. Filemaker can then grab it and import it. The user is none the wiser but the FM database will be loads smaller and also if a record is emailed it will be WAY sma…

When an iCal alarm goes off, I'd like it to run an Applescript that will go to an open Filemaker file and perform a (find) script using a parameter of the iCal event (event name). What would the Applescript language look like and how do I capture the script parameter from the alarm? Thanks in advance.

I'm having troubles with Filemaker 10 and applescript. When we use Filemaker 7 all was good, but now with 10 can't figure out why applescript wont read db table and gather information to proceed with task. I highlighted in red below the part of script I cant get to work. Here's the code below from Applescript [color:red] property dataText : "" property hexList : "" property noRecordList : {} property masterList : "" property ScanNBRList : {} property containerList : "" property tempContainer : "" tell application "Finder" set theDate to (current date) set theMonth to month of theDate as number set theDay to day of theDate as numb…

I wonder if someone could point us in the right direction. We are novices at this. I have an AppleScript to open DVDs from within our database of DVD folders (not DVDs) with their Video TS files. It works great! We wanted FileMaker to open a different DVD for each record (of course) but we realized that if we make this a button which activates this script below in layout mode, it always opens the same script. How do we either: 1-set a variable so that a specific field can insert the name of the DVD file we want opened (this sounds hard, but it’s probably the right way) or 2-enter a different script in each record the way you would enter a diff…

I'm having trouble getting a date from iTunes into Filemaker using applescript. After running the script, the applescript says object or property is of the wrong type. Here's the line of applescript sent within the tell block to iTunes to extract the date: "set last_played to played date of track 1" Here's the line of applescript used to set the cell in Filemaker: "set cell "Last Played" of record 1 to last_played" I've even changed the field type to timestamp and that didn't work either. Does anybody know what I'm doing wrong?

in a database that has only one table and only one layout i am trying to get record counts from referenced filemaker tables. this is what I have so far, but I am having a hard time getting the result of applescript to trigger. of note this table would contain a record for every table with a field that is the table name that I am trying to get counts for. tell application "FileMaker Pro Advanced" tell document "myDatabase" set rec to ID of current record as integer tell table "referenceTable" set recCount to count records end tell tell table "logTable" set cell "recCountField" of record rec to recCount end tell end tell end …

Does anyone have experience of extracting data from Filemaker in order to print tape labels using Applescript and Dymo SDK. I can't get my labels to format legibly. Thanks

Script working, but not working if I duplicate it. FMP 8 Advanced I have the following script that allows me to dial phone numbers in FMP. tell application "FileMaker Pro" set theNumber to the cellValue of cell "Phone 3" of current record end tell tell application "ABDialer" dial theNumber end tell I imported this DB form FMP 6 and it is working fine. However if I duplicate the Dial-button and wanting to change the script to tell application "FileMaker Pro" set theNumber to the cellValue of cell "Phone 4" of current record end tell tell application "ABDialer" dial theNumber end tell I get “Expected end of lin…

I'd like to know how I can set a specific value of a repeating field (say repeat No.2) of a 4 values repeating field, using AppleScript.

Hi All, I'm new here so please be gentle.... This works for me in the script editor (its part of a longer script) try set appnames to do shell script "/hosts/bern/user_data/HR/jobsappv1 -g -i=5" on error the error_message display dialog "Error encountered" return end try If the script "jopsappv1" returns an error (exits with 1) then the script does the "on error" bit. If I run it in filemaker as a "perform applescript" I can't get it to do the "on error" bit when it encounters an error. I even tried giving it the name of a script that does not exist and it still does not do the "on error" bit. I'm using the "Native applescri…

How can I make FileMaker open a quicktime that's on a Network drive with applescript? I've tried: [set Variable] $$qt_path [Perform Applescript] Calculation: RAID01:SYSTEM:shotsubmit:test.mov "do shell script open " & Quote("$$qt_path") And: [set Variable] $$qt_path [Perform Applescript] Calculation: "tell application " & Quote("Finder") & "activate " & "open file " & Quote("$$qt_path") Tried several combos incase my code is faulty... but nothing works. I'm going insane... seriously ps. "alias" & Quote("&&qt_path") works to check if the quicktime-file exists, so the same path should work to open the qui…

Hi, So am moving a database from FM6 to FM10. The database uses Applescript to 'talk' to an external application. It appears that in FM10 the Applescript command 'key down shift' actually generates an output of 'a'. The script I'm generating by calculation is: tell application "appname" to activate tell application "System Events" tell process "appname" keystroke "c" key code 29 key down shift keystroke "t" key up shift key code 23 keystroke "g" end tell end tell tell application "appname" to activate This should type the sequence 'c0T5g' into the target application. If I copy and paste the script into ScriptEditor a…

Hello, I want to user "Perform Applescript" to check if a file exists on our Network. I have no problem to check if a file exists locally on the computer I'm on, for example... this works for me: alias "Macintosh HD:Users:edit:Sites:index.html" However, when I try to do the same with a file that's on our Network I doesn't work: alias "raid01:SYSTEM:shotsubmit:test.txt" I only get: The file raid01:SYSTEM:shotsubmit:test.txt couldn't be found. (Got a Swedish OS, so it might not say exactly that in the English version). The Network drive is mounted. If I go to: iBook:/Volumes In the terminal and write "ls" It shows: Macintosh HD raid01…

-My solution is pasting the clipboard into a FMP field. -Every time at first run, FMP crashes. -Then intermittently it will crash after that. -Bumping up the pause helped, but not with the first execution THE STEPS: Go to Layout Go to Field Perform AppleScript Pause/Resume Script [ Duration 5 sec ] THE SCRIPT: tell application "System Events" tell application "FileMaker Pro Advanced" to activate tell process "FileMaker Pro Advanced" to keystroke "v" using command down end tell Any suggestions, or other solutions?

Title pretty much so says it all. Happens to a local database or a hosted server database. Tested in Filemaker Pro 8 and Filemaker Pro 10 demo and Mac OS X 10.5.6 (PPC or Intel). Has anyone else ever hit this bug, or have ideas? Basic code: set imagePreview to read (filePath as alias) as picture from 513--get the image data tell application "FileMaker Pro" to set data cell "imagePreview" of record ID theRecordID of theDatabaseRef to (imagePreview as data) --insert the data into the filemaker record

I am currently working on a DB which will store information about Kernel Extensions (Kexts). I am looking for direction as to the method of retrieving the below information. If I should stick with Applescript or if there is some other means of scripting that will do the job. Say I have a folder of kexts from a particular update from Apple (Not those currently loaded on the machine) I want to find the following: 1. The name of the kext 2. Size of the kext including its contents as they are actually folders. 3. Pull useful information from the Info.plist file such as version, build, dependencies... The kicker is that there could be additional kexts buried…

I cannot make FileMaker Server 9 execute system-level scripts (Mac OS X). The scripts run fine from terminal. For example, I create a file called "test1.sh" with the contents: #! /bin/sh osascript -e 'tell application "Safari"' -e 'activate' -e 'end tell' When I run the above from the FileMaker Server Scheduler - nothing happens. When I check logs - I see in the console log the following error: osascript: kCGErrorRangeCheck : Window Server communications from outside of session allowed for root and console user only In the FileMaker Server log, file "stderr" INIT_Processeses(), could not establish the default connection to the Window…

Hi tell application "Finder" set Server_folder to "WHP_Data:Alberti work: minutes folder:" as Unicode text tell application "FileMaker Pro Advanced" set save_folder to cell "meeting::gtext" of current record set file_name to cell "meeting::filename" of current record end tell tell application "Finder" to set copy_file to duplicate save_folder & file_name to folder Server_folder with replacing end tell Basically meeting::gtext is a folder (set earlier in scriptmaker using the applescript "choose..... command." and meeting::file - well is the file name. Sometimes this script works but now get an error saying Finder got an …

Is there anyway to set a filemaker variable from applescript. Example: If I run: set Original_Printer to do shell script "lpstat -d" I want to output Original_Printer to a filemaker variable.

I need a script to send an email to a person and take, at random, the text out of a specific field in a FMP 8 data base. I am not good at scripting and so far my attempts have failed. Does anybody have any ideas? Here is the mail script I use that works fine to sent fixed text: set theSubject to "Subject text" --change me set theBody to "Body text" --change me set theTarget to "[email protected]" --change me tell application "Mail" set newMessage to make new outgoing message with properties {subject:theSubject, content:theBody} tell newMessage make new to recipient at end of to recipients with properties {address:theTarget} set sender to "M…

if i use this bit of applescript: open filemaker_file for Accounts "my account name" with passwords "my password" I still get a login prompt. Has anyone else experienced this?

Hello, OK....I have two scripts I am trying to now combine into one. One script is a folder action that when a PDF File is dropped into it, that it sends and email message to a group of addresses and lets them know the name of the PDF file that was just put in the folder. The other script is for a filemaker pro database that opens a file (in this case a pdf) in photoshop (once it is dropped on its script application icon), and adds it as a new record to to my open database after it changes its file size and copy and pastes it into the database picture field. So, here is my thought..... I would love a folder action that when a file is dropped into that…

Not sure if this is the best forum to ask this but here goes. I was hoping to get a script going which will allow me to put and get FTP site files via a database on web. Any thoughts on the best way to do this? thanks

I have a client that has an AppleScript that has just stopped working. All it does is ask the user to pick a file (name), this is then returned to FIleMaker. The main variable is that their Mac server died (which unfortunately is also the FMServer). They rebuilt it and applied new Apple Security updates. If the user logs on (not to the network but) locally and opens the files through FMServer, the script runs correctly. If I just have the first half of the script that asks the user to pick a file, it works. It has something to do with returning the result to FIleMaker. Here is the script. Thanks Andrew "try¶ set the target_file to cho…

Is there a simple way to return the result of a "calculated applescript" script step to the originating script? I appreciate this can be done by having the applescript itself write the result into a field on a layout, but i was hoping for something a bit more elegant

Hi the following two scripts both work when run in scripteditor** but fail "generally object not found: when run in FM scriptmaker. (first script saves a pdf to local drive and second one makes a copy to a server) tell application "FileMaker Pro" to set file_name to cell "meeting::filename" of current record tell app "finder" to set new_folder to (choose folder with prompt "Choose a Project Folder to save the PDF file: " & file_name) as Unicode text tell application "FileMaker Pro" to set cell "meeting::gtext" to new_folder AND tell application "Finder" to set Server_folder to "WHP_Data:Alberti work: minutes folder:" as Unicode text tell ap…