FileMaker Server v7 - v11

I having recently migrated to Filemaker Pro 9 Advanced from Filemaker 7. A script I used in 7, which was assigned to a button and ran very quick, now runs very slow in 9, when run from the same button. However, if I run the same script from the script menu in 9, it runs as quick as it did in 7. If anyone has any ideas as to why this is happening, I would be grateful.

I have an online FMSA 8 XSL form and I was wondering if it is possible, depending on the user that logs in, to only show certain input fields? So if the admin logs in, then the form will show all input fields, however, if user "jsmith" logs in, it will only show the fields "jsmith" is allowed to input? Will I need to set the permission at the database level under the "Accounts & Privileges" section or can I control the authorization from the XSL page? Is this something that can only be done with FMSA9 and PHP?

Hi, I am currently working on Instant web publishing on FIlemaker 7 client and Filemaker 7 advanced server. The Operating system used is Tiger. I am having problems with the IWP. I hosted the file on the server and is working fine. For IWP I followed the following steps: 1. In the server (Filemaker Server Admin) changed the status of the the corresponding served database to "closed". 2. Went to the corresponding directory where the database file is present and opened it using Filemaker Pro 7. 3. While opening it gave me message before opening "FileMaker cannot share files because another user is already sharing files using FileMaker Pro on this computer" …

Any tips for improving performance over WAN? I have a database which opens in about 1-2 seconds on a LAN, but takes 40 seconds or so over a WAN, even after I removed most of the startup scripts that could access data or go to layouts with big graphics. I've done some testing with a big file and small file, and it seems like FMS is loading the entire file's layout structure before opening it. Since this database has a lot of unused crud in it (test layouts, unused layouts, old versions etc.). "Save as clone" gives a file size of about 6MB with no data. I'm wondering if I would get a speed boost if I cut out the unused layouts. Or.. am I misguided my theory…

Hi everyone, I am also have an issue with the PHP Test files and Site Assistant. The Test IWP, Test PHP, and Test XSLT all are not functioning properly, saying that it FM encounters an error - "The requested resource (/:/192.168.1.38/fmi/iwp/cgi) is not available". When manually entering the URL, I can reach the IWP Site with the database references, but the links report that the page says: databases are unavailable. The file is hosted and has the correct user privileges. The test files in the pre-installed locations, the FMS 9 Adv is enabled to use all the extended privileges, and Apache/Web Server is on. I have the firewall completely open, so I know…

hello guys , i'm new in FM Server . I have a question here , when we create new record on the web host by FM Server 9 Adv using IWP , will the source update too ?

Here we go again. Thought this would be an easy upgrade. I am installing the technet version of FMS9 on OS X latest version with all updates on a macmini. Started the admin_console_init_webstart.jnlp and get "The Database Server is not available". I also followed the unistall instructions of fms8 ID#6588 from filemaker knowledge base. any ideas how to solve this? The post started on this(http://www.fmforums.com/forum/showtopic.php?tid/190592/) didn't seem to help. Thanks for any help you can offer.

Hi All, I have installed and setup FM Server 9 adv...databases all being hosted ok. One of the dbs i have setup is for IWP...which worked fine when just running from FM 8 Pro Adv. I could access via the web. But now i need to host this via the server. So i setup the IIS on the FM server 9 adv box (OS = Win 2000 sp4). The iwp_home.html i have placed in the 'Web Publishing' > 'IWP' directory...is this correct? The link to the db in the iwp_home.html file is as follows: http://ipaddress:80/fmi/iwp/cgi?=db=dbname&-loadframes This is how i had it setup in my Pro 8 adv...apart from the port was 591...i have changed the port to port 80 f…

How do I extend the amount of time before the client times out? Is this a server or a client setting? I have an application database that is using IWP and hosted by FMSA 8. The application seems to be taking some users 90 or 120 minutes, including searching for paper or research etc. Any recommendations? Thanks in advance.

Hi all, I'm unable to connect to a database over VPN from a remote source. I can see the database and select the database, but then I get a coffee cup, then a gray screen. The database never comes up. I have other people at remote sites able to connect fine, any suggestions? Thanks, Jason

Hi, I have a strange problem with the PHP site assistant. I click on the next step: choose a site profile but nothing happens.. does someone knows why? I've installed FMS on another machine to avoid this problem. Now I'm becoming an error massage that says: the admin console cannot connect to admin server. I'm working on XP with SP2, no firewall or such things are running. Please tell me someone how can I fix these problems. ps. sorry for my english :B

Hi everyone, Is there a way to download a database off the server from a remote location? I know I can upload from a remote location, but I there are times I need to work on it off the server. I know I can go to the server computer itself and work on it there but anyway to either download or save a copy to my remote desktop? Mike

