fchieli

Hi everyone, I have a Filemaker Table containing customers and a MS_Sql table containing jobs. On the FM table I have a key field, text, empty (values to be entered by our producers). On the MS_Sql shadow table an FM calculated field that takes the job number from a sql field and removes a few characters meaningful only to our accounting dept. The calculation gives text as result. Basically on the shadow table the sql field would look like AR-12345-001-PRO. On the FM table non accountants will enter job numbers in this format AR12345. I've related the key text field on the FM table to the calculation on the shadow table, but a portal on the FM layout doesn't show anything. As a test I related the key on the FM table directly to the ms_sql field and in this case the relation works as expected... Any one can suggest how to use calculated key on a shadow table? Thanks! federico

Check for file or host availability Hi, I'm trying to make a script that checks if a filemaker file hosted on my office network is available or not. If it is the script continues and imports a few records. If the laptop running the script can't see the office network (the laptop is not connected to the office network) the script should stop. What's the best way to implement this? The File hosted in the office network is described in the External Data Sources as: fmnet:/internalofficeservername.ourdomain.com/OfficeFile The name internalofficeservername.ourdomain.com only resolves internally (there's a record in our internal dns server, but not on our external dns servers). I tried using: Open File [Open hidden; "OfficeFile"] if[Get (LastError = 802] */ Unable to open file Exit Script[] Else etc........ also tried if[Get (LastError = 100] */ file is missing Exit Script[] Else etc........ if[Get (LastError = 803] */ Host cannot be resolved Exit Script[] Else etc........ All 3 attempts are not giving me what I'm looking for, even if the "OfficeFile" is not available the script continues... What gives? Thanks for your help! Federico

Hi Everyone, I'm using a standard installation of Filemaker 9 server advanced on a Mac OSX 10.4.11 machine When trying to test sending mail using phpmailer I get this error: Warning: fsockopen() [function.fsockopen]: unable to connect to ssl://smtp.gmail.com:465 (Unable to find the socket transport "ssl" - did you forget to enable it when you configured PHP?) in /Library/FileMaker Server/Web Publishing/publishing-engine/php/lib/php/class.smtp.php on line 105 Mailer Error: SMTP Error: Could not connect to SMTP host. It's the second SSL related error I get on this server. How do enable openssl on the server? Is it the way Apache is built or a PHP module ? Thanks! federico

I set a web viewer to show my gmail account. I can basically bookmark conversations URLs to FM fields, the only thin I can't do is pass my user name and password from a couple of filemaker fields to the gmail authentication form in the web viewer... Is anyone aware of a way to do this ? Thanks!

Wow! brilliant!! Thanks so much. federico

Hi, I'm trying to find the most elegant way to give to users the option of tagging (select) a bunch of records. For instance, let's say we have a list of several contacts and we want to isolate a few that need to be printed. The most obvious way is to include a check box on every record, have the user checking the box on the desired contacts and then do a find for checked contacts. This works great on a standalone solution, but if the solution is hosted on a server there's now a problem: User A marks his selected 4 contacts, a few seconds later User B selects a set of 5 different contacts. When user A issues the find command , he's going to find his 4 contacts + the 5 contacts of user B... Has anyone seen a good way to solve this type of problems on hosted solutions? Thanks on advance for your suggestions! Federico

On the Admin application to manage the server there's a plugin tab. Can i install regular FMPro plugins on the server and have clients using them without needing to install them? Is every plugins server compatible? I've been experimenting with myFmButler do script. I've installed it in the extensions directory of the server. It's enabled on the plugin tab on the server admin, but when I try using the default function to call it, from a client that doesn't have it installed locally, I get an error... Thanks!

We have a couple of FilemakerPro files shared on an Appleshare IP volumes. One of the computers accessing the files crashed. One file got damages and trying to open it generates a "the file is damaged and cannott be opened.Use the recover command to recover this file". Using the Recover command (on a copy of the file) seems to work fine , I get the usual xxx kbytes were recovered , 0 fileds were skipped etc. , but it generates a file that doesn't open and gives me this message: "The access privileges in this file have been damaged or possibly tampered with. Please contact Filemaker Technical Support if the problem cannot be resolved." The file version is Filemaker Pro 4 and was open using OS9 Can anybody attempt (for money) to repair the file for us?