Custom Web Publishing

The ecommerce company that I work for (eSellerate) provides a mechanism where order information can be sent via an HTTP POST to a web server for immediate order notifications. The body of the POST is XML based on a schema that eSellerate defines. Is there a way to interface this with Filemaker Server 7 Advanced without the need for PHP, or am I going to have to write a PHP/WebObjects page to receive the post, translate it to the appropriate INSERT SQL call and insert the information into the DB via ODBC/JDBC? Thanks!

How can I publish in the web filemker pro 7 database without using Filemaker Server Advanced 7? I need it to run as well with Windows and Mac.

Hi guys I'm having trouble structuring a find request. I'm trying to return companies from our database where the first character is a number. I don't want to do 10 individual find requests so I thought of trying to use the ... range find symbol. Doing 0...9 returns companies where there's a number from 0-9 in the field somewhere. I've tried doing ==0...9* to try and return the companies where the first character of that field is a number, but with no luck. I'll also need to try and structure this find in CDML syntax as well. Any ideas on how to do this? Thanks Ben

I

Hello, On our website www.sj-solutions.nl we use CDML tags to connect to our FMP database. but google won't index those FMP page's. I use <META NAME="ROBOTS" CONTENT="INDEX, FOLLOW"> and now I want google go to those pages I made with CDML and index them. The CMDL string looks like: http://databases.sj-solutions.nl/fmpro?-...max=1&-find and give result like NovaNet 9 Any ideas how to let google index the NovaNet 9 page?

Has anybody found a way to import pictures into a container field through a browser to a published fp7 database. Ta Colin

I work for the Vanished Children's Alliance a missing child Non-Profit www.vca.org. Using Filemaker Pro 6 we host a database which is searchable from our website that contains the information about all of our missing child cases and their printable posters. We do this to help law enforcement generate leads and sightings which help to recover these children by allowing the public to have access to the photos and descriptions of each child and the capability to print and help us dstribute the posters. Using Filemaker Pro we are able to keep the database up to date through Web Companion, unfortunatly we have come to find out that this version only allows 10 users (or ip ad…

CMSI has Server Advanced 7 on an X server. I have looked at the post here. There seems to be problems with logging out ect.. and people who use an exact match find to allow user's access (this is what we did with our 4.0 filemaker). We need a way for customers to create their own accounts to be able to create and update their own records only. This needs to be secure. Should I keep using the exact match find or use filemaker accounts? I would gladly buy a solution for this. I have toyed with using two files. One with guest access and one that requires a filmaker account that allows access to the account's records only. The problem I have with this is I have to create t…

I have seen suggestions in posts and articles that it is possible to output static Web pages from FMP, but haven't found any concrete information as to how to actually go about it. I have a friend who can get around in FMP 6 on the Mac well enough to create a product catalog--a layout that contains a product name, description, item number, photo, etc. He would like to be able to output static Web pages that preserve this layout. We would then ftp those to our hosting server along with the images. One advantage he sees is being able to use the same layout for Web pages and also for paper sales sheets, the difference being that there are both low and hi-res jpeg d…

Is it possible to use Dreamweaver MX2004 to publish web pages and use FileMaker as the database it connects to - using the application server ColdFusion? What is the best configuration for using Dreamweaver and connecting to databases created in FileMaker?

Hi I seem to have a problem making my database available on the web. I'm working with filemaker 6 on Os X panther. I've activated the web companion and activated TCP/IP port 591. In the webbrowser, the database is now available on the computer that runs the database on URL: http://127.0.0.1:591. In the LAN I can connect to the web interface on http://192.168.254.30:591/index.html Now I want to make the site available to the world... The computer that hosts the database has a static IP, so on the router I've forwarded port 591 to the LAN-IP (192.168.254.30) When I insert the adress http://www.myURL.com:591/index.html I keep getting a "Page not availa…

Hi there! I've used FileMaker Pro 6 for years personally, but just started to use it at work for a small project. I haven't had any problems (even though this is my first time using portals and related fields). But I want to share it with some colleagues using the Web Companion. I've upgraded to the latest version of the Web Companion on our Windows server (which is running the database). When anyone tries to edit the database using the Web Companion, they get this error message: "Repeating Related Fields Not Supported: Repetitions in related fields are not supported by the Web Companion." Unfortunately, I don't really understand this error message! My layout do…

Hi, I'm a beginner to both Filemaker & this forum so hello! (proficient at Access but keen to make the jump) I run a small record label and would like to catalogue all our music (mp3) with view to selling music online from our website. Would also like to include a customer database that could be added to online by new customers. Please can anyone point me to any templates/tutorials to get me started. Many thanks in advance!

I just purchased a new laptop and transferred all my files. However, I cannot get IE to recognize localhost. It works just fine on my old laptop. I looked at all the IE settings and they appear to be the same. I do not recall doing anything special to enable localhost on my old laptop. I verified that web companion is on and all that. When I enter http://loacalhost on my old laptop (even if I do not have any FM files open), I see "Local intranet" at the bottom right of the IE window. On my new laptop, it's just "Internet" and in the body I get the "page cannot be displayed" message. Can the problem be the Port number?? How do I check the port number on …

