FileMaker Server v7 - v11

Hi everyone, My boss and I have been discussing the future of our FileMaker databases, and whether it would be worthwhile to upgrade. First, a little background. We are running FileMaker Server 5.5 on a machine running OS X 10.2.8. It interfaces with our web server, which is running WebSTAR on a 10.2.8 machine, via Lasso Pro 5. This, as I am sure you know, involves using a "web companion" machine running FileMaker Pro 5.5. This is on a machine running Windows XP. While this does work, the technology is very out of date, and the web companion is prone to problems, with FMP hanging up on a semi-regular basis. Plus, the hardware these machines are on is all o…

What is the trick for getting the plug-ins to load? I installed them...changed the permissions...and rebooted the server. I can see them in the list in the Admin Utility but I can not select the checkbox to load them.

Is it possible to change the language with a Script? - Here my Idea: I have different Addresses from many different Countries, if I write for example to a German person I like to have the German Spellchecker, if I write to a english Person the Spellchecker can should switch by the Language Field in the Address. Do you think that will by possible?? How can I try to resolve this Problem?? Thanks Matthias Wuttke

I am working on a DB that will be accessed via web browsers. The database is served from FileMaker Server Advanced. I'd like the server to send an email when the user is done, is this possible? It seems to me it isn't, but I'm hoping I'm wrong. I know the Send Mail step isn't web-compatible.

Hi all, Just wondering if anyone has come across the problem where they can no longer get into the Server Administration Tool? When clicking on the big icon, and clicking on Connect (on localhost), it says Login Failed. It was fine previously, but was moved to a different location (physically), and now we continuously get this error. Any ideas please? Thanks, Diane.

I have a script that finds certain records based on 2 criteria. The file is working well but recently something wierd has happened. When I use the find script on my computer it works, but when it's used on other computers it does not recognize one of the criteria. So why would it work right on my machine but not on the others. The file is housed on a server. Thanks

I am pretty sure that I can open .fp7 files hosted by FM Server 7 with the v8 client. Can anyone please verify? Thanks!

Has anyone heard/used the online version of an application called CAQH? It's a general medical application that many different health plans use to submit doctors' info to/from. The paper application alone is 43 pages, and I've been able to 'map' the questions using a large FM database. Now I'm moving to the online version of this. They use XML as the core technology, which I have a fair understanding of. With such a huge project ahead of me, I wanted to see if anyone else has used this and has had any success with it. I might be able to shed some time if anyone else has experience with this, and can spare a moment or two. Thanks!

Has anyone encountered a problem with the "FileMaker Publishing Engine (CWPE & CONFIG)" service refusing to remain running? This is an FM8 Advanced installation. The service generates this event log error and quickly terminates within a few seconds of starting up. The Java Virtual Machine has exited with a code of 1, the service is being stopped. I'm unable to edit the configuration of the web engine via the web interface but the rest of the web engine is running fine with all IWP enabled databases showing up and serving out correctly by the server. Is there any sort of a java log kept by FM that would help diagnose this issue? Thanks

I'm using FM 5.5 Server on a Windows 2000 machine. Administering it from FileMaker 5.5 client (win2k)using the Admin plugin. When in the Remote Admin tool window, go to Open File and select FM db and get the error message, "Error occurred; unable to open file." Important to note: I can close the file using the Remote Admin tool, I just can't open it when I'm done with it. Sharing is on in the selected db. Permissions appear to be a go-go on the server. I can open the FM db on the server using client software but get an error message that a network issue is preventing sharing. However. If I start the FileMaker Server using Services, all FM files within…

I am looking for information on an error that I am unable to solve. We have a set-up with seven servers on Windows NT 4, Filemaker Server 5.5. Client has Filemaker Pro 6. In one of our databases (a VERY simple form database for filling out details for our shipping departments), we have one single user who keeps having problems with Filemaker crashing. I have looked at the database time and time again. I have looked at the errors in the server log, but nothing surfaces. I have checked that the data entry, which sometimes is done via longish pop-up lists, is the culprit, but it is not. I have had the machine checked of this user, but to no avail. I also had all sw…

Howdy y'all: I'm trying to build a contact database in FM7 using the provided template that I have customized. It's going great except I want to be able to include links (like a shortcut or hyperlink type thing) to files on the server that relate to the contact currently displayed. For example, Joe's Donuts has a logo, a brochure, and a business card all produced by us and I'd like to have a link(s) or button(s) that the users can add to the contact that 'points' to those specific files or even just Joe's Donuts' folder on the server, or just shows the file(s) in a finder window. Any ideas and or help is greatly appreciated. All the client machines are ru…

We've got Server Advanced 7.3 running on an X-Serve for several months now; which we use to serve to clients, and then pull to a secondary web server using XML/XSLT and the FX.php plugin. Within the last couple of weeks (the minute I took off for a week's vacation, natch), we've lost our Web Publishing engine for what appears to be no good reason. Clients still have perfect connectivity, no problems; but the XML/XSLT publishing goes poof on the server--this means that automated imports and updates using XML to the server don't run, etc. I've tried re-starting server admin, no luck. I go to the FM SA Web Publishing admin console (http://fmserveripaddress:16…

