FileMaker Server v7 - v11

Howdy all, I am about to upgrade from Server 9 to Server 10. Here is my issue(s): -Currently server 9 is running on a Windows XP box. In order to upgrade to Server 10, I need to install a Server 2003 box. No problem until here. But, let me give you the scenario. Currently have web publishing and PHP on a separate server. Both servers are running a combined web server for a client. * * * * * If I upgrade my server to Server 10 and to Server 2003, can I still use the features on my other server running Server 9 features (PHP, Web Publishing, etc.)?? Or do I have to upgrade both and go through the whole procedure again?? Alternatively, since my …

Hi all, I recently did an upgrade deployment using a script to install Filemaker 10 Pro (client) to 190 workstations. On some of the workstations, there are no "local hosts" being found automatically by the system... I can manually add them via "favorite hosts" but that's it... Very odd. Anyone know why this happens? Second question. Is there a place where I can specify to the installation (ini file, registry, etc.) what the favorite hosts are? Thanks in advance.

Thanks for everyone's help on my other post. (I had databases that ran about 1/10 the speed they should on FM9 Server Advanced). Here's what I did to try to make this work again. a) I did the export/import thing, exporting my data to MER or FP7 I saved clones of the database c) I recovered those clones d) using the clones, I imported the data again e) I did NOT then save a compressed copy, as I read I should do somewhere, if this matters I also dropped down from FM Server 9 Advanced to 8 Normal, and things were great for a while. For a while. Then I started getting crashing again, and that's where I am now -- the database will go down 1-2 times per day,…

I am developing an application for a medical institution that will be used in several health centers across 3rd world countries. Each center will have their own server (2003), and there will be a main server located at the HQ of the institution. I was told by the IT manager of the institution that the connection between the health centers and the HQ may not always be active because of different reasons. That is why each center will have their own server, which should be sufficient. The job of the HQ server will be mainly to synchronize the other servers when possible. My question is, can I use FM Server in this situation? I am thinking of having the server installed …

does anyone knows how to get back username and password for fms 9 i totally forgot. thanks hasru

I have a need to upload data from one FileMaker Server to a second FileMaker Server. I now know that this can NOT be done within a FileMaker scripting using "From FP7" method or using the "Set Field" method. FileMaker has put some kind of limitation crippling these methods. (Darn you FileMaker Inc ) So can I skirt the issue by using "Import from XML Data Source" and use a http request to the source server? i.e. "http://192.168.1.101/fmi/xml/FMPXMLRESULT.xml?-db=details&-lay=xml&-findall" I've tried this and get some kind of response, and an error of "XML Parsing Error!; Unterminated entity declaration 'ContentType'; Line number 81; column num…

Greetings. 1: I installed FMS9 on Windows XP and the very first time it ran perfectly, I was able to add files to the database and run em at the same time with another OS X. I ran the program again after a few hours and it would not load anymore, it would stay stuck on this address for hours: C:/Program Files/FileMaker/FileMaker Server/Admin/admin-server/launch-page/prelaunch_single_en.html The loading bar of the picture above runs as if it was loading but never loads. I also tried Installing the FMS9 updates from the downloads section at the FM website but an error comes out saying: the updater cannot find a qualifying product on the system. …

Hi there, The Filemaker solution I am responsible for is hosted on an FM server. Every now and then when I need to make bigger changes my company's IT divison gives ma a copy of the file, I change it and then they put it back on the server. Lately it happened several times, that when I open this copy on my machine, I get an error message saying "This file was not closed correctly, FileMaker is performing a consistency check". As I found out, the reason for this is that some clients were still logged on to the file on the server while the copy was being made. The IT helpdesk member who makes a copy of the server located file for me, said that in this case everyth…

Hi, Im hosting a single FM file with few tables using Filemaker Server 8. I have a problem with a global field on one of my table that doesn't update its value even it has been changed from any of the client PC. How can I get it updated as soon as it is changed by any of the users? Please help. Thanks, Garu

Hello, Hoping to get some feedback on a project we're working on. My company is currently building a Filemaker application for our own business use. We would like to eventually offer this program to other businesses, but would like to do it without having to sell Filemaker Licenses. Is it possible to create a Filemaker Application, host it using Filemaker Server Advanced, and then use a flex application downloaded by our customers to access the Filemaker Server database? Hope this makes sense. Any assistance will be appreciated! Regards, David

Ok, I think I have worked out the ins and outs of moving data from one table to another on the same server. I used the SetField method and am happy. Next hurdle on my project is moving data from one FMServer to another FMServer. We have a WAN with multiple sub-nets. To avoid downtime, each sub-net has a "mini-server" that acts as a local server, caching records, and periodically sending the data upstream to our "main-server". Some may call this polling. Some call it replication. The solution I had was to use a looping script for each local (mini) record and SetField[] with the related (main) record for data exchange. The script works great when testing/deb…

I'm using File maker server 9 adv. Admin console / General settings / E-mail notifications / SMTP information. SMTP settings are invalid. Error is given. Here you enter the correct address, password settings, although I can not do. Where I would make mistakes. Please help. Thank you.

