Custom Web Publishing

Hi, this may be a very simple and small question, but I never did it so.. not coming in my mind.. I want to create a hyperlink of my filemaker file, which is located on server (LAN) and whenever any body is opening internet explorer, they should be able to open that file. I dont need IWP, or even I dont want to put a shortcut icon on desktop. This is internet cafe and we need this icon on internet explorer. Please help. Thanks in Advance.

I just uninstalled and re-installed FileMaker Server 9.0v3. When I check PHP version in terminal it says the following: PHP 4.4.7 (cli) (built: Jul 10 2007 13:05:18) Copyright © 1997-2007 The PHP Group Zend Engine v1.3.0, Copyright © 1998-2004 Zend Technologies In the initial deployment I was asked if I wanted FM to install PHP 5.2. How do I get FM to properly install PHP 5.2?

I am trying to figure out how to use the PHP Site Assistant to create a site that I can host the php files on a separate web server from the Filemaker server. Which of the files created by the PHP Site Assistant contains the address for the Filemaker Server?

First post in this forum so I hope I am posting in the correct place for this question. I am a first time user of FMP with experience in MS Access and a beginner in SQL. I am now a mac user and was told by mac that FMP is the best software for building a database and sharing it with windows and Mac users. I have no problem building the DB but I have no clue how to get this on the web and available to share with a few users. I do have a few websites and can publish it to a place on there. I just cannot seem to figure out if I jsut publish the FM file and that's it or if there is a list of things I need to do for people to be able to access this from the internet. Th…

I'm hoping to get a fairly basic app up that tracks workers, activities, clients, has work categories, start/stop dates/times, and time summaries. This is for internal use for less than two dozen users. I've not done any FileMaker / PHP work yet, but bought the FM Webschool book, and may buy the Dreamweaver plugin. Before I dive in, I thought I'd ask if anyone has taken something like the "Job Time Tracker" (from the FMI Creative Pro Starter Kit) and PHP-ified it in any way. Ken

I'm looking for either a plugin or perhaps an existing FM application that will automatically download new or updated files from an FTP site to a local server periodically. Problem is I can't search for FTP as its a 3 letter word, and the search function will not search for less than 4 letters. I've tried "FTP site" and +ftp + site etc but no avail. It finds "site" but never finds "ftp". I know about FTPeek and FTPit..(found them through Google !) my real question is just how to go about searching for something like FTP or similar short words. And if there are any such applications out there I'd like to know too!

Hidey-Ho Fellow FileMaker-Ins, We have something special for all FileMaker-Ins today. A new site built entirely on FileMaker and it’s just about as good as it gets. Some would call it shear perfection, while others have used such superlatives as Spectacular, Outstanding, Magnificent, Stupendous, and surly it was made by God himself! Well close to God anyway… I built it! Ok Ok maybe I didn’t build all of it, now that I have God involved and all, I should at least be a little truthful. Hey, anyone can try something once right. Man you guys can be a tough crowd. First of all the idea and brains behind the idea is a guy by the name of Steve Thompson. I must apo…

Is there any reason this code would not work. It's driving me mad after spending an entire day trying to get it to run a script! There are no problems with the connection to the database, the layout and the script exists. The script is web compatible. I don't see any errors just a blank screen and looking at the database the script has not run. If I run the script from the client it works fine. Am I being dumb here? I think I have the latest api - downloaded the server installation package at the beginning of the month (fms_9.0v3_full_ESD) <?php require_once('include/FileMaker.php'); require_once('include/commonFunctions.inc.php'); …

Is there a way to duplicate a find request and then add criteria to the duplicate before combining the requests? req1 is a findRequest. req2 is copy of req1. set criterion 'color1' of req1 to 'blue' set criterion 'color2' of req2 to 'blue' add both to compound request and execute. Basically what I want is to find records where either field 'color1' matches or field 'color2' matches my condition. Ed

Greetings, Using PHP API I've used the separation model (raw data in one file, ui with no tables of it's own in another). No problem accessing these fields through a layout on the raw data file but I get a field not found error when trying to access the same fields on the UI database. Is it not possible to link to these fields through the UI database? Thanks

I've just started working on converting some scripts from FX.php to Filemaker PHP API. I'm working on one that does an insert into the Filemaker DB, and there's an autogenerated order # that gets created when a record is inserted. I can't seem to figure out how to get that order # short of doing a second query to find the record I just inserted. In FX.php I was able to just inspect the result of the query for the data, and I found an example for FM API which said you could do that, but I've tried checking the result and all it seems to contain is 1. Is there any way to do this short of a second query?