Help..I worked a whole day on this problem and I'm about to give up... I have a database with 7500 records. There is a username (actually an e-mail address) and password fields in all records. This a database with a custom interface for the web. My Problem: I need to find a record based on MATCHING the two fields. (email AND password) If I enter correct info in only one field, and leave the other field blank, the record is still returned. (Bad...) If I enter correct info in one field, and incorrect info in the other, I get the error page. (Good...) Here is the html source for the page (I stripped out the table junk to better see the code) …

I have a layout with lots of checkboxes on it. In FMP they are aligned nicely. However, when I publish my database to the web, the layout changes and the checkboxes are everywhere. How can I set the web alignment for the checkboxes?

Hi, Is there a way to get the values of the "-find" request from within the script that is called after the "-find" request? Suppose a "-find" is called with request of myTextField=A and myTextField2=B, I some how need to get the value of A and B from within a script that is called. Is this possible? Thanks.

Thanks in adavnce. I want to allow prospective customers to fillout an online form, linked to an FM file. How can I use FrontPage with FM, or publish from FM to a FrontPage website. Do I need FM Server or Adv Server to do this?

Ever since updating our Filemaker solutions from FMP 4.1 + Lasso 2.5 (runnning under OS 9 & WebSTAR 4) to FMP 6 UnLtd (running under OS X 10.3 & WebSTAR V), we have been plagued by a problem where (some) web browsers hang when submitting forms. Maddeningly, the problem doesn't happen all the time, and doesn't seem to follow any pattern we can discern. It does seem to happen more frequently in Safari & IE for Mac, but will sometimes occur when using Mozilla-based browsers or IE for Windows. It seems to occur more frequently with forms which create a new record than with forms which edit an existing record, but can occur with either. It also seems more frequent …

I have FMP7 Advanced installed with FMP7 Server and the Web engine (with IIS) on separate WIN2K servers. Access to my test databases via FMP7 Client and IWP works fine. I have used Site Assistant to create a complete 'home' site which allows me to view and sort records. Problem is, when I try adding a record, the reply always comes back Error Reply 200, which apparently translates to 'Record Access is Denied' I am using the same layout to add a record in IWP, CWP and the client, and have the same default privilege set applied against the fmxml and fmxlst extended privilege entries as I am using for fmapp, fmiwp and fmxdbc. Can anyone help?

I have learned in the IWP forum that publishing reports with sub-summaries and leading or trailing summaries isn't going to happen in IWP - possibly not at all. I am new to FileMaker and, more specifically, to web publishing. I need to know what options there are. Ideas I could explore include: - Using a regular layout, placing fields in the body to look like a report layout, as suggested in the IWP forum - seems a good idea. - Publish and update the reports regularly as a pdf so they can be opened from the FileMaker on the web. - Install FM Pro on the PC's that need complex reports and sync data from the main server to those remote sites. (They are franchise busin…

When I check the "Indicate web compatibility", it shows as compatible. But as you can see in the actual script window, it indicates it's not compatible. I am trying to get back to page one after doing a sort. Does anyone have any other ideas as to how I can do this? Thanks, Brad

Dear All, This is IWP Just wondering if anyone has got a way to overcome this script limitation. 1) To show a URL page after a submit ! this part is ok 2) To close the database after the URL page is shown. (Not sure how to) So that users do not get confuse and re-submit again.

Dear Wise man / Woman of FMforums. How does one include the username and password in the url so when a user clicks on the link , it will connect them to the password protected database. Please note that the database is Filemaker 7 Server Advance. Thanks much.

Hi! I made an application that is intended to be send to user via internet (16Mo) since it's kinda big file to download with a 56k, I thought, I could set the application so the user could run it directly from our website. I uploaded my standalone solution onto my web server, but I get an error, I can't access to the folder where the application is. Is there any compiling I need to do in order to be able to uswe it on a website!? will 2 or more users be able to use it at the same time? Thank you!

I have the following situation arising during a V6-V7 conversion project: A simple script is used to send data form the current "contact address" record (V7) to a web-hosted database (V6) using a Lasso command constructed by a calculation field. When viewed on the web page after transfer, uppercase letters in the source data are displayed as lowercase. This was NOT the case prior to the V6-V7 conversion of the source db. In that situation, uppercase text was displayed on web pages associated with the web-hosted db WITH all the uppercase letters as entered in the source db. I'm guessing that this is an issue related to character set conversions …

I'm looking for some direction on whether it makes sense to host a 4G file in FMP 7 containing ~86 million telephone numbers (the national do not call list) and make it available as a look-up table for checking telephone numbers against it from the web using IWP. We don't seem to be having much luck. Most of the issues are due to the slowness of importing and indexing in FMP 7 and the fact that the file is so huge to work with. Any advice?

