AppleScript & Automator

I saw the discussion, but need clarification/help. We just installed FileMaker Server 5 on a PC Windows 2000 platform which is serving all Mac clients. Since I think I may be able to muddle through AppleScripts to do some automated updates to our database files, I'm wondering how to get the scheduler on the server to run those AppleScripts. Or is there a better way/method to create those updates? Thanks

Want to learn Applescript, but I also need to learn the alternative scripting for Windows so it can work the same way in solutions on both platforms. Is there any?

I've written several AppleScripts that work with Filemaker databases. The scripts usually involve searching database files for records and if not found will insert records into multiple tables. I've noticed that sometimes, I have to perform a search manually in FileMaker and then select show all to get my script to work properly. Otherwise the script search seems to find a match to the first record in the database. I'm guessing that somehow when I manually perform the search, that Filemaker refreshes the index on the [primary key] search field. Is there a way that I can have AppleScript tell FileMaker to re-index fields? I'm thinking this would make sure …

In FileMaker, version 6, when I do this command, set thenames to cell "autors::Name" of current record the result : {"Durant", "Javaux", "Nagy"} = the data of the cell "name" of the 3 related records In FileMaker Pro 7, the result returns only the first item. What's the solution ?

Hi, I was reviewing post #101779 in the "PDF" section of the FM Forums. The post talked about AppleScripting the creation of a PDF. I copied Apple's "AppleScript" as suggested...the script makes a PDF and sends it straight to an email. It works great! I'm just wondering now if there is a way to incorporate making a SECURE PDF into that same AppleScript. Anyone have any ideas or suggestions on where I can find out how to do this? Thanks!! Kristine Stone

I believe on client machine

I was wondering if somebody could help me write a script that would delete every record older than 1 year. Thanks for any help you can provide. FileMaker Version: 7 Platform: Mac OS X Panther

I am wondering if anyone out there could help me out on building a simple script. I don't know too much about scripting so hold tight. I am printing a PS file over the network into a folder on a server. I need a script that automatically takes any file that appears in that folder and moves it to the printer's RIP folder. Only the drop boxes are shared on our network, so I can't directly print to the RIP folder. And I don't want have the RIP folder shared in our network I will list exact folder paths to make it easier. I need any files that get added to server/users/filserver/public/drop box/lop file server/to print and move it to server…

So I discovered that if you use FM7 to host a database (not server just FM7) you can perform a save as copy... script even when there are users connected. (This is different than previous versions, which made you disconnect users, unless you have server) Since live unattended backups are the only feature of server that I really need, FM7 may allow me to have this feature without buying FM7 server. With this small applescript tell application "FileMaker Developer" go to window "database" do script "backup" end tell I can call this script from a shell script and place the shell script in my crontab file, subsequently using another script to gzip…

Trying some basic AppleScript writing to tutor myself, and have run across the following problem while trying to script Filemaker Pro v7: This works fine: show (every record whose cell "Manfr" is equal to "Apple") But I have fallen at the syntax to do the same with multiple criteria ("Apple and Compaq", "A or B") across a single field (or multiple criteria across multiple fields for that matter). Just a syntax problem I assume, but Scriptor is not big on helpful error messages. Also, can't for the life of me get the show every record command to SHOW ALL, simply shows all in current Found set? Newbie questions I know

I would like to have a dialog box display at regular intervals throughout the day to remind users to address a FileMaker file. I am not sure of how to script the time intervals or apply them in an appropriate repeat, as I have no programming background and am teaching myself AppleScript. Can anyone help me with this please? Thanks FileMaker Version: 5 Platform: Mac OS X Jaguar

On a recent project I wanted to embed PDFs into a container field. I used AppleScript to do so, using the GraphicsImporter OSAX to get the image from the file. However I was disappointed to see that I could only get one page. I hadn't thought of this before; but I find that all graphics programs only see the 1st page of a PDF. I want to embed each page into the container field(s), so it is completely viewable within FileMaker, across a simple network; using v.6 (for now anyway). The Preview application is NOT AppleScript, neither is Acrobat Reader. I found a little app that is, PDFpen. It even comes with an example AppleScript for breaking a PDF file into separ…

The .com Solutions Inc. AppleScript scripting language guide provides a side by side quick reference for commonly used FileMaker 6 and FileMaker 7 AppleScript code examples. This FileMaker 7 AppleScript Reference is intended to aid developers who need to migrate existing FileMaker AppleScript code to work with the new relational model incorporated within FileMaker 7. This reference highlights differences in commands and returned values between differing versions of FileMaker, including returned values for field types and calculation formulas. I have attached the current version of the .com Solutions Inc. FileMaker 7 AppleScript Reference, for updated versions please…

