FileMaker Server v7 - v11

I have a shell script that works on my local mac via terminal "curl -s -T /Users/me/Desktop/Pictures/test.png ftp://id:[email protected]" I have saved it on the Filemaker server filename: ftp_upload.sh (unix LF, Unicode UTF-8) directory: Filemaker Server/Data/Scripts/ I have created a FMS schedule to run the file, but it is unsuccessful. Am I missing something?

Filemaker Pro can open two databases with the same names. Obviously the operating system requires them to be in separate folders, but FM Pro doesn't object. I'd like to be able to clone a set of templates for different groups of users and host them from the same server. The advantage would be that updates could quickly be disseminated without having to rename a lot of files and rename all of the external file references. However, unlike FM Pro, FMServer refuses to host two files with the same name. Simply putting them in a different folder doesn't work. Filemaker Server's Admin console even refuses to list the duplicate file name if a database with that name is alr…

Hi, I couldn't find a JDBC forum sorry, so I am posting here. Please point me in the right direction if there is a better location. I have several databases on fm server. I want to access them via JDBC. I created a single database with references to the other tables as stated in the fm10 jdbc guide. "If your FileMaker database solution uses many FileMaker database files, create an additional database file that contains all the necessary external data source references, table occurrences, and relationships for your solution. Then define this additional database file as your data source in the JDBC URL. All of the FileMaker database files must be on the same …

I have a nifty timecard solution that I have been working on. All the employees clock in/out via a simple screen where they enter their number and press a button. Works great. The problem is they access this via IWP and IWP logs the user out every X minutes. Is there a way to set this up so it stays running all the time without logging out? Right now when a shift starts the first person to clock in will log in with a generic username then they will be able to access the "clock" screen and everyone else will be able to clock in/out after that but when lunch or the end of day comes someone has to log in again. Is there a way to get this working with IWP so they don't h…

