AppleScript & Automator

This is a snippet of a script which works fine when running from the Applescript script editor. It just creates/opens a small text file on the startup disk, writes some text to it, and then closes the file. However, when you try to put this applescript into Filemaker Scriptmaker in a Perform Applescript statement it comes up with the error "Expected end of line but found identifer" and highlights "thetext" where it says "write thetext to fileref" when you try to compile it. Any reasons why it wont compile within Filemaker and any way to get around this? thanks. set thetext to "Hello this is a test" set startpath to (path to startup disk) …

In the process of updating an old solution for a client. There is a run-only applescript that does "who knows what" being called from FM. Has anyone successfully opened a run-only copy of an applescript. I just want to look at the code in any shape or form to see what it does and rebuild it. Thanks

I am trying to upload a database to a web server via Fetch 4.0.3. Filemaker 6 is initiating the applescript from a Filemaker script. Everything works well, until an error appears. Fetch begins the upload, and in exactly 2 minutes Filemaker posts this error: Fetch 4.0.3 got an error: AppleEvent timed out. (Error -1712). Fetch is, in fact, still uploading, but my Filemaker script continues to the next step, sending an email telling the host to swap out the database. But it's not fully uploaded yet! So, I need some way to supress the error, or set a timeout somewhere longer. Here is my code (I made the delay long to see if there is a change. Result: no …

I am setting up a script to parse information from certain emails so that in can create new records in a database, and I am almost there but for some reason that I cannot fathom Filemaker overwrites the information in the first record of the database rather than putting it into the new record that the script creates. Would anyone know where I am going wrong. Here's the script tell application "Mail" set the_message to item 1 of (get selection) set message_text to content of the_message as string set nom_list to paragraph 4 of message_text set nom_list to items of nom_list count items of nom_list copy result to total_nom set nom to items 7 th…

Hi: I have built a database solution into which data is entered by users on PC's. The database is then opened on a Mac and then the Mac user hits a button that invokes Applescripts embedded in the database, different types of ads are then created in Adobe InDesign. My question is how can I have the PC user send a command to Build the ads on the Mac machine. Putting InDesign on the PC is not an option. The database is shared using Filemaker network. Thanks in advance Daibhead

Morning all. Has anyone come across an issue where an Applescript will work fine for a while and then stop working for no reason? We seem to have pinned it down (maybe) to opening the Applescript inside an FM script for reference and somehow something changes and stops the script from working, although there appears to be no visible change. We also seem to be able to fix it by cutting the Applescript, coming out of script editor, going back in and pasting the same Applescript back into the FM script. Has anyone else experienced this?

Hi, I am writing a db with the intent of comparing the prices of a list of stocks over a period of time. To do this I import prices daily with an applescript which takes me to yahoo from where I can download my list in spreadsheet form. Then I import to FM. It would be ever so convenient to be able to do this from within FM7 with a script. Any suggestions? Thanks yknot

Hi, Im running filmaker server 7. it was running on a OS 10.2.8 server, Recently our hardware guy installed over it OS 10.4.2 server and everything seemed to be working, However now i cannot perform the applescript that used to work fine when the filemaker server was on 10.2.8 Like so set userComp to (do shell script "echo $USER") set fold_path to "Macintosh HD:Users:Shared:Exported images:" tell application "Finder" delete every item of folder fold_path end tell Now it doesnt do a thing , wondering is the upgrade the problem or is there a setting i need to fiddle with somehwere, as always thanks for any help. D

Anyone know how to open a database on FM Server using AppleScript. The following works for a local database, but there is not a similar Open Remote command in the FMP dictionary property DBPath "Macintosh HD:Users:syounker:Desktop:Home:My Database.fp7" property DBAccount : "My Account" property DBPW : "Password open file DBPath for Accounts DBAccount with passwords DBPW

I new to Filemaker, and I have created a letterhead, and at the top of the letterhead, I want the current date to be displayed. By current date, I mean whatever day I decide to write a letter, I automatically want that date displayed on the letterhead. How do I go about doing this. I created a field called "Today's Date" and set the type to "date", tried running some scripts I read about, but can't get it to work. What I am doing wrong.

My AppleScript skills are fairly minimal, but I'm needing to get some XML parsed out of an email (either from Entourage or Mail.app) then stuffed into FileMaker. (XML coming from the Yahoo Store, confirming an order) I have been playing with it (in Entourage), and I've made some progress, however I'm not good enough at dealing with corner cases like missing fields or multiple line items. Once all the info is parsed out of the XML I can probably do the rest, but maybe not. Anyway, I'd like to hire this out, I'm looking for interested parties or for recommendations.

I have a short AppleScript to insert a text file into a specific field in FM8. However, I only want the file to go into the field of the Current Record. Is there a way of doing this using: set cell "XYZ" of record Current Record of table "ABC" to text_file As text ? Thanks, Charlie