Hello community, I'm wondering if FM server 8 works on Mac osx Leopard? The datasheet only indicated it requires 10.3 or 10.4, didn't say 10.5 Currently, I'm running FM server 8 on Mac osx Tiger, which runs on a xserve dual G5. I'm trying to upgrade to Leopard, not sure if FM Server 8 will continue working or not if I do so. Thanks a lot.

So I have a database that's being shared by FM server 9 and it's worked for awhile now. All of a sudden the other computers in the office can't open it. When they go to Open Remote they see the host computer in the left hand box but not the database file in the right hand box when they click on the host. What's going on? I checked the server software and all systems were normal, but one thing seemed very strange to me under one section it said "Filemaker server permits 0 simultaneous Filemaker Pro connections." Any help would be greatly appreciated.

Hi, this is my second attempt to upload a file into FMP9 Server. My first attempt ended with a successful upload. But my new attempt results in a LONG 'checking file configuration' box, which I eventually close giving up, which results in a spinning blue ball, and then eventually 'one or more of your destination folders doesn't have room or doesn't exist' and that just makes no sense at all. I've tried uploading these files both from my desktop and from the db folder they are supposed to be in and it makes no difference. Sometimes when I try to upload, instead of getting what I got above, i just get a message saying that it can't upload cuz its being used by another u…

Hi There! I'm trying to write a Rumpus user file with filemaker server. What I've done is the following: - fill the records with needed info, if anything is added/changed it sets a "global check field". - filemaker server checks every minute if the field is set and if so run the a script. - the script then exports the user file. now first of all i'm wondering whether i'm on the right track, and if it is indeed not possible to trigger the server script from a client. and then secondly i need to move the users file to the rumpus folder. What is the best way to do this? Can anyone point me in the right direction? Thanx! Wouter

When I leave work at night, I like to take home a current backup, rather than the most recent 'on-the-hour' backup from the backup folder. I just discovered that I can make a zip file of a currently running (FMS hosted) file, without stopping the file with the admin console. That means I don't have to run the admin console, stop the file, make a copy, then restart it. Is this an ok thing to do or am I asking for trouble? Thanks, Phil (aka Lazy Bastard)

I have a client running Server 9 on Mac. They have set up a VPN for me so that I can give support remotely. I have Windows XP SP3 and am using FM 9 Advanced. I can open the remote file dialog. I can see the host name in the left panel. I can see the list of available files in the right panel. When I double click a file to open it, I get a coffee cup cursor for about a minute, and then FileMaker gives up and nothing happens. Is this a common cross-platform problem? I have no problem opening their files directly (from CD-ROM backups). Any ideas anyone?

FM9 Server Adv - IWP deployment. OS X 10.5.6 Multiple databases - each client has their own set of applications. Multiple customer branded web pages. Apache configured for VirtualHosts, one IP, branded web pages in separate directories, sub-domain access set up in hosts file. Web page contains link to each clients set of databases. This works perfectly. Problem comes when .... 1) cancel at login in iwp_auth.html 2) Scripted exit database Both return to iwp_home.html - and not one that is unique to the customer, so they can never get back to their own set of databases without re-entering the subdomain URL Replacing the Javascript in the…

Hello, Does anybody know of any issues with Filemaker Server 9 admin console and the latest Mac OSX Java update 3? Current configuration: I have a Macbook running OSX 10.5.6 that I did the latest Java update 3 on. I am trying to use the admin console to log into a remote iMac running OSX 10.5.6 and filemaker Server 9 advanced (with the filemaker 9.0.3.326 updater installed) but without the Java update 3 installed. When I try to open the admin console on the Macbook it never loads up. I get the Java start up screen that says "Java starting....", but then it just quits. Is this an isolated problem that only I am having, or an issue with the Java up…

hi... i have this problem since i bought fms 9. i installed on windows 2003 server. the screen show 'wait ...'. i read in the forum and they said problem with the latest java. i uninstall java version 6.10 and install java 1.5.9. still the fms cannot run. everything is ok when i run fms 9 on windows xp.

I have a pretty standard FMSA9 installation running on a: Dell Dimension 4600 Windows Server 2003 Standard SP2 Dual Pentium 4 @ 3.2 GHz (or one hyperthreaded P4, which I'm told shows up as two CPUs in the Device Manager; I'm not really clear on this) 1.5 GB RAM 80 GB Maxtor 7200 RPM DMA/ATA-133 drive A single 100baseT Ethernet port ...and our Internet connection is a T1 at 1.5 mbps. We have ten phone lines on that T, so voice traffic can pull up to 640 kbps if everyone's yakking at the same time. This works okay on the LAN in the office. This sucks donkeys when accessed remotely, to quote one of my users. Bandwidth is obviously an issue - what w…

