FileMaker Server v7 - v11

Hi, I am new to server and have a question similar to xochi's post about global containers. I noticed that if I close the file and then add the global container, everything works fine. My question is I am usually a remote user. I access the database from a different state. I can administer the server, but I do not have access to the hard copy of the hosted file on the server computer. Is there a way to add a global container without that access?

I need help diagnosing the following error which appears using FM 5.5 while accessing a multi-user database which resides on a server. Users open their desktop FM 5.5 (Windows XP or W2K), then do a File Open. Although this is not recommended practice (file on server, application on desktop), this is what I have with my users. Only one user gets this message: Sorry. Filemaker is unable to update the disk this file is on. Click continue to try again, or click Exit and copy this file to another disk. Anybody have any ideas? Thanks. [email protected]

I'd like to have a global container field that holds my corporate logo to use in the header on all reports. I know that when using FM Server, a Global is actually "local" to the current user, so I thought I could solve the problem with the following setup: Table "Graphics" which contains 1 record. Logo (a regular container field) gcLogo = Logo (a calculation field that is a Container with global storage) However, I can verify that gLogo is blank. Next, I tried a similar setup, but used a self-relationship in the graphics file to make sure the global calc was working: Logo (a regular container field) Constant1 = "1" gcLogo = SelfRelat…

I am setting up FMP7 Server Advanced, as an upgrade to FMP Unlimited 5, by creating a new database on my PC FMP7, and copying over to the "databases" folder on the server. When I attempt to open the remote, and select the file on the server, it brings up the "Maximum Number of Licensed Users" Error, and closes FMP7. The server has it's FMP7 Server Advanced license. I have my FMP7 ordinary license. There are no other FMP7 users on this network. What am I doing wrong. Please help!

Using FM Server 7v3, I find two very serious bugs. Can anyone else confirm? Bug #1 Make a global calculation field equal to a text constant, i.e. kgKey1 = "Work" (calculation, global storage) Add the field to a layout and verify that the field has the right value. Now, go to table definition, duplicate the field definition, and change it, i.e. kgKey2 = "Home" (calculation, global storage) Add the field to your layout. Notice that the field will not have the correct value. You must re-open the database for the global field to refresh to the correct value. Bug #2 Global calcs that reference a summary on a self-relation hangs filemaker ser…

We are building a FM solution based on FM Server Advanced. FMPro users will be uploading mass data, while web users willl retrieve it via CWP. I estimate the database will have millions or tens of millions records in a short period of time. There will be 2 or 3 FMPro users and 100s of web users. Is a Filemaker SErver a right tool for database of this size? Does anybody deployed such a huge solution? Thanx in advance Cdda

Hi all. I get an error when I try to enable database sessions for XSLT publishing. When I toggle the radio button to yes and click the apply button an error message appears at the top of the page. Fortunately, it's extremely informative. It says "An unexpected error has occurred." Is this happening to anyone else? More information: Windows 2000 Server, FileMaker Server 7 Advanced (v2 update), using port 8080 for web publishing.

I have a small office of 5 users in NY and we would like to get 3 remote users from our DC office access to our filemaker database. Does anyone have a good cheap solution for this remote access? Here is the set up: Host Computer Mac OS10 w/ Filemaker Server 7 LAN: 3 MAC OS10 users, 2 WIN XP Users Remote Office we are trying to set up: 2 MAC OS Users, 1 XP USer. Help we are not looking to break the bank just access the same filemaker database.

Hey all Just had some questions about Server 7 Advanced.. since there's no trial for it I can't just find out for myself. Just so you all know, I'm no database/computer expert, i'm just the one in charge of the computer related duties. Lemme just outline the setup we have right now.. We have 2 offices.. one has our server(5.5) with 4 clients(v6), the other has 4 clients, and 1 computer using a remote desktop kind of program to use the client that's on the server. we have a VPN set up between the 2 offices. We have a few other people who work outside our offices who use information from our database, and a 3rd office will be opening up which will need access…

I have a database that I am hosting on my company's intranet, my boss added 2 fields yesterday and now i am unable to get the database out of a closed status. The 2 other databases are running fine. I have stopped and re-started Filemaker server several times. I checked Local Filemaker server Admin. and Start all Filemaker Server processes is active. I am at a loss - am i missing something - this isn't the first time he has made changes, but its the first time we can't get the database back to a normal status. Help - and Thanks ahead of time

Does anyone know how I can set up virtual directories and have them Filemaker web publishing extensions enabled for them? For example, I want www.bob.com/fmi/config to be able to databases for bob.com but also have www.bob2.com/fmi/config to be able to configure bob2.com's databases. Any ideas? When I created a new virtual server in IIS, I'm not sure how to extended filemaker web publishing to the new virtual server.

Has anyone some information about Filemaker Server 7 clustering. I would like to use the cluster services in Windows 2003 Entreprise Edition but FMpro 7 Server is only certified for Windows 2003 Standard Edition. Thanks for your help.

Hi gang, Two related problems have sprung up for us. FM Server Advance 7, on an XServe with OS X server 10.3.8. First, we noticed that we could not reboot our server remotely, it would hang and never complete the reboot cycle. Someone from the datacentre would have to go and manually reboot. Second, when I tried to put on the v7.3 patch for the Web Publishing Engine, the updated kept saying that it could not install because the web publishing engine was running. OK, used the Server Admin program to stop the FM Server, used my web browser to administer the server, turned off web publishing. Still couldn't install the patch, web publishing engine still runni…

