AppleScript & Automator

Hi, Here is my requirement. I have a mail received, its body contains a link to some executable file. e.g. /Macintosh HD/Host Folder/samplefile.sh samplefile.sh is a shell script file created for Mac (OSX). In samplefile.sh I am using...osascript to call an Apple Script. The Apple script in turn should invoke a FileMaker script and pass some parameter to it as well. Currently I am facing the following problems:: 1. This whole logic should run on a click of the above mentioned link....which is not achieved. 2. How to invoke a FileMaker script through an Apple script? 3. How to pass parameters to the invoked FileMaker script, while calling it fr…

Hi All My hardware is an Intel iMac, running Mac OS X 10.4.11 My software is FilemakerPro 8.5v1, and Apple Mail Version 2.1.3 (753.1) My need is to achieve the following workflow: Whenever an email arrives in Mail addressed To: a specific address, it should be copied into a specified folder on the Mac, and the contents of the email body should be copied into a named field in a named FMPro database. Another Applescript (aimed at a 3rd program, QuarkXPress) should then be triggered. I'm a newbie at Applescripting, and would be grateful if anybody could give me the scripts/steps needed to automate this workflow. Many thanks in anticipation. PH…

I've searched the forums and probably put in the wrong search terms and the Apple Events db does not provide examples that are helpful. I've looked at Hannaan's book where he describes how you can use the whose clause to work directly with a table's records without doing the Find steps. I'm trying to get cell values of a select part of a table, but cannot within the tell block of the "whose" clause. Uncomment the below and you'll see my result. How would you iterate through this subset? My goal is to save this info to a list, and then those values will be used to discriminate records that have this value. Each of those records have certain fields populated depe…

Here is the problem I am having, lets say I have a database with 6 records, and in those records is a field called "Status". Now lets say the first 4 records have the "Status" field set to "done" and the last 2 have it set at "Active". Now, if I do the following (show every record whose field "Status" = "Active"), it will give me a found set with just the last 2 records. But if I then try to loop thru these 2 records and extract info this way: repeat with i from 1 to 2 set New_Client to field "Customer_info" of record i end repeat I will get the value from the records with the value "done", since the (record i) reference is to the whole database not t…

I have the following script step Tell application "FileMaker Pro Advanced" Tell Database "MyDatabase" set TheResult to field "Status" of (every record whose cell "TheFlag" = TheVariable) End tell End tell This will work once or twice then give me a "event not handled" error. And that is with the same values for TheVariable. I have used different ways to refer to this info, calling "whose cell 8 = TheVariable" etc... The result is all the same, it works once then will give an event not handled. Any ideas?

Here's my applescript: tell application "FileMaker Pro Advanced" activate set theUID to cell "ID" of current record of document "Update Address Book" end tell tell application "Address Book" activate tell me to open location ("addressbook://" & theUID) end tell If I run this applescript in Script Editor it selects the correct person in Address Book. If I put the identical code into a "Perform AppleScript" in a Filemaker Script it selects the Address Book file but then it appears to hang or pause and the Filemaker icon on the dock starts to bounce. Now that is behaviour that suggests that there is a dialogue or message from Filema…

Hi, has anyone an apple script to click on a button in Filemaker to take a reference number from a field and open any file within Cumulus (7.1) that contains that reference number? I can't write apple scripts myself but I am hoping one of you geniuses have will have something I can use! Many thanks Peter

Hi all, I have Filemaker 5.5 and going to upgrade it to 9 soon. When we connect to our Filemaker 5.5, we use an apple script like this: tell application "FileMaker Pro" activate open location "FMP5://servername/Main Menu.fp5" end tell I am trying to modify this script to work in FileMaker 9. I do not know much about applescript, and I am sure a lot of people here does. How do you modify it so it will tell filemaker pro 9 application to open and connect to the database? I am sure this is probably a simple command. Thanks for your help.

I've been sending data from Filemaker to iCal but have found a problem: any field that has a ! or " in it causes an error in the Applescript to err and to stop. I'm wondering how can I escape these characters in Filemaker? Or more importantly, how do you search/replace a quote within field contents without going character by character? I've tried: Substitute( Cal::Notes; """; """ ) but that doesn't actually do what it implies.

Hello All, I have recently created a database for 6 users. We are organizing several thousand images with it, and I need to keep file size low. The dataqbase and images are being housed permanently on a server, so linking the images is just fine for our needs. The embedded images are already getting large. Any advise would be appreciated. Thanks,

Fixed I think - needed as text after the first line tell application "Finder" to set Server_folder to "WHP_Data:Alberti work: minutes folder:" tell application "FileMaker Pro Advanced" set save_folder to cell "meeting::gtext" of current record set file_name to cell "minutes::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 I get an error when running this script to copy a file across to a server. I think it runs ok in Applescript. Any ideas? thanks

