Other Internet Technologies

I am converting cdml to php for FileMaker unlimited and I am finding in my conversion that the php version loads slower than the cdml version, especially when accessing lists. I am doing this conversion for the eventually migration to FileMaker Server 7. I have put only the files needed to be accessed on their own layout, but this does not seem to have improved the performance. From readings I have done, I have gotten the impression that php should be faster than cdml. One example where I see the slowness of my php solution is accessing two databases: on a php page I have a client listed along with all the clients orders, so I am accessing two databases (client.fp5 &…

Can any one explain the syntax for the use of "if" and "else" with php. An example would be to show on a php page a check box and text if a field in the database is no and show no check box and text if the field in the database is yes. An example in my database is a client who receives prints with their new order (send_print field = yes) and another client who does not receive prints with a new order (sent_print field = no). For the client who does not automatically receive prints I would like the php to show a check box and some text. For the client who automatically receive prints I would like nothing to show on the php page. Thanks in advance for your help - …

I finally got FM Pro 7 up under IIS but now real grief has set in: My output screen is completely dead! The web output has terrific fidelity to my original FM Pro layouts, BUT in all that complex dHTML they forgot to make the fields, buttons, and menus work... at least in my case. (See attachment. It contains both the dHTML source code and a screen capture showing the rendering. Further, both Go-Live syntax checker and the W3C HTML checker complain bitterly about the output code. W3C got very confused indeed. (This reminds me of the days when people tried to use MS Word for web publishing and it's output was so bad that FrontPage couldn't interpret it and h…

Hi, I'm new to FM Pro 7 but not to Filemaker though most of my experience was a couple years ago though i did run earlier web enabled dbs with little problem. So I have a client with 2 FM4 Win databases which easily converted into FMpro7 on a mac 10.3.8. Everything works fine and dandy from the conversion in FMpro. The problem is access via a web browser. 3 other users on PCs with XP pro. They only need data entry and perusal. I enabled IWP down port 591. Databases show up on browsers in the IWP page. Users either get a password screen where they can't authenticate or a Javascript alert that too many people are logged in (and no-one is logged in)…

Does anyone know how to verify a Lasso installation on Linux? I installed Lasso Server 7 on Suse Linux and since Omnipilot only supports Red Hat, I have no idea if its installed correctly.

I'm working on a Database, and I have a spot where it searches for all records, on a website. But it will only display the first 25 records? is there a limit or something? or a code that I should be using? thanks for the help!

HELP,,, I have a form with a field "ori" and listvalue coming from the db as session (example below). I want to make the field required to select a value by user. If not selected then a pop window will remind or not continue if submitted. I tried javascript, and it works with text fields but with example below, not at all. Help needed. Thanks in advance. --------JAVA SCRIPT <script language="javascript">function validate(){ if (document.testform.ori.value==""){ alert("No Orientation Session. Please Enter a Session!") return false } return true }</script> ----------FORMAT <FORM ACTION="FMPro" METHOD="pos…

I normally use PHP includes to pull in filemaker data so it disguises the address bar link to the database. So I normally do something like this... include("http://db.domain.com:591/FMPro?-DB=TEST&-Lay=WEB&-Format=template.html&-FindAll"); To get filemaker data onto my page. Then I thought if I rename my filemaker format file to .cdml and add the file type .cdml to be parsed as PHP in my .htaccess file on my main website, then I could use PHP code in format files. Well it works!! But it gets better... You don't even need to add .cdml as a PHP parsed file type in .htaccess Any PHP in the cdml format file gets parsed…

All, normally FP7 has no problems with relative pathes to multimedia content that was included "by reference", though it needs a replace operation to get there. After some testing with IWP I come to the conclusion that, in addition to the restriction that referenced multimedia files must be in the Web folder of FileMaker, they are only shown on the IWP page if they are referenced by an absolute (full) path. Can anyone confirm this? Anyone as annoyed as I am with this fact?

when im using instant web publishing is there anyway to use the new window script step or any other step for that matter to open another web browser so that i really have both windows open at once? Thanks, Anthony

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…

I'm stumped... we have two CDML templates which call very similar fields from the same database (one is a small image, the other is a larger image), and the portal only works on the detail page. I don't know much about CDML, but I thought it should work since it's very similar. The only difference I see that might make a difference is that in one, the FMP-Portal is inside a FMP-Record tag? The portal isn't even being accessed. Here's the code for the CDML page that works: [FMP-Portal: Self|FilmNToIMG|pk_FilmNID|Relation] [FMP-Field: Self|FilmNToIMG|pk_FilmNID|Relation::imglinkurl_disp, raw] [/FMP-Portal] [FMP-Portal: Self|FilmSToIMG|pk_2ndFSID|Relation]…

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!

I was wondering if anyone has had problems using the CDML converter? We have a few databases and associated webforms that worked great on FMP 5.5 Unlimited. Recently, we upgraded to Advanced Server 7.2 with the Server and Web Publishing Engine on one machine and IIS 6.0 and the Web Server Module and Web Server on another. The two are separated by a firewall with ports 16016 and 16018 open. I finally got the two to connect across the firewall, and the Web Publishing Administration Console shows XSLT Publishing enabled and active for this database. This database works fine with Instant Web Publishing and the Site Assistant, but I can't get it to function with the conver…

On the final page of a series of web pages we use the inline script below to send out an automatic cemail. At present the inline script below does not seem to work, though we can edit the 'email.txt' file and have it send out very basic messages like hello how are you? This leads us to believe that it is the contents of the 'email.txt' that fouls things up. [inline:email.host='smtp.bu-london.co.uk', email.to='[email protected]', email.subject='BU London - Update Confirmation', email.format='email.txt', email.from='[email protected]', Nothing] [/inline]

I may be missing something small here but anyway : I am trying to use a "ghost" file which only contains my layouts and scripts for IWP purposes. This file is stored on its own server and is linked to our main FM7 server. In FM Pro this file works perfectly however when i go to our website there is no data in my records. This is my first try at online DB design in this way so i am a little lost. As always any and all help is appreciated

I'm running Filemaker Server 7 Advanced, patch two, with IWP, and Active Directory authentication. When a user types in a bad password once, their account is immediately locked in AD. I checked the domain controller logs, and the filemaker server is sending multiple bad passwords to the domain controller within one second. (Even though the user typed their password incorrectly once.) Has anyone else ran into this? Is there a fix? Thanks, Enzo

Hi, I am trying to add a new record to FM 7 using FX. The new record is added; however, the returned data set has no data. It is supposed to have the values of the just created record. Here is my code: $result=$NewData->FMNew(); $recKey = key($result['data']); $recordPointers = explode (".",$recKey); $recID = $recordPointers[0]; RecID is null. Any ideas will be very appreciated! Thank you very much

I look in all the posts and find nothing. So if somebody can help me. Say I have two fields. One is a name of a project and the other is a total for the project. I can have many records for a project. Something like Field 1 field 2 project1 120,50 project1 50,25 project1 30,25 project2 323,67 project2 63,63 project2 23,67 In a javascript, I want to add the numbers so i can have sub-summary for each project. In my script in Javascript I have a line like this within a [fmp-record] TotalProject += "[FMP-Field:TotalBCNet]"; My problem is that it does not add the numbers so the result would be 200,00 for project1 but write Project1 1…

I am puzzled. When I check the Web Compatibility box on my scripts, the Go To Record/Request/Page script step changes from: Go To Record/Request/Page [First] to: Go To Record/Request/Page [Perform with Dialog(NOT COMPATIBLE); First] Here are my problems: 1) FM help says that this step is web compatible, and 2) This step has no option to perform with or without a dialog. When I test the step in IWP it seems to work, but I need to be sure it will work reliably before I distribute the application. Does anyone know why this step looks this way, or what the "NOT COMPATIBLE" is meant to signify? Thanks. David

I've been having this problem for a while now but I seem to slowly be making progress with it. I am looking to automatically send out an email after a series of html pages are filled out. I am using lasso to record the information to FM pro. That part works fine, the FM files are updated. I have even gotten the inline lasso script working, it sends out an email with the subject line I tell it to have to the email address that the person has provided during the course of filling out the forms. The problem I am having now if how the email.txt file (the body of the email) should be formatted. The email gets sent out but there is nothing in the body, despite the fact that in …

I have portals on a layout for an IWP DB. These hold things such as phone no's etc... Problem is... Portal shows 5 records... After you have filled 5 records no verticcal scroll bar appears and you can't go to the 6th row... don't get it ! Tried various scripts from a committ button tell it to go to the portal field then last portal row etc but no avail... Any ideas? Thanks in Advance ! Steve

now that CDML is gone, do I learn xml/xslt or can someone tell me about lasso, How powerfull is it compared to xml of cdml.

I've been using cdml tags for more than 5 years and am pretty proficient, but I must be brain dead at the moment: I am running a couple of databases off of FM pro 5 on a win 98 box In db "buyers guides" I have a layout "web layout" which contains fields from "buyers guide" and related fields from "qdb_co_info_web. The call to this page is: http://qualitydigest.com/qdb/FMPro?numbe...strar&-find On format page all I have is the following: [fmp-field: number] [fmp-field: qdb_co_info_web::company] When I execute the URL I can see that a record is found and the correct layout is showing. However, while the field "number" is displayed on the web…

I have downloaded and started using fx.php and noticed that the link that is being sent to the Filemaker 7 db is sytax for a Filemaker 6 db call. Does anyone know the syntax for a Filemaker 7 call using php just to find all records? This is what I get now: http://10.1.3.32:80/FMPro?-db=Book_List.fp7&-lay=Book_List&-format=-fmp_xml&-max=50&-findall Need this translated into 7 please. Thanks

We are trying to create a CDML page that will search related fields from "Table B" that are in a layout in "Table A". Here is a snippet of the code we're using. Email and Password are the fields don't live in Table A, but do appear in the WebLayout in TableA. FileMaker reports that no records match the request after clicking Submit. If I change the field names to ones that live in TableA the system works just fine. ---------------- <P><FORM ACTION="FMPro" METHOD="post"> <P><INPUT TYPE="hidden" NAME="-db" VALUE="TableA_.fp5"> <P><INPUT TYPE="hidden" NAME="-lay" VALUE="WebLayout"> <P><INPUT TYPE="hidden" NAME="-f…

I am running a small solution on FM7 using IWP to allow multiple users to input data. Because I have not yet invested in FMS7a, the solution can only support 5 users. In an effort to encourage the users to limit their time spent logged into the DB, I set the disconnect time to 15 minutes. Unfortunately, one user was distracted before he could submit his data and was disconnected. Is there any way to save his data? Thanks

I have an issue with a layout we have online. Quick background- we just began to integrated some of our DB's with our corporate website. However navigation is horrendous and i keep finding myself getting trapped (if i stumble onto a part that we have restricted i am unable to use the back button on my browser to get out). We use a lot of permissions and privilege sets to determine who gets to see what data. Also the go to url function doesnt work. No matter what url i want to direct the user to, FM will either refresh the current page you are on, or go to the generic page that FM generates with the list of online DB's. is this a common problem or are we just…

Dear Forum, first an intro: I was very suprised to find a forum exactly on my topic, Filemaker and Flash. Great ! I've been working on Flash file to present some data about a library, documented in Filemaker. Given the XML output by Filemaker, via HTTP request, I've imported the XML data and presented it in Flash via Actionscript 2.0, with the use of the XML- and XMLNode-Class. So nothing is done via the (data) components. The first step of my development was to make a general 'XMLBrowser' is Flash. It is available at http://prbieb.fee.uva.nl/Sjoerd/XMLBrowser. If you find this piece of code useful, let me know, I can post the .fla (Flash) file. All is object oriente…

i amrunning fmp7 iwp locally and want fmp7 to prompt for id/pw for list of dbs. where do i place the db locally?

Have a Mac with two network interfaces. The primary interface (en0) is connected to my local area network and it is used to connect to the Internet (via cable modem), file server, network printers, etc. The IP address is obtained dymanically. Secondary interface connects to Internet via DSL modem and it has static IP address. How can I have IPW use secondary interface? It always defaults to primary. Steve

I want to IWP some instructional pictures and videos but need to control access to the videos and prevent local saving by the viewer (I figure have the vid play in the bowser) The problem that I forsee is that video files stored directly in a container will not play so the must be put in the web directory which apperently is not safe either. Anyone have a possible solution? Also are there any video file formats that will actually be stored in the container field and be played nativly in FMP so I can control access. Again if it is stored on a directory (namely a distributed CD) anyone can brouse to the corresponding directory and view? I really hope thee is a sol…

Hello. I am have a table of data generated from Filemaker on the web. I want to be able to submit another entry into the table & the data to be entered into the table when it goes to the next page. It seems I can only do one action at a time. Does Filemaker/CDML allow for multiple actions or do I need something more advanced like JavaScript? Thanks

I want to IWP some intructional pictures and video but need to control access to the video and prevent local saving by the viewer (I figure have the vid play in the bowser) The problem that I forsee is that video files stored directly in a container will not play so the must be put in the web directory with apperently is not safe either. Any one have a possible solution? Also are there any video file formats that will actually be stored in the container field and be played nativly in FMP so I can control access. Again if it is stored on a directory (namely a distributed CD) anyone can brouse to the coreresponding directory and view? I really hope thee is a solut…

I have a portal that has container fields within it. Only one image (related from another table) shows correctly, all the others don't display. On other layouts, without portals all images view OK. I've tried making all images the same size as the successful one, but no luck. Has anyone worked this one out?

Hey guys!! I could use some help on this problem. I think I have most of it but I keep getting an error message of Record Not Found: The specified record was not found. here is the code I am using and it connects to a Weblayout with the Email and UNIV ID fields already present because if your Emal and and UNIV dont match the db then you cannot register. The password is entered 2 times as you can see from the code. What am I doing wrong? Any suggestions to better this problem?? thanx a million matt <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <title>Student Register</title> <meta http-equi…

Hey, I've got a problem with getting FX.php to work right on a new machine I'm trying to get it set up on. I'm running PHP 5 on WinXP using IIS as the server. Using FMP 6.0.4. for testing purposes. Basic PHP scripts are running fine, and a url such as http://127.0.0.1:591/FMPro?-format=-fmp_xml&-dbnames returns the xml output from FileMaker that I'm expecting. So I'm pretty sure that IIS, PHP, and FM are all set up right. I've got FX in a folder in my web root. (I've actually tried this two way. I've used FX 2 and FX 3. FX 2 was the most recent release of FX until a few days ago. FX 3 was released by Chris Hansen very recently -- Aug 30th I…

Anyone else have web client GUI bugs? Specifically, 1. Cursor positioning over a blank input box is very difficult 2. Tab order through fields is different than specified 3. Occasionally input fileds will "float" to another location, although this can often be cured by reloding the page. thanks Steve

Is it possible to start a print job on the server using the instant web publishing? Following problem must be solved: We are running a Filemaker 7 Pro on our local network. The Database is published and used over the IWP. Everything works fine instead of printing. The server has access to every printer in the network. Can a print job be started from the IWP? Any Plugin can do this? Thanks for your help.

Hey all, Have a newly published db in IWP, with no records. Although I have tested the db before release multiple times with no errors, users are now unable to enter a new record into the database. On my backup db, all still looks fine. Users are getting a pop up with 'Unknown Error Number 6' when trying to enter a new record. Has anyone ever seen this or know what the problem might be? Help PLEASE! Thanks

Hey all, Having another issue with IWP. I have portals set up on PC side to display 15 rows with a scrollbar enabled. Users on the web cannot add more than 15 rows of information - a scrollbar does not appear when they reach the last row. Any ideas? Do I have to increase the portal size -- this doesnt seem like much of a solution as there are certain records that have about 50 rows of information. Please help! I do appreciate any ideas you can pass along... Regards, Jamie

Hi, I have tried to search everywhere on this forum for the answer. The default port for Filemakerpro 7 seems to be port 80. Are there any other alternate ports to utilize? My ISP blocks port 80. I am trying to publish my database it works fine from my computer and web browser but when an outside computer tries to access they get an error message. Any help would be greatly appreciated. George

hello I want to publish db's for different clients so I need to set-up differents directories. Each one would have a different url. For now I see there's only one url possible. I tried to copy the existing folder and duplicate it without any success. If someone knows the solution ... Thanks.

Hi There ! On a layout I have two portals. One displaying a list of non-editable names and the other a data entry portal with a name field on it. The first portal holds the list of names to be enterd into the second portal and I have created a button in the first portal to insert the name text and Record ID text into the second portal. I have worked this way as the whole database has to be able to work in IWP and this is the one way I have found to paste bothe the name AND the record ID data. This works fine fort the first row of the second portal, but once you have filled in the first row I can't find a way of inserting the data into a new row in the portal, even wh…

Hi, I have no experience about Filemaker online. That's why this question may be quite stupid... We have 1 licence of FM7. We have 3 computers in our network which should have an access to same FM-database. Is this possible to do with IWP ? Secondly... If possible, could someone give me REALLY simple "cookbook" instructions how to do that ? Arttu

I have Advanced running happily under Mac OSX 10.2.8 Server (upgrade will wait for Tiger) and using IWP works fine for Mac clients everywhere. But PC users cannot see the files, even on the IWP homepage. So far FM have no idea why this is. Has anyone experience of this?

Hi all... I have a online database set up for my fellow teachers to enter student data into. With some reading and experimenting, after finally updating my Filemaker to version 6, I can now use multiple tokens!!! (pretty cool...) I understand how to set & pass a token between pages, but would like to now combine it with a value list so that the token data appears in the field first, but the user can click on it and get the value list (from the .fp5 database) instead. I was previously using a just value list in the field and am trying to save time for the teacher to enter multiple records. Is there a way to do this? Thanks, in advance for reading …

I have an application that stores UNC paths to executables in a table. I use the open URL script step so that when a user click a button it executes the program at that path. In the client application, the button works fine; however in IWP, the URL is concatenated with HTTP: so that the resulting URL is HTTP://FILE://xxxxxx/xxx/xxx/xxxx.exe. I cannot seem to find the work around for this. If I manually remove the http: from the address bar and hit go, the link works as expected and the program executes. Does anyone have any ideas? Thanks in advance!

We are using filemaker with lasso and webstar. We have html pages which record information when entered and after all of the information has been entered an email would automatically be sent out. Though the pages have not changed, the email is no longer sent out. here is the code used: [inline: Email.Host='smtp.bu-london.co.uk', Email.To=Field:('stpermemail'), Email.From='[email protected]', Email.Subject='London Page Update Confirmation', Email.Body='email.txt'] [/inline] the emai.txt is in the same folder as the html files. Thanks for any help Paul

I am trying to set up FX.php and just can't seem to get connected to FileMaker. I have tried using 2 different web servers and two different versions of FileMaker (FMP7 Server Advanced and FMP6 Unlimited) with all combinations thereof. I've tried both the IP address and the URL name in the server_data.php file. I've checked the FileMaker version set in FX.php. I've even tried hardcoding the file references into all the FX.php files to bypass the server root function. On one of my servers I can get it down to a "Call to undefined function: xml_parser_create()" error. On the other I get "failed to open stream: No such file or directory". I suspect that the root w…

How do I have users login to a database with the Guest account via IWP? If I enable the guest account to have access to IWP, it automatically logs in users as guest. It does not prompt for a password so I cannot log in as a higher access user. Any ideas? Thanks! John

Hi everyone I am developing a filemaker solution in FM7 - using IWP on Advanced server. I want to be able to direct people to a specific record in my FM7 database using a URL. Does anyone know of a way to pass a varaible to IWP through the URL which can then be pick-up by the start-up script in the database to then direct the user to a specific record. I have emailed Filemaker to request that it is added to the next revision of Filemaker, however if there is a work around I would appreciate hearing about it. Thanks Neil

Ok, so I know it's not possible to enter preview mode from a web interface, so who has some good ideas on how to display a nice printed out version of a list of records with summaries etc? Any help greatly appreciated.

Perform un-supported script steps with IWP using WebTrigger! FMWebschool would like to announce their new plug-in "WebTrigger" WebTrigger allows users to perform un-supported script steps from the web. WebTrigger allows you to Print, Export Records, Send Emails, Open Files, Close Files and more. WebTrigger even allows you to perform "MULTIPLE" unsupported script steps. This plug-in is currently available for Windows users. There are many creative options that will be available with this plug-in! You can download the demo files and user manual at: http://www.fmplugin.com online movies available. More movies and example files of really neat …

Is there a way to get a field to scroll in IWP so that the entire contents are viewable -- without allowing the field to be modified? In other words, I want a vertical scroll bar to appear on a field in a given layout and want the scroll bar to work, but I do not want the user to be able to modify the contents of the field from this layout. I've been messing around with this for some time and I can't get it to work. Any workarounds or tricks would be welcome. Thanks!

Simple question and hopefully simple answer: In PHP what is the code to display an image from a container field? Ie) in CDML: <img src="[FMP-Image:CoverImage]"> In PHP using FM5/6 you can use: <img src="http://localhost:591/FMPro?-db=publcations.fp5&-recid=<?php echo $recid; ?>&Coverimage=&-img"> But that won't work in FM7 In FX.php there appears to be a convoluted way to do it in a secure way. But all I want to know is the very basic simple was to do it using PHP code. Who can answer this?

Hi, Is there any way to access more than the first item of data in a repeating field with PHP? I've found examples of how to do it with CDML, but I'd prefer to use PHP for this particular project. I'm using FX if that helps. Cheers, Kevin Futter

I have been developing a online intranet for a client and it's going nicely, but I seem to run into problems when either trying to use the "Open URL" command to actually open another File... and when trying to perform scripts on another file. I was wondering if anyone knows if FM produces a more definitive IWP doco. Cheers

Okay, I'm just about certain that I can do better than this... I have a script attached to button that allows teachers to log information about students via secure website. The two tables used are: Students Contact_Log The script looks like this: Set Error Capture [ On ] Copy [ Students::StudentSerNum.pk ] [ Select ] Go to Layout [ "Contact_Log" (Contact_Log) ] New Record/Request Paste [ Contact_Log::StudentSerNum.fk ] [ Select ] Commit Records/Requests Insert Current Date [ Contact_Log::Date ] [ Select ] Commit Records/Requests Insert Current User Name [ Contact_Log::LoggedBy ] [ Select ] Commit Records/Requests [ No dialog ] Go…

I have downloaded the FX.php folder and the database works fine with the text fields. My problem however involves displaying images. They do not show up in the examples provided with FX.php. I've looked at the source code briefly and have also viewed the source of the resulting webpage. PHP source for the image tag <img src="image_proxy.php?FXimage=<?php echo vignereEncryptURL($BookData['data'][$currentKey]['cover_art'][0]); ?>"> HTML source for the image tag <img src="image_proxy.php?FXimage=%89%C7%FF%94%E7%A8OBF%5D%A5N%F0%D1%C2%80%DF%92%FB%5B%7D%86%BCr3%7BM%E8Z%7E%80S%88%C9H%3F%9C%7DY3%7B%7F%832M%B5%27%8A"> I am curre…

I am having trouble entering data into a field with a layout in IWP when using Internet Explorer v6. The layout has 2 fields and a scripted button. The layout is reached via a scripted button as follows: Go to Layout ["problem_layout_name"(Table_name] Show/Hide Status Area [Hide] Perform Find [specified Find Request: Find Records; Criteria: Table:Field_test"=1"] Go to Field [Table::field_1] Open Record/Request Enter Browse Mode[] When you run this in FireFox, the layout appears and you can enter data in the first field by clicking within it. The problem is that when in IE, I cannot select the field to enter data unless I first click on the "Edit Cur…

I am currently using FM 6 (We'll be converting to FM 7 later, but am stuck with 6 for now) I'm trying to create a Entry Only html form to allow people to submit a pricing request form. I've managed to get the form created, solved the tab order problem and everything is working fine. I'm now working on the validation. The problem I have is that I have a simple Quote_already_Supplied_Y_N field on the form and if the field is yes, I want to validate that the user has also supplied the original quote number. I created a validation calc as follows: (Quote_Provided_Y_N = "No" or not IsEmpty(Quote_Number)) This validation works correctly in FM, but doesn't…

Hello, I am using FMSA7 on a windows 2000 server, static ip. I have been trying to use the IWP thru the server advanced. Now I have been thru the config and I can see access the database on any client machine using the servers IP. I can not access it from outside thru the net. I do have the router port(i tried ports 80/591/50003/50006) fowarded to the server IP. Did I miss something in the setup? I also noticed in the IIS setup under Master properties the port is set to 80 and is greyed(so I cant change it) could that be my problem? Now if I stop the FM service and run my database using Fmpro7 and turn on sharing/IWP using port 591. It works fine. But limit…

It seems I cannot get my buttons that are attached to scripts to work while using the firefox web browser. Has anyone else had this problem or is it just my machine? Stu

After so many questions about how to set up IWP and FileMaker Server 7 Advanced we decided to make a video public. This video covers how to configure the FM7SA administrative console to work with IWP. http://www.fmwebschool.com/fm7iwp_video.php Enjoy! There are also a few other free videos available on this page you might find useful. In Kindness Stephen K Knight

I'm stumped. I am new to version 7 and am used to customizing published pages using ancient software (Claris HomePage). Please--someone help me with my IWP questions!!! I've looked through the manuals, printed and viewed the ones that came with the application, even browsed through any website I could to find my answers. My database is very, very simple accepting similar to address book information--so it is not complicated at all! In fact--I've been able to add records successfully via the web but still have the following questions: 1. How do I get rid of the default status bar in the left margin when viewing my layout on the web? 2. Since I want to take away the…

I am trying to get the Exit Application script to run like the Logout button on the status bar. When I click on the button attached with Exit Application it logs out just fine and it goes to the iwp_home.html page. I have a redirect in that page, which does work but the web adress in the address bar still displays the host computer for the FM db and not the redirected website. The redirect works fine when I use the Logout button on the status bar. Is there anyway to make the Exit Application work exactly like the logout button? I can't have students using the status bar because they dont't kow how to use it. Thanks for the help. Regards, Nathan

Hi I've made a login section using username and password (see code below). It took me quite a while to find out that with this code the username is enough to get into the closed section. Does anybody have a hint on how to improve the code so username AND password are required? Thanks, pjwassermann ----- <table width="178" border="0" cellspacing="2" cellpadding="0" background="pix1/bg_Kuenstler_Login_2.jpg" height="112"> <form action="FMPro" method="POST"> <input type="hidden" name="-DB" value="ptAddress.fp5"> <input type="hidden" name="-lay" value="form_Address"> <input type="hidden" name="-Forma…

Hi, When I have 10 records, I know that IWP just let see 5 records in list mode.. So I want to make a script so that I can make 2 buttons, the first button let see the first five records and the second button let see the next five records. Is this possible? and how? Because I can't find any functions to do this. I don't want te make a extra record so that I can use the find mode for example. I hope it is possible with a script or something that filemaker can count the current viewed records and then can let see the first five or six to ten. Please help. Regards, Diego

I have a simple set field script step on an IWP database (attached to a button) - nothing happens. I added a commit step following the set field...didn't help. Any suggestions?

FMWebschool is proud to announce the new release of FXForge V1.03. The easiest way to bring FileMaker to the web! See our new movies of FXForge in action at: http://www.fxforge.net/Movies.php This version of FXForge offers numerous enhancements! * A brand new GUI with enhanced navigational options * Ability to add Images into HTML tables on the fly * Previous Next button series Ex. 1 | 2 | 3 | 4 | Just like Google search results * The ability to add scripts on the fly * 1 Button push to open Dreamweaver and GoLive (you can use any text or web editor with FXForge) To see the new movies of FXForge in action, and our new user interface, please …

Hello, Yesterday, I posted a question about getting rid of scroll bars. This was posted in the layout forum (I thought it could be layout-related). I found a solution. It is a bit complicated, but here it is: A lot of the JavaScript code and HTML tags are created dynamically by the CGI code (cgi.dll) and so they are not modifiable. I looked into the cgi.dll and made some changes (using HexEdit) and I discovered that the file size must remain the same for FileMaker Pro to recognize cgi.dll as legit... So, starting at character 267587, I changed exactly 16 characters: from [color:"blue"]marginheight="0" to [color:"blue"]scrolling = "no" The f…

does FX.php work with FM server pro 5? and if so how do you get it to work.. (i tried just to enter the FM server IP address in the FX.php config page and it did not get any info from the database. also is there a specific port that FM server 5 works from?. thanks in Advance

I've got a first name, and last name field that get their information though a calculation. The calculation pulls the information from a related database. All IWP finds return no records found. Any ideas as to why?

I'm looking for an example that uses FX.php and browses through a set of records which has the link next and link previous. The viewer would see records 1 to 10 of 50. click the next link button and see records 11 to 20 of 50. etc. If anyone could let me know on a working example that I could look at it would be greatly appreciated.

FileMaker 7 Beginning Web Publishing Video Series is now available! http://www.fmwebschool.com/fm7iwp_video.php FMWebschool is proud to release their new video series for Instant Web Publishing! Purchase this training series for $34.99 through January 24th! Price will go up to $40.99. (Special Offer: receive FM7 Beginning Web Publishing PDF book for free with this order) Learn about this great video series at: http://www.fmwebschool.com/fm7iwp_video.php

Hello, I have desinged a layout, data viewed by list. But the problem is that on the web I only can see maximum 5 records a time. It will not list all the records.. [if I view in filemaker, it will show all records so that's ok]. I have created a script to show all records, but that does not help? Now I only can make a button to go to the next records (more then 5) and a button to go back. Is there a solution to view all records in one time. Or is there a limitation that I only can see 5 records?

I put a message under the Scriptmaker forum asking about testing in a script for the client protocol, in order to make a solution that would run under either Filemaker directly, or through IWP. Perhaps it should have been put here? Specifically, I would rather not create both a Web version and an FM version of my database, but would rather test for whether the client is using IWP or not, and if so, to activate a different set of steps. Is this possible, or advisable? What approach do others take with this sort of situation?

Hope you all are doing well. I just have a quick question related to the portal relationship: I have two related tables (Reference and Author) and the name of the relationship is "Authors" and I have a portal on the Reference layout which shows some fields from the Author table !! Now my question is I am trying to add a new record into the Reference table and at the same time I want to add the corresponding authors into the Authors table too by using that portal ...so I am trying to write my query string something like: $create->AddDBParam('Authors::Author.1',$_POST['Author1']); OR something like this (if I want to add multiple…

I'm using IWP and have the status area hidden. I have created a button to commit the new record. The issue is that when using the button no field validation is done, actually it is done because no record is created but no message appears to note to the user why the record was not created. Note: I do NOT have

Hi, I haven't been here for a long time, but I promise I will return if I can get some assistance here. Long time developer, just switched to 7, trying IWP for first time, let me say this WOW!. BUT... I can display the pages wonderfully from withing a LAN or directly from my test PC, but trying to access them via the world through a correctly configured hardware firewall, seems to get through, but wait for it... BLUE SCREENS MY TEST PC! Which just happens to be my development laptop. Any suggestions. WinXP PRO. Service pack 2 FMP DEV 7 All updates, both fmp and MS no software firewall Any help greatly appreciated.

Can I place a username/password in a URL and log someone into a FM database via IWP?

Hello gang, I'm developing a custom app in FM7, FMS7A and PHP/FX.php. Hosted on Win2003 Server running IIS6. Hopefully someone can advise on a high-level approach to user authentication. Here's what I need: 1 - Multiple users, each with specific functional access privileges. 2 - One class of management users must be able to create, edit and delete other users. 3 - Tracking sessions is nice, but not required. 4 - I am able to require users to allow cookies. How would you approach this? Authenticate via PHP On every page, include a PHP function that verifies who the user is and reconcile that with permission to view the page. There is a good exam…

I'm trying to duplicate a record (current view) from a web page (using iwp) and I put a button on the page and set it to duplicate. The button shows up on the web, but I get nothing when I click it. Is it possible to duplicate a record with iwp? Any workarounds if not? Thanks in advance for the help!

50 Quality Screen Capture Videos Multiple movies are included with each movie title. http://www.fxforge.net/video.php Some of the videos included. EasyPHP setup Configuring PHP Your first PHP Script Creating your first form Submitting via Get and Post Includes and PHP Introduction to FX.php and FileMaker Building a basic Query Searching FileMaker with PHP and specifying parameters Creating Records Editing Records Portals Multiple Requests Sorting Value Lists Radio buttons and check boxes Displaying selected values Emailing Images Working with Errors Installing and setting up FileMaker Server 7 Ad…

Ive been working with claris homepage 3.0 becuase its the only thing i have found that dose CDML. I want to create a page where users can create a new cource. However I cant seem to make the pop up menu work. This is the code i have been using::::: <P><FORM ACTION="FMPro" METHOD="post"> <P><INPUT TYPE="hidden" NAME="-DB" VALUE="ihBHDSCource.fp5">&nbsp;<INPUT TYPE="hidden" NAME="-Lay" VALUE="crs_edit">&nbsp;<INPUT TYPE="hidden" NAME="-Format" VALUE="crs_view">&nbsp;<INPUT TYPE="hidden" NAME="-Error" VALUE="error.htm"><Select name="crs_type"> [FMP-ValueList: crs_type, List=crs_list] <option [FMP-ValueLi…

I've been asked to look into using FM as a method of cataloging quicktime movies on a web server. Basically someone looks up a match based on date, location etc, and the QT movie appears on the screen for them to watch. I've done a quick mockup which has presented two problems that I'm hoping someone can help with: 1. The system will host about 4Tb of movies, over several HDDs. I don't want to embed the movies into FM. Is there a way to make FM link to the file in question? 2. At the moment, when I click on the container in IE, it tries to download the picture, rather than play the movie. How do I make it play the movie. Thanks

Hello all, I hope this will make sense. I have a Purchase DB with a notes field that I can create new notes for certain purchases. What I would like to do is show the last note inputed on a webpage if possible. Here's the break down. The Purchase DB is part of a Software DB they share a relationship, and on the Software DB I have a portal to the Purchase database so when I purshase new things for a piece of software such as a renewal of a support agreement, the Purchase DB logs the date and the note I typed in. I already have a CDML page displaying th Software part, but I want the last log of the Purchase to display as well. Again I hope this make sense. t…

I am trying to adjust my web pages to work with FM Sever Advanced 7 and FX. I need to find records within particular date range. I was able to do that with FMPro6. Right now I can FindAll, or use -eq without any problems, but the follwong does not work: $fmq->AddDBParam('date1', $start_date, 'gte'); $fmq->AddDBParam('date2', $end_date,'lte'); $fmq->AddSortParam('work_number', 'ascend'); $ReturnedData = $fmq->FMFind(); I believe all my other settign are OK because I can FMFind records for one date. What is not wokring is finding the date range. Please HELP... Thank you!

I've read throught the documentation in FX.php as well as the FX.php in 8 hours booklet and can not find a way to specify the sort order in my query. for example I have a link that has <a href="clearance.php?currentSort=prod_sku<?php echo $currentSearch; ?>" class="whitetxt">Model #</a> What I would like to add is a descend sort order. I understand how to use the AddSortParam but I do not know how to have this work in a link.

I would like to do the following find but it looks like Lasso 7 does not allow the use of the OperatorBegin/End tag when using FMP its proving tricky. Anybody have any suggestions? [inline: -Search, -Database='ChannelLines.fp5', -Layout='Web', -Keyfield='zk_channelLineID_p', -OperatorBegin='OR', -OperatorBegin='AND', -Operator='gte', 'channelStartDate'=(Action_Param:'channelStartDate'), -Operator='lte', 'channelStartDate'=(Action_Param:'channelFinishDate'), -OperatorEnd='AND', -OperatorBegin='And', -Operator='gte', 'channelFinishDate'=(Action_Param:'channelStartDate'), -Operator='lte', 'channelFinishDate'=(Action_Param:'channelFin…

In our custom filemaker solution using CDML, I want to create a Filemaker link in the filemaker database and have cdml correctly pass it through a browser. In the database there is a field called: relatedURL the cdml is: a href="[FMP-Field:Web_URL_Related_1]" target="-top">&nbsp;[FMP-FIELD: Web_URL_Related_Desc_1]</a> This works fine for any url except if I want a FMPro type url. I want to be able to pass a url that might look something like: http:// xxx.com/FMPro?-db=dbase_.fp5&-format=detail.html&-token=[FMP-currenttoken]&-lay=ForWeb&CatalogNumber=24346&-script=Web_English&-find The token is the problem r…

I'm using FileMaker Pro v6.x on a Macintosh. I've created a custom web solution using CDML. It's a simple form that I want people to fill out online. Part of the form is a list of available newsletters our members can sign up for. For this list I'm trying to use a check box field. Here's my CDML: </B></FONT>[FMP-VALUELIST: services, LIST=services]<INPUT TYPE=checkbox NAME="services" VALUE="[FMP-ValueListItem]">[FMP-VALUELISTITEM: Always, HTML] [/FMP-VALUELIST] The field displays correctly in the browser (any browser), but when you try to submit the form I get the following error: "Your attempt to edit a record failed because of the fo…

Add me to the SLOOOOW list. FMP6/WebCompanion/CDML 500 records, search, sort, calculate = 13 seconds to completion (finalized in graphic applet). Just converted the whole mess to FMP7 SA, using Lasso 8 and inline commands, 500 records, search, sort, calculate = 53 seconds to completion (finalized in graphic applet). This is unacceptable, disgusting and pathetic. This is a web-enabled example. I have spent a good 4 days hyper-customizing and streamlining this database solution - all energized by my faith in FMP - but it is waning - very, very fast. The XML Link to Lasso is sludgey chunky. Slow and plodding. Someone needs to get their act together. A warni…

Does anyone have a clue to fix the 5 records limit listing / 10 records limit in table? This is ridiculous. Can one use url syntax to request for 25 records and display as list view? I have done it before in Filemaker 6 but not sure in Filemaker 7. Currently using self-join relationship and then Portal in a layout to show 25 records. Silly.

I have a record_details HTML-page wich includes normal fields and pulldown menus. I would like these pulldown menus to display their value from filemaker. Now these menus are blank dispite the fact that the fields have previously given values. I just can't get these fields to display those values. Help? Example: <table> <tr> <td>Select<br> <select name='category' id="select4" value='[FMP-field:category]'> [FMP-Valuelist: category] <option [FMP-If:ValueListItem.eq.Field:category]selected[/FMP-if]> [FMP-valuelistitem]</option>[/FMP-Valuelist] </select>…

Hey everyone. I just started looking into IWP and when I try to view my database online, the checkbox fields are all messed up! Is their any simple way to fix this? The Word document attached shows the before and after (or FMP and IWP version). Word doc with before and after IWP pics Thanks for all the help! -Daniel

Hi, I'm a photographer and I would like to publish web based 'contact-sheets', which clients can view as a Form (whole image), List (I appreciate the 5 record limit per page) and Table with up to 20 images per page. To this end I have experimented briefly with the 'Free' Photo Catalog file, supplied with FMPro 7. I have to say I'm pretty dissappointed. The whole IWP thing seems very flakey indeed. For starters, the Table view doesn't work at all. No images show up (the images are referenced in the FMP/Web Folder as suggested in the IWP pdf). Secondly, sometimes the image height/width tags don't work, so the image is stretched out of shape .. someti…

Please be patient with me on this one people. Hopefully this is the right place to post this. I will not post elsewhere so in nec. please move this post. What I would like to do is after having someone receive an automated email from an FM action (which is in place) which would contain a link similar to the one below. The first link below is an example that pulls up a html page and finds a record. (That works) ----------- http://11.111.111.11/FMPro?-DB=Company.fp5&-format=/Acme/index.htm&recordID=1&-findall ----------- What I really would like to do is have the link perform an action (in this case set an approval field for a specified record i…

Hi, I'm using FileMaker 7, and I want the result to return rows where the date is 1/1/2005 and lock is not 1. I doesnt seem to be excluding the dates that arent 1/1/2005. Even when I add "date.op=eq", it still doesnt work correctly. Here is the url: ipaddress/fmi/xsl/a3/recordlist.xsl?-db=dname&-lay=wwwlayout&date=1/1/2005&lock=1&lock.op=neq&-lop=and&-find=Find What am I doing wrong? Thanks!