I recommend all read: http://filemaker.com/support/leopard.html http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=6495 Steven

I'm sure I'm in good company with this, but the limitations of SASE to only Web Compatible script steps makes the bulk of its utility for me worthless. I was talking with another in-house developer and he suggested setting up a dedicated machine that would run one continuously looping script that would pause for 24 hours and execute itself once a day, or whatever intervals we choose. Does anyone see a problem with this or have any other ideas of a way to automate some of the non-compatible script steps, such as Import/Export and Send Mail? Thanks for any help folks.

I am unable to get FMS9 admin working after a clean install of FMS9 with the v2 update running on clean install of Mac OS 10.4.10 Server. I keep getting the error "The admin console cannot establish a connection the admin server". I have tried from the server machine and from a Intel iMac running 10.4.10 as well. FMServer is running but I am unable to finish setting it up.

Hi, I feel like I am behind the 8 ball before I start. I only just bought server8 advanced and fm8.5 advanced and they introduced 9 within a couple of months. I don't think the company will pay for another upgrade but I do need another liscence so my question is if I buy fm 9 advanced will those database run on the 8 advanced server? Glenda

I recommend all read: http://filemaker.com/support/leopard.html http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=6495 Steven

I am trying to set up my web server. In the Adm setup panel, it locates the IIS service, however, when I try to go to the next step it says "Testing Web Server - Return Code False". I am sure I am missing something basic? Any ideas?

Perhaps it's my (mis)understanding of how an opener file should work or needs to be configured, so allow me to explain what we do now that brings up the warning and quits fm: Have distributed a simple opener file to five users matching our five user license limit for FM 8.5 on Mac. The users are to keep this file on their desktop or dock on their mac. To open a database running on the FM Server they double-click their desktop opener which merely runs a script to open a simple "Menu" database hosted remotely on FM Server then closes. This all appears to work fine. The menu db, hosted on fm server, is just buttons with scripts to open a variety of other databases…

Hello, This morning I went to remotely open a FileMaker database from our server and got the following message upon trying to open the database itself... "The maximum number of licensed users are currently using this copy of FileMaker Pro.... License Key conflict occurrued with user "Myself". I don't know how, but it looks like I'm causing licensing conflicts with myself. Say for example my machine was named "Zach HD", any changes I make to the name also reflect in the license key conflict line of the message I'm getting. We're also supposed to have an unlimited license for FileMaker Pro. Any suggestions? Thanks!

Hi. I am new to FileMaker 9 Server. I cannot find a way to "Auto Start" FileMaker 9 Server. Does anybody know how this can be accomplished? Also, any experience running FileMaker 9 on a Mac Mini? What amount of RAM is recommended? Thanks Greg

Is there a way to see the Access Log in the Server Admin Console? Thanks Russ

I just got an alarming call from my IT guy that FM Server Advanced (running on Windows) was not running -- when restarted, none of the hosted databases were even visible in the admin panel. What could be going on? How do we get the databases back? (I know I need to provide everyone with more info, but I'm wondering if anyone has any ideas or experience with this.)

Hi, Can someone tell me what I'm doing wrong? I'm using FMS 8. I want the server to make a daily backup of the databases. The problem is with the backup folder. When I want to validate the target folder, it says that it is "Not a valid path". The path is: filewin://BackupSvr/FMDB I don't want to reboot the FM Server. What is wrong with that path?

Is there a way to change the port that Web Publshing Engine listens to as it serves a FM database? Network/server issues internally here have forced me to install the Web Publishing Engine and FM Web Server modules on a different machine than the FM datbase (FM Server 8.0v4). I have an XServe that is hosting FM Server. The issue i'm facing now is that i need to port-forward incoming web traffic to the box running WPE. The default WPE port is 80. But i have a web server running on the XServe which also is looking for web traffic on port 80. If I could change the port that WPE listens to (591 for instance), I could configure my router to forward traffic for 591 t…

Any ideas why in my FMS9 admin console, the "enable ODBC/JDBC" Option is greyed out? The plug in is there, and I have databases that have the extended privilege set. Thanks.

The title pretty well says it all. Since applying the updater, I'm getting no server statistics. Checked the Logs folder, and the logs are in fact being written. They just don't display in the admin console.

Hi gang, This may seem like a dumb question, but am I correct in assuming that in order to receive email notifications on schedules that the server has to be setup with an email program of it's own and doesn't use any built in one from FM Server? I am trying to set up my SMTP and it's failing the test. I am using FM Server 9 Thanks Mike

The Database: Originally written (preMe) in 3 upgraded by me to 5 and started running it via FM Server. For many years I'd make changes to Layouts and Scripts "live" during the day on the active files. I had a window each week when all would be kept out so I could make or edit fields. All was well in the world. This summer we took these 44files and upped them to 8.5. Some bugs, but all seems OK. Here's my question. I discovered that I can get into Database Design while live on the server and make changes to fields, relationships.... Is this a bad thing? Because I can, doesn't mean it's good for me.

I have a few problems with Filemaker that I haven't found a solution for - and neither can the Filemaker support. We use Filemaker Server 7 Advanced for filesharing. The problems are: 1) If I do a restart of my computer I can't use Filemaker again that day. I get an error message: "The maximum number of licensed users are currently using this copy of Filemaker Pro.... Licence Key conflict occured with user xxx". That is my own machine. I have to wait approximately one day before I can start the program again. 2) We have one file that is shared on the web by approximately 25 people. I use Filemaker Pro 8 advanced on the same file. The web-view and the Filemaker v…