Goal: Save pdf to local directory with scripting on OS 10.5. Scenario: When I visit: http://www.domainname.com/directory/generatereportpdf.aspx?VIUEoYx7fvmJJgtoX2bOw2+bHMUSd9JTe39xjuWnj+lCqxiwPX6JWbEYIq%2fIKvi1etUQkfRAaMBKmokWcUfYRWYxL93jpHV%2fd+YgP+%2f20Br6RFQmqJ5Bb1 It generates a PDF report for me on which I can right click in Safari and save it to my Desktop. I used to have a process using SuperContainer where I would pass the URL to supercontainer and it would upload it. The provider of the pdf changed their site and now encrypt it as seen above and this process no longer works. The solution to my problem as I see it to have applescript save page as …

I am seeking to automate an Insert Picture task in a container field in my record set. It's probably going to involve using some combination of Mac's Automator and ScriptMaker, but I'm stymied owing to a lack of programming experience. The way it works: I'm inserting a unique ".jpg" file reference in each container, where the name of the file matches the unique ID number for each respective record. The JPEGs themselves are prepared in advance and saved externally, in a directory file tree on a separate hard drive. The names of the nested containers in the tree are based on the same unique ID numbers as are the names of the JPEGs they ultimately contain. T…

I've created a script in FileMaker Pro 9 to send and receiving e-mail. Because i want it to run often, i've wrote an applescript that is launched by Cronnix every 15 minutes. This script looks like this: tell application "FileMaker Pro" activate tell database "Mydatabase.fp7" do script "SendAndReceive" end tell end tell The script SendAndReceive opens another database which is in the same folder than "MyDataBase". Since i'm shearing the computer (Mac Intel OS 10.5) with other people I cannot let my session always opened. My script works well when i'am the current user. But when one switch user, it doesn't work. At best, putt…

I’m having strange problems with this “Restore Backup File” routine – any help would be appreciated! My main database file is named “ISM Program.fp8” (I know .fp8 is not standard, don’t even ask why I have to use this..!). Each time the database is closed it saves a copy of itself named “ISM Data Backup” (no extension). This is the folder set up: (omitted HD & username, this runs on multiple computers with multiple usernames, that’s why I’m using “DesktopPath” in the AppleScript) Main database = Users:Applications:ISM Stuff:Safety Management System:ISM Program.fp8 Backup #1 = Users:Applications:ISM Stuff:Backup:ISM Data Backup Other Backups = Users…

I have an AppleScript that tries to create a new record and insert data into that record on a remote host. The remote host is running FileMaker v8.0.1. When I run the script, the remote database creates the new record, then raises an "Object Not Found" error. FileMaker is telling me that it cannot find the new record that it just created, despite creating the new record and returning a row id! Here's the relevant part of the script: set newRec to create new record tell newRec set cell "ID" to item 1 of d set data of cell "client" to item 2 of d set data of cell "title" to item 3 of d set data of cell "responsibility" to item 4 of d …

I am trying to write an Applescript that will perform a find for data in a given field. The data is already established by the first part of the Applescript which works fine. What I want the second part of the script to do is to : go to a given layout, enter find mode go to a given field enter the data created by the first part of the script perform find The following Filemaker script script "check dups" does this up to step "go to a given field". What I can't figure out is how to enter the data contained in adresse_complete into the field "adresse au complet". The "set cell" command in find mode gives a "write access denied" message. tell…

I posted in the external data forum about this but A] realized it belongs here, and B] no one has replied due to my waaay to in depth post. (Sorry all.) I am trying to manipulate an already existing event in iCal from Filemaker via Applescript. I am able to create events no problem. After an event has been added to iCal, I'd like to be able to update or delete the event via Filemaker & Applescript. I know the UIDs from iCal that I'd like to access but am having trouble getting Applescript to actually select the event. My code checks to see if the event exists; if it does it should select the event as theEvent to manipulate. If it doesn't exist, …

I am writing a Filemaker/Applescript solution to rename a huge number of files. Filemaker will calculate the new name, and Applescript calls a shell script to rename. I want to be able to test on 2/3 records. The script insists on running on the whole database. I feel I should be able to say tell found set but I can't! Am I missing something? So many questions, but let's start with this one! TIA.

I've got an icon in photoshop, 50px by 50px. For Reasons to Become Apparent Later, I'd like to recreate this icon as single coloured pixels in FileMaker. Obviously, creating a couple of thousand pixels isn't my idea of a good time. I was hoping to AppleScript it. Can I AppleScript layout mode to the extent of 'make a rectangle, colour it this colour, position it here'? If so, then I can script Photoshop to get each individual pixel's colour, then go to filemaker and recursively make them; if not, then I guess I have a few evenings' tedium in front of me. Help much appreciated. Hamish

I am trying to write a script to auto send a confirmation letter. I want Mail to enter the e-mail address of the recipient automatically. I can do a keystroke to enter the address, but think there must be a way to tell the Mail application to paste or get the results of a field in FM. Thinking I need to use AppleScript, but there may be a better way. I am a novice at AppleScript. Hope someone can help.

After using different solutions I came up with this Applescript fix. It replaces the quotes in the text field so that applescript doesn't get an 2741 error. Hope it's helpful for you. :