Ok background, I had a FMSA10 on a Mac OS10 Server go down due to various reasons. Installed FMS on a temp backup server with the databases while the original server was being repaired, and had no problems. Ordered a new Mac server and installed FMS on it and immediately received a license conflict message and an abrupt shutdown of the databases on both systems. I'm not going to go into how wrong that system is. But, since I have now decided that we are going to have two FMS systems running in the future anyways as a backup, Ordered a new FMS license upgraded the new system, fired up the FMS and databases and no issues while it sat there peacfully for about 5 hours. Excep…

I have a mixed network of Macs & PCs connecting to FMS7 which is hosted on a Mac G4 running 10.3.5. Yesterday I erased the HD several times, did a complete OS reinstall and did not update it. I reinstalled FMS7 and updated it to 7.04. Yesterday when I left the office, FMS7 and Admin were both working perfectly. When I open Server Administrator on the Server and connect to FMS, I get a blank info screen for about 30 seconds and then an error message saying it couldn't connect. This same thing was happening before the reinstall. The Activity Monitor shows FMS running and we are able to connect to the database through FMS with no problems. I've …

Hi all, I've been using FM for some years now and created various helpful tools with it. I now need to take one application to the web, so that various users can access my FM database read, edit and add information. I read through the instant publish stuff, but decided it was not sufficient for my need, so I'd like to give FM Server a try. I downloaded the Trial from FM homepage to get acquainted to it and check how it is working for my stuff. Using Vista business I installed the IIS service and started it. I then installed the FM 10 Server and followed the installation instructions. When the installation is done, I am directed to a "start…

I am about to upgrade our clients and server to version 10 but I am getting a LOT of resistance from our IT department which considers Bonjour both a security risk and a generator of excess network traffic. Can 10 be run without it in any reasonable way?

Hello All, I am using Filemaker 10 Server running a script that imports a routine from MySql via ODBC. If i run the script manaully from Filemaker Pro Client, works fine and records are imported. If i run the script from Server the following error is stated: Filemaker Script Error: (Admin Concole) last scripting error (802) The file is open and running on the server fine: >>>>> Anyone have any ideas in this issue, Filemaker Technical not very helpful... Thanks, Martin

Here's my setup. Filemaker 8 Server with a couple databases running on it, each one configured with two admin accounts. These admin accounts are set up to allow full access. Filemaker 8 Client. When I open FM client and use Open Remote to connect to one of the databases on the server, everything works normally, and it asks me for my username and password. I enter my admin u/p (which should give me full access), and it connects without a problem... but not with admin access. I can't create or modify records. I've verified that it is authenticating against the accounts I set up in the DBs, since it won't let guests or random character u/ps to sign on, but it also …

Hello everyone. My organization is looking at Nagios as a system monitoring tool. Upon first glance, the tool looks very nice and comprehensive for our needs. I noted that it is even able to monitor specific services/processes on monitored servers. One thing I did not immediately find was its ability to monitor FM9SA. Does anyone know if it is possible, and if so have you succeeded in setting it up yourself? If so, I may follow up with a question or two . TIA.

I set up an account and preliminary password and then selected the "User Must Change Password at Next Login" option. When I use this account's credentials to log in, however, it doesn't prompt me to change my password. Instead, it logs in and allows me to see the databases I have access to, but when I select a database it tells me that my password is expired. I would be grateful for any help this forum can offer. Thanks!