Hello together I have a FM-script running as a schedule on my FM-Server and it's producing "errors" such as the beloved 401 NoRecordsFound (which imho is no error) so it's consequently spamming my Server Event Log. As ErrorCapture is not compatible with the server environment, does anybody have an idea how to prevent this from happening? (My script is going to run hourly and is checking 24 tables for journal entries to process them into the journal-table... so, it matters otherwise it's going to be a LOT of entries)

Hello all; I'm trying to get a FileMaker Server (v11) that is hosted on a virtual instance of Win 2003 (Hyper-V) to gracefully close files etc. when the host machine is shut down. I've read numerous articles stating that when Win 2003 shuts down, it should execute the shutdown script that is defined within the GPO, and then close the network connections, but I am finding that the opposite is true in this case. Because of the fact that network connections are getting closed prior to my shutdown script executing, FileMaker clients are not being notified of the pending shutdown (and hence have no notice). Any un-committed changes that these users have are also o…

Does anyone use FileMaker PHP on IIS with SSL. Im trying to get the FileMaker sample working on my test machine and I just get errors. I can give you details on everypart of the configuration as it is on my test machine and not our production environment. The test cerficate I am using is generated by the IIS 6 resource kit if anyone needs to know, but the installation itself is producing EXACTLY the same error as our real server machine. When the Sample PHP test page tries to connect I get an error 22.... any help would be much appreciated. Thanks Jalz

Hello All - I have been asked to begin to take over some of the admin responsibility for our office regarding Filemaker beyond my current comfort level. I've been an end user for 10 years+ and pretty well up to speed on the design of the files themselves, but a complete entry level noob on the server side. Any suggestions for a guide/manual to get a good handle on the basics? I didn't really find much at filemaker, and I've always preferred the third party books (FM pro 9 Bible by Cologon is my current favorite) Thanks in advance for any suggestions! Darrren

This might not be a server problem, but I didn't know in what other category to post. Here's what's happening: If a user creates new records in a database, it fills the fields out with random information from other records. The first thing that popped to my mind was file-corruption. But here's the kicker... it only happens from ONE client machine. All others, whether remote or in the same network/subnet are good. I've tested it. The leads me to cache... isn't there a location in Mac OSX where FileMaker saves the database files temporarily if they are opened over the network? Removing this cache could help, no? Any other ideas? Thanks in advance, any he…

I just saw it for almost nothing on ebay. Item # 150499847126 just in case anyone's looking.

Can anyone help? We badly need a copy of Server 8 (or 8 Advanced) __for Intel__ to replace our copy running on an old PowerPC G5 which is on the point of failure and needs a hardware upgrade. It seems that Filemaker ceased support for this a few months ago, and I'm unable to find a copy anywhere. And no, we've tried but can't update to a more recent FM version, due to masses of legacy scripts we've written for this over many years. If anyone has a box on their shelf, or knows where I could download it from etc., you'd be a friend for life. We're willing to pay a fair market price.

I've read this post: http://www.fmforums.com/forum/showtopic.php?tid/194129/ But it does not fit my case. I have a script in FM 11, that imports from one table to another. I keep getting script error 100 (Which is file missing) Is it the import step, thats not compatible with the server script. If this is the case, and I need to use a bot, How do I bypass the user name and password, with out giving everyone access?

Hi, If I use FM Pro 11 to access a file hosted on FM Server 10, will the quickfind script step work? Thanks in advance!

Hi All, I just finished a migration of different databases from fp5 to fp7 on a FM Server 11.xx. Everything is rolling just fine. I just want to know if there is a way to hide all the database files in the remote window, except the" Main Menu.fp7" that is the starting point of all users. By doing that, I would like to avoid confusion for the beta users. Thanks for replying Nick

I don't know if this is the right place for this topic, but here goes. I have a database hosted and multiple people using them at once. I want to know if there is a way for a user to perform an action that will then make my local database perform a script. For instance, if a user selects a certain drop down box category, it will set in motion a script that will notify my immediately. Currently I do this through a combination of apple script / mail. I just wanted to be able to do it all inside filemaker. I was thinking about doing it based on ip so the "warning" would only run if the computer's IP would be "X" so everyone would not see the warning i want to se…

We are not able to use the Admin Console to manage our shared databases. The actual sharing is working perfectly. We can log onto the server console and access any of the settings under Configuration. However when we select Clients, Databases, Schedules or Statistics the data is displayed correctly but immediately we get "Admin Server Connection Error: An unknown error has occurred." On "OK" the console closes. We have upgraded to server 9.0.3.326. The server is on a windows server which according to our IT support is "running Windows Server 2003 R2, Service Pack 2 (and fully patched with all MS patches prior to SP2). The installed version of Java is Jav…

Dear FileMaker Experts, Have you guys all seen this article? http://help.filemaker.com/app/answers/detail/a_id/7701/~/deprecation-of-xslt-api-for-custom-web-publishing When they say this, does that mean that with the next version of server our current FileMaker Server xslt will be gone or removed? If so that is very troubling and reminds me of how they removed the .dbf import and export in a recent version that caused such an uproar. Is it possible to get them not to remove that api as we have been using it for years and have lots of uses for it? Thanks in advance, Shawn

Hi, we have Filemaker server 8 and will be upgrading to FM server advance 11. In order to install the upgrade do i need to uninstall Filemaker Server 8 first? If so, how do i find out the serial number for # 8 since i lost the sleeve with the key. THanks

I know the header says only versions 9, 10, 11 but we are using 8 and looking at upgrading to 11. Should we expect any issues to arise? Frequently problems encountered? What is a reasonable project time to plan for the upgrade? We are a smaller agency with only 20-25 licenses so the project management should be minimal-correct? Thank you in advance for any thoughts, suggestions or advice given

Hi Does any one know how I can get the count of users on a filemaker server? is there a script I can run to get this information. I want the full count across the server and not per database?

hi all i was wondering if there is some type of hosting for filemaker that i can point some solutions to. i don't want to use it via web but the filemaker file itself? the client that i am working for wants the solution to work localy but i need a server to host it. they don't want the cost for a server then the cost of fm server. any help would be great.

First, the machine specifics: Server 11 Advanced running on Mac Mini with Snow Lepoard Server. FMPRO Advanced 11.2 running on Windows 7 64-bit. I have an application that constantly crashes on my win7 machine. When it crashes, the server *never* releases the license key. In fact, the only way to disconnect as a user is to go the server and restart the entire machine. "Disconnect" user doesn't work. Is there a setting I need to set in FMServer OR Snow Leopard server preferences? Thanks.

Hi there, I have a Filemaker Database on my computer, and I recently copied this database and loaded it on two other computers. Now there are three copies of the same file, but the two other people that use it are not on the same network as me normally so over time we will all be working off different versions of the database! Is there a way we can all work remotely using one master database and connecting over the internet? Thanks a bunch, any and all suggestions are welcome. J

Hello, We are looking at upgrading our FMS10 Pro Adv to FMS11 Pro Adv. We are not upgrading FM10 pro A at this time as we need to make sure that our app will actually work properly in FM11. Are there any issues with FMS11 serving FM10 DB's. Thanks for your time. Michael

Hello All, A week or two ago i had to wipe and reinstall our 2003 server that host FMS 9, every thing went ok but now about two weeks later i logged on to check it out and when i log into FMS and click on Clients nothing happens, when i click on Databases it comes up but shows NO databases however it shows that i have 35 DB and 17 clients connected.. So i thought i might need a reboot, so i opened CMD prompt and asked FMSADMIN.exe to list clients and it came back with Error 9 when it ust to ask fro a user name and pass. What do i do? IT is NOT doing its backups and i have no way to close the DB's... Im Kinda freaking out some one HELP !

Hi there, I'm trying to execute the following batch BEFORE a Filemaker script @ECHO OFF net use L: sharefolder /user:myUser "myPassword" pause Note that, the user i'm using to mount the share has full privilege. I have to mount a share in order to export periodically a .xls via a Filemaker script. [color:red]THE PROBLEM IS that when the scheduler starts the batch, it says "processing" (or "Wird ausgeführt", I'm using the german version of FMS) and nothing happens. Seems that he cannot execute the command "mount". Any idea ? Thanks in advance ! Flo

I am using FM Server 8.0 to host a file at the office. I can see the file on my Power Book while I'm at the office. I have opened port 5003. However, when home, using the same Power Book get the same issue, the files no longer display. No firewall active on my Mac Power Book. Any ideas?

I looked up the forums and also saw this tutorial: http://www.vtc.com/products/FileMakerServer11/ConfiguringFileMakerServerPart1/92903, but need specific answers/verification on serving up runtime files. As I understand it, runtime FILES, but not the APPLICATION, can be opened on an FM server, as long as there is a copy of FMPro on each client. Here are my questions: Will FMServer 11 open runtime files created in FM10? My application has multiple files that interact with scripting, etc. using the separation model (data files and format files are separate.) I also have a few plug-ins in the extensions folder. What needs to be on the server and ho…

We have an existing process that dumps all of the information in our Filemaker databases out to xml for import into Postgresql. When upgrading the server to windows 2003 x64 and Filemaker Server 11 Advanced we can no longer access the databases over the xml interface. For example, this command used to work: curl -s --user USERNAME:PASSWORD -d "-findall&-db=db_name&-lay=layout_name" http://192.168.x.xxx/fmi/xml/fmresultset.xml Now we only get a response of: Service Unavailable Filemaker appears to have the Web Publishing server configured correctly. I think it has something to do with IIS. Any ideas?

I recently bought FMP Server 11 Advanced but am unable to select IWP from the Admin setup page... thanks for the help...

We have a database hosted by FileMaker Server Advanced 9 via IWP that went haywire and started generating FileMaker Error 504 (Value in field is not unique as required in validation entry options) and Web Scripting Error 509 (Field requires a valid value) at a rate of 200,000 error messages per minute logged into the pe_application log. We’re running FMSA 9 v3 on a Xeon quad core dedicated server with Mac OS X Server 10.5.6. A user had tried to create a new record that had one field that is required to be non-empty and unique. She was confused by this, didn’t understand the FileMaker error message and closed her browser to get out of the situation. I have seen…

Hi there, I need to send an automatic email every 6 months. How can I manage to run that little script every 6 months on FM Server 10 ? Thanks for a quick idea, Frank

Hi there, Here is a sample of my Event log file 2010-08-24 16:54:00.207 +0200 Informationen 645 PMDB Zeitplan "rt": Scriptingfehler (800) bei "Dev_Patchlog_PMDB_V100 : PL_WebExportTrigger : Export Records". Does anyone know what the number [color:red]645 corresponds to ? Thank you in advance, Flo

I have installed FM11A on Windows 2003 Server 64 bit. When i do then "Test Instant Web Publishing" I get "Service Unavailable". The same result when I type "localhost" i IE. Before installing FM11A the "localhost" show my index.html from c:inetpubwwwroot How do I get a successful test. Is there settings til the IIS? Hope the anybody can help me - I am new to FM.

Hi ,right now my database is hosted at the FM Server which is at an MAC. I just wonder if i need to shut the server down before shutting down the MACs occasionally... thanks!

Could someone please point me to some whitepapers or other helpful documentation that shows me how to script or push client updates and new installs? I have 100 users with FMP10 who need to be updated to FMP11 (including any updates to it). Right now my options consist of creating an assisted install file and walking around to all 100 machines to manually install the software and updates. I then have to remove FMP 10. I'm hoping that someone knows how I can do this from the server so I can save myself a boatload of time. We haven't had any luck in the past with silent installs or updates because we install to the D drive. We used to be able to change the inst…

I'm having a curious problem of not being able to connect my FMP 11 client (running on Windows Vista) to a FMS 11 installation (running on Windows 2003). 1.) I am able to connect to the server admin console via http://localhost:16000/admin_console_webstart.jnlp so I know the server is up and running and I can reach it. 2.) When I start my FMP client, I select Open Remote and try to connect to the sample database via fmnet:/localhost/FMServer_Sample but cannot connect. 3.) My colleages that are using Windows XP do not have a problem opening the sample database from FMP 11 on their machines. 4.) The correct ports are open on the server (specifically 500…

Good afternoon, Having developed a Filemaker solution as a single user, I now need to collaborate with a colleague over the internet. Is Filemaker server the best way to share a database, maintain synchronicity and avoid problems with two people editing the same data at the same time? Do i need to have Filemaker hosting or can i run the server on a cable connection (if indeed Filemaker Server is the way to go) I considered switching to MySQL, but i already have the database in Filemaker and I would by slightly concerned about the security aspect as the data must be kept private. Thanks in advance for your replies...

I am installing FM Server Advanced 11 on a new Apple Server. Does anyone know how to set the ports on FM server to something other than 80? Port 80 is reserved for http website. Thanks a bunch! Randy

I can't get Site Assistant to login to a Windows-based FMS 9.0v3 database. I'm running Site Assistant from a Mac with OS 10.5.4. My database requires authentication, direct login works fine, and has fmphp enabled. The Test PHP database screen works and connecting to it using PHP Site Assistant works. In PHP Site Assistant I can connect to the server. I see all active databases. When I try to select and authenticate the desired database, I always get "Invalid user name or password." It doesn't matter whether I select "Prompt user..." or "Store database account..." The admin login is managed by FMS directly, user accounts are externally authenticated. I've tried…

I've written an application which uses JDBC to connect to a FMP database. It works fine on my test system (shared via JDBC in FMP9 on Windows), but I can't get it to connect to the live database, which is running in FMP9 Advanced Server on MacOS X. Closer investigation (with netstat) indicates that the FMP server is not listening on port 2399 for incoming connections. I have read as much of the documentation as I can find, and consequently have: Enabled plugins in the server Enabled ODBC/JDBC in the database Added the the xDBC permissions to all users defined in the database Reuploaded the database to the server Restarted the server None of t…

I am wondering has anyone else had the same issue that we are having with FM 11 odbc. On the FM server, every so many days we find an error of fmxdbc_listerner.exe has stopped in the event logs. We have a hugh number of processes that are using odbc but once this error happens everything fails. The error is not logged in the filemaker logs and filemaker support has not provided any help with this issue as well. If anyone has any information, please provide the knowledge. Thanks in advance.

Hi all, gonna ask a silly question: once I upload my database file in FM Server Advanced, how can I retrieve the file to my local disk again? Where is it stored in the server? I need to get the most current database file.. Thanks!

Download file http://www.kitchenappliancesforum.co.uk/RDO.zip open it up and you will see a field to search on. when performing the search on FM Client it works and returns one record if you host the file however you get no result!

Hi Everyone, I currently have FM10 Server advanced on a windows server. It is VERY unreliable and has to be restarted frequently. We are going to upgrade to FM11 Server advanced and we are also purchasing a new server. My question is which operating system is superior, OS X or Windows? I'm not asking which is better for everyday things and do not wish to start a war, just wondering which one will provide a more stable FM environment. My other question is, can I also run FM11 Pro on the same machine? I would host it via FM server and access it from FM pro via the assigned IP address so it would not be an attempt to open the same file directly from both the s…

I'm trying to connect via JDBC to a database hosted on filemaker server 11 advanced. I'm trying to connect with SQuirrel client and with a simpla java class (as exemplified by the odbc/jdbc guide that came with fmsa 11). In both cases the connection just hangs. There are no errors returned, no time outs happen, nothing. Please let me know if you have any suggestions or if you were able to connect to a file via JDBC using serve 11 and the new drivers from FileMaker.. Notes: - yes, jdbc is turned on - yes, jdbc access is enabled on the account - yes, I was able to connect via jdbc using datadirect sequelink drivers on fms 10 but not 11. - i t…

I would like to create an administrative group with the main goal of monitoring client statistics. I do not want this group to perform actions on the server or database file. I have only been successful at showing server statistics to a group with such limited privileges. Is this possible?

Hi there, not sure where I should post this question - but here goes: When accessing a hosted version of the DB - does Filemaker write or store ANY data to the local disk ? I am thinking specifically about temp files etc. Any help greatly appreciated. Glorifindal

Are there any bad implications for hosting on FMP Server 9 a solution built in version 11? The users would have FMP 11 client software on their desktop computers to access the file. For instance, I'm pretty sure things like the Mutlti-field quick-find feature would work okay in this circumstance, yes? Any other "issues" I need to consider when designing this soultion?

Hi There, I set up a FM server 10 recently and has been working for the last couple of months. After rebooting the server this morning, all database files are running okay but the server admin is not starting. I don't recall I needed to do anything to start server admin in the first place. But when I start it this time, it keeps "connecting...." but never complete. I looked at each tab from admin start and tried changing some configurations, that didn't make it work. I don't seem to find a log somewhere to tell what could be wrong. What could be the problem? What can I do to get it running again? I really appreciate any help from this community. -Sal

HI, I was wondering if anyone can enlighten me on the best setup for using FM server with an overseas office. Currently when I have users connect in the USA to the databases the speed is very acceptable. However as soon I go over the the pond, may it be Atlantic or Pacific it comes to a screeching halt. It is no longer usable. Can any of you tell me what would resolve this. -Go to a company that hosts FM databases, assuming that those connections are faster? -Better servers internally? We will be on a mixed platform, with overseas on Windows and USA on MAC. I appreciate the help, thanks.

I'm sure I'm missing something here but when I launch the Site Assistant it loads up fine and when I check to create a new site it displays the server address, but when I go to connect it says the server isn't found. Our IT guy is no longer here so I've had the "priveledge" of taking on all the server work myself and I'm a total newbie... I have no problem opening up the DB through the client and our IWP works perfect. All the privileges and boxes are checked to allow PHP. I need help and the documentation so far is terrible...

Sorry if this is already known, but I couldn't find this information anywhere and stumbled upon it. FileMaker's KB says this: Importing/exporting directly to and from another FileMaker Pro file is not supported via a FileMaker Server scheduled script. However; I found that if you have a .fp7 file in the documents folder and attempt to import from it, the error that came back was 212 (Invalid user account and/or password; please try again). Even though I had matching account credentials in the files with full access, as well as running the scheduled script with the same full access account. What did work was when I modified the data source file (in the docum…

I just want to get verification that it is not possible to use a custom function in a script parameter from a schedule on FM server. Is that correct? I tested this on localhost and it appears that the custom function is not working. I'm using the custom functions to pass parameters from Six Fried Rice. Thanks.

I would like to have my database in a way that the website(s) will be dynamic (able to open multiple windows to compare and edit) I have done some research and seems like IWP (instant web publishing) cannot get what I want, so I wonder if CWP is the only way. I don't have any experience with CWP, and wonder if there is any othe way here... If I can install FM Pro copies in all of my users' PCs, can I somehow share my database in a way that all clients can access and use it? Please advice. Thank you very much! :

I am running Server 11 advanced and I am trying to set up a page with IWP and when I start the set up, it looks fine. Asks for the site name and then the IP to connect. I am working right on the machine and it shows the local IP in the box. But it won't connect to get the list of hosted databases. I have put in 127.0.0.1, I have put in the domain name I have even put in a forwarding port. And nothing. It says it can't connect. I checked the IWP setting in the server and it is on. I also checked that the database I want has PHP and IWP setting on and it shows that they are on in the list of databases. I am at a loss on what to do.

Hi We have a solution which contains various global fields used to store preference data. However as the solution is hosted with FM Server a client who access the solution is unable to edit these fields. Only the host is able to do this. This is a real pain as in order to make a change to a global field in the preferences area of the sloution you have to close down FM server, re-launch the solution with FM pro, make the changes, quit FM pro and then restart FM server. Does any one know of a trick or work around that will allow a client to force a change to a global filed?

Hi, I have built a database in FMPro 9 on Windows Vista. I have delivered it to the users who have put it on FM Server 11. In the month it took me to build the database I didn't get a single crash and they tell me they are getting three crashes a day. I asked them to send me the error logs which they have done. The logs are attached to this post. Can anyone help we interpret these and do they give any indication of why the crashes are occuring? Thanks Tom fmpcrash1_20100712.txt fmpcrash2_20100712.txt fmpcrash3_20100712.txt

Hi, I'm wondering which way to publish my FM database. I need to test if all my scrips developed in my client side would work in the web-based interface. I tried IWP (instant web publishing) but seemed like some functions did not work. I have a button in one layout which would trigger another window (layout) to open, but it is not doing it via IWP. I heard there are servers and CWP options too. Which one should I try? BTW, I'm not working on the server PC. Our office did purchase FMPro Server which comes with the Server Console. Do I need to use that? since it includes the PHP web assistant function which I guess might help with opening multiple windows. I'm ju…

I am having a very odd problem. It started when I rebooted our filemaker server. Once it rebooted, no one could log into any databases. I opened the admin console and got the error message "Could not start database server" When I clicked on the server start icon, it got an hourglass then back to cursor after a minute but it did not start - got same message when I click any of the links on the left - such as databases. I figured... well... lets manually stop and restart - so I cycled the service manually. Still no luck. At this point I figured, well, I wanted to upgrade to version 11 anyways.. so I uninstalled filemaker server 10, including …

Hi, I'm trying to auto update some plugins using FMPA11-XP and FMS11-Win2k3. It doesn't work. I tried multiple script examples without any success. There is no error when running the script. I executed the same script from my FMPA11-Win7 machine and it works. The plugins are in the c:usersmyNameAppDataLocalFilemakerExtensions. Here are the setup : FMPA11 on Win7 : It works FMPA11 on XP : Doesn't work FMS on Windows 2003 : Plugins are set to autoupdate.

I have a stand alone db that runs on a computer and periodically needs to sync up with FMS I can not guarantee that the network is available though. So I figure to test to see if its running and if so, do an import. What is the most elegant way to test if FMS is available? (this is similar to the heartbeat thread but I need to test from a FMP DB Charles

I have a shell script for closing files and shutting down FM Server that's called by the UPC when the power goes off. All works well except I can't seem to figure out how to suppress the prompt that occurs, asking me if I really want to close the files. In order for the script to continue a person must click Yes, but I certainly can't count on someone being present to click on that button when a power outage occurs. Any suggestions? Running FMSA 11 on Snow Leopard. Thanks in advance! -Kent

I'm not sure where to put this question so I thought I would start here. I have a database that is hosted on the web by a remote server in California ( I am in Washington state). The server has been having some up-time issues so I am contemplating replacing the remote server with a local area network. Are there any performance issues (positive or negative) that I should expect as a result of switching to a LAN? What would be the observable differences between the various approaches to communicate from one computer to another. If this LAN is successful I anticipate that I would have up to five linked computers. Can anybody point me to a discussion of t…

I am running windows 2003- Can I have more than one website that uses PHP to connect to a more than one FM dabase- one data base for each site. Does FM server using PHP only run on the Default website?. I tried creating a new site and using "host headers" in the IIS-cannot seem to connect to the data base unless the database folder is selected in the default site in "home directory" Any ideas would be appreciated- I have been searching all over for documentation and have not been able to find any.

Just wondering if anyone can help me. I have a script which will open the 3 databases in the server. The interesting thing is, 2 of these databases can be open without any problem but for the remaining 1, the following message will appear(see attachment). However, this database is definitely uploaded in the server and it can be open when listed there when I choose to open it using 'Open Remote'. The database can actually be seen open partially in the background when the error message pops up. This seems to be a very simple problem but somehow I just can't find the root of the problem.

I'm running FileMaker Server Advanced 11 and connecting to it from FMP 11 clients. A few days ago something very strange started happening. I can't seem to get into Define Fields (manage -> database) from Mac clients but I can from Windows clients. Here's what's been going on... We've had FMSA running on Windows Server 2003 for some time now. We had upgraded it to 11 when it came out and weren't having any issues other than sometimes it just seemed pretty slow. Well, here lately my client has been complaining that he can't into Manage -> Database on some of his files. I was able to confirm this at his location and I also cannot get into that area on…

Going from FMS 5 to FMS 11. I want to back up all the databases on Monday to a folder called "Monday", on Tuesday to a folder called "Tuesday", Wednesday to a folder called "Wednesday" etc. On FMS 5 I just navigated and selected the destination folder. When I put 7 folders ("Monday", "Tuesday", etc) in the "Backups" folder already designated by FMS and validate the path it tells me that it is an invalid path. How can I direct the target folder for a backup other than just the one called "Backup" set by FMS? Greatly appreciate a point in the right direction.

We recently upgraded from Server 9 to Server 10, and during the installation I discovered a previous installation of FMS 5.5 still running (but not hosting any dbs). I tried to uninstall 5.5, but discovered that I need the installation disk to do the uninstall. Unfortunately, I discarded the 5.5 isntaller CD some time ago (we haven't run 5.5 in a few years). In the meantime, I just disabled the 5.5 service, but it would probably be nice to be able to just uninstall it. Are there any uninstallation workarounds that all you to uninstall without the install CD?

Hello, I am just upgrading our server from version 8 to 11. I did not know until now that backups were now each in their own folder. I understand the upside of allowing multiple backups and preventing them being overwritten. Having a fixed location was a plus in this situation: we need a duplicate of the database at a remote location - the data is replaced every night and using "day-old" data is not an issue and performance is better than using the network. So the script used by the remote machine was "pulling" a backup of the database from the same location every night. Now, with a new name every night, it no longer works... We can't do a file copy of the …

I'm currently running FileMaker Server Advanced 11 on Windows Server 2003. We're trying to move to an X-Server. I've got OS X 10.5 installed and FileMaker 11 Server Advanced along with it. All of that went smoothly. I then closed down all of the files on the Windows server and proceeded to copy them over the network to my new server. They show up in my new FM admin as expected, but when I try and open them nothing happens. Nothing. No disk activity. The status doesn't change. No spinning wheel. Nothing. I try open all, nothing. I try to open 1 at a time. Nothing. The sample file opens and closes just fine. Just not the ones I copied over. Any inf…

so if you join FM technet for $99 you get a free version of FMS9, sounds too good to be true- it kinda is. It works like a full version, but is limited to 5 FM client connections at a time. So for deployment, do I have to pay the full price, or just an upgrade license with my technet license key ? Has anyone had experience with this?

Hello, We are a small company currently running an FM database, with just one user. We want to be able to have more users at times, as many as 5 - 7. We are thinking of setting up a dedicated Mac Mini to host the file, but I'm not sure if we should be using FM Server or Peer-to-Peer. The Peer to Peer sharing speed has drastically improved in the recent versions of FM, so that isn't a hinderance now. The main reason for us having FM Server would be the automatic backups, but I'm wondering if I couldn't just use Peer to Peer, and setup a timed script on the host that would Save A Copy every night. I could even have another script run before the backup script that…

New in FileMaker® Server 11 and FileMaker® Server 11 Advanced is that the FMS Helper Service/Daemon monitors the heartbeat of the Admin Server and thus of the Console. If it goes deaf, the Helper Daemon/ Service will attempt a restart. Hopefully this will help address some of the issues reported with unresponsive Consoles. Steven

When I setup the server I bypassed the option to save an icon on my desktop. Now I'd like to do that. Is there a way to do it after I bypassed that option? In lieu of that, I've saved console in the dock, when I quit Admin Console the icon changes to rectangular gray square with "exec" in corner. When I launch it from dock, Terminal opens instead of Admin Console. Any ideas? Thanks in advance.

HI, I have a development server running on a Mac Mini. Currently the ram reserved for database cache is set to the default of 64 Mbytes. The server indicates that this values can go up to 800 mbytes on the system. What is the recommended setting for this? What are the advantages to increasing the value? Are there any negatives side effects to setting this to a higher value? If so what are they? Thanks very much. Bruce Herbach

Hey all, I have a fMS script scheduled and in that script it has an import script step. The import is pulling data from another hosted filemaker file. But when the script runs it does not import the records. I do a find the database that I want the data from. Then go to the table that I want the data to end up. Set Error Capture[On] Go To Layout ["Default Main" (Default)] Enter Find Mode[] Insert Text [select; Default::Next Date; "<="] Insert Current Date[Default::Next Date] Perform Find[] If [Get(FoundCount) > 0] Go To Layout ["MainRecords Main" (MainRecords)] Import Records [No Dialog; "Maintenance"; Add; Windows ANSI] Go…

I noted an anomalous behavior this morning, where the Server admin console reports that the server is not running when it is, in fact, running. I know the server is running because I can open files hosted by the server in Filemaker Pro. When I first launch the admin console, it takes an unusually long time to launch. But once it's launched, I can authenticate to it. When the admin console comes up, it reports under Server Overview that the ODBC/JDBC server is off, which is fine; I don't have that functionality enabled. But when I click on any of the other entries (e.g., Clients, Databases, Schedules, etc.), I get a dialog that says, "The Database Server is not a…

Hi So far, I've done developing only for desktop/client based solutions, but I'm now talking to two different departments in a college setting about upgrading their existing legacy databases and making them accessible to a wider (but not huge) audience within the walls of the college. So, I'm figuring FMP Server 11 is the way to go, and it's high time I got educated/experienced with Server. First, though some really basic questions: 1) If they are part of the same college computer network, will a single FMP Server license suffice for managing databases for both departments? Is there a maximum number of database files that server can manage? I imagine not . .…

Hey all, anyone know of others having problems with IE8 rending the webpages through IWP on server 10 advanced? I've come to the conclusion that it is DEFINITLY something with the browers as I have tried Firefox, Chrome, and even IE7 and all work fine. It seems like IE8 doesn't always want to read the HTML file Server puts out. I get everything either shifted or scrunched over to the left and nothing is centered. if anyone knows any fixes or issues to be aware of please let me know. Thanks! Bill

Hi all, I just made the first scheduled script, is there a way of aborting the script in the middle of running? Any help will be very much appreciated! Amram Chayim Eirinberg Ps I'm using FileMaker Server11

We are running FM Server on a Windows server. The remote database publishing works fine, but when we try to connect via IWP in a web browser, the browser tries to DOWNLOAD the page rather than display it. So I'll go to this address: http:///fmi/iwp And I get a dialog box saying: "You have chosen to open iwp which is a: application/x-msdownload" This happens in multiple browsers, and in multiple OS, leading me to believe that the problem is with the server. :)

I am running FM10 Server and need to be able to allow my clients, (mac and PC) to be able to store images in the same shared location. Currently, these images are stored within the FM Database. However, I really need to be able to sync the images to a website as well. So, I was thinking that I could store them in the database, as normal, and then schedule a script that exports the updated images to a shared location and then I can have another program running that will keep the image location synchronized with the website. However, Export Field Contents is not available server-side. Any ideas?

I'm running a server using FMS 9 and the client is running Filemaker pro 9 advanced. The solution works by starting a startup file that accesses a file on the server which then activates databases both on the client side and the server. These interconnections happen multiple times throughout the solution. My current problem is that I can't get the databases server side to connect to the client databases without hard coding the path to said folder, e.g. when I ask the database on the server to use the relative datapath (file:.fp7) in External Data Sources it simply searches for said file in the server's folders. For now I've managed to fix the problem on Windows by si…

I am running FMS 10 with generally less than a dozen Clients connected, each running FMP 9, 10, or 11; and all running Mac OS X v.10.x (except one on Windows XP). Each Client usually has 18 databases open - 5 for regular use and 13 as hidden lookup files. This setup has slowly evolved over several years, so there is obviously some collateral code lingering around that is either untouched or slows things down unnecessarily. That said, my issue is with most of my Clients showing up in the FMS Administration screen twice - once with all the open databases listed, and once with duplicates of a few of those databases. Which databases are duplicated appears to be related t…

I am thinking about buying server hardware dedicated to our FM11A server. Any suggestions. We have about 40 simultaneous client connections and plan to have 100+ web connections, not all simultaneously or even for very long. Currently the Server is on a Win 2k3 server that is also handling DHCP, FTP, and Print Services. I thought I read somewhere to not have such services running at the same time with FM server. I would like to know everyone else's setup: OS, additional services run, etc. This server will only host the FM Server and will connect to a separate Web Server. I have heard of FM Server hosting online, but I am not too familiar with i…

Okay, there are several things I need help with. 1) On Mac OS X 10.5, Under sharing I'm not seeing ODBC/JDBC. How to get this option to show up in the menu? Note: I have the same FM Pro 7, installed on windows XP, and it's showing up, just not on Mac. 2) I've written a Java Application to try and connect to the FM Pro 7 database on my windows version. I have already turn on ODBC/JDBC sharing, to all users, and added the ODBC/JDBC privilege to the users, the fm pro file is also opened within FM Pro. This is the error I get from my application: java.sql.SQLException: [DataDirect][sequeLink JDBC Driver][sequeLink Server]Unable to retrieve error message from b…

We are hosting a database with filemaker server, and then four office computers with client access the database by choosing Remote. When our Internet service is down, the database does not show up in the window for selection. However, you can still access the database by opening FIleMaker and selecting Open Recent file. Is there some reason it is not showing up when the Internet is out?

I just assumed responsibility of a number of FileMaker databases from a developer who left our company. I have very little FileMaker experience so please forgive my ignorance. Our server support folks indicated that they have to manully start FileMaker on the server everytime the server is rebooted (i.e. log on to the server and restart FileMaker). It is possible to have FileMaker start 'automatically' when the server comes up (maybe through a script)? All of our FileMaker databases are served up via the web. Thanks!

Hi, I have FM database solution, accessed by a number of Win XP pcs running FM pro 8.5, and a Win Server 2003 running FM 8.5 server. I need to get three more FM Pro licences (as 3 more Win XP PCs need to access the database). Since I cannot purchase FM Pro 8.5 any more, I assume my only option is to purchase FM Pro 11. But I am concerned that those PCs running FM Pro 11, will not be able to open and use the FM 8.5 databases. Does any one know if this is possible, and will all the features of 8.5 work in 11? Or, is my safest option to upgrade the server and current PCs to all ver 11? Thanks

Good day Can someone point me to or tell me the behaivior of scripts that are running server side and get interrupted by another server side script. I am predebugging an automated email server send script and if the previous one is not complete ... Cheers Charles Delfs

Hi. I am looking to work around a problem that I am having with FMS/IIS and Apache. Now I know that one is not supposed to run anything else alongside FMS, but the problem is IIS it would seem. In my case, I have Apache hosting a few small websites on port 80. IIS also wants port 80. So I would like to achieve either of the following: 1. Either have FMS be able to use Apache for the IWP function (most ideal arrangement as I'm not keen on IIS really anyway) on port 80, or 2. Work out how I can use another port number under IIS for FMS. Problem with this though is that I am hosting several domains and websites and issue is that IIS doesnt do this well, if a…

Hi we want to put in place a Filemaker Server for an office with 10-15 simlutaneous users, clients are Win XP (80%) and Mac OSX Tiger (20%). Question. We are tilting to getting a Mac Pro also due to security reasons. Whats better? A Mac Pro or an equivalent Windoze machine? Perhaps a Server 2003/2008? We would like a cost effective solution with raw speed. Any Tipps what would be best? Thanks

Was hoping for some help. I'm sure this is a checkbox somewhere, but I'm completely missing it. I have a webpub database that people are accessing. They have no problem logging in and seeing what I want them to see. Everything seems to be working. However, when I try and launch my FMPA11 local copy and access the file, it says that the license key is in use and my local copy closes. Any ideas on what might be causing this? I don't have anything shared to my IP via the sharing tab.

I VNC in to a remote machine to administer their FMS9 machine on OSX 10.5.8. Clients can use the served databases just fine. The console loads fine. I can choose any of the Configuration settings just fine. But as soon as I select any sub heading under the Administration heading, I get an error: Admin Server Connection Error Unknown error has occurred And the console quits. Any recommendations?

I'm running FMPro 10 v.3 under Win7 virtualized via VMWare Fusion on OS X 10.6.3. From Filemaker Pro, I can see other computers hosting databases (both Filemaker Pro clients hosting shared files and FMServer hosting files), but I can't actually see the files being hosted. I've turned off the Windows firewall, set Fusion networking to Bridge Mode rather than NAT mode, etc. I can ping to the server that's running FMServer and can see the directories in which the hosted files are residing, so it's not a connectivity issue. I'm trying to think of anything else that could be interfering with my ability to connect to those hosted files, but I'm drawing a blank. Is FMPro ju…

Our computer tech purchased a Tropaz for electronic signature on reports that would be sent via internet. There is a problem with how to get it running in an 8.5 version of filemakerpro. He is not familiar with filemaker, but I am. I understand that there is a plug-in and has to be a script. Since I am self taught I'm not sure of the way to put this in the document. If a container filed or a ole field. If there is a script involved how would it be worded.

So I run several databases, they're hosted by FileMaker Server 11. The clients are a mix of FileMaker 8.5, 9, and 10 Pro. One of the DBs I connect to via ODBC from 2 different PCs. This worked perfectly until I switched servers. The original server was a Mac Pro running 10.5 Server, it decided to have a massive spectacular hardware failure today, so I installed FMS11 on another server machine, this one a Mac Mini running 10.6 server. This has worked fine for everything else. Everyone is connecting to the other databases via FM protocol no problem. However, ODBC doesn't work. The server console shows that the file is shared via ODBC, it is readable and writeable …

Our Mac Xserve hosts our FileMaker pro 9 Server Databases. The Server was rebooted after an error message stating "the startup disk memory was full." After rebooting the FMS window opens with "Searching for FMS 9 Updates," but it never stops searching. The progress bar immediately moved to the 100% mark and begins flashing. The FMS dows not start and the databases are not available from the client workstations. I need to know what is wrong and how to fix it. Thanks, Jim

I had to reinstall FMA9 this morning because after migrating from an old MacBook Pro to a new one FMA9 kept complaining about a missing spelling dictionary. Easy enough. But now this copy of FMA9 will not see my hosted database in the Open Remote dialog. I know the database is still being hosted, another client computer is still connected and accessing data. How do I troubleshoot this? Thank you.