G'day Folks I'm trying to set up a testbed for a deployment of a FMS on a Windows site for which the ideal would be to use PHP Web Publishing. I have FMS & Apache installed however when I go through the Deployment Assistant & get to the page where I'm asked to select the wen server there are no entries in the pull-down list. I'm guessing that the problem is with my Apache configuration (currently a bog-standard hpptd.conf file). Any clues or tips?

we have a database shared on Server 8 advanced and communicating with a XSLT pages via XML fmresultset. works great. we do a search with 2 fields location keywords both calculation fields concating other fields. we have a HTTP QUERY with lop=and works great. However, we want to change to return ANY match for the keywords but only those that match the location. example: location = sunnyvale keywords = asian mexican italian results = locations that are in sunnyvale that have asian AND mexican AND italian easy and right. we want same example but we want results = any location in sunnyvale that has asian OR mexic…

Here is the link to our latest webinar. http://www.fmwebschool.com/movies/iphone_webinar_new/iphone_webinar_new.html Also we have created some great new web technology, demonstrated in the last 20 minutes of the webinar. Here is a little information about JumpStart technology and a LIVE movie on my iTouch and Treo. What was so exciting about the webinar? JumpStart. JumpStart is a web based application that builds sophisticated FileMaker sites for mobile devices in minutes. We demonstrated this LIVE in front of 400 people. We actually took our time and spent about 10 minutes building a site with multiple tables, that allowed creating, browsing, and …

Hi I'm looking for advise. I need to read from an access log, get the result (which is tab-delimited text) and write each line as a separate record in a database. It's a constantly changing file so it'd need to read from it constantly and retrieve any new entries What's the best way to achieve this? PHP? Built-in FM function? 3rd party plugin? Is Filemaker the best way to do it, should I use PHP/MySQL instead? If anyone has any advise/tips it'd be greatly appreciated

I seem to be missing something. I have FMSA 9 setup on Tiger and I can get the FileMaker PHP API working no problem, but as soon as I try to run the web server with a manually installed API on a different server other than the FMSA server, I start getting a bunch of PHP errors. I think I'm missing one or two things from looking at it. 1) Some sort of config file to specify where the database server is and/or 2) FileMaker Web Server Module. Know idea on this one. It's named in the Web Publishing with PHP manual, but I can find no evidence of it anywhere else online or on FM's site. Any help would be greatly appreciated. jon

This is actually 2 exciting webinars in one. Why should I learn to create FileMaker websites for the iPhone? Because businesses, universities, hospitals, realtors, people of all walks of life are now using mobile phones to run their businesses. And guess what, they need to be able to connect and update live data from wherever they may be. What a great opportunity, to be able to learn how to develop data powered websites for the iPhone. Whether you are an employee of a company, or you are self-employed contractor, the skills taught in this webinar will be important to know now and for the future. This webinar will give you the tools you need to begin building…

I have a calculation in filemaker for the field (image_link_eMLS_2) " I use - getFieldUnencoded in the php file as so: <?php echo $record->getFieldUnencoded('image_link_eMLS_2', 0)?> This provides the image which is external from my site at 150 x 100 (these numbers come from a global field calculation in the field (Image_size_SM)) But I have no control over the image. I want to attach some javascript and effects, links and resize the image in the web design app instead of filemaker. This is a real estate web site with up to 12 pictures per listing. The 1 change in every link is the MLS number wihch can be pulled from the filemaker rec…

I have an IWP database which I want to auto-login as a guest and create a new record. It is an application to attend a summer program. I have the solution all ready and hosted on my FMSA9, and I can access it through my iwp_home.html page, but I have to first login. Is there a way to create a link from a web page which will automatically login as my WebGuest User and privilege set and go directly into the database, without turning on the option on the file to auto-login? I do still want to be able to access the database as admin and look through the applications - which is why I do not want to turn on the automatic login feature. Or maybe there is another way to…

I try to integrate PHP via FM Server 9.0 access to our standard-Business Solution and have problems when usin the site assistant in combination with a password protectetd Database. Environement: FMServer 9.0.2.15 Win 2000 Server 5.00.2195, ServicePack 4, IIS Access and site assistent work well when using the testfile without password. As soon as I use a password protected account even with unlimited access, I am asked accountname and password when I choose the file. I canot continue, because I always get "invalid Password", and I know it is valid. Tried many times with very simple passwords, no chance. When I remove the password I can open the file and ever…