FM8 Server - I am trying to create a schedule to backup all files every 10 minutes but it is only backing up once per day. I tried daily repeating schedules and also weekly. What am I doing wrong here?

I share a central db with FM Server 5.5. There are users who cannot access this server once they are located outside our company network. Therefore, I have forseen a local clone of the central db, which is a personal tool for each user. Once they are located off the company network, they open their clone so they can log new records. When they return to the company, they do an UPLOAD of these new records towards the central db. My question: How do I make a secure UPLOAD script? Now I do this: the user opens his local copy, and executes this UPLOAD script from there. What is it: it is an external script from the central db that executes an import of the record…

I did it again, but to a different file. Somehow the web publishing admin console has changed its login info on me. How does one reset this? I was able to reset the FMS admin console in the registry.

In FMS7 (or 8), when a client loses its network connection with a served database open (message: "Communication with the host was interrupted and could not be re-established. All affected windows will be closed."), is the database considered protected from corruption? Ken

Hello all, I am running FM 5.5 Unlimited on a Windows 2000 PC. On the client side they are using 5.5 pro with windows XP. I have created FM shortcuts to different databases that are on the server, via a script. When they launch the shortcut it can take up to 5mins or longer to open up the database. I found a tech note way back when that said to delete my temp files and that worked but it is only a temp solution. Anyone have this issue or a solution? Thanks, Jaser

Background: We have FileMaker Web Publishing (WPC & CWPE/CONFIG) installed on MS Server 2003. We purchased it about 2 weeks ago, so I assume we have the latest & greatest. I have one problem & one quirk. The problem comes with some Drop Down Lists. We use a series of 5 Drop Downs, with each Drop Down attached to a Relationship. (Year, Make, Model, Series, Body Style). Works good in the normal Client/Server setup. In the Web version, each time we make a Selection on one of the Drop Downs, the Web Page makes us hit a Submit Button. I have checked the Layout, and it saves the data directly (as one would expect, since it works with the FM Clie…

I have been debating scraping 13 yrs worth of FM use b/c of the limitations of Filemaker. Is it true that even using CWP (fx.php for example) that server advanced will still only allow 100 simultaneous users? Can someone explain exactly what that means? Is it what it sounds like..that 100 users can access your server advanced hosted web site at once? If so that seems extremely limited! If so, I wonder why anyone would still be using Filemaker as a backend to deploy web based systems? If you have to use middleware such as php anyway, why not then just use mysql instead as the backed? Thanks in advance for any feedback. It is a very important issue that I am face …

Hello all: I've been asked by a client to explore encryption possibilities for a FileMaker 5/6 system, running FileMaker Server 5. The only thing I've found is Troi's old Coding plug-in. While it does indeed encrypt and decrypt fields, it's going to be a bit clunky to use on an existing 3000 field database. Does anyone know of any other options out there? Due to OS limitations, the client is stuck for the forseeable future with FMP 5/6. Thanks, Stanley

I've installed FMS8 + WPE on an xserve (10.3.9) All goes OK until I try to configure the WPE via the web console. (I'm using a secure/https server) No matter what I try, I keep getting a message... "The web server and Administration Console server must be restarted before continuing to configure the Publishing Engine." Yes I've restarted the processes and the machine a few times to no avail. Also tried uninstalling and reinstalling from scratch. I tried an install on OSX 10.3.9 client and I do get past this point. Any help or pointers to try out would be extremely gratefully accepted. Ta

We have small set up, a Mac g4 running FM7 server and 4 users. I periodically lose contact with the server from my g5 Imac, have to reconnect with Open Remote. Is this because the server is sleeping; do I need to change settings? 10.4.6

Does hosting an IWP database on Server 8 have any benefits aside from increasing the number of concurrent users?

Have recently installed FM Server 8 Advanced, with the Web Publishing engine on the same machine, a G5 running OS X 10.4.6. The web server works, and I can execute an XML query like this: http://localhost/fmi/xml/fmresultset.xml?-db=approves&-lay=DigitalAdvertisers&-findany This returns one record, which I expected, but it is not formatted in any way, which I also expected. I understand that I have to route the results through an XSLT stylesheet to get pretty formatting of the results, so I modified my query like this: http://localhost/fmi/xsl/adresults.xsl?-grammar=fmresultset&-db=approves&-lay=DigitalAdvertisers&-findany This…

Hi, I'm trying to get FM Server 5.5 to run on Debian 3.1 (the latest). At work I have it working on RedHat and Fedora and I got it installed on Debian (using alien to convert the rpm to a deb package) but then I don't succeed in getting it registered or even started. The error message is known to me as it's the same that you get when trying to run it as-is on RedHat > 7.2: fmserverd: relocation error: fmserverd: symbol __on_exit, version GLIBC_2.0 not defined in file libc.so.6 with link time reference The thing is that I don't know how to solve this issue on Debian ... anyone got a clue how to do that? Thanks, Bernd