I'm running FM Server 9 on a Windows 2003 SBS SP2 machine. (Yes, I realize that SBS is not a supported operating system, but that's what I'm using and it's not going to be changing any time soon.) I'm currently hosting only two small databases. I have FM server set to back up these databases every hour during the business day. When the time for backup rolls around, I get the following error e-mailed to me from the server. The file does not appear to get backed up, as no backup file appears in the backup folder. Does anyone have any idea what this Error 642 is? I searched here and in FM's database but couldn't find anything. ------------------------------…

In an effort better to manage the flow of posts to all the Server Forum sections, we ask your cooperation with the following new proesses, to be effective immediately. 1. Please only post questions related to FileMaker Server 7, FileMaker Server 8, and FIleMaker Server 9 or to the Server Advanced versions as appropriate. 2. Questions about older versions and questions about peer to peer issues with any version prior to FIleMaker Pro 7 should be posted in the Legacy version (.fp5) section of the Forum. 3. Your Moderator will try to help you with this. Thank you for your assistance and cooperation as we strive to serve you better and to provide answe…

Beware -- I'm able to reliably crash my FMSA9v2 server (Mac OS X 10.4.10) using an unregistered demo version of the mail.it plugin (3.0.14.88), by calling it from a Server-scheduled script. I suspect the crash is happening when the plugin tries to put up an "unregistered" dialog. Question -- does this plugin work on FMSA9 within a server-scheduled script if it's registered?

HI, I have been tasked with finding a list of the EVENT IDs for FileMaker Server 5.5. I easily found the Error Code Value list with descriptions in the back of the FM Pro user manual. (Appendix B for anyone that is looking). However, I have had no luck with finding a similar code list for Server. Specifically, I need to find something along the lines of: Event -- Description -- Variable 2 -- Shut Down -- 4 -- File Closed -- 5 -- Asked to Quit -- 9 -- User Opening a Connection -- User Name, IP 15 -- User Closing a Connection -- User Name, IP 28 -- User Opening File -- User Name, File Name 29 -- User Closing File …

Hey Everybody, Is there a white paper, tech brief, or can somebody give me a little more in depth explanation of the Data entry options under File options. More specifically, if the current systems settings are different than those saved in the file, what types of things will this affect? It says dates, times, and numbers, but how will they be affected?

Hi people @ fmforums I know this topic may be out of place, but it is related to a WAN IP problem I think, so ... I'm running FMP 8.5 on OSX 10.3.9 and I want to share a database using IWP. What should guests type in the address field of their browsers? It is clearly not the local IP-address that FileMaker suggests in the IWP setup dialog! And do I need to configure my AirPort Extreme in a certain way to let outside guests see the IWP startpage ?!? Thanks in advance. Kind regards, pinocchio

I seem to be stuck,and can't find anything in the manuals or on line...The FMPSA v.9 install went well, the FMServer_Sample opens remotely in Pro, and in IWP, but I can't figure out how to get other databases I upload to open in IWP, or show up in the /fmi/iwp/res/iwp_home.html page. How is this done? I have tried setting IWP both before and after the database is uploaded. Thanking anyone for advice.

Hello, I have a call log db solution that allows our customers to log problems by email. My question is to do with Server 9 & SQL integration - so I hope i'm in the correct area We use two SQL tables for 'mail_in' and 'mail_out'. I have added the SQL 'mail_in' table to my FM Schema & created a relationship to 'match' the incoming domain address to the correct customer in my FM Customers table... My problem is this - I'm wanting the server to execute the send/receive script by schedule & i'm having a problem with my only supplemental field. The supplemental field I have in my shadow table uses the above relation to 'lookup/calculate' the desired…

In the admin console for FMSA 9.0 I click on the Edit Deployment link and activate IWP. When I get to the Configure Web Server, there is an empty pop up menu and a check box that says "skip this step and select web server later". IIS has been activated on the PC, but it was activated after the FMSA initial installation. Do I need to re-activate IIS, re-install FMSA or just restart the Component Services and/or the PC? Also , what should i see in that popup menu? Am I right that this is what is preventing IWP to work??

