Custom Web Publishing

I have a database that is hosted on a FileMaker server online. I have 2500 pics that I reference by using imagewin when using as a desktop application. How can I get these images to show on the web. They are pics that are identified by a specific number such as 111111.jpg. That number belongs to a certain document so that picture shows up at that document when referenced. Not sure how to embed into my database so I can upload it and see it on the web. SOLVED: I found a script on the FileMaker forum.

I need to display dynamic price data from an established web source field into a FileMaker database. For example if the record in Filemaker has an ISBN number, is there an easy way to show the current Amazon price for that product in the FileMaker record?

I want to store link text similar to this in a text field and then have it work on a web page: Any suggestions would be appreciated. Thanks.

I have just discovered that a particular database we're hosting on our FMSA11 box (Windows Server 2003) has developed an appalling response time for XML-based web calls since migrating to this server. It worked fine when it was on our old server (FMSA8 on OS X Server). We're hosting over 70 other databases, many of them also publishing data to the web (I'm using FX.php), and this is the only file exhibiting this slowness. And by slowness, I mean over 15 seconds to return data from a table that has a single record and only 6 fields. No errors are reported anywhere, it's just really slow. I managed to isolate the problem to this file by rebuilding this one particu…

Hi, I have a problem with the Filemaker PHP API. I want to get the content of a value list. I'm using the following code : $layout =& $fm->getLayout('my_template'); $list = $layout->getValueList('my_list'); The list is imported successfully, however there are issues concerning special characters (accented letters etc...). For example : "Chargé de mission" will get imported as "ChargChargé de mission". "Animateur du réseau numérique" will get imported as "Animateur du rAnimateur du réseau numérique". When the first special character is encountered, the string is reloaded from the beginning and concatenated with what was alread…

I'm trying to find the best solution to send data to our main server from our runtime solution. I have a runtime solution that each user creates bids with. The users are not always connected to the internet so that's why they are using the runtime solution. I want them to be able to send the bid data to our main server once they are connected to the internet. I thought I would just use PHP to interact with our Filemaker server which is hosting the file. It also has web publishing (PHP) enabled. Could someone point me in the right direction on how to get the runtime solution to send the data via php to my main server? I'm not sure if I could just script a loop w…

Hi, I've got a recordlist.php page that outputs the found set of records as a table using a foreach function, pretty straightforward stuff which is working well. In one of the columns of the table I have a button that calls another update.php page which changes the value in one field from No to Yes (i.e. mark the record as "completed"). When the script has finished it returns the user to the previous page which reloads with the update details. This is all working well and generally happens pretty quickly but I would like to take it to the next level with AJAX and have it update the page dynamically without it having to reload/refresh the page. I'm not sure if t…

Hi everyone. This is what I've got and the story of my problem. I have a Solution with approx 2000 clients, 10 staff, 50 products and about 30 manufactures. It has Several Layouts, portals and relations. Also, script triggers and calculated value lists and validations. I got a host "MacUSA" but it takes almost 30 seconds just to enter the first layout. If I create new records it takes about 10sec before something happens and the same if I create new portal rows (ie. Note Utility) and just swishing between records has a delay on 5 seconds. I got 1 BIG portal that contains 4 checkbox fields, several dropdowns, popupmenus and text fields, many of them with con…

We have a database that is accessible online. People can search for records in our database and display them, e.g., as a table. In this format, the records are listed one per row, with fields as columns. We'd like the web users to be able to copy and paste these data tables into, e.g., an excel file, or text tile of some kind. This is possible, but the pasted text does not include any tab delimiters between columns. Each column is separated by a carriage return, and there isn't any special marker between records. This means the data appears as a single column, which is very user-unfriendly. Is there any way for the web user (as guest) to download the table in a use…

I have been developing and scripting my first database over the last several months and just began to test how it would work while sharing it from one mac to another across the web. I was astonished to see many relatively fast operations slow down to a crawl. A routine operation of medium complexity that took less than 3 seconds working on a single machine took between 25 and 53 seconds working remotely through internet sharing, and about 100 seconds doing the same through the free hosting site Neo Code. Is there any remedy for this slowness? I am wondering whether something in my scripts (perhaps using Refresh Window in a loop with Flush Cached Join Results selected…

PHP USER GROUP AT DEVCON 2010 Start Planning! Come show us something! For the fourth straight year, people doing Custom Web Publishing with PHP are getting together at the beginning of the FileMaker Developer Conference to share projects, tips, and ideas. DATE: Sunday, August 15 TIME: 4pm - 6pm (before the 6:30 keynote) ROOM: Marina 5 This will be a friendly, informal chance to share some of what we all have been doing with FileMaker and PHP. All web-related tools and technologies are relevant. Show us one of your projects. Demo a cool app that helps with your development. Bring us a challenge to solve. Impress us with some HTML5, CSS3, Mobil…

Hey, all. I'm trying to pull in values using the PHP API from a related database and it doesn't echo. Here's the code: echo '', ucwords(strtolower( $record->getField('A to x02A to x01A_PERSON LdrPsnOne::b01A_PsnNmFirst') . " " . $record->getField('A to x02A to x01A_PERSON LdrPsnOne::b01A_PsnNmLast'))),' ', $record->getField('b04A_LdrTitle'),' ', $record->getField('A to E_DELEGATEUNIT DelUnitOne::b04E_DelUnitDesc'),' '; $count = $count + 1; The fields in bold don't echo out, but the others do. Occurrence names for bolded fields go through two related databases, 02 and 01. I have made connections to those databases and…

When using either iwp or the php assistant on adv FMS 11, can an external data source in a solution (ie a MYSQL table) show data in the web pages ? I have so far been unsuccessful. It seems to only display data from native FM tables even though the solution is showing data in the layouts with the mysql table, the web page shows zero records. I dont know if im doing something wrong as in a bad/old odbc driver or if the functionality of what i would like is just not there ? appreciate any feedback as every call to filemaker has told me it will work but i have never seen it.

I have a php solution that has a layout in which the user can edit a list of records via a relationship. (FMPS 9) In other words, I have a campus (1 record) with a portal to teachers (many records)shown as a big list with just a few fields that are editable. I created this layout as a work-around having to edit each record individually. Everything works, the director at the campus can login, retrieve the campus list of teachers, and edit the fields on the list, no problem. The issue I have is that when I add a pop-up list, radio buttons or any type of value list, there is an error on the edit page. I have double-checked that the layout in FMP does have the valu…

I am using the FileMaker 10 Server with with the PHP API. Recently, we switched the PHP code to a machine (apparently) running a newer version of PHP, and now we're getting all these errors: Deprecated: Assigning the return value of new by reference is deprecated Is there are newer version of the PHP API that works with FileMaker 10 and doesn't use the deprecated syntax? If so, where can I get it? Thanks for any help!

Unable to access individual files via open remote on server, I think I have had this problem before and needed to delete a local file via terminal from somewhere in the library. No problem from other macs at different locations Can any one please direct me

Hi -- At some point many months ago I recall trying to figuee out how to share a FMP database on my computer with external users via the "Open Remote" feature. I also tinkered a little with Instant Web publishing. I don't currently need to be sharing any files with people in either (or any other) way. My problem: Whenever I open certain FMP files, I'm greeted by a dialogue box that warns "FileMaker cannot share files because another user is already sharing files using FileMaker Pro on this computer." Then I click "OK" and proceed as normal. How do I get this annoyingthing to stop? Does this mean I have a file somewhere on my computer where I have "Newt…

I created a new form and related database, using a working php form, originally developed with FileMaker Site Assistant, changing only the look of the form and a couple of the fields. I made the changes using Dreamweaver (CS4). I have done this several times with other forms, having perfect results. But this time, the new form works in Firefox and Safari browsers, but not in Internet Explorer. I'm at my wits end trying to figure out what is wrong. Any ideas? Could it be something new with CSS, which I found to be very non-user-friendly in the CS4 version of Dreamweaver? Thanks!

Hi, How can I make a search that checks from one field if it's prohibited (meaning that it will not show those posts) when I have like 3-4 different values on that field which I want to show $fm = new FileMaker(FM_DB, FM_HOST, FM_USER, FM_PASSWD); $findCommand =& $fm->newFindCommand('layout'); $findCommand->addFindCriterion('title', $title); if ($format) $findCommand->addFindCriterion('type', '=='. $format); $findCommand->addFindCriterion('type2', $type2); $findCommand->addFindCriterion('description', $description); $findCommand->addFindCriterion('rights',$rights ); like this $findCommand->addFindCriterion('rights' , "!…

Ok I searched the forums here and haven't found quite the solution I'm looking for. I'm relatively new at PHP, but I've been learning quickly as I go in creating this Filemaker API site. Basically the problem i am running into is updating values in a checkbox set on one of my filemaker layouts. When I do a find command and retrieve the data from filemaker, it gives me the checkbox values in what looks like a space delimited list, e.g. '214.0 214.29 215.9' Upon further investigation, doing a urlencode($returnvalue) i get this: '214.0%0A214.29%0A215.9' If I try to add another %0A and the next value to the end of the url encoded string, then send it …

Hi, My solution is on the net by FMADV server en IWP. I have different accounts, with different privileges. To filter the records they can see, I have a script that has to set specify fields. The fields that come out the original table don't give a problem, but if i want to set a field of a related table, the script can't find any records. If I test it on the local pc in the program of FM it works correct, but on the internet it doesn't go. How can I solve this? Thanks if anybody can give me some idea's.

Can anyone tell me if there have been any changes to the PHP API with FileMaker Server 11? if there were, are they backwards compatible? Thanks Todd

Hi folks how do you hide port in filemaker IWP? 1.I configure my DDNS to www.myddns.net:90 2.I put that URL to iframe inside my webpage www.web.com/index.htm 3. everytime i access www.web.com/index.htm, the filemaker break free and reveal www.myddns.net:90 any other way to hide port? i tried frame, somehow it didnt like it.

How can I upload a file into the filemaker DB? I have this php code that give the user the option to choose the file, how can I get that file into a record in FM? thanks

Hello - thanks in advance for the help, have spent dozens of hours trying to figure this out myself. Filemaker 10 Advanced on Windows - PHP publishing works through test, but test sites that I generate fail to pull up. At first I had trouble with IIS permisssions, had to enable "Anonymous auth" for the "Default Website" to get the pages to even pull up. Now I'm getting: Warning: require_once(fmview.php) [function.require-once]: failed to open stream: No such file or directory in C:inetpubwwwrootnewtesthome.php on line 6 Fatal error: require_once() [function.require]: Failed opening required 'fmview.php' (include_path='.;C:Program FilesFileMakerFil…

I have an events FM db that I would like to publish to the web. However, I cant find any dynamic ways to do this. I like some PHP calendars, but cant figure out how to connect them dynanmically to the db. This would be for a view only calendar.

Hey, all. Are you aware of any way to preserve Italic and Bold formatting of values in a FileMaker file when published to the web via the PHP API? Thanks, in advance, for your response. Michael

I am developing a site of Guest house management system using filemaker but some time script run and some time it's not working while it work correctly on filemaker application. What is the reason for this type of problem? Currently i am using trial version of Filemaker server.

Hey, all. I'm designing a system that will allow a user to upload a file via a webpage, and I'm trying to get the FM PHP API to automate an import and then read out to a result page the number of rows that were imported. I know that Web Publishing scripting doesn't allow import, but I wanted to find out if anyone had come across other ways to circumvent this limitation. Thanks, in advance, for your response. Michael

Anyone have experience integrate iWeb to FM data? I have potential client that has built his website on iWeb, but wants to allow some data entry and data viewing from his FM db. From what I've read of iWeb, it seems pretty limited...little custom HTML coding, separate CSS sheets for each page, etc. Is it possible to integrate with FMP directly, rather than just providing a IWP link?

I'm using the FMStudio API for PHP and have posted this in that forum (not on this site), too. I have downloaded my hosted database, cloned it, sorted records in the original, imported them all into the clone, renamed the clone to match the original, then uploaded the file and opened it. My PHP search page cannot access records in the cloned file. I get 401 errors. Is this normal? What is being changed when the file is cloned? I did find numerous differences in the file header of the clone and edited those to match the original, but that did no good, as far as I can tell. Same errors. I know that my host does something with the file's permissions before it …

I am running FMPa 10v3 on Mac OS X 10.6.2 Filemaker seems to be remembering previously used IP addresses in its network/IWP settings and messing up my ability to remotely connect. i.e. FM thinks its IP address is x.x.x.x when it is actually y.y.y.y I am including the network pref pane and you can see there are 4 IP addresses. Only one of them is in use. I am only connected to one network. IWP wants to use the first IP address listed in the network prefs, but this is not a valid address. I have tried deleting Web.pref and all FM pref files, but can't fix it. It could be an OS X issue, but I can't figure it out. Anyone have any experience with this?

Hello I want to use the IWP of my filemaker solution, I'm connected to internet with a cable modem that gave me my Internet Service Provider, I already open the feature of sharing and swith it to ON, the FM pro 9 advanced already has the url active with this IP address: 192.168.1.65:90. The problem is that If try to access from any other place with this address http:/192.168.1.65:90 IWP for filemaker doesn't work??? I suppose is a problem of the real IP address, because this is the classic IP that gives for default on every machine right? or I don´t know if is the port problem??? any suggestion, help please! Thanks Sincerely BluiSh

Are there any particular problems associated with optimizing a website built entirely from FileMaker Pro databases that have been exported as HTML, and uploaded to a server? Thanks for your feedback.

I'm sure there is an easy fix for this but I can't find it. I am trying to do a search using PHP. The search is an OR search in one field. If I were using Filemaker directly I would enter a value in the field, create a new search page, and enter another value in the same field. How do I do this using the PHP API?

I am completely stumped on this problem. I am trying to setup a simple PHP API connection with a Server (9.0v3) but I keep getting the same error when I use FileMaker::isError to verify everything is working. Communication Error: (22) The requested URL returned error: 403 - This can be due to an invalid username or password, or if the FMPHP privilege is not enabled for that user. I know the username and password are correct and that the PHP option is activated in the permissions. I do not have direct access to the server, but my client says he talked to the company that hosts his database and they assured him that the PHP API is active. It is currently hosted on…

Hello all, I'm trying to adapt a php osCommerce shipping module to FMP so that I can provide shipping estimates from within a FMP DB. The thing is, I don't know php or xml, I also haven't really had the chance to play with the PHP, XML or even web viewer part of FMP, so I need some help. The php looks rather simple, it forms some XML using the data provided, uses an HTTP POST to send it to the Canada Post server and then parses the resulting XML back from Canada Post. I'm pretty sure I can accurately recreate the XML with my data in FMP. The part I'm not sure about is how to send it and get the reply. The php goes like this: /* using HTTP/POST…

I have a situation where the only method to push third party app data to FileMaker is via a web form. I have looked into instant web publishing and while the login bypass is well documented, posting form data to a IWP page directly is not, and perhaps not possible. So my question is this, I have a one shot webform that can be anything and I need it to both login into the database and post new records. Can this be done? The third party app doesn't offer any ODBC or other functionality associated with passing data, and while it does have SQL backend, the function cannot be scripted into the UI to update real time between the two apps. My first thought is XML to…

Hey there, I'm new to FM - is it possible to create a DB with FM, which I can set online like a webshop-system? I have to decide to build a webshop in Flex or in FM and maybe FM is much easer to build a DB/Webshopsystem as in Flex!? But I'm not sure if it's possible to build something like that in FM? If it is, what do I need on the server-side? A special OS? Could I use Linux or I have to use a Windows-Webserver? The Webshop is for products, which can be customize by the customers. Does FM supports a Scriptlanguage? So I could code a little program, that the customers could set up their text to the product und this tool would build a PDF an attach t…

I need to propose a method for my parent company to add orders to my FileMaker database as they are received on their web site. Is using the PHP API a good way to approach this problem? I am fairly comfortable with PHP and the FileMaker API (I have created a web site where my retailers can place orders, check inventory, etc.) I'm imagining their server would send an HTTPS FORM POST to one of my php files, which would parse the key/value pairs and create the record in FileMaker. Then I guess just use echo to output a "success!" message back to the parent company server (?) as if it were a browser? I'm guessing that could by improved by receiving the order in…

Can anyone please help with this which sounds simple...? I am displaying record details of a FileMaker record using php api. I would like one of the fields in a record to be a hyperlink to the field's contents which is a URL of a pdf document. This is my base code without the appropriate hyperlink. The actual FMP field name of the URL is httpForm. <?php echo $record->getField('Form'); ?>

I am new to FileMaker via PHP so please be patient with me. We have a FileMaker XSLT page which shows data from a single record. I have used a form to post the recordID from the XSLT page to a PHP script. The PHP script sends an email and then redirects to a static page which indicates that the email message has been sent. In the PHP script I am trying to figure out how to use the recordID to call our FMSA 10 for the contents of the email field which will be used of course as the TO: address for the generated email. I see from the documentation that I will need to tell the PHP page how to contact the FMSA10 and then presumably actually call for the data. …

Hello, We have a FileMaker Solution and are using the FileMaker PHP API to produce a custom site. Certain fields, like a module's name i.e. "Contacts" have their labels stored in a record that gets generated as they log in. So the record ID is seemingly random. The only way to retrieve a record's data, as far as I can tell, is to use: $record = $fm->getRecordById('LayoutName',recordID). I see there is a method newFindAnyCommand('LayoutName'), which might work except this does not return a FileMaker_Record, but instead a FileMaker_FindAny class. I hope I'm being clear enough, still getting used to the FM API here. Thanks for your time!

I've just noticed in my FM Server logs the following Publishing Engine Error: FM Web Publishing - - wpc1 Web Scripting Error: 4, File: "Contacts", Script: "On Close Script", Script Step: "Adjust Window" I'm familiar with scripts and which script steps are compatible with Web Publishing. However I'm not clear about when either the OnOpen or OnClose scripts that you can set in FileMaker Pro via the File menu > File Options > Open/Close tab are performed with PHP API clients? It appears that my OnClose script is being performed but I haven't setup any script calls in my PHP pages - I know the "Adjust Window" script step is not web publishing compatible, but I…

Hi all, I have been creating a php script that would get a username and password, then authenticate against filemaker by running a command and check to see if an error is return. My code is below: $errorcode =""; $errorcheck =""; require_once('Filemaker.php'); require_once('FileMaker/server_data.php'); $lcc = new FileMaker('lcc_applications_.fp7', $serverIP, $_POST['name'], $_POST['pwd']); $record = $lcc->listLayouts(); if(FileMaker::isError($record)) { $errormsg = " Incorrect username or password"; $errorcheck = $errorcheck."1"; } else { $errorcheck = $errorcheck."0"; } if($errorchec…

Apparently, our hourly server backup which pauses the database is causing our PHP web clients to receive a fatal error (as opposed to the FM clients which receive a "coffee cup"). I would imagine this is common and that there's a best practice. We appreciate all comments, Barbara.

HI I have a problem. I have set up streamtime custom web publication, the login page apears but we get no further... Filemaker gives this error... one odd thing is the web site, and filemaker are on ip address 192.168.0.89 the router is at 192.168.0.1 anyway maybe someone can shed light on this ? Thanks...

I recently wiped and upgraded our Xserve from Leopard to Snow Leopard, and re-installed FMServer v10 – local and remote client access to our databases from client machines is working 100% fine. On the previous (Leopard) system, I had created a CWP solution allowing viewing of record lists from our database. This was created using PHP Site Assistant, and then the layouts customised to suit. Before wiping the system, I backed up the folder of files for this solution and had thought (foolishly perhaps), that all I needed to do was put them back into the /Webserver/Documents/ folder, and all would be hunky-dory..... However, when I try to visit the site, I get nothi…

Is it true that custom privileges do not work in PHP CWP? I read that somewhere, but I couldn't find any more information about it. I have several users with a custom privilege set in my database, and I haven't been able to get it to work with my web pages, so I thought I'd ask the experts. Thanks, -Timothy Moser

I have used PHP Assistant to create a generic Web Site. Home Page, Find, Result List, and Find All. I would now like to modify the Find page so that one of the fields has a pre-determined 'Find'. On that page, I have 5 fields: Category, Item, Notes, Location, and Tag. I would like the Category to ALWAYS be "Assistive Tech" while allowing them to search for anything in the other fields. The reason being, this database contains a lot of stuff, but we only want to display the records in the Assistive Tech category. How would the html code be modified so that they do NOT have a choice is changing the Category field (I would like it if the Category field di…

Hi, There are several cases when FM script must be triggered from separate button on page layout or to put in action field script trigger. '<?php echo ("window.location="script.php"") ?>' name="another page" value="Script"> (code isn't show correctly due to coding symbols in it) Separate file "script.php" are involved to keep php code for script: /*** <?php $rec = $record->getField('Npk'); $script =& $fm->newPerformScriptCommand($layoutName,'List',$rec); $result = $script->execute(); ?> ***/ Separate file count rise if number of scripts rise. Probably somebody can give better solution -one …

Hello Together, I have published a personal data form from my fp7 database on the web. What I want to do is that people fill in their data and then submit the form to me; I would put a script behind the submit button so I would receive a notification email and I know when someone has sent their data. What I don't want is poeple to have access to any of the other records in my database. How do I do that and is there even a possibility that the person that logs into the web published database doesn't even see the navigation panel on the left? Thanks for any help, Andy

I am relatively new to PHP and run into a couple problems I cannot figure out: 1.) The First, Previous, Next and Last buttons lose the sort of the first page. If a User performs a find, the list comes up sorted by name, but when they click the NEXT button for the next group, those records are unsorted. I can see the definition of the function that controls those links in fmview.php, but I don't know how to modify it. Here is the code: function getStatusLinks($resultPage, $rs, $skip, $max) { $links = array ( 'first' => 'First', 'prev' => 'Prev', 'records' => array ( 'rangestart' => 0, 'rangeend' => 0, 'foundcount…

A certain field's data has disappeared in my browser. It's still there in the FM 10 file though. The data in that field had previously been displaying fine on the web. Note, it's just one field from each found record that disappeared, not entire records - the data from the other fields continue to display fine. The only difference between those fields which display and the one that doesn't, is I made some changes to its field definition to perform some text manipulation (it's an ordinary text field). If I recall correctly, I created a new calculation field using the Substitute function, changed that calculation field to a text field, deleted the old text fiel…

I have two files ( File A and File B ) where File B contains a set of calculated global fields that I use in File A. But for some reason if I update a global in File B the update is not reflected in File A via FileMaker PHP. I can see the update in Pro but not on the website. Any help would be highly appreciated. Thanks in advance Nanigi

Hi All, How can insert an array into a field? Is this possible? Or if not, How can I insert the array's data into the filemaker field? thanks RB

Hi Everyone, I ran into a problem with the PHP API for filemaker and the filemaker server. I wrote a basic script that uses a local account to query a table in the database that has 45 records. the layout I'm hitting is stripped down to just the fields I need (about 8). Whenever I load that page it takes about 3 seconds to return the results. If I have 2 simultaneous users it goes to 10-16 seconds to load the page, for both users. The CPU goes to 50%. On just a basic query. Why?! I'm running Windows 2003 sp2. 4GB RAM, Dual Core AMD Opteron 2.81Ghz (2CPUs). There is nothing else running on this machine. FileMaker Server 10 with latest update without …

I'm just getting my head into CWP with the Filemaker PHP API (should have done it ages ago!!), with the goal of being able to access our Contacts and Events data online, but I've hit a couple of problems. PHP is new to me, although I've learned a whole bunch by dissecting the Site Assistant generated code.... but I've hit a few issues which have me stuck! Problem 1: The first time I use the 'findrecords.php' page and enter my criteria, I move to the 'recordlist.php' page fine, but there's nothing in it.... refresh the page, and the data is there. Any thoughts? Problem 2: I duplicated the recordlist.php file (record_detail.php) so I can have both "lean" and …

I am building a solution in which users can edit club information. For security purposes, the data is first copied into a holding table by a FileMaker script triggered by a newPerformScript command. The record just created is the last record, so that is the only one I want to download to the user's browser. I had hoped that making the script create the correct found set would do the job. It didn't. There is not necessarily anything unique about the data in the desired record, so I can't figure out a way to create a php find request to get just that record. --Doug

I'm running into a pagination problem while doing a search on the same page. I have a single search box which queries both the first name and last name of a person. The search works fine. I also have pagination at the bottom of the page. I modified the pagination from here: Pagination_1 Pagination_2 The pagination also works fine. When I enter a search criteria, I get the expected found set and a modified pagination (as expected). For instance, when I enter "ba" in the search box, 11 records are returned and pagination returns a "1" "2" and "Next" (I'm showing 10 records per page). The problem occurs when I click on a pagination link (a number or …

Hi there. I ran into a problem recently and am unsure what Im doing wrong - and I know its me. I have FmPro Server 10 Advanced on the server, and the database is developed un FmPro 10 Advanced. I am setting up several small databases and want to publish them on the web, but have two problems. Firstly, the server doesnt put a tick in the web publishing column for some of the files. I dont know why, but wonder if its related to the port on which I specify (within the database), and on that note, do I have to specify different port numbers for each database being published? Please help. Greg

Hi all, I have a database file 1 using as an interface file with user menus in there. I also have another database file 2 that is a separate database system. I used a menu button in database file 1 to run a script in database file 2 to go to certain layout in database file 2. However, when this script is run in Web Publishing with "Status Area" disabled using a button on the menu, it always go to the first layout instead of the layout that I wanted to go to. On the database file 1, if I enabled "Show the Status Area", it works fine when I click the command button from the same menu. Does anybody know why it default to the first layout when you disab…

Hello, I'm brand new to filemaker, but am a pretty quick learner. I just have a basic question that I'm having trouble finding an answer to. I just started a new job and am looking to switch a Lotus Database and replace it with Filemaker. I am in sales, and we currently have around 16,000 records in the database. I showed my plan to my boss, and he liked the idea but after he did some research he didn't like that only 5-9 people could connect to the database at one time. If I were to upload the database to the web, would more than 9 people be able to connect to my database? I told him that the 5-9 connection limit was for when the database was on…

I'm trying to allow users to create comments for individuals. One individual may have many comments (which are timestamped). I have a web page with two buttons (see attached). One allows the user to update notes. This is a text field in the individuals table and is working fine. The other button is meant to create a new comment record. I've not been able to get this to work. I'm using Lance Halberg's excellent video tutorial by VTC; however, it seems that he does not cover adding related records in the tutorial. I found this site to be helpful - http://blog.expertzweb.com/programming/filemaker-api-tutorial-for-php - however, the author refers to a custom funct…

I know this seems like a very basic question, but I've searched and searched and read and reread and can't figure it out. I created a database that I need to make available to view and edit by 1 other individual. I changed all of the sharing settings to make the particular database available. I'm provided with a url to be able to view the database. When I go to the url on all of my home computers (mac and pc), it works fine, but the individual I'm trying to get to access the database cannot view it. I confirmed browser compatibility, etc. Has anyone experienced this before or have any ideas as to what might be the problem. Thanks

Hi Folks, I am running Filemaker 5.0 Unlimited on a Windows server using custom web publishing. Recently, some users accessing the page from Internet Explorer cannot access the pages or save the input into the form. It does not seem to affect Firefox or Safari users and the majority of IE users have no problems. Does anyone have any suggestions or should I just break down and buy a new version? Thanks.

Is there any list out there of mobile devices or Mobile OS's that can connect to a FileMaker-generated PHP site? Got a customer with Blackberry's and they can't connect. Seems odd that there wouldn't be a list of "good" and "bad" devices. Thanks!

I want to collect data from a web form. What do I use to post data to the FMPro database so that it writes new records to the appropriate table?

Hi everyone, I created a couple cheat sheets that I think you will find helpful : The cheat sheets are a perfect quick reference - for pro's and newbies. http://www.fmgateway.com/API4FM.pdf http://www.fmgateway.com/API4FM2.pdf Enjoy! In Kindness Stephen Knight FileMaker Hosting Made Easy http://www.fmgateway.com 800.353.7950 Ext. 87

Hi there - would anyone know whether it is possible to have the php API working with FMS Server 8 ? If, yes, is it as simple as copying the API directory simply to the web publishing folder ? Server = Windows Small Business Server 2003 I am trying to persuade them to go with an X Serve, and upgrade to FMS 10 - but, you know bosses... many thanks in advance Glorifindal

Hello : I already have a solution in high school working areas, but right know my client is asking me for a new website and to use the system via Internet, they want to consult grades and another features of the students. They need to use all the solution via Internet. I know that exist a lot of options to do it, but I don´t know exactly from what point to start or what is the best option for me. 5 years ago I use CDML, but now exist FM web studio, php api, fx.php, lasso, etc. I use dreamweaver to design my websites, and first than anything I need to design the website and add filemaker to it, i should use PHP??? or Lasso??? and finally do I really nee…

Hi All, I get this warning after my php script runs: Warning: Invalid argument supplied for foreach() in /Library/FileMaker Server/Web Publishing/publishing-engine/php/lib/php/FileMaker/Implementation/Command/AddImpl.php on line 9 Can someone help tell me whats going on? In the php script I have several API commands that create records.(newAddCommand) Also these commands are in one php function? (is that the problem maybe?) thanks RB

Hey All, I have a some script that use setField command for data entry, but one of the fields is a (auto-enter calculation replaces existing value, evaluate always.) and I cannot enter in data from the scripts into this field. Is this a filemaker bug or am I doing something wrong? thanks Ricky

Okay, this might be a little bit complicated. I'm trying to save an image taking from a container field to my local disk. I know it's possible to save a picture to a specific location with PHP but I can't pull it off with a URL that gets an image from the FileMaker database. That's because I need to insert this pic into a PDF created with TCPDF and TCPDF requires perfect HTML in order to work, meaning calling makes it fail and tell me image.php? isn't a picture.(I know it's not the exact line). Now I can't really save the pictures locally and just put a reference to it in the database because the picture in this field can be modified by my clients, and it's imp…

Total noob with questions galore... I am tasked to research the value of various applications with the goal being the creation of a PC hardware/software/maintenance database for use by our organization. I am so woefully ignorant of FileMaker than I am ashamed, but I hope someone can give me insight. Here is what we envision... We'd like a database whose front-end is graphical in some way. If it can operate on the web, that would be excellent. We envision using it on smart phones (iPhone, Android, Windows Mobile) as well as PCs/Macs. The interface would have a homepage showing a map of our complex. One could click on any building and then be taken to a diag…

Hy How can a find request be done with the php API which allows the following query: "give all records where the field User is xxx an the Status is not released (there are other status like "in work" , "in test" , "accepted" etc)" Any suggestion ?

I am trying to use Javascript to validate a form, and stop the user form submitting an invalidated form. The problem is that the JS validation uses the "name" parameter and requires it begin with a letter. Filemaker seems to require that the "name" be a number. This is an example of the input code in the editrecord.php file: "<?php echo $record->getField('agency_department', 0) ;?>"> This shows on the live page as: So "name" is 1. The JS validation (and w3 standards) want "name" to be a letter, not a number. We tried changing the name to a letter which resulted in no data going into filemaker. Is it po…

Hi there - I am using the Filemaker php API to create a select menu and populate with options - However, it also returns lots of empty values - where the field being used is empty. How do I add an omit to the php ? here is my current code - which does not work : $fm = new FileMaker(FM_FILE, FM_HOST, FM_USER, FM_PASS); $find_lands =& $fm->newFindAllCommand('COUNTRIES'); // $find_lands->addFindCriterion('COUNTRY', "="); // $find_lands->setOmit(true); $find_lands->addSortRule('COUNTRY', 1, FILEMAKER_SORT_ASCEND); $result_lands = $find_lands->execute(); When I run that - I get Fatal error: Call to undefined method…

Is it possible for my databases that I have created on FMPro Adv 10 to look and act the same as in FMPro Server 10 Adv.? I have IWP my Databases and its a completely different look then the original i have created. Thanks for the reply.

I just started working on publishing data via php. I built a solution for in-house use using the separation model. I figured I'd do the same for php starting with a blank ui file. I have no problems pulling data out of the ui file, but anytime I try to pull data of of the data file, I get "Field is missing". I googled it. Found something about about using TO::field name. That didn't work. I tried accessing the data file directly via php and that seems to work just fine. But I would really like to keep my php layouts in a separate file. Anyone know what the problem is?

Hi all, I have a cwp solution using the FileMaker PHP API connecting to file hosted by FileMaker Server 10. The web server is outside of a firewall and the server and wpe are behind the firewall. When I use a couple of development environments as the web server everything works fine. Moving the web pages to the production server causes the container fields to no longer render. The only differences I see are the production server is running php 5.2.10, versus 5.2.9, the apache api version number is different (but both development and production are running apache 2) and the production server is a virtual server running linux. Development servers were either mac o…

Hi. I'm new here and a complete filemaker neophyte. I have been asked to find out some information for someone. There is a co-worker of my brother who wants to create a membership site for information he has collected over the past 15 years. Here is what he tells me: "...The data base I developed is a relational data base presently using File maker pro 7, it was originally created some years ago in Paradox. I have over 33,000 entries. the data base is designed to have short answers to questions ... as a quick research guide. The data base is broken up into 4 fields. It has the ability to be searched via key word in any or all of the fields eithe…

Has anybody tried to visualise data stored in Filemaker by making the data available to IBM's ILOG visualisation software - either directly or via the Adobe Flex environment? I'm looking, but I can't actually see any way of allowing ILOG to see the data in Filemaker. Many thanks in advance, W.

Sorry if this should be posted elsewhere but this seemed the most relevant sub forum. We have Filemaker 7 and have been using it nicely for a number of years for project management. Now, our main client has asked us to look into creating and on-line image library of all their images that we hold on our in-house server. So, what I'm wondering is, can Filemaker be used easily to create an in-house image library that can then be published to the web. The web front end only needs to offer thumbnails and 800x600 low res images, the client would contact us direct for high res images - this also protects us and keeps the high res images in our studio. If anyone has exp…

Having created a fairly successful iPhone version of our database, I've duplicated and tweaked one of the PHP pages with the intention of allowing particular clients to access information about their booked events. I can't post code here (wrong Mac!), so please bear with me..... To allow multiple 'online' users, I've created a generic account within FM, with PHP access privileges only. My original 'eventslist.php' page requires username and password authentication, but my 'tweaked' page – "clientevents.php" has the generic PHP account authentication embedded in the page (i.e. $userName = 'username' etc.). I can then send individual clients links like http:/…

hello, I've got a FM database up and running with PHP Site Assistant but now i want clients to be able to login to the database and only see the records that have the same Client_ID, how do i do that ? Kind Regards, Zero

This has really got me stumped. I am trying to create a new record from our website when someone fills out a form. I've done this before, but for some reason every time I try to do it I get a Filemaker Error 101 Record is missing. Here is what I have $form = $fm->createRecord('Web.Forms'); if(isset($_POST['HomeNum'])) $form->setField('Contact.Home', $_POST['HomeNum']); if(isset($_POST['MobileNum'])) $form->setField('Contact.Mobile', $_POST['MobileNum']); if(isset($_POST['Email'])) $form->setField('Contact.Email', $_POST['Email']); ... $result=$form->commit(); if (FileMaker::isError($result)) { $error=$result->code; echo " Error $error: " …

Asked this a few years back, but thought I'd ask again, if anything has changed now that 9/10 is out. Have a simple webform that collects standard usual user info (name address, etc). Am looking for a way for end users, via a web page, to be given the option of uploading a Office file to append to a container. Any suggestions? (SuperContainer is too expensive, and the volume is too low <40 to justify it.)

My database as it exists on my computer allows users to search one field that is in the checkbox format (all the others are just text fields); but online, no checkboxes or even the labels for the individual checkboxes, are visible. There has to be a simple explanation that I'm just missing. Also; is there a standard web-compatible script for saying no records were found? I've asked this before but could not get any of the answers to work. Thanks!

I'm a little stumped here. We're trying to get a version of our application that would be 100% web and would cost MUCH less, allowing us attract small companies or companies with money problems. One of the main features our of software is the ability to print the list of produts(It's a database filled with that client's toxic product to print MSDSs and labels). Now in FileMaker it's pretty much instantaneous. In PHP it's a completely different story. While I have no problem making a list of 25 products with a previous and next buttons, the problems arise when I'm trying to load the list that will be printed. While I can load the print page with a list of li…

Hi there, Just looking to use a simply php theme to create a basic site. I want to modify the theme a bit to look more like our company's site. I am generating the site to: /Library/WebServer/Documents/Backup Library The bizarre thing is when I change the images in: /Library/WebServer/Documents/Backup Library/images nothing happens! I can delete the entire images folder, and the site is not affected. Where else would all this be stored? Is FMS 10 storing all the web data somewhere else now? I am kind of confused. thanks in advance for any ideas.

I want to put a carriage return into a text field using set field, like this: $currentRecord->setField('tActivity_Log', $text . "Carriage Return"); What do I use in place of the "Carriage Return"? Thanks!

I have just started to use IWP, but people visiting get all sorts of warnings from their browsers. How do I get around this issue as it's frightening people off from using the site?

I still can't figure this one out: http://fmforums.com/forum/showtopic.php?tid/210459/ If I have a fresh, clean, virgin record that I have not edited via php, I can successfully edit it via php once. If I try to edit it again via php, Filemaker returns "Unknown error." Even if I log out and back in. Even if I go in and edit the record from within Filemaker, it still won't let me edit it again via php. Is there something that should come after the commit() to free the record up for editing?

So, I have a database that gets his informations from another database, then I load information from that first database. There are fields on it that are huge, and contain up to 8 pages text if it was a standard text document. When I load my list of records I need to download between 50 and 100 of these records and it turns a 2 seconds search into a 30 seconds search. Really not user friendly. Anything I can do to help the loading speeds?!f

I've got a Win2k3 Server. I installed IIS and then installed all updates on the machine. I then proceeded to install FMS 10 and ran the deployment wizard. I let the deployment wizard install PHP for me and it says that everything is successful and gives me green lights at the end, however, when I try and browse localhot at that point IIS returns Service Unavailable and the PHP API returns Communication Error (22) and says the WPE service isn't running. I've gone through this a few times now and after first installing IIS it runs fine but then after letting the FM deployment wizard do its thing it always ends up with Service Unavailable and I can't even get IIS…

Hi all, Is there a limit to FileMaker's API for PHP/CWP in terms of searches to related tables? It seems that I can search "1 relation deep", but I can't go "2 relations deep" I have three tables: STUDENTS, ENROLLMENTS, and PROGRAMS. The first, STUDENTS, has a single->many relationship with ENROLLMENTS (since students enroll into subsequent semesters). ENROLLMENTS has a calculation field bringing in the Location of the Program to which the student is Enrolled with a single->single relationship to the PROGRAMS table. The field that I'm searching is a calculation "lookup" based on the ProgramID field that the ENROLLMENTS table holds and matches to a uniq…

does anyone have a good way to line up all the checkboxes that are generated for a field. I have fields with 10 checkboxes in some cases, and they just wrap. Ideally, I'd like a couple columns of fields, but for now, I'll settle for 1 column

So, we are hosting a web version of my company's application that works with a FileMaker database and recently we acquired a new server and for some reason(I don't know technical details, I'm not server-guy), the current version that works with FX doesn't work, so I was asked to make it work with the PHP API of FileMaker, which does work on that server. Now I'm not a FileMaker programmer, so let's net get highly technicals with stuff I won't understand. I'm a web designer that never used much classes and object, which could explain my current confusion. I'm trying to get records from the portals on specific layouts. I can already get portal-less information but …

I'm using the API to create a simple logging system. I can retrieve records from the database specified in the 'connection' php file, but I need to retrieve some related data from an external data source; another machine in my office. Both machines have Filemaker 10 Server installed and the API set up working fine. I can also view the related information in Filemaker without a problem, however, no records are returned using the API and I have a feeling that this is not possible - is this correct ? :joust: