Custom Web Publishing

Maybe I'm confusing myself, but I'm still getting used to how to make Find calls using the FM PHP API and could use some help. I have a table with 4 fields: Date, City, Size, Status. And I have a form where a user can filter the data by checking off one or more of those field values. So for example the use could check off a number of checkboxes to make the filter criteria: Date: 08/30/2011…08/30/2011 City: Los Angeles, San Francisco Size: 100x200, 100x300 Status: Active, Disabled If all these record combinations existed, I would get back the results: 08/30/2011 LA active 100x200 08/30/2011 LA disable 100x300 08/30/2011 LA disable 100x200 …

Hello, today I tryed, to delet a record with the API. I've read how the code has to be. But in the line §cmd->setField the Script fails. $fm = new FileMaker('DB', 'http://mac.equitania.net', 'user', 'passWord'); $cmd = $fm->newFindCommand('Layout'); $cmd->setField('Kategorie', 'Tests'); *Script fails $cmd->setField('Aufgabe', 'Test Aufgabe'); $result = $cmd->execute(); if(FileMaker::isError($result)){ echo 'ERROR'; die(); } $records = $result->getRecords(); $recordId = $r…

I'm wondering if there is any way to access the script results from PHP after the script is executed. Like in the FMPro script, if I put an "Exit Script" command and type in some script results, are those accessible to PHP after the PHP executes that script? If so, how? Thanks!

Guys: I found this tutorial http://www.fmwebschool.com/resources...pache_FMS9.pdf explained how to configure FMS with apache using tomcat connector. After configure it, I was unable to launch Apache (I'm using wampserver) do to this error: httpd.exe: Syntax error on line 491 of C:/wamp/bin/apache/Apache2.2.17/conf/httpd.conf: Syntax error on line 9 of C:/Program Files (x86)/FileMaker/FileMaker Server/Admin/admin-helper/WEB-INF/conf/mod_jk.conf.txt: Could not open configuration file specified. Obviously apache is considering the file mod_jk.conf as a TXT files, nor as a CONF file. In FMWebschool tutorial, files appears saved as CONF files (Fig.7), but there is …

I have searched all over the forum and internet for and answer and I have not been able to find one yet. Hopefully, someone here can help. I have created a massive filemaker database/program that I am in the process of converting over to HTML and PHP using Filemaker PHP API. I have a script that takes certain field variables in a layout and sets them as global variables so that I can reference those variables in scripts that will be run within the main script. Basically, the script takes a unique record identifier ($$) and if it is still AM ($$) and it runs through different scripts to determine if certain health care services need to be scheduled for this record. …

I would only like to display records that meet a certain criteria. For example only every show records that have an "enable flag" field set to true. If that field was set to false the record could never appear in the PHP site. Thank you for your advice.

Hey all - I've successfully synchronized my filemaker solution to google calendar (for multiple, secure accounts) using googles nifty API. The icing on my cake is to us the API's tag to embed a link that calls on an fmp connected PHP page. For the life of me I can't get their link logic to work. Anyone used it? Thanks, Tim

Dear friends, I am working on a Integration project with php API. and in reports it is giving a problem. Reports are displayed in anywhere in India on any platform, whether it is MAC or Windows. But in USA it is only viewable in MAC, not in Windows in USA. In USA they are using Firefox 5.0. -------------------------------------------- And in Reports part only we have categories like Construction, Design & Development, Operation, blank categories. It is giving the correct sum of the categories like Design, Operation and Blank field but giving wrong sum in case of Construction, here I am using the same loop for all. Please help me as soon as possible. I …