Does anyone have any details on the client server interactions of making database schema changes? The reason I ask is because, while developing a solution file on my laptop using wifi, the wifi has on two occasions dropped out in the middle of processing a schema change. This means the file becomes totally corrupt, and I have to go back to a backup file. I would have thought that that sort of thing would have been transactional, ie the FM client sends all changes at once to the server for processing, the server checks it's a complete and valid request, then all the operations done exclusively on the server, with it just sending informational progress update…

Hi Guys, Ive got some spare time, and as a member of the FSA I received my copy of FMS Advanced Developer Edition. Ive finally decided to install it on a Windows Server 2000 machine, installation as far as I know went as it should. Ive created an identifier and passcode Web Admin Console says [not yet connected]. When I try typing in http://127.0.0.1/fmi/config I get an Page cannot be found. Both services for server and publishing engine are running. When I type in http://127.0.0.1, I get an index of all the folders in my wwwroot folder with "Apache/2.0.55 (Win32) PHP/5.1.2 Server at 127.0.0.1 Port 80" at the bottom. Anyone guide me to the config scree…

A lot of the navigation techinques within my first multiuser solution depend upon global fields. A user may go to a layout and work there for awhile before returing to the original layout (or some other layout). Where you came from is stored in a global. That's how the solution knows where to return to when the user hits the "Return" button. What if someone else uses the same global during a wait period? Or in the middle of running a script that depends on a global. If all users shared the same globals, then this would make my solution behave totally eratically! Have I totally screwed up? Jason

Hi, I have coworkers sitting at customers sites with restricted surfing possibilities, they can access port 80 only at external sites. My IWP solution for timetracking starts at port 80, but answer them on port 16080. I´ve been looking around for a setting somewhere, but cannot find any in WPE. Maby a setting in Apache? A login at: http://:80/fmi/iwp/cgi?-db=&-startsession Returns: http://:16080/fmi/iwp/cgi?-db=-loadframes If they manually change the port to 80 it works, but thats an ugly feature... Can anyone help? Best! / Matts

Is anyone using FileMaker 8 desktop software to access FMSA 7 server files? Any problems I should be aware of?

I do know it is bad to open a shared file over a network. But is it also bad to open a single user file on a network drive? I have an employee who has 15 files that she has on her desktop and uses but she wants them on the server so they are backed up with everything else. I do not want to load these 15 files on the fmserver because my # of fies is already over 100 and I do not want to host more files if they are only going to be used by 1 person every once in a while. Would it be safe to store the files on the fileServer and allow her to open them as single user? The FileServer is a Windows 2003 SBS, the FMserver is version 5.5 on a Windows 2003 Std Serv…

I am trying to determine what kind of performance I need out of my hardware given a couple of different scenarios. I am setting up a php site on a third party web server, so I don't have to worry about a complete lack of web presence if our connection is down in the office. (which I have already determined will require me to know what components they have turned on and off in php) I want this site to use data coming from a FMSA server at our location with the Server being one box and the webserver for the Web functions of FMSA being another box. As far as the servers here, which one is going to take the most heat when having the data accessed from the web? …

I am planning to start a modest database server based around FMAS. The system is likely to serve around 10 databases and never have more that around 10 concurrent users. The databases would themselves would be relatively small with definately less than 1000 entries and probably more like 200. I was planning on headless unit that would be hidden away and adminstered with VNC. Would a dual G5 powermac be overkill? Would a PowerPC mac mini be enough? Thanks for your help.

Is there any way to test for the method used by clients to access a database. In particular, I want to know if a server file was opened via http in a web browser or directly using FM Pro.

I installed FM Server 8 on a development server and FM 8 Advanced on my PC. I coverted all current databases (in FM6) to FM 8 and put them on the server. I could open all databases except one. I went to the console to open that database, but it keeps closed. I got a messages. * FileMaker cannot share a file because FM network sharing is truned off. Where do I trun on the network sharing on the server? Thanks.

Hi, I have have searched everywhere for a solution with no luck. I am a noob so this could be simple. I am using filemaker to create proofsheets for our clients. Each record has a container field that is calculated by our Market and Client ad number. These images reside on a remote server and I cannot seem to get this to work. My current calculation is: "file://192.0.1.222:Graphics:" & Market & ":ads:" & adNumber & ".eps" I recieve an unable to find file error. If I import the image manually i get the same path. I am stumped at this point. We have 10 different markets, so I am trying to avoid using the import folder option 10 …

Have ported FM6 database to FM7 as per documentation . Set users to single prior to conversion .Have placed in Databases folder( default folder in FM7 server )Restarted etc. File doesn't appear in hosts. There is obviously something that I am missing . Wandered around in Administrator .The file doesn't appear there either . Read lots of posts in various forums nothing successful.Can some one direct me to the correct information ?

I'm looking for information on what others think is the best way for a person to upload a file via the web to a container field in my fmp database. I have server 7 advanced, so IWP, XSLT, and XML are all posabilities. Any insight would be great. Thanks

