Custom Web Publishing

I've created a search form with the FileMaker PHP API as part of an upgrade from a .fp5/CDML site. In the previous site you could click the Enter key on the keyboard and it would execute the search/submit the form if you had clicked outside of any of the search fields (some drop down lists, some normal fields). In the new PHP site the Enter key does not do this when you have clicked outside of the search fields. It does work if the cursor is inside a normal field but not when you click outside. Does anyone know how to get this functionality back so the site continues to function as before in regards to clicking the Enter key on the keyboard when you have clicked…

Hello, My solutions is a 28 mb database that loads painfully slow (the clone without records is about 5 mb). I'm hosting the database and only have 2 clients. The host machine is mac pro (3 ghz quad core, 16 gb ram) with FMP 9 sharing via TCP. This solution takes about 10 minutes to initially load with both the server and client having at least .5 mbs upload/download speeds. When loading locally, the same computers only take about 5 seconds. The client machines are both Macbook Pros (at least 2 ghz with at least 2 gb ram) with FMP 9. I understand that the following question has a lot of variables, so I'm not looking for a definitive answer, but even some good r…

Hi, I am logging into my database via filemaker remotely and I can't seem to add images. I can add text but the container that hold the image can't seem to be selected so I can never insert picture. seeing if anyone has any thoughts. thanks!

Greetings, I am using cron to call a php script which in turn calls a filemaker script on a database on fmserver. This workaround is because I am sharing the server and don't have access to creating a schedule. The script appears to run (it writes start and finish time to a log table) but the subscripts it calls don't run. All the script steps are web compatible. Any ideas? Thanks Pete

I am working on a project that asks for a student to enter their ID before they can vote in the contest. They first thing that needs to be looked at is whether the ID exists as a record in the table. Then the user must have less than 11 total votes which is a field. I am trying to figure out where and how to put the logic to display a message if a. the student does not exist and b. if the student exists and has more than 10 entries already. I would like for the message to display on the original page that the submit button was pressed. If anyone has time or ideas on how I can complete this project, I would appreciate any help I can find. My stru…

In FX, you could use $PubFind -> AddDBParam('PubStatus', 'Killed', 'neq'); to find all records where PubStatus does not equal Killed. Adding a third parameter in the FM API like this: $PubFind->addFindCriterion('PubStatus', 'Killed', 'neq'); produces an error. Then I tried: $PubFind->addFindCriterion('PubStatus', 'Killed'); $PubFind->setOmit('TRUE'); mimicking the way you do it in FileMaker. That errors too. I guess the setOmit must be part of a compound find. I could build a compound find but that seems fussy for something so simple.

Seems like this should be easy, but I can't figure out how to do it. I have a layout and it has a portal to a related set. I want to perform a find that returns records that match a field in the related set. For instance, I have a students table and an applications table that is linked to the students table. I have a layout displaying data from the students table with a portal to the applications data. How would I return the records from this layout that have have applications submitted in the last week?

My service provider just moved my html and PHP files off the filemaker server. From what I have found so far I just need to add a line of code: $fm->setProperty('hostspec', 'http://fm**.*****.net'); But it is not working. It serves up a blank page. I'm also wondering if the FIlemaker require call needs to be adjusted: require_once ('Filemaker.php'); These files began with the Filemaker Site assistant and I'm wondering if the fmview.php file is an issue also. It is referenced by a "require_once 'fmview.php';" call My provider gave me 2 hours notice!! So my site is now dead!

Is there a way to have 2 web server machines pull data from the same FileMaker database server? is it as simple as running the FMS9A installer and adding another Worker machine, or is it way more complicated? We are looking to segment off some of our sites, and if we could just connect another Apache server to the existing database server, that make a lot of the bosses happy. Thanks, ~Mark

Hello all, I'm going to update my web platform to filemaker 9 advanced (currently using FMSA 7): is there any change that I must consider before upgrade server? Will my web pages work properly? Which are the difference between 7 and 9 in XSLT publishing? Thank you in advance for your replies.