Hi, This may sound stupid but I've been looking for this for 3 hours now. I'm hosting about 30 different files, but when my client goes go file open remote, it only sees home. Now I'd like to add some files to that "remote" list on Filemaker Server 8.5 on the Mac, but I can't get it to work. Can anyone please guide me in the right direction? Robin

Hi. Has anyone had any experience getting data in/out between MS Exchange and Filemaker? I need scheduling, resources and such. Possibly email too. I know there are some possibilities using Outlook and plugins, but I would prefer to be able to integrate this at the FM server level directly with the Exchange server. I don't know what is possible with Exchange, ie. ODBC, XML or what... Anyone have any ideas on this? Cheers, Andreas

The updater is now available on the FMI web site on the downloads page. Steven

I just downloaded the trail version of Server 9. I uploaded my database and it works fine being hosted. However, unlike the sample file in the databases section of server, my database does not have all the little check-marks for what options are available. There are check-marks for Pro, IWP, and ODBC/JDBC but not XSLT, XML, or PHP. I really want to practice using the PHP site assistant before I invest in the full software. Do I have adjust my database file to enable these items? The sample server file works fine with the PHP site assistant. Any ideas?

Hi everyone, We have two servers listed as favorites in Open Remote. Both servers have their own licensed copy of FMS9. One server (called Development) is currently housing our files (while being designed) and they reside in Databases. They are being served. The other server (called Production) USED to have files in it which were served. That was unserved and the files removed. But still ... when I open FM9 and select REMOTE, both servers show in my favorites list (all good) but ... if I click that second server 'Production', it still lists those files there! And I can select them. Of course it then says they aren't there but why are they showing at all? …

Hi, I'm trying to use a JDBC client to connect to FM9Srv. I have a table "test" with a PK "id" (auto-increment). I need, from the JDBC connection, BEFORE insert a record, to know the next usable ID value. If this isn't possibile, there is any way to know it after the INSERT without execute a select? TIA

I have a Windows 2003 Server SP2 installed with Apache 2.2.6 and PHP 5.2.4 working. How can I configure the Filemaker server web publishing feature to use Apache and PHP5 on my Windows box? The server deployment's enable web publishing does not detect the Apache web server. The error message "Could not get a list of web servers from the specified worker machine" appears. We do not want to IIS as our web server option. Any manual configuration instructions would be appreciated to have FM9SRVADV work with Apache and PHP5 instead of defaulting to the only option, which is IIS. Thanks in advance.

I have a some clients who have FMS 8 installed, and I do remote administration for them. Now a client has bought FMS 9. I was hoping to have both flavor on my machine to do the administration, but it appears that I must unistall FMS 8 before installing FMS 9. Question: will I still be able to remotely administer my FMS 8 servers? Thanks, mvreade

Hi everybody. I installed some days ago the FMSadv 9 developper licence. When i'll try to install the web publishing on it, at the screen to choose the webserve, there's nothing. But i have already installed on my machine (Vista) a package (called wamp) that had installed apache 2.24, PHP 5 and mysql 5. I can find the server apache, use php with msql. I probably forget to configure some file. But wich one? I'm new in web publishing. Every help is more than welcome. Thanks for reading my post. Jean-Philippe

Hi! We have a rather strange problem. We are using XML to insert and edit our Filemaker database. We use commands like: "http://admin:[email protected].*/fmi/xsl/login.xsl?-grammar=fmresultset&-encoding=ISO-8859-1&-db=Johner&-lay=Image_Searchword(W)&Archivenr=557024&Id=281&Searchword_priority=50&-new" But after a while with inserts and edits the commands goes slower and slower and finally the WPE "dies" more or less. Then If I reboot it it workes fine again for a while. Anyone have any idéas about this problem? Regards Joakim

Hello- Having some trouble with FileMaker Server 8 Advanced. I wanted to use CWP with FX.php to display some catalog and inventory database, but all my FX.php pages (including the samples) were getting "No action taken" errors. I made some discreet inquiries, and came to conclusion that my FX.php scripts are failing to see/find my databases. As I investigated this issue, I discovered something stranger still. When I go to the web config for the WPE, and click on "Published Databases" under "FileMaker Server," nothing is shown. The menu header for the config interface is there, but there's no list of databases, not column headers. Now you may think that I d…

We have a 2 machine setup. Our Database server is a windows machine(Server 2003), and our web server is an Xserve. Each machine has 2 network cards. On the web server 1 goes out the the internet where all our requests come from, and the other is a crossover cable to the FM server. The FM server has 1 that goes out to our internal network, and one is the other end of that crossover cable from the web server. the two NICS on the crossover cable are configured to be their own network. This works great and we have had no problems until now. We had to change some IP addresses,and reconfigure our network. thanks to our internet provider and our network ad…

Is there a way to automatically add a "Favorite Host" IP address when installing a client in FileMaker 9? I remember back in FileMaker Pro 5/6, there was a text file in the user preferences folder that would store specific hosts that had been added manually. But I couldn't find a similar file for FileMaker 9. Just trying to see if there is a way around having to go to each FileMaker install and add a favorite host IP address by hand. It would be really nice if we could just add the IP address to the "assisted install" file and have FileMaker add it during the install process. Install Info: FileMaker Pro 9 Windows XP SP2 Thanks, Joe Gonzalez …

Hi, Anyone have experience multihoming FM8 server? I've added another network card to our server to allow vpn access through another network. Is there something I need to do in FM server admin to utilize this card? The error message I get when trying to connect to our database on the additional card is "CGE Master.fp7 could not be opened. Either the host name is not available or the file is not available on that host". Any help greatly appreciated. Jason

I can log in perfectly to the file on my desktop, but as soon as I mount it on the server and make it available with the server admin tool, I get this message, "Your access privileges do not allow you to perform that action." file sharing is turned on. what gives?

Hello! We have had this configuration for awhile now: - Mac OS X server 1: Runs Filemaker 8.02 Adv Server - Mac OS X server 2: Runs WPE 8.02 This has worked fine for along time now. But suddenly when our load had whent up the WPE is getting deadly slow. Or it seams that its getting slower and slower until it stoppes. Is this a known problem? Is there anything I can do about it? Regards Jocke

I am very very [color:green]green at this but: I am using FM server 9, it was working great, users were able to see and modify files remotely, blah blah blah. Then, I needed to open the admin console, but could NOT remember the password. So I uninstalled, then reinstalled FM server 9 to create a new password (my last resort). Now, I can't modify any files remotely and there isn't any fmsadmin group listed to redefine. I can, however modify files on the server--I also have fm 9 client installed there. I'm using os x server too, is the problem in my os x or in my fm 9 server?? Also, the upload assistant says "cannot create folder volumes/...(etc). HELP!

After working for quite a while on a solution (interface and data seperate), I moved the files into the shared location on my machine to start implementing it via FMS 8 Advanced. After restarting the system, it seems that all my file references are broken. I've tried to move the files back after shutting down, repair, optimize, and nothing seems to help. I've restated the file references a bunch of times, but the interface files don't seem to respond to this. I have a backup, but now I'm nervous.

Hello! We have had some problems with webpublish eninge and we desided to upgrade the publishengine to 8.04 (the Server is still on 8.02 Advanced). All works fine but now it only uses ASCII for XSLT pages. We tryed to change to different charsets in the webpublish adminconsole but nothing worked. What could be the problem? Regards Joakim

Hi, I have been tasked with moving from fm 5.5 to server 8 and client 8.5 The migration appears to run ok. The 5.5 server is windows 2000 and a 800MHz dual machine. The new server is a quad core 1.8Ghz machine running windows server 2003. The mac clients connect and start the files ok approx 40 seconds, but the windows clients take upto 30 mins. Both load equally quick from the old machine (around 40 seconds) I have tried tweaking the server settings, but there appears to be not much to tune and on the client side even less, I have fiddled with the cache etc. The clients calls a menu file, which is small and loads almost instantly on both systems, but if you …

Hello All, How to I get back to my admin window? It just brings me to this 'server starting page' (that does nothing) or if I type http://:16000 - which also brings me nowhere. I can't see the obvious here. Need help. gsunglao