:idunno: In the past I used a simple applescript to call on the Printer Setup Utility to switch printers. Leopard ditched that app and has totally integrated it into System Preferences. Does anyone know a way to access those settings via applescript? Better yet, how about a terminal command? :idunno:

I would like to get a list of all files (graphics files) on my hard drive that contain, as part of their filename, a product code from a field. I have a record with a "show Art" button attached to a script which I would like to produce a the list which might, for instance, appear in a finder window where I could simply double-click the one I need to edit and have it open in the relevant app. I have tried applescripting it and send event but haven't sussed it. Any clues? Thanks in advance. Roger

Warning: I have never used the applescript EVER but i would like to see if i can do a work around for my runtime solutions that are demos for the mac. i am currently using without any problems .. Dempsey's Mooplug for my windows runtime solutions, but i would like to lock down my demo's as well for the mac. i need to be able to create a folder on the mac on first installation, i need to be able to check to see if that folder exists as well, i need to be able to create a blank text file and be able to put it into that folder, and check for the text file too, i need to do all this and have the applescript report back it's findings to fm8.5 so i can then furt…

hi I want to create a new record in my database each time I drop files in folders on my finder desktop I use the Folder Actions Scripts I have one folder per client and many different kind of files When the record is created in FMP, I want to paste the name of the folder and the name of the file in 2 differents fields... I wrote an applescript and no problem create a new record and to copy and paste the folder name... but I can't find how do the same thing with the file name... help... this is my script thanks ----------------------------------------------------------------------------------------- property dialog_timeout : 30 -- set th…

I got sick and tired of having to duplicate names and addresses in an FMP Application and in AddressBook. I figure if contact details need to be anywhere they should be in AddressBook and can therefore be used by a variety of applications. Here's two Applescripts that are the basics for integrating AddressBook with an FMP application: Script 1 - Adds and AddressBook entry into an FMP Table. It only requires 2 fields in the FMP DBMS. Field 1: The AddressBook ID for the contact entry. Field 2: The name of the contact person or company. Field 1 is for AddressBook lookups. Field 2 is for Value Lists, Portals etc. -------------------------------…

I have a problem being able to paste a text field's contents into a webviewer objects form field that is on the same layout. If a field is manually entered into and I use the keyboard command c to copy and then click into the webviewer object: Can not use keyboard command v to paste. I can right click on webviewer form field and then submenu click on paste and it works fine. Have not figured out how to script that mouse action though. (is there an applescript for ctrl clicking the left mouse button?) I have tried to use script copy and paste function, but that also does not paste into webviewer field. So my question is, how can I script the functional…

I have an Applescript that runs a FM script via the 'do script' AppleScript command. What I want is for the FM script that runs to do some work and then return a text value back to the AppleScript. The last step of the FM script is 'Exit Script' with a text 'result' value set. The problem is that the 'do script' AppleScript step is not returning the FM Script's 'result' value -- presumably because the return value is only getting passed to a calling FM script, not an AppleScript. I'm wondering if there is some other way to do this. Obviously I could have the Applescript proceed on, wait awhile, and then check either a FM global var or the clipboard for a retur…

Hi, I have been trying to get either xmlrpc or soap to work from an applescript. It has not worked. I get an appleevent time out when I try to save the script. I have also add a tell finder command to the start of the script and that does not seam to help. set address to "new york city, new york" tell application "http://rpc.geocoder.us/service/xmlrpc" set response to call xmlrpc {method name:"geocode", parameters:{address}} end tell

I would like to create a text file from a global field. Ultimately i want to turn it into a .ics file and open it in iCal. This is an example of the field need to copy. Its important to keep the returns. BEGIN:VCALENDAR VERSION:2.0 METHOD:PUBLISH BEGIN:VEVENT DTSTART;VALUE=DATE:20080610 DTEND;VALUE=DATE:20080613 SUMMARY:Josh Allen (Annual): 3 days UID:242 END:VEVENT END:VCALENDAR thanks

I'm a newbie to FM and need some help... The following native Applescript (button opens FM container field named "document" containing a PDF file with Adobe Reader) works in FMProAdvanced 9.0v3 but not in runtime 9.0v3. How do I get this to work in both? I think I need to somehow get the MacOSX v10.4.11 to associate Adobe Reader v7.1.0 in the runtime version of the program. When I finish entering the native Applescript code for the button, I am then asked to choose an application. I then select Adobe Reader. The same problem occurs with another button that runs Adobe PhotoShop with JPEG images. Thanks, - Jansen Error message: Object not found…

For my database I also now need to do basic applescipts. I have just started today, However, I have hit a roadblock. I need to know how to write out a file's path name. I thought it would be {imac HD/Users/Mddharma}, but when i try to compile it, It gives me a syntax error saying "Expected “,” or “}” but found identifier." and it has "HD" Highlighted, but that is part of my hard-drives name. Thanks for the help

This applescript works great: tell application "FileMaker Pro Advanced" set img_URL to cell "zz__web_ImgPath_CertImg__lct" of current record do shell script "cd /Applications/Cert_Print; curl -m 1 -fO " & img_URL end tell tell application "FileMaker Pro Advanced" set img_path to cell "zz_local_cert_path" of current record do shell script "lp" & img_path end tell Problem I am having is that I would like the image that is downloaded to be fit to the size of the page when printed. I saw the -o option and fitplot but can't seem to make it work. Any ideas or help would be really appreciated. Thanks, Drew