I'm currently hosting one DB file with FMP 7v3 on a 533MHz G4 with 512 MB RAM. This configuration has proven very stable for the past 9 months serving to 4 concurrent FMP clients, and up to 5 concurrent (~150 total) IWP users. Now I'm going to need more concurrent FMP clients, and I'll need to move to server, and since I'm using IWP heavily for remote users, I'll need server advanced. My question is: Will I be able to make use of the 533 G4 for anything with server advanced? I won't be drastically increasing my traffic compared to when I used FMP to host, but I get the impression that if you want to put both the WPE and FMS on the same machine, the 533 G4 wo…

One day I could not access the /fmi/config page on my webserver. I checked to see if the Web Publishing Engine service was running, and in fact, it was. I decided to go ahead and restart the service. Tried /fmi/config again and got nothing. At this point I decided to just go ahead and uninstall the Web Publshing Engine and reinstall. Upon uninstalling I got this error: then this error after hitting OK. Just hitting OK, I decided to reinstall the Web Publishing Engine and was then prompted with this error. After getting this error, the Web Publishing Engine does not show up in the services tab.. but it does say that its installed in Add/Remove p…

I am interested in a temporary directory for reading and writing data files on both PCs and Macs. The default path seems to be gone in FM7 so I need a absolute file path that is always availible even for hosted files...regardlest of harddisk names, permissions, etc. My ideas are: filewin:/C:/TEMP/Resultstemp.txt filemac:/MacintoshHD/Temporary Items/Resultstemp.txt filemac:/MacintoshHD/private/tmp/501/Temproary Items/Resultstemp.txt file:Resultstemp.txt filemac:/Macintosh HD/Applications/FileMaker Pro 7/Resultstemp.txt file:../../../Resultstemp.txt

Hi, I am currently hosting a FM 5 database on a networked PowerMac G4 - 450 w/ 512MB RAM that is running Fm Server 5.5. I have noticed that when I TCP/IP into the database as a guest the performance when it comes to sorting records is extremely slow. There are over 8000 records, and doing a sort of say 6000 will take about 20 minutes. You can watch it count down by 4 records every couple of seconds. Now the machines are on a Gigbit network and the NIC cards are set to 100 Full. Any ideas or reasons why this database would be crawling like that? Thanks! Ron

Hello everyone, last year I set up filemaker instant web publishing in plain old Pro 7. I was pleased with everything except for the fact that it would only display 5 records at a time (my main layout was a list view). I want web users to be able to see ALL records in their found set, not just 5 at a time. I've read through a lot of documentation on Server 7 and Server Advanced, and have not yet found a definate answer to this question. Can I still use IWP and display more than 5 records at a time through either of the forementioned programs? Do I need to use Custom Web Publishing making use of the xml/xslt functionality? I'm willing to spend the time to learn whatever I …

Here's the actual problem to our FileMaker 7. We are a small business and have 2 servers in which terminal users and/or pc users log into. Our problem is that we have a problem that shows up in each of the terminal/pc users preferences options. Here's are problem: == When we goto FileMaker 7 and load it up, and then we select the 'Edit' tab on the toolbar and select 'Preferences' after that .... and where it says 'User Name' ... most of the terminal users have it listed as 'Information Systems.' We don't want it to say 'Information Systems' and rather have it set to their last name comma first name (i.e./ Doe, John). Our soultion is that we locked one of our se…

Hello, is it possible to clear safely this file in order to delete the oldest access information? thank you.

Hi Guys, Wonder if anyone can guide me here. Im a very experienced FM developer, and over the last couple of years have developed a very complete private medical insurance calculator for a customer of mine. Without going into too much detail it basically calculates medical insurance costs for 15 different companies and allows you to compare the costs. On a 100Mbp network it takes around 25-30 seconds to do a full calculation. These arnt very complicated, basically lots of lookups that create around 200 extra records per customer running the quote. Now the problem is, over a VPN (broadband 512kb download 256k upload) this quote takes over 10 minutes, which is a d…

I am having a serious problem with a FileMaker solution I have created. The database is hosted on FMP Server 7 on a Windows 2000 Server machine. It is accessed by a mix of Windows 2000 Professional and Windows XP clients. The particular issue I'm having is with two tables. Table 1 has a primary key (pk) and has a one to many relationship with Table 2. Table 2 has records which are selected and related to records in Table 1 by populating the foreign key field (fk) with the serial number in Table 1's pk field. The problem is that I am increasingly experiencing issues where records in Table 2 are showing up in a portal as being related to Table 1, and the "go to re…