I have purchased the upgrade to FMSA 9, but unfortunately I have lost the disks to v8 so I cannot conduct an uninstall of v8 prior to installing v9. (We moved offices and the CD didn't come for the trip.) So, my questions are: 1. Is there a way to uninstall FMSA 8 without the original CD? 2. If not, will an v9 install not work without getting rid of v8? Thanks so much. I really appreciate any help you can offer.

I'm just trying to get familiar with FMSA's technologies. I see that the server deplyment assistant won't let me enable the XML component if I won't choose a web server it can detect. I'm wondering if it's possible to enable and use XML without a supported web server. For example, using Apache on Windows. In my particular case, I just want to get familiar with the DB access interfaces FMSA can provide, and I'd like to contact them from simple PHP and/or other scripts run by the command-line interpreter, without using any web server whatsoever. So, actually I want to enable the XML and/or PHP API component without any web server. Is it possible?

I'm trying to install FM 9 Advanced on the D: partition, since that's where we have our apps installed and have plenty of space, but I can't seem to get passed the "User Name", "Organization", "Licensey Key" screen. I click "Next" and it doesn't do anything. I called FM tech support and they confirmed that FM 9 Advanced is supported only when installed on C: but that I might be able to modify an .ini file to install it on a different partition. I've looked at setup.ini but I can't find where the installation path is specified. Can someone please shed some light? TIA

Hi All, I have an end user who ordered Windows Vista Business which will have IE7. In our environment all our client installs have FM8.03. Will there be any issues with this version working with Windows Vista or IE7? Thanks in advance!

I'm sure this has been covered somewhere but I can't find it. How do I access the filemaker server offsite? Do I need a static IP? We want to be able to use a laptop at a location and access the filemaker database server to do entry real-time. There are also others in office working at the same time. I want the outside person at the shows to be able to login and also enter/chaneg data. We are using Filemaker 8. I would greatly appreciate any info on what we need to do to make this happen. I'm sure it's easy and I'm sure the answer is online somewhere but I can't find a straight answer. Thanks!

I have read a couple of post here about the new admin tool not launching in FMS 9. So far the fixes I have seen include; - Repair disk permissions - Clear all caches with Cocktail - Make sure ports 16000 to 16018 are open - Changing the Mac Open command to 'Java Cache Viewer.app 11.5.0' - Reboot after doing the above All of these have been tried on my install, and I still can't get the admin client to launch. Is there something I missed? Any help would be appreciated. Mac OS X 10.4.10

Hi, Does FM Server 9/Pro 9 have an Offline Files feature that allows you to open remote databases when disconnected from the network. I have set this up for Windows shares in Vista and not having FM do the same is the only thing stopping me from having a complete offline solution. Thanks/...

hello all, I've recently installed full filemaker 9 platform in my company local network, which means that that I updated clients and server to filemaker 9. I'm now trying to schedule the backup procedures (please see the attachement to this post), but none of them run properly. In fact, no backup schedule runs. I've created 2 folders and related subfolders on backup partition of my server (dell machine with Windows 2003 server standard edition). back up program should weekly save the copy of databases into the subfolders (at 11 PM in '11' directiry, at 5 PM in '05' directory etc..). Even if the procedure seems to be completed, back up files are not been crea…

I have tried to perform scheduled scripts on our server that will trigger scripts from other files, but I don't get this to work. The event log says error 100, can't find file. Script is performed with an account and password that exist on both files. Filereference tried are file:filename, fmnet:127.0.0.1/filename, filewin:/D:/path/filename Any clue about this someone?

I would like to query a table (select * from table) with MS Excel over the DataDirect-ODBC-driver from my FMS9Adv. It worked a few days on several Databases, but since today ALL clients get an error when they try to get the query result in Excel. It says "SQL Parse error". Restarting the machines did no effect. We also tried another JDBC query to the same Server and this works currently without any errors. Does anyone know how to fix this problem?

I've a db with 45 data files (this was originally written in fm3, upgraded to fm5 then migrated to fm7) Two of my files will have their "Network access to file" changed from All Users to No Users and then fall off the network. Closing the file, opening it in FM and resetting it to All Users and then re-opening in Server gets the file back online. I can't figure out why this is happening. We did the migration to 7 weeks ago, and this problem is just showing up. Thanks for any help.

This morning, I needed to make some configuration changes using FileMaker Server 9's Server Admin Tool. When I tried to open the tool, it went to a screen that showed the tool was checking for updates. It does not get past this screen. It has worked fine previously, and no changes have taken place that would affect the tool. Files are continuing to be hosted, just not able to be managed with the admin tool. Any thoughts? Hardware: Xserver running OSX Server 10.4.10

When I upgraded from FM8.5 to FM9 the LDAP settings were removed. Is there any way of preserving these settings, incorporating them in the 'assisted install' file or any other way of accomplishing this? I have several hundred upgrades to do and I don't want to have to do this manually.

I am learning Filemaker Server and am liking it. I would like to schedule a backup off my mac and onto a network share (in case electronic failure of my server). my issue is I can not seem to figure out the backup path to put into Filemaker Server. Current default path is: filemac:/Macintosh HD/Library/FileMaker Server/Data/Backups/ How would I put the path to a network share? I tried to put filemac:/Volumes/USB/ More specifics is I am using the USB Disk Share on my Airport Extreme Base Station so my share shows as USB on my macbook pro. When I look in pathfinder it shows in terminal as /Volumes/USB/ Any idea's would be greatly a…

I noticed that the FMS Admin Console application was showing the server date and time 90 seconds in the future. Any one seen similar, or account for it?

We recently upgraded both (we have 2) FileMaker Servers & FileMaker Web Server to the new FileMaker v9 Advanced. Our setup is as follows: 10.0.0.2 - FileMaker Database Server (UK server) 10.0.3.20 - FileMaker Database Server (USA Server) 10.0.0.3 - Web Server / Web Publishing Engine (UK Based Server) When running on FileMaker v8.5 we were able to extract data via php from 10.0.3.20 using a relationship hosted on 10.0.0.2. But since we upgraded to v9 this has not been possible. Data is being published successfully from 10.0.0.2. No coding has changed on the web pages, and all the privileges seem to be the same as in v8.5 but still we canno…

Hi, I know FM server 8 runs scheduled backups but does it also run scheduled scripts. I have to create records overnight and when it does not I have to do it with ZippScript. Henk

We have two drives on our FMS machine (Mac OSX). FMS is on the first drive. We want to use the second drive for our back-ups. We have created folders on the second internal drive, but they will not validate. Yes, I have the trailing slash. Why is it now working?

I've installed FMS9 and accepted all the defaults that the installation procedure requires - including using the FM supplied PHP. When I run the test page I only see the code that is produced in my browser (Safari). I was expecting to see the similar results that you get in IWP and XML test pages. Any help appreciated.

I am trying to collect data using IWP. I will have hundreds of participants and it is not practical to create an account for each participant. Is there a way to create one account "participant" but limit each participant to viewing his/her record only? Please advise! Thank you

We are currently running FM Server 8 on a Windows 2003 server. Windows 2003 (32bit) has a limit of 2GB for page file size. From what I can tell, FM Server is still 32 bit, so even if I upgraded to a 64bit server, I would still be looking at the 2GB page file limit. Unfortunately, our install of FM server is getting pretty close to maxing out the page file. Is the MacOS version of FM Server also a 32 bit program, or would it be able to fully utilize the MacOS 64 bit capabilities? Are there limits to virtual memory on an XServe vs a Windows 2003 Server? I would appreciate any advice I can get.

Is anyone serving from FMS8 or 9 on a 10bT network? (I'm not, but a client might.) If successfully, could you describe the specs of the server and clients (speed, essentially)? Thanks.

Does anyone know of a review or at least a list of the various companies who offer FMP Server hosting (I know there are some who advertise on this site)? I tried a couple of google combinations, but I didn't find anything. Thanks, dan

Hi All, I have a client that has Server 8 advanced installed on a windows box (I failed to note whether XP or server version OS), and uses windows administration sharing to get at the drive remotely. This did allow dragging down files to a local client machine, which with no OS sharing turned off, that I am familiar with, would allow. Now windows is not my (preferred) environment. I understand the requirements about system level sharing not being allowed, and have underlined that from the start. The IT person was of the opinion, that admin sharing was different to ordinary system sharing; but they are not FileMaker savvy. Can anyone illuminate me on thi…

If global field values in a shared file situation are only saved on the host computer, how do I save a global field value when the file is being hosted by FM Server? Thanks.

Hi, I have searched in forum but i can not found an answer. The databases published on the web is updated every day. Update process is more than half hour. So during the update my visitors can not see right contents. I want to stop web publishing engine before starting to update and stops after update. (Update process is done automaticly by a script) Stopping and starting can be done automatically? And can I forward to "Site is updating" page during the update process? Thanks in advance Regards Osman

Hi, I am currently working on Instant Web Publishing(IWP) using FM7. I first created a layout in a database in a local developement machine and did a IWP and it worked fine. Then I tried uploading it into the server and tried the same. I tried to enable the IWP option of the DB in the server and it gave me a error saying "Filemaker could not share this over the web because instant web publishing could not be started". Please can someone help to solve this and do a IWP on the FM7 Server Advanced. Thanks and regards, Sudharsan

Today I moved our database files to the new server running FMSA 9, our files were previously on a FMSA 8 system. We have a few scripts in a few places that create records in the database via XML/XSLT/Custom Web Publishing/Whatever and they don't seem to work. Here's an example: http://OLD.IPA.DDR.ESS/fmi/xml/fmresultset.xml?-db=CartSales&-lay=Orders&BillingFirstName=Wes&BillingLastName=Plate&BillingCompany=Duck&BillingAddress1=TEST&BillingAddress2=TEST&BillingCity=TEST&BillingState=TEST&BillingZip=TEST&BillingCountry=TEST&BillingPhone=TEST&BillingEmail=TEST&ShippingFirstName=TEST&ShippingLastName=TEST…

Hello all, Could someone point an example to me where I could learn how to time-control a db file? What I wanted to do is... 1) A user opens up the db, do some editing... 2) Left the DB open for x-number of minutes... -> What I want to accomplish is to have the timer to start counting when there is no activity on the system (ex: mouse movement for example). I was looking at pause/resume script but the best I could do is to assign a value and that's it. It starts ticking regardless whether theres a system activity or not... I wanted to leave a message on the screen informing the user that the db has been disconnected because of lack of activities. …