Computer Mac OS X (10.4.11) Problem: I have a simple fp7 database (version 8 Advanced) that contains a list of the names of about 400 PDF files along with new names for those files. The DB record contains two fields—"OldFileName" and "NewFileName". All the PDF files are in a single folder. I need a way to automate the change of the old name of each file to the new name. I imagine that someone else has already done this with AppleScript (which I am not that good at) and I am hoping that someone can steer me to a ready-made solution. Thanks in advance Jake

There seems to be a limit imposed on the amount of text that one can read into a cell from AppleScript in this way. Does anyone know a way to get around this? I have a text file that I read in and then copy into a text record in FileMaker. AppleScript reads 2500 lines, but then only transfers 85! -- request the file containing the text set filePath to POSIX path of (choose file with prompt "Select text file for import" without invisibles) -- get the text of file and put it in current FileMaker record open for access file filePath set fileText to read POSIX file filePath as text close filePath try tell application "FileMaker Pro Advanced" …

I have another little conundrum involving transferring data from one file to another. This time I need to lift the contents of a text file into a single field in FileMaker . . .a seemingly trivial task that is very easily performed manually. I wrote the script enclosed for this which works well until TextEdit hits it's memory ceiling. What I want to know is, is there any way I can lift the text straight out of the file without going via TextEdit, or is there another way round this problem. The text files are large (~250,000 lines), so the other methods of importing into FileMaker have proven too cumbersome and I need to be able to import the text before I c…

I have a script that inserts text from FileMaker into Word documents, making up a page per record. However, nothing I do seems to be able to make it also insert a picture on each page. I have tried using 'make new inline image' but I just get an error saying that it cannot make one! Any ideas? Many thanks - Anatole My code is as follows: set myname to "test" set myFinishedDoc to (path to desktop as string) & myname & ".doc" set x to 0 as integer repeat if not (exists file myFinishedDoc of application "Finder") then exit repeat else set x to x + 1 set myFinishedDoc to (path to desktop as string) & myname & x & …

is there a way to use 'wild cards', e.g., * or @, in the file name of a 'select file' statement for the finder? If there files a1 a2 a3 a4 in a folder, I would like to be able select all files starting with 'a' (a* maybe) but i can't seem find a way to do that.

Hi, I use Filemaker to manage a lot of my uploading business for different websites. One part of it is to upload files from my local directories to the webserver. I use applescript and an ftp program called transmit for that. Yet lately the data volume got so big that I constantly get a timeout error on my applescript which handles these uploads. I was told to use "with timeout x seconds" before my tell to transmit statement so it would give me x seconds before timeout. Yet as I changed my code and reran it in FM I got the same error again and again after 60 seconds. Again I checked the same script code in the applescript editor and got no timeout. I…

How do I get the text of a custom function or a calculation into the clipboard? I want to edit them within Emacs with function name highlighting, parenthesis balancing and so on. Jens

tell application "FileMaker Pro Advanced" activate --activate the first database and the script getURL "fmp7://192.168.6.24/test1.FP7" tell database "test1" do script "test 1" end tell --activate the second database and the script getURL "fmp7://192.168.6.24/test2.FP7" tell database "test2" do script "test 2" end tell end tell the problem is that i don't know how to switch to the second Db, the focus remain on the first. Please help me

tell application "FileMaker Pro Advanced" activate getURL "fmp7://myaccount:[email protected]/myDB.FP7" try do script FileMaker script "myscript" end try end tell do is possible to add the parameter script to the "do script" command? example: do script FileMaker script "test" parameterscript"my parameter"

Hey everyone. I am new to both Filemaker, Applescript, and this forum. Thanks for all of the helpful stuff you have posted here! It's a great forum. I have been hunting around trying to find an answer to this, and I am sure it has probably been asked before on this forum, but I can't seem to find it. We have a script in our FM9 file that uses Applescript to generate a folder on our desktop. We need to change the permissions on this folder to be 775 (Read/Write/Executable by both Owner and Groups). What would this Applescript look like? Any help is much appreciated!

Ok, Ok, I know this topic has been discussed quite a bit already. First, before it's suggested, my client is plug-in shy. So, the solution I have so far: - Select folder to link to using applescript. - Take path returned by applescript, replace ":" with "/" and add "file://" prefix. Save this to a field called FolderPath. - To open the folder, use "Open URL" script step on FolderPath. Here's the applescript: set theResult to false tell application "Finder" try set FolderAlias to choose folder set theResult to FolderAlias as string end try end tell tell application "FileMaker Pro Advanced" tell database "woj08" tell tab…