Trying to create a second backup schedule, and am getting stung here: This path is valid: filemac:/IS_Server_HD1/Users/administrator/Documents/ But this path is not: filemac:/IS_Server_HD1/Users/administrator/Documents/FMS7_Backup2 I assumed permissions (Documents is admin admin, rwx------), but setting same as Documents folder, or changing group to fmsadmin rw- makes no difference. Any advice? (my advice for filemaker, please include a bloody file browser next time, so we don't have to mess with your filemac: path formats!) Thanks for your help. Justin

I'm just setting up a FM7 server and have several image database that I have been hosting with FM 6 Unlimited. The databases were set up with referenced links to the images that were stored in a subfolder with relation to the database. When converted to 7 the images would only show up when opened directly connected to the machine, not when remote accessed or via IWP. Looking at the paths stored in the container, it showed both a relative path and a absolute path which was wrong because I had moved the files to a new machine. I removed the absolute path and pasted back just the relative one. This fixed the problem of the images showing up when opened via remote but n…

I am using Filmaker server 5.5 with FMP 6. After several sessions my dictionaries default back. I have repeatedly changed the dictionary on both the client and the server. I have stopped the server and changed the dictionaries and yet eventually they revert back. There are other preferences that default back as well like the beep on mispelled words that I have tried to turn off. What's going on here? [email protected]

How do I perform a find with multiple request on server advanced. What I want is to perform a find where a field has either a value of "X" or "Y". I tried using the -lop in my http request and I was getting no results. Below is my request: http://myserver.com/fmi/xml/fmresultset....ln002&-find I get no results for this. Hopefully someone can help me out construct the proper find request. Thanks.

I've published a database over the internet using Developer 7 - pretty easy. I also know that Server Advanced can do the same and a whole lot more. I just can't shell out $2500 for testing if I don't need it. Now the middle part. Can Server 7 publish the same way over the Internet as Developer can? I could change the port on Developer - but didn't see a clear way of publishing or port changing with Server. The 5 concurrent connections of Developer are about what we need and does work, but as I understand the license you can only use it for development/testing and not for production. If we stayed with Developer 7 for publishing, are there any draw backs of not us…

We're using FileMaker Server 5.5. I'm using the steps suggested at http://www.afp548.com/articles/system/fmpserver.html to automatically start the fmserverd services when our Xserve boots up, so that I won't have to manually hit the 'Start Server' button on the FM Server Config app. Works fine, but how can I now *gently stop the daemon* without using the Config app, and without corrupting my open databases? Thanks very much

I have a relational filemaker 6.0 file running on a windows xp computer. The problem is when I log in to the same file to share it on a remote xp (or max os X) computer. Any image that is in a container field that has just a reference to it does not display on the remote computer. If the image is actually imbedded in the file the image does show up. Now, if the file is closed on the host computer and I directly open it from the remote computer, all the images show just fine, but then you can't share the file Since I have a database with over 30,000 records and 30,000 images I don't want to store them all in the database, just the references. Is there a way to …

I am trying to determine whether I can support all of our companies needs with FM7 (server) instead of using Microsoft exchange, meeting maker or the like. So any input is appreciated. We need to track several things including, events, inventory, groups, members, assets, resources, provide room scheduling etc. We do not need Microsoft exchanges email capabilities as we are hosted externally and meeting maker is web only. I do not want to have several apps for folks to track all of this. i know many of these items are easily accomplished in FMP, but the calendar aspect escapes me. Any thoughts? Thank you!

A while ago (2004) someone posted the following message, there were a lot of responses, but no "eureka, I have it". I have exactly the same problem. I have fixed it by restarting the engine etc using the command line, and it works for a bit (an hour or so), but then it reverts again. This is not a lot of use. Does anyone know the definitive answer? "Hi everyone, I'm about to shoot myself just trying to install FileMaker Server 7 Advanced. Here's my setup: Xserve running OS X Server 10.3.5, fully updated. 2GHz G5, 2GB RAM. Services running: AFP, Apache (completely default), and FIleMaker Server 7. That's it. (FWIW, all appropriate ports o…

When testing FM server7 I try to open a database on the machine I developed the solution with the right password that should give me full access to all the files. But when launching the database on my machine I can't get in with the account/password I use all the time when developing. Shouldn't I be allowed to do so?

I know this is a very basic question, but here is the problem. I created a FileMaker relational database on my local hard drive which contains scripts. I then copied all of the files to a shared network folder. Another co-worker tried to open the database on the network using FILE, OPEN. They were able to open the database, however when they click on a button, which runs a script that opens a related file, a message is displayed stating that changes cannot be made because the file cannot be modified. So, I changed the sharing property for all files involved in this database so it can be accessed by all users. However when they try to open the database they still rec…

Hi All, I'm looking into adding a -script argument to one of my web request which is a -find. What I would like is if the -find returns no record I'd like for the -script that i call to actually create the record that was initial looked for. Currently when I do a -script with a -find that doesn't return any records, i still get the no records found error in the XML returned. Is there a way to create the record in the script that is called then return the newly created record as the found result? Thanks.

As there's no way to run both Server 5.5 and 7 on the same machine to test the new solution I run server 7 on another pc in our office. The question is - is there any potential of conflict while running server 7 and server 5.5 as all computers share the same network? As far as I understand, there shouldn't. To be on the safe side should I stop server5.5 manually before testing on 7 (which means doing this on evenings, weekends...when no one's working in the current database...)? We had some troubles lately with our server that's why I'm pretty concerned...

I have a new server setup (Windows 2003) with FileMaker Server 7 Advanced. As far as I can tell everything has installed correctly following the instructions. However, when I try to access a database using web publishing the response is painfully slow .. it takes a few seconds to refresh each page. This is occuring with several different databases .. some of which are very basic. I don't have the same problem with I use File Maker Developer 7 to access the files from a remote workstation .. everything is good. I also don't have any problems with speed when I share the same files using Developer 7 from a workstation .. I can use IE to connect with no problems. Th…

I am currently running Server 7 Advanced on a Windows 2003 server. when I try to log into the database over the internet, I have no luck when using a user name and password. When I activate the guest account, I can get logged in, but it does not ask me for a password. How do I set it up so that it will ask me for a password? Thanks.

One of our customers is having quite large FMS/FMP6 client/server solution (sales mgmt & control). There are approx. 40-60 simultaneous users online every day from 4-6 different locations. There are four applications under the same server and file amount is in maximum (124 files, each application having 31 files). Each app. has 1-1,5 million recors. About 100000 records are updated per week, ab. 10000-50000 new records created per week (in two out of four applications, two are just for training & testing of new functionality). Recently we've got few Error messages in Win2000 server log (& FMS log) saying Could not pause file "filename.fp5" because of an out…

I am about to make a database for my work which needs to be multi user so that up to 50 people can all access the same database, which have around 5000 records a month added to it, each with about 40 fields. Will FileMaker 6 be able to cope with this, whatkind of restrictions will there be on users? I'm only asking because i've never made a multi-user database before and i don't want to waste time with big networking problems.

FM7 advanced server running on a Microsoft small business server. I am basically trying to run a SELECT query on certain records from the FMP7 db using ODBC scripted into PHP and INSERT them into a MySQL database. All seems to be setup correctly and working fine, but this. When I run the same query from Microsoft Excel it executes within milisec's. ps. the php file executes on an apache webserver. ####################################### ############# dbQuery.php ############# ####################################### <html> <head> <title>DatabaseQuery</title> </head> <body> <?php # connect…

It is very strange but since I Updated my FMServer running in a G5 to the new version v7.03, portals behaviour has changed. Now, when some client clicks out the portal after scrolling it down, the portal scrolls up again to the first row. This is really frustating!! The same file running in a HPProliant w2003 with FMServer v7.02 keeps as always. If the layout has unchecked the "show field frames..." option from layout setup menu, the portal stays in the last row you were in, until you refresh the window. Is anybody also experiencing this annoying behaviour??? Or it is just me. Will somebody find out how to workaround this?

Hi everyone. One dumb question. Running Windows 2000 Advanced Server and Filemaker 7 Advanced Server. FM Docs recommend using a static IP address for your server. My hardware firewall assigns DHCP. I reserved an IP for my server in the firewall. I assigned that number to my properties in my network setup on the server. My external IP address is 68.166.225.202. The internal ip address is 192.168.0.7, which is the number that is in my network properties of the computer. For some reason I cannot connect to FM Server Advanced outside of my office network. Is the problem related to Microsoft IIS, FM Server Advanced Web Publishing Engine, or becaus…

Greetings All Wondering if anyone has had any related issues with the access log not logging. Thanks! -st

I've installed FileMaker Server 7v3 and FileMaker Pro 7v3 on seperate dedicated machines. When I start FileMaker Pro and go to open -> remote, nothing is displayed in the Local Servers list. Both machines are installed on the same subnet, so no routers or what-so-ever are causing problems here. Very strange, as I've talked to another FileMaker person and he said to me that this happened in his environment too, but there it displays the FileMaker Server from time to time. Thanks in advance for any help!

[color:"red"]OLD Question: ***We are running FMS 5.5 off of Mac OS9 for a small in house databse. Last week the server crashed unexpectedly. When everything got restarted, FM seemed to be working fine, but now we are discovering that some data is missing. There seems to be no rhyme or reason to the lost data just some fields on some records. Any hope at recovering lost files? If not, any suggestions for a more stable setup to avoid future problems?*** [color:"red"]New Question: I bought an external drive to back up my data off of the server (something about closing the door after the cow has already left) but when I try to set an automatic schedule I keep gettin…

Hello everyone... We have here a server running with Mac OS X, on which FileMaker Server Advanced 7 is installed. Our database is protected with authentication (thanks to FileMaker accounts), and is backuped daily on a DVD. Friday, we got problems with our server (the midpane had been replaced since), so we naturally wished to use our last backup on another computer, running on Windows XP (we don't have another Mac computer). We had then the quite bad surprise to notice that we couldn't open our backups under Windows : FileMaker recognise well that's a FileMaker file, but rejects all passwords, from the simplest (an empty password, for a read-only access) to t…

I'm using FileMaker Server 7v3 and I'm trying to register FileMaker Server with a directory service (AD) but I'm not able to do this. I fill in everything correctly: Directory server name: <full DNS name of a DC> DN: <distinguished name of the DC> Login settings Enabled Use Windows authentication log in using: <Username + password of domain administrator> I get the following errormessage in eventviewer: Source: FileMaker Server 7 Event ID:27 Description:Registration with directory service failed. (No Such Object) Does anybody knows what I have to do here? thanks in advance for any help

Hi everyone... Is it possible to create SQL queries/command in FM Pro 7? If it is, where should I put the command and how does it actually work in FM Pro 7? Thanks in advance!! Cheers, Ren

Post deleted by lmead

[color:"blue"] Is it worth the expense to possibly [color:"red"]improve [color:"blue"]performance and use 2 machines with Server 7 Advanced and serving the database on the web? FMP inc. claims that using one machine for the web publishing engine and the other for the 7 Server will provide the best improvement in performance. Has anyone tried this with any sukcess? It would be nice to know before I spend another 3 grand and a few days modifying the system.

I'm using Filemaker Server 7 Advance to developed a ASP web base App and using OBDC to connect, does anyone know how is the license work when using web. Thanks in advance

Hi everybody, How to set a default value of some global field when application is on server? To describe closely: App is on server. Field format of that global field is Radio button set, and display 3 values from one Value list: a) one, : two, and c) three. Every time I've log in, default value is b)two, and I want to change that default value to some another [ i.g. c) three]. I read one tip about it on FileMaker Advisor http://my.advisor.com/articles.nsf/aid/12129 , but seems that tip does not work properly on FileMaker Server 7 on Windows. Any suggestions? TIA Veselko

Hi We have just installed FileMaker Server Advanced in our XServe and everything seems to be working accordingly with the exception of an error in the server module log of FileMaker Server Advanced, We always get an error of Error reading reply from tomcat. Tomcat is down or network problems. [Mon Dec 06 16:45:30 2004] [jk_ajp_common.c (1187)]: ERROR: Receiving from tomcat failed, recoverable operation. err=0 [Mon Dec 06 16:45:30 2004] [jk_ajp_common.c (1198)]: Error connecting to tomcat. Tomcat is probably not started or is listenning on the wrong port. Failed errno = 61 [Mon Dec 06 16:45:30 2004]wpc 17.212.20.79 0.000378 [Mon Dec 06 16:45:31 2…

We are using FileMaker Server 7 to serve a database. FileMaker Pro 7 clients are connecting to the database using an account that uses the default [Data Entry Only] privilege set. Clients have enabled "Save layout changes automatically (do not ask) in Preferences > Layout. When clients navigate manually between View as Form, View as List, and View as Table in Browse mode, they are presented with a "Do you wish to save this change with the layout? (Yes/No)" dialog--even when no changes have been made to data (let alone the layout). When clients with default [Data Entry Only] privilege set use a script whose only step is View As [Cycle] to navigate between View…

Our FM7 Server runs our point of sale (POS) system (very important for our business). The FMServer is at our main corporate site with 3 FileMaker 7.0v3 clients connecting from our LAN and we have one FM 7.0v3 user accessing the FM server from off site through our server's pretty slow upload bandwidth. All machines are running Mac OS X v10.3 (client). We are finding that our FileMaker server is crashing at least every few days, sometimes more frequently. More specifically, the fmserverd process dies. The computer/OS keeps running just fine. We have tried a bunch of stuff so far: 1) exported all data and reimported into a brand new database 2) clean …

I guess I've got a pretty easy question: I've set up a filemaker 7 server and installed filemaker 7 pro on a citrix server. Now, I would like to publish several database files, so users just have to click the published content to access their fm7 database. I've already tried with the following program path "C:Program FilesFileMakerFileMaker Pro 7FileMaker Pro.exe" fmnet:// but this didn't do the trick. Actually, the question is: is there a way to open a remote file on a filemaker server via the run command or command prompt (so without opening filemaker pro first -> open -> remote -> and then select preferrable file)? thanks in advance for any help, Joe…

Hi, We have a FMServer 5.5 running on the same computer as the Windows 2003 server. The databases are accessed by 4 people within the office and need to have it accessible for remote users (5 users in Latin America). This is a non profit organization so our budget is very limited. The question is: do we need to set up a VPN, or there is a way for the remote users to open the databases via "open remote" by typing the IP address of the FMServer? (the office has a DSL connection and the remote users too) Thanks very much in advance!

Hello. Is there a way to make the Filemaker Web Page be at localhost instead of localhost/fmi/iwp?

We had a major crash this afternoon on our Server: Version 5.5, Windows 2003. We have had problems on and off all year. This is our second major crash. The first one took down one file. This one took down our entire Server. I would cut&paste a copy of the actual screen dump, but I'm not sure if the admins would like that. The info goes like this: Event ID: 1000 Source: Application Error Category: (100) Text: Faulting Application Server fmserver.exe, version 5.5.0.1, faulting mode fmserver.exe, version 5.5.0.1, fault address 0x000014f2. ... I found nothing on the FileMaker Website (suprise). The one thing I did find talked about…

I thought I remember seeing somewhere how to do this, but here's the deal. I have 15 files in a database, hundreds of fields and scripts, a lot that over time have become obsolete, etc. Is there any way to get some type of report outlining what is in use and what isn't in use? I thought I remember seeing something like this a while back, but I could be mistaken. Thanks.

I'm looking for a solution to run a script via FMP Server Advanced. Scenario: From the web a user accesses a site using fx.php and connected to FMP DB via FMP 7 SA. Data can be sent and received fine, however, data needs to be exported from FMP into a batch file and run against another system. In FMP 6 Unlimited this was no problem because a FMP client was actually running behind the web. I know FMP 7 SA cannot directly export a file, but has anyone come up with a solution that would trigger a script on a FMP client running with FMP 7 SA? Plain terms a user submits data to FMP 7 SA and that data is entered into the DB, then a script is triggered on a remote FM…

We wanted to make our filemaker pro database accessible to our help desk through a web interface, so I exported the database to xslt style sheets to make it available. Is this the best method for making this database available? Also is there a way to set user names and passwords on xslt sites?

This is a repeat of a post I placed at the FM6 Pro forum. I want to have about 10 people use FM Pro 6. We chose FMP6 rather than FMP7 since many of our users are still running Win98. Is FM Pro Server 7 capable of hosting FM Pro6 users? If not I'm going to need to purchase a copy of FM Pro 6 Server. I would appreciate some guidance if possible. I don't like purchasing expensive outdated software unless there's literally no choice.... Is Filemaker permitting FM Pro 7 Sever to be downgraded to FM Pro 6 Server the way they do with the client software?

I have set up remote administration for FMS and installed the SAT on my XP laptop. I can log in, do my thing, get out- everything is fine. Until I try to log back in. The password resets itself to blank. I actually didn't figure this out the first time and I had to reinstall Server 7 (Adv). Now, in desperation because I couldn't remotely access my Server, I tried logging in without a pw. I got in. I reset the pw, logged out, logged in, logged out, logged in- pw reset itself again. I did this numerous times because I am incredulous that this could happen. It must be an id10t error. Any suggestions? Server et al. installed on one Windows 2000 machine off-site.

with a solution running on server, can you create a relative path to a client desktop (mac or pc) when using an export script?

I want to have about 10 people use FM Pro 6. We chose FMP6 rather than FMP7 since many of our users are still running Win98. Is FM Pro Server 7 capable of hosting FM Pro6 users? If not I'm going to need to purchase a copy of FM Pro 6 Server. I would appreciate some guidance if possible. I don't like purchasing expensive outdated software unless there's literally no choice.... Is Filemaker permitting FM Pro 7 Sever to be downgraded to FM Pro 6 Server the way they do with the client software?

Hi, I've developed a runtime that's attracting a surprising number of requests for a server version. I have no experiance of servers (don't even know if this is possible with a runtime). Can anybody poin me in the right direction for FAQ's etc on server versions of runtimes? Thanks Giles

I've been tasked with updating an acquired FM database application that is currently running in Filemaker Server 5.5 on a Windows 2K server. In the application when someone clicks on a button, I want to execute a Perl script and then have the results of the Perl script written to a field. When the application is running, will the reference to the external script know to look for this external script on the server? Or will any external scripts executed from a Filemaker Server application need to be installed on the client workstation? I know I could test this myself. However, I don't have access to the production server. There is no development server (to my…

I hope I am not asking a question everyone asks, I've done a search and found some useful info but nothing that answers my specific question. I have also looked at the manual. I am running Filemaker Server 7.03 on a Mac (panther) and want it to host files that are on another mac, over the network. When I try to enter a path name in the 'additional database folder' field it is rejected 'not a valid path'. I am using the following format for the path name filemac:/Volumes/volumename/foldername Permissions on this folder and contents let anyone do anything I am logged into the other mac under my normal username which gives me full access. Two…

I have two issues with FM7 (Mac OS X). 1. I am testing FM 7 Server on a separate Mac from FM 6 Unlimited. When I access FM 7 from another Mac (after closing FM 6 on the machine I am accessing it from) FM 6 Unlimited will freeze up and I have to force quit on the machine that is severing FM 6 Unlimited. Summary: FM 6 Unlimited on Mac 1, FM 7 Server on Mac 2, Opening FM 7 on Mac 3. The other issue is when I open Define/Define Fields on the Mac #3 it takes a very long time for it to open. When I close Define Fields and open it again, it opens right away. Is there something in the fields that is causing this initial slow response? Thanks in advance for your hel…

Hello Almost all 'big' database servers (MS SQL, Postgress) include a mechanism of 'transactions'. It means that all operations between the start and the end of the transaction are done succesfully or in case of any error all of them are canceled and also all affected records are restored to the previous state. Are there any plug-ins bringing such a feature to FM Server 7 available? Thanks for any suggestions.

I manages a FileMaker Server 3.0 on a windows 2000 server. I also have FileMaker Pro 3.0 installed on the same server, just in case I need to perform file's inconsistent check or recover files. Sometimes the FileMaker Pro 3.0 runs in the back and seems sharing the files with FileMaker Server. It brings up the CPU usages to 70-80%. It really slows down the application. Any idea? thanks, Jackson

I'm hosting 20 dynamic websites width about 20.000 pageviews a day. Since my old Windows Server was to slow I installed a brand new XSERVE width FM7SA. I had to change some parameters, but everything works just fine. I use FX.PHP and PHP5 for my websites. Except: Sometimes the link between the datasource and Apache breaks. This without any reason. Apache & Filemaker Server don't stop working, it's just the dynamic generated part of my websites that stops. The only option I have is to completely reboot the server. Very nasty, because now I have to check the site every minute. I just don't trust the system anymore. And every night I do a complete reboot, to be sure…

Hello! This is silly - probably pilot error. Could not get FMPro 7 Server installation to work - first because Firewall was turned on. Now it's off and I can access databases from other computers. Great. next step is/was to get Web Access going. Installed WebPublishing, and the config web site can communicate with the Server. Or so it says. Problem is, in the FMP 7 Server Admin Program / Clients / Filemaker WebPublishing engines, when I add the same identifyer and Passcode as for the WebConfig, I get no IP for the Web Admin Console. Consequently, when I try to actually access the DBs via Safari, they are listed for access, but when I try to open them,…

Hello. Need some help with the set up. I go to host:80/fmi/config Set the first two sets of passwords I get to "Overveiw" the pink box titled localhost, reads the publishing engine is not responding, to configure click here. I click there Get to another user name password screen And it will not take the User Names and passwords I set up? What user name and passwords is it looking for?

I have a FM7 file that I have successfully published using FMSA 7.03 on a Mac running OS X.3.8. I need to change things in the file, but when I log in remotely, it is not accepting the original user/pw I set up (before webpublishing), and opens with the guest settings/permissions when opened locally. The Os X file privileges are Owner = fmserver (R/W), Group = fmsadmin (R/W). How am I supposed to edit the file, and how do I get around the automatic local guest login, since right now, the file can't be changed?

Hello, Filemaker 3.0 Server on a MAC G4 suddenly refuses to sort. I have 18 thousand records that uses about 37 mgs. Whenever I try to sort, Filemaker just closes incredibly quickly. Any thoughts? Is there a repair/analysis tool that I can run? I did try deleting the preferences. Thanks in advance for any thoughts. Cheers,

I'm using both Custom and Instant Web Publishing with FM Server 7 Advanced on Panther. I have IWP set up to require a user name and password to access the database. My question: when I submit a user name and password via my browser, are those items encrypted during transmission to the Web server (Apache), or are they sent as clear text? Thanks.

Hi Guys, I have a server using Filemaker Server 7 and want to make a backup in another machine but when i try to do that it calls an error like "invalid Path" or something like that.. Can anyone help me with that?? thanx a Lot Andre Tozzini

We currently have a setup of our web publishing installed on one server and the Apache Web Service installed on another server. Is there a way in the web publishing of FileMaker Server Advanced to restrict access to the Apache Web server's IP Address? Or is it a setup in the server operating system. We are currently running OS X Server on both servers. Another question is, how can i prevent someone from making the request of /fmi/xml/fmresultset.xml?-dbnames which list out the names of the databases that are being shared on the web. Thanks.

I installed FileMaker Server 7 Advanced on Mac OS 10.3 and now I am trying to install Web Publishing Engine on a separate computer (Mac OS 10.3.7 Server). I followed all the instructions and installation was successful. However, when I am trying to configure it via http://server/fmi/config it tells me that apache cannot find this file. I realize that the problem is that I have 3 virtual hosts configured on that computer and just http://server does not work. Does anybody know where I can specify maybe a port number or folder location to access Web Publishing? Thank you very much! Jul

Now don't you all laugh ... but this just tickled me pink today ... I received a frantic call this morning that our server was down (we aren't using Server yet). I rushed to the office in terror but, as I walked in, everyone was grinning and working in FileMaker anyway!!: Oh wonder upon wonder ... FileMaker didn't need Server to work just fine - because it is its own server, right? Oh sweeeeeeeet .... Everyone was so excited that they weren't affected at all and business wasn't disrupted!!! Now this is probably well known by all of you but I'm new to networking FM and it surprised (and greatly tickled) me!! LaRetta

Hello all, I'm creating a new database to publish on line. As I already publish my web site with my FMSA, I'm using a FMSA 'trial' version (max 3 FMPro client and max 3 Web sessions). the 'funniest' thing I'm experiencing today is that, using the value of the field to get the URI of an image (the URi is created BY filemaker), I get an HTTP: 404 error (as Tomcat says). someone can tell me if this is a bug or the 'trial limitation'??? Tnx!

Hi all, I'm looking for a few good suggestions. I've recently been put in charge of a small DB supporting faculty and student records. We're running server 5.5 off of an old mac (OS 9) and using FMP6. Unfortunately, we've outgrown our old solution and are looking into upgrading to FM7. On the software side, we're pretty much set FMP7 with server 7 advanced. We're now looking into buying a new machine to run the server. We'd like to be able to utilize all the new features that FM server 7a has to offer, especially on the internet based access side. Any suggestions as to a cost-effective machine that will be able to handle a medium-sized load without difficulty? …

Hi All, I'm trying to find out how I can put a shortcut on a users desktop which will when clicked start up filemaker and go to a remote server. Is this easy to do? Thanks

Well, I have used FMP6 for two years now and must admit, its awesome! We have FMP6 Unlimited that works great! Now we have FMP7 Advanced server and I cannot get the .xsl files to work! I used the handy little CDML/XML converter and still get errors. I though I had trouble in my files since my CDML pages were quite complex, so I built a very simple CDML page in FMP6, got it working, then ran the CDML converter, put in on my Advanced Server at: library/Filemaker Server 7/Web Publishing/xslt template-files/fmp7test and right away I get an error! http://134.39.205.247/fmi/xsl/fmp7test/search.xsl Thoughts, Ideas, Comments? Below is the contents of this file use…

The v3 update to Server 7 and Server 7 Advanced has finally been released. Here's the Fix List: FileMaker Server 7.0 and Server 7.0 Advanced v3 1.1. Stability Improvements 1.1.1. Addressed stability issues some customers have experienced while hosting complex FileMaker solutions, particularly under heavy load. 1.1.2. Addressed a stability issue that could cause a file to be incorrectly reported as damaged at the end of a backup. 1.2. General Fixes and Improvements 1.2.1. Windows: Fixed a problem that prevented scheduled script tasks from running. 1.2.2. Windows: Event Viewer entries now display the correct Type/Severity code (Error, Warning, Informa…

Hi All, My company is soon to upgrade all the Filemaker systems we have to version 7 in one hit. This is about 400 seperate multi-file "systems" and they plan to consolidate them onto much fewer servers. My question is: is it possible to host more than one system on a server, and have multiple logins at the server level for administration? In other words, can the individual system administrators be given access to the server to configure for their own system, but not have priviledges for any of the other systems? I know this can't be done with version 6, but I haven't had access to version 7. Thanks, Sean.

You can connect to a FileMaker server behind a NAT box or firewall using built in SSH features of Mac OS X. This is handy if you run a NAT box or firewall, and have more than one FM Server to connect to. Note: this procedure gives out your admin password on the server to the client, so use only with a trusted user. I use it for my personal development needs only. It also exposes SSH to the outside world, so make sure you are using strong passwords and have all of the latest system updates. Steps: 1. Make sure your server machine has port 22 open and your NAT box forwards port 22 to that machine. See your Airport Base Station (or linksys, etc.) help files …

I'm a little bit of a FM newbie... I've just created a simple, 1-file database to organize our school's career exploration day. This database basically counts the number of people attending each career exploration session (there are many all running at the same time) and generates students' personalised timetables. Unfortunately, 8 people will be required to all use the database at the same time. Would it be possible to share this file over a network in FMP 5.5? We have a highly secure windoze xp/server03 network where we can't do something as simple as right-clicking in windows explorer so changing network settings (through control panel) is definitely out of th…

So I am finally ready to take the plunge to move to FMP7. However we are not yet ready to give up FMP6. How can I serve both 6 and 7 efficiantly together? Our setup is one server, 4 client machines. Connected with a router, Port forwarding is turned on, on the router so we have WAN access to the databases (using FMP, not IWP). So far I have learned that I can't serve 6 and 7 on the same server. So I guess I will get another server for FMP7. But does anyone know how to set up the router so I can connect to both FMP6 and FMP7 files remotely (using FMP6 and FMP7 respectively)? (FWIW, we have a NETGEAR router) TIA Jerry

Hello, I've been working with mysql and php for a while and now I'm looking into using Filemaker 7 as a frontend. I think what I'm trying to do is fairly simple: I want to use Scriptmaker to Execute an SQL query, like this: INSERT INTO journalists (contact, name) Values ("' & contact & '","' & name & '") I've added a new record, two fields, contact and name, and I now want to add that record to the sql database. But how do I get the field values into the INSERT statement? In php I would do: <?php $sql = "INSERT INTO journalists (contact, name) Values ('".$contact."','".$name."')"; ?> What do I do in Scriptmaker…

I remember reading a few weeks ago that while Server 7 uses SSL encryption between server and client (using "open remote"), the login/pass for the database is not submitted with SSL. The SSL is only applied to the data after login. This doesn't make any sense to me, but I remember reading some posts with some very upset users who discovered the bug. Can anyone confirm this, or if it has been fixed? Thanks!

PROBLEM 1 - LICENSING ISSUES: We host FileMaker Pro databases with FileMaker Server 7 Advanced. For a few months now numerous Macintosh (only) clients will get without notice "The maximum number of users...". We've extensively checked every serial number of every copy of FileMaker on all networks and all are unique. Sometimes the recipients of the message can simply reboot their Mac and get back to work. Others must wait for hours or even a full day for the issue to clear. If we reboot the server the problem clears instantly for everybody. That

I have some served files that have date fields with today's date as a popup. I know the server needs to do something each night to make the correct date popup each day. I've had other people handle this in the past, but I now need to step up to the plate. Does anyone want to be a designated hitter and help me out. I believe it has something with shutting down FM each night. Mark

Hello guys, I was able to install and configure the web publishing engine BUT I am unable to edit any field in the database. The same user can edit in FM developer but can't do anything in the web interface apart from browsing data. The fields are only editable in Find mode. Please advise. Bench

Hello guys, Please I need help urgently. I installed FM Server & FM Advanced and configure publishing engine with no problem, suddenly when i want to enter the administration console i am stuck with this "An unexpected error has occurred." if i click on restart publishing engine. I have restarted both web server and console several times in the terminal, i updated FMS to 7.2 and restarted the computer but invain. I am on Mac OS X 10.3.7 Thank you very much for your support BK

hello Using FMPro7 server advanced on windows server 2003. When we first installed server advanced I was able to use the Filemaker Server Admin. Then after about a month I started getting the message: "Login Failed". The thing is I am never asked for a password. We did make some changes (we added the external authentication method) but I am not sure if that has anything to do with it. What I don't get is the fact it will not prompt me for a password. Any ideas? Thanks in advance. steven durow

Hi- Our company has both FM 5 and FM 7 Servers. Is it possible to access FM 5 databases with FM 7 Pro client? I just upgraded my client to 7 and I can't seem to access any of the FM 5 servers. It looks like the method in which you connect to servers has changed since 5.5 Pro so I'm not sure if I'm doing it right. Any help would be greatly appreciated. Thanks!!

Hi All, I'm using the FMServer Config 5.5 on an Xserve running Mac Server 10.2.8. I have two schedules set up to back up all databases to an attached RAID. One runs weekly and the other nightly. The Schedules window says that they are running when they should, but if I look at the file dates, they're from more than 3 weeks ago. I've tried altering the script to save to the Xserve's harddrive, but I get the same results. Has anyone seen this behavior? Thanks in advance, Andy Mowrey