Hi im new to filemaker.PHP can somebody give me an idea on how to do page navigation, i want to display 1 item per page then if next is click it will display the next item. Hope somebody can give me an idea about this.... this is the function that i used but its not totally working but maybe this will help.... function getStatusLinks($ur, $rs, $skp, $max) { $links = array ( 'first' => 'First', 'prev' => 'Prev', 'records' => array ( 'rangestart' => 0, 'rangeend' => 0, 'foundcount' => 0 ), 'next' => 'Next', 'last' => 'Last' ); $fetchcount = $rs->getFetchCount(); $foundcount = $rs->getFoundSetCount(); $total…

I have a FMP database being served with php created from the php site assistant. On the search page I have several fields that when ever anything is entered into them the search gives an error when preformed Error: 102 - Field is missing Home page is here: http://mlsmax.com:80/eMLS_Listings/home.php?

I am looking at a site which would allow my users to fill out a questionnaire and then could use a HTTP POST to a script to my site and populate the FM DB. My question is: could I use HTTP POST to populate a server side script which would take that information and put it in to a FM DB? I know this is possible with *Sql, but not sure about FM as I 'm fairly new to the FM family. Thank you

Free Shopping Cart Webinar (January 29th 11 a.m and 4 p.m. EST) Register for the Webinar - January 29, 11:00AM EST https://www1.gotomeeting.com/register/856134455 January 29, 4:00PM EST https://www1.gotomeeting.com/register/271639205 What do your customers want? Shopping Cart solutions. The most requested FileMaker solutions to develop are online shopping cart systems. Cost's for developing a basic solution for a client can cost thousands. In this LIVE teaching demonstration, we will create a complete shopping cart system that integrates with the most popular online payment system on the web, PayPal. In this teaching demonstration we wil…

Does anybody know how to format a field as a dollar amount in the php output file

So I developed a pretty sophisticated FM -> PHP API solution in FM 8. Our FM Server is on one machine, and our PHP scripts reside on a separate web server. When we upgraded the FM Server to FM Server Advanced 9, the scripts all continued to work... But... Under heavy load, the scripts will periodically stop with the "Unable to Open File" error. It seems that, as configured by default, FM Server Advanced 9 can't handle the same amount of traffic that 8 could. Does anyone here know what the maximum capacity for PHP API hits on FMSA 9 is, and, if any of my server settings need to be tweaked for performance, which settings those would be? I po…

I have FM9 and have been trying to use the "Web viewer setup" to insert data from a Filemaker database into html fields without success. It´s no problem to insert data into search fields. My problem is - how do I insert data from a FM database into fields in a html website. I want to be able to insert the data from a specific field in FM to a specific field at the website. Does someone know where I can see a demo of how this is done?

Trying out the new 9.0 web PHP. In 6.0, I used to put a "-script" tag and run the script after I create a new record. The script sets fields in the record after it is created. In PHP, I put this in the confirmation page: $recid = $record->getField('current_record_ID', 0); $findCommand =& $fm->newFindCommand('WebRegistration'); $findCommand->addFindCriterion('current_record_ID', $recid); $findCommand->setPreSortScript('TEST2','22'); $result = $findCommand->execute(); The script runs and changes the field in the database, but what is displayed on the confirmation page is the value before the script is run. Also, do I need to …

Hi all, I'm running file maker as a company data base and I want to use some fields to update my company website, built with Adobe GoLive Any suggestions of where to even start? Tks Paj

Hi all, I'm working with php and FM database for a data entry form and here is the description of my problem: I have two combo boxes, the first one displays a project list and the second one a sub-project list, depending on the project selected. How can I get the value selected in the combo box and put it in a php variable, without submitting the form?? Thanks!

After completed migration from FM 6 Unlimited to FMSA9, some kind of requests are much slower than before. FMSA9 is faster on small databases, but speed decrease on huge content databases. I don't know why, but simply diplayed a list can take 10 times more than before. I found a trick, using "light" layout, wich do not include all fields. That issue do not occured Filemaker 6 Unlimited.

Hi everyone, I have been tasked to publish some of my company's filemaker database online.Can someone give me a idea of how should i go about it and what are the things that i need?I have been using filemaker for a few years but i simply have no idea of how to do a web publishing. thks

I want to easily generate HTML for a job openings page through a script in Filemaker. I currently have a table with four fields -- company division, job title, job description, and a yes/no for "currently hiring." Is there an elegant way to export all of the "currently hiring" records to a single html page, sorted by company division, with my custom HTML (for headers, styles) already built in?

Hello, Can anyone help me how to achieve the below requriement, I want to create a login form in php to check the filemaker data is precent -- How can I achieve this ? Thanks in advance...

Hi everyone. I am having some difficulty implementing our (simple) workshops registration with FM via IWP. I have a Workshops table with 20 workshops to be attended by a mix of 300 individuals. I'd like to use IWP to mimic a Web form where each individual enters his/her name and email address, and clicks a checkbox (presses a button, something) to select the workshops that he/she would like to attend. My problem is knowing how to selectively display the "available" Workshops records for the workshops that are still available (i.e. not full and date not passed). Not only do I need to publish this dynamic list via IWP but I need to capture the particular wo…

I have a client who has a Remotely Hosted Filemaker database residing on a remote server and web hosting space with a different company. I would like to use the API for PHP in 9 to publish some data to the web. I am running a test server (Mac 10.4) with FMSA 9 installed with the Web Publishing Engine I generated the PHP files with the Site Assistant and added the call to the remote server. Testing on my local machine everything worked fine. When I upload the files to a remotely hosted web server running PHP and IIS I get this error... Parse error: parse error in O:Hosted Web SitesMy.Namemywebsite_comwwwfmview.php on line 340. Filemaker…

Is there a script or custom function I can use to determine if someone is logged in via IWP or from network connection? I have a few scripts that I'd like to run but aren't "web friendly" and would like to work around it... If I only knew if the user was logged in web version or network version. HBO (help a brother out) G

Hi, How do I implement audit trail using cwp (PHP)?

i'm doing some finds on a field where there search value could be some odd characters. i've tried adding "quotes" around the search as well. ex: [search for "nurse's room"] $cmd->addFindCriterion('afield', '"'.$var.'"'); but it doesn't help, i get a 401 error. if i go into FMP client and run the same search i get back what i expect.

i am working on a site where i am expecting to get back a single row as the result of a search. i know how to iterate thru all the rows using foreach ($response->getRecords() as $record ) {} and I have used this to get a single record by id $record = $fm->getRecordById('sku_web', $_GET['id']); but i'm just not sure on the syntax to get the first record from the getRecords() array. thanks andy

Creating a simple site to search one field named "authors", presort by "authors" and "year" fields, and return a listing of a calculation field. Search works fine. Sorting doesn't work. I believe the sort options in the PHP Site Assistant does not perform presorting search results. it just provides column headers that sort by clicking. That's cool but won't serve our purposes. The data returned must be presorted. Is this an option? Not within the FileMaker PHP Site Assistant. Website Address John

Just getting started with PHP. I use an authentication form to establish a username for purposes of searching my database. If I provide a login button so that a subsequent user can login, is there a way to prevent the new user from seeing the old users data by simply hitting the back arrow? Thanks.

Where do I do that in Filemaker Maker Server advanced 9? Thanks!

Got data in FileMaker and you want to display it as a map on your website? Now you can. The FMStudio Google Map module enables you to quickly create live, interactive google maps on your web pages in seconds. FMStudio Google Maps allows you to use the technology behind the powerful Google map system. http://www.fmwebschool.com/fmstudio_map.php * Generates maps of any size, with custom starting view modes and locations * Easily add multiple addresses and coordinates to a map * Custom marker icons can be used to brand the locations on the map * Takes only seconds to implement and fill with data Simply install the Google Map module and yo…

Do you know an editor that can [color:red]highlight the PHP of FileMaker? [color:green]Include([color:red]"FileMaker.php"[color:green]) [color:blue]$fm[color:green]=db_connect(); [color:orange]// call any record of web_items [color:blue]$any[color:green]=[color:blue]$fm[color:green]->newFindAnyCommand([color:red]'web_items'[color:green]); [color:blue]$result[color:green]=[color:blue]$any[color:green]->execute(); ... ?> What editor could be expanded [for the rest of us] without long and hard work? Notepad2 (v.2.0.18) GeSHi (v.1.2) - Generic Syntax Highlighter Demo of GeSHi TextWrangler2 Syntax Highlighting Wh…

Hi What I've done is to create a page with two record sets: From a results page you click on a link to the client record. The client record page has two record sets on it; the client detail (from the clients table) and all jobs linked to that customerID (from the Jobs table). When you click on a link, if there are jobs against that client, everything displays fine, however, if there are no linked jobs for a client the jobs record set returns goes to the error page and gives a 401 error . How do I get it to suppress that error and still display the client detail from the clients table whether there are linked jobs or not? I would have just used a portal but ne…

I'm doing some PHP work with Dreamweaver and its telling me to go to my Root Folder. I can't figure out where the Root folder is on a Mac. Can you tell me? It seems I can't do a thing until I figure it out. Carl

I have used the PHP Site Assistant to create an Add Record and Confirmation site. I now want to edit the PHP files to also send an email on Confirmation. What is required to get FileMaker Pro Server 9 Advanced to perform this function?

So, we installed FileMaker Server 9 and configured it for using the PHP API, then I unzipped /Library/FileMaker Server/Web Publishing/FM_API_for_PHP_Standalone.zip to the webroot directory, like the documentations says, but when I try to perform a find, I get the following error: Public Beta has expired. We used to be using the public beta, but aren't anymore. It seems like this has somehow confused the API, but I can't figure out where or how the confusion is coming in. Does anyone know if there's something I would have to uninstall, and where it might be?

I've just installed the php site assistant and attempting to create my first site. Server is set up for custom web publishing, php installed and db has the correct privileges. When I enter the web address and click on connect it asks for account name and password, no matter what I type there I get invalid username/password error. What else should I look at to determine where my error is. Thank you.

Hello all, I am currently tearing strands of hair out of my head over this problem: I am trying to use the PHP Site Assistant to produce a basic record management system (for storage of student files). Everything with the php output works fine, I can login, created new records and delete old ones - BUT - whenever I click to edit an existing record, it shoots me right back to the login page. Has anybody experienced this problem before? Any help you could give me would save me from going bald!

Hi, I'm looking for a demo or an example using FM API for uploading an image into a container field. If I can have the source code, it will be appreciated. Best regards,

Hi Guys, I am looking for some advice on creating some new dynamic database websites. I am a longtime user of Filemaker (I think since version 2), but I still have limited skills, and practically no CWP skills. I am exclusively Mac. I have a couple of new websites I need to have developed for some new companies (some startups I have been working on myself). These websites will be relatively simple, basically consisting of user registration/log-in, some products, shopping cart, checkout, admin, and a few other things. I am trying to figure out if it makes more sense to have these websites developed with Filemaker (and Lasso?) or some other database. I ha…

Maybe I should rephrase my last question: What is the procedure for showing or hiding specific fields in a record when published to the web? Thanks. Cayce

Hello, Forum; I've got a situation where on a record with twenty fields & 7 buttons, only 10 of the fields and none of the buttons publish to the webpage. I'm new to FMP, having just come on board with a publishing company using it to display book titles & information in an Amazon type format. This problem has me stumped after considerable prowling through the help files. Thanks. Cayce

Is there a way to format a FM field to the web (FXPhp) and retain the formatting, specifically paragraph breaks. thanks, r

Hi, I am doing work for an organization that wants to put a database of about 3,000 old photographs online. Each photograph has a separate record in the database, created in Filemaker Pro 9. I would like to find a way to put the records online (a separate web page for each record), keeping the design and layout I have created in FileMaker. Could anyone recommend a separate app, add-on or plug-in I could use? We're also on kind of a tight budget. This may be a pretty basic question, but I'm pretty new to Filemaker, and I thought it would be better to ask you guys on this board for advice before searching elsewhere on the web. Thanks in advance!

Hi All, I have prepared a very simple site using PHPSA in FM 9 adv. and win XP. The procedure to publish the DB online with PHPSA goes fine. When I try to connect to the DB, I reach the authentication.php page, I use my credentials but the Home page is not loaded (IE7) and so any other page. When I use the log-in procedure I do not see any error, simply, the pages are not loaded. If I decide not to use the log-in feature, freeing the access to the DB, I get an "unknown Error" message when I try to connect to the Home.php page. Any suggestion to fix would be greatly appreciated ! Diego

Hi Everyone, I've been looking around for an answer to this question: Can I Sync Filemaker with .mac? I have a home computer and a computer in my recording studio. I want to sync my Serial Number and Invoice databases on both machine. Any ideas? Thank you very much.

I've been reading about FileMaker and PHP and trying to get a good idea of its strength and weaknesses and it brought up some questions. What do you do after your site develops so much traffic that it begins too really slow down? I guess my questions are. 1• Do you have to ditch FileMaker at that point? 2• Can you keep FileMaker and go to something for the web that is more robust? 3• If you have to fully dump FileMaker from the web standpoint. Can you download the information from the new web source and still use FileMaker for report building etc? 4• At what point is it necessary to dump FileMaker completely and use another database and if so which on…

Is there a way to integrate fm database with front page? For example like Access db?

Dear Sirs, I'm learning API for FMP with some examples, then I have always the problem with function getRecordById, particularity the variable " recid ", it returns always error Undefined index: recid when I used $record = $fm-> getRecordById ('Layout1', $_GET['recid']); or empty($_REQUEST['recid'] = TRUE ! Here are the examples <?php define( 'FM_HOST', '127.0.0.1' ); define( 'FM_FILE', 'Test' ); define( 'FM_USER', 'php' ); define( 'FM_PASS', 'php' ); require_once ('FileMaker.php'); $fm = new FileMaker(FM_FILE, FM_HOST, FM_USER, FM_PASS); $record = $fm-> getRecordById ('Layout1', $_GE…

Ok we have a small business I have just finished(mostly) creating a FM database solution for us now I want to link our inventory tables with our website and create a nice dynamic web catalog so new products can get to market quicker. Right now our web hosting is done by Yahoo! and we have no desire nor $ to invest in an in house web server. What is the best way to get our FM data to the web and managed by a PHP front end? Any good PHP tools to help get this up and running quicker would be appreciated as well.

Quick question that hopefully has a quick answer. We are setting up our 9 test server, and trying to mimic what will actually be used in production. In doing so, we are enabling and disabling certain functionality. And my question is this: I know that the PHP API requires cURL to be installed and running, but for security reasons, we would like to disable allow_url_fopen. Does anyone know if the API will be adversely affected if this is disabled?

Our website is the face of a working business and we have employees who would be affected by a major loss of traffic, so much care is needed in the transition. I am still making the switchover to php/filemaker from html/Cold Fusion and from one web host to another. I have learned quite a bit on the journey but as usual there are questions. I have switched over all of the pages to php except those pages with cold fusion forms on them and the index pages. I left the original html pages on the original site though. In watching the stats, I am concerned about the final changeover because the stats show that most of the entries onto the site are still being made through …

Why should you watch this Live webinar? * You want to learn the easiest way to bring FileMaker to the web * You don't have time to learn PHP - but you cannot afford to be left behind * You want to learn some powerful techniques that you can apply in minutes * Give us 1 hour to teach you how to harness the power of FileMaker web publishing! Register for our Free Webinar! Space is limited Reserve your Webinar seat now at: Thursday November 8, 2007 10 A.M. - 11:15 A.M. EDT Register for 10 A.M. Webinar https://www.gotomeeting.com/register/697534767 Thursday November 8, 2007 4 P.M. - 5:15 P.M. EDT Register for 4 P.M. Webinar https:…

Hi, one of my fields contain data with semi-colon such as: apple;ball;cat apple;ball Within the PHP page, I added a search criterion using astericks such as: $findcom->addFindCriterion('field1', '*' . $search . '*'); ...but this doesn't seemed to work. The return page says no record found but using the find command within the fat filemaker client, I can see the records. Anyone can help? I'm stucked big time. Thanks.

I hope you can help me understand how to set up "Accounts & Privilages on the Web". Just the standard thing where someone looks around your site and decides to become a member. When they enter their "User name and Password", is Accounts & Privilages used for that and if so. How do you set it up? Somehow I've very confused on this issue. Milo

Can someone please post a copy of the FM Server Test file that installs with FM Server 9? I deleted my copy on a hosted server. Thanks much.

Hello, I've been given a website that I need to stream data to from the FM9 database. Once the data is streamed we will be receiving an acknowledgment from the site..I'm assuming this will also be streaming. This is new territory for me. I'm hoping that someone can point me in the right direction to accomplish this.

Dear Sirs, I am new to php, therefore I have an important question that I hope some of he gurus here will help me to make clear! this is the situation: 1. I have a full filemaker database that I would use to build an ecommerce website; 2.For each customer,in filemaker database, I have created a login and a password,to which are assigned diferent privileges and extended privileges sets;this helps me to have a great control over what each customer category can or cannot do, see or not see(eg.I set up privileges in a way that a customer can see only the orders that he had created;i though that this was a better solution instead of retreiving via php rela…

I have set up my site using the PHP site assistant and it works fine from the local network. If I want to access it remotely what should the correct path be in the URL? I am trying http://my_external_IP/focus/home.php - but it wont work. Error 404 If I type http://my_internal_IP/focus/home.php from within my LAN it works fine. I have set port forwarding to push traffic on 16000 and 16001..are there other ports that need to be open for php to work? What am I doing wrong?

Hi, Am new to the whole web thing so please bare with me. I have setup FMServer Advanced on a virtual server. Have also setup a test database file. Got both working beautifully, no problem. Can see the php page in IE and it talks to the database. Question though is opening up the PHP file in dreamweaver to do some design work. I can't seem to see the FM connection? I go through the motions of setting up the database connection, and under bindings, but it always asks me for MYSQL connection. It doesn't seem to recognise Filemaker Server as a valid connection. Is this correct, or am I completely in the wrong place in trying to set this …

My code: include('FileMaker.php'); $conn =& new FileMaker(); $databases = $conn->listDatabases(); print_r($databases); $conn->setProperty('database', 'Employee Info'); $conn->setProperty('username', 'fasdf'); $conn->setProperty('password', 'safdfadf'); $cmd =& $conn->newFindCommand('Data Entry'); $cmd->addFindCriterion('First', 'Rick'); $result = $cmd->execute(); if (FileMaker::isError($result)) { echo $result->message . '(' . $result->code . ')'; } My results: First the result from the databases printing (there are a bunch of errors in there I think?) FileMaker_Error Object ( [_fm] => FileMak…

Hi all. I just installed FMSA9, and the included PHP 5.1.2. Are there any security issues that should be dealt with after installation, especially regarding the php.ini file? I know there are whole books on PHP security, wondering if there is a simple checklist of what to change, if anything...or if there are any web sites that go over the basics. Yes, I have Googled "PHP security" and there are many sites. For a non-programmer, does anyone have simple ones to recommend? I also obviously will have to learn some PHP to implement web publishing, right now my main concerns are security issues with its installation.

Hello, I have tried using the PHP site assistant to create a basic site. The problem is when i go to any of the pages it says that "Failed opening required 'fmview.php'" I go to our /Library/FileMaker Server/Web Publishing/publishing-engine/php/lib/php area and found all the other files like FileMaker.php and Date.php but no fmview.php. Can someone tell me how to find this file or provide so that I can test out the php site assistant. Thank you for your help, Dustin

I have a FMP database that I would like to link to web. I anticipate about 80 or so users to access the website and enter some general info needed for a conference registration. I have no idea how to link my database to the website. Is this complicated?

I used the PHP Site Assistant to create a site to test out. It works fine if I place the site folder into: Hard Disk/Library/Web Server/Documents (but strangely not in my ~/Sites directory). Anyway, now when I try to open the FMS Admin Console through localhost:16000 it says "localhost can not be found" - I have tried 127.0.0.1 and my local IP address 192.168.0.2). Why is localhost on this port now not available? It's available on other Ports such as 631 and worked fine in the initial setup of the hosting of my database!

Hello everyone... I have a client that is using FMP5 Pro hosted file for web companion to view records on the web. My question is, they have a directory listing that shows all records (currently 2000) and they have a next page and previous page. Going backwards and forwards 20 records at a time is crazy. Does anyone know of a better way to handle this, maybe an (A B C D, etc bar at the top and find all records with a name that starts with the letter they click) or maybe a Pages 1, 2, 3, 4, 5, etc so at least they can get closed to the record then do a next or previous.) I am open to any suggestions. Garry P.S. Please do not suggest upgradin…

I have a system that runs a script that mainly uses the Export Script Step, which is no longer web compatible. I have checked Help to no avail. How do I do this now?

Hi Guys, I really need to understand FMP on the Web. We want to put up a FileMaker site that we think initially will have upwards of 800 users visiting the site at one time and project that to triple within six months. These are people without Filemaker who will just be visiting the site to read some reports and then show their interest level by selecting 1, 2 or 3 and then pressing a button to record their selection. Can FileMaker and PHP handle these numbers? This is our first time we are putting Filemaker on the Web and although I know Filemaker reasonably well from a development standpoint. I know little about putting it on the Web. Is there a good…

I just recently downloaded the trial version of Fm Advance 9, and wanted to test out the PHP Site Assistant. I can't find the button for Launching the Site assistant anywhere. I am probably missing something quite obvious here, but any pointers in the right direction would be appreciated. ~Rae Lin

Have you ever had any of these thoughts? · FileMaker web publishing is too difficult · I don't have the time, it will take years to master · I will have to learn PHP Our Promise – In 60 short minutes we will put all of those myths to rest. Spend an exciting hour with us as we build an entire online music site. In this live online broadcast, we will show you how to build a website that would take professionals hours to reconstruct. Learn how to quickly add this invaluable resource to your FileMaker talents. To make things even more interesting, we will create the site in 45 minutes, and then have an informative question and answer period. This is…

Wondering if anyone has made the jump from FM8 Serv ADV (using the php api beta) to 9. I got the Oct 7th bomb at a client who was already prepping to upgrade to server 9. My concerns are - I've build quite a bit using the example php files with the beta AND I've hacked the iwp_auth.html pages pretty well to manage a hot-link, login flow through. I can of course back that stuff up and drop it back in but...what will break!! Anybody been there? Thx

Hi Has anyone out there used or know of a cart solution that works with FileMakers API for PHP. Have been trying to convince my client to go with PayPal so I can use Dolphin Cart, but they will not budge. Any help or recommendations are much appreciated Regards Orlando

I have a reservation system in php and it works fine up until I get into the date areas. So, I figured that what I could do is when the student logs in, it would setfield with current timestamp. I gave a couple wacks at it but it is getting jumbled up. Could someone see where I went wrong? <?php session_start(); include_once('FX/FX.php'); include_once('FX/server_data.php'); $userid=$_POST['userid']; $password = $_POST['password']; $DateTimestamp = date("m/d/y",timestamp); // UPDATE THE TIMESTAMP FIELD currentTimeStamp_g WITH CURENT TIMESTAMP $edit=new FX($serverIP,$webCompanionPort); $edit->SetDBData($dbname,'students'); $edit->SetDBP…

how a java file connects to filemaker pro9 database using mysql server

Dolphin Cart is Community Built New FileMaker Shopping Cart System Dolphin Cart Website Our challenge was to create a FileMaker shopping cart system that could be online in minutes. This cart also needed to have an easy way to add products, set-up billing and shipping and be able to support multiple languages. Plus, the carts CSS template needed to be modifiable from within FileMaker, enabling you to quickly change the colors of the website. Once we accomplished all of the necessities, we asked the FileMaker community to beta test the cart. We set up a Dolphin Wiki page and a test of Live Dolphin Cart Example . The response was great! We re…

We are looking at retiring an old Mac Server running FM 5.5 where we enabled the web companion feature for several databases. We are trying to identify usage of those web accessible databases. Does FM gather any statistics when databases are accessed using the web companion? If so, where would I look for it on the server? Thanks in advance, Jack

Hi Have just started working with php on FMS Advanced 9 and noticed it will only accept date values in US format MM/DD/YYYY. Can this be changed anywhere. The local system date is in UK format. I would like to be able to input dates in this format: DD/MM/YYYY

I'm having a problem getting the function call for newFindCommand to do what I'm expecting. I am fairly new to the API, so I might have missed something elementary. I will provide a brief run-down of steps I took to setup my script. I have a table called "Family" which has a corresponding layout "web_Family". This table has a primary key: zkp_serial. My database file is called "Goodyear.fp7" I am serving this file with FM Server 9, have enabled the account Admin account for [Full Access] privilege set. Under the [Full Access] privilege set, I have enabled "Access via PHP web publishing - FMS only (fmphp)". When I go to configure this database via …

Hello! i would really love to get any useful information about the performance of Filemaker PHP or ODBC or XML/XSL comparing to using other databases like MySQL or MSSQL. is there any benckmarks or something regarding that point? the company i work with, using FileMaker, and we have large website that pulls 1000's of records (and growing) from the database. at the moment, i'm using (ODBC with ASP.NET), it's alright for the moment there is no heavy load on the website, but i'm very concerned about future performance issues that might come up later, as the website is going to have a lot of traffic later... lets say 75/100 visitors at once. i know th…

I'm sure I'm just missing something, but HELP!!! I've followed all the instructions for FM 6.0v4 to publish db to the web....but nobody can access it using the IP address I've provided. Can someone giving a newbie some simple options as to what the problem might be? Thanks

I'm experiencing some difficulty trying to set a global field from php. not getting any errors but when I check the global field, it's still empty. $findAny = $fm->newFindAnyCommand("php_Products"); $result = $findAny->execute(); $error = error_check($result); #now I have a FileMaker record object and no errors so far $record = $result->getFirstRecord(); $record->setField("globalField", "123"); $result = $record->commit(); now, $result is true, which means the commit is successful, but if I do another findAnyCommand, and echo the contents of globalField, I get nothing.

Hi everyone, I'm having a problem running scripts from php. One of many things may be happening but I'm not very familiar with the api. What I'm trying to do is run a script that will create a pdf and put it in a temporary location in my web directory. I know the script works perfect using the Filemaker Client but I am unable to call it from php. I've tried both ways below: $params = 2; $conn = new FileMaker(......); $test = $conn->newPerformScriptCommand('layout','some_Script',$params); $result=$test->execute(); /* $cmd = $fm->newFindAnyCommand('layout'); $cmd->setScript('some_Script',$params); $blah=$cmd->execute(); */ …

I am hoping someone is familiar with this problem and can possible help solve it. Background info: Server - Server 8 Advanced Clients - Using Firefox 2.0.0.3 or 2.0.0.4 The situation appears to be random. Switching pages in a database, adding a new record or just switching tabs on the tab control will randomly cause the next page to be white blank page. This kills the browser session more or less as no buttons in the panel to the left will then function. Browser must be closed and restarted. If user was saving a record this locks them from the record until after the timeout period. I have been unable to pinpoint a cause for this. I get multiple reports …

Do not know if this is the right place for this post but here it goes: Is it feasible and or practical / worth developing e-commerce site in FM. A real e-commerce site with shopping cart and all of the features of, for example, aspdotnetstorefront (www.aspdotnetstorefront.com). I understand that php, xml or so will have to be involved. The reason I'm asking is that of all online e-commerce providers - their db management, and fee structure always leave something to be desired or provides something not needed. Might as well get someone to develop the thing specifically for what is needed and be done with it. I am a novice in FM so I would like to get P…

A quick demonstration of FileMaker and iPhone can be seen here. http://www.fmwebschool.com/movies/iphonecommercial/iphonecommercial.html A more thorough demonstration of building the website and deploying it on the iPhone can be seen here. http://www.fmwebschool.com/movies/iphonecompletenew/iphonecompletenew.html I hope that you enjoy the movies! In Kindness Stephen Knight

Does the new FileMaker PHP API require FM Server 9 or will it also work with FM Server 8 Advanced?