Okay, I've got everything working thanks to Feton's help in my previous topic. I figured out how AppleScript handles file paths (rather poorly) and adjusted my script to take this into account. Here's my filemaker script: and here's the AppleScript subroutine: "set filepath to "" & $tempfilepath[$count] & """ & "¶tell application “Skim”¶ activate¶ open filepath¶ print document 1 print dialog no¶ close document 1¶ end tell¶" On my computer, this works fine! The PDFs get exported, and Skim opens and prints them, no problem! On a co-worker's computer (he's running the latest 10.5, I'm running 10.4.11, b…

My data base has two tables: ListservLists and ListservOwnersandEditors. Layout I'm viewing shows some fields from the first table and a portal with fields from the second. Screen shots are of an area in Layout and Browse mode. The two tables are related by a ListName field common to both tables. Under filemake 6, the following statement would return a list: set job to cell "ListservOwnersAndEditors::Function" job would be {"Onwer","Owner","Editor"} In Filemaker 9 on Leopard, job is simply the string "Owner" How can I get this to work in 9?

I've been running an apple script with FM6 for years. Moving to 9 now, revising for this release. In AS, some "set variable to cell" statements are not picking up values. When I explore the data base with Script Debugger, it is not showing some values either. Are there issues between AS and FM in this new release that are causing these problems?

In my initial message I described what I wanted to do, batch print multiple records with container fields containing multi-page PDF files. I found an App that works for this called "Skim" which is capable, via AppleScript of prompt-less printing of PDF files. I use filemaker's "Export Field Contents" to put the files in a known location, than using a calculated applescript I feed the PDF paths to Skim. The only problem is Skim won't open them. It displays an error message saying the file couldn't be found. Weird thing is it displays the exact and correct file path so what is it I'm doing wrong? Calculated AppleScript follows: "set filepath to "" & $tem…

Hi all, apologies if this has been covered before, but I've googled and searched and while I have come across some sample code none of it seems to work, so I'm appealing to you guys to solve my problem quickly and easily. My database will be used for the purposes of batch printing PDFs. Each multi-page PDF has its own record and is stored in a container field. The user selects a number of PDFs, entering them into a portal. Then presses the print button. In an ideal situation this would present the user with a single print dialog that would fully print all the files in the portal. So far, I've managed (using Applescript) to get all the files in the portal to ope…

Hi, I've an automater script to backup a file via ftp to my local disk. Then it restores this sql file. The file is a mysql dump of the online database. Can I past this file in filemaker or can I make a new script to a. backup the internet database to local file b. restore the local version I have odbc connection to both databases. My filemaker file is mostly for reporting purposes.

I have been working for a project in container terminals for data collection and reporting. Since different shipping company required different format of data in Excel format, how can I do it? My first guess is using filemaker to trigger a script of VBS and output the data in the excel while this stupid data will be translated into some defined format via some macro function. DO you all have the solution or some sample post here? I have tried all the method for half a year. Thank you Fenton