I have a FM db hosted by FMS v10/WinServer 2003. I am having difficulties getting linked images (i.e container fields that store only a file reference) to display correctly on client machines. The clients are running either FMv9 or v10. The image files (mostly .jpeg's) are stored in a shared folder that is located on a volume of the same Win2003 server that is running FMSv10. The shared folder is mounted on the desktop of each client machine. Users can open the shared folder at the desktop level and browse and edit the images with no problem. However.. within the FM client app, the images do not appear in the container field. Instead, the fields only show the pathnam…

Hi. I need some advice regarding the purchase of FMS. I am currently using FM10 advanced to run a database that can be accessed online via IWP at my Hospital. I am a physician, not a developer. In FM Advanced I do use the developer tools. I am planning to expand access to the database, so I need to overcome the 5 user IWP limitation of FM Advanced. I am looking to upgrade to FMS, but I find the FM website quite confusing in terms of what the differences are. I am unsure what I get for the considerable price difference between FMS and FMSA. Does FMS have the same developer tools that FMA has or would I need FMSA? I have no immediate plans to use SQL or ODBC at the moment…

Hey, I have server 9 running and I am trying to go directly to a database uploaded via IWP Right now if i go to say http://127.0.0.1/fmi/iwp/cgi?-db=thisDataBase.fp7&-loadframes a log in screen comes up first. Guest is enabled so anyone can get to it but i want to be able to go directly to the database without seeing this log in screen is this possibile? regards Marcus

FM server 9 hosting files. on the host I also have FM9 advanced in case I have to do some tweeking. Problem is: after compacting a file using FM9Advanced (while FM9Server is quit) the file is accessable and modifiable in FM9 Advanced but when I switch to the FM9Server and access the file from a guest (which has it's own copy of FM9Adv with different license), I can't manipulate inside the relationship window and I can't edit records. I haven't tested all functions but these. When I put back the pre compacted copy of the file into the FM9Server data file, all is well. This occurs with all compacted copies of various files. I end up putting the original back and t…

I have a client that wants to use Server 10 but only has Windows Server 2000 installed on the server. Anyone anticipate any problems with this? I know it isn't 'up to specs' but they have just a few users and I don't anticipate any web publishing. TIA Jerry

I would like to know what the main changes are between filemaker server advanced 8 and version 10. Is there a big enough difference to make it worth us upgrading both software and machine it runs on?

Hi, I am uploading on a filemaker Server 10 one file. Filemaker server is running on a machine. Question. 1 First time when I uploaded file, it was uploaded. I was trying to access from other machine and I removed and tried to bring again. And now its not uploading again... Its saying I do not have space in same folder. I went to data folder and even deleted teh file previously copied. But even its not uploading.... 2) After uploading how I will access from other pc. Please help. Regards, Tusif

I am attempting to clone a DB using File | Save Copy As menu. The selection is grayed out, even though I am [Full Access] account. Do I have to have all other users off the system before it will enable? If I look at a backup copy with same permissions, the menu selection is available. Thanks.

I've got a client setting up FM Server 9 Advanced on a Mac OS X Server (10.5.6). There's a regular 280 GB internal drive and another, internal 550 GB RAID drive mounted as a regular volume. (It's formatted as Mac OS Extended (Journaled).) I cannot get the FM Server Administration tool to recognize the path to the RAID as valid. I have confirmed that another directory on the main drive will resolve correctly, but cannot duplicate this with the RAID. This is not a remote drive, which I understand cannot work. Has anyone seen this behavior, or offer any clues? Thanks very much. Bill Krauss

Hello everyone. I came into the office today to find that i could not log into our database. I checked the computer that hosts it and opened the server admin. from there i found our database which has status of "Closed". From there I tried to open it and all the status says is "Checking" and then returns to being closed. Am i missing something really obvious here? I'm sorry if there has been similar posts in the past, but i could not find anything to help me. Any support would be greatly appreciated!! Thanks in advance!

Sorry about the complete NEWB question and if I have posted in the wrong area : Could somebody explain how filemaker's licensing works? The main site talks about users and seats but for some reason I just don't get what the actual cost would be to me. Here's what I am thinking. Move a php/mysql (LAMP) based program to filemaker (reason ... development time and that I've been wanting to take up filemaker for quite a few years.) The program I currently have been working on is a basically a project management setup with a few extras that are going to be increasing over the next 2 years. End users will need access to either individual based apps o…

I recently upgraded my Filemaker Server from 9 to 10. I followed the installation instructions and removed Filemaker 9 prior to installing 10. When I try to connect to the Admin Console from one of the clients (192.168.1.250:16000) I get the FMS 10 start page, however, when I click the link to the start the admin console it tries to open FMS 9 console and I get an error. I can't figure out what I need to do to fix this? Please advise

Is it possible to use a three machine deployment with: Machine 1 running 10.4.11 & FMSA 10 for FM Machine 2 running 10.5 or 10.4 & FMSA 10 for WPE Machine 3 running linux with apache? Thanks, Drew

I have a client who is on Server 8 I am signing in with VPN and using Server Admin 8. Clients are administering the computer from another computer on the LAN with Server Admin 8. They are all windows. My other client's are Mac. I need to point the manage to exact place to check. I do not have direct access to server but they do have an IT contract firm. Do I need to have any ports on my computer open for Admin 8. Thanks patricia

When installing FMS 9 Advanced I had to put a redirect for IWP to work. Now when I check the box for the security setting it breaks. What do I need to do? Do you think this is because of the redirect? Thank you.

I've installed Filemaker Server Advanced 10 on a W2K3 box, running IIS 6. Get the following error during server deployment: Web Server Test Failed Unconfiguring web server... Return Code = 0 Testing Web Server ... Return Code = false Can't seem to find any documentation for this problem. So far, I've tried reinstalling IIS and going back and forth between installs of FMSA 9 and FMSA 10. Very frustrated at Filemaker's offensive scarcity of documentation. Did I really just have a client buy a 50-user license? : Anyone got an idea what I can do next? I'll call FM support on Monday but hoping for a solution before then.

I currently have FM 9 Advanced Server running on Windows 2003 Standard Server, 10 Lic. When I tried to update to FM 10 Advanced Server I keep getting the message that FM 9 is still running I should read the Getting Started Manual and cannot continue. Perhaps I should have written exactly the message. Bonjour was installed and no problem. Do I have to uninstall version 9 or is it supposed to update automatically. The FM 10 Pro for clients installed with no problem and is running OK despite leaving FM 9 Advanced Server, until I resolve the update issue. One thing I did notice quickly, as it is now my application runs a lot faster.

Hi.Apologies if this is the wrong forum. I have a small business with FM7 located on 1 mac and mostly 1 but sometimes 2 client macs in the office. I don't use FM server. This arrangement has run without a hitch for many years. I recently upgraded the host mac (a powerpc G5) to leopard (10.5.6). One of the client machines is a G5 PPC iMac and the other - the problematic one- an Intel iMac. Both are running 10.5.6. and have done so for months For the first week there were no problems but recently I am no longer able to "see" the server files from the "Open remote" dialog box. I can see the host machine in the (L) hand pane but none of the associated files…

We are still using FMS 9.0.3.325 but I am using FMPA10 client on this one box. I have a local file which has external file reference to our served data file (separation model). Every time I perform a strenuous sort or find, I am thrown 'Communication lost' message. It happens consistently when I stress it a bit. I haven't really lost communication and, after I say OK to the dialog, I'm fine again. But it is very annoying. Has anyone else experienced issues with backward (10 client to 9 server) compatibility? Windows 2003 and XP Pro Client 2002 sp2

Where is the IWP homepage located in the FileMaker Server 10 Installation. I want to create a custom login screen... Cheers Lars

Hi, I am stuck with this and have no clue on how to proceed. With FileMaker Advanced I could just specify the port in the File Preferences and then append the port to the url ala www.domain.com:81 (mapping the respective port thru the firewall) Now with FileMaker Server (and Apache running on port 80) how do I achieve this? Any ideas Thx Lars

We're thinking about the possibility of upgrading our clients to v10, but would like to stay with our existing copy of FM8SA. Are there likely to be any issues with this combination? Kev

Hi all, I was lucky enough to be the first database manager to have his databases put on our then new company server (V9). The administrators just placed my files in the server root. I would like to move then into a folder to seperate them on the server from all the other files (all in folders) What is the safest and easiest way to do this. I now have admin privileges. Any advice is appreciated. WM

I've created a file with buttons for users to click to open several different remote databases hosted on FM Server 8. The scripts for each are identical, except for the relevant filename. The weird thing is, when I click the button for a specific file (the 4th button), I get a License conflict warning and Filemaker shuts down. This only happens when I click the button/run the script. If I open the file using the "Open Remote" menu item, using exactly the same file path (copied from the script itself), it opens fine. The text of the message I get is "The maximum number of licensed users are curently using this copy of Filemaker ... License Key conflict occured wit…

Hi, We currently run Server 8 at our agency...and I wanted to see what the thought about upgrading is...should we upgrade to Server 9 or 10 or just stay where we are? I have upgraded some clients to 9 and they all seem to be working fine with Server 8 (so far) We only have about 50 people connecting to about 10 DB's so it is not a major operation. I have tried to read all the data I can find and I'm just not sure if we need to make a jump up. Any input is appreciated. Jim

Wow... do I have a major problem. Everything was working and without doing a thing I can't host Fmphp anymore. plain html is possible and plain php also. This is the message when I try to request index.php: [color:red]Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 393216 bytes) in /Library/WebServer/xImI/FileMaker/Implementation/Parser/FMResultSet.php on line 72 The Filemaker is working (it adds a line on entry of the request) and also IWP is hosting without problems. But where do I need to look? Is it a apache thing that causes the error. I run a Xserve 10.5.6 FmServerAdvanced 9.0.3.326 (as client FMProAdvanced 10)…

Hello, I developed a problem a couple of weeks ago where my Server Admin Console would crash intermittently when I tried to view the Clients link. This is the error panel that came up: FileMaker Server Admin Console Admin Server Connection Error: An unknown error has occurred. I eventually traced the problem to a particular user. They were using IWP with Firefox 2.0 on Linux SUSE 10.2 machine. The odd thing is it only happened on the Admin -> Clients link. If I was viewing the Clients, and this user opened his file, it crashed, or if he had his file open and I tried to navigate to Clients, it crashed. I solved the problem by having this…

I'm brand new to Filemaker server. Am looking at a copy of FMP Server 7. But, most development work for DB's to be hosted was done on FMP 6. Will this be a problem? I know FMP Server 7 was a BIG upgrade, so I'm not sure if it can handle and work with FMP 6 files. And if the clients with FMP 6 installed can still open the files hosted by FMP 7 server. make sense? Any help?

I've been serving from just a client version of Filemaker for the past year, but just bought my first copy of Filemaker Server and so far I like it. However, I have a basic question about developing my current solution. In the past, when I wanted to fix something (e.g., I wanted to add a new script), I just logged into the primary computer and edited the solution directly. Now that my solution is running on a server, what is the best way to develop or edit it? I noticed that I can still remote in and edit (e.g., create fields, run scripts, change layouts), but I thought I read somewhere that editing a file over an internet connection is a bad idea. Or, should I…

I have FMSA version 9.0.3.326 deployed on a single machine running under Leopard on an Apple Xserve but I can't access databases via IWP. In the admin console, the FMS Overview panel reports that the server status is normal and the Web Publishing Engine indicates that IWP is on. I can also verify that my DB is hosted, along with the FMServer Sample DB, and available via IWP to clients. Also, the recommended ports are all open however, when I run the technology tests using the Open Test Page command, only the IWP fails; My browser (regardless if Firefox, Safari, or IE) remains in a fixed processing state and no errors are logged. Any troubleshooting ideas or solutions?

Is there a way to bypass the keychain stored username when opening a filemaker database? I thought that I had previously been able to hold down the option key when logging in to force the login window to appear regardless of the username stored i keychain access. Thanks

Hi, we're running FM8.5 here, and it has been thrown into my lap when the person who had a basic understanding of it left our company. My knowledge of what can and can't be done with FM is extremely limited (I'm a SysAdmin by trade), so please bare with me. In one of our tables we have a field called 'order_status', on the layout, it is in the form of a drop down box. What I'm looking to do is populate a second field called 'Process_date' (in the same table), with the current date, when 'order_status' is set to a specific value (in this case, 'Paid'). I know how to do this with the likes of MySQL, Postgres, etc, but have come up empty with trying to figure it out …

I am trying to install FM10 Server on Windows Server 2008. It requires Bonjour Services. Service keeps quitting with the following error - Bonjour Service Terminated with service specific error 4294901759 Anyone have any ideas? I tried running the service with administrator permissions, didn't matter

Is this correct? That with a copy of FMP9 Advanced I can preview the user experience of running a solution via the Server, that I don't actually have to have a copy of FMP Server running? A colleague attempted to show me how, but couldn't remember the required steps, nor could we find documentation for this technique. Would appreciate learning whether or not this feature is available and its requirements. I'm on a Mac.

You might want to note that FileMaker® Server 10 Advanced, released today, can manage up to 999 FileMaker Pro client connections, That's quadruple the prior limit!! Steven

The salesman are wanting to work outside the office. How do you all handle this? I can open the two ports in the firewall to access Filemaker Server Directly. I don't know if this is the industry standard. Please help..... Thanks Thom

I've only heard bits and pieces about this since vs. 7 and, when searching, I can't find anything specifically on the subject (I apologize if I'm the only one who doesn't know this). But, if it is important to always close all databases before you 'stop serving database' in FM Server Admin Console, then why doesn't FileMaker do it automatically for us? I believe I've read it can damage your files if you don't close them first and, if true (or STILL true with FMS9) why doesn't FM protect us from the issue by including closing (and verifying they all close) before stopping server? Or maybe FileMaker DOES close them (if we forget and stop the server before closing al…

I have windows 2003 server (SP2) running Filemaker Server Advanced (9.0.3.326) - I'm using external authentication with accounts in Windows server - Most users are Mac Clients. I'm having trouble with the clients showing in Filemaker Server twice and the user is getting a message that they (themselves) are modifying a record in another window. (before you jump to the answer of the other window problem they are in only one file with no additional windows open) This just started happening when we installed the new server and moved the databases over. I can correct the problem if I log into the server and disconnect the oldest user.

I've encountered a crasher where Server 9 Admin Console crashes consistently whenever I look at any screen other than the overview screen. I understand that Server admin console uses a Java runtime. Maybe I need to update the Java runtime?

Hello, I am running FMS9A on Windows Server 2003. We have been up and running for about a year now. We have been keeping up our Windows updates and patches. I want to make sure the rest of the system has the latest updates, but I do not want to break FileMaker. For example, I read on one posting that Java version 7 is ok, but version 10 causes a connection problem with the admin console (per answer ID 7029). Does anyone know if version 11 (just out) works ok? (aside - what the heck is version 6.0.0.b105??) In conjunction with Java updates, do Tomcat Catalina version also need to be updated? What version should be used? Is there a place to fin…

Using FMPS8 on a MAC server. I have no physical access to this system other then Mac Remote Desktop. Its located in another building completely. All clients are using FMP8 on MACs and can access the server fine, including myself using FMP8. Installed FMP8.5 Advance on my Mac only. I now can't connect or even see the server using FMP8.5 Advance. I downloaded and installed all updates for the FMP8.5 Advance client. FMP8.5A has not connectivity at all to the server. I still have FMP8 installed and it connects to the server and files fine. I have no access issues using FMP8 Any ideas why 8 would connect and 8.5A not? I am a windows network user …

I have a server computer set up and anywhere from 2 to 6 users logged in at once. When I work on one of the client computers and make changes to the database, the changes aren't reflected on other client computers. The user has to close FileMaker and open everything back up in order for the changes to come up. Thoughts? Thanks in Advance!

I've noticed that my server C drive is starting to fill up with FM log files. Especially: C:Program FilesFileMakerFileMaker ServerAdminadmin-master-tomcatlogs That directory is around 1.3GB of just log files. Can I safely delete logs? Is there an automated way within FM Server to clear out old logs. I'm using FM9 advanced server. Thanks

Hi, I have a nightly scheduled script running on a Mac FMP 9 Server. There is no External Authentication set up. In FMP's Accounts & Privileges there is an account, "admin", that I need to change the password for. The problem: every time I change this password, the nightly script throws this error in the Logs and Email notifications: -authentication failed on database "XYZ.fp7" using "admin". Any idea how to stop this so I can change the password? Many thanks, Pat

We just received two new laptops running Leopard (10.5.5). When we open Filemaker and go to connect remotely, the production server running on a Mac (OS X 10.4.11 running Filemaker Server Advance v9.0.3.325) does not appear but the development Windows server (Windows 2003 SP2 running Filemaker Server Advanced v9.0.2.151) does appear. We have tried downgrading the OS on both laptops and have tested 10.5.4 and 10.5 and are still unable to view files on the Mac server. OS 10.5.4, however, is able to view files from both servers. Has anyone seen this before? Is there a fix for this? Will we just have to downgrade the OS on the laptops to 10.5.4 or lower?

Hi, I have FM web application (CWP), hosted on two machine configuartion. Database consist of multifiles, hosted on FM server 8 (database server). An web (xsl) files are hosted on other machine which has FM server 8 WPE. It sometimes stops the WPE access. And error message displayed in web browser is 'HTTP Status 500" & root cause :java.lang.OutOfMemoryError What must be the reason and solution to resolve this error? Thanks in advance..

Hello, I just upgraded from FM4 (yeah, I know) to FM9 (Server and Pro). In the old version, a FMP user could close the database on the Server (as in take offline) in order to do maintenance (archive data, modify db, etc). I can't seem to find that functionality in the new version and giving access to the Admin Console is not something I'd like to do. Am I missing something or am I out of luck? Thanks, Mark

Problem: I have one file that works perfect locally with FMPA and as well as when served on a test FM Server. The file crashes FMPA every time when hosted on my production FM server when I enter define database. This problem occurs with no other files on the same server. Solotion attempted: I reinstalled FM Server per FMI's documentation. Current status: Unsuccessful elimination of the crashing problem. Perplexed, Drew OS X 10.4.11 FMSA 9.0.3.325

All of a sudden when I try the shortcut on my workstation it gives me a java message with a lot of gobblygook info. If I go into http://localhost:16000 I get it to work. How can I create a new shortcut on my desktop and have the start, programs, server work?

First off, there are several things wrong in terms of best practice, and I'm aware of them, but it's the database owner's decision. So that said, I'm trying to find out if the issue is not necessarily related to the violation of best practices, and if so, any possible remedy. Client: OS X, 10.5 (latest). FileMaker Developer 7.0v3. (v. 7 is not supported by FMI, and even when it was, v. 7 was not supported under 10.5). Server: OS X, OS X 10.4.11 (non server). FMS 7.0v4. I found that when opening a database on the server from my client, and making schema or accounts changes (with no one doing anything on the database) (I realize that many would recommend a c…

I just added a database to my server which already has a well functioning database. It's in the right folder (Library>Data>Databases>OldDBFolder, NewDBFolder). Server9 Console shows me that it is Normal and check marked under the Pro column. But when I go to my client computer and use FM open remote file then click on the server location, I see the other older DB files well by my new DB files are not listed. I tried: >Restarting the FM9Server, >Refreshing the list, >Moving the new database files from its folder (still under the Default Database folder) to the folder containing the seen old databases (still inside the Def…

Hello, do you have positive/negative experiences with running filemaker clients v8 using a v9 server? best wishes, Sebastian

Hi, everyone. I was running Filemaker Server Advanced 9 version 9.0.3.326 on a G4 tower, 2.0 ghz, when the database started getting extremely slow, approximately 1/2 the speed or normal. It also started disconnecting and generally being miffy, and (horror of horrors) I'd find that the backups I religiously made weren't functioning, e.g. backups of my data from 11/1 had no records in them more recent than 10/22. That's a nightmare, let me tell you. In the past I've had problems with "corrupted databases" that turned out to be caused by a server computer that were just plain bad (either the hard drives or the computers themselves or something), so I decided to replace…

Is it possible to script a window (or a file) to close if it is inactive for a specified amount of time?

I have fms 8 installed and want to use command lines to control it. I have fmsadmin installed and working fine on my computer but the command lines seem to be trying to access server on my computer not the computer the server is on. I can connect to the server fine using the admin console. the ip of the server is xxx.xxx.xxx.1 and mins is xxx.xxx.xxx.10 and in the admin console the hostname is filemaker server. Im using the command window in windows and type fmsadmin list files and it returns an error saying xxx.xxx.xxx.10: ip address is invalid or unreachable error 10502. so how do i structure the command to reach xxx.xxx.xxx.1 ?

I am looking for advice on the best way to host a set of databases. My goal it to allow multiple customers to access their own database on my server over the internet. I am doing that right now for my own database. The issues I'm struggling with are: 1) How can I share multiple databases with multiple customers and insure that customers can only see their database in the list of avaialble databases on the server? Both file sharing and IWP expose the names of EVERY shared database on the server when logging in. 2) How realiable is this? How about performance? 3) The part that really scares me is security. Is anyone else trying this and have you been suc…

Hi @ all: I'm searching for the FMFMP50.DLL, but neither Google nor FMForums or Filemaker.com know an answer. Can anybody tell me were I can find this Driver? Best regards Yellowspam

FMI has identified an issue with the Java 6 Updater 10 and FileMaker Server on the Windows platform. Please see www.thefmkb.com/7029 for information. Steven

I am having problems with my database served on fm server 8 I have a main file with 1,600,000 records. It keeps losing records. I`m not sure if the problem is with fm server so I am trying to find out what version of fm8 server I have. I would like to install the latest version

Some modern programming environments support concurrent development. That is, two or more programmers access a set of files from a server and work simultaneously to modify the code. I'm not talking about doing development work while end users are active. Is this possible in the current release of FMP? If so, what's involved? Kind regards,

Filemaker has issued updates for FMP, FMPA, FMS, FMSA products to correct the SSL / Year 2038 / Remote Host issue. http://www.filemaker.com/support/downloads/index.html

We're currently running FM Server 5.5/FM Pro 6.0 on our Windows network, Server 2003 on the servers, XP SP3 on the workstations. I'm planning on Migrating to FM Server 9/FM Pro 9 on the same domain. I would like to have FM Server installed and tested before we switch over to live data from the Server 5.5/client 6.0 installation we currently have. Doing this would require that Server 5.5 and Server 9 run simultaneously on the same domain (although hopefully on different servers) at least for the testing period, which should be a week or less. Are there any issues I should be aware of (assuming the above is even possible) prior to rolling out Server 9? I assume th…

I'm an admitted noobe trying to get my head wrapped around FileMaker Server. Here's the issue: We have FileMaker Server 9 running on a G5 on the network. The rest of the machines on the network run a mix of FM Pro versions. Accessing the databases through the server while on the network is fine. No problems. Patrick How do I go about accessing the databases from OUTSIDE the network? I'm the administrator by default and don't really have a LOT of network experience. Unfortunately this is a somewhat pressing issue and I'd really appreciate some guidance on this.

I'm trying to establish https on a Mac with FMP Server 8 Advanced to serve web page via XSLT. The certificates have been created (by someone else) and I updated the httpd.conf file to listen on both port 80 and 443. I also enabled the Secure Connection on FMP Server Configuration. When I look at localhost on the machine with either http or https, I can make the connection, but when I try the registered name of the server, only http works. The message I get is that the browser couldn't establish a secure connection to the server. Ports 80 and 443 are both open. Please point me in a direction to go next!! Thanks.

I'm having a problem with a new machine on my network connecting to my FileMaker Server. It sees the server under "Local Hosts" but it doesn't see any files that are shared on that server. I don't know what I'm missing. The server is set to "List all databases." I've setup client accounts for this user on the databases that I want them to get into. This is so strange. I have eighteen other computers here that connect to the databases just fine. I appreciate any thoughts any of you have about this. We are all running Macs with OS 10.5.5 and FileMaker Pro 9.0v3. Thanks. Rick

Over the past few days I have been experiencing License Key Conflicts with fully licensed machines. I am running FMServer 8.### with a mix of about 8 clients. Randomly, FM Pro on a client machine will quit. Upon relaunch the user will get a License conflict. now this has happened before and we had to restart the machine to fix it. That no lnoger works. I have to close all of the DB's and then reopen them. trying to disconnect the just crashed client from FMServer does nothing. I cannot even send a message. Anyone else having similar problems or does anyone have a solution? Thanks

I'm running filemaker server 8.0 v4, and I've recently started trying to implement autoupdating of plugins for our client computers. I've taken the sample Autoupdate file and am trying to use this to update the clients, but I've not yet gotten it to work. As I'm tracking down what is going wrong I come across the fact that the external function YourPlugin_Version (referenced in the fm8_autoupdate pdf) does not exist...why on earth? What did I do to cause this? Anybody have a notion why it isn't there? and what I can do to put it there? the script where it should be called is "Local Plug-In Check", and this is what is in the script... Set Field [AutoUpdatePl…

OK I have a FMS 7 serving around 20 FMP 8 clients. I have amended/ added a number of files on FMP 9A and added them to the server, one using the dacons mail-it plugin. On trying to access these files via FMP 9A I get the response "This action cannot be performed because this file is not modifiable" The files have network sharing on, and Network access to file is set to all users so why are they not modifiable???....don't think Im being totally dim, but its a possibility!

Our office runs Filemaker Server 9 to which appox. 10 Filemaker Pro 9 clients connect. I spend that last few months developing the database on my computer using Filemaker Pro Advanced 9. After testing, I moved the database to the server about two weeks ago and it has been in use since. To create a new record, the user runs a script that opens a window above the list of all records. Once they enter all the data, they run another script that validates the information, set up some relationship, and then closes the data input window. Today, a user followed this procedure to create a new record. However, when she viewed the new record, all of the data that she en…

hi i need help. i have installed the DataDirect Sequelink for ODBC 5.4 on 3 different servers (2 windows 2k, 1 windows 2003) fine. on another windows 2003 server, after installation, the driver does not show up on the installed drivers list in ODBC data source administrator. when i checked the installed programs list, its on the list. need help asap. thanks.