Hi all, Is anyone aware of a way to display php data (created with php site asistant) in a html calendar form, somehting like what phpicalendar outputs? The ultimate goal if to have a read-only calendar displayed on a web page, but multiuser(probably login based for finding this user's calendar data in the FMP report) I have a local script working that exports fields data to phpIcalendar per user name, but i'd like to improve and have the data refreshed automatically, server side.. Maybe finding a way to generate a "calendar" template file in the php directory of my site that would be parsed and placed in the right days in a month view. (…

This may seem like a simple question (or solution), but I'm stuck... We have a database and files, hosted using FMP 6 Unlimited (using Web Companion to serve the files). We'd like to have web users search, add and edit records on-line. In addition, we want a few administrators to have access to the actual database to delete, run scripts, etc. (basically, admins gets full access via remote host; web users can add, edit, and search). I'm not sure what the best way is to secure the database.... using the FM security databases, or access privileges. I don't want anyone to be able to access the database remotely, so I want it password protected. At the same time, an…

I'm working with an FMSA9 server located at my client's building. I've got a test server of my own here in my office that I've been using to develop and it's working great with their FMSA9 w/ the PHP API. We recently installed a new server for them to use as their production server and I cannot get the applications to work on this new server for some reason. FMSA is simply returning "unknown error" without any error code. When this first happened I realized I never did install the WPE onto the new web server so I went ahead and did that but it didn't fix the problem. Any information on what's going on here would be greatly appreciated. Thanks!

Hi all, I am using Filemaker Pro 6, with IWP. I really like the "Blue and Gold 1" Template, but would like to move some categories in the search and table views around. Where do I find this and edit it? Thanks Heeter

I've created a site that's working well with the PHP Site Assistant. It sets the search page method to POST - I would like to change that to GET. I gather some changes would be required in the fmview.php page (I can post this if needed) but not sure if this is possible and where to start. Has anyone attempted this before or know what changes to make? Thanks, Steve

I have a date field on a search page that was created with the PHP Site Assistant. I want it to use the DD/MM/YYYY format as that is how the database is setup and all our computers use that date format. I've just discovered by comparing a search via the web browser and a search in the FileMaker database that web searches on the date field are using the MM/DD/YYYY format instead of the DD/MM/YYYY format. On the findrecords.php search page there is this PHP code which I presume is relevant: // formats for dates and times $displayDateFormat = '%d/%m/%Y'; $displayTimeFormat = '%H:%M'; $displayDateTimeFormat = '%d/%m/%Y %H:%M'; $s…

I have a site created with the PHP Site Assistant working well that allows users to search from a number of different fields. I would also like to create a number of static links that can be clicked that perform a search based on some static criteria but I'm having trouble either getting the correct URL syntax or overcoming some limitations of how the Site Assistant works that I'm not aware of. All the different URL's that I've tried always return all records. Here's the latest ones that I've tried: http://192.168.0.53/website/recordlist.php?action=find&author=jones&-lop=and&-max=20 http://192.168.0.53/website/recordlist.php?-db=Articles&-la…

I'm having trouble using getFieldUnencoded in a recordlist.php page (it works fine in my browserecord.php page however). If if I have this in my recordlist.php page: <?php echo nl2br( $record->getFieldUnencoded('source_with_URL', 0))?> I get this error when trying to view the page: Fatal error: Call to undefined method RecordHighlighter::getFieldUnencoded() in C:Inetpubwwwrootsiteselected_records.php on line 115 If I change it to: <?php echo nl2br( $record->getField('source_with_URL', 0))?> I don't get the error but I don't see the field, which contains HTML. I suspect the problem related to this at the top of the table …

FileMaker keeps using this =& operator, which some research indicates is called a 'reference'. But FM doesn't seem to explain when and when not to use it. Also my research tells me you can get into trouble using this in some circumstances, and others say it isn't necessary as the parser takes care of the optimisation issue. My reading on it has done my head in. Has anyone got opinions on correct usage, and does it really improve performance? Michael

I'd be very grateful for help on this - I'm moving from a CDML system to php and am trying to do a find based on a user input field (record id) and a hidden field (expired). If the result for a record has the expired field set to 'no' then I want the browser to return a text string including the record details, if the result has the expired field set to 'yes', then to return a different text string . How do I do this? In CDML, I simply used [FMP-IF: expired.eq.no] Click on record id to view details [FMP-FIELD: record number] [FMP-ELSE] This record has already been used. [/FMP-IF] Any help / suggestions would be greatly appreciated, Thanks, George

Trying to get my head around these: what is the difference between createRecord and newAddCommand? I am assuming they do the same thing (could be wrong there), so when to use which one? Michael

Hello, I've attached a really simple test database and PHP file - it's simple purpose in life is to test the speed of requesting a FileMaker record approximately 200k in length using the FM/PHP API. As you'll see, the script is total bare bones - one findall request for the one record. I've hosted this test database and the PHP file on two different Windows servers - one a dedicated box and another that's a VPS. Both return approximately the same times, although the VPS box takes a bit longer. Server load on both of these machines is minimal to none. They are running the latest version of FM Server Advanced, and the web server and FileMaker server both run on th…

Hi, I brought one page in webviewer from yahoo. Which is good, but I need just the bottom infomation to be visible not the top. One has to scroll down and see the information. Is it possible that I could ommit (cut) or crop the above page and could show the exactly what i need. I wish we could have crop tool there, it would be great. Please help? Regards and thanks in advance. Tusif

I've only begun to dabble in FM with PHP so hopefully this is not to awkward of a question. I currently have a couple of very simple but long online questionnaires. With IWP to grab even a partial questionnaire I've broken them up in to 2 or 3 pages. First Page is usually name and contact info with a couple more of the important questions. If some clicks on my continue button I've grabbed the first bit of info and we'll contact them later to try and finish it over the phone. Is this possible in with FM and PHP? I've tried using the site assistant but it lumps everything into one page with a submit button. I'd really like to be able to break it up into at le…

Hi, I am trying to perform two separate finds on two separate databases from within one php script. It works, but itermittently I get the message: Error: unable to open file displayed in the browser. If I refresh it normally disappears. If I strip the code down to just perform one find on one of the databases it works every single time with no errors, on either of the two databases / search criteria. It just seems the combination of the two throws an occasional error. Here's the code: <?php include('Filemaker.php'); ?> Total Number of Projects <?php $fm = new FileMaker('xxxx.fp7', 'm…

I have this following situation in a FileMaker file: 1. User searches for and finds records in Table A. 2. User clicks a button in record row a1. This button is attached to script s1. 3. Script s1 has two branches: a. If there is a related record in Table B, script goes to this related record. b. If there is no related record in Table B, script creates a new related record, then goes to it. 4. User winds up in record b1 and layout b1 in Table B. How can I code this behavior in PHP? I get error 101 - Record is missing. I have this form snippet for page A. I have this PHP snippet for page B. $newPerformScript = &a…

Using this publication which does not have a forum So hoping some savvy participant has an answer here. In Chapter 10 Repurposing A Filemaker layout For The Web, I'm unable to get the example to update from the Web Browser. Also unable to turn on instant web publishing due to a port error. FMp Sever is installed locally/

This problem is driving me mad... I have Filemaker Server 9 Advanced installed on a new mac mini in a single-server configuration. Web Publishing via PHP is working perfectly, as long as I don't add the machine to a network. Using the included sample database, or a proven working PHP + Filemaker solution, I get solid performance as long as I am not connected to a network. Once connected to a network, all requests for pages referencing the filemaker database time out with a "server not responding" error. Filemaker databases continue to be accessible via Filemaker, and the webserver continues to run, but no PHP pages accessing Filemaker work. I have tried it on the…

hi, I am planning to make CWP Publishing with FileMaker. But I have some concerns, CWP is enough for a user friendly interface as FileMaker layouts or scripts. Most important issue is importing from an excel file. The user can import excels into FileMaker directly from web browser. But I dont know it is possible or not? Please illumine me about this. Thanks. Osman Cabi

hi. I have two problems currently. I have a text field called Filepath that is a calculation field that returns Text. calculation is simply that Filepath = thumbImage (which is a container field) If I insert a REFERENCE to a file into thumbImage manually, I get this sort of result but if I import a folder of images, AS REFERENCES, I get this: so, I was used to the difference when I EMBEDDED the pictures, versus Referencing them, but I did not expect a difference when I did a bulk import with references. anyway that isn't much of a problem until the next calculation, which is to create an URL so that you can find use OpenUrl to open t…

FX had convenient Next and Previous links that arranged all name value pairs and could be invoked by: <?php echo $SearchResult['linkPrevious'];?>">PREVIOUS <?php echo $SearchResult['linkNext'];?>">Next Does the FM API have an equivalent?

How do you sort records based on a value list? I've read that you can but I can't find samples. I've tried the following but get error 108: Value List Missing. $SortString = "Saved, Pending, Exception, Canceled, Approved"; $CourseFind = $webDB->newFindAllCommand('web_LIB_Browse'); $CourseFind->setRange(0, 10); $CourseFind->addSortRule('rt_Status', 1, $SortString); $CourseFindResults = $CourseFind->execute();

I'm a little confused about how to handle adding data to related tables in FileMaker via PHP API. I see that I can easily add data to Portals, but if the related table isn't displayed as a Portal, then what? For example, I've got an invoice layout. On this layout is basic information like shipping address, cc info, etc. This layout also has a portal on it display records from the related InvoiceItems table. So adding items to this invoice would be easy. Here's what I don't get, though. Our customer data is also stored in separate related tables but this information is not on a Portal. The fields are simply added to the layout. So if we create a new cu…

Has anyone got a decent FileMaker CMS web system out there that uses a WYSIWYG editor and stuff similar to Joomla. If so can you provide a link so I can see what can be done please with load times etc. Many Thanks Jalz

I'm using FMP 6 Unlimited running on Mac OS 10.2... we've been hosting pretty simple files directly from the FM 'Web' folder for years, and it has been working fine (creating new records, editing records, searching, etc.). We'd like to make some changes to the files, and use some newer functions (mainly html web functions) that we didn't need (or weren't available) years ago. It appears that FM Web Companion can't handle some basic html commands. For example, I've tried to use an 'include' command for a header. Dreamweaver recognizes it fine, but the page won't load properly on-line. I've also tried some pretty simple html pop-up calendars that won't load prope…

On my layout I have a field called ProblemList that is defined as a repeating field with up to 50 repetitions. In php I'm trying to insert a record into the table on this layout but I can't seem to do it if I include setting the ProblemList field with a repetition greater than 0. All of the "problems" I want to insert into the ProblemList field are stored in an array called $problems. I am looping through them and using the setField command to specify the repetition number. Here's my code: $counter = 0; foreach($problems as $problem) { $request->setField('ProblemList', $problem[1], $counter); $counter += 1; } On my layout, I have the P…

I apologize if this question is dumb but this is my first attempt to use FM and the web. I am just wondering if it is possible to use FM as a simple web authoring tool to create web pages: No fields, no data, no records, just 3/4 pages (layouts) with static info and hyperlinks to navigate from 1 page to the other. As a test I created a layout and tried to save it as HTML so I can view it with a browser but would not save. Does that mean FM can't be used as HTML composer or am I doing it wrong?

Hi, Ok basically I have a script NewQueueRecord which creates a new record in the JobMonitor table. I can run this script directly from PHP with no problems. However when I try to run RGA_Issued_4 which contains Perform Script NewQueueRecord, no row is created in the JobMonitor table. Both of these scripts run as expected within FM. So, does anyone know of a limitation when executing a FM script from within PHP that would cause a call to a subscript to fail? Let me know any other information that would be useful, I find that I usually miss something when trying to explain a problem *winks*

I used FX for a while and developed a technique of searching related tables directly rather than pulling data through a portal. It made for really simple databases - hardly any joins on the Relationship Graph. Now I'm using FM's API and the ability to interact with portals seems more robust than FX. Should I change my technique? Does the portal method have the advantage of speed or elegance or keeping with best practices?

I think if I ask for all the records that meet certain criteria and zero are returned because there are none, then this is not an error condition. I end up having to probe the error object to check the message, which I find to be a bad practice given the tight coupling. Can we not just rely on getFetchCount() to figure out if there were no results returned?

Hi Guys, I've developed a solution in FileMaker which I am porting over to the web. Im interested to find out if anyone has managed to get data entry into portals similar to that of lets say IWP (with the master and related records all on one screen). Thanks

Hi, I've used the PHP Site Assistant to create a simple site (this is my first time with PHP and the Site Assistant). On the search page I have several fields that the user can search on, one of them as follows: I would like to modify this so this field is searching for "greater than or equal to" for this Score field automatically behind the scenes (not sure what the default operator is?). I'm not sure where to add the necessary PHP code to make this happen and would appreciate anyone's help with this. Kind regards, Steve

Hello, I attended Lance Hallberg's session at Devcon this year and I know this is possible. He used FPDF. I want to allow web users to print mailing labels on demand. Any tips would be greatly appreciated. Thanks! Greg

We are looking to publish a simple shopping cart system using FMSA and php. One thing I cannot find addressed anywhere is how local US sales taxes should be applied to orders. My company has presence in 15 states, and we need to charge different levels of sales tax to purchasers from those states. In addition the sales tax can vary from county-to-county within each state. I know when I purchase something from apple.com I am specifically asked which county I live in for this very reason. I found http://ws.cdyne.com/NatTax/taxquery.asmx?op=GetTaxInformation which offers an api for this service. But I am wondering if this is the best way to go? So h…

I'm excited about learning/using the FMP API for PHP, but I'm stuck right at the beginning. : We have FM Server 9 Advanced and have been using it successfully for about a year now, but we would like to take advantage of CWP with PHP. I installed PHP with the original server installation, and when I go to the PHP test page in the server admin console it comes up successfully. However, I cannot open any other php pages on the server. I think I am just not putting the files in the correct directory. I've tried putting them in the IIS root directory: [color:red]C:Inetpubwwwroot and that didn't work. I've also tried putting them in the [color:red]C:Program Files…

CMU School of Music If you search back through this forum, I've had a number of posts related to a site I'm doing. Well, it's finally finished...er, up. Is it ever really finished? It's a mix of straight html/php and some filemaker stuff as well for event data and anything that has multiple records. Some of the coolest parts of the site are unfortunately only for students (authenticates across the schools Active Directory...), which include a locker check out with a GUI map of the lockers (attached image) showing which ones are available built from the Filemaker PHP API using some html table and css tricks. It also offloads a ton of work for my office so we don't …

Is it possible with the PHP API to do a find on two FM servers? My first find works fine $fm_it = new FileMaker(); $layoutName = 'webview_kell'; $fm_it->setProperty('database', 'db_name'); $fm_it->setProperty('host', '10.1.4.5'); $fm_it->setProperty('username', 'test_php'); $fm_it->setProperty('password', 'temp_pw'); I have tried to change the IP address in the host property for my second find to be the other FM server, and I get error 802(Unable to open file) The second server has the WPE enabled, firewalls/ports are not an issue as these are on the same network. Any thoughts or ideas would be great. I am tryin…

Hi Everyone, I'm using a standard installation of Filemaker 9 server advanced on a Mac OSX 10.4.11 machine When trying to test sending mail using phpmailer I get this error: Warning: fsockopen() [function.fsockopen]: unable to connect to ssl://smtp.gmail.com:465 (Unable to find the socket transport "ssl" - did you forget to enable it when you configured PHP?) in /Library/FileMaker Server/Web Publishing/publishing-engine/php/lib/php/class.smtp.php on line 105 Mailer Error: SMTP Error: Could not connect to SMTP host. It's the second SSL related error I get on this server. How do enable openssl on the server? Is it the way Apache is built or a PHP module ? …

FMWebschool announces 2 Free webinars back to back! First Webinar - Build an Online Survey System with FileMaker Have you ever filled out an online survey? Did you know that they are used on millions of websites to collect valuable information? Online Survey Systems are extremely effective ways to gather data. Surveys can be used to rate the quality of service provided by a company, used in scientific testing, or to help companies gather important data to be used on product innovation. In this webinar, we will teach you how to create a complete online survey system using FileMaker and PHP. The survey that you create will enable you to create yes | no q…

Hi I have been using PHP for only a short while and have not touched xsl or xml. I need to automate server9 to send an email on a regular basis to the same address'. I have found and used the xsl style sheet that that graham sprague wrote (http://www.grahamsprague.com/server_side_email/ser ver_side_email.zip ) and this works very well. But I cannot work out how to call this from within the server. I tired to create a script that called a page with a webviewer in it and giving it the url but this did not work unless I went to the database and went to that layout. I realise calling an xsl is probably straight but I cannot work it out and I have a limited time schedule at …

Hello, I have made the databases for my company's inventory in FM Pro 8.5 Now I am designing a website for them. I would like to find an easy way to publish our list of inventory on the site for customers from all across the USA to see. I see where I can export records to HTML format but one of my fields is a container which contains an image of each of our items. I really need to have that image with each record. I could always export to HTML then edit the HTML files in Dreamweaver and place the images in it BUT I have over 3000 items. I am really searching for a solution that wont take me a decade to accomplish. Can someone help me please? Oh yeah, we al…

I just don't understand how anybody gets any actual use out of FileMaker as a database back-end to a web solution. I've got a client that insists it has to be done so I continue to rip my hair out over this type of thing. Please tell me I'm doing something wrong. We've got an AMD Operton 2.8GHz server with 2GB RAM. I've got FMSA9 and the WPE running on this machine with a web server located off-site. I'm able to successfully hit FM using the PHP API. I can listDatabases(), etc. I have a database called Auctions. There are 228,104 records in this database. There is a field called Auction_Status and approximately 4,500 have a value of Current. I …

Hello Guys, I'm wondering are there any text editors out there that have the FileMakers API for PHP code snippets built in(or can be embbedded). I'm working on a PC at work unfortunately. Many Thanks Jalz

I am very new, so pardon if this is obvious, but I have a dataset of projects with various fields that describe the projects, included in each general description is a html link to the project site. My problem is the links do not work. I've tried dumping the data so the field is just the link, but that doesn't work either. Here's an example - http://oxford.seiinc.org:8012/baasc/browserecord.php?-action=browse&-recid=11 Do I need to do something special in the original filemaker database to make the html link active?

For security reasons I had to install the FM PHP API on a own Linux server with Apache + PHP 5. The database is running on a FMS 9 Adv. Up to now I was not able to get the stuff working. I put my own php files + the FileMaker.php and the FileMaker folder at the same place. When a open the php file with the browser I just see a blank page. The last performed line in the php script is always this: //create the FileMaker Object $fm = new FileMaker(); Has anybody a suggestion, what I do wrong or what is missing? The error messaging in the php.ini is activated, but i see no errors. Thanks a lot for any idea. Thomas

Hi all I am running Filemaker Server Adv 8 I am trying to install the Filemaker Web Server connector onto my new web server - this is running Windows server 2008 Web Edition So this server is running IIS7 When I try to install the Web Server connector I get the following error... Internet Information Services (IIS) is required and is not installed. Please install IIS prior to installing the Web Server Module and Administration Console. Has anyone had any luck with installing the WSC on IIS7 as it is obviously looking for IIS6 Anyone know of any workarounds? Many thanks Ed

Hey! Looking for suggestions for the best way to take form data, including a few file uploads, from a webpage, and insert them into a FM9 db at a hosting company. Seems like there are a few ways to do this (like a PHP script into mail.it), but looking for any/all suggestions. Anything more ovious I am missing? Anything easier? Thanks!

Hi php developers, I hope you can save me from getting crazy: setting: FM-Server9adv, php-api php scipt creates a new record in a table/layout with several fields (about 100), but with some date fields it doesnt work! date1, date2, date3 works fine, like all other textfields, but with date4, date5, date6 it is not possible to write into. same definiton of the fields, no checks write the same date/string to all fields even duplicated working field with new name doesnt work this is not a spelling problem error message says: "field not found" it is not dependend of the position in the write cycle, when doing a commit after every …

I can't get my CWP PHP connection to work...I am getting the following error which I cannot find any info on how to resolve. Any ideas? The PHP connection to the FMServer_Sample database failed. I do have a SSL certificate installed. Notice: Undefined index: message.error.fm.60 in C:Program FilesFileMakerFileMaker ServerWeb Publishingweb-server-supporttestfmi-testphptest.php on line 36 Any ideas?

I have a PHp solution that uses a login page(authentication.php) to log a user in. If the login is successful, no problem, go to the index page. If the login is unsuccessful, the page just refreshes. Is there a way to capture what FM returns from a login action?

I'm new to this and am trying to setup my server (server 2003 + SP2 + IIS). PHP is installed and running (5.2.3), the sample database works fine with their associated setup files but I can't get the PHP Site Assistant to generate files that work (even on the FMPHP_sample.fp7 file). I get a blank page when I try to load up the home.php file in my browser. I'd be very grateful for suggestions as to how to go about trouble shooting this one. I have updated all the programs - 9.3 for FM-SA and so on. many thanks, George

Hi, Using FileMaker Server Advanced 8.04. I have some databases published on our LAN using instant web publishing. These are very simple databases used by production staff who do not need full FMPro client. I also need to publish databases on the web for consumers using custom web publishing. The web server and webserver module would be on the Web (in our DMZ), and the Web Publishing Engine would be on the LAN on the FileMaker Server. Is it possible to install an extra Web Server Module and/or Web Publishing Engine (on the LAN) calling the FileMaker Server to serve the LAN databases? Or does all web publishing have to go via a single Web Server Module…

I've just spent the last day and a half figuring out how to use the container bridge to grab any kind of content out of a container field. (users who were only going to drop in images started dropping in pdfs, then someone added a ppt file for good measure). At any rate the container data gets added by one set of users via the FMP client and viewed by another set via the PHP API. Simply adding header('Content-type: application/octet-stream') to all .cnt url references caused Firefox to download the php file and was just ignored by IE. I used PEAR's HTTP_Request Package http://pear.php.net/package/HTTP_Request to come up with the following solution. &lt…

Hi Everyone, Social Networks are all the rage. Millions of people around the world flock to Social Networking websites to chat and upload pictures. Social Networking has also played an integral role for businesses. Businesses use Social Networking to meet alike professionals, network, market their businesses as well as introduce new products and ideas to a community. In this exciting free webinar, FMWebschool will present a live webinar demonstrating how to create Social Networking sites with FileMaker. In one hour we you will learn how to create login systems, enable online conversations, upload and download images and more. Once completed, the websi…

Are you a FileMaker developer? Would you like to learn more about FileMaker web publishing? This free webinar will demonstrate the power of FileMaker driven websites. Here’s how. One of the most frequently requested solutions we are asked to create are online registration systems. One type of registration system that is extremely popular and requested year round is youth sports and camps. Whether it be baseball, football, soccer, cheerleading or a summer camp, online registration is a must. In this live webinar we will create a youth registration system from scratch. This will be accomplished in less than one hour. There will be a question and answer p…

Hi: I’m in the process of communicating a remote office with the main office databases. But this is my first time trying to do it online, to this date we have been using a full backup in a Mac Mini and a complex set of export/import scripts of almost 25 databases (FM Pro 6). I have several questions: It is better to use the Web sharing and accessing the files using the browser? Even when the user interface changes? or using a remote address to access the open databases in the FileMaker Server using a VPN. (I’ve try this already and it is slow). Is there a way of estimating how much bandwith it is needed (Download/Upload) based on the amount/size of databases. T…

I've got a basic insert record script setup that was working when I initially set it up and now I can't get anything out of it. Not an error, not a new record. Here's what I'm working with: <?php include_once('FileMaker.php'); // Open file outside of web root which contains FM credentials. This is for security purposes. $FMCredentialsPath = "C:PATH_TOfmCredentials.xml"; if(!$FMCredentials = simplexml_load_file($FMCredentialsPath)) exit("There was an error opening the credentials file"); $APIUsername = $FMCredentials -> APIUsername; $APIPassword = $FMCredentials -> APIPassword; define('FM_HOST', 'filemaker.ourdomain.com'); define('FM…

I'm hoping someone might be able to help with a problem I'm having navigating the pages of a site and retaining the found records. For the purposes of sample code I've provided extracts from the findall page and the target details page which I have got working to a degree in that when the user clicks on the link to the details in the findall list only the record clicked on is retained as found. I will also need to achieve the same when a user completes an actual search as well. Thanks findall: <?php session_start(); require_once('include/inc.php'); $request = $senseDB->newFindAllCommand('List'); $request->setRange(GET('skip'), 15); $resul…

I am having some trouble displaying related images. The path information does not appear to be being passed as the images just display as a broken image icon in Firefox. The database server is running FMSA 9r3 and PHP v.5.2.4. In my details page I have the following code: $pix = $record->getRelatedSet('ImageLib'); foreach ($pix as $pic) { $detail .= ' [*]getField('ImageLib::myPicture')).'" style="width: 80px; height: 80px" />'; } The getimp.php which works in every other instance is: <?php session_start(); require_once('include/db.inc.php'); echo $dbConnection->getContainerData($_GET['path']); ?> ... and the images are…

Is it possible to enter PHP as data in a web viewer? I can open a PHP document on another server and have it execute, but I'd like to store the PHP code as calculated data. So far Im having no luck. I've tried pasting the following: "data:text/html,<?php echo 'hello world!'; ?>" But the web viewer just ends up being blank.

We are experencing very slow response from filemaker/php. Has anyone else had the same problem? We are running a relatively simple database as the only thing on a server. It is for a catalogue that is viewed on the company's intranet. When it crashes it strings up a whole stack of connections from IIS to filemaker server which are never cleared. Filemaker Server 9 Advanced, all updates installed. PHP 5.2.6 Server: 2ghz quad core Xeon 4gb Ram 2x 146g 15k drives in raid1 TIA

Hi All I have 2 tables: Article Article_Rights When i want to create a article I want to use that ID in Article_rights to create Rights for that Article This is what I have for creating the article: $request = $GLOBALS['db']->newAddCommand("Article"); $request->setField('Parent_ID', $id); $request->setField("head", $head_value); $request->setField("tekst", $tekst_value); $request->execute(); But how do I get the ID or create a related record in Article_Rights.. Within the same query or something ?

I am trying to get my web server operational. I have installed the FMServer 9 worker version on my IIS machine. When I go back to the database machine and try to deploy the web server I receive the following error: "web server test failed. Return Code: = -1" Any ideas what to check?

Hi, Is there any way to pull in 3rd party data from the web during a FileMaker script triggered from a browser (via FX.php or even IWP)? I need to pull in some data on-the-fly from Google Maps, depending on a user's address. Unfortunately it seems: A. I can't use Web Viewers (possibly because they are only rendered client-side and a browser client cannot process the results) B. I can't use cURL since the AppleScript script step is not web-compatible. Am I wrong on either of these points? Is there any other/better way to pull in data from a 3rd party website during a script triggered from a browser? Thanks for any advice. f…

Novice question. It is my understanding that FMS9 Advanced allows 100 concurrent users when using the WEB. How do enterprise-wide solutions which have many more users than that deploy or configure their solution? In otherwords, if I have 500-700 users, how do I do that with FM?

I've been making a website for the past few days and have recently run into a problem while trying to make files from a container field download with a specific name.ext. I've been using a modified version of the image bridge like I've seen others do that they say has worked. //the path is the standard urlencode(getfield) //typical database connection info here $dl = $fm->getContainerData($_GET('path')); header('Content-type: application/force-download; name="p.pdf"'); header("Content-Disposition: attachment; name="p.pdf"'); echo($dl); What I get is a download that has the name p.pdf but when it finishes downloading it is unable to be opened by …

I have a database containing item details that include a number of checkboxes which have either been 'checked' or not as required. I am creating a web interface using the FileMaker API for PHP and need to retrieve the checkbox information to display on the web details page. I am using the following code to try to retrieve the data: foreach ($records as $record) { $detail .= ' getField('dbaseFieldName') .'> Checkbox1'; I'm then displaying the data in the body of the page using: <?php echo $detail; ?> However, the checkbox displays as unchecked in all cases. Any assistance would be appreciated.

I've taken over a filemaker pro app that is deployed on a FM9 AS and accessed via the web interface layer. Most stuff if fine , but users want to be able to change their passwords and from what I see the change password function is either not supported in the web interface or the values must be supplied via some calculation thingy.... Has anyone sorted the problem of creating something to let users change their password?

I've been stuck on the syntax of performing a fairly simple find through the API. For our events calendar, I want to be able to find events that happen after today. What is the proper way of specifying this find? The line I'm having trouble with is $request2->addFindCriterion('Concert_Date', '>='.$today); What's the simpler way of asking this? Are there any solid resources for stuff like this? I have the book FileMaker Web Publishing and the white papers from FileMaker, but nothing seems to have an expansive resource for syntax. <?php $today = date("m/d/Y"); $request = $fm->newFindRequ…

It appears that there are two separate ways of sending emails from CWP and I'm looking for advice on which way I should use, PHP email or performing a FileMaker script to send the email. The data I need to send needs to be secure (i.e. not found on the web page) because I'm using a web form to send a lock combinations. PHP seems the easiest but it has two drawbacks... 1) I would have to figure out the PHP session/cookies or encrypting issues and.. 2) If a person needs multiple combos, they would need to send two emails. (which also may be solved with better php skills. The other option would be to have FM do the email creation and sending. I would need to …

Hi, Can we integrate Adobe LiveCycle and Filemaker. I think it should not be difficult. I downloaded the trial version and looked at it, its saving data as xml. But its sending file for when we click submit every time. Can we save there a data in just one file.. ? then I think, we will be able to import that file in filemaker.. any suggestion.. Thanks in advance., Tusif Ahmad

I've got a little app setup that generates an auction description using a dynamic template that pulls data from FM using the PHP API. I have a field in FM called Web_Page_Description that is being used to pull the basic description for use within in the description area of our auction template. The Web_Page_Description field is a basic text field. The problem is I can't seem to make it hold any formatting no matter what I do. If we paste information into this field from a web page it does its best to hold the formatting inside FM. Line breaks seem to work out, it even changes bullets into #'s. But then when I pull this field into an application via…

How do you compose a URL that will execute a find on one or more fields when it is published using PHP (or IWP)? I can't find any doumentation on this and I haven't had luck googling it; so please feel free to recommend the books that reveal the secret. I published a PHP site using the PHP Site Assistant and its find works, but the resulting URL only reveals the following: "http://somesite.net/PHPSite/test/recordlist.php" However, clicking the Find All link reveals the following URL: "http://somesite.net/PHPSite/test/recordlist.php?-skip=0&-db=TestDB&-max=20&-lay=TestLayout%20live&" What would I have to add to the URL if I wanted to creat…

hee guys !, I am now working with Filemaker for a few weeks and come up with a problem: i have this $request = $GLOBALS['db']->newEditCommand('Account', $_SESSION['user_id']); $request->setField('Username', $_SESSION['username']); $request->setField('Password', $_SESSION['password']); $request->setField('Email', $_SESSION['email']); $request->execute(); if(FileMaker::isError($request)){ $error_code = $request->code; if($error_code==500){ return false; } else { return false; } } else { return true; } I want that if the Date value does not meet validation entry…

I"m running Filemaker v6 on a terminal server (XP machine) and use CDML script to access the database within our intranet website. I log into the box via terminal service and let the database open with web companion enabled. The problem we encounter is that the database seems to need to be closed/restarted about every week or so. What am I missing?

Is it easy to run a script remotely on server using custom web-publishing? Is this now available in FMS 9, or is the Advanced server still required for this functionality? Could anyone give me a quick run-down on how this would be accomplished?

I am investigating the PHP Site Assistant. After created, without an error a site and placed in the webserver/documents folder, when I look up the index.html page in the web browser, it loads but it is empty. The php files all seem to have the right code (they are not empty files). I checked the php connection and php sees the db that I am looking for with the right layouts so I deduce that there is no problem there. I already have a php page being fed from the same FMSA and it works fine. There fore I can deduce that I have do have php. My problem arrives when I use the test IWP & PHP page. IWP returns a Forbidden, you do not have authorization to access this ser…

Hello Guys, has anyone managed to get PHP working with IIS and SSL enabled on Windows 2003. Imm having trouble, and can't see how to do this. I know I have SSL enabled as my IWP pages are serving up pages with the "HTTPS:" fine. My php pages generated with FileMaker Site Assistant seem to be producing an error 22. Can somone post who has it running post a step by step guide of how I can get it running. P.S the SSL in FileMaker Server itself is turned off. Many Thanks to all.....really scratching my head with this one.

I have developed a database that we are using for HelpDesk requests. I want to be able to publish it so every computer in the company has the application on it. From what I have heard is that we need to have FileMaker installed on every computer for this to happen. Is this true? Is there a way that we can do this without having to purchase FileMaker for every computer. We have upwards of 500 computers and that can get very expensive. Please let me know what I can do.

I couldn't get the PHPSA to generate a site that has passwords so I enabled the guest account and PHPSA llowed me to generate the pages. Now the issue is, how do I set the generated pages with a custom login/logout so that when a user logs in, they can view or edit only their records based on the login credentials? What I envision is a home.php page that will be used as the logger, then propagate this through the other pages. Thank you.

How do I add field data to html code? I have a database of products that exports an excel file used to upload information into an e-commerce site. I would like to include a field, in each record, that combines html code and the data from a couple of the other fields. I am trying to combine some static code with data that changes with every record. i.e., html text "Colors:" with the data from a field containing the available colors. How do I do this?

I am trying to create new word document using Filemaker PHP - API. My Code is as follows: <?php set_time_limit(0); try { ini_set("com.allow_dcom","true"); $word = new COM("word.application") or die ("couldnt create an instance of word"); print "loaded , word version{$word->version}"; //bring word to the front $word->visible = 1; //open a word document $word->Documents->Add(); //add some text to the document $word->Selection->TypeText("this is some sample text in the document"); ///$word->Selection->InlineShapes->AddPicture(".imageschart.png"); //save the document as sampleword.doc $word-…

I have a DB with 27,000 real estate listings. Created with Site assistant and modified a little. Doing a search provides a number of records in list view. Clicking next will go to the next set of 10. Clicking link will provide the detail page. Clicking back in the browser shows all listings not the second set of 10 as it should. Clicking Back botton again provides the second set of 10 as it should If you are viewing the first set of 10 records this is not an issue. It is only after going to the next set of 10 records Any suggestions? Also: Periodically the price of the house will show up as zero and some times it will show up correc…

Here is another periodic error with screen shots of the searches and incorrect results they provide. I do a search for a price range and a city. The city is the issue. The name of the City is "IRA". If I search for "IRA" I get no matches. If I search for "IR" I receive 126 matches including [color:red]IRA and St. Cla[color:red]ire and B[color:red]irmingham Again this is Periodically, not all the time. This error was with Safari on a Mac. I immediately opened firefox and performed the same search and received the correct results with 14 matches. This is DB with 27,000 real estate listings. Created with Site assistant and modified a little. I have rede…

I have a big scrolling text field in my FM database where users can store miscellaneous notes pertaining to help desk calls they are working. The Help Desk staff accesses this database using standard FM Pro v8.5. They frequently paste text from many different sources (usually email) into this big note field that they can refer to later on when working similar calls. Everything works fine and has been for years. Recently I built a PHP web page on our intranet (FM PHP) so non-help desk people can see view the details of a specific help desk call without needing to use the regular Filemaker Pro client application. This is a view only page of one record at a time so …

Running into a major issue with my site. Some of the data I need to display just isn't coming up when trying to display it. Its seemingly happening to calculation fields which are based on a calculation of another field of a referenced file. It appears to work fine on calculation fields in the same file. I say seemingly only because I have seen it working. For example, I thought I had it solved by adding the referenced fields onto the layout because they showed up when I refreshed my web page. But after trying it with another field, it didn't work, and then trying to go back to the first field did not allow it to work either. It appears to be some sort of bug. …

Oh man, I've been away from this for almost 7 years, I can't believe I can't find an example of this in my old work. I am completely drawing a blank. Any how, I'm simply modifying a form submission (CWP / XSL / FMServer Advanced). How do I change the operator on a form so that it's not a popup but a hidden value? For example, here is the html for a field operator (there are usually several; equals, contains, greater than, etc. I simply copied the first value 'equals'...) OperatingStatus.op Equals If I leave this out, the default operator is 'equals'. Suppose I want to change it to 'contains' and that's the only option I want and I don't want …

Hello, I'm in need of converting a text box on my layout to produce some minor html to format basic things like underline, bold and italics. I've tried using GetAsCSS, but it makes the code a little dirty (having lots of extra SPAN things in it), and I've tried Bob Weavers code Text it will show up in the browser's source code as Let([ k=TextField; a=Substitute(GetAsCSS ( k ); ["";""];[""";"""];["“";"“"];["”";"”"]; ["<";""&Let([T="<"]; [">";">"; S=PatternCount(T;"SPAN"); X=PatternCount(T;""); B=MIN(1;PatternCount(T;"WEIGHT: BOLD")); I=MIN(1;PatternCount(T;"STYLE:ITALIC")); U=MIN(1;PatternCount(T;"DECORATION:UNDERLINE"))]; C…

Hello! I'm a tech assistant working on a thorny FileMaker API for PHP error. I'm gathering this information mostly for our head programmer and I'm all fairly new to both FM & PHP, so be patient with me, please We're getting several different errors -- the first of which happens over a dozen times: the use of ampersands in our variable declarations. . We've tested removing the ampersand and it seems to fix that issue, but I'm not sure this is truly the solution or just a quick fix. Any opinions on this? The other errors we're getting are... Assigning the return value of new by reference is deprecated From some searching, I've gathered th…

I work for a large non-profit organization. We use Filemaker for several intranet projects but our IT group won't allow open-source projects like PHP to web-enable them. They cite security reasons. Is this unusual? Are there other organizations that won't allow PHP? They will only allow Lasso to web-enable our databases. I'm sure Lasso is a fine tool, but why is Lasso more secure than PHP? Does anyone have any good arguments I could use to convince our aging IT guys that PHP is good to use.