I realize that this is the not the IWP list but I need help for an article that is going to be published soon. I have been trying to figure out a way to print from IWP using a plug-in to call a script. I have tried waves in motions events plugin as well as troi's activator plug-in to try and run a script when a new record is created, or when a field is activated. So far no luck. With IWP you have to create a new record and then use the commit record script step for the info to be saved in FM. However even though a new record is created the plug-in does not fire off. Any ideas on how this could be accomplished would be GREATLY appreciated! The other proble…

Since you can't have more than one LOP parameters in web companion, I am forced to make one tremendous search field of many other fields concatinated. However, in my database I have a portal that contains many rows of textual information. Is there any way to create a field that would contain, all in one non-repeating field (Or a repeating one, if GetRepetition could somehow be used), all of the information in all of the rows (Think the sum aggregate function for text)? -Paul

I have the database working great except when I post it to the web it will only display 5 records at a time, is there a way to increase this. I want to use the list format the table and form do not work for this page I only have 6 records on this forms but you have to flip pages to see the last one, this is just a pain, does anyone know how I can increase how many records I want to display???

It used to be in FileMaker 6, you could enter the IP and Databases name of the FileMaker file you wanted to open in the browser such as "fmp5://somehost.com/myFileMakerFile.fp5" I wanted to know if this problem in 7 has been fixed. I tried using fmp7://somehost.com/myFileMakerFile" but all this does it open my FileMaker Pro 6 application. I also tried fmnet:/somehost.com/myFileMakerFile which shown in the Open Remote... dialog box and did not get any further. Has anyone managed to get this to work?

I use a Filemaker database to manage a number of similar housing rehabilitaion projects with a co-worker. Each of us works out of our own home-based offices. We want to share the same databases and have total mutual access to each project database and essentially total functional access to each database file. The databases are straightforward, (not relational) if somewhat complex. They include summary and calculation fields. Each project database has about 600 fields, 30 value lists but only 500 records or fewer. We are concerned about security over the internet, but can limit the sensitive dta (social security numbers, etc) contained in the database. Wha…

I am needing to deploy a custom CDML solution where users will basically be creating and editing records. There are no scripts called from the pages or that run while the database is used, nor are there calculations on the layout accessed via the web. There is one relationship and about 30 fields on the "create" and "edit" pages. I am wondering if anyone has any kind of metrics/experience about how well FMU 6 under Mac OSX performs over the web on a single server relative to number of users. I have run a 4 CPU RAIC for higher traffic sites, without any significant issues, but am wondering if in this particular case I can get by with one decent OSX box. I would anticipate …

Greetings all We're running FM 6 to publish a database online of student clubs. I learned today that we've been hacked. We think someone is passing add new record commands through the URL. Is this possible and can it be blocked? Thanks! -steve

I have tried to figure this out, but now have more questions than answers. Our Main database is a simple contact database for mailing lists. Will be shared by 5-7 users. We have a cgi form on our website for people to apply to our college, but it is clunky to import info into filemaker (must open a .csv file in excel, than import to filemaker). Also, administrator must wait weeks for IT to update the form. (Info on the college app changes every semester). I would like to have the college app be in filemaker, and automatically be part of the database when the applicant submits it. Also would like the administrator to change the info whenever she wants. I th…

Hi all first post here, and first time using filemaker, so I hope someone can point me in the right direction. Im want to use filemaker pro to publish a database on the web. However I want to use a database that is located on a server running filemaker server obviously. The ideas being both web users and office ( LAN) users can access the same one database. However I can not seem to get the database to show in sharing/instant web publishing/currently open files....and therefore I can't get it public. Am I barking up the wrong tree ? Or just missing something cause I skipped bits of the manual ? Regards Darren

Hello, I have set up the Web Security Database on Filemaker 6 Unlimited. The database is a fairly simple thing that collects data from an online form. It works fine without any access restrictions. However, when I add an All Users password to the Web Security Database and check off Browse and Create, instead of getting the login screen online, I only get an Add error (-9959). What's up? Thanks.

Hi, I'm having a hard time passing information from two different databases using CDML. I have a database "login" for storing login information, then I have a database "invoices" which holds information about customer invoices. After they login to the "login" database, I want to pass the company name so that when they do a search in the "invoices" database they can only search on their company name. In other words, when they login and transition to the search page for invoices I want a field that defaults (and shows) their name, then searches the "invoices" database for their company. It should also be noted that on the search page I wish to have other search criteri…

OK, My last post did'nt get me any answers. So I will try again. I want to update our 4.0 FM solution that allowed nurses to submit and update resumes online. We have an Xserver with FM server 7 advanced, we still own FM 6 unlimited, we have lasso 7 and studio 6. We can spend some money on upgrades. Which is the best way to go and why? Lasso PHP IWP Custom Thanks in advance for any good advice.

I'm fairly familiar with FM development, but other than creating an IWP page, I haven't done anything on the Web with FM. We have FM7v3 advanced, and I'd like to switch over to having more control than IWP allows. At a high level I sort of understand XML, but I'm hoping someone can give me a better understanding of the XML/XSLT capabilities. With XML/XSLT and nothing else, can I do direct "Insert/Update/Delete" type functions in FM? Do I need some sort of a middleware engine? We have some Java background, but nothing significant with Perl/PHP. If we have to have some sort of middleware engine is there any info on using Java as the engine? Most importantly, can someo…

I'm currently testing FileMaker Server 7 Advanced with different types of configuration in order to find which one offers the best performance for web publishing. So far, I have gotten horrible performance from all the setups, where a single simple request from the web has required no less than 6 seconds to perform (with network lag being insignificant in this case). The times listed below are a rounded average of 100 consecutive (non-concurrent) queries on a database that has 35,000 entries, on a layout that has 3 text fields. The machines I have tested it on are : PC : Pentium4 3GHz, 512Mb RAM Mac : dual-CPU PowerMac G5, 768Mb RAM (1) WPE & Serve…

I am building a fairly simple product DB that I will need to publish on the web using Instant Web Publishing and Server Advanced. Any way, I am attempting to test (off-line and from my hard drive) the search function from IE, but I get and error as soon as I click on one of the search fields that indicate

I am a FM7 neophyte looking for a solution to show a selected part of my DB to potential clients. As a photographer I have a thousands of negs that I have scanned and compiled into FM. I can even publish the whole DB on the net! Very slow though! I have been approached by potential client asking for certain types of pix but for the moment I do not know how I can show from the DB only those that are pertinent. The question is: Can I create a new FM doc that shows only those pix that I ask it to & publish them over the net? Can I have numerous docs running at a time via different web addresses? Or is it poss to create an html template page that is a portal to a FM…

I have a database that I originally designed to just be used on one computer (stand alone). I have since found it more useful to put it online using filemaker server. The problems is that the fields that are in the database that are defined as global no longer work properly. To my understanding it is because the globals are linked to a user in some way, so when someone else logs in they do not see them in the same manner. How do I fix these fields so that they function in the same way when the database is not published online?

Hi all, I have never built anything FM to use with the web... Is it possible to design a form that would be e-mailed to people (members of a group), they would then fill the form and hit a submit button to send me the completed form. Once received in my mail box, I would like to update my database with the info on each received form. Is this a job FM can do, or am I going around the world to get to the house next door?? Should I be looking at other software? How easy is this going to be?? I don't know much about web programming! thanks Dan

Hello! I have an online database and I would like to monitor the number of request made to the database. More specifically, I would like to know how many times the Submit button has been hit. Can anyone help me with that? Thank you! Catherine

Hello, First the Background, Our company just purchased SugarCRM. Which is a web based Customer Relationship Management program built using MySQL and PHP. I have developed some office databases in Filemaker that my boss wants to try to incorporate with this app. One of them is a pricing database which we use to price our products. It has 6 or 7 popup lists whose values in the lists change depending on the previous values. By drilling down, we come up with a price. We want to add this pricing finder to the Quote section of the CRM software. I'm OK at programing with Filemaker, but have no experience with PHP or MySQL. The soultion …

Hi there, For people who works a lot with php and mysql (just like me) and think in mysql-methods, i have found a solution to get the last_insert_id (recordid) after a INSERT in de Filemaker database. Maybe it's usefull in your future scripts. This methode only works in combination with FM-and-PHP. More info you can find on www.fm-and-php.info Check this ! <?php include("./fmandphp.php"); $FM = new FM_and_PHP(); $FM->setFileMakerHost("localhost","80","7"); $FM->setDatabaseName("bsp7"); $FM->setDatabaseUserPassword("Admin","Admin"); $FM->setDatabaseLayout("www"); $FM->setCommand("new"); $FM->addParameter("Field1", $…

I am having a problem processing payments with Filemaker on the web. I get an error code of 803 host not found and all of the files are open in fm and I have the port as 591 if you have any input let me know and I will check on it and get back to you. It looks like when it is trying to process it the fm files close for some reason does anyone know why that would happen as well. Any help would be really appreciated. Thanks in advance

I've been milling around this forum trying to understand some of the newer "features" of FileMaker Pro 7. It all started because my boss bought a copy of FMPro7 (and she loves it) and wants me to create a front end for it for the web. I tried to create a test html page and put it into the Web directory of my FileMaker Pro 7 directory and then access it through a web browser. It didn't work like some of the stuff I've done in FileMaker 5 and 6! (URL: <port>/FMPro?-db<dbName.fp7>&-format=...)'>http://<host>:<port>/FMPro?-db<dbName.fp7>&-format=...) So if I have understood what's going on in FM7 (as well as what isn't), there is …