Back in fm 4 and 5 (developer) we had an applescript which imported refs to photos in a chosen folder and parsed out some information from the file names. Our users could then use the solution to log the photos and print out photo reports. The only real information entered about each photo in the solution was a location field and a description field. I had another applescript which exported the contents of a calc field "infoComment" which was just location + description to the comment part of the original photo file. So, the real data from this photo logging solution is actually preserved in the file itself and can be parsed back out if the need arises. In th…

I have done alot of scripting in fm, macros ect in excell but never used applescript. I want to learn where and how so I can enhance my fm scripts by using embedded applescripts. In all the tutorials I have looked at you have to use it with appleworks, which I haven't used for a couple years. Where can I go to learn applescripting without having appleworks or is it one in the same? Version: v6.x Platform: Mac OS X Panther

I have used ABDialer successfully, but it seems like there must be a way to dial via a bluetooth phone through applescript directly since you can do from the AddressBook. I can't see why an additional program is needed. Anyone know how to do this? Version: v7.x Platform: Mac OS X Jaguar

whenever anyone sends me an order off my site i get this email: --------- FORM DATA STARTS HERE --------- <First Name> Potato <Last Name> Head <Email> [email protected] <Email Confirmed> [email protected] <Address> Potato House Highland Road Northburog Shiringhamshire IG7 4FX Twoodeland <Refered By> friend <Friend's Email> [email protected] <DVD> Saving Private Ryan <Gift> portabledvd <Comments> make it snappy! <Terms> on <Mobile/Phone Number> 07548 531468 ---------- FORM DATA ENDS HERE ---------- Now t…

I'm trying to have a file open via a "perform Applescript" command in a FileMaker script. When the script gets to the point to open the other file, an error happens that says "Data is being accessed by another user, script, or transaction (error -10011). This other file is not opened at all. Here is the sample of how I have it coded, I need to open several files all of which start with a single letter, thus the variable part of the name of the file. open file ("Artist's Drive:Database Files:" & item i of myParaList & "_Scans_Database") any ideas?

I have had quite the dilemma trying to create a script to rename my files. I have a folder every day with a group of files: k19pe001.vit <---the "19" reprensents the day of the month k19pe002.vit k19pe003.vit k19pe004.vit {and so on...} which i need to rename as e 01.vit0317 <---the "0317" refers to the month (03) and the day (17) e 02.vit0317 e 03.vit0317 e 04.vit0317 {and so on...} i figured that I could wilcard out the "k19" prefix, as it changes daily, creating the new names of the files seems impossible, since "0317" stands for the month and the day, and I would have to alter the script daily to do this... …

Hello, I have a database which i have created for several users . the problem is is that as i use an applescript or two to "alias" files (an applescript and another database ) when i copy the database to another computer the "alias" is lost and the scripts fail . any ideas Paul Apted

Hi, I've been charged with getting someone's template-based FM contact database on to their new Palm m130. I'm thinking of using AppleScript. I haven't got myself a copy Palm Desktop yet, but I'm assuming it doesn't have much AppleScript support. So I was thinking I could use Address Book and iSync to get it on to the Palm. Anyone have any samples or ideas for this?

HI, I don't have any specific need yet at least for now, but I wonder is there any tool that I can use to substitute the Apple Script function in Windows. Because Apple Script won't work in Windows Thanks

I've been trying to open word documents on Mac OS 9 and run into several problems. On OSX and Windows I use the "open url" script step and a calculation field that contains the file-path. This works fine but not on Mac OS 9. On OS 9 internet explorer is opened instead of MSWord (file extension is .doc or .dot). In the internet controlpannel both .dot and .doc are listed to open MSWord. So I've tried to use the "send apple event" script step instead. However, if specify the field containing the file-path I keep getting the message: "<unknown>" could not be found...... I have no idea how to solve this problem. Also on windows XP i have a problem with "send m…