Can't seem to figure out the X-ABShowAs function in Apple AddressBook. In AddressBook you can click the checkbox 'Company' making the card show the company name. When creating a vCard from AB it shows 'X-ABShowAs:COMPANY'. [color:red] With a applescript I am exporting from FileMaker but how can I set the card with the Company checkbox? I get Access not Allowed when i try to add the X-ABShowAs with applescript. Does anyone have experience with this particular function? Would be great to hear it.

Is there a terminal or applescript way to open and close a filemaker file on a server? The script would reside on the server and be accessed accross the network. It is further complicated by the user selecting a particular file by an applescript dialog. The reason want to do this is I have a number of project based databases that need to be converted into a updated version and am only using peer to peer networking. thanks

Is there a way to return whether a field is indexed or not in Applescript? I can't find a property that does this in the Applescript dictionary, and I refuse to believe that it can't be done. I mean, we can return a lot of other stuff, this seems pretty important as well. Thanks!

Hi I want an applescript to copy something to the clipboard in Safari and then to paste it into a given field in Filemaker and I can't work out how to get Applescript to recognize the given field. Would any body be able to help me. Here is my script so far. tell application "Safari" activate tell application "System Events" tell application process "Safari" keystroke "c" using command down keystroke return end tell end tell end tell tell application "FileMaker Pro" activate set field "commentaire" of current record to clipboard end tell The line "set field "commentaire" of current record to clipboard" obviously does n…

I have a problem getting Applescript to click a button on a web page. And although it is the only button on the page I cannot use the usual option of "keystroke return" as it simply doesn't work. My script goes like this and it is the line «click button "login"» that provokes the error. The problem does not stem from the password or User ID not being correct or entered as Safari does this automatically. Any ideas on remedying this? tell application "Safari" activate make new document set URL of document 1 to "https://www.orange.ch/footer/login" end tell if page_loaded(5) then tell application "System Events" tell application process "Safari" …

Hi there, Just wondering if someone could help me with something. Say I have an Applescript which has some variables in it such as emailSubject, emailMessage etc... How can I easily call this script from Filemaker instead of typing the whole thing in and at the same time as calling it pass in the emailSubject, emailMessage variables from data supplied via Filemaker fields. I would like to basically be able to pass data from Filemaker to the script. The script would be used for emailing and as I want different details each time I do not want to have to hard code in the variables as they will need to be dynamically generated via Filemaker. Any …

Hello, Preface: I'm working with FM Pro 6. In my case I have an AppleScript that uses a tell application "Filemaker Pro" block in it to retrieve records from a Works database table that has relations to three other tables (titles, creators, images). So in the layouts, there will be references to fields like "Titles::Title Qualifier", etc. The problem I'm having is that when I reference the related data in a set statement it works most times but not others. I don't understand why the syntax will work in one place and not the other. The only issue that I thought was the fact that all the references were not on the same layout. But even adding code to sw…

Is there a way to have FileMaker automatically connect to a remote volume though AppleScript or other method. I actually am trying to do this on Mac and Win. but thought I would start here. Any suggestions would be most welcome.

This works in apple script but not in Filemaker. and falls over at the line- "set this_data to ((read FMFile) & return as string)" I am adding a tab separated file (exported from FM) to another file which is created by the script and contains the exported files field titles. For the script to work it needs a tab separated file on the desktop called "export.txt" (with 6 fields) Any ideas why it works in applescript and not in file maker? Thanks as always -------------------------------------- set this_data to "First" & tab & "Last" & tab & "Company" & tab & "Job title" & tab & "Email" & tab & "mobi…

A small FM8 file and Automator app to show how to burn discs with bit more automation. The file first deletes old pdf, if exists, creates a new pdf of records being browsed, bit of applescript calls the automator app that burns the pdf onto a disk. Burn.zip