One thing that really intrigues us about FM9 is the use of PHP. This would be a great help to us immediately. My question is: What kind of compatibility issues are there if we were to update the server to 9, but leave the clients at 8.5?

Hello, we've finally begun our transition from FileMaker 4 to FM8 with FM8 Server (yes, version 8 - owned for year and never deployed ). It has been decided by the higher ups that the first phase will be converting all existing files to fp7 and continue to use as flat files while the new relational databases are being built. My question is about opener files. What is/are current practice(s) in this regard? Currently, with FM4, the files are hosted on a server, and the first to open the file becomes host. All the files have shortcuts on every client's machine (about 8 clients). I'm trying to make things cleaner and easier for the end-user (many are not too comp…

I have FileMaker pro 8.5 and get a timeout when I go online to see my test application on the web at another site. I publish and can see it from my browser at http://10.0.0.1:591/fmi/iwp/cgi?-db=Task%20Management&-loadframes I have a DSL modem, no internal network, OS X Any suggestions apreciated

We've just purchased FM Server 9 and I'm really excited about our commitment to FileMaker Pro for future development. My newbie question is: Is it OK to continue development on a database hosted by FM Server while it is "open" on the server and others are using it? Up to this point all development has been on my local copy of a db, and when new functionality was needed I was the only person in the file making updates. Once I was done, I deployed the solution again to our staff with the new functionality. I'm concerned about data corruption or some kind of conflicts. For example: staff member 1 is in layout "Main". Staff member 2 is in layout "Other"…