am new, stupid, stuck, and on a deadline... goal is to publish a school district faculty/staff directory on our web site from a fmp database by exporting the fmp database as html tables which i can then edit and dress up in dreamweaver (not able at this time to do 'real' web publishing of database...) have imported and cleaned up faculty/staff records from a .xls file and now have a nice fmp database with 1349 records that include lastname, firstname, location, position, department, phone, emailadd, etc. want to publish each 'location' as a separate, static html table/page (each of which will be linked to a 'master' html page that directs visitors to each l…

Could someone please take a look at this code and tell me what might be wrong. I used the CDML converter to get this and the syntax looks just like the syntax that is in the Custom Web Publishing Guide but it will not work. If I replace the test with say 'one'='one' it works. Thanks in advance! <h3><center><xsl:choose><xsl:when test="fmrs:field[@name = 'Status']/fmrs:data[1]='Expired'"> <center><font size="+1" color="#FF0000"><b>Registration is closed for this class.</b></font></center></xsl:when><xsl:otherwise> …

I think I already know the answer to this but, I have just converted a fully working FMP 6 Unlimited Soution to FMP 7. I went to turn on the Web Sharing and see only IWP is available. Is there no way to offer simple HTML web pages with CDML links directly using FMP? Thanks in advance!

am looking for a good (and inexpensive and easy to learn) solution to publish a faculty/staff directory on our existing web site that is on a netware-brand apache server and built with dwmx... could i build such a thing as a fmp 7 database, then, upload to our web site and have it be a searchable/'filterable' directory? for example, if a visitor knows just the first name of a faculty or staff member, i would like them to be able to search the database and view a 'report' showing all the records whose first name matches their search term. or, if they know the person works at a certain location, filter the database by location and see a report for all faculty/staff at …

Could someone help out with a full rundown on all prodycts available to put FM on the web. I see many people are balking at upgrading to FM 7 Server Adv and losing all their CDML, so I'd just lilke to get a full list of alternatives out there What I know. IWP - simple, not too secure Server Advanced - XML and XSLT web publishing Lasso - LDML and nice feature set iApp - not sure what it really does, seems kinda hokie fx.PHP - not sure, does PHP and FM? other alternatives: straight PHP and SQL Coldfusion ASP What else do we have to put our databases online? Especially keeping FM as the main backend. There seems to be some scattered…

Since the Send Mail script isn't web compatible, is there a way I can use the Open URL script? I know I can enter mailto: in it, but how do I get field values into it? Thanks !

Is your wallet in DENIAL and you don't even live in Egypt? Pull up a chair at CAFEphp and RELAX! Now you can publish your custom site to the web without FileMaker Server 7 Advanced! http://www.cafephp.com/index.php Daytona Beach, Fl. - February 22, 2005- When you need information immediately, where do you turn? If you said the web, you get a cookie. FMWebschool believes that "custom" FileMaker web publishing should be available to everyone, just like your local Cafe. That is why we have spent the last 6 months developing CAFEphp. CAFEphp is a server that enables you to connect to FileMaker Client and serve your custom pages to the web. Perform comple…

In the 'FM site assistant' I am able to choose my hosted database, but when I try to select the layout in the 'site feature' section' they are all blank.

Is there some way I can upload attachments with the record? I have a bug tracking database and sometimes it's necessary to include pictures or log files. Since this is IWP, I need some way users can do this from their web browsers. Thanks!

Hi, Hi there, Total newbie here. Will probably be asking more than answering on this Forum section A general question as a start. How exactly FileMaker can interact with PHP based Intranet and Internet Sites ? - uploading documents (mainly pdfs from printed FM reports) to the Intranet. - synchronization of a PHP db Can these tasks be automated from FileMaker 7 ? Is FileMaker able to generate PHP requests ? At least is it possible to fill a "form" directly from FileMaker ? Thanks

Hello I am using FMPro 7 server advanced on Windows using custom web publishing. I have a reply page that returns several fields. The fields that reside in the main file and have calculations using only data from that file are showing up fine but two of the fields are calculation fields that gather data from another file. When the web user submits the form the reply page returns one of the fields empty and the other displays a question mark "?" Any ideas what could be wrong? I used the CDML converter to make these files and have not touched the coding yet. Thanks in advance. steven durow

Hi all. I'm trying to solve a problem that's been mentioned previously on this forum, and could use some advice. The client has a FM6 Unlimited box serving up databases using CDML. One of the databases stops responding to internet requests, though it's still open on the FM6 box. Access to the database through FM6 Unlimited somehow drops, so that a database opened with full privileges will now only have read privs. Strange. Anyway, what I gleaned from earlier posts is that what's happening is that a user will click on a page element multiple times, thereby sending new requests to web companion and interrupting the previous ones. Web companion then chokes - s…

I am running a small solution which is designed to allow users to input data that will later be collected into a rather large report. I am using IWP to allow the users to enter the data from a web browser. I have set up an account with read/write access which allows them to see only the input layouts. The problem is, upon logging in, the users are led to one of the report layouts that they do not have access to (and hence a large <No Access> message appears on their screen). I have taken this layout off of the layout list (and it doesn't appear on the drop down list for the layouts) but it still opens up to the restricted layout. Hope that makes sense. …

Using custom web publisher on FMP7 server advanced (windows). After a web user submits the form the reply.xsl page shows their name and percent correct. The name is displayed fine but the percent does not show up. The percent field uses the count function. After playing around it looks like the the count function is the problem. Anybody have an idea why it will not display? Thanks!

I need a web based electronic claims filing service's program to interface with a FMP5 Server application. The other company says I need to create a TCP/IP socket and send HL7 messages. I'm getting the HL7 down, but I'm not sure where to start with connecting with them over a TCP/IP socket. I don't see anything IN FMP that allows me to create a socket so is there a Plug-in that is eluding my search? Help, please! Sabrina

I have a very plain DB. 1 layout with 1 portal, showing at the moment all records (15 rec) on 1 field I have an Open URL script. When I access the DB through the web browser (IWP on FMS advanced) it only reload the current page, when I click the field. There is only one script step in the script. (Open URL - specified a field eg. http://www.lavendt.com) Am I missing something ? ;-) Claus

Does anybody know how to allow scrollbar in a field in iwp? I notice the scrollbar would appear only if the field is editable, but not in read only format. As such the field size becomes the limiting factor as one can't have more text inside than the field size. Regards, Clifford

Is there a way to increase the limit of 5 lines of records showing in the web list view? I at least want to show 50.

Hello, I have been asked to make forms where people input information into a FMP7 database and I modified the Site Assistant widget results to do this. The problem is that required fields are necessary in these forms, but when a blank is not filled out, a 509 error pops up. I tried modifying the xsl in the addrecord page and in the utilities.xsl page to ignore the 509 error and send the user to the edit page, but to no avail. Can anyone tell me how to do this. Thanks very much!

Does anyone have any suggestions for examples of web pages using FMP? I have in mind a small start-up company, providing database services for small businesses over the internet. I've used IWP before, but I'm looking for something more customized. I looked at the FMP web page but they only list testamonialsof companies that use FMP, not links to any "online" databases. If you know of two or three, I would greatly appreciate it. Thanks. dan

Anyone tried it? Excited by it? Is it crap? Let's talk about it: http://www.macworld.com/news/2005/02/03/iappserver/index.php?lsrc=mcrss-0205 iApp Server enables custom Web publishing with FM 7 By Brad Cook [email protected] MacWeb.com on Thursday announced that its first product, iApp Server, is now shipping. The middleware tool installs as an Apache 1.3 module -- a 4D WebSTAR V plug-in is on the way -- and enables FileMaker Pro 7 users to build database-driven Web clients. It includes such technology as Server-Side Rendering and Saved Actions and offers support for all of the new features found in FileMaker Pro 7, including relational and portal f…

I have a very small database associated with a web page. With FMP 6 and CDML everything works well except one thing. At the beginning of the page I ask them to click a box stating that they have completed and returned the necessary forms. If this box is not clicked, I want a message to come up telling them they have to click the box, and not allow them any access to the other fields until that one box is checked. I haven't been able to figure out how to do this. I've tried several things, but nothing works. This would be similar, I guess, to having to click the box stating that you accept the terms of a site before you can go farther. Any clues?

I will be getting filemaker server advanced. I was wondering what everyone uses to talk with, between the web and filemaker 7, lasso, xml-xslt, fx.php or what? Are there good resources for that product? Thanks - Doug

Currently I am running a little CDML site through FM6, FMWSC, all SSL - security is priority 1. We need to impliment file uploads and having session based logins would be nice as well. We weekly have to export data. What I am wondering is should I skip upgrading the site to XML and just purchase lasso and connect that to FM7? Or should I get lasso running off a MySQL database and just use filemaker in the back? I am trying to find the easiest path to upgrade at lowest cost with most features (aren't we all). I'm afraid FM7 is going to take a lot of time and money to upgrade to, and if I am going to spend all that time, maybe I should swtich over to a more robus…

I'm not sure if this is the right forum to post this in, but here we go. I managed to get Filemaker Site Assistant to notice my database as being accessible. When I click on the db, it asks for a username and password.. I enter the information and I get access denied. I've tried resetting the password, all that jazz, and keep getting access denied. Any information would be appreciated. EDIT: I guess it will be a good idea to let you know the background of my setup. I have filemaker advance server 7 running on a mac g4. I am putting up a webserver on windows 2003. I installed the filemaker web module and tools so that I can have the web server access the filem…

We are running Filemaker Server 5.5 Unlimited on one server (Computer #1). This server hosts all Filemaker web pages and runs a script that opens the database files (.fp5) located on another computer with the Filemaker Server 5.5 console (Computer #2). A third computer (Computer #3), running Filemaker 6 is used to edit each of the .fp5 databases (e.g. File > Open > Hosts...) We use FileMaker to run our Grades and Comments database for our summer school program. Last year, all database files (4 of them) were labeled 2004summerschoolxxxx and all webpages (9 of them) were labeled 2004summerschoolxxxx. This year we needed to archive last years information and r…

I seem to be having problems with authenticating web connections (IWP in this case). I have external accounts defined in my database config and I can slide in (the desktop credentials are passed into FM without any problems) when opening the database with a full client. But, if I hit the database (mounted on an FM7 Advanced Server) via IWP, the web login refuses to take my network credentials. Any idea what I might be doing wrong? P.S. I am able to get into the database with IWP if I use a local database account like Admin.

Hey everyone! I'm new to this site but I wish I'd found it long ago. Anyway here is my question. I have several databases that are shared over our network. The users add data to the files every day from all over the state. This means each user has a version of FMP running on their desktop. I'm using FMP Server 3.0 on an old NT box with Multi- User turned on. My boss wants to take this box down. We have another box running W2000 and FMP Unlimited 6.0. This box publishes databases to our users through the company intranet. My question is this. Since the databases that are running now are purely for information to the user they have no way of entering data. I need to kn…

I have custom published databases (converted from FM6) and I am trying to use cookies to pass the user's privileges thourgh the pages. In FM6 I had a code [FMP-IF: CurrentCookie:web_access .cn. Delete] which worked fine. When conveted to xsl, the code looks like this <xsl:when test="contains(fmxslt:get_cookie('web_access'), 'Delete')"> And it is not working. It is not the if statement, it looks like the cookie cannot be set/retrieved at all. Thank you for your help!

I am trying to accomplish in fm 7 what I had in fm 6. Any recommendation on help materials would be great as well. At the moment all I have is the "FM 7 Instant Web Publishing.pdf. My setup in fm6 was: preferences/application preferences/plug-ins/web companion/ Enable Instant Web Publishing is not checked I have a folder called "myinfo" with these files: mydatabase.fp5, index.html, mycalc.html in the "Web" folder. the index.html has a link that looks like: <p> <a href="http://xserver.lsi.ku.edu/FMPro?-db=mydatabase.fp5=&-lay=CGI&-format=/myinfo/mycalc.html&-script=ClearForm&bivalue=@&-FindAll"><span class="large"…

I have no problem defining fields and telling numbers to have 2 decimal places while in Filemaker, but once the information is published online they seem to get a mind of their own. For instance, in Filemaker I can view

I have Server Adanced on OS X (panther) up and running. When I use Instant Web Publishing my file with auto-enter calculations and auto-enter lookups works fine. However, when I generate the xsl code from site builder, these fields do not work. I have to convert them to full blown calculations, not auto-enter calculations, to get them to work in the xsl format. Once I do the field conversion from auo-enter to calculation, they work fine. Again, this all works well in IWP with no change. Anyone have any suggestions for me?

Question: When you list all the script steps that are web compatible, loads dissappear. Does this mean that in a database you should not create scripts that are not web compatible even if the script isn't to be used by a web user? I would believe that a database should use all the functionality of FileMaker except Web Users just use a different set of scripts and layouts that are web compatible. I've never used Web Companion so I'm a little out of my depth. Is it easy to get into? Can you use data stored in web space? can you have your line item file accessable over the web? I am trying to work out whether I need to keep on uploading and importing …

When I signed in today to make a contribution of knowledge and experience I discovered the request for money. Since I am now living on a meager social security check of less than $1k/mo I will no longer be able to give my knowledge and experience away for free. Well, that has been my experience with FMPro. I have spent more on it than I have made from it. So I will no longer be attending to the needs of others since I cannot afford it. I depart leaving this bit of advice for all present and future visitors: Test your solutions with rigor while simulating multi-user activity.

Hello. I built a website with FMU6/FMS6/Lasso7 about a year ago and it was functioning without any problems until now. Right now sections of the site behave strangely. I noticed that the problems occur when the all the files opened in FMU are minimized. When I maximize them the site is working normally. Does anyone have any idea why this is happening? Thanks!

Hi, I'm new to Filemaker 7 and actually new to databases itself. With the help of people on this website, I have created a well working database that I am quite pleased with. I was originally going to keep this for myself to store records of information, but when I realized that I can put it on my website, I figured that would be a great place to be. So knowing that, I would like to place my database online. These are the fields it consists of: Date Ordered User ID # Full Name Product Purchased with Price # of Referrals # of Referrals Needed Referred by: Paid? (check box) I also have a portal that includes 3 parts (This is to show who a certain per…

I just published a FMPro (IWP) to the web. It works flawlessly with Safari. However there appear to be many issues with other systems: COMMENTS by Users: Mac OS 9.2. Netscape 4.7: Buttons and Navigation Scripts do not work at all. Some words overlap each other. Left hand side blank. Not useable for me. ========================== stuck on page. BACK button in browser does not work. ========================== Are there tables of what browsers and systems do and don't work and why?

I am new to FM. I want to make website in FM. Do I have to use FM as front end or HTML. If HTML , then how should i communicate between FM 7.0 and HTML

When I posted four templates on our server using instant web publishing, two of my four templates are missing the NEW, DELETE, and FIND buttons at the top. I was wondering how to work with certain changes that occur when the template is published? where does one start? What would be the reason that one would retain this field and another would not? Would appreciate any help. thanks....

Howdy! My University department handles registration for new student orientation for which we charge a fee to cover accomodations, meals, etc. In the past, we have required paper forms be mailed to us with checks/credit card numbers, but we are going to offer online registration this year. * We use a medium/complicated FM relational db for program registration. * We will probably have a security certificate and merchant account just for this program. * The University has a gateway/bank for us to use. * The University will probably require us to use PHP/MySQL for the financial transaction. * I am competent with CDML with some PHP/MySQL experience. * I know…

Hello All, I'm looking for a way to search one DB from a value entered in another.. I have a newaccounts DB that recieves new account info and I would like to populate it by looking up info in another DB based on one of the fields from an entry in the newaccounts DB.. Currently all HIDDEN fields in the DB are passed to it from cookies I set when a user logs in that are setup in a user DB, values I want set a certien way so it is proper when a new account comes in.. As of now I am setting a bunch of cookies to pass this set info around while they are in the DB pages.. I am looking to set maybe one value like name=whatever so when they send in a new acc…

I have a few quirks in a search reply page that I've created, and think I know what the problem is. I just don't know how to solve it. Any ideas are welcome. I have a database of faculty members at our school with names, email addresses, teaching schedules and photographs. I'd like to use the information in a dynamic web page setting, where students, parents, etc. could search for a teacher and get a web page showing their picture, schedule, email, etc. What I get instead are some strange results: Anywhere the data requested is part of the designated source file, it works fine....except for the photo images. The photos are in a container field, and what is retur…

I have a form that displays a single record from an online search. I can fill in the form and hit the submit button, and a new FM record is created with the contents of the form. This all works GREAT. But here is my question: what if I use the [FMP-Record] tags, and within my form I show the contents of 3 seperate records. This is done by using a [FMP-Include: Filename]. Something like: <form action=FMPro method=post name=Edit> [FMP-Record] [FMP-Include: contents.html] [/FMP-Record] <input type="submit" name="-Edit" value="Continue"> </form> That is not the complete form code, but you get the idea. A find is performed, 3 records …

Dear all, happy holidays! I hope life finds you very well. I have a question.. I'm not satisfied with IWP.. I don't think the interface is so usable for the average user.. and am not happy with the 20 record limit.. so, I'm considering other options.. keep in mind.. I'm a mere mortal.. taught myself Filemaker, but besides that my programming experience is very limited.. some html, not much though... I've looked at the options for publishing databases online.. and came across Witango. The lite version is free and allows you 5 connections to Filemaker Pro (not server).. in any case.. I saw a demo of it, and it seems like the easieast way to publi…

Hi, I am trying to create a web-forum on a Filemaker database. What I thought I would do is create one field that holds all the responses to each topic. I call this field "response". When a user submits his response-form, I want to add, whatever he wrote, to the pre-existing content of the "response"-field. Eg: 1. Response-field holds following content: "This is response one". 2. User submits a form from the website containing "This is response two." 3. The "response"-field in the FM database should now look like this: "This is response one. This is response two." Can anybody give me an idea of how to accomplish this?

We use a Windows 2000 FM webserver and it works fine! But we have one problem: If a person on the console of the Windows FM webserver with the rightmouse button clicks the FM server does give an reaction on the web. Can we prevent this problem Thanks any way for your reaction!

I've been searching for hours and hours. Does anyone know of a web service that will accept an ISBN number and return the Library of Congress call number? I hope to integrate this functionality into a library management component. Thanks Chris

What is the best way to have a URL that will find multiple records? I know haw to use one for a single record search by including items such as: [FMP-Field:e1]=2&[FMP-Field:e2]=229&[FMP-Field:e3]=3344 But how would I do a search for 3 different records where: 1) All 3 records have [FMP-Field:e2]=229&[FMP-Field:e3]=3344. This is the same for all 3 records. 2) Each of the 3 records has different criteria for [FMP-Field:e1]= for example, [FMP-Field:e1]=1 and [FMP-Field:e1]=3 and [FMP-Field:e1]=5 Larry

I'm having troubles sending special chars through to FM using XSLT. For example, say I'm submitting '

Help! this is driving me nuts... I wish to display dates in dd/mm/yyyy format using custom web publishing. At present it refuses to do anything other than mm/dd/yyyy. (It displays correctly when viewing the database in Instant Web Publishing, and also when exporting the xml directly from FileMaker) I can see that the xml that is being sent to the cwp engine has "date-format="MM/dd/yyyy" " in the 'datasource' tag (see below), but no idea how to change it. Does anybody know??? ----------------------------- http://intraweb-dev/fmi/xml/fmresultset.xml?-db=Goods_In&-lay=Plain&-findall <?xml version="1.0" encoding="UTF-8" standalone="no"?…