I'm trying to script a command to open a folder on the Mac My PC solution just uses a send event which works just fine, but does nothing on the mac. I'm setting a variable that is the $Filepath and passing that to the send event open document script command but nothing happens. Any ideas - maybe an apple script (something I'm not competent in at all) Thanks

Does anyone know about an applescript that can automatically open a remote database. It seems like something that should be available instead of having to open FM, go to Open Remote, click on the Host, click on the database, etc. Anybody up for a challenge? I don't know applescript well enough.

Hi there, I have a system that checks thousands of emails using a mail plugin, moves the attachments to a file server and puts file references to the attachments in a container field. I'd really like to convert .doc files as they come in to .pdf. Does anyone know how I could do this? I'm willing to pay for a commercial solution. I know there's a free way, using the CUPS printer or something like that, but that has to sit on your desktop and it dumps the files into a folder, and I don't know how I could automate invoking the CUPS printer and pulling the files from it's folder, so I was hoping there might be a more seamless way that worked with FileMaker. Any…

Hi everyone, I have an AppleScript that activates a database, runs a FM script that selects the correct layout and then the AppleScript puts a value in a FileMaker field. However, if I don't complete a manual Find in that FM table first, the AppleScript says that it can't find the field. The field is on the layout (I even go to a layout with ONLY that field) and once I've done some random search in a similar layout, I have no problems running the AppleScript. Ideas? Thoughts? HELP!? In advance, thanks for your time and help!

I used to use the following AppleScript to change printers in FileMaker: tell application "FileMaker Pro" to set printerChoice to cell "gPrinterReceipt" of table "Preferences" try tell application "Printer Setup Utility" to set current printer to printer (printerChoice as string) on error display dialog "Sorry, the printer, '" & printerChoice & "' was not found." buttons {"dang"} default button 1 tell application "FileMaker Pro" to set cell "gBlnAppleScriptError" of table "Preferences" to "1" end try But now the Printer Setup Utility is gone, and its functions included in System Preferences. Can this be scripted? If so, can my code be modified…

I am new to filemaker and applescript tho i have some years experience in other databases. I am looking for some way to trigger the execution of a script upon the addition of a record to a table - this record is added by a script which processes incoming emails and formats a new database record. When each new record is added I need to use information in that record to update other database tables. Where can I attach a script so that it will execute when a new record is added to the table? Where can I find a good scripting guide to help me build the script?

I haven't seen any specific reference to "views" anywhere in Filemaker. Perhaps this is ancient parlance for something that is done differently in FM? FM uses the word "view" in terms of layout - I mean a "view" of the data which is a superset or subset of the table records. I need to create a relationship with child records using a key field PLUS a constant. For instance (tho this is not my application), in a sales order, the relationship with the order line items is defined by order number PLUS the line item status (A=active, V=void) so that I see only the active line items. I can see how to do this if I create an extra field in the parent, and set it to "A…

Hi, I see there is a built in script to import pics from a camera, does anyone have a script to take a picture from the iSight and auto import it into a container? Sort of like how iAlert U works for iSight? Thanks... cause it would be cool!

Hello I have a filemaker pro database I created for my wife to store her client information and notes in. She also makes hypnosis tapes and would like to store the sound files in her database and burn them to CD What I have done is used 24usoftware simplesound plugin to create .aiff files from within filemaker. I store the file in a folder in the documents folder. In the database I have one field the stores the filepath to the folder and one field that stores the name of the sound file. The only way I can figure out to burn a CD is to use iTunes. I have figured out how to add the file to iTunes. I can't figure out how to tell iTunes to burn a CD, so …

Is it possible to access the record id for specific messages in Mail, store them in a field in Filemaker, then to use applescript to open the message in mail from a script inside Filemaker?

I have a program that returns a phone number when a person calls, the properties are CIDnumber. Ive create a layout with a number field in my database called CIDinfo, this field is on the new layout. How do I get the number stored in CIDnumber to be entered into the field CIDinfo box on the layout? or have I gone about this in the wrong way. Ive used applescript to start FM when a person rings but not sure where to go from there. Any help will be appreciated.

Here is a simple applescript to get the count of file types on your hard drive. In my case I get a total of about 4000 files in 1 second. set makeFind to "mdfind "kMDItemKind == 'FileMaker Document'"" do shell script makefind set f0 to count of paragraphs of result set makeFind to "mdfind "kMDItemKind == 'Microsoft Word document'"" do shell script makefind set f1 to count of paragraphs of result set makeFind to "mdfind "kMDItemKind == 'Microsoft Excel workbook'"" do shell script makefind set f2 to count of paragraphs of result copy ("FMP: " & f0 & " Word: " & f1 & " Excel: " & f2) as string to cell "AS_Result" of current recor…

This isn't really about AppleScript, but it is a Mac-only solution, and we don't really have a simple Mac-only forum. This seemed to be the best place. http://myfmbutler.com/index.lasso?p=433

When running the following script in FIleMaker Pro 9 I get a filemaker error stating that "the command finished with a no-zero result" and fails. Running the script in applescript editor it is successful. The result shown in applescript editor is a null string "". tell application "FileMaker Pro" set calling to cell "ID" of current record set called to cell "tele" of current record end tell set dStr to "dial," & calling & "," & called do shell script "echo " & dStr & " | nc -u -w 1 192.168.1.10 21900"

I've recently learned to create a graph with Chartmaker Pro. I would like to find a way to get a chart from Filemaker to a Microsoft Word document. So far I have just been manually capturing (shift-command-4) that part of the screen and then inserting the resulting file into the word document. I've also tried the "Go to Object" command and copying the chart to the clipboard, but it just grabs the text characters and not the graphics. Is there anyway to automate this or are there other ways to export such a chart? thanks ahead for feedback!

Hi, I am using Filemaker server 8.v04 on Win server 2003. Cleints are connecting to it using Filemaker pro 8.0. some of the clients are using wireless network. These clients are getting the error 'Communication with the host was interrupted and could not be re-established all affected windows will be closed' very often. They say that they get this error when thay are doing some processing which takes few mins. But I have not set any time out for any database. even my server power option is 'Always On' Please help. Thanks in advance

Hello, this is too easy to find an answer to! I've been searching for an hour or so for this simple script. I've only been able to find really complicated and special situations... Obviously I've never used applescript before. I have datbase that stores file references to MS Word documents (in contianer fields, of course). I'm creating a loop script to print out the document in a certain order. So I need a very simple script that will print the MS Word document, then close it. That's all. I can specify the filepath dynamically in the "Perform AppleScript" script step in FMP. Thanks!

I'm having trouble getting data from a global field into an Applescript. Here's what I have now. tell application "FileMaker Pro" to set theCounty to cell g_CorpCounty of database 1 The script keeps giving me an error "theCounty" is not defined. Unknown error -2753. I've read that adding a try statement helps native Applescripts in FileMaker, but it hasn't prevented to error so far.

I need help with two things. First, I want a script that defines the output path for an exported text file. If possible, I want the user to select the output folder/location (example: MacHD:Users:User:Desktop:$filename.txt) on the first use of the script, and then the script will remember it each time the script runs. If the folder/location is missing, the script will ask the user to redefine it. Second, this exported text file will be imported into Quark XPress 7.2. Currently, I'm using Tex-Edit to "massage" the data to remove quote marks, commas, add spaces, etc. Can Applescript edit text without the use of a text editor application? Can somebody provide a sam…

I am a doctor and have written a simple Filemaker database that stores patient information. I keep the patient's xrays in iPhoto because I need to zoom, pan and rotate the images when I look at them. Is there a way to open a patient's xrays in iPhoto by clicking on a link in the patient's Filemaker record? Thanks for your help! Andreas

Hello, Is it possible to have a button in my filemaker database create a set of directories on our file server (with the names of the directories determined by the values of a field from filemaker)? Also, I currently link to files on our server using the "open URL" script attached to a button. This works fine on Tiger (the web browser just passes and afp:// link to the finder), but on Panther it comes up as a page not found in the default web browser. Is there a better way to do this? Cheers,

Am trying to use the filepath of a file stored in a field (Not the POSIX Path) to open the file using applescript. I have the following script steps Set Variable [$FilePath; Value: DocumentLibrary::File Path] How can I use this variable $FilePath in a "Perform Applescript" Script step?

Can I make filemaker run an applescript and return a value? For example: tell app "Finder" count every folder of desktop end tell If not, what is a work around to get the value returned from an applescript into a field?

I have 2 fields - both type: Time - one is time in and the second is time out. I would like to have an email notification sent if the time out has not been modified within 4 hours of the time in field. Is there a way to do this without requiring any user action? Thanks!

I have a backup Filemaker script that uses the save a copy as script step to place a copy of the database in a backup folder. I then use the Send apple event script step to run a applescript application that changes the name of the copy to system username and current time and date. This applescript application then deletes any copys older than 60 days in the backup folder. The filemaker script runs fine until I run the filemaker database on another computer. Filemaker says it can't find the applescript application :(

Forgive me if this has been talked about before. When I'm creating a new database I often face a lot of work just adding tables and fields by hand. I often find that each table has 2-3 of the same fields (title, primary key), same naming convention, same options (especially auto-entry of serial numbers) ... you get the picture. A lot of tedious work that seems ripe for automation. I'd like to be able to make a list of table names and have AppleScript build the database off that list, and automatically stock each table with fields that follow the naming convention and are set to the correct options. Has anyone seen a solution like this?

Hi, I have a folder full of about 1000 cover images for films that is left over form a previous Access database. The images are all named according to a catalog number (that is how they were displayed in Access), which is the same in my new FMP database. Being wholly inept when it comes to Applescript, how might I go about writing a script that would import the images to container fields in their respective records in FMP.

I have an AppleScript / FileMaker script combo that periodically times out, but I don't know why or where in the script the slowdown/failure is occurring (the AppleScript is called by Entourage and tells FileMaker to run a series of scripts). I was thinking of writing to a log file at each step of my scripts (both Apple and FM), noting what step was happening with a time stamp. Is there an accepted best practice for doing this? Should I call an AppleScript to write to a file each step of the way? Or maybe build up the log with calculations in a global text field in my database that I flush to a file at the end? Thank you.

Okay. I am building a FMP database to keep track of my Cafepress shops. I want one to simply contain all my products, including images. I can create the URL to the image from the product number, but want to be able to use that to pull the image into the container automatically, rather than going record by record, click the button link to the URL, then copying the image manually, returning to FMP and pasting. With all the automation options -- FMP scripting, AppleScript, Automator -- you'd think it would be a breeze to do this. Does anybody have any suggestions? Thanks. Dave

I'm trying to run a simple applescript which will open a FileMaker database and run a script. When the script runs, it opens the FileMaker database and displays the following message with the "do script" line highlighed "FileMaker Pro got an error: Object not found." tell application "FileMaker Pro" activate open file "RemoteHD:Nightly.fp7" do script FileMaker script "Test" end tell I've tried a number of variations such as: - Shorten the script line to 'do script "Test"' - insert before the "do script" line: database "Nightly" For debugging, I've tried to make the script as simple as possible. Thanks for yo…

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 6 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" --change me set theBody to "Body" --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 "Me…

Prior to FMP7, if you got the cell "OtherDb::afield" and there was more than one related record, you got a list of the values of the related records. (This was a pain in that if there was only one related record, you got the value plain instead of a one-item list, but that was manageable). In migrating a very old database up to FMP8.5, that seems to have broken: getting a cell or a field from a portal only gives me the first related record, and I can't find any way to get all related records. I think this change happened with the introduction of the Table class in FMP7. Has anybody had success in getting multiple related records via AppleScript?

I HAVE NO EXPERIENCE WITH APPLESCRIPT. Does anyone know how I can modify this script to make it work in FM7? We recently upgrades from FM6 and our tech person no longer works here. I tried just changing all "fp6" references to "fp7" and the script seems to be running, but all I get is FM6 application opening up with no file. My goal is to get our file (which has been upgraded to fp7) open in FP7, using the script. Sorry if this is confusing! Here is the old script: try tell application "FileMaker Pro" getURL "FMP5://oipserver.uoregon.edu/OpenDatabases.fp5" end tell on error error_message number error_number if error_number is -10000 then display di…

I am trying to have FMP open a file from a server. The name of the file is contained in a field in each record. This should be simple, but I'm not sure how to go about it. Here's what I have: tell application "Finder" activate open "Shared Items:Agreements_scans:.pdf" end tell After the 2nd colon, before the .pdf, I need to insert the field contents of that record. How can I do this? I'm sure this is simple, I've just never worked with applescript before. Any advice would be great!

Hi all I see there are some scripts to import/export iCal data. Has anyone got a script (or other solution) that will import all my Apple Address Book contacts into a FileMaker DB? I know there is a plug-in that will do it, but it's too expensive for me right now.

I have a script that works great in Script Editor, but does not work in FMP natively. I have a repeat loop in the script. I have pasted the entire Applescript into just one FM Script step ("perform Applescript") and it does not work right. What it seems like is that the repeat loop does not do its repeat, it just goes through to the last value of the repeat. Inside of this repeat is another FM script that does a Find and then Sorts and goes to the last record found then. Does FM handle doing script steps inside itself differently? Do they happen too fast? Does it ignore steps? Also, does anyone have a suggestion how to save multiple variables into a list, like …

I'm having a problem inserting a file through script here is what i have set AttachmentPath to ("" & (path to documents folder) & "TEMP:") tell application "FileMaker Pro Advanced" set foo to (AttachmentPath & "release of information form.doc") set cell "msgAttachments" of current record of database "artcode" to a reference to file foo end tell this works if I tell it to insert a JPG file but not a word doc or RTF file yet if insert file through the menu I can insert anything

Simple question: can I pass a parameter with the applescript "do script" command? I don't see anything in the scripting dictionary...

How do you pass a Filemaker variable (such as $$doohickie) into Applescript? I can't get Applescript to recognize any FMP 8.0 variables.

I am trying to sort records in FM Pro 8.5 with Applescript. I have 2 dbs, in one of them user choses fields which contents are actually names of fields in the second db (report db). Based on their choices and order of sorting, I want the applescript to do the sort. The command is: sort by {field SortField01, field SortField01} in order {descending, ascending} The syntax is OK, but the sorting done in FM is not in the order specified, it goes only by the first parameter for all the fields, which is wrong. I need different sorting orders for different fields. I can't figure the way around this. Someone said that this is a problem and FM knows about it, but maybe…

How to create empty Folder with Applescript in: MacintoshHD/Applications/FileMakerPro8.5Advanced/ ? Something like: tell application "Finder" activate make new folder of startup disk with properties {name:"TestIno"} end tell Thanks in advance Zagino

Using FMPA 8.5 I tried putting this AppleScript directly in a FileMaker script in a file called test1... Idea is from file 1 to open file 2 and set a field... tell application "FileMaker Pro Advanced" activate open file "mydrive:myfolder:Testers:test2.fp7" set cell "testfield" of current record of database 1 to "stuff" end tell When I run this - I get - " no user interaction allowed" error = -1713 - this is just 2 new test files with no privileges - it is set to all access Q: what's wrong here?

Hello I found a script online for running a apple script in FM to export to ical. I do wonder how I can manipulate the script to have also a Alarm time and alarm style, also it should be a whole day event. Any ideas? Link to File Thanks for the help.

Hi, Is it possible to change dock icon like in MacOSX Mail ( when you receive e-mail there is red circle on the post mark icon ) or animate it like Roxio Toast 8 ( when you burn media icon is moving ). Thanks

Is there any example file or knowledge in getting Apple Keychain info in Filemaker alter the info and maybe add info to keychanis. Like a keychain manager. I would imagine it can be possible with Apple script like the FM to iCal solution. Any info out there? Thank TMAS

I have the following script: tell application "FileMaker Pro" go to layout layoutName of database databaseName show every record of database databaseName -- this should do the find, but for some reason, I cannot enter data into a calc field - even in a find request delete every request set myRequest to create request of layout layoutName set cell mySearchField of myRequest to mySearchText find end tell For some reason, when mySearchField is a calculation field, I get a "Write permission denied" error in AppleScript. Even those if I get permission on the field it shows I have write permission. I can also manually search in this field o…

Hi, I am mailing two users whenever a new contact is created. The client wants a button in the mail to go straight to that contact in Filemaker. I don't think I can put a button in a mail but I can include a link. Can I create a URL which will do what is required? This solution is not web enabled. Running from FMS8.04 on Windows Server 2003. Clients running OS X, mainly FM8.5 but one (the MD) who still runs FM8 due to printing issues. Thanks for any help possible, Norman

Trying to script creation of new PDF files dynamically, having problems on one client running OS 10.3.9 (works fine on 10.4 and above) I’ve boiled it down to the fact that this applescript step: /* applescript steps to execute */ "property folder_name: " & Trim(CHARTS::financial_number) & "¶" & "tell application "Finder"" & "¶" & "set pdf_folder to (desktop as string) & "PDF"" & "¶" & "make folder at folder pdf_folder with properties {name:folder_name}¶" & "end tell" works fine on OS 10.4, but not, apparently, on 10.3.9 (on 10.3.9 it creates untitled folders, rather than one named as the financ…