Hope someone can help me !! I'm trying to create a new event in iCal using a date field from Filemaker using Applescript. Here is the script i've got: set calTitle to "Work" set eventTitle to "Filemaker Test" set eventDay to cell "date_day" of current record set eventMonth to cell "date_month" of current record set eventYear to cell "date_year" of current record tell application "iCal" set bDate to current date set time of bDate to 32400 -- seconds, = 9 hours = 9am set year of bDate to eventYear set month of bDate to eventMonth set day of bDate to eventDay set myevent to make new event at the end of events of (item 1 of (calen…

I can't find the solution to this anywhere, hopefully you can help. I'm writing an applescript that controls BBEdit's wonderful find and replace function to modify a link in a web page. The value it modifies is based on a LastName field in a Filemaker database. Here is the problem: When I set the variable LastName in Filemaker, BBEdit errors during the replace step. But when I set the variable directly all works fine. Here is how I set the variable in Filemaker: tell application "FileMaker Developer" tell current record of layout "data_entry_T" --script doesn't work if setting LastName using Filemaker set LastName to cell "Last Name" as string …

Hi, I want to move a FileMaker 5 application using "AppleScript" from MAC to PC(Windwos XP Pro and FileMaker 6). What is the Windows equivalent for Mac's "Perform AppleScript"... Thank you for your help in advance!

Can I trigger an applescript from a calculation field? Short explanation of what I am trying to do. I have a database of local bands that have played my club. I have many of their demo songs in iTunes. I would like to have a field in the database that will search iTunes for their band name, and return a list of the tracks available in itunes from said band. Is this even possible? Thanks

I have a solution that requires am AppleScript scripting addition. Is is possible with FMP8 to check for the file, and if is does not exists, export the zipped addition from a container field to the desktop, expand it, then move into main libraries scripting additions folder.

Does anyone have an idea how to export records to an SLK type file, where the filename is automatically determined trough a field which is available in the database? Let me explain: I have a database with several records, the first field ofthe last record contains the desired filename. Exporting this data works fine, but only with a fixed filename, this is done in the export scriptstep (filename:"blahblah" - type "SLK") It would be a lot more interesting if the filename that is determined in the field of that last record becomes actually the exportfilename. As the operating system is WIN XP, I presume that Applescript doesnt work …

Is it possible with Applescript (or any other way) to embed an image into a database. I have run scripts that place an image into a container, but this is only a reference to the image. For example: set folderPath to choose folder tell application "FileMaker Developer" activate repeat with i from 1 to count of records tell record i set pictureFileName to cell "Ad Number" & ".pdf" as string try set cell "Picture" to file (folderPath & pictureFileName as string) end try end tell end repeat end tell activate display dialog "Done"

Does anyone know of a method to export a 140 record FileMaker Pro v.7 list into the Mac's Address Book Version 4.0.2 (475) - vCard file?

I have a db that has a validation of 'not empty' and also has strict and a message on it. But now I'd like to script making records into the db but also need the validation for when users manually enter info. When I script a record to be made and try to enter the info into a field when the validation is on, it fails, but when I turn off the validation on the field then I can add any info I like. Can I get around this at all? [color:blue]set myNewRecord to create record go to myNewRecord set cell "BookCode" of myNewRecord to "0027000605"

Hello, I have an applescript to send a freehand file from filemaker. I need to change the freehand mx file to freehand 9 and send it with mail. The script: set originFolder to desktop folder set caminoanexo to choose file with prompt "Selecciona el fichero mx" set EPS_Location to originFolder & caminoanexo & ".fh9" as string tell application "FreeHand MX" open caminoanexo without Dialogs save last document as FH9 in file EPS_Location without IncludeFHDocInEPS close last document end tell tell application "Mail" set newMessage to make new outgoing message with properties {subject:"prueba tal y tal", content:"Atenci

Hi there, I was just wondering if someone could help me with a (hopefully) small problem I am having. I recently downloaded the xMail OSAX from http://www.osaxen.com and have successfully configured an email script for our SMTP server. This all works fine with the Apple Script Editor and hard coded values. The problem I am having is that I need to be able to send the following variables from Filemaker to the script emailSubject - emailMessage - emailSender - emailRecipient I currently have them hard coded into the script but would like to be able to fill in some fields in Filemaker and then have Filemaker send these values to the script (should i…

hello all, osx has its own inbuild smtp server, not a secret. i have a script with only one step (perform applescript) which contains this do shell script "echo hello | mail -s 'test' [email protected]" this sends one email with the content hello and the subject test to [email protected]. now the question is how can i parse the contents of a text field instead of just hello? i must somehow let it know which field, like set the field to somefield, and then call it with echo $field i believe. any ideas? overrider

I need to make a test in finder within applescript as a step in a filemaker script. If it is false I'd like the filemaker script to exit as well. Is this possible? Basically I have a finder dialog that has Cancel button in it. I'd rather it wasnt there but I dont think I can stop that. If a user hits the cancel it messes with the script

I'm kind of a beginner with FMP and a real newbie with Applescript. I've created a DVD library (based intially on the Film Library Template) and now have some 300 titles added. I'm now adding the VIDEO_TS data to my hard disk and would like to play them from FMP. I've added a play button to one of my layouts to call an applescrpt to enable me to play the currently displayed DVD title. The location for the DVD data is as follows; HD:Users:Me:Movies:Library:X:VIDEO_TS Where X represents the "FilmID" cell of the current record. How do I build a pathname in Applescript that will get the value of X from the cell "FilmID" from the current record? I've man…

I have a simple apple script that beeps when an order is placed through IWP. Because of the nature of FM 7 Server and Server Advanced I cannot have the server computer make the beep noise. I have created a script in ScriptMaker that calls the apple script. I would like to have the client computer send the apple script request to the server computer. Can this be done? If yes, how would I do it. Thanks in advance - Sam

I am looking to add a button that will move a name, email address, and phone# to Mac Address Book. I am also looking for an AppleScript that will move a date and description to iCal. Thanks in advance. Jim

The question is : How to set the value of an FM field from an AppleScript ? I tried : tell app "FileMaker Developer" set cell "test::test" to "Hello World!" end tell but an error occured...

So I think I discovered a little FileMaker / AppleScript quirk and I wanted to confirm it here. It may be very well known... I was trying out some test scripts just to get the hang of things and I had one script that just displayed a dialog with some values from the database. My invoice database has fields for customer_id and customer_name. I could display the id, but the name kept on giving me an Object Not Found error. I finally figured out (I think) that the problem was that customer_name wasn't displayed on the layout (a calculated field - customer_name_city was). I tried out other fields and got the same behavior: unless a field is actually displayed on the…

Hi! I know absolutely nothing about AppleScript, and in fact only started using FileMaker a short while ago. I thought, like most other things, I would be able to find engouh examples or at least a reference on applescripting to be able to write a script, but I was wrong. Really, really wrong. Because I can't find anything close to what I want to do, which is shocking. Anyway, on to the task at hand: I need to be able to click a button in my database that will say "Add event to iCal" and actually have that event added to iCal. That's it. Nothing fancy. But anything I've tried has been a stab in the dark and has produced either no results, or error messages. Does anyb…

Hi there, I want to cahnge my exported file's name by any text in my global field in FileMaker. For windows version i am using dos commands (ren command) to change filename after i exported from filemaker. It is works but now my problem is mac version how can i change exported file name? New file name should be get from filemaker field. Apple script can help me? But i don't know Apple Script. Can anybody help me? Thanks Adam

I have inherited a FM Pro Version 4 application that runs fine. I want to copy the approx 50 tables to my personal Mac OS X Tiger machine, so that I can use the data in a read only format. I have downloaded the FM Pro 7 trial version and it will convert the tables. Akwardly, and with lots of dialogs thrown up, but the actual data looks good. Before I ante up my $300 for Version 7, I'm hoping somebody will comment if I'm on the right track. One of the things I want to do is lookup values from these tables from Automator or Applescript. When I look in Automator, I do not see any actions for FM Pro 7. Are there actions available either from Filemaker o…

Does anyone know how to use applescript to save a PDF in Safari? I want to insert the PDF into a container field once they enter a URL. Here is the task: User enter a URL into a FMP field, clicks button Open that URL in Safari Safari saves web page as PDF on desktop FMP7 inserts file as Quicktime (so user can read it in FMP) Delete PDF on desktop. I've looked around and can't find anyway to do this without making a PDF printer. This will be in a networked environment so I don't want to set it up a PDF printer on all Macs involved. Is there a way to script the "Save as PDF" button the the print dialog?

originally i needed to set some fields from FMP to applescript variables for faxing purposes. Originally i had: set FaxName to (get cell "Name" of current record of layout "Fax Forget Letter" of database "Invoices") I get this error message: Filemaker Pro got an error: Object not found. (error -1728). I've looked everywhere for this (probably not hard enough) and wondered if you could point me in the right direction. Thanks for the help in advance. Mike

Is there a way to take a file from a location on my computer rename it with a document serial number from my database, insert it into a network attached storage device then save that location as a reference in my database?

Hi everybody. I'm completly new to FMP so plesase be easy on me. I am making a database for my sound effects library which is made up of .wav files. I want to be able to insert a Quicktime movie into a container field named "Audio" by specifiying a file path from a field called "Filepath". I tried using the Insert Movie script step but it doesn't allow me to specify a file path. It only lets me specify one file. I'd like to write an applescript that would tell the application "FileMaker Pro" to do this. Is there anyone who would have a similar example. Later I would automate this process so every time I select a field the Quicktime movie is loaded ready for au…

Hello List, I put together a very small complaint logging DB that sits on the desktop of a machine that is running only one other program. I have written a script which commits the record, and then runs an Applescript to switch to the other application. In Developer 7, the applescript is as follows Tell application "Finder" Tell application "Cuestation" to Activate End Tell The script works fine on my machine, but when I put the runtime on the other computer, instead of opening "Cuestation" it opens Simple Text. So, I wrote the script in Script Editor on the other computer and compiled it, and it asked where Cuestation was. I told it, and the sc…

I have created a simple apple script to launch mac mail, new message to run in FM. I have two commands for the to recipient but not sure of the commands for the CC or BCC field in a new mail message. set theAddress to cell "toEmailAddress" of current record -- then compiled with make new to recipient at end of to recipients with properties {address:theAddress} thanks for any help!

Hello, I've got a simple script to get the file path of folders and enter it into a clickable field. set folderChoice to (choose folder) as string set cell "location" of current record of layout "Main" to folderChoice It runs great the first time I use it, when I use it again....I receive the following error... Data is being accessed by another user, script, or transaction.(Error -10011) Any help would be appreciated. Thanks!

How can I access a cell in a portal row? This did not work: tell application "FileMaker" set myURL to cell "URL" of current record end tell and this neither: tell application "FileMaker" set myURL to cell "URL" of table "Exemplare" of current record end tell where table "Exemplare" is the portal table. Thanks for your help.

I am transferring some data fields from one FM DB to another FM DB. but when the date field format of the source and receiving DB is (for example) 14/3/05 Ihave no problem setting the destination date field When the source date format is (say) 14 Mar 2005 the receiving end responds with a "invalid data supplied" error even if I set the layout date field formats to be identical. I am running FM3 and FM4 Is there any way I can coerce the date field data en route and change the format ?

Hi, I have been using FMP 7 for a little under a year and Applescript a little longer, and I'm trying to do something that seems like it should be really simple in FMP 7, even without Applescript. I want to import an existing Excel table into an existing FMP database as a new table with all of the field names automatically created from the Excel table's header row. I can get the Excel table to open in a NEW FMP database by simply drag and dropping the excel table onto FMP, but then I see no way of importing this table into the other existing FMP database without manually creating the table and all the field names to import into. So.... now I am trying to create an Ap…

I have created an AppleScript which works fine when I run from my AppleScript Editor. But when I copy it into FM and after I escaped all quotes I can't get it to run. It runs fine in FM as native script, but when I try to use it as Calculated AppleScript I get errors. Here is my script: property theFMPath : "file:/Mac hd/Users/X/Documents/foo/bar/baz/quux v1M 0.9.fp7" property theFMFile : "quux v1M 0.9.fp7" property theFolder : "export " & theFMFile property theAlias : "export" tell application "Finder" --Convert path from FM format (file:/foo/bar/baz/quux.fp7) to AS format (foo/bar/baz) log "theFMPath = " & theFMPath set savedTextIt…

I need some assitance with a shell command. How can I use a shell command to export a set of related records with the file name set to be the related field? I have the database for a newspaper website, all stories entered by issue umber- there are over 300 issues. I have a script that finds the related fields, and exports them, but i currently have to manually enter the issue number for the file name. I don't really want to have to type "issue650.txt" issue651.txt etc... any ideas? THANKS!

Please help: I create a FM-Script to import manually a xml-file with a stylesheet. I like to create a hotfolder; somebody in my network save a xml-file in the hotfolder and the script create FM-Records from the xml-file and delete after the creation the xml-file. The stylesheet is for all cases the same - the xml-files have different names without control. (Sorry for bad english - best wishes from Frankfurt/germany)

Hi All, I have written an applescript that will run a script within FM7. But I am unable to get the script to automatically run without the applescript run dialog. How do I automatically run the script upon open? Thanks for any help

I have a simple script which takes a cell value from one db and creates a new record in another db with the same cell value. (Then relationships, portals, and other cool things happen.) The script works great from Script Editor, over and over again. When I copy the script into FM Pro 6 or Developer 7 it fails. The script: tell application "FileMaker Developer" tell window "ProductionShedule" tell current record set ProdSchedSN to (get cellValue of cell "ProdSchedSN") end tell end tell tell window "Materials" tell (create new record) copy ProdSchedSN to cell "ProdSchedSN" end tell end tell end tell V7 errors: Write ac…

Is there a way to test for the existence of an import file, before actually trying to perform an import? We have a FM DB that is supposed to clear out all previous records, before loading a fresh set from a text file copied to the server from other machines. There's no point in deleting the old records if the new ones are not yet available (for whatever reason); since the old import source files are deleted after every successful import, how can we see if the new ones have arrived, so that we don't prematurely erase the old data?

We have just upgraded from FM6 to FM7 and as many of you have posted, this can throw a wrench into existing AppleScripts. Thanks to the many existing FM Forum posts we have been able to fix most of our AppleScripts so that they work in FM7, but there is one that we just can

My script is pretty simple, just inputing data from variables into newly created cells. (Can't find any info on how to do even this.) Using FM to track time spent working on a project, so there's date, time, and client code fields. I can gather all my variables, but have no idea on how to put them into FM. I've had experience scripting DTP applications, but this is my first foray into scripting FileMaker and I'm having difficulty finding any information on the subject. Does anyone know of a book or website where I could pick up some rudimentary knowledge?

Hi I was trying to find a way to make a daily backup of my labdatabase db, And finally. I did it by running an external file by using ical, everyday. from this file, i am running a script which 1 Saves a copy of my database (by executing the script in labdatabase by using file reference) 2 and Perform Applescript, and rename the copied file, (I tried performing this script step both from the scriptrunner file(the external file) and from the labdatabase file) 3 close the scriptrunner file... By this way, I am able to make daily backups which has the current date appended to the name of db This method used to work for about a month, However, suddenly it s…

Is there a way to check if a _specific_ error occurred? It seems like if you use the TRY command, you can trap error conditions, but there's no method for seeing what the problem actually was. Does anyone have a way to check this? Does there exist a list of numerical equivalents for Filemaker Applescript errors?

We have a machine running FM 7 Pro Client, and a number of cron jobs that trigger applescripts at various times of day. One script in particular seems to refuse to run to completion, when left to run overnight. The script always times out, and the script application cheerfully informs me that it experienced an "Object Not Found" error. However, if I manually trigger the script by hand, it works fine. My question is this: when running an applescript under Filemaker, and you want to have a Filemaker Script called via the "Tell" command, does it matter which Filemaker DB window you are currently "in"? In other words - since the contents of the FM "Scripts" menu …

I'm trying to create an applescript that will save the contents of a mailbox to a text file which I can then import into Filemaker. I searched here and at macscripter.net and can't find anything related to this. To do this manually in Mail, simply select all the messages in the mailbox and then select Save As.. from the file menu. Here is my script: set destination_file to ((path to desktop as string) & "MailOut.txt") tell application "Mail" set exportmessages to every message in mailbox "MailtoExport" save exportmessages in destination_file as text end tell From the event log, it appears to be getting the messages into "exportmessages" oka…

Hallo I'm trying to automate the process of inserting word documents into container fields (reference only) using applescript and I'm missing something. If I use set file_path to (choose file) as string and later set the cell "Pathname" to file_path the container holds the pathname as a string and wont launch the file on manual entry/ double click to the field If I use set file_path to (choose file) or set file_path to (choose file) as alias Then later Applescript "Gets an error.. Filemaker cant set ...etc etc" Any thoughts or assistance greatly appreciated. Thanks Simon

How can i get the relationship names and details using applescript? I'm using Filemaker Pro 5.5. Thanks.

Hi there, I'm new to Applescript and FileMaker although I've done a bit of database development on Windows and Linux. I've having trouble working out in advance what is possible with Applescript and FMPro. In particular I want to read a folder of filenames and if they match a rule create a record that has container field with a reference to an image filename. I am not clear whether I need the improvements to the container field brought in for Filemaker 7 or not. Can I construct a string that points to a filepath and insert it into a container field in FileMaker 6? I am not going to have access to a Mac until I have agreed to do the work or else I…

Hi I'm trying to run an AppleScript but I get an error from FileMaker 6 stating "Your password does not allow this action". The AppleScript only works if I open the file with developer password which I can't allow. Is there any way for FileMaker 6 to allow running the script with a user level password and not developer password. Thanks.

Hi there - we are a small company big into skype and we use FP7 for our contacts database. I am fairly new at all of this but have found that I can do some amazing scipting within the FP7 application. I now want to take it a step further and use the data held in the contacts database (namely the telephone number) and get it to automatically call the number using skype (www.skype.com) My issue is that I cannot define a parameter to pass to the applescript I have been using a select field and copy statement but then where do I paste it or set it as the passable parameter? This skpe code below works well but I just need the last bit to get it to work …

Riddle me this experts. The following is part of an AppleScript being called from within FM 7 with a perform AppleScript command. show (records whose cell "Committee" = "MA Thesis" or cell "Committee" = "MS Thesis" and cell "Include/Skip" = "Include") It runs without error, but only shows records based on the first criteria. If I take off the [color:"blue"] and cell "Include/Skip" = "Include" it properly shows records based on [color:"blue"] "Committee" = "MA Thesis" or "Committee" = "MS Thesis". If I put [color:"blue"]and cell "Include/Skip" = "Include" first, it shows records based on [color:"blue"]and cell "Include/Skip" = "Include" and the first of the …

This is my set up: UI.fp7, Tabs.fp7. There is references between the two. My problem is that when trying to ' set cellValue of cell "Tabs::foo" ' i a layout in the UI-file, I get an error message (-10006) telling me I can't write access that cell. I do have write permissions in both MacOS and FileMaker. Please give me a hint! I can really use it:)

Ok i have read some of the other posts about geeting infomrationfrom/into cells in filemaker 7 and none of them seem to help! tell app "Filemaker Dveloper 7" tell database "mydb" tell current record set theone to cell "ONE" --this is on the visible layout so it returns a result set thetwo to cell "TWO" -- this is not visible on the layout so "Object is not found" end tell end tell end tell Ok, so how can i get the value of cell "TWO" from the current record, when that field it is not visible on the layout. Just can't seem to get it to work! Any help very greatly appreciated.

Hi, Curious if AppleScript could handle this from FileMaker. What I'd like to do is to open a Chat with one default adress by a single click. If this first step is possible, how about automatically entering into the message box a previously stored message in a global. Using either IChat, Msn or ICQ, on a single solution I'm developing for a MacOS Panther user. Thanks for any insight.

I've searched through the archives, but haven't found something that solved my issue. I have a number of records in a table and I am trying to use field values from each to rename files in a folder. I have written the following AppleScript. When I try to run it, AppleScript throws an error saying it cannot rename the file identified in the first record. Yet when I look at the Finder, that file has, in fact, been renamed. Each of the records has a different value in the field for the "new name". I wasn't positive if the variable "recordLoop" was automatically incremented, but either with or without the incrementation line, I get the same error. Anyone hav…

I am trying to read in the titles of files in a folder, add records to a FM database and fill in a field with the title of each of the files. I cannot get the command to create a new record to work. I have searched this forum as well as other internet resources with no success. At the "create new record" step, I get the "Set Data failed. Invalid data was supplied" error. What am I messing up here? ----------------------------------------------------- copy (choose folder) to foldername --select the source folder copy (list folder foldername) to folderstuff copy (count of folderstuff) to thecount copy {} to fileList repeat with num1 from 1 to thecoun…

Running FMPro 7 locally... I run the following script and I'm getting an error (Timeout on appleEvent) on the SECOND "activate" command. The first 'tell... end tell' section works perfectly, but the second seems to fail. I thought it was an error in the second FM database, but I switched the order and the problem still comes up during the second "activate". - Just for fun, I removed the second "activate" and the same timeout error occurs on the "open file..." command. - The last command in the FIRST FM database script is to "close document" (which works fine). Is this more AppleScript voodoo?? Thanks in advance for any help/advice. tel…

Hello, I'm a beginer in development in FM Pro and applescript. I'm trying to make an applescript that import (every night) a lot of pictures into a database and also some information (modification date, size,...). I have made it but i have a problem with pictures. I try to import and embedded pictures into my database and not import references. Because, when i use the web sharing of FM PRO 7 (with safari or IE) i don't see the pictures. 1. If i use the web sharing with FM PRO server with the advanced package should i see the pictures that are in references into my database ? 2. If you have a part of script that import picture (not references) into…

Hi everyone, As a new trainee on a filemaker project but learning Filemaker and Applescript in the same time, i'm coping with small troubles implementing "basic" scripts... I want to insert an applescript longer than 255 characters in a field, with a calculated result (fields containaing paths, names....). At the beginning, i was just inserting text , without calculation in the field, no worries. Troubles came with the calculated result try. Originally, i didn't saw any reason for it to be a difficulty but when i try to implement it, the text field is limited to 255 characters or so.... So, i read something about defining a text field with the auto-e…

We have built a database in which we track our jobs. Part of each job involves posting comps to the clients section of our website. Right now this involves manually creating new HTML pages that all use the defined jobnumber from the db, putting our work onto it and posting for the client to look at. I am wondering if anyone on the forum has experience using Applescript to generate HTML documents so that we would cut out that step of the process? In other words, when we hit the "Create new job" button it would perform a script that generates all of the HTML documents with the appropriate job number, client name, and job title within the HTML code. Does anyone hav…

Hello everyone, My experience with AppleScript is a bit behind the rest of you but this is what I want to do. I want to create a new text file with text from a FMP database. So I would like to take the following: table.fp5 > field: MyText > data: "blah" and create a new file with the text "blah" from the field MyText. How do I go about scripting this in AppleScript. -Al

I am a newbie to all of this and little idea of what I am doing. I am trying to create an Applescript in FM that will create a new folder and name that folder by the JobNum field (it is a serial number to identify that record). Here is the script that I currently have: tell application "Finder" activate make new folder at folder "Current Jobs" of startup disk with properties {name: JobNum} end tell The error message that I get when I use this script is: "The variable JobNum is not defined." I am having a hard time figuring out what this means and how I can get this script to work. Any help is much appreciated!

Hi! I have following problem with Filemaker 7: I have a solution, which copies all selected tracks of a cd (or mp3-files) from itunes to filemaker. This works fine with filemaker 6 but not with filemaker 7. Because there is a real cool command in filemaker 6: If you have a cd, with title, etc, and the songs in a portal (connect per unique key in filemaker). In FM 6, following statement worked: set cell "Songs::Songtitle" of newRec to TrackNames an Tracknames is a liste: {"Song 1", "Song 2", "Song 3", ...} But under FM 7 that simple thing does not work. Do you have any idea, if there is an similar solution? best regards, karobert.

I'm having a problem at a customer. He uses a professional FileMaker database with a FileMaker Server and FileMaker Client 5.5, both on Mac OS X 10.3. I (poorly) don't know, what's happening in this database. When the user opens the database with the Hosts-Menu, everything works well. I wanted to make it easier for the customer to open the database with an AppleScript, so that he does not have to use the way with Open-Menu, click Hosts and than look in the list of databases for the correct one. This script looks like this: tell application "FileMaker Pro" open database "userdatabase.fp5" end tell But what happens if I use this one, is that I get…

Hello Anybody, I am a FM7 neophyte. I have database with a list of emails, some of which I have now discovered are wrong. I have a txt file with a list of emails that need to be erased. How can I import this list which FM7 will then search my databsae and erase the listed addresses? Even better, can I replace them automatically with another address

I'm having a problem getting 'show records' to work in AppleScript --this code works show (every record of database "Image Library Data" whose cell "File Path" contains "9504095U33.jpg") --this code gives an Event Not Handled error show (every record of database "Image Library Data" whose cell "File Path" contains "Image Bank #1:H&D Images:1995 APRs:9504095U33.jpg") --and so does this show (every record of database "Image Library Data" whose cell "File Path" = "Image Bank #1:H&D Images:1995 APRs:9504095U33.jpg") but if I go into FMP and do a find for this, It properly finds my record. The equal sign and quotes have to be input in the fi…

I have a client that has thousands of images stored in container fields in a FileMaker solution. He would like to be able to "using Applescript" export images from his container fields and save them to a file. He has thousands of images. I would be extremely grateful for any help! In Kindness

I need an applescript to extract the user name from the OSX and place it in a field in a FM file. I think it's the short name that I need. I don't know if there's an equivalent for OS9, but if so, to extract that also would be cool. ...any takers?

This has been driving me nuts for years. I just did some troubleshooting and found that it's only a FileMaker problem, other programs are not affected, so I thought I'd ask here... If you print a page in FileMaker, then change the printer (applescript or manual), then print another page in FileMaker, the print dialog will still show the original printer unless you execute the second print AFTER the first job has FINISHED printing. I always thought it was an Apple problem, but strangely enough, this problem doesn't happen in other apps. It DOES work if you print something with another program, then change printers, then print something within FileMaker while…

The Filemaker 7 Apple Events reference describes a custom reference form for records using the unique record ID. The reference "record ID 23" names the record whose unique record ID is 23. I had hoped to use this reference form to communicate between FM scripts and AppleScripts, using Get(RecordID) in FM to identify the unique record ID to pass it to an AppleScript. (Specifically, I use a calculation to create an AppleScript containing that reference.) However, I have discovered that the unique ID for a record as used in Apple Events is not necessarily the same as the value returned by Get(RecordID). In my particular case, IDs less than 128 are the same, but larger ones d…

Hi Guys, A little off topic, but can anyone tell me how to call an Excel macro using applescript. I intend to call the applescript via FileMaker. The Macro I want to call is called Macro1(). The actual file is called Worksheet1.xls . Im using Excel 2004 Any help would be much appreciated, I've searched in google, and not found anything that works.

I'm working on an AppleScript to sort images with the help of Filemaker... tell application "FileMaker Developer" tell document "mydatabase.fp7" activate tell layout "all" go to cell "c_fileName" show (records whose cell "c_fileName" is [color:"red"]FileName) set ownrName to cell "Manufacturer" set mnfrName to cell "Manufacturer" set pdctName to cell "subBrand" end tell end tell end tell now this works great if I use: property FileName "DTM_13380.jpg" --- or -- set FileName to "DTM_13380.jpg" as text but NOT if I get the file name this way: set defTID to AppleScript's text item delimiters set fi…

I just want a little app where I can enter in a search string and then have filemaker display matching records: tell application "Finder" display dialog "Search Videos by Title" default answer "Enter Title" buttons

Hi, I'm a novice and I hope someone can help me with my troubles. I'm trying to create an applescript which downloads a file to the desktop, then opens the file and reads it into a string: ------ set the target_URL to the clipboard set the destination_file to ((path to desktop as string) & "maptemp.htm") tell application "URL Access Scripting" download target_URL to file destination_file replacing yes end tell open for access destination_file set filedata to (

I have a FM7 database of a club membership and want to have the database open with the date on which it gets opened. In other words, the date should automatically update itself every time the database gets opened. Since I am very new to FM and to AppleScript can anyone provide me with assistance to achieve this? Many thanks Roger

Hi I've added the following script to some databases I administer inhouse that request a password after a specific date has passed. This script is set as the startup script (using "Perform AppleScript" in Scriptmaker) - each month I'll change the expiration date so users should never see it. Bearing in mind that I'm the only one with the admin password, access to document prefs and scriptmaker is there anyway users can bypass this if they don't have the admin password. If anyone has a better way of writing the script I'd be interested in that as well Ta!! ---------------------------------- property expiration date "January 11, 2005" property mypa…

I would like to be able to compress (zip, is probably prefered) the files that I import into my FMP7 database. Obviously I could do this manually by first compressing the file, then importing it, but I was hoping that there was a more automated way to do this. Specifically, I would like to have a button trigger a script that would compress the file on the computer, then import it into the container field. If there's a way for FMP7 to do this on its own, then that's great, but I'm not thinking that this is possible. Because of this I was thinking that I could use AppleScript (which I don't know much about) to access the OS's built-in archiving abilities. Thanks in adv…

I'm new to applescript... found this example in a book. Works in FMP 6 not in FMP 7 "Object not Found". its pretty simple... Can someone help Thanks ---- set myfilepath to (choose file "Select file") as string tell application "FileMaker Developer" set cell "path" of current record to myfilepath end tell ----

Hi there. I am a relatively new AS programmer and also new to FM7. I am trying to get applescript to insert values into various related tables in my database. I cannot figure how to make applescript insert a new record to each of the related tables ... simultanously. I.e. I have a "product" table a "sale" table and a "notes" table ... ideally to have multiple sales and notes for each product ... (this is a simplified example, its actually with interest rates, exchange rates, etc where the relationship is not as obvious) I would like to insert a new sale for a new product, and add a note explaining where the product is shipped from ... I have no trouble do…

I have both Filemaker 6 and 7 running on the same machine. If I am trying to run any applescripts with something like "tell application Filemaker Pro" then it automatically grabs FileMaker 6. I want to aceess only FileMaker 7 instead. Any ideas? Thank you very much for your help.