AppleScript & Automator

hello, i am trying to write a script in which you drag a file/folder/volume onto an applescript applet ,it then creates a new record for each file and puts in the filepath into a cell called "filepathtext" . Thanks for any help Yours Paul Apted

hello, i have a script that copies a soundfile that is referenced to a record in my database. tell application "FileMaker Pro" set thePath to cell "filepathtext" of current record end tell if thePath is not "" then set theDestinationFolder to choose folder try set thealias to alias thePath tell application "Finder" duplicate thealias to theDestinationFolder with replacing end tell on error errMes display dialog "Could not copy file" & return & errMes end try end if I can run this script and it works fine when copying 1 sound file ,how do i edit the script to copy all the soundfiles in the current found set to one destination f…

Is there a way to tell PrintCenter to change its output to postscript file? I am printing a report from a FM solution and want it to print a hard copy then save a copy as a postscript file. (I've found that running the PS file through Distiller gives a smaller pdf than saving as PDF directly). I've tried doing the page setup with print center set to save to PS and save settings then saving that page setup as a print subscript in scriptmaker, but it keeps defaulting to the Standard mode. Would love to be able to print from all of the layouts without dialog and have the postscript files created as well.

Mmmm... I've already put this on the printing section, but I think it would be more appropriate here. I've already read some fine stuff by the brethren on 'choose printer via applescript', and I was just going to add this to that. But it ain't quite the problem. I've worked out the printer switching, but I WANT MORE. I want what I got from OS 9 with the Use Printer OSAX which is still in my opinion the mutts walnuts. It is the bomb. But I recognise I may be forced to go OS X so I'm trying to get prepared for the painful transfer. Here is my blurb: I have repeatedly been told that OS X (I now have 10.2.3 installed on one of my 10ish machines) has got all the feature…

hello, Really simple one this ,how do i get quicktime to quit (EASY ENIOUGH) but how do i get quicktime to ignore the script if it is already closed (this is a script that Filemaker uses when it quits as well)? Also,i have a database which is linked via a field to a quictime sound file ,is there a way of taking the 1st 4 words from a field (description) and pasting it to the end of the soundfile referenced by the record?? thank you for all your help Paul Apted Thanks

If I have a file name let say AB1234 and I want my applescript to return 4321BA (backwards text of original) do you know of a quick way to do that? I have looked up different additions that will break down the name, but not a simple backwards command. Please help!! What is the easiest and fastest way to achieve this. Remember the name lengths will differ.

Need Info about Program Linking and eppc when the script start the program linking open the windows to put password ant name to start the application by (Remote). how to put a password ex: 123 and the name ex: Ricky ..and start automaticly That is the script property abc : "Yes" display dialog " The index take 8 Minutes.....Please Wait!!!" buttons {abc} tell application "Finder" of machine "eppc://192.168.0.199" open application file "Travaux:Applications Index:Action" --Action is another l'application (Script) beep end tell Thanks for Help

Hi, I am running (testing) OS X Jaguar and AppleScript v2 beta (I need more then 32K, and it's there). Under OS 9 the following very basic script works fine: tell application "FileMaker Pro" open file "Macintosh HD:filemaker.fp5" end tell But under OS X, AppleScript v2 this won't open the FileMaker database (the AppleScript times out). Has anyone else come across this problem, or am I the problem Thanks, Peter.

I know this forum is for FileMaker, but I was wondering if anyone knows how to export pages in Acrobat PDF by using Applescript. There is little or no information on scripting Acrobat and even less scripting additions. Please let me know if you know of any.

I accidentally wrote a script that added text to the end of a field of every record that I really wanted inserted in front of the fields existing text. How do I undo this? And do it properly?

Hello, I am interested in getting a book on scripting for Filemaker and indeed also a book on Applescript ( i am a beginner ) any ideas anyone?? THank You Paul Apted

I'm trying to use the filemaker script step called "send apple event" to open a varity of documents using another application. The application is called GCK and I would like to specify which GCK document is opened according to the value of a field in my FileMaker database called "FileID". With ScriptMaker's "send apple event" command I have specified the target application as "GCK", and sent the "open document" event with "Field value..." and I specified the field in my database called FileID. The GCK application launches but does not open the files I indicate. Does anyone know how to accomplish this kind of task?

I'm working with FM 6 unlimited and OSX.2 server. The probelm that I'm having is at I can not script printing to pdf. PrintToPDF does not work with OSX. I looked on Adobes website and they do not have PDFWriter for OSX either. Here is my question. In preview mode how can I create a pdf file using applescript?

Here's a snippet of code from my program, after it fills all the fields in the commands, I just want it to run a FMaker script inside... tell database "Foreign Items" repeat with x from 1 to count of items in y1 set newrec2 to create new record in it set cell "Foreign Item Y1" of newrec2 to (item x of y1) as real set cell "Foreign Item X1" of newrec2 to (item x of x1) as real set cell "Foreign Item Y2" of newrec2 to (item x of y2) as real set cell "Foreign Item X2" of newrec2 to (item x of x2) as real set cell "PageID" of newrec2 to pageid go to newrec end repeat do script "Generate Gaps" end tell Prob…

I'm interested in creating a function within a solution I'm creating. When the user clicks on a button, it will open an MS Word document (the file will actually be a "stationery file", so the user will not alter the original template.). I'm pretty sure I know how to do this with AppleScript. However, I'd like my solution to work on a PC as well and don't know to approach this in the Windows environment. Will I need to use a VB Script? On both platforms, I'd also like to specify where the Word document gets created by using a field value. Any info or thoughts on this? Will this require a plug-in? Thanks in advance. Any and all help is greatly appreciat…

I'm new to Filemaker and trying to write some information from a database to a flat file. I don't know how to in Filemaker, so I've tried the "perform applescript" route, but get expected end of line compilation errors (on the write statement) when trying this (as an example - the myfile exists to start with) set target_file to "myfile" open for access file target_file with write permission set eof file target_file to 0 write "example text stuff" to file target_file starting at eof close access file target_file display dialog "Done" this applescript works from the script editor. Is this something that could be done easily directly from filemaker,…

How can I do Paste cell in Sherlock 2 in Os 9.2.2 with a applescript like copy cell in a db then paste in sherlock. Thanks!!

FMP experiences very frequent crushes when accessed using AS?:? Often citing "invalid connection-609" error Mariusz P.S.The script works fine in OS 9

I have 1 folder with 20 txt-files which I want to import into FM automatically. Each record in FM have 2 fields (1 with the name of the txt-file, the other with the contest of the txt-file). I have tried to modify the "Import Picture"-script which comes with FM without any success. I get a Filemaker error when the script arrives at set cell "filecontestt" of newRecord to file (txtFileRef). A guess would be that I have to copy/paste the text, instead of importing it. But...I might be wrong! The modified script: --choose a folder with text files activate set folderPath to (choose folder with prompt "Choose a folder with text files to import

hi, i sent this to the applescript-users mailing list but they are busy... so i was hoping some body has a little experience in this and can advise... i have a slight problem here using the URL Access Scripting ability to upload files via ftp. i tried a few times to upload a file to a machine that has a non standard ftp port - not 21. when i tried to upload file to a different machine that has a standart ftp port listening - no problem. i really need to upload the file to the non standard port machine. can i or not with URL Access Scripting?!? (i alreday tried ftp://un:[email protected]:port - it times out) if i can not (WHY?) - is th…

ok, i have this database in which each record references a sound file on a hard drive using a text field (filepathtext) as its file path.this script plays the sound via quicktime. Now it all works fine in OS9 and OSX 10.1.5 ,but since upgrading to 10.2 i now just get a quicktime -43 error ,file not found... has apple messed around with filepath names etc etc with 10.2 and if so how do i change the syntax to repair it my original file path for example would be :"sfx1:fx:az:az01:az-01/01" and works fine in older OS's here is my script : tell application "QuickTime Player" launch activate tell Application "FileMaker pro" Set Myfile to cell "Play Sound…

i have an AppleScript that downloads and unpacks a text file that after that is supposed to be imported in a db file. when the AppleScript gets to the point where it has to interact with FileMaker i get this error: application does not run in this environment which environment? it works fine if i open it myself. this is the AppleScript: set localFile to "projects:my:path:newDB" tell application "FileMaker Pro" activate open localFile do script "importDB" end tell any help appreciated.. thanks...

I am hosting a FM solution on an OSX machine. I have already created a applescript that, when launched, opens all my FM files. I have this script set to lauch upon computer startup. Works great incase the machine crashes and restarts. I want to expand upon this idea. Is there a way to: 1) Somehow set particular times that 3 different applescripts will run. maybe thru the built in CRON in OSX. 2) The first script will close all the open FM files, avoiding the message about connected users, or in other words, shutting the files wether there are any connected users or not. Is it possible to do a script like this? 3) Have a second applescript that copies the fi…

I need to Index an entire volume whit juste the pictures in a multiple folder or not but not the folder then I need the path and the name of the picture in Filemaker 5.5 Thanks

Thanks in advance everyone...just scanned the board and couldn't find an answer explicitly relevant to this. Is it possible to create an Applescript that opens a database hosted on another computer (ie., file->open remote) over TCP/IP? I am not running FMServer, nor is the database password-protected. If I've left necessary info out, let me know and I can elaborate the setup further. Thanks again!

I'm looking for a way to open a Real Basic application on a mac If I use AppleScript tell application "OpenOS X" activate end tell I get an error " Can't get the application's event dictionary" If I use send apple event I get an error "<unknown>" could not be found and is required to complete this operation. I think the problem is in the Real Basic App because I was able to make both apple script and apple event to work with other app's Any thoughts. Ron Bascom PS I the one that worte the Real Basic app in question.

FM 5.5 under OS X The following seems always to return "false": enabled of menu item "Minimize Window" of menu "Window" Is this a known bug? Anybody knows of another way to check whether some window has been minimized?

I'm having difficulty entering data from the script(date) into a date field of FMP. Is there a solution? Mariusz

A script that work fine in OS 9 using FMP. Crushes FMP in OS X citing the following error "Connection is Invalid". Mario

A Win application digitalises X-ray scans and delivers them in .tiff format to an Access database. Is it possible, through Applescript, to automatically export them from the Access database to a Filemaker database? Thanks in advance for any advice. dirk

I am working on a solution to automatically read data off of CD ROMs in a 7 CD tower, and I am looking for a way to read the SCSI ID or disk number or something so that I can indicate to the user which drives are in use, and which are not. I can get the volume names, but that does not indicate which of the 7 drives it is in. Ultimately I will be showing a graphic of each drive, which will show it as empty or with a CD in it. The Troi file plug-in does not seem to have any way to get this information, but I was hoping that Applescript can.

I am using Applescript to control import of data into MYOB V 11, on a Mac OS9 platform, using the Perform Applescript command with a calculated field that contains the Applescript text. Two problems - is there any way of monitoring under Filemaker Script control what is going on in the Applescript, or detecting if it has failed? - how do I stop the Applescript asking for the location of MYOB Accounting (the application that the FMP Applescript is trying to control) every time I run the FMP script that contains the Applescript?

I have a applescript that opens a particular FM file. tell application "FileMaker Pro" activate open file "Macintosh HD:Applications:FileMaker Pro 5.5 Folder:Database Files:GW_Users.fp5" with password "ibiubu" end tell This particular file opens, runs a FM script that pauses until the user inputs a username and password into 2 seperate fields. Is it possible to add something to the applescript above so that it will fill in these two fields, then hit the equivelant of the enter key. LR

We are a ceramic retailer in France and we import from Italy. I started FM three years ago as a simple database. Today, I use Filemaker (Macintosh) for any purpose from accounting to sales, from ordering to statistics or list of articles. We import from at least 25 differents clients and none of them use FM Pro. For the moment, I generate all my orders via a specific (complex?) Relational Database, with an order form I edit and fax. This order form contains different fields, as N

Hello, I hope this is the right place for this question... What I have is a ton of numeric text files that could be made into charts, using a seperate application, and placed in container fields in different records of my DB. However, the number of charts that this would create is prohibitively large, and so I am trying to implement a more elegant solution. What I would like to do is have a button in my DB that activates my chart-making program (Igor, from WaveMetrics) and tells it to create the graph and store it in a temporary file. I then have the script load this temporary file into the database. This way, charts are only created when they are needed. …

Hi! I'm new here so bare with me. I'm also pretty new to FMP. One of my scripts is launched via a button. The button will start a FM Script which will make it so that the only record is the found set is the current record, then launch an applescript. The applescript will grab some data from the web, parse it, then set some fields in the found record with the grabbed data. This usually works fine, but if an errant user decides that while they are waiting for the script to run, and clicks on one of my navigation buttons which can change the found set (a list of all unpaid accounts, for example), then the applescript will write data across ALL records in the f…

I am trying to import 5500 images and names into a database. I made a database with a text field and container field. Below is my script. The container field won't import. I don't want a reference to the field I want the actual picture placed in the field. Please help! Below is my script: tell application "Finder" -- change the following to suit your own folder name tell folder "Elements" tell folder "!logos" set myfolder to "Desktop:Elements:!logos" set app_path to every item repeat with this_item in app_path set fileName to the name of this_item set filepath to (myfolder & ":" & fileName) tell database of app…

I would like to know where can i download a tutorial about filemaker 5.5 for mac-os x. I was search in many pages but i had not good result. Please who have information, tell me. thank you.

Hi, new to this forum topic but not the site. Hope you can help. I am building a (FileMaker) script that creates a report, prints it to a PDF (using Acrobat writer, my client is still in OS9), then calls an applescript that selects the new pdf, renames it and moves it to a folder. This is repeated 50 times to create 50 reports. My problem is that some of the reports take longer than others to create than others. Due to all the calculation fields, number of records in each and time to print the PDF. Sometimes the applescript comes back with a message similar to 'untitled is not availble' can't proced'. then the whole process falls appart and things get name…

Hi there, How do I open a file from filemaker server using applescript? Any info would be really helpful! Thanxs Steve Griff

Hi All, I have a script which allows me to select a folder and have each file's name imported into a separate record. What I need the script to do is also the the names of any files (and their path) within sub-folders. Here's what I have so far: --choose a folder with picture files activate set folderPath to (choose folder with prompt "Choose a folder with filenames to import

in this script below if i delete the "do script" line the thing compiles, but it doesn't with the line in it. why? how else can i do an import. this is on OS 9 with filemaker 5? set FMapp to "Sys-Apps:Applications:FileMaker Pro" set localFile to "HD:Stuff:emptyDB" tell application FMapp activate open localFile do script Import save end tell

Is it possible to make a applescript in macosx where it can take screen shot and save it in a file?? I am macosx newbie

I'm trying to make an "Ultimate" Filemaker find and sort subroutine, where I just pass some lists to the subroutine, and it returns the found fields, sorted in the order I requested. I don't want to bore you w/the entire script, so I'll just ask about the sort part, which is where I'm getting stuck. I know FMP likes to sort in this syntax: sort by {field "State", field "Date"} in order {ascending, descending} So I'm trying to write a script to build that sort from 2 lists. Here's how far I've gotten, but i'm stuck on how to build a list that looks like {field "abc", field "xyz"} . Can someone help? TIA. Dan set theFieldsToSortList to {"State"…

hello, i have a DB in which each record is referenced to a sound file on a hard drive ,i can play the sound via quicktime using an applescript .What i would like to be able to do is COPY the soundfiles (that are referenced from the records in a found set) to another location. any ideas any one Paul Apted

I've set up a FMP database where each record corresponds to a different Microsoft Word file, and I'm trying to set it up so that one could open the Word file, corresponding to the active record, with a FMP button. But, it may be easiest for the users of the DB to store these Word files on their FTP server. So I was trying to find a way, using Applescript, to open files on an FTP server. I can use the "Open location" command to open the FTP directory, but when I use it to open a specific file, I get garbage. Is there anyone out there familiar enough with Applescript and FTP to help me out? (For the record, I've just been introduced to FTP, so I apologize if this turns ou…

Alright, I have an applescript that I want to search for and make changes to a dynamic list of files. The list itself is generated by filemaker, in the following format: "Item A Item B Item C Item D" Now, what I need, is to convert this into a list object in Applescript. That is, I need to be able to, for example, say Open Item 1 of List X. Is there anyway to parse a carriage return delimited list to a list in Applescript? I tried converting it into a string formatted like the string versions of applescript lists: {"Item 1","Item 2","Item 3"} and then just saying get cell as list, but this just returns a list with one item, that is the stri…

Why doesn't this work? I get this Execution Error: Can't make <<data Pict>> into a string I found this script on the filemaker site. It's a little old: tell application "FileMaker Pro" -- count the found set of records in the (current) database and -- put that number into NumOfRecords. set NumOfRecords to count record of layout 0 of database 1 -- Loop through all the found set repeat with i from 1 to NumOfRecords -- Get the contents of "Picture" in a certain record of the -- current database set PictureReference to cell "Picture" of record i of layout 0 of database 1 -- Put the contents into "FileName" as text …

I have a solution that needs to have two sub-folders for long-term running. I have created an opening script that checks whether the solution has been installed, and if not, creates the folders for me. In Windows, I have a simple batch file that runs from a Send Message script command. I assume that I should use Applescipt on the Mac, but not being a Mac person, I have not been able to figure out a couple of (admittedly basic!) things: 1) I want Applescript to create the folders under the main database folder, which could be anywhere. Every example of Finder scripts specify the exact location of a newly-created folder. I do not know how to instruct Applescript to do …

I have a system running on OS 8.6 which juses iDo Script to execute a small AppleScript every minute. The AppleScript does this: Opens a FMP file Runs the startup script Checks for new records Passes new records to Eudora (via AppleScriot commands from FMP) Closes the FMP file It's a simple messaging system that doesn't require the client machine to have a particular (or any) email program. I'm moving to OS X I know I need a cron schedule ( I think I've got that worked out), but I'm unsure how to execute an AppleScript or open the FMP file. It's nearly 15 years since I was anywhere near UNIX, but I remember the c shell and the bourne shel…

Hi, this script technically works apart from one snag .. (its only a test script to ensure that the connectivity of files and data function correctly) tell database "central.fp5" set accessID to cell "AccessID" of current record as text end tell tell database "TBcentral.fp5" set cell "gAccessNumber" to accessID as text do script "enter find mode" do script "perform ID search" find set cell "gAccessNumber" to "" get cell "First Name" of current record end tell The two fmscripts "enter find mode" and "perform ID search" are created within the database "TBcentral.fp5", the first script just sets the view to fin…

I have a script in FileMaker (4.1) that automatically prints a record to a pdf file. Adobe Acrobat automatically names this file "untitled" and puts it on the desktop. I use an AppleScript to rename it after a FileMaker field and move it to the appropriate folder. Is there anyway to script this so that the file is automatically named after a FileMaker field and put in a certain folder when it is first printed? I want to eliminate the "untitled"/desktop step because it causes problems when there are multiple users.

Is there a way of creating a container field that will display the time of a quicktime movie? this is probably undoable but it is worth asking thanx paul apted

For anyone whose interested, here is a little applescript to duplicate the current found set of records: Just stick this in a "Peform Applescript" Scriptmaker script step and voila. tell application "FileMaker Pro" duplicate records end tell

I am attempting to run a script that affects two databases, so to switch between them, I am running the script generally as follows tell application "Filemaker Pro 5.5" tell database "filenameA" ..... end tell tell database "filenameB" .... end tell end tell The problem is, that it doesn't pick up the two databases! It will err out when I call for it to change a cell specific to one of the databases, and I'll go to filemaker and see that it's writing to whichever one happens to be on top. I tried putting an activate step in, although I don't imagine that should matter. I also tried running a script to return the name to me, …

I know, I know, I should bite the bullet and buy the TROI plugin. But I don't WANT to buy a plugin! I know it was mentioned elsewhere in the forum, that it is possible to set a container field to a picture, but to store it as a reference, in applescript. How?

Hey all, I need an apple script to reset the serial value back to "1" on a field called SequenceNumber when the script is ran. I am going to use it on Filemaker server and I am going to schedule the script to run through the scheduler program in filemaker server. I would set it up as a filemaker script but I only want it to reset once a day and not everytime a user quits out of the database. Any help or suggestions would be great. The filemaker script I used for this is: Set Next Serial Value["SequenceNumber", "1"] The script works great in filemaker but had it doing it on a restart and everytime a user quit out of the filemaker database it would reset it and i only w…

I'm using the following script and it's doing the strangest things: tell application "FileMaker Pro" activate tell database "lead_routing.FP5" activate set gEmailScript to cell "gEmailScript" of record 1 as styled text create record at layout "Entry View" with data {"Dan", "", "", theTitle, Address1, Address2, theCity, theState, theCountry, PostalCode, Phone, "",

I am in the process of upgrading from OS9 to OSX but have come across a fairly fundamental problem. Whilst using OS9 I used to have the Energy Saver CP, combined with the use of AppleScripts, start up my Filemaker Server in the morning and close it down in the evening. The Energy Saver System Preference in OSX does not seem to have the facility for Scheduling. Am I missing something obvious here or is there no way of getting a Mac running OSX to startup and shutdown automatically. I am not currently running OSX server which I believe has a CP for the System Administrator to startup and shutdown Macs on a network.

I have a need to be able to perform certain database admin tasks remotely. I was looking at 'Timbuktu', however it is quite slow and a bit of an over-kill. So, I tried some Applescript from the Terminal application of OS X. It works fine. I am now able to login to the FMP host with ssh and issue Applescript commands; e.g. code: /usr/bin/osascript -e 'tell application "Filemaker Pro" to activate' /usr/bin/osascript -e 'tell application "Filemaker Pro" to open file "Data:db:openfirst.fp5"' Hope this is of interest. Garry [ April 01, 2002, 07:14 PM: Message edited by: Garry Claridge ]

Should be a nice simple one this but haven't found the answer as yet. I have an Apple Mac setup hosting my databases to the network. On this machine I am running an Applescript to open the databases in Startup Items and in conjunction with the Energy Saver control panel. All the databases open fine but I would just like to add a short line at the end to hide the Filemaker Application. Can any one give me the Applescript to achieve this?

hi, i am using this right now as an apple script step in my databases: Property x1: 162 Property y1: 862 Property x2: 183 Property y2: 544 set the bounds of window 1 to {x1, y1, x2, y2} this works great exept for the fact that it would be nice to set the name of, say, main.fp5 to 'main' so i can set the bounds one main to.... so it is not always working on the front most window, but on a specific one. is this possible? thanks.

Most of us develop projects for both platforms...but I have to say that is really pains me that Windoze doesn't have an extensive scripting language like AppleScript. My current client...is all Windoze...and poor them...there are so many wonderful things I could script if only!!! Using DDE is just not as elegant. Does anyone know of a Windows scripting app that I could send a DDE to and control the machine? BTW...I recently put my PC into the closet...doing my cross dev in Virtual PC with Win 2000 and XP...running 3 OS's at the same time is fab.

I am really new to AppleScript but am pretty ok with Filemaker. I have developed an extensive school student tracking database which teachers in my school use to enter grades, write reports etc. The difficulty I have is that although teachers now log out of the database and close it down correctly so that pupils can not see it, the server is still on the desktop and must be dragged to Trash (some folk are not good ateremembering to do this!) Is there any way of getting AppleScript to remove the server as the database is quit? Thanks for any help Phil B

We are have a complete Mac network and are running Filemaker Server 5.0. I need to quit the server every morning, about 3 a.m., and then relaunch the server a couple of minutes later. I have a script that I think will work, but it always just quits the server and does not relaunch the server. I am using Filemaker Server's schedules option to run the script. Any ideas on how to make it restart Filemaker Server?

Being a windows user know need to create a sendmail script to drive Entourage on the Mac. My problem is I can't get Entourage to create a New mail message and transpose the details across i.e Subject, message etc. The PC works great with outlook. But my knowledge of Applescript is basic so could do with some help

Bit of a cheeky one this but I am trying to get an Applescript to take a SKU number from a field in a Filemaker database and use this information to find the the graphical image of this SKU in a Cumulus database. The Filemaker part works fine with putting the SKU number into the variable but I can't get the Cumulus part to work! This is the script I have so far. tell application "FileMaker Pro" go to database "BOM.fp5" go to layout "BOM" set SKU to get data cell "SKU" of current record end tell tell application "Cumulus Single User" open "Filemaker Server:

Hi. I'm trying to schedule Toast Lite 5.0.2L to backup a folder onto a CD every 6 hours. So far, I've written: code: set theItem to "HD:Folder" tell application "Toast Lite 5.0.2L" add to current disc item theItem write current disc end tell But it doesn't seem to work. Can anyone please help me? Thank you! Kind regards Krishan.

Can anyone tell me what the Applescript line would be to copy information from a certain cell in the current record to a variable. I have tried lots of variations using the set and copy commands including: copy cellValue of field "SKU" to SKU None seem to work. Can someone give me the correct wording for this command. Thanks.

Can anyone tell me why this isn't working: open "database.fp5" with password "password" I'm getting a message in the Event log which says "Filemaker Pro got an error: The event failed." Any Clues? [ February 12, 2002, 12:46 AM: Message edited by: mad_mickey ]

I have a script (droplet) that gets the file names of files inside a folder (that is dropped on it). The script first gets some info from the files, and sends one part to FMP to insert into a field. Then from a portal that matches the data, another regular field is filled in via a script in FMP. This sets up where the actual data about individual files will go. The script is set to "transcation" so that part will run. The names of the files are put into some generic text container fields (from the script). Then lastly, the script tells a FMP script to create each file in a portal. This script works great on the computer it's running on, the FMP server. When I try the…

code: display dialog "Please enter your password..." default answer "" default button "OK" giving up after 5 copy (dialog reply button returned) to v_button I run the dialog and get an "Execution Error" message. It says "Cannot make some data into the expected type". I am sure that I have some formatting errors, but I do not know what. Any suggestions?

Little off topic but... Has anyone heard anything about AppleScript Studio? The site still says available later this year. Hey Apple, um it's almost Dec, where the heck is it?

Can anybody please shed some light on this one. I'm trying to use Applescript to open a remote database on a certain day each week and automatically run a report. I am wording the Applescript to the format as per Filemakers Applescript dictionary, but the database is not actually opening. It is opening the remote access window and showing all the databases available but not actually opening the requested database. My script is as follows: tell application "Finder" if weekday is Thursday then tell application "FileMaker Pro" activate get remote URL "FMP5://[url address]/database.fp5" end tell else display dialog "This script should only be run on…

I would user a FM plug-in such as the Troi-File plug-in. It has a full range of file handling features. -bd

I am in the process of making a filemaker 5 database that is intended to store a large amount of scientific info. I have been unable to create a script that will allow me to open a file in another application, where the name of the file to be opened is the content of a field. The doc to be opened is a string of letters representing DNA sequences and the application I want to open them in is called MacVector 7. I am making this database on a MAC! Not in windows. This seams like a really basic comand and I'm sure it can be done, just not by me. Can anybody help???

I have some Databases that are used by several users, I need a login and passwords with diferent access levels. My question is: Has Filemaker this function? if so, please could you help me? Thanks in advance Maribel

Trying to have FM run a script that copy's a folder off a CD to a volume drive. After about a minute I get an error from AppleScript, that an AppleEvent timed out and the error is -1712. How do I lengethen the expected time out? I added a wait with 3600 seconds but that didn't do it... Here is my code... code: tell application "Finder" activate select every item of container window of folder "LOW" of disk "PO 4026" with timeout of 3600 seconds copy selection to folder "LOW" of folder "PROJECT" of disk "Photo Library" end timeout end tell [ November 19, 2001: Message edited by: Ocean West ]

The situation I have is an applescript that works in one db but doesn't work in a duplicate db. What the script does is set a text field showing the calculation used on a particular set of fields. I have checked and rechecked to make sure the script is the same in both db's. What am I missing? The error I am receiving is: Expected end of line but found identifier. (Error -2741) Set Field Formulas FileMaker Script Set Field ["gCounter", ""1""] Loop Perform Applescript [cApplescriptFieldDefinition"] Set Field ["gCounter", "gCounter + 1"] Exit Loop If [gCounter = 151] End Loop The following is the cApplescriptFieldDefinition field. "tell applica…

Hello. With this script : tell application "FileMaker Pro 5.5" activate open "HD:Documents:FileMaker:File.fp5" with password "password" end tell I open a FileMaker document using a password. Is it possible to open this file and not perform the FileMaker script whose be selected in the document preferences to be perform when opening the file. [edit to disable smilies] Jean-Marie Hoornaert [ November 15, 2001: Message edited by: Jean-Marie ]

I want to use AppleScript to open a database that opens with a default password. I want to do this so that I don't have to type the password into the AppleScript. However, when I try this I get the error message: "FileMaker Pro got an error. The event failed". If I type the password into the AppleScript, it will open the database.

I hope someone has the answer for this. I want to create a watched folder by writing an Applescript that is attached to a folder with folder actions. The script will tell Filemaker Pro to run a a particular script. When I write a script that simply says: tell application "FileMaker Pro" do script "import_textfile" end tell it works if I just run the script manually, but when I make it a folder action and drop the file "textfile" into the folder, nothing happens. Help, please. thanks in advance.

Hello All I'm a photographer who has been working with FM for about 5 years. I have numerous DB's where I have imported pictures though a loop in a FM script by manually specifying the file to import each time in the dialogue box. I have never used apple scripting and am wondering whether it is possible to write a script that will automatically go to the next file in a folder each time the FM script is calling for an import. Thanks in advance. Jim

I am trying to find a way of changing from the paper tray to manual paper feed during a Filemaker script on a Macintosh. I want to print paper from the tray and labels from the manual feed. Do you have any fixes? Thanks in advance. (We don't allow duplicate posts of the same question on the Forums. Please answer in "Outputting Issues". This thread is closed.) [ October 20, 2001: Message edited by: LiveOak ]

My first question would be what is the UPS software doing? A normal shutdown, would cause Filemaker Server and all other applications to Quit first. This would disconnect all guests and close all databases normally. The UPS software must be doing something abnormal.

I am using the Perform Applescript script in FMP 5. I want the script to open my Timbuktu and navigate to a particular FMP Server. That part works fine. However, after I run the script in FileMaker and Timbuktu comes up, I press "cancel" instead of "OK" then I get an error -27. I know I need an additional line at the end of my applescript that says "If user presses the cancel button then tell application Timbuktu to quit". I just have no idea how to write that in applescript. My script is pasted below. TIA tell application "Timbuktu Pro" activate open window "New Connection" end tell tell application "Finder" activate open selection end tell t…

I would like to create a script using either applescript or filemaker to perform the following: at 7:00 , 10:00, 14:00, 18:00, 22:00 perform filemaker script "import" To give you an idea of exactly what I am try to accomplish- We have a in house system here and we have a remote filemaker web server host and we would like to import our new records without having to have a person doing it. So that is why I have times to perform script. Thanks!

Hi, Am using the script as mentioned at the bottom of this message, but at the last step it gives a wierd error Can't make

If I try to tell FM anything over the Network with AppleScript, I always get an error. This Problem occurs not only with FileMaker, there are other applications reacting the same way. Is FM not scriptable over the network?

Hello, Is it possible to import pictures (and not only a reference to this pictures) in a container field of FileMaker WITHOUT using third party osaxen. Only the Finder or Apple's "osaxen". Thank's. -- Jean-Marie -HOO;-)

I am writing values to succesive cells in Filemaker 5. When I go to a new cell, if its value is "" then I need to perform a different action. I need something like ...if current cell = "" then ...etc. Thanks

I have an AppleScript snippet that is the following: tell application "StuffIt Deluxe

Is there a forum for applescript similar to the FM Forums? I have an applescript triggering a FM script that works on a timed basis. The problem is that it goes at seemingly sporatic times also. The part in question is "set TS to time string of mydate if TS contains "9:4" and TS contains "AM" then set BS to true else if TS contains "12:4" and TS contains "PM" then set BS to true else if TS contains "3:4" and TS contains "PM" then set BS to true else if TS contains "7:4" and TS contains "PM" then set BS to true end if if BS then tell application "FileMaker Pro" ...." the time is checked every 600 seconds.

Hi, I do have some basic knowledge of AppleScript with FileMaker, but this has me stumped. I've got a database made for a friend that has descriptions of hundreds of old advertisements. Each record has a unique ID. These Ads have been scanned and saved with the same name as the ID (though with a .jpg extension at the end of the file name). They are all saved on an external hard disk in a common folder called "Press Ads". Problem is that he needs to mail these out to people regularly, and finding them is painful. Is there anyway through AppleScript that I can copy them to a new folder ? Thanks in advance Partha Dasgupta

Hi, I'm new to AppleScript. I created a script to save some of my data as a PDF file using Acrobat.It works fine. I created a field "PDF name" and I'd like the entry in this field to automatically be paste to become the name of the PDF file, without displaying the "Save" dialog box.Is there a way ? TIA

Is there a way to set the field properties, ie. Color by using AppleScript? I would like to be able to create 4 buttons to change the color of the field depending on the status of the item. Also if that is possible, can I also check the color of the field with AppleScript too? [ August 30, 2001: Message edited by: Thomas Lepkowski ]

I am trying to launch a web page address according to the contents of a field in a non-web database, but can't work out how it is done. Can anyone give me a quick tip? Thanks.

You are much better off using a backup file. That ****ing Recover Command will give you a corrupted file fairly frequently. The FM manual even mentions this!

I have a scriptmaker script to enter find mode which my Applescript calls. I then want the applescript to set a field in the find request to a string variable held in my applescript at which point the applescript will call another two scriptmaker scripts that performs the find and deletes found records respectively. I tried doing this all in applescript but I am not yet up to scratch on FM language keywords and syntax for applescript. Where I am going wrong is in the following code when I try to set the "MACAddress" field. I keep getting an error saying "Can't get or set "MACAddress" to "VariableContents" tell application "Finder" activate my GetMACAddr…

I can open a folder in Finder just fine by executing the following AppleScript: tell application "Finder" activate set my_folder to "Volume:Sample Folder:" open folder my_folder end tell My problem is... In Filemaker, I have a script that uses Troi's File Plug-in to search for a particular Folder and the resulting path is placed in "gSearchResults" which is a global text field. from there, I perform an AppleScript to goto finder and open the folder. However, the following gives me the error: "The variable gSearchResults is not defined. (Error -2753). I'm new to AppleScript, what is wrong?? All I want to do is to open a folder in finder from FileMaker. Is ther…