I know what the problem is but I don't know how to fix it. Everything is running just fine except that when I try to configure IIS with FMSA it says it can't find the web server. The reason for this is because when I configured my site in IIS I actually disabled the default site and created a new one. Take a look at this screenshot to see what I mean: http://www.angelleye.com/temp/iis.jpg If I disable the angelleye.com site here and enable the Default Web Site, then the FMSA configuration finds it successfully. The problem is I already have the SSL configured for this current site and don't want to mess with changing all of that. How can I make Fil…

Helo I hope somebody can help me with this tricky one: I try to find a way so that i can store a file that is in a container field on the host server. Example script: Go to field [select/perform; PDFkart::PDFkart] Set variable [$SavepathOnServer; Value:"filemac:/85.196.85.67/ServerDisk/Library/FileMaker Server/Data/Databases/" & Get ( ActiveFieldContents )] Export Field Contents [PDF::PDFkart; "$SavepathOnServer"] This does not work. I have also tried Set variable [$SavepathOnServer; Value:"file:/" & Get ( ActiveFieldContents )] in hope that it should be stored on the host server, but the file i stored on the client machine in the Filemaker app…

I've read that new in FMS 9 is "Server-side searches and calculations provide faster access to results" So I need to do anything special to enable searching by the server? We've had some horrendous query times with FileMaker 8.0 clients on our FMSA 8 server and I'm hoping to see these times drop with 9. I just wonder if I have to do something special/different in order to benefit.

When installing FM WPE on the FMSA 8.04: -Windows 2000 Server Server installs ok, and WPE appears to install ok, but when I go to http://localhost/fmi/conf some strange things happen. 1. I create a username and password - fine 2. I check FMS is on same machine - fine 3. I create a username and password for WPE - fine 4. I go to connect to FM server with ID and passcode (checked and I am entering the correct info). 5. After clicking commit the web browser says "an unexpected error occurred" 6. I go back and try to do this again and I login to window 1 ok, but then when I want to configure the WPE and try to enter my Username and password, which I know…

Is true Integrated Windows Authentication on a Windows box possible? The FM Client uses this, but coming through Internet Explorer through Server Advanced forces authentication. We have RSA fobs at work for the desktop but no RSA on the servers so people have to remember their windows passwords to log into Server advanced ... Any work around for this? Does Server 9 Advanced add this by chance?

I installed FMSA 8 and the WPE this morning. I can't get in with what I thought was the login/password that I just set. I have tried every combination I could think of. Actually I am pretty sure of the password, but not the login. Does the application list or store the account names anywhere? Or what would you recommend I do at this point? Thanks in advance

I'd like your help preventing the dread disease called "cross-talk". "Using FileMaker 8" applies this term to a situation where the wrong version of a referenced file might be opened, if more than one file by that name is being served at the same time, anywhere on the network. (See pp. 526-528.) Our users have FM Pro 8 and 8.5, and we're developing in FM Pro 8.5 Advanced. We'd like to run two FileMaker servers on the same network: one for production, and one for testing. The same set of files would be deployed on both servers. If we were to only use relative paths, and only put one path in each file reference's file path list, would that be sufficient to preven…