Hi all, I've always tried to keep all FMP activity (scripts, etc.) entirely within FMP itself, and plugin- or AS- free. I am however finding more and more situations where it would be desirable to add some automation outside of FMP itself, in the Mac Finder or the Windows OS environments. Especially when I need to automate data exchanges between FMP and other systems (PHP/mySQL solutions for example). I'll probably be asking a bunch of rather newbie questions in the beginning -- so I appreciate your help, and patience. In this case... I don't need to resize any of my FMP windows (I do that within FMP), but I'd like to simply position the selected table (window…

Hi I am a novice at applescript but I thought it records in filemaker and with text edit. I was trying to make an applescript using the script editor. I hit the record button and did stuff in filemaker and in text edit. I pressed stop and NOTHING recorded. I have not used applescript in system 10 pather yet - so am I doing something wrong? I have no clue on what to do if it does not record my steps. I need help here Thanks Stann

Is there a way to retrieve a JPEG from a given URL (for example http://mySite/myPic.jpg) and store it in a container field? I'm not very good in applescripting, but I think that can be done... Thanks in advance for any help! Paolo.

Does anyone know of a method (AppleScript, standalone app, or otherwise) for taking raw "forms" data which has been received via email (using OSX's Mail.app) from a web site (e.g., name and address data), and converting it to tab-delimited text -- so that it can be imported into a FileMaker database?

Hi all: I've just picked up a job completing an unfinished FM Server solution, and one of the things the client asked for was to integrate all their legacy data into the new solution. This data consists of a ton of Microsoft Word files, and what I would like to allow the user to do is to enter a PO number into a field in FileMaker, which would then launch the correct Word file. All the Word files have the PO number of the record in the file title, so this seems fairly straighforward to me - however, I wonder if anyone has done this with Word, and if there are any pitfalls I should avoid. This would all be done on OS X. Thanks -Stanley

So I have a photo database that I built with FM. In the database, I have a record for each image, with a smallish thumbnail of the image the record relates to. The larger original images are kept in a directory on my drive that has a bunch of subdirectories containing images from different months and locations. I wanted a button in filemaker that I could click and have the large version of the image for that record pop up. The problem was that the paths might change, and I couldn't hard code location data into filemaker. The solution: Write a bit of applescript that uses the terminal to execute unix commands to find the file. So I have a field that cont…

FMP6 osX 10.3 Can I have applescript open window centred in screen?

I need to automatically create PDFs from within FileMaker which need to be Password protected, so that they can only be printed, but not modified. Can someone tell me either how to do this or where to find the respective information in this ever growing Forum? Thanks a lot, Dr. Woo

I am writing an Applescript which finds data in a FileMaker Pro 5 database. Mac OS 9.2.2 My question: Is it possible to do a search in Filemaker from an Applescript, which applies the functionality of Filemaker's Special Find Operators, such as the double equal "== " ? For example in Filemaker if one does a search with a pair of equal signs (==) in front of the text being searched for, that search will return only exact "field content matches" for that search: So a search for "== car" would return only fields which contain only the word... "car" and not would not return a field which contained... "car door" Is there language to execute such a…

Does anyone know of or have an Apllescript that will Change Enter Key at Number Pad to Tab Key?

hi I've got a large amouth of fields I want to copy data from to another field in the same record...using script copy and paste is fine for a small amount of fields but when a large number is involved, I find it long and tedious to define...is there another command I do not know about that would do the trick faster? thanks in advance Luc

I have a repetitive action where a applescript would be very helpful. I create pdf files for my clients out of FileMaker and save the postscript file name which is then converted by Distiller into a pdf. I would like the applescript to do the following: When I press the print button the script should automatically 1. press the Save button, 2. Paste the stored name into the Save as box, 2. press the Save button. Thanks in advance for your help

hello, I have a Database that worked perfectly well in Jaguar ,but alas in Panther it doesn't work .The Script basically reveal's a file in the finder that a record is linked to using the "filepathtext" field ( i set "Filepathtext to Filepathglobal in a script step before this applescript) Now the script goes to the finder and then announces that the file cannot be found ,even if it does. i believe it is the line "if myfile exists then" that is the problem ,if i remove this line and therefore disable the failure dialog the script works fine... any ideas .. here is the script Paul Apted tell Application "FileMaker pro" Set Myfile to cell "finder…

Thanks in advance to anyone who can help a newbie. I have three printers. In OS9 I would use QuickKeys to choose a printer as part of my script for printing a label on my Dymo labelwriter. OSX QuickKeys does not have that option. I need to applescript a printer choice in print center. How do I write a script to choose the Dymo LabelWriter 310 as the printer I wish to point at in the print dialogue box? I have read other posts on this topic and tried those scripts but without success. Thanks again in advance. Joe.

I want to open a filmaker file but I want to check to see if it is already open if it is don't open it again. tell application "Filemaker Pro" if "Mytest.FP3" doesn't exist then open file "Mytest.FP3" activate else display dialog "Mytest already Opened" end if

I want to find a record in my filemaker database Which has about 5 forms in it. The name of the Database is FMTEST and the form I want to do the Find is NEWFORM. The field is Called NAME in the fm database that I want to enter my param1 into and then find the record. Then after that record is found then Return the values in these two other fields as strings 2nd step is to return the text that is in Field "PHONE" as X and Field "CITY" as Y On run (param1) tell Database "FMTEST" of app "Filemaker Pro" Find Record Set cell "NAME" of Find record to param1 End tell End run

Hi, I'm passing a filename from FileMaker to Sherlock which should do a search and return a file path (the filename should always be unique). This will work OK, except that Shelock defaults to doing a search on "by content" What's the command to make it search by file name?? thanks, jeff

Hi Scripters! (I posted this before at the "ScriptMaker"...silly me! Now here we go...!) I'd like to open several FM-Databases via AppleScript, including the passwords. Works fine so far... But there are some files with an other password, not included in the script. At these it is necessary to press the cancel-button manualy. Is there a way to include this "pressing" into a script? Otherwise the opening of the remaining files stops until the button is pressed. Thanks for your help in advance!

My DB stores references to PDFs stored into a web directory. Does anybody know how to tell acrobat to "Open Web Page..." with applescript. I know it's not really a FileMaker issue, but Adobe doesn't have a cool forum like that one! Thank you for not flaming me

I would appreciate if someone could help with the following: I

Hi, I've been using an applescript application for some time which just asks FMPro to run a script every five minutes. It's really just: ------------------------ repeat tell document "markzlog" of application "FileMaker Pro" activate do script "importlog" end tell delay 300 end repeat ------------------- But now I have to add an extra database to it and I find the problem is that I need to call the two database windows to the front in turn to make the script run. how can I call each database window to the front from my script? thanks, jeff

I have an AppleScript that includes the following code: tell application "Toast Titanium" activate make new Data disc open alias (CDS_TO_BURN_FOLDER & CURRENT_CD_NUMBER) with timeout of 30000 seconds write current disc without asking end timeout end tell This code is of course part of a much larger program, but this is were my error is occuring. When I run this code from within Script Debugger, it works find. The AppleScript waits until Toast is finished burning the disc before continuing. However, when I run the exact same program from within FileMaker, I get the following error from the FileMaker applicatio…

Greetings to all who can help What I would like to do is create an Apple Script on a specified computer which has a printer hooked up to it. We create new PDF's every 5 minutes. Each PDF then needs opened in Acrobate and printed to the Epson. Nothing special needs to be done to the file. So my script should be something along the lines of Open from rip/out Print to Epson It has to open in acrobat, or the epson wont scale it to the paper size, (epson issue) Any time a PDF is dropped into this specified folder, it should print automatically with out running anything. Thank you!

I am new to applescript and I have what I think should be a simple question. I have tried looking for an answer but no luck yet. I have a script and set it up in the login section of OS X. Basically it opens the server connection with the Filemaker Files on it. Script = tell application "finder" mount volume "smb://domain/etc/" end tell How do I get the script to automatically run without asking the question, "Have Script Run?" with the choices "quit ", "run". Do I add a step when I save the script? Thanks, Paul side note: I know you can add some servers directly to the login area, but OS X does not support smb in this area so I …

This is not really an AppleScript post, but I am hoping some of you amazing gurus out there might be able to help. I have this AppleScript that, along with the DatabaseNames and FieldNames functions, allows me to import data from selected fields from the current found set of any open database... tell application "FileMaker Pro" tell database "MyDB.fp5" set theDatabase to cell "database_g" of current record set A_Field to cell "A_Field_g" of current record set B_Field to cell "B_Field_g" of current record end tell tell document theDatabase set the_A_Data to field A_Field set the_B_Data to field B_Field end tell go to database "…

How can I give different names to an exportfile when I use a script? (Every week I want to sent a report with the name "weekverslag<todays date>"

hopefully this should be easy .. i have database that plays a soundfile via quicktime using a script which basically uses a field as the filepath. now all i want to do is write a script which shows that file in the finder ,basically a "reveal file" function . any ideas thanks paul apted

Can someone tell me how to select the current record in a scritp? Thanks, Warren

I'm relieved that Print Center is so AppleSciptable! One thing, I cant get is the list of printers in the list. Strike that, I can get the list, but when I put it into Filemaker is comes out all in one line. How do I get the list with a rtn after each printer?

I would like to print from a different printer for some scripts. Can OS X's print dialog be scripted in this way? or do I have to use the Change Printer plugin?

Looking for a line of script that would allow me to select the field, select options, and enter text in the Define Fields dialog box. I'm new to this, so it might be easy. I've only gotten as far as opening the Define Fields... menu item. help!

I have an AppleScript that runs on a specified time using Script Timer. One part of the AppleScript is to run a FileMaker Script. The problem is when it reaches the point of running the FileMaker Script, it says the object (meaning the FileMaker Script) not found. I realized that it was because the FileMaker file wasn't the front most file. How do I tell applescript to bring a specific filemaker db to the front in order for my tell document "MasterList.fp5" of application "FileMaker Pro" do script "Compile and Send" end tell to work. Thanks... I realized that

Folks, I've been working on some scripts to search and update tables in a FM application. I've basically written Applescript functions to do this. Each has used the same type of code to create a new record when necessary: ... create new record at database irisTitles save database irisTitles set lastRecord to count record of irisTitlesDB set cell "Work No." of record lastRecord of layout 0 of irisTitlesDB to workNumber set cell "Title" of record lastRecord of layout 0 of irisTitlesDB to workTitle as text set cell "Title Qualifier" of record lastRecord of layout 0 of irisTitlesDB to titleQualifier as text set cell "Title Notes" of record lastRecord o…

While my knowledge of AppleScript is limited, how it works with Filemaker is even more so. I'm trying to get certain values into a field and I've come across a few different ways to do it. 1 - set the cell "fieldA" of record 1 of database 1 to (varA as text) 2 - set the field "fieldA" to varA as text 3 - set the cell "fieldA" of current record to (varA as text) They seem to do the same thing. But I've noticed that when I'm using it in a FM Script from calc field, example 1 cause the FM Script to basically skip over the AppleScript, 2 only works on my machine and not my client's, and 3 I have yet to test on my client's but work fine on mine. Is there …

I've used an Applescript to change the default printer in OS X but everything I've tried to restore the original printer has failed. First I tried capturing the current printer name in a global field with status(CurrentPrinterName). In OS X it returns '<unknown>' as the printer name. The next thing I tried was to have Applescript capture the current printer and populate my global field as follows: tell application "Print Center" set defprinter to current printer tell application "FileMaker Pro" set data field "gPrinter Default" of database "db.fp5" to defprinter end tell end tell It returns an error "Can't make <<class prnt&…

Folks, I've got a problem that I'm hoping someone else has run across with AppleScript and FileMaker 6. When having a table that contains a field called state which contains values like "Virginia" and "West Virginia", doing whose cell "State" = "Virginia", i.e. set recordSet to (every record of database "states" whose cell "State Name" = "Virginia" or cell "Variant Region Name" = "Virginia") as list returns both the Virginia and West Virginia record. I tried =, is, and equals (is equal to). All return the same result. Does anyone know how to force FileMaker to do an actual equals and not a contains when selecting records from a FileMake…

Folks, I've only been working with Applescript for two weeks (and FileMaker for about a month) and gotten some help from these forums. I'm at a point where I'm stuck. I'm reading from one FileMaker (which is working fine from the event log debugging) and trying to update records in another FileMaker database. Both files are opened as references. The loop I'm using looks like this: repeat with i from 1 to 3 -- Get the Spiro values to use to populate the IRIS system set spiroCurrentRecord to (a reference to record i of layout 0 of spiroSlideViewDB) -- Go get an IRIS record and update it set irisSurrogateRecordNumber to irisSurrogateStart + i …

I'm sure this is quite easy to do, but since I've never used AppleScript, I thought I'd ask the experts to fill me in and save myself the learning curve. I need the syntax in apple script that will open a record's file folder in a certain directory. The folder name is dynamic, named Last_First for each record. I'd like a script in FMP that opens the folder, so that user can then see all the associated scanned files connected with the record, and choose to open them or not. On the PC, the Open URL script step does this, but I think for the Mac I'll need to use AppleScript. Can anyone help me? thanks so much! Leah Brooks

Hello, I'm very new to AppleScripting and I'm trying to find an AppleScript that will allow me to compose an email with multiple BCC contacts from my FM database. I've made a novice attempt so far to which I managed to set up a new draft window with the correct "to" recipient and a BCC recipient of the first record but cannot add more than one recipient. Any help with this greatly appreciated, Here's a copy of my current script: tell application "FileMaker Pro" set strURL to cell "g_email_to" of current record set strSUBJ to cell "Subject" of current record set strBCC to cell "email" of current record set strCOUNT to cell "new_record_count" of curren…

I want to calculate a ranking for sports events. Everthing works fine and (after sorting) I almost get the correct ranking. The only problem occurs when there are two athletes with the same score. They must get the same ranking. How can this be done with a script. I've got an idea but I can't access the value of a field of another record. The script could look like this. Loop If Score(previous record)=Score(this record) Then Rank(this record):=Rank(previous record) Goto next record End-Loop Can anyone help? Thank, Peter

The goal is to have FMP build an invoice based on a customer's order, send them their invoice, and include a picture of each item they ordered. I can make Filemaker generate an email within Entourage, and include an attachment that is defined by the record. So if they order part #123, they get attachment 123.jpg Where I am having trouble is getting the script to include multiple attachments without defining several fields and a varialbe for each one. attachment: variable1 & variable2 & variable3 & variable4 It works, but its brute force and would mean setting up the script with maybe 50 fields and variable, just in case the customer or…

Can you AppleScript a print, like click a button in FileMaker and the print dialog pops up with the From and To range already set, such as From: 100 To: 200 I tried recording, but mothing is happening. Pretty novice with AppleScript. Thanks

Need help with an applescript for excel. Using a mac 9.02 and office 2001. I have an excel file with only one Column called User_ID. I Need to take all the strings in that column and add them to a listbox in a Realbasic5 app (Populate a listbox). But when my Excel activates I need a file open dialog box so I can choose which Excel file I want to use at that time. myFile = Application.GetOpenFilename ("All Files, *.*") on run tell application "Excel" activate open file dialog box set A to Select Range "A1" return A end tell end run

Is it possible to trigger a script from the result of a calculation field? What I want to do is automatically trigger a script when the user changes a drop down menu from one state to another Thanks!!

I'm trying to create a script that finds all records where the contents of a particular field matches exactly the contents of another. Both fields are Date fields. What I've got so far is... tell application "FileMaker Pro" activate go to database "CenterstoneBusinessCards.fp5" go to layout "OrderStatusReport" show every record of database "CenterstoneBusinessCards.fp5" show (every record of database "CenterstoneBusinessCards.fp5" where cell "Date.Last" is equal to cell "Date.Order") show layout "OrderStatusReport" end tell Whenever I run the script I get an error - "Unable to coerce the data to the desired type." Can anyone tell me what's up …

Can someone help me with a simple applescript. I have a quark document open which is my front most window I want to do a find in my document for the word "test" Then do a paste of what's on my clipboard Save the file to a desktop folder called working in a sequential order. By a sequence order I mean 1.QXD 2.QXD 3.QXD 4.QXD ETC ETC You get the picture

I'm working on a database where I'll frequently have to export and upload a tab-delimited text file to an FTP site. Exporting is no problem, but for the upload, I was thinking I could attach a "folder action" to the folder the file is saved to. I don't know anything about folder actions... is this possible? Thanks!

Hello I am at my wits end. I HAVE a quickey solution to extend filemaker. Everytime I use the apple event script . it works but doesn't shut down, I get the blinking command and period thing on the Macintosh. If I try to start the quickey with applescript telling it to start the quickey backgrounder it does the same thing. I called CE software and they say they have lots of people who run quickeys successfully from Filemaker. I HAVE NEVER been able to do this. Have any of you had similar problems and did you ever find an answer. I think they are stumped at CE software about running from Filemaker . I need to do this but I can't seem to find an answer as to why it neve…

Hello Is there a way with applescript to activate a key combination like option+ 7 for example. If so could someone show me how. thanks Dave

Hello, In my last post I described the problems I had trying to use a quickey application with filemaker and that I could n't use two quickey apple events because it seems to only allow one. So I tried applescript. I used the script editor and recorded exactly what I was trying to do , and when I told it to run it did it. But when I brought the exact script text into filemaker it didn't work. Here below is that text. Menu "ProCD PhoneBooks" Exactly From "#-16489" Wait Application "ProCD PhoneBooks" Click (37, 29 Top_Left) - (0, 0 Mouse) Window #2 ("Select Phone - North East - V3.") AliasKeystroke %51 AliasKeystroke %51 AliasKeystroke CMD…

Hello I have a script in filemaker but Ihave made 2 applications from quickeys that reside on my desktop. The problem is when I try to run the other application in only plays the first one with apple event command. Is there a way to cancel out the first to play the second with filemaker. I tried doing the quickey script in Script editor for applescript but when I paste that application in the script window in filemaker it gives me an error code. I don't know why because I just copied it from the script editor window. Thanks Dave

Greetings, I created an Applescript that copies the fp5.5 databases from my osx server box to my iMac every day in a folder. When the copy completes, and I go to open the backup, the main database file is always corrupt and I am forced to revoer the data. Any ideas on why this is happening? do I need to shut down the Filemaker Pro Application on the server before I run the script?

are there any PDFs online that i can download to refer to for AppleScripting FMP? i did a search but didn't come up with anything... thanks in advance!

I've been using Applescript for a little while now, but still have a difficult time thinking along the lines of applescript. I can't help but think in terms of Perl and C. Anyway, I'm just trying to do something very simple. That is, I want to connect to a server with OS 9. And a version to connect to a server in OS X too. These applescripts would be launched from FileMaker as a preliminary process before launching an existing Applescript which moves things to these servers which reside on our LAN and have a known i.p. address. Any help with this simple task would be greatly appreciated. Maybe I'm thinking incorrectly and the connecting to the server has to be coup…

I'm trying to write an AppleScript that will set multi-user or single-user for a bunch of FMP files dragged onto it. I've got it to prompt for the password, and prompt for multi or single user, and then for each of the files it runs the following command: set multiuser of database DBName to multiuser where "DBName" is the filename of the database and "multiuser" is either TRUE of FALSE. However this command doesn't seem to do anything - not even an error. What am I doing wrong? How do I AppleScript the setting of multi-user for an FMP database?

Does anyone know the proper syntax to send the Do Script Apple Event from a REALBasic app? I've gone into the reference for Filemaker and Apple Events, but all the examples are for AppleScript and Frontier. I believe the following is the start: dim ae as appleevent ae = newappleEvent("misc", "dosc", "FMP5") But I can't figure out the syntax for the next statement which is to send the event. I think it's something like... ae.Send.... But after that...? Thanks! Best Regards, Jeffrey Ellis

I am trying to retrieve the files that are in my subfolder and I always want it to go to this folder to find these files example Desktop:Test:Test1:text.txt Then I would want it to open the file in the subfolder tell application "Finder" activate Set sourceFolder ("Desktop:Test:Test1")

Ok, this has got to win a prize for the most ridiculous problem ever, but I cannot for the life of me figure it out: (OSX.2.5) We have 4 databases running in seperate windows; Ido Script Scheduler runs every night to trigger a printscript which itself works fine, except: when Filemaker itself is hidden or in the background, which was easily fixed by an "activate" command. when the database that contains the printscript to be triggered is not in the foreground. So how do I tell FileMaker to activate (i.e. bring to front) the window I need? I've tried activate, select, bring to front, all to no avail... thanks for any help!!!

Is there a way to have an applescript return the path where it is saved? That is, if I put an applescript in My HD:Folder1:Folder2:Applescript, I want to be able to divine its location. What I'm trying to do, is have the applescript open another file, using a location relative to its own location. So, in the above example, the applescript would need to read data out of a text file at My HD:Folder1:Folder3:textfile.txt. But, I don't want to hardcode the hard location, just the location relative to the applescript, so taht I can move it if neccesary.

Hi, does anyone know of or ever thought up an Applescript that will automatically backup your DB to a CDR? It should prompt the user to put in a CDR and then copy the files over, rename the CD based on a code, burn using Disc Burner, then eject and instruct the user what to write on the CDR. sound possible? I can't find any reference in applescript on the CD burning part. Any ideas??

Hello, How do i Copy the text from a cell into the "Comments" property of a file? (using OSX.2) thanks in advance Paul Apted

I would like to search a directory to determine if a certain file exists there. How can I do this?

my script archives images. When it runs, every few hundred records I get an error - out of memory- clip2gif got an error- not enough memory. how can I modify my program so as not to get this error? do script "Copy Image Big to clipboard" -- copy the image field tell application "clip2gif" activate save clipboard in window delay 2 save window 1 in window 1 maximum size {144, 144} -- pixels AKA 2 inches set picture_var to content of window 1 close window 1 end tell --application "clip2gif" tell application "FileMaker Pro 5v3" activate --bring to front set cell FM_Image_Small_Field of re…

I'd like to have a button that would select a specific text field, then select and set all contents of that field to a specified font and size. How might this be done? Thanks, kent m

I just upgraded from a 450MHz g4 desktop to a 1 GHx iMac. I've been running a solution in FM6.0v4 using an apple script to insert pictures as a reference into container fields. On the new computer the first time I try this script on a file it causes FM to unexpectedly quit while browsing for the picture. I restart FM, open the file and it works fine from then on. It can be real annoying if I have typed a lot of text into the file and gone to insert a picture without remembering to close it first. Other computers on the network don't seem to have the problem. I've tried trashing all of the preferences I could find and reinstalling with out any luck. Any sugges…

This is a script I used in OS9 Filemaker to write external text text files with unique info and filename.....now it doesn't work in OSX. Here is the script: tell application "FileMaker Pro" set this_name to get data cell "HTML File Name" of the current record set this_data to get data cell "HTML Page" of the current record end tell tell application "Finder" set this_file to (((path to desktop folder) as text) & "jewelry_HTML:" & this_name) set the target_file to the this_file as text set the open_target_file to open for access file target_file with write permission write this_data to the open_target_file starting at eof …

hi, everyone ! i need to export formatted text ( bold, underlined, italic, etc... ) in fmp to quark-express or word without losing format : ( actually i want to export those text without losing format and want to use in quark-express. ) now somebody told me that this can be done with applescript. can somebody tell me how ? and since i'm newbie with applescript, would you give me the script ? regards,' kyle

in my filemaker database i have an images stored in containers. i have an applescript that tries to extract the path from the image- set image_path_var to get data of cell "SKETCH" of current record The image is an eps file. The problem is that on every record i get an error when trying to use this image_path_var which says something like can't make data eps then a whole bunch of garbage. this script works beautifullly on a different database. what could be the problem?: help!

I work at a edu. facility. and I need to make a applescript that check the size of the users "home" folder at login. I have tried with the following script. I run it from the login items in the system pref. But something is wrong, can you please help.... [color:"red"] try tell application "Finder" activate set username to name of home set using to round ((physical size of home) / 1024 / 1024) tell application "Finder" if using > "4000" then display dialog ("Hey... " & username & " You use too much diskspace! You use " & using & "MB your quota are 4000MB") with icon stop buttons ("ok") else display dialog…

Hi everybody, I wanna insert pictures in FM database via AppleScript, but not the reference of the file. I know the database is going to be heavy, but I really need having the picture in the database and not its reference. I made an AppleScript (see code below), but it only store the reference of the picture. What can I do and how can I modify my AppleScript to insert the picture and not its reference. Thanks for your help Jave Code of my AppleScript tell application "Finder" set finalFolder to "Macintosh:Utilisateurs:jave:Bureau:Images" repeat with x from 1 to (count of every item of folder finalFolder) set mapPart to item x of …

Hi, all I am writing an apple script that will enable an user to write an email using outlook. This is my script: "tell application " & quote & "Microsoft Outlook" & quote & " Activate make new draft window with properties {to recipients:" & quote & Email & quote & ", content:" & quote & anrede ausgabe & quote & "} } end tell" but when I run it, I get the error : Expected end of line ect, but found class name (error -2741) What does this mean??? And how do I fix it! Plz help as this is only the last thing I need to do then the DB is finshed! Lots of love Shane…

I've got a scheduling system which the client has suddenly decided needs to be altered in a major way. Looking for a workaround, I thought that I could solve the problem if I could AppleScript a way to change the system's date. However, I can't find a way to do that. Is it possible to script a date change? I can find the date, but can't find a way to modify it. Thanks Stanley

What are the appropriate AppleScript commands to do this? I have two database files open. The one that is active has buttons linked to an AppleScript that tells the other database which layout to display. I want to add AppleScript commands that will bring the other database to the front (make it active) to make life easier for the user. I've tried activate "db 1" select window 1 and that results in an error message. Likewise activate "db 1" activate window 1 Thanks in advance.

Hi I am trying to send an apple event I can select the application I want to use. My next step is to open a file in my application (QuarkXPress) using a field I have specified in my database. I can open the same document by specify the file but I don't want to do that I want to specify my file from my field.

I have a problem with printing from an FMP script to .ps or .pdf because FMP doesn't remember the name of the output file. To get around this, I have been looking at the archives of this list and someone mentioned what is my script below, but I cannot get it to work. I get a message something like: "Finder got an error: Can't set file "PDF:Tool Bar Dock.pdf" to "Annual data-1.pdf"" How can I get my file renamed? I have to generate five .pdfs per record and each one is attached to separate auto email from FileMaker and for this exact file names are essential. Here is my script: set theKnownPath to "PDF:Tool Bar Dock.pdf" (--this is FileMaker's usual generic fil…

Is there a way to retreive the auto-enter and validation settings for a field via Applescript? I have been able to retreive field names, IDs and most other field parameters like access, protection, repeating status - but I don't see how to get this additional info. David Simpson

I'd like to write an Applescript to move a folder after Fm runs a certain script. Basically, every morning we import our orders that have been batched from our online estore database into our orders, customers and lineitems databases. What I would want the applescript to do is then copy the folder to our server and name it the current date. Is this something relatively simple? I have no Applescripting experience.