I don't know if this is a coincidence, but I just installed php5 on our windows 2003 server which is running fmas8 and IIS6. Since I installed php5 and configured IIS to run it, I can't log into the FM web admin console. When I try go to that page now(http://localhost/fmi/config)I get a dialog asking me if I want to save this file called config, so its trying to download the config file instead of showing just showing the config page. Like I said, it wasn't doing this before I installed php and configured IIS, so I'm guessing I need to change a setting in IIS. Thanks for any suggestions anyone can offer.

Is it possible for a Custom Web Published database to execute a script in a database being Instant Web Published? Here is the basic scenario that I desire: 1. User types a URL into a web browser. 2. The index.html file for that URL redirects the user to CWP database. 3. The CWP database then executes a script in a database that is only being IWP'd. 4. The script in the IWP database runs and updates the browser window to display the layout that the script is told to go to. Is this scenario possible? In my preliminary tests, I can't seem to get the browser to switch from CWP to displaying the IWP layout. Thank you, Chris Scott

Hi.. I don't know whether I've missed or forgot to create wpe user and password. Now, I couldn't access web publishing engine configuration. Does anyone know how can I solve that problem. I removed the web publishing engine and filemaker server using cd and then I install the back. I thinks, I can setup wpe user and password for the initial setup page but the page didn't ask me to set the wpe user and password. Thanks.

Hi, I have a question about script speed. When I run a script from a remote location, it seems to take a heck of a lot longer to run. Is this due filemaker, the host machine hardware, the remote machine hardware, or the remote connection (T1)? Thanks

Hi everyone, Is it possible to save a copy of a hosted file from a remote location? it is greyed out from the menu. Can it be scripted? I created a test script but it didn't work. I didn't get an error message it just ran the script with the save a copy as step, using the remote desktop as the output file with the copy after the filename. it ran but no copy. Is this just not possible? Thanks in advance

I'm feeling a bit stupid for asking this but I have never had to do it. I am having a the makers of a plug-in troubleshoot my problems with their product and they have asked me to send them a clone of our file with no data/records. I have our backed up files but obviously they are full of data. The database they need to look at is tied to two others. I guess I need to send them all three. Also, how do I give full access if they have to use a password. Thanks for helping with my problem!

Hi everybody, I succesfuly login FileMaker Server Advanced Web Publishing Administration Console http:localhost/fmi/config Then I tried to login Publishing Engine Configuration: Authenticate Web Publishing Engine Access using the same identifier/passcode that I created at filemaker server. WPE Admin User: xxx WPE Admin Password: xxx But I got error "The Publishing Engine user name or password is not valid". Hmm...does anyone know where I can create that wpe username and password to login publishing engine screen. Thanks.

I have nearly searched the whole forum before making this post (as I always do and wish most people would do more). I have successfully installed and run FMServ7 & Server Advanced on about 3 WinXP machines until my most recent build (a WinXP Pentium D w/ 1 GB RAM) and not even after reinstalling 3 times and updating to Server7v4 have I been able to get the darn thing to OPEN a database. At MOST you can barely see that it flashes open for a milisecond. None of the files, not even the default or my biggest, a 25MB data file in a alternate folder will open. Is there something I could be missing? I am making the install from Back-Up CD-ROM of the Developer'…

I am starting the process of developing web components of several databases for my school. I would like to hear about other programmers' experiences to help me decide which tool I should use: Fx.php, FM-and-Php, or Custom Web Publishing. I have not started playing with any of these yet, so I don't know what specific questions to ask. Any comments and personal expericenes that you think might be helpful will be appreciated. I have played with IWP, and have decided that it is too limited for my applications and too quirky for my users. My environment is FMS8A on a Win2k3 server. There are no previous-version applications to deal with, and so I am not con…

I am attempting to use XSLT with Custom Web Publishing and continue to get the following error when attempting to connect via the web. I am using FileMaker Server 7 Advanced. "FileMaker Custom Web Publishing with XSLT - The requested stylesheet file could not be found (FILE-ER0001)" (followed by the name of the file). I have checked all of the following: 1. The stylesheet (.xsl file) has been placed in the xslt-template-files folder (inside the Web Publishing Folder; inside FileMaker Server 7 folder; on the host where Web Publishing Engine is installed) 2. The corresponding database has extended privileges added (fmxslt) and assigned to the user accou…

Hi gurus I have a pb to solve quickly: Briefly: At work, we have a Fm Server + advanced (Web publishing) The users ident is done by ldap query (Server 2003) No pbs, all works fine, from lan and WAn (Web companion) Question: Today, the fm server in set to query LDAP from domain A How can I set FM Server to query another LDAP (Domain B for exemple) Basically: is it possible to reach FM Databases from two differents domains ( A and with ident done by each domains ldap? Thx gurus Xavier

So we had a power flash during a lightning storm last week, (4 separate flashes of <1 second each over a two minute period) My filemaker server box (Dual 1.8 G5 with 10.3.9 and FMSA 7) did not go down during this time, and there were clients connected that didn't get disconnected. So I assumed (stupidly as it turns out) that everything was OK. I went out of town for the weekend, and upon return I noticed that my main db was unavailable. checking the server logs showed that the server had closed the file down after an unsuccessful backup attempt in the middle of the weekend. I have timestamped, zipped backups so I reverted to a backup from three hours before …

Has any Filemaker 8 Server user had an issue with the Filemaker Server 8 service not stopping. The service remains in a 'stopping' state. The only way to stop the service is to reboot the server. Any assistance is appreciated.

Hi all, I've just migrated a system running Server v7 to Server v8 (and then patched to 8v2). I stopped the relevant services, then used the Backup Settings Tool to save all the paths and schedules from v8 before removing Server v7. Then installed v8, and used the Restore Settings Tool to, well restore the settings! Everything is fine, except one minor detail. The default Database Path can't be changed or set (it's greyed out) and sadly is set to the old v7 path. It's not an operational issue as I have the db files under a custom path, but I can't change the default which points to a older v7 server path, and hence can't remove the final parts of the v7 f…

The FMS function LocalBigPut is causing the failure of FMS service to stop. DrWatson says: Application exception occurred: App: fmserver.exe (pid=924) When: 4/07/2006 @ 08:40:31.764 Exception number: c0000005 (access violation) In function: LocalBigPut the fault should be this: FAULT ->00408972 f6430a10 test byte ptr [ebx+0xa],0x10 ds:00819ee6=?? The system info: User Name: SYSTEM Number of Processors: 2 Processor Type: x86 Family 15 Model 2 Stepping 7 Windows 2000 Version: 5.0 Current Build: 2195 Service Pack: 4 Current Type: Multiprocessor Free It has 4gig ram, raid discs, etc. so hw …

Is it possible to run both FMS 8 and ARD on the same Apple computer so I can admin the FMS from elsewhere.

Hi guys, I have question about the protocols for the web publishing engine. I used one computer for configuration: install Filemaker Server, the web publishing engine, and all of the associated software components on the same computer. To communicate with Filemaker Server and web server, the web publishing engine uses the following protocol on the ports indicated. Protocol Filemaker Proprietary Networking --> 5003 (TCP ports) Apache Jakarta Protocol (AJP) 1.3 --> 16016, 16018(TCP ports) Tomcat Control --> 16010(TCP ports) Filemaker Internal --> 16008, 16012(TCP ports) HTTP --> 16014(TCP ports) Ports 5003 and 16008 through 1…

Does anyone have experience of installing Advanced Server and IWP on OS X Server (10.4.6) managed by Tenon iTools? The OS is a clean install with SSL, iTools, FMSA and nothing else. Tenon tell me they have customers running this combination successfully, including Apache 2, but I can't persuade it to open the web admin console with either Apache 2 or 1.3. FMServer is sharing databases with FMPro clients and the Web Publishing Engine is running, but when I try to open the console I get: https://www.:443/fmi/config Not Found The requested URL /fmi/config was not found on this server. Apache/2.0.55 (iTools 8.0.5)/Mac OS X) DAV/2 mod_fastcgi/2.4.2 mod_ssl/2.0.55 …

I have a machine that hosts the web server, Filemaker 6 Client, and on the same computer has the database files. This Filemaker 6 database is for the web and performs very slow. Question is will having a separate Filemaker server that hosts the database be better for the speed of the user accessing thru the web? -Thanks, Ainge

When I install Server 8 web Publishing everything works fine. I connect to the admin console and create a FMSA user and password. Move on to create a WPE password and user, no problem. Get to point out the FM server, and then it gets problematic. When i register my settings I get an "unexpected error" and then I'm stuck. The WPE user and password i registerd do not work so I can't get in and try something else. So I reinstalled the thing and the same thing happend again. I would be glad for any ideas or comments you can give me.

Every night during the week my server crashes regularly between 5 pm and 6 pm (ie. quitting time). On the weekend, no one is logged in and the server does not crash. On occasion, the server has quit in the middle of the day, typically a Friday. Once it has quit for the day, it will be fine until the next evening. I am not recovering files. I always pull from the latest backup. When the server crashes, I have been watching the Activity Monitor. The “fmserverd” process will go away but the other two FM process will remain. To “restart” the server, I have been replacing the crashed files with my backups and started the Admin app. The “fmserverd” will startup and wo…

Hey I think I read something about this hear but not sure. I have two mirror systems running on different servers: One in 7 and one in 8 each on their own server. The system uses xslt to publish data to the web. in 7 a page takes about 6 sec to load or less. In 8 it takes at least 30 sec. Does anyone know what the issue is between the two versions and how to fix it. Thanks Darren

Hello everyone, I have this filemaker script which needs to run in the background once a day. Since I purchased Filemaker server 8, I thought I would be able to schedule it but unfortunately I understood that Filemaker Server only runs "shell scripts". I have absolutely no idea what a shell script is and was wondering if someone could help set it up. I should probably just say: open file "TTM bookings" in Filemaker pro 8 and perform script "export all icals for all artists"... I tried to check the net for examples, but I am afraid it is like chinese for me. thank you in advance.

Does server 8 support multi-processors and/or does it support Dual core processor?

Is there an elegant way for a filemaker user to request (or force) other users to log off via script maker? I have some large batch operations during which I'd prefer for no other users to be using the file simultaneously. It'd be great if there was a script command which would force other users to log off (or at least, send them a message politely asking them to?) I don't absolutely need for this to happen, but I'd feel more comfortable knowing that only the single user is online. I know I can do this via the server console, but I'd rather have a non-super user be able to do this. Since nearly all navigation in this database is scripted, I thought of s…

I have just converted my peer to peer platform to one with Server 8 controlling the workgroup. I am now unable to get my Global fields to update. Every time I close down, they revert to the prior setting. Please advise.

I haven't pinpointed the problem but here's the circumstances. I'm running FMS8v2 on Mac OS X Server 10.4.5 w/plenty of ram and disk space. I'm serving about 60 files to 20 Mac clients running 8v2. I've recently started consolidating some of my files and I believe it's causing the problem. When consolidating I import a table into the main file, fix/add TOs, import scripts, and duplicate layouts. At some point during this process the majority of my 20 client's FMP application totally freezes requiring a 'Force Quit'. I'll have to do some more experimenting to pinpoint what's causing it and I'll report back. In the meantime I was hoping somebody might shed some li…

Open URL Script can't execute on FM7 Files published on FM Server Advance 8 using IWP. My remote PC running Win XPSP2, using IE6.0 Browser, can access the published FM File but cannot execute 'Open URL' Scripts. Using Firefox instead of IE also shows same result. However, if the FM Publishing Engine and FM Server 8 is turned off, and the same FM File is published on the same Remote Server (Win 2003) using the FM File's IWP Sharing turned on, the Open URL Script works just fine. On another PC running similar Win XP OS, does not have this problem with 'Open URL' Scripts published on FM Server 8 Advance. Question is why can't my PC execute FM 'Open URL' scripts on FM Publish…

Hi! We've just installed WPE and we could access Admin Console, but testing the config, we've restricted the access to an IP out of our IPs range, and now we can't use it. Is there any way to reset this config? Do we need to reinstall Admin Console? We can't change server's IP because we don't know the IP restricted,... Thanks

Here is my challenge: I am not sure if this question belongs here or under Windows Server or Scripting... Does anyone know how to execute a FileMaker script on FM server 8? I have read elsewhere that it can't be done, but I need to find a solution... I want to download data (from another non-FileMaker system using ODBC) on a daily basis. I have written the scripts and it all works fine, on a client (FM 8 advanced). In FileMaker server 8, what actually happens when a file gets opened and "served"? If I specify a script to execute at file opening (in File Options), it looks like the server ignores that. We had found a way to do that in FileMaker 5 s…

I've tryed to host an FMP8 file on server 7. At first glance, it seems to work even the tabs, has anyone done this, any know problems, can this be recommended? Thanx.

I was thinking of using Python for archiving backups and update routines with FMServer8. Has anyone had any experiences using the two together? It will be on OSX, but I would like it to be Windows friendly as well. -Raz

Hello - Has anyone successfully set up a FileMaker Server running on Mac OS X that uses external authentication from a Windows domain? I realize that it would be much easier to run FileMaker Server on a Windows server since we have a Windows domain, but I don't have that luxury. The boss wants all new setups to transition to Mac, so I was given a Tiger (10.4.5) server and FMS 8.0v2 (Mac) CDs to work with. I don't think our domain server will change any time in the foreeseeable future, if ever. Following the instructions in the tech brief on External Authentication, I had our domain admin create 3 user groups on the Windows domain for me: fmsadmin, fm-manager…

Note: This forum is for you to post your articles, tips, tricks & techniques. Please don't use this form for requests for "how to..." Newbie should learn how to read.... Sorry Ok. Folks.... This my first experience with IWP... have a working solution that prints and calculates fine using Server 8 on a local network. set up a brand new machine for advanced server got IWP working.. but when I go to print out some of the forms that I have built block by block they print on 6 sheets through the IE browser.... ANy thoughts on printing? I'm thinking I need to force FMP to print to a PDF and then display it... Many thanks in adv…

Hi Everyone Im using filemaker server 8 and for some reason one of the database's i've created wont open. Its status is now closed, i select 'OPEN' the status then becomes 'CHECKING' for about 5secs and then reverts back to closed again. Any idea's? Thanks

I have been using FileMaker Pro on a Mac since 1996 so I am well used to it. Since I upgraded to Version 7 I discovered that I needed a new manual. i have bought Schwartz & Cohen's "Bible" and have constructed their tutorial Address Book. When I entered my homepage in a button "Open URL" I found that it would not open any site to which I need to login. Is this usual? Also, I still cannot use Dial Phone as I used to prior to version 6. Why is that, please? Terry

I have read several posts regarding files not opening on FMS 7/8. I have a similar problem. I have been developing many solutions in FMP 7/8 Developer, hosting them on a 7 server (Win 2000 Server SP4). I just upgraded that machine to FMS 8. All but two files opened as normal. One (1.66GB) opened after I opened it in FMP and allowed it to fully open. The remaining file (1 GB) will not open, even saving compressed would not help. The event log shows that the FileMaker Server Helper cannot be started (error1003), but that was FMS7's helper, which I set to manual start. Max Files hosted =30, have 15 now.

Hi there, I have a static internal I.P OS X 10.4 server running with FMSA 7 on a clients novell network (the novel network is server standard IP protocols with win XP clients and our server does not communicate with the novel side of things at all) When I goto http://localhost/fmi/iwp on the server the web publishing works fine. If I access from a PC on the network at http://192.168.x.x/fmi/iwp again it works fine. If from our office i goto... http://81.178.x.x/fmi/iwp my browser just says connecting. I have had the customers IT department open their smoothwall firewall ports to redirect to our server... TCP Ports 5003 50006 50003 1…

When I do search over the FMNetwork it gets my list results just fine. If I do the same search over the web using IWP it doesn't grab the first record in the list.

Hello, can I still pull records from my database in FMPS7A and display them in a web page, like I used to in version 4 or is using custom web the only option? As in using [FMP-field: ] Thanks PS My version of FMP is not available from the FM Version drop down menu on this forum.

Hello! I wounder if there is anything spceial to think about when I am going to transfer my database from version 7 to version 8 Advanced server? Is there some hickups that usually happens? Are there anything special I should know about? Ragards Joakim Sjöberg Systemsengineer Johnér Images, Sweden

Looking for someone to possibly help out trying to sort through the mass amounts of server errors i am getting using Filemaker advanced 7. I called tech support and they blammed it on the Xslt. So I need to have someone look through the xslt pages and find any errors that might be causing problems with server. Here are some of the errors: [13/Mar/2006:07:35:00 -0800] FM Web Publishing: Error: 404 [13/Mar/2006:09:18:11 -0800] XSLT-CWP: An unexpected error has occurred (null) [13/Mar/2006:09:18:11 -0800] XSLT-CWP: Unexpected error [13/Mar/2006:09:33:33 -0800] XSLT-CWP: An unexpected error has occurred (null) File: /fmi/xml/fmresultset.xml [13/Ma…

I got a new server, running win2003 and FMS 8. Has of today I'm hosting 80 databases with an average of 5 users per database. The most users that I have had at the same time is about 30. I got 2gig of ram. I'm wondering how the system would perform if I had 200+ users logged at the same time. How much ram should I get more for that scenario. Is there a rule that I don't know about (like a terminal server requires 80 megs of ram per users) fo FMS8. Please don't answer has much ram as you can get!!! Fred.

I am having a heck of a time figuring this out. I can access my Filmaker Pro 6 Server from a Mac remotely and local with no problem however from a Windows copy of Filemaker remotely I have no access. My copy of FM Server is behind a firewall with the ports 5003, 50003, 50006 being forwarded to the server. Are there additional ports that need to be configured for Windows? Any help would be appreciated.

Hi, I have a simple database with some table. One of these tables is called Countries: it contains a list o almost 200 countries. Basically I just tri to order this countries by name: -sortfield.1=name&-sortorder=ascend. Yesterday it was working fine (obviously it's very very simple): List its like this: Albania Algeria Belgium [..other countries] Italy [..other countries] Vatican This morning I restarted the engine and, after this, the countries weren't sorted: Italy Germany Belgium Vatican Algeria etc.. So i decided to restart my engine and now it works fine again: no changes made to xslt file or to the query …

I examined the CPU activity when FMSA7 was running as of recent and detected that both processors are not engaged on my dual 2.0 gHz G5. No matter what the query is, only one processor shows any activity in the Apple Activity Monitor. I think FM has lied about the server capable of being dual processor.

Hello all, some days ago I added the bsf.jar and the js.jar files to my filemaker server 7 adv. v3 (running on a G5 Mac OS 10.3.5). I'm still experiencing some unexpected XPath errors some times (randomly: reloading the same page the error seems to be fixed, and this thing happen only on those page where I use the xsl:component and where I define and call some javascript 'server side' function. Any idea? PS: I followed all the FM instructions before install the jar files.

Hi, I am having a strange problem with the Server Advanced 8v2 on Mac tower. My main file never passes the consistency check. I have to turn the consistency check off to get it to start up. The log just says that the check failed. I performed a recover on the file and got the same thing. If I put a clone of the file with no data in it, it starts fine. It therefore something about the data itself that is causing it to fail. It is a large file of about 4.5 Gigabytes. Does anyone have any ideas? Scott Wright

Hi, This question is related to the topic below: http://fmforums.com/forum/showtopic.php?tid/171863/post/185201/hl/scripts+odbc/ Bear with me while I give you a little background on the project: I'm an ASP developer working with a Filemaker developer on a project to build a public website that draws a lot of data from our client's FM database. Whilst I'm pretty experienced with Access and SQL Server, I'm a complete idiot when it comes to Filemaker so the whole project has been a steep learning curve for me. The client's FM database has been migrated to a Windows Server 2003 box running FM7 Server Advanced. We're upgrading to FM8 Server Advanced in…

Hello, I have replaced an old file with a newest one (it has the same Tables, same layouts and it should contains same data but the oldest was very damaged so I needed to re-write it), it contains also numbers and I imported the data from the old to the new one. The file is hosted in a windows server machine which use the point ('.') as decimal separator but in the local machine the decimal separator is the comma (','). As I pulish this db on the web with an xml/xslt solution I need to use the point instead of the comma but, viewing the xml output, I realized that this file keep the client settings and not the server one.. how should I set up the file in o…

In the FMS8A console...everytime I try to set the database to OPEN it very quickly says CHECKING then displays CLOSED. I've checked the priviledge sets on the file itself making sure that IWP is allowed. Why can't I get this thing to open???

We are running a cross platform solution of FM 5-6. We have four Mac G4 (400mhz- 1.25Ghz) towers running OS 10.3 and FMS 5.5 and one P4 Server running WIn 2000 Server and FMS 5.5. The problem is with the Macs. While they perform adequately (albeit slow)under OSX, when we try to stop the server using FM Server Config, the dialog box says it is shutting down (and that it may take a few minutes, the server never stops. It can take half an hour or so before we must force quit. It is consistant across all of the Macs. Why is this?

On the Filemaker web site it says that FileMaker Server 8 Advanced is an enhanced version of FileMaker Server 8 that lets administrators securely manage and deploy shared FileMaker Pro 8 and 7 database files over networks, intranets, and the Internet. This leads me to believe that FMSA8 advanced includes the Server 8 software. However the installer I have for advanced only has the FMS 8 Web Publishing Engine installer. Did our boys get the wrong thing? We have Server 8 as well, should I install that first then run the WPE? Sorry if this seems elementary but I'm confused!

Hi, I've just migrated the application from 6.0 pro and updated Server 5.5 to 8.0. The database works fine, only the editing functions are not possible anymore, even when logged in with a "full access" account. Anyone have a suggestion? Thanks

Hello, I'm gettin' mad about a new (!) filemaker server 8 strange behaviour.. I jsut installed all the web engine (server v2+ WPE + advanced 8 v1 patch) in a Windows server web edition (i Know this is not the proper version of Windows server for FM 8.. but just go on.. I have a surprise for you) and it seems to work for 3 maybe 4 minutes (yeah! minutes!!).. then the CWPE process start to allocate for it self almost 100% of CPU.. you know.. the server simply becomes unusable, CWPE stop to do its 'job', and my site is unavailable. So, I checked the OS version requirements and I founded that the proper version is WS standard edition.. well, we got it too (all pat…

Dear FM Forums, One of the main reasons we want to use Instant Web Publishing is so that we can have a vendor portal. We have thousands of vendors, and we'd like to have an interface where they can login and update some of their information. What are the options for using IWP to give limited access to thousands of users, only a few of which will ever access at a given time, and none of which will ever access the FileMaker solution directly? At first glance, there would seem to be two options: make a FileMaker Account for each vendor that will access the system, or make a generic account that all vendors login with, and implement within the solution a custom set …

I have a number of databases that run across a WAN, using FileMaker Server 8 Advanced. Unfortunately for some users access can be very slow. To make it easier/faster for them to quickly look up an individual record, I would like to encourage them to access the database via IWP. On log-in, I intended to redirect them to a simpler page. But I can seem to find a function within FileMaker that allows my opening script to know if the person has logged on using their browser (or IWP), rather than as an ordinary client. I would have thought there would have been a "Get" function for this purpose. Does anyone know I can identify that the person is using IWP?

I'm using FMPro 5.5 with FMServer 5.5 in a multi-user environment. Making modifications to our application is always a pain, because I have to either make changes and do testing in realtime on the system while it's in use (dangerous, if the changes are at all complex), or I have to isolate a copy of the database files on a computer not connected to the network. I can simply copy the files to my local computer, and then disable the network connection, but the instant I re-enable the network connection, I risk having the application accidently open one of my test files (even though the active copy is already open!) I suppose there's an expensive "Developer's Edit…

Is there a way to control how many client stations can have access a record at one time? What I am trying to constrain is the ability of one client station to attempt to modify a record while another station is currently modifying a field. If this cannot be done, is it possible to somehow signal the the other stations that the active record is currently being modified? My network consists of FM Server 7 and FM 8 Advanced and FM8. Any suggestions? Jarvis

Hi All Have just set up iwp on fm server 8 advanced.. All was working fine then at some point .. when accessing database thru a explorer browser about 4 hours into running, we received an [unknown error 13]. We had to restart services and all appears to be fine now. Anyone know what an error 13 is and what causes it? Thanks Stu

Can anyone help? I have a file that I wish to share through server8. The file I wish to share will not open once I have connected the the filemaker server. I have other files that I can share, but this one will not seem to open. I right click on the the file, press open but the file just reverts back to closed. The only thing I can think of is that this file has been converted from FM6. Does anyone know any settings that would cause this not to open? Maybe something that I need to do in order for the file to be shared? I can think of nothing, all settings are the same as any other file that I am sharing. But this particular file is the only one that …