Hi all, I'm FM novice - all of my databases have been local so far. I wonder if this is possible: can I use FileMaker's PHP API to generate PDFs to be stored on my server? If so, can users download these PDFs from within the database web interface? Also, could I set up the server to email these PDF directly to an email address (ie no downloading to user's computer, just emailed straight from the server). A yes/no answer would be great, but an expanded answer would be super!

I created a search form using the PHP Site Assistant and would like to limit the results to those records that have a "yes" value in the "Publish to Web" field. I tried adding this at the top of the source code between the php open and close tags: $find =& $fm->newFindCommand('Web'); $find->addFindCriterion('Publish to Web', 'yes'); $result = $find->execute(); That didn't work; the find commands were ignored. I then tried adding <input type="hidden" name="<?php $fieldName = 'Publish to Web';?>" value="yes"> to the top of the form, which also didn't work. I know pretty much nothing about PHP (hence using the Sit…

Hi all, I've been building websites and Filemaker solutions for eons, but I usually stay away from combining the two for anything too big, preferring instead for a PHP/mySQL setup, or perhaps Ruby. We have however built a handful of smallish CWP sites, and numerous IWP hookups -- but although some of them are quite nice, none of them is truly large or spectacular. We've built many an industry strength PHP/mySQL solution, but we now have a few clients that are interested in a full-on PHP/FMP solution, from start to finish. Their first question is, can it handle the load? And their second question is, can you show us some examples? Well, it turns out, finding…

Hello everyone. I'm a web developer who recently had to work to create a PHP website (from scratch, not using filemakers code gen tools) that communicated with a Filemaker Backend. While the official FilemakerPHP API is great and all, it really just enables communication from PHP to Filemaker. Nothing more. Nothing less. Being an OOP programmer who believes strongly in ORM's, this API wasn't enough, so I went ahead and developed a light-weight PHP ORM for communication with filemaker. This ORM is just a module that internally uses the Filemaker PHP API to do it's stuff. A port to FX might come later, but for now I'll only support the official API. Being mainly a…

Hi, I have a text field typically with several paragraphs but the output on web page ignores the paragraph markers altogether (whatever they may be in Filemaker). So the text becomes one big, hardly readable block. I am using FMSA 11 on Mac, PHP is set to UTF-8 nn FMSA Web Publishing section. I have tried e.g. GetAsCSS calculation, but PHP just outputs the result plainly on the web page, that is, the original text with html-entities. This might be solved with PHP html_entity_decode() Function but is this really the only option available? Thanks for any answers! Arto

Hi, Can anyone offer any pointers on migrating from FX.php to FM.php ? I need help transferring the php code on my pages. I set up some Search > List > Details pages about 4 years ago using FX.php, pushing my envelope, and have not touched PHP since. Now having a technical problem with the web publishing engine and FM Inc won't help unless I use FM.php. Thanks, ft.

We currently have a php site connected to a Filemaker database. The website has a simple search box connected to the FileMaker website. The problem is that if a user search for "*" all records will be shown. We do not want the user to be able to do this. Is there any way to set a limit that the search querry has be at least three characters long? Do I set this up in the FileMaker website or in the php code?

I have a filemaker database that I access from the web. I have been running it for about 1 month. Just yesterday in creating a record in one of my tables, or in editing a record in that same table I get an error 802 message. This happens about 90% of the time now. I have about 20 other tables in the same file and I don't get that message editing or creating records in any of them. The only information that I have been able to find on the subject other than the usual description of the error is on this website.

Dear All, I am creating webpage as according to desktop filemaker file layout.IN layout i have 1 field which have 1 dynamic valuelist attached(means that valuelist is coming from another table's related records) I am very confused to do this .in case of static values i just passed those all values manually in php coding.But i don't have idea how to implement it for webpage layout. Please give me solution....i am trying it since last 2 days. Thanks a Lot .Please reply me :o

CWP USER GROUP AT DEVCON 2011 It's our 5th Annual meeting at DevCon! Come show us what you've been working on! For the fifth straight year, people doing Custom Web Publishing with PHP are getting together at the beginning of the FileMaker Developer Conference to share projects, tips, and ideas. (formerly called "PHP User Group", but we focus on so much more than just PHP ;-) DATE: Tuesday, August 2 TIME: 4:00 - 6:00 p.m. (before the 6:30 keynote) ROOM: Sapphire 410 This will be a friendly, informal chance to share some of what we all have been doing with FileMaker and CWP. All web-related tools and technologies are relevant. Show us one of y…

I have a website connecting to an FM database via FM PHP API. It has been online and working for months but I just started getting the Error: Unable to open file (code 802). The FM Server is v11.0v3 on a Mac. I created a very simple "connection test" php file which has the bare bones only: a single find any command. This script also fails, even when it is run on the FM Server. Then I copied the database files to a Windows computer running the same version of FM Server and ran the same script and it worked. My conclusion is that there is something not working on the Mac FM Server computer, but I don't know what. I didn't see anything of note in the FM Server l…

Dear All, I am working on Filemaker database show on webpage using php. during my add record i have different kind of field like text for name,address ;number for mobile no,age ;container for upload image,upload file.....it is working correct . But main problem occurs as i have done name,age,address entries;when i click on upload image/file button it takes the file path into filepath field but it refresh the page so my other entries disappers. so i want such a code it dont refresh page during upload file or image.. although i search it on google but not been able to work it properly. Please he…

I'm running Appleshare Fileserver 6 on MacOS X.6.7 (MacMini server). I have Filemaker Server Advanced 11 installed. Instant Web Publishing works fine. XSLT web publishing works fine. I have SSL enabled on the server (ie, all my urls are HTTPS _ :443). I have my server set to "List only the databases each user is authorized to access". I have a valid, institutionally signed security certificate for my server. I have used the built-in Appleshare server version of php, it is PHP Version 5.3.2. I have checked my include path, it is set to .:/usr/lib/php, I have, in that directory, both the Filemaker.php file and the directory Filemaker containing Command Error.…

I have a FileMaker database published to the web with the PHP API. It was working before, but now whenever I attempt to connect to the database I'm getting a FileMaker_Error object instead of the result I used to get. The error message is: Communication Error: (22) The requested URL returned error: 404 - This can be due to an invalid username or password, or if the FMPHP privilege is not enabled for that user. I see the user name and password in a vardump of the result and have successfully logged in with these credentials using the FileMaker Pro client instead of the web, so the username and password are valid. I've checked the user's privilege set. WebUse…

Hi, I've just started learning PHP and just finished running through the Filemaker PHP API turorial. I'm trying to apply what I just learned to a custom website and I'm having some troubles connecting to my Filemaker Database. What I am trying to do is to get all records on a specific table to be displayed and I get the following error, "fatal error: call to a member function getField() on a non-object - on line 63" and I'm not sure where I went wrong. I'm sure its something simple as I am quite new to PHP. My php code is as follows: <?php $findcommand =$fm->newFinallCommand('Recipes'); $result = $findCommand->execute(); …

Hi, I am a newbie to php. I am having an issue with setLogicalOperator. I have the following scenario in FileMaker. I need to fetch all the records for which cDailySheetRecords =1. The value of this calculation field is set based on logic, If( (Upper(Left(Accession; 1)) & Final = "SN" ) or (cExpireFromDailySheet ≥ Get(CurrentDate)); 1; 0) --- (note: & is concatenation operator) where, cExpireFromDailySheet = VMIS_ReleaseDate + 5. This will fetch the below 20 records in FileMaker. It will fetch the records if any one of the above conditions are true. -----------------------------------------------------------------------------------------…

Hi, i have php api installed on a seperate web server from the filemaker pro database server. For example web server address 160.169.82.9, filemaker pro database server 160.169.82.10 I have the following script on web server called img.php <?php require_once("FileMaker.php"); $databaseName = 'test'; $userName = 'test'; $passWord = 'test'; $serverAddress = '160.169.82.10'; $fm = & new FileMaker(); $fm->setProperty('database',$databaseName); $fm->setProperty('hostspec', $serverAddress); $fm->setProperty('username',$userName); $fm->setProperty('password',$passWord); if (isset($_GET['-url'])) { $url …

I’m hosting on FMS 10 (not advanced) and running FMP 11 Advanced on my desktop. I’m using the Filemaker ‘Registration’ template as a basis for the project. I’ve made the necessary customizations to the template to for their needs. Now I’m using the Site Assistant generated code to build a web interface to the database. The end users can now come in and either create a new account or edit their existing account fields. The next step is to allow them to register for new events once they have verified their account information. The flow looks like this (depending upon new record or existing record) home -> addrecord.php -> browserecord.php -> eventreco…

Hi All, I have a requirement for someone to remotely access a database that I am hosting to view several reports. I have been allocated a fixed external IP address and use a manually selected internal IP address behind my router but I can still not access the file with "Open Remote" The set up is: Filemaker Pro 11 Advanced Mac OS X 10.6.6 External IP 41.0.30.116 Filemaker see's my IP as 10.0.1.2; 10.0.1.2; for some reason, as far as I am aware it is 10.0.1.2 Router IP Address 10.0.101.20 Router Address 10.0.101.1 Open Ports: 5003 I have Filemaker Pro set to allow incoming connections in my firewall If I open remote from within my ISP's network by …

i am using PHP API to retrive data from aperal magic. can can all data from all Layout except (Products 2) is there anyone could help me?

I am starting a fm script via php. Php is now waiting until the fm script has been completed but I do not need that - is there any way to tell php that it should continue with its own script?

Hi guys, I was wonder if there was a way to convert my Enter key to a return key so when I type in numbers and hit enter it moves on to the next line. I had it working without a script before but I forgotten how to do it. Thanks,

I have two separate applications with their own databases writing to the same grades layout in a FM database. I need to find the max event_id in the layout so I can increment back at the source. This will provide me with the event_id but will it give me the max event_id? //Create the 'find all' command and specify the layout $findCommand =& $fm->newFindAllCommand('Grades'); //Perform the find and store the result $result = $findCommand->execute(); //Check for an error if (FileMaker::isError($result)) { echo " Error: " . $result->getMessage…

I'm having a big problem getting IWP running on a new server (see other post in IWP forum if you're curious). I need to get this thing up fast, so I'm thinking of finding a host for it until I solve problems in-house. Any recommended hosts? The database is about 10MB. I'd need to give IWP access to about ten users. Direct Filemaker use will be by me alone. Use will be VERY light. Inexpensive is preferred, as this will come out of my own pocket (a volunteer job that's gone awry). No need for a custom domain name; this will be used only by these ten folks. Thanks!

I am a fairly new to FileMaker Pro 11. I used FileMaker many years ago when it was a flat file database and had no problems with it. Maybe the issues I am having are due to the relational DB, but I don't thinks so. I find that some fields I create in new tables do not allow any input. In the layout mode the magnifying glass icon on the right side of the field box is yellow rather than green. I have spent a lot of time with this and can not find the problem. Could someone give me some pointers on this please? Thanks,

Hi, I need to submit a html form code from within FP7. It will be used to send customers data eg name, email address automatically to a web based autoresponder system. I have the HTML form code I use on the web page, but I can't figure out how to use that code and integrate it into FP7 so when I hit a 'Submit' button in FP7 it will submit the form data. Any help would be greatly appreciated. Regards Mark

I am new in writing a WEB application. I am currently writing a VERY simple web application which require to read and write information to a filemaker Pro database. The database is located on a MacMini Server, I do have five to six client remotely connected to the database. I could have between 5 to 15 external users trying to access the database simultaneously through the web application. People will be registering to the DBMS and make order ? My web pages are written in XHTML and I am intending to use PHP to : validate user entry information; query/ gather information from the Filemaker Pro database and; write information onto the FileMaker Pro d…

Hello everybody, I'm wondering whether there is a different way of publishing PDF Containers besides IWP options of FM. Currently my customers are able to download their information through IWP. However this interface isn't user friendly and it's kind of slow. So do you think there is a way those containers could be accessible through PHP or anything else? Thanks in advance!

I have been debugging an issue that i have with a PHP form connected to FileMaker and have narrowed the issue to my function. I am new to PHP forms, and I think this might be a relatively easy fix, but am not sure how to approach it. Here is the issue: When I have a field getting a value list from FMP, and the value list has a strings (with spaces) as one value, the values appear on the form, but if I check the box, save, and return to the form, the value with a space between words is unchecked. On exaiming the FMP field in the filemaker, the data is there. There seems to be an issue with the function getInputChoices echoing the string, although the value is checked …

The timestamp fields for the database seem to be using server time, which is different from our local time. Is there a way to make the filemaker file use server time +3 hours? Or is there another solution? If I use calculation fields then all of the old data will be displayed as the wrong time. This is for a lot of different fields, so I'd rather not go down that road. Thanks

Ok, Im assuming this is where this topic would go. I know the basics of filemaker, and the basics of freeway pro. I know no PHP. That being said, I want to be able to take a filemaker database I have and put it on a website so that people can fill out this form I have and send it to me. The reason Im trying filemaker is because the forms you create in Freeway aren't as aesthetically pleasing as the filemaker form. Sooooo how would I go about doing this? Thanks!

Hi, i generated a file, using php site assist, to add a record to my fm database. The problem I have is that one dropdown content is dependent on another dropdown list. for example I have a dropdown list of different sports (basketball, soccer, tennis) and then once that is chosen, in the second dropdown list contains the different teams of that particular sport. In fm itself and with IWP it works like a charm, my relations are all correct and working. Now the questions is, how do I do that with php? that's the code site assist generated for the dropdowns: <td class="field_data"> …

Hi, I'm trying to understand why I get thrown an error when pointing a getField to an empty field in a related table. Empty fields in the main table simply show up as...well, empty, when a getField is used to echo their content. Example: <?php $relatedSet = $record->getRelatedSet('taxontable'); foreach ($relatedSet as $relatedRow) { $relatedSet = $relatedRow->getField('taxontable::taxon'); echo $relatedSet; …

My understanding was that I used the FileMaker PHP Site Assistant to create php files that would interact with my database. I created the PHP files with the assistant and copied them to a web host, but I get loads of PHP errors when I try to load a page. Or am I supposed to host these PHP files on the FileMaker Server directly? Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home2/platenet/public_html/mphs1991/FileMakerPro/MPHS Class of 1991/home.php:2) in /home2/platenet/public_html/mphs1991/FileMakerPro/MPHS Class of 1991/fmview.php on line 10 Warning: session_start() [function.…

Hi, I need some help here. This addFindCriterion is to general: $findCommand->addFindCriterion( "BarcodeRF_ID_Assinged", $code); I find; barcode 123, and barcode 1234 and barcode 12345. I need an EXACT find for barcode 123. Can I get some help. Can someone provide and example for an EXACT search/find for the above $code. Thanks :)

Hi, does Filemaker Server 11 also run on Windows Server 2003, Enterprise, SP 2 ? Or only on the standard edition. The Website only lists the standard edition. Thanks

A curious thing: I have two number fields: originalPrice and currentPrice. The currentPrice was calculated via Replace Field Contents to show 15% off the originalPrice. In FileMaker, both of these fields were marked as "Currency", a fixed number of decimals (2), a dollar sign ($), and a thousands separator (,). This works fine in FMP. However, when I view it on the web (using the API for PHP), the originalPrice looks like this $1,234.33 and the currentPrice looks like this 1049.1805 I changed the currentPrice to a calculation field (number return), again marked it as "Currency" in the inspector, but this did not help. Anyone have any ideas? Thanks.

Does anyone know how to do this? I've found the same articles telling me about setRelatedSetsFilters() and getRelatedSetsFilters(), but i haven't found any examples. So i have no idea how to implement it. I have a page, that will be displayed on a large plasma. On it is 10 portals all pulling from the same child table. Each portal shows projects in a different stage. IWP doesn't work, it just shows all the records in each of the 10 portals. If 10 is too ridiculous, i'll settle for 1 and just use iframes or something. Any thoughts? Thanks!!

I have a PHP script that is 3 separate FileMaker finds show 3 separate tables of results. I am having trouble when one of finds returns no records, in this case the while script dies (but I am not telling the script to die anywhere). here is the important code where I know its breaking but I'm not sure how to make it move on. .... $result = $request->execute(); if(FileMaker::isError($result)) { $apps_html = '<p>(No Pending records found. Records will be displayed here)</p>'; }else{ .... bunch of code..... $request2 = $FMDB->newFindRequest('fm_layout'); .... .... $result2 = $request2->execute(); if(FileMaker::i…

I am using the FileMaker PHP API on Windows Server 2003. I am wondering if I can change the port of FileMaker as Port 80 on my server is already in use and I need to use an alternative, such as 8080. Is this at all possible as I cannot find any help on the web with this one. Is it just a matter of changing the IIS Virtual Web port? Many thanks, Jim.

I'm working on a mobile version of our website for iPhone, Blackberry and Android. The iPhone is perfect because I can just show the PDF in a web page like I do on a regular browser. Blackberry and Android devices are kind of a pain because they don't support in-browser PDF reading. You have to save them and read them with a third party PDF reader. The problem is that by using the method in Jonathan Stark's book (pdf.php?-url="pdf field information" then $fm->getContainerData($_GET["-url"])Wink you show a PDF, so the Blackberry and Android just fail when I click on my link. Is there a way to actually force the saving of a PDF instantly by clicking on a link? …

Using PHP I am successfully able to receive posted form input of special characters such as é or ç and store them in php session variables, and even output them back to the browser. but as soon as I try to do a FileMaker new record command, if any of the fields are to contain accents such as this, I get nothing but a completely empty record in FileMaker. How should I work around this?

I have a 2 related tables and 1 of the tables has a calculated field which counts the number of related records in the other field and returns 1 if there are records and 0 if there aren't records. When viewed in the FileMaker client, the values are working properly, however, when fetching the records via PHP all of the values are 0. The calculated field is If ( Count(table::IDField)>0 ; 1; 0) Am I doing this wrong or is there a better way to do this?

I'm familiar with FX and now I'm trying the PHP API. In FX, the result array from an ADD operation contains the data that was just added to the database. However, when I examine the result of an ADD operation using the PHP API, I don't find the record contents. Am I missing something? Is it really there? Maybe I have to Find the last record to get the contents.

Good afternoon, We have a FM 11 server which is running on OS 10.6.6 (non server edition).. The PHP test page works fine from within the admin console, however we are trying to test the connection from another machine also running 10.6.6 with PHP running independantly with no success. The PHP install is running XAMPP on our test rig, we have followed the FM documentation to the letter for manual installation of the API but when we use the FM class in a PHP script we are getting the following error.. Fatal error: Class 'FileMaker' not found in /Applications/XAMPP/xamppfiles/htdocs/ddf/fm.php on line 2 This leads us to believe that the installation has someho…

We've got an Auctions table with an InternalNotes field that usually has quite a few notes in it. Each new note is separated by a line break so it's easy to read. I have a PHP script that I'm using to update the Auction record with information from eBay. When the auction ends I'm updating the notes field some new notes. In order to do that without losing all of the previous notes I'm first pulling the notes from FM into the script, then I append new notes to it and update the record with the new notes. The problem is when they get back in FileMaker all of the lines have been pushed together like 1 huge sentence. For whatever reason it's losing the line b…

Here's the code snippet: $fm = new FileMaker( DATABASE, HOSTSPEC, USERNAME, PASSWORD ); $findCmd = $fm->newFindCommand( USERS_LO ); $findCmd->addFindCriterion( 'Email', $_POST['email'] ); $result = $findCmd->execute(); if ( FileMaker::isError( $result ) ) { echo 'Error: ' . $result->getMessage() . '; ' . $result->code; } I get "Error: Field is missing; 102" output from that second to last line. I've double-checked and the USERS_LO is correctly named. There is an Email field on the layout. I tried a newFindAllCommand just to make sure I was connecting correctly, and it worked. Can anyone hel…

I am using FilmakerPro 6 to allow customers to access their records on my database based upon the criteria in the attached file. It utilizes web companion to interface with Filemaker which will not work with Snow leopard. Does anyone have any suggestions on how to limit access to single records bases upon search criteria in a later version of filemaker that wilindex.html work with snow leopard?

I installed snow leopard and my filemaker 6 web companion will no longer work. Does anyone have a work around?

I have a database that I have built over 5 years that is the heart of my company, now we are expanding and I need to have people off site able to do data entry, seems simple but I am not finding a solution. We Currently share the database locally peer to peer with 4 users. Network Sharing (hosted offsite)seems to be too slow, unless I change the database I'm told Instant web publishing works poorly as far as I can tell. Where should I turn? Any suggestions would be greatly appreciated.

Hi users Going from FM5 to FMP11 amd have some development issues, please send background and rates 12Midnite

hi, I have taken a portal and date is coming from selecting the drop down ,i want to prohibit the duplicacy record.

Hello! I have been asked by some co-workers at my school if I could help them with their website. Of course this has become a bigger project than initially thought. They would like a registration form that when submitted a file importable to filemaker is sent to them. Any advice? I am new to filemaker and from what I played around with, a simple comma delimited file may work? Thanks! -Josh

Hello, I've been searching everywhere for a solution to this problem, I hope someone here can help! I'm trying to build a flash application that uses php to retrieve information from a FileMaker database, so that it can be put into a UI used for employee scheduling. The short story goes like this: The php file is interfacing with one large database that contains more or less all information about the company, the employees, their hourly rates, the jobs they are working on, etc. This database is referencing another database that contains contact info for clients. To test out how php interacts with the Filemaker API, i've built a simple application that gets data from a…

Hello! Already have a solution running pretty well in a High School, this solution takes care of all the grades of almost 500 students, every month the users of the solution print all the grades in one special format for their parents. The next step of course is to upload the solution to the internet only for consult and to check the grades an not to print all this info every month. I know I have some options: Internet web publishing, FM studio from fmwebschool, maybe php and maybe lasso, I don´t know which could be the best path to take??? I know that I have to take in mind security and the most important is that I already have a domain hosted in a server…

Hey there, My solution contains records of different categories: The Category field can hold e.g. "Library item", "Periodical", "Internal Knowhow" and many more. (A record has one category only.) The Find screen that is being offered through a PHP solution contains a field where users can search the Category field using two checkboxes: When they tick "Library item", they find library items; when they tick "Periodical", the find periodicals; and when they check both, they find records of both categories. My problem now is, if a user does not check any of the checkboxes he finds all the records that belong to other categories. But what I have in mind is that …

Hi group, My first post here, so bear with me. I connecting to some FM files created with FMPro 8.5 that run on an server 11 setup so I can use the PHP API. This all works well, but I would like to grab the contents of some containers. People drop images (jpg and gif) and pdf files into this container. If I fetch the contents with PHP I keep getting "image" even though I know some are pdf files. I've tried several things, most solutions I've found on this forum as well do it the same way. When I use cURL and try to grab the headers there is no content-disposition, I was expecting them to force a mimetype to pdf (or some other) etc. The path is also "/…

I'd like to automatically send an email when a new record is entered via CWP. Here's the situation. Student information system. Teachers can enter a discipline referral for a student via CWP, and the office needs to know that it's been entered. How can I trigger such an email. thanks in advance for any help or advice.

I have a number of solutions in FX, now trying the Filemaker PHP API. I'd like to test the find result for the error code that indicates "No records match request." The method getErrorString() and getMessage() both give me a text string. I know there's a numeric code hidden in there somewhere, but I don't see a method to retrieve it. I could do this easily in FX, why not in PHP API? Gary

I promise I've tried searching for quite some time, but I can't find exactly what I'm after so... This seems simple - I would like users to be able to download pdfs associated to their record via the web. More specifics - this is for a school, I'd like parents to be able to log in to a site, see their student(s) and any associated pdf report for that student. I currently have container fields which hold pdf versions of grade reports, progress reports, etc. Is this possible? Thanks, Scott

First of all apologies if I have posted this topic in the wrong forum, wasn't sure what topic this would come under. I am currently designing a management database for a festival. They need to share the database between 3-4 people and don't want to purchase FIle Maker Server. I can setup sharing the database internally in their office fine but they need to access the database from home, different event sites as well as within the office. I couldn't find much on the web about remotely accessing a database from an external network, so just wondered if anyone had any suggestions? Thanks in advance! Dan

Hello Is there anyone who can help me translate the following search form to a URL, with the value children in the search field "malgrupp"?

I want to run this script: CreateMenu On this layout: WebOrderSimple2 Here's my PHP code, can someone please tell me exactly what code i need to run to this? Thanks!!! <?php //error_reporting(E_ALL); // ini_set('display_errors', '1'); ob_start(); require_once 'OrderManager.obj.php'; require_once 'vmail.php'; require_once 'ShipGroundDomestic.php'; $OM = OrderManager::getOrderManager(); $fm = $OM->getFilemaker(); if(!($OM->getCustomerID() > 0 )) { header("Location:../login.php"); } if(empty($_SESSION['oldvalue']['SubTotal'])) { $layoutName = 'web_Step4'; $reid=$OM->getCustomerRe…

Hi! I'm developing a form in PHP and am wondering if it's possible to use a value list that uses only related values in one of the Web fields. The form includes a field for the type of service the user is requesting. In the database, a separate table contains vendors, each of which provide only one service type. I have a relationship between the request table and the vendor table based on that service type. I want the user to select a vendor or vendors from a checkbox set/value list that includes only related values based on the relationship. The user would select a service type and see a checkbox list that only included vendors that offer that service ty…

I'm trying to get a site up using custom web publishing (cwp) and I need to add a supercontainer for user to upload images. I've found an example elsewhere on the web which says the it should be put in an as per below. [color:green] I've changed the URL path, plus the field and name to my relevant source, but I don't know what to do with the "$php echo" section of code. Can anyone give me any help with PHP code for showing a supercontainer? Thanks.

I am trying to grab data in a field (USERS::fullName) by doing a search on another field (USERS::accountName). The context is that a person logs into CWP where authentication is via Accounts and Priviledges. Her account name is also in the table USERS (but her password is not). Once I log in I want to go to the USERS table, search for her record, and grab her fullName. The log in process works properly and is omitted here for brevity. The $_SESSION['accountname'] is set to htmlentities($_POST['accountname']). Here is how I have it written: // successfully logged in. now find specific user based on log in $find = $fm->newFindCommand('userL…

I have an Array it contains the value from a key field in my database. The key is for sessions of a class. The keys display fine but I now need to take this and show other related data from FM. I have been reading and searching for many hours trying different things but have not had any luck. If someone could point me in the right direction I'd be very grateful. Here is my PHP code to display the Keys after they are selected from another page/form. if (isset ($_POST['cart']) and is_array($_POST['cart'])) { foreach ($_POST['cart'] as $id) { $html .= "$id n"; } Can I do something like if (isset ($_POST['cart']…

So the issue seems to be that I'm trying to sort on a field which is unstored. its pulled from another field if a value exists. its defintely pulling correctly as I can display the sort field in the search results. heres the code that doesn't want to work: $findCommand = $fm3->newFindCommand('Exhibitor Search'); $findCommand->addSortRule('ExhibitorSearchSort',1,FILEMAKER_SORT_ASCEND); $result = $findCommand->execute(); So now I'm confused about what exactly filemaker has returned to me as $result. it is a multidimensional array? a resultset? can i use a standard php sort on this? somehow specifing the name of the field to sort by? any …

(PHP newbie beware) I am working with 2 tables, Classes and Sessions. I have built a page to display a list of Sessions, showing their related class title. I am looking for a way to group the results based on Class title, showing the title and description only once and the available sessions below. Below is all the PHP code to what I have created so far. If you have any suggestions or can point me to an article that will help, it would be much appreciated. thanks grum <?php error_reporting(E_ALL); require_once('db.php'); $request = $fm->newFindCommand('php_Session'); $request->addFindCriterion('StartDate', '>= //' ); $r…

I have an online search form that pulls in a value list. I would like the form to initially be blank and the user can pull down an arrow to get the values - basically a global field in the HTML. Right now, I have added a blank to the value list in FMP: ¶Dog¶Cat¶Butterfly instead of Dog¶Cat¶Butterfly Although that works, I'd rather not have the space in FMP and just have it in the HTML. I've tried but that didn't work. Not sure what else to try. Can anyone offer any insights? Thanks.

Any help would be appreciated... We've recently upgraded to Filemaker server 11 (not advanced) and Filemaker Pro 11 from version 7, so I have no experience with the web publishing. I've used the PHP 'site assistant' to create a site, but now I want to make some alterations, ie. add a supercontainer for images and change the layouts a bit. But I can't figure out how this is done, I've read all the documents from filemaker, but none of them actually describe how to launch the PHP API. Firstly is that the correct application to use to make the amendments I mentioned? or should I use something like Dreamweaver? Thanks in advance.

I have exam grades stored in a MySQL server and want to insert these into a FileMaker table. I have made the connection and queried my records but am unsure just how to insert into FileMaker. I ran my query and now have everything in a while loop. while($row = $db->sql_fetchrow($pullgrades)) { $quiz_id = $row['quiz_id']; $quiz_name = $row['quiz_name']; $exam_type = $row['exam_type']; $course_number = $row['course_number']; $academic_year = $row['academic_year']; $uid = $row['uid']; $somkey = $row['somkey']; $username = $row['username']; $grade = $row['grade']; I have not found much documentation on what to do here. $req…

I've set up a FM network at our office. I installed FM 11 on all the computers that need access but there seems to be a stability issue. FM keeps doing a force close or saying there are connection problems. We're using FM with 4 computers. My computer is hosting. All running windows XP. I'm also running IWP (should I turn that off?). Wifi network. We upgraded our internet speed and bought a new router so that everyone's wifi is faster and stronger. Any suggestions?

Dear Team How to Connect FileMaker to database mySQL ? FileMaker Pro 9 (OS WINDOWS 7) MySQL Best Regards David

I would like to use PayPal's IPN system for collecting shopping cart and payment information. They send it in a URL. I have a two part problem. Is there a way to have FM 'listen' to web requests, through web publishing, log the URLs that are requested, and then drop those complete URLs in to a FM field? From there I can parse out what I need. Every web request should create a new record. For example, if someone hits http://sample.com/data?1&2&3&4&5 (or whatever it needs to be) and that points to my FM system can "http://sample.com/data?1&2&3&4&5" be dropped in to a field? PayPal requires a return request for validati…

I'm trying to create some simple links on a Site Assistant created home screen to a few often-used search queries. I can't figure out how to construct such a link in the PHP code, though. The search parameters seem to be stored in the session, and if it is possible to construct such a search via a URL (for example: http://www.site.com/recordlist.php&-name="Fred"&-job="Boss") I can't seem to tease out the logic of it. Any ideas? Thanks much.

Hello everybody ! My job is to get datas from an enormous FM database (bad organised ^^) and to show them on a simple website. I'm getting easily those datas with commands like $record->getField('FieldName'); My problem is, there is values I must get in FM wich are in a sort of array, "rubriques multivaluées" in french, "multivalued field" maybe in english ^^. I see a FM script that get the 2nd field like that : fieldName[2] Of course I tried this in my "getField()" method, even fieldName[1], but that return nothing... I can get the first value of this field but not others... Thx for helping !

Hi I have set up my database to be accessed by web publishing from outside my office. I am just using filemaker pro 10 advanced not server. It works great. However I would also like to access it with my full version of filemaker from my laptop when in my other office. Is this possible and can anyone suggest what the path would be if the file is in the documents folder of a mac running snow leopard. many thanks John

Now I have upgraded to the last version of the FMP (from 8.5) because the Instant Wep Module didnt work in that version. BUT now I can get the database published but its incomplete.. Some fields and tickmark boxes are missing, which seems rather useless.. What to do, shouldnt FMP be able to include all ? It just seems more and more like poor programing/implementing. Does the web approach only work with databases made in the final version ? Would be surprising since they have sold the "functionality" since version 8.5, but maybe it just didnt work ever ?? What is your experience ? Jakob

I am looking to see if there is a way to collect data from two separate portals (using the List function) and concatenate them in a calculation field, displaying the result in two columns. Example resulting calculation might look like this: Blues | Reds Sarah | Bill Jane | Jon Bob | Sue Any help gratefully received Thanks

I found the php.ini file and edited the memory_limit to 32MB, and that did the trick! Hi all, I am receiving this error when I query to a new list page I created: Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 76 bytes) in /Library/FileMaker Server/Web Publishing/publishing-engine/php/lib/php/PEAR.php on line 868 Any help? I can view the found set on other list pages, but this one page with a set of about 8 fields, gives that error message after listing 77 of the records. The total set is 165 records. I can login as different Users who have smaller record sets (110 is the next largest), and they do not receive the er…

I installed snow leopard and my filemaker 6 web companion will no longer work. Does anyone have a work around?

I have a databese hosted on the internet. It has several tables. Each table has an AUDITLOG field to track certain activity. When working in the database via FM remote everything works as designed (or perhaps I should say as "intended" ) When entering data via browser to IWP, the AUDITLOG field from table 2 is populated with data from Table 1. The AUGITLOG field for Table 1 looks like: Evaluate ( Quote ( Table1_pk_Field & " | " & Get ( AccountName ) & " | " & Get ( CurrentTimeStamp ) & " | " & Get ( ActiveFieldName ) & " | " & Get ( ActiveFieldContents ) & "¶" & _AuditLog ); [Table1…

Is it possible to give access to just one record on the internet and allow a person to make modifications? Here's the deal: We're starting a directory company, producing directories for small groups. A big part of it involves getting people to update their information. Ideally, we'd send an email and by clicking on the link people could get access to their own personal data and make corrections. If you've ever updated your profile on a website, that's basically what I'm looking for, but I'd love it if logged the user into their information automatically. If this can't be done in FileMaker (and I suspect it can't), if someone knows other software (including i…

i am new to filemaker server so please forgive my ignorance on this topic. i have a database which i want to host on a website. specifically, i want 4 layouts to be hosted. i also need the layouts to look exactly as they do online and work the same (script performance, subsummary report sorting, relational value lists which relate to fields from a different table, etc.) in case this is not enough detail for a solution to be suggested, below i have outlined the specific layouts that i need to host: 1) SearchForm - a form of global fields that is used to search for items in my inventory (the fields are from a different table). it also has a portal from which selec…

I'm trying to host a file on my computer so that someone else not on my network can access the file using their own filemaker pro 11 app. I already have IWP set up so I know that port forwarding is working fine at least for port 591. I try to connect using the same server information for IWP and it doesn't work. For example my IWP server address is host.com:591 and it works fine. When I type in host.com:591/databasename in the Open Remote File dialog box it doesn't work. Is there something I'm missing?

Can anyone point me in the right direction in finding a ready to go fm b2b website template. I need to deploy something fast. All data is already in a fm database as in product etc.

Hello! Is it possible to have people log in to a filemaker database over the web and interact with that database? Thanks For your help!!

I recently had an issue where only my dev PC could login to a newly created site created with FM Studio. I was utilizing a table based login and everything was working perfectly on my dev PC, but any other PC the login screen would simply refresh index.php. I even had an error message binding on the page that would not reflect any change. I was initially having the problem myself until I found a post giving instructions to edit line 4 of the FMStudio_Tools.php file. Basically, this is the code that determines the page that will load after a successful login. What I found out was that on the PC's that could not login I had to manually go to the "redirect" page…

I have just created a table based custom login page and everything works great as long as I use the Server hostname in the URL. I am setting up a DNS from outside and if I try to login using this URL it will not work. It will also not work simply using the IP Address as the URL. I initially thought that I had hardcoded some PHP to look at the hostname specifically, but I have searched the entire site and there is no reference to the hostname, and only one reference to the IP address in the connection include. Any help is greatly appreciated. ------------------------------ Update : I just did some testing and the problem is much stranger than I initia…

I'm relatively new to FMP. Last year I modified the Business Productivity Pack to meet our company's basic needs. We recently paying a hosting company to serve our database off site so we can use it in multiple countries and access it simultaneously. The hosting company charges us based on the number of .fp7 files we use. I removed the unnecessary ones. Now we are down to just 2 (Sales_Orders and Inventory). I would like to combine them so all the necessary data entry tables and relationships work in one .fm7 file in order to cut our monthly bill from the hosting service in half. Any tips on how to make this fairly simple task? Thanks!

Hi, i've created a database for tracking deliveries to our company shops and i need an explanation on how to share the database with them. I have FM Server Adv and the shops will have the possibility to connect to the server through 2X, what will be the best way to share the database? Web publishing maybe? If is correct, how to proceed? I'm pretty new to the server dark side of things.... Thanks in advance for any help.