syounker

I just came across an email plug-in from 360works.com. It apparently works in Instant Web Publishing solutions and can be loaded as a plug-in in FM server. I'll be giving it a test in the next few weeks.

Did you find a solution? I'm looking to do the same.

I'm using FM Server 8. When I use fmserverd to stop the server I get a response that server is already running. When I use fmsadmin to stop the server, it asks me to confirm. I want to shutdown server with a script without requiring any confirmation. How do I do this?

I'm using the STOP command with fmsadmin to shut down my server during a power outage. The fmsadmin documentation does not list a corresponding START command. Does FM Server start automatically and open the databases when a computer starts up even though the STOP command was issued or is there a command that can be used within a startup script to start server and open all databases. Thanks

I need to change the body color of a report based on the value of a field. One way of doing this is to have a calculated container field that looks up a color graphic based on a calculation. The problem with this is that the Sliding/Printing feature won't properly reduce the size of a container field. Anyone know a trick on how to set the body color through scripting?

I tracked down the full syntax of the GetURL AppleScript command. You can store it in a property or call it from FMP and use fields you have defined in your database. getURL "fmp7://UserName:Password@IPAddress/MyFile.fp7"

I tracked down the full syntax of the GetURL AppleScript command. You can store it in a property or call it from FMP and use fields you have defined in your database. getURL "fmp7://UserName:Password@IPAddress/MyFile.fp7"

I tracked down the full syntax of the GetURL AppleScript command. You can store it in a property or call it from FMP and use fields you have defined in your database. getURL "fmp7://UserName:Password@IPAddress/MyFile.fp7"

Doh! Apparently the script command whose cell "file path" contains... does not like the # sign in my string. probably because FMP uses it as a reserved string for finding in FMP. time to rename my volume.... Argh!!!

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 find field as well. ="Image Bank #1:H&D Images:1995 APRs:9504095U33.jpg"

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 found it. Under the Format menu there is an option that says "Use System Formats". Once I selected this everything works as it should. My system is set to English and the database was originally created on my machine. Gremlins....

The date fields in my database are requiring me to input dates in the interational format. When I enter a date like 12/23/2004 FMP says the date is not in the right format and should look like 23/12/2004. My operating system is set to use the U.S. format for dates and my date fields are formatted to display dates in the U.S. format. Is there another preference that I'm missing for date input?

In further testing it appears the problem lies with external FMP data sources. I can create tables and layouts in a single file and the script works as it should. When I attach a layout file to external FMP tables the script works for some tables but not all. Not sure if this is a bug or if there is a better way to reference the attached tables. Anyone...?

I have a very simple snippet of code that generates a 'Write Access Denied' error. On one table the code works but on others I get the error. All of the tables are in one file that is external to my layout file. I have relationships set up, but nothing that prevents the creation of records tell application "FileMaker Pro 7" activate database "APR Library" tell database "APR Library" set data of cell "File Path" to myPath end tell end tell