Custom Web Publishing

I would like to know if anyone has done this and what steps they advise to convert a Filemaker Database to Mysql. Right now I have a Filemaker host that publishes my database and I have created CWP webpages for my clients to access and interact with. I would like to eliminate Filemaker and have all my records in Wordpress (Mysql). Thank you in advance for your help - Sam

Im using the Sendinblue API and some simple commands to add / remove contacts from mailing lists and all works as expected. But I'm having issues getting some extra attributes into my command and not sure how it should be formatted in filemaker Copy below of the Curl which Sendinblue says is correct, but I cannot get the 'Attributes' section to work, so I'm unable to add FIRSTNAME, LASTNAME and COMPANYYNAME I don't know how to format it in my variable here - JSONSetElement ( $json ; ["listIds" ; "[7]" ; JSONArray]; ["updateEnabled" ; "true" ; JSONBoolean] ; ["email" ; Contacts::Email ; JSONString]; ["emailBlacklisted" ; "false" ; JSONBoolean]; ["smsBlacklis…

Hello Everyone, I have FileMaker Server 19.4.2 installed in Windows Server 2016 and PHP (v 7.2.9). I am facing an isue while trying to connect to filemaker server database. It's throwing error as mentioned below: PHP Parse error: syntax error, unexpected 'new' (T_NEW) in D:\Program Files\FileMaker\FileMaker Server\Web Publishing\publishing-engine\php\FileMaker\PEAR.php on line 557 Not sure how to resolve this error. Pls suggest.

Our community has 100+ organizations that help with the homeless and with low income folks. We have a good list of those organizations and their particular resources. A friend wants me to set up a database with those organizations and characteristics that can be accessed by people in the community over the Internet - without access to Filemaker Pro. Help! How would I set up this application?

Time to start building that web front-end? Have fun learning at CodeAcademy! http://www.codecademy.com/tracks/php

Hey there ... has anyone experienced any issues when upgrading their server to 19 from an earlier version (in my case 14) when it comes to functionality of their existing CWP solution? Any functions that have been deprecated? Relatively simple solution (finds, adds, edits, etc). Thanks for any info.

I currently use FM CWP for my business/website. My current setup is: - FM18 database w/ a FM hosting provider Memory: 8GB Disk space: 30GB - Website w/ same FM hosting provider Shared web hosting (they do not offer VPS) By hosting my db and website with the same provider, I supposedly benefit from speed (same location), but I'm concerned that using shared web hosting runs the risk of site downtime. Over the next year, I expect my web traffic to grow significantly. Would anyone recommend I change my web hosting to a VPS (virtual private server) with a different provider to reduce the risk of downtime? (I would not change my db host.)

Given that you are starting a new custom web publishing site with FileMaker 19, with no legacy database or tools, starting completely fresh, building a solution that will not be hooked up to a store, but will be a multi-tenant solution that must include user authentication with at least 3 levels of security privileges. What development tools would you choose, and why?

Download : http://www.gokselgokce.com/index.php/2020/05/26/claris-filemaker-icin-php-kodlayicisi/

Download : http://www.gokselgokce.com/index.php/2020/05/26/claris-filemaker-icin-sanallastirilmis-web-sunucusu/

hi guys please help in this situation: Scenario: I want to retrieve the records of a database having 90,000 records via PHP, but unable to do it. How can i retrieve the complete records without any performance issue ? I am using the code: <?php $layout='web'; $fetchLayout=$fm->newFindAllCommand($layout); print_r($result=$fetchLayout->execute()); $values=$result->getRecords(); foreach($values as $recValues) { echo $test = $recValues->getField('make'); echo $instructorlist1=$recValues->getField('model'); echo $instructorlist2=$recValues->getField('year'); } ?>

Dear All, I am working on a project, where I need to insert image in every records using PHP. I have tried in both the ways, by executing script and also by using simple code for php. Please help me. If possible, please tell me the code, which I should use. Thanks in advance...

I've got a FMSv16 (can't upgrade yet due to Windows 2k8R2), and am using CWP to send data to the server using php. The server sends out SMS's via an online SMS Gateway and gets results back via php. This happens sometimes in a burst where hundreds of SMS's are send out, and the incoming results can overwhelm the server (in terms of connections, not CPU or memory resources). I've set the allowed CWP sessions to 1000, but I'd like to be able to terminate a session after the script has run. I've tried calling a FM script with 'close database' and 'exit application' at the end of the php script, and unsetting the $fm variable in the php script, but it doesn't termin…

I have not touched my early version of fx.php in years and now find that I cannot use PHP7. Have to stay with PHP5.6. Does everything need to be rewritten to migrate to the newer fx.php version. It seems rather daunting to me, not being much of coder. I have not found any help on the web on how to update an older fx.php version to a newer one. Thanks in advance for your help - Sam

Hi, I am wanting to list in a FileMaker field all the $_POST data ... I've been trying different suggestion but no luck. $request->setField('WBForm_First_Name', $_POST['first_name']); $request->setField('WBForm_Last_Name', $_POST['last_name']); ... 23 more. The next $request enters the number 25 in the WBForm_Comments field ... I have 25 fields in my form. $request->setField('WBForm_Comments', extract ($_POST)); The last step of the $request->setField I would like to list the actual data inside the $_POST to a non-editable field so the customer can look at for reference in the event they edit fields that were populated individuall…

Hi, Need some help, I built a CWP year ago but the solution never came about. I am in search of a tutorial that can give me some very basic examples but unable to locate any at this time. I will be meeting with the server hosting the soluiton Friday and I would like to have the HTML written and ready to upload to the server where the file for the solution is for CWP. All I am doing is providing a html page so any persan can navigate too, enter in the 8 pieces of infomation on the html page ... Project Name: Description: Qty: Size: Stock: Printing: Finishing: Shipping: Error check those html field to make sure th…

Hello - hoping for some PHP help I have a search function working on my website (see arina.biz/search.php) Basically it gives a list of search tags in a checkbox field and after a submit the results then follow under. I am thinking it might work better functionally if the results came up on the righthand side of the webpage - and in an independently scrollable frame!! I though about separating the two halves of the script but would the results then recognise the search variables? Thanks all I have attached my basic script Searchbackup.php

Don't forget! Monday July 24, 3:30–5:30 (before the 6pm opening keynote). Come see: Steve Winter @steveWinterNZ Mark DeNyse @mdenyse Ken d’Oronzio @kdoronzio Gjermund Thorsen ggt667 Joel Shapiro @jsfmp Hope to see you there! -Joel http://jsfmp.com/cwp-user-group

Hello, I'm new to FM and Custom Web Publishing. I'm playing with PHP and I after various days of searching I can't figure how can get the value of a summary field in a found set. This is the code I'm actually using, this code get the value of one record, not the value of all found set. (Excuse my English....) "Total Sales" is the summary field. Any help please? Thank you very much. $findCommand = $fm->newFindAnyCommand("MyLayout"); $findCommand->addFindCriterion("Year", "2018"); #$findCommand->setRange(0, 1); $result = $findCommand->execute(); if(FileMaker::isError($result)){ …

Hi all Moving a couple of Custom sites done with FX.PHP to Windows 2016 Server and from FMS 10 to FMS16. After moving the pages to FMS16, some of them work - and some do not. Yes, I changed all server_data.PHP files to the new IP and all references to the old database .fp7 names. Still, some of the "search_result" pages that are invoked after a PHP search give me a 500 Server error. If I make the query on those sites via a direct XML call to /fmi/xml/fmresultset.xml, all is fine. So: something in the PHP code - in PHP or in FX.php? - has changed its functionality vs what Filemaker can handle. Edit: or is it Filemaker that has changed it behaviour? …

Im sure im not the first person to ask this but here goes… How do I get an image to show on my webpage. My script successfully finds a record and displays the text from a number of fields. ( see arina.biz/search.php) I have added the following $address = 'https:fms.arina.biz:444'; $Image = $record->getField('Image'); echo $address . $Image; returns https://fms.arina.biz:444/fmi/xml/cnt/Monash-BLTB-300x200.jpg?-db=Projects&-lay=WebSearch&-recid=1462&-field=Image(1) This seems to the correct syntax based on the CWP manual. I believe it is a permission issue as I can click the link and using the PHP passwords see the image. Ho…

Hi all, many thanks for reading my post. I am working on a project with my sister who currently builds our databases at work with filemaker. We are working on a website together for release in late 2014 or early 2015. As with all websites, there's a frontend and a backend. We would like to develop the backend "usernames, passwords, user data, dates, times, data fields etc" within a filemaker database (that my sister can build), and then have a professional web programmer build the frontend using javascript or html 5 or something similar. I have a few questions: 1) Is this a stupid path to go down factoring in growth and scalability? If, hypot…

I have a projects DB where I am applying "tags" via a multiple checkbox field. I would like to make this field available on the webpage for searches to find the relevant projects. I was successful using a text box field but it would be much more user friendly to have checkboxes of available tags. As time goes on, the tags list may grow. So my question is how would I code the value list options as checkboxes into a search field on the web. My code works for the text field and a single checkbox but not multiple checkboxes. I tried to create a search array using some manual entries and $find = $_POST['search','search1'] but this didn't seem to work. In any event I …

I really am not sure where to start with this. I would like some fields of a database (hosted on FMS) to show on a webpage and be searchable. I can do this through web direct but I would prefer a user not to be kicked out of the company website to go to a web direct one. Any thoughts and guidance? Unfortunately im not good a web coding nor understanding the protocols for interaction. thanks

Hello, I am trying to convert a custom web publishing site in php, from FM Server 12 to FM Server 15. We've updated the Windows machine that hosts it (to a shared server on the recommendation of IT) and installed FM Server 15. Direct opening of the existing scripts always yields 0 results, though the database hasn't changed. Is there some setting, somewhere, that I am oblivious to? I've consulted user's manuals, IIS settings, web postings, ... Attached is a copy of the website I am running. I can point you to the existing website, though I doubt it would be useful. The beginning part of this website are script tracking errors. I've been…

Hi, am Simon, new to Filemaker. just wish to ask if its possible for one to build a complete web app with Filemaker products. (Online Learning Platform. LMS)

LS, We are running FMserver with custom webpublishing. People can connect to the website and see pictures that are attached to propositions. The pictures folder is located on the FMServer as well and getting pretty big now. So we are complating moving the folder ( it is currently located in htdocs ( running on a Mac )). How do we reconfigure FMServer/apache to do this? Kind regards....

I have apparently installed RESTfm properly because when I go to the report page everything is Green and looks fine. However, when I go to localhost/RESTfm and get the prompt to authenticate nothing works. I do not get any errors at all, the prompt just comes back. I have tried using Server and database credentials but nothing works. I did have this working on a previous server and did not have any issues of this kind after getting everything "Green" as mentioned before. Server version 15 running on Windows 2012/IIS 7 Any help is greatly appreciated.

Hi All, I am trying to set up a very basic HTML page to test out the FileMaker 16 Data API. I am on a Mac - EL Cap Test server: First of all I am using the Postman app on local host FileMaker server. I have got that working pretty well with success with scripts. I am attempting to take those settings and put them into an HTML web page. The first thing I am trying to do is try getting an authorization token using the post method with HTML web page. Currently, the pages are coming back BLANK including the console log so it's hard to track. Question: any ideas on how to get this set up? Here is my example test below– Any assistance would be app…

Hello I have a personal travel itinerary database where I can view destinations and travel routes using the web viewer. I notice that when use maps.google.com.au the web viewer is different to the one I see in safari (Mac OS Sierra). Key features of the Bowser version are not available including a tab button to hide the destination information and additional travel options such as Plane. Anyone have any ideas why this is happening and better still if it can be corrected. For convenience I have attached a file showing examples. Thanks webviewer test.fmp12.zip

Hi, I would like to be able query my remote database that's being hosted by FM Server on my Mac but I'm unsure about the best way to do this. Previously I've updated records but creating a simple php script that lives on the FM server and calling it using curl from my mac. Up until now I have always extracted data by opening the remote FM server database in FM Pro on my mac and using applescript to interact with records but if possible I would like to do the same without having to open the remote database using FM Pro. What would be the best way of doing this? should/could I run a php script on my mac that interacts with the remote database and returns me the results…

Hi, My programmer and I are trying to set up communication between FileMaker 16 and a WordPress website(www.heightspethospital.com.au ) so our veterinary clients can do online booking and look up when their pets are due for vaccination and other treatments. My programmer has hit a problem. The code does not work on the WordPress Server (www.heightspethospital.com.au), though it works on his local machine. He gets the following error: “Communication Error: (7) Failed to connect to 203.206.217.177 port 8080: Connection timed out” Filemaker error codes suggest this is a memory issue, but my programmer is sure it's not related to memory. …

I'm not a noob at FM, but never did anything on the web with it. I'd like to put a FM file on a web space (like where my homepage is) and access that with my desktop or my phone. This is only personal data used only by me. Searching turns up a lot of info on hosting services, FMS, and stuff I don't understand. In the manual I found what sounded right (using an URL) but I couldn't get it to work. Are there any step-by-step instructions on how to accomplish this? Thanks, Stefan

Just checking the Event Viewer for a PHP error and noticed many of the following entries: PHP Warning: Creating default object from empty value in C:\Program Files\FileMaker\FileMaker Server\Web Publishing\publishing-engine\php\FileMaker\Implementation\Parser\FMPXMLLAYOUT.php on line 53 I know these are only warnings but would like to eliminate them if possible - I'm running FileMaker Server v16.0.1 using FileMaker's version of PHP. Haven't been able to find anything so far - anyonke know how I can prevent these warnings from being logged in the first place? Looking to eliminate them not suppress them if possible. thanks

I'm trying to understand what could generate an error when performing a FileMaker script from via the PHP API using the newPerformScriptCommand command, e.g. $scriptObject = $fm->newPerformScriptCommand($layoutName, $scriptName, $scriptParams); // Execute the script $scriptResult = $scriptObject->execute(); if(FileMaker::isError($scriptResult)) { // FileMaker PHP API Error -- Alert User. $scriptError = 'Perform Script Error: '. $scriptResult->getMessage() . ' (' . $scriptResult->code . ')'; } else { // no error - continue on } I realise that if any of the newPerformScriptCommand parameters have errors like an invalid layout name or script name it…

Hi all Come join us at the 11th annual CWP User Group at DevCon: Monday, July 24, 3:30–5:30pm (before the 6pm opening keynote). Do you have something you might like to share with the group? Please let me know. We're always looking for new people! Everyone's welcome. Hope to see you there! -Joel http://jsfmp.com/cwp-user-group ~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro : database design : web development http://jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~

FREE fmREST.php – Simplifies & manages PHP connections to FileMaker 16’s REST-based Data API. The newly released FileMaker Server 16 now offers REST access to your FileMaker databases. There’s more about that how this impacts PHP developers here. The bottom line is that to use REST as part of your PHP solution, you would usually need to write a series of cURL functions and you would have to manually manage connecting & disconnecting from your server, and saving your tokens. This is a pain! We know it’s a pain, because we have spent the last several weeks rolling REST functionality into soSIMPLE Calendar. We created this class file to make i…

I have a website that is displaying FileMaker data using the PHP API. Is there a way for the web site to display the basic text formatting from a FileMaker field? For example, a few words in the comments field are bold in FileMaker and I would like them to also be bold on the website. Thanks for any ideas.

Ahoy there ! In the old days, there was a plug-in for Dreamweaver, helping filemaker programmers to design web layouts interacting with filemaker database. Fm Studio was the product, now a discontinued product. Last edition was compatible, as far as I know, with FM 12. Does anybody used this product ? Does anybody have this last kit ? Is any other product able to replace this FmStudio ?

I am having an issue with a value list not showing up on my php page consistently. Most times the value list appears as it should. Some times it will come up blank. If I REFRESH the page, then it usually appears. I don't think my coding is incorrect because it works most of the time. Why would I have to refresh the page for it to appear. Does it have to do with the server connection…? I do display other fields on the php page, like name and email address, but the value list is the only one that does not show up all the time. CorrectVL.tiff incorrectVL.tiff

I have a PHP page that allows users to search our department directory (of people). It works, but if no records are found, then they get a header graphic and nothing else. I have looked online, and I think my FileMaker::IsError syntax is correct, but it does not display. Would someone look at the attached file and see what I've done wrong? (Once I get it to display an error code, I can customize it and trap for various errors, but right now I only get the header!) Thank you, Brian namesearch.php

I am pulling data out of FileMaker 10 server to a web page and displaying numbers in a table, everything works great! until a number goes over 9,999.00 then it just doesn't display at all. Anyone have any idea what is causing this and how to fix it? I assume it would lay in my php code since the number 11,000.00 is showing in the database, just not in my table on the web page. My code: <?php echo '$'.number_format(round($Number_row->getField('iAverage'),2),2); ?> Any help would be much appreciated!

Hi, we are using a little sync script via php, which allows us to store all data from a FileMaker DB into our internal MySQL-Database. The only problem iam unable to solve is how to download images from container fields and store them local on our web server. I tried something like: foreach($recordsPersons as $recordPersonsData) { //saving images to /srv/www/htdocs/ $url_orig = urlencode($recordPersonsData->getField('FotoDatei')); // Search for the extension of the file $url = substr($url_orig, 0, strpos($url_orig, "?")); $url = substr($url_orig, strrpos($url_orig, ".") + 1); // Send th…

Hi, I'd like to creat a sorting order with a $varCount like: 1 1 2 2 3 3 and alternating row colors that will print: pink pink yellow yellow pink pink Here is the kind of coding I'm using that works fine for sequential numbering and odd/even row colors. I appreciate anyone who can help me change these parameters, as I have tried every combination I could think of. Thanks! <?php $row = 0; $varCount = 0; foreach($records as $record) { $varCount = $varCount + 1; if($row % 2 == 0) { echo '<tr class="alt_row_color">'; } …

Hi all, I have a database that is being accessed via custom web publishing externally and I would like to generate a url for a specific record, is this possible? The idea being that if I generated a url to a specific record I could email it and the end user and they would only have access to that 1 record. Thanks, Nik

I've created a compound found which works. I know need to constrain that foundset by omitting records which I would do with another find in FileMaker and the constrain with omit criteria. Is it possible with the api to do this? I need to omit after I have found the records.

Does anybody knows where to find Lasso's how to' for FileMaker ? Marius

Does anybody have the working files from "FileMaker Web Publishing A Complete Guide to Usingthe API for PHP" book (Author : Allyson Olm, Stephen Knight and Michael Petrov)? I was looking after them for a while, and didn't find it. Thank you, Marius

Hi, accessing external SQL resources from within FileMaker is quite common. But how do I go about the exact opposite? I have an import_nwde:: table in a fmp12 file hosted on FMS 15. I have switched on ODBC in FMS. I can access the tables with Windows and Mac (using the Filemaker ODBC drivers specifically installed to do this). But how can I write into this table from within a MySQL database running on a LAMP machine? Whenever something happens on the website, I need to process the data in FileMaker. Thanks a lot for any help, Gary

Our Web Publishing Engine keeps crashing. We have a two-machine setup, both running on Mac El Cap, 10.11.6. Yesterday we did fresh downloads of Server 15.02 to both machines. We did the clean uninstall and reinstall procedure on both machines, as called for by FM KB article 15550. Filemaker tech support says that pretty much rules out Filemaker Server as the culprit. Today, the problem is actually worse. The WPE crashed three times this afternoon. Symptoms: We see no problem with Pro access to Filemaker. We see no problem with WebDirect. Several people within the office use that method of connection and it continues to work while CWP goes down. M…

Hey all, Hoping someone can help me out. I am using a two server deployment with FileMaker Server 15. I have created a simple database with two fields, MemberID and Display. The display field has a static value list applied to it called YESNO and the values contain Yes,No. When I call the getValueListTwoFields command, my web page displays an error 500. As soon as I remove the line $layout->getValueListTwoFields('YESNO'); and put in a simple array, my code works fine, I can retrieve data from a field but any attempt to list, display a valuelist causes the web page to fail. Anyone have any advice to offer, I've tried everything possible, made sure the db has w…

Hi, is there any reason my DB crashes web publishing engines? It is a simple database on an FMP12 server. clients generally toggle simple buttons on or off. Is there a function inside the DB itself that I have not turned on or off? Is it a sharing, permissions or admin thing? Is this a problem with other users? I'm new and you guys in this forum have really helped me a lot! Thanks in advance!

Greetings - I got my start with CWP using FMwebstudio as the front end library to the FileMaker API (Dreamweaver). That library is no longer maintained. One of very cool things about that library was a dynamic field capability, fmsLiveInputField, where the changes you made in a web page were updated into the database in real time. I used it for event registration where the total attending and fees due automatically updated. I'd like to replicate this functionality ... display the total due, a show a few other live calculations. I prefer a PHP solution but realize javascript might be a better approach these days. I'm not a javascript guru so your help po…

Hello! Another post... Please help me out. I am trying to create an array from a value list within Filemaker Pro (Using PHP API) The idea is to create an array of names from a value list I have set up... Then put them into an option tag. e.g. $staff = array(FileMaker Value List) ^^ I know that's incorrect, but it shows what I want to do Then with that array I want to be able to Create a HTML option list (I know how I would do that) --- I am just really struggling with creating the array... Here is what I have $database = "comms__web"; $hostname = "###.###.#.#"; $username = "web"; $password = "################"; $la…

I am stuck with a very painful one: I am using cwp php to access FM data from FMGo (iOS SDK 15) using 'insert from URL'. On a very erratic basis, I either get a successful call or a "Communication Error: (22) The requested URL returned error: 500 Internal Server Error" response. Credentials have been checked over and over again : they are valid The fmphp flag for the user is set No actual correlation with server load/activity. This happens either when CPU is spinning or when it's flat as brain-dead. Same for RAM I can see quite a bit of posts out there on this 'Communication Error: (22)' - sometimes with alternate H…

Hey Guys, i've got a filemaker script which uses the execute sql command a couple of time to retrieve data which is contextless. i now need to port/convert that FileMaker script So it works with PHP API. When i've worked with the API in the past there was no command equivalent to execute sql, is it still the case - or is there a work around to this. Worse case scenario is for me to create a FileMaker script and get the api to perform script and store the result in php variable. However really wanted to keep php scripts isolated from my FM scripts. Thanks in advance

Hello all So I'm pretty new to Filemaker and CWP - I have created a form which people fill out and it stores the data in a filemaker solution. The idea being a script is then run which will notify a user if the form has been submitted. Now I have the script for that and all the Filemaker side completed, as well as the data entry from the PHP form, but I am really struggling with running a script with a parameter... It runs the script, but not the parameter attached. For a bit of context, Someone fills out the form and it is entered into the database, a script is then called with the parameter being an ID, the script then checks the ID with the paramet…

I have a php page using the FileMaker PHP API that performs a FileMaker script using the newPerformScriptCommand method - this all works well so far. The script performs a bulk email to a selected group of records and can include an attachment. We've found an issue where if someone selects a reasonably large attachment (e.g. a 2mb PDF) the FileMaker script will still send the messages successfully, however the php script encounters an issue and i get "The page cannot be displayed because an internal server error has occurred." in the browser and there's a 500 error in the IIS log file for the script. Does the php script have to wait for the FileMaker script call…

Hi all We're going to be having our 10th annual(!) CWP User Group on Monday, July 18, from 3:30 to 5:30pm (just before the 6pm opening keynote). Got something you'd like to share? Please let me know. Everyone's welcome. Come join us! -Joel http://jsfmp.com/cwp-user-group ~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro : database design : web development http://jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~

Server: Windows R2 2008 SP1 FileMaker Server 13 Connections via PHP I have several databases that users connect to via a web browser using php. All has been working correctly until Friday 1/3. I have been assured by IT that the server has not changed. However, the PHP connections are no longer reliable. Sometimes, the user can log in fine. Other times, a user logs in, submits a request, and it looks fine to the user. However, the "Error: Did not receive an XML document from the server." is thrown. Other times, the error is thrown and the user knows something is wrong. Sometimes the form will display the correct information, and sometimes the form cuts off…

Sorry this is so long -- I'm having a difficult time explaining what I need without some background. What I need: A app which stores client data and makes it available to a team of distributed web users. A place to host the database so that it's available on the internet. User-level access so that when a staff member leaves we can lock them out. Questions: Do you know of an app which would work or do we need to create a custom solution? If not, is FMPro the right platform for us to be developing this solution on? If FMPro, do you know of a good developer to handle work like this and would you mind sharing their info with me?…

hello, i'm a beginner, i have problem with a php script, i run it (1/2 minutes), reaches the command execute() and then it stop with no error message. this is the script: $fm_a = new FileMaker($file, $host, $username, $password); $a_table = $fm_a ->newFindCommand('layout_name'); $a_table->addFindCriterion('online', '1'); $a_result = $a_table->execute(); if (FileMaker::isError($iconografia_result)) { ....... where i'm a wrong? thanx for your time and collaboration Simone

Hi all, I was wondering if anyone had any solutions to host a FileMaker Database on my website. I currently have my website hosted on x9Internet. I have looked at filemaker hosting websites but would like to pay an annual fee as opposed to a monthly fee. If anyone has any other options for creating a database without FileMaker and hosting it online please advise. Thanks

Hi, For some reason I can't get value lists to work on my CWP PHP solution. I have a value list "Test" with four values (one, two, three, four) on a layout called "Test" where I have a field called "Test" that is a drop down menu using the value list "Test". When I use the following code, I get an error on my page. I have two included files one that has the $fm variable created and the filemaker.php include. Here is the code: <?php require_once 'FileMaker.php'; require_once("secure.php"); $layout = $fm->getLayout('Test'); $values = $layout->getValueListTwoFields('Test'); ?> What I want to do is create a drop down list on my web page where th…

Since appending/combining PDFs with FM Go is not available natively and using a robot machine is not an option, I've dug up a handful of PDF APIs and options. I've got about 1/2 way through the problem, but I am getting some errors with the PDF API and not getting a lot of feedback. If anyone is interested in collaborating, please send a PM. Currently, I'm able to send two encoded PDFs from FM to the script and the script will spit back the combined PDF into a container field in FM. Super simple implementation. The PDF that comes back is blank, but has the correct number of pages. The server log shows some errors relating to the PDF API and that's where I'm stuck. …

Hey Guys, I've got two sets of results from two different queries. The fields in both tables are almost identical, the one field I need to access is. My question is before I continue to do the foreach loop to return the appropriate field, can I merge the two results together prior to my foreach loop? It would basically help condense some of the repetitive code. the only field I am interested in retrieving from both datasets is called dataPlot. $dataset1 = $fm->newFindAllCommand('table_dataset1'); $result1 = $dataset1->execute(); $dataset2 = $fm->newFindAllCommand('table_dataset2'); $result2 = $dataset2->execute(); Many thanks …

Good morning! I need some help getting something working. We have a company website, and we are trying to create a instant web publishing portal for our customers to login and view their open invoices. Pretty simple. We have all of our information on a FileMaker solution that is hosted with FileMaker Server 12. The problem is we can't get it to work the way we want it to. This is our idea and how we kind of want it to work. We want the have our customers create their accounts/passwords on our actual website. We will store their account information on our web server. We will authenticate their login on our web server. Then, after they log into our …

Good Morning, Stumped with a FileMaker Server 14 installation and getting the PHP web pages to work. Machine Specs: Mac OS X El Capitan v10.11.2 Mac Pro (Mid 2012) Processor: 3.2GHz Quad-Core Intel Xeon Memory: 12Gb FileMaker Server 14.0.4.412 installed SuperContainer 2.93 installed When viewing the FM 14 Console: FM Server is Green Web Server is Greyed out, PHP is enabled and XML is enabled (See attachment of screen shot) Web Publishing Engine is Green ODBC/JDBC is Green When trying to run the test page (Server > Open Test Page and clicking Test PHP Custom Web Publishing) …

I have the same exact solution files setup on 2 separate server stacks. Everything is working perfectly one one, but on the other I'm getting this Communication Error (22) and I cannot figure out why.The message says specifically... The files are exactly the same, though. The FileMaker files themselves and the PHP files. The usernames and passwords are all exactly the same in both places. It's just that they are running on different server stacks. Both, though, are a combination of FileMaker (in-house) with a web server hosted by the same hosting provider.I have a very basic script setup to test the connection to FileMaker by displaying the available data sou…

I'm performing some find operations that I only want to get the total number of records returned for display purposes, and don't need to return any records. I've tried using the following: $max = 0; $skip = 0; $request->setRange($skip, $max) $result = $request->execute(); but this looks like it's returning all the found records, not zero records. I had assumed 0 was a valid value for $max but it appears this isn't so. Anyone have any experience with this or know a way to return zero records but still be able to call getFoundSetCount() to get the total number of found records?

I would like to edit a value list via a web interface- I have done this using a field ("Use values from field"), but that [I incorrectly assumed, see doughemi's suggestion below!] requires adding/editing a record for each value, while (if possible) the textarea box would allow the editing of the whole value list at once. Genx showed how to display a value list... $layout = $fm->getLayout('my_template'); $list = array_map("htmlentities",(array)$layout->getValueList('my_list')); I am hoping there is some easy way to send back an edited valuelist… We are using Filemaker Server 11 (not advanced). Thanks in advance!

I am in the process of modifying a FileMaker CWP site where a user was allowed to view a video hosted outside of FileMaker. The company upgraded to FileMaker 14 from FileMaker 11 allowing the usage of the getContainerURL method and uses embedded video file in a FileMaker container. My issue is simple, when I use the method I am prompted to authenticate. The authentication prompt is not a total surprise because I “suspect” that the method call is a new session call to FileMaker. So is there a way to use HTML5 and play the video from FileMaker without the prompt? Note: The prompt is presented across all browsers. I cannot imagine this is a new question but for som…

I'm using setResultLayout for the first time so I can search on one layout with all the find fields on them but then switch to a much simpler layout with just the fields required for the search results. My search looks like this: $request = $fm->newFindCommand('WebSearch'); $request->addFindCriterion('customerName', $_GET['contactName']); $request->setRange($skip, $max); // Set the layout to use for the Search Results $request->setResultLayout( 'WebSummaryList' ); // Perform the Find $result = $request->execute(); if (FileMaker::isError($result)) { if ($result->code = 401) { $findError = 'There are no R…

Hi all I just helped someone else with this problem, so I'm posting again here to make it publicly available: THE PROBLEM: The PHP API function "getValueList" can break under FMS10 when there's an ampersand (&) in one of the values: "apples & oranges" > becomes > "apples apples &apples & oranges" The function has officially been "deprecated" in FMS10 -- and replaced with "getValueListTwoFields" -- but the ampersand is a case when the original function in fact _breaks_ when hosted in FMS10. Changing to the new function fixes the problem. (I don't know if any other characters also cause problems.) WHO THIS AFF…

Hi, I'm doing a newFindAllCommand in a db with 5000 records. I get no results unless I set my $myFind->setRange(0,500); , which only returns the first 500. 500 seems to be a cut-off point for some reason, Is this a thing? Also, I want a varCount that doesn't refresh back to '1' when the next 500 records are displayed, i.e. the next record numbers should say 501, 502... Thanks again!

Hi, I'm trying to find records with a number field that are greater than or less than 2 numbers, i.e. if I'm looking for the records greater than 115 and less than 120. $myFind->addFindCriterion('ssvm', '>115'); $myFind->addFindCriterion('ssvm', '<120'); do I need $myFind->setLogicalOperator(FILEMAKER_FIND_AND); or am I way off base? Thanks for your advice!

My permissions are set correctly with one Admin account with full access and one guest account with access to creating and editing only. I am not getting a password prompt when I delete records so anyone can delete them. Do I need a PHP validation code of some kind to require a password when deleting records? Thanks!!

Hi, I have several fields I'd like to sort that are empty, like Email. Here are 2 snippets of code that are not returning results: $RandyFind->addFindCriterion("Email", ''); or $RandyFind->addFindCriterion("Email", "=="); Any thoughts? Also, is there a way to force null into a field when editing? Thanks a Bunch!!

Hi Guys, I've built an application and one of my 'dialog' windows has a web viewer in it which contains a html text editor. I use api for php to add content back into a FileMaker database when someone submits the html form. This all works well, however I would also like to shut down my FileMaker dialog window, upon submit. Is this possible using the API for PHP somehow calling a client-side script to close window for the particular user? Thanks in advance

Hi, I'd like to sort records using value lists as well as text fields. My FirstName field works (try Steve) but I'm at a loss on how to make the valuelist sort records correctly. I want to search records from CA in my State valuelist. Here's a link and the php code. Thanks All! http://ssvtennis.com/valuelistsort.php valuelistsort.php

I have lots of searchs that may return 'no records'. Is there coding that will not kill other php requests on the same page? Can I make an If statement that will search my db for a count of records before a result is executed: something like if ($_Get Count($field == 1) my field is 'lafall1'. it is a tennis tournament. when someone clicks 'yes' for lafall1, it returns the number '1'. this way, when someone plays 'lafall1', lafall2 and la fall3', a calculation field returns that 3 tournaments have been played. If no one has clicked 'yes' for 'lafall1', the query will return an error: no records match this request. It stops the script and the coding on the rest o…

Hi, I'd like my New Record.php to advance to an Edit.php upon clicking submit on the New Record form. I don't want to remain on the New Record.php, but doing otherwise gives me a 'no record created' message. Here's an example of my New Record.php Thanks! newinputplayer.php

Hi everyone, I just signed up here and have a question that is probably really simple. Question: I want to know how to map a website like crm.mysite.com to my FMS14 custom web publishing site. Details: The domain is through GoDaddy. Right now I have created a subdomain and setup forwarding to the public IP - which works for the outside world but when on the internet network it can't load the page because it's pointing to the public IP. I'm not very good with this kind of stuff, I just want to be able to use the url crm.mysite.com to get to the solution no matter if it is inside or outside of the network. Thank you in advance, and sorry if I didn't provide…

I am trying to create a login process based on the Accounts and Privileges in FMP. I have, as a guide, Johnathan Stark's article "Deliver Secure Web Applications with PHP and FileMaker Pro" from the February/March 2008 issue of FileMaker Advisor. Copying Johnathan's code is no problem and I understand how it works. However, I'm trying to do it a little different: 1. I have an "includes" folder which contains, among other things, a header.php file. This way I only have to go to one place to change things like the horizontal navigation. 2. The "includes" folder also has a functions.php file (based on Lance Hallberg's DVD series "FileMaker 9 & PHP Foundatio…

Hi, when a search returns a listing, I'd like a numbered sequence like: 1 2 3 4 any example of how to do this? I appreciate your help!

Hi, I've currently got a script that takes JSON data and using the Filemaker API, puts it into my Filemaker database. This works great, I run my php script and it fills my filemaker table with all the pulled in data.The issue I have is when a record in the table needs to be updated, the api skips the record it as there is a unique field in the filemaker database (my chosen key field) as it already exists. I can get round this by using php to create a csv from the Json, then run a script to import into filemaker matching on the unique field, but it seems more of a hack than a robust solution. Is there a way of grabbing the internal record id from filemaker when cre…

Hello, I want to have a script pause when a field is not empty, and to continue as it is not empty any more. So I tried this infinite loop: while (1 == 1) { echo "Test if field is empty..." . "<br>"; $val_block = $record->getField("web_block_n"); if ($val_block == "") {break;} echo "wait for field is not empty..." . "<br>"; sleep(5); } Result: When field "web_block_n" has already been empty, the loop breaks immediately as expected. But if the field is not empty before the php script starts, and I make it empty after start, nothing happens. The browser from where the script was called, is just in wait mode, and no echo output…

Am running a two-machine deployment of Filemaker Custom Web Solution on OS-X using only PHP and would like to edit the error document(s) for the server. I've already altered the document on the Apache side (HD/Library/Filemaker Server/HTTPServer/conf/httpd.conf, which I do not think is ever used) but when I attempt to edit the Tomcat error-page, the server is reported as "not responding" and, indeed, does not work. The file I attempted to add an error-page directive was HD/Library/Filemaker Server/Web Publishing/publishing-engine/jwpc-tomcat/fmi/WEB-INF/web.xml. The reason I wish to do this is that I used to have an XSLT deployment that I have changed to PHP. And wh…

Hello, I'm trying to increment 1 to a value that is already on the database on a layout, but I cannot seem to be able to do it, here is what I did step by step. //Searchs for the field, and saves the value $findCommand = & $fm->newFindCommand('PHP_Prefs'); $findCommand->addFindCriterion('id_prefs', $_SESSION["prefs"]); $result = $findCommand->execute(); $records = $result->getRecords(); foreach ($records as $resultado) { $atual = $resultado->getField('service_ID_serial'); } //Trying to increment 1, withou success $rec =& $fm->newEditCommand('PHP_Prefs'); $rec->addFindCriterion('id_prefs', $_SESSION["prefs"]); $rec->setField('service_…

Hi, I'm running FileMaker 12 on a Filemaker 13 server. I'm able to sort and delete records, but cannot edit or create new records. Here is a snippet of my code for entering a new record, any help would be appreciated! <?php include('start.php');?> <?php $request = $fm->newAddCommand('my_layout'); $request->setField('FirstName', $_POST['FirstName']); $result=$request->execute(); ?> <form action="InsertRecordSimple.php" method="post" name="Insert"> <table border="1"> <tr> <td>First Name </td> <td><input name="FirstName" type="text" id="FirstName" /></td> </tr> </table> &l…

LS, We currently have this worker machine running, but I want to get rid of it. The worker runs a FM-script every 5 mins and exports some data, which is then uploaded to an ftp server and then processed by the website. The script does several xml-exports. It starts by searching for certain products , then it exports the data to and xml file ( xml-result ). After that is does a go-to-related script-step ( matching all records ) to commercial descriptions of the products and then exports this data as an xml file. We go back to the found set of products and then repeat the proces for more related product data. As said, all data is exported and the uploaded to an ftp-serv…

Hi Guys, We currently have a FileMaker Server instanace running, it already has PHP web publishing running. I'm just wondering is it as simple as ticking enable XML web publishing for it to be up and running or have I got to restart the server?? Thanks

Can FileMaker communicate with another website's service api? I am very unfamiliar with APIs in general. In my specific example, a website file hosting service called "SmartFile" (much like Dropbox) offers an API where I can download my activity log from my account: https://app.smartfile.com/api/2/activity/ can anyone offer some insight as to how I could import data into FileMaker via this API offered? They say they support json as well as xml. Any help pointing me in the right direction is much appreciated.

Im looking at creating a connection class for connecting to the different databases that ill be needing to connect to to query for data and not familiar with classes much but found this one im trying to figure out. How do i get it to work properly and return to me what i need and also that it did connect successfully? as well as being able to use it for other filemaker databases i need to connect to? The connection details below is example but ill connect to logins.fmp12 first to check the users credentials with a table that has their login and password info then if success and they are active then ill go to a layout where they can do finds and pull data for cu…

My question may be as simple as how do I enter a date in DD/MM/YYYY format using a radio button? (If you can answer that, ignore the rest). I have a simple form for online Timesheets that we have been using for years (thousands have been entered without almost no work on my part since I set it up). Now we want to change the date format from MM/DD/YYYY to DD/YY/YYYY. Everything works except where I auto-enter the "Period Ending" Date. An assistant updates the global value for the "Period Ending" Date in FileMaker every two weeks- this date needs to be auto-entered in new Timesheets (but must be modifiable by workers). Since addrecord.php is creating a new record I u…

Hello, I'm new to developing with FileMaker API, but I have been able to do some stuff with it. But now I reached a wall, and I would appreciate any help. I'm trying to use the following code to list the content of a Value List, but I'm not seeing how to do it. (You can also see the attached file). I added a few comments on the code, and I would appreciate any help on this situation. - Henry index.php

This is an open-ended request for recommendations for a dedicated web interface. I'm describing what we're trying to do and what tools we have, and am interested in any input & advice. We're a public library, and we have a promotional Web site in place that features a calendar of public events. This is built on DotNetNuke, the CMS preferred by the host/developer that we contracted. FMS13 (will upgrade next week to 14) publishes an XML feed which DNN polls every few minutes. The functionality I want to add is allowing patrons to log in to a site, set up free accounts, log in and register for events. Also some management (i.e. canceling participation, etc.). I think I…

Hello! I'm attempting to display a portal field. $find = $fm->newFindCommand('PHP_Client_Live_Container_All'); $find->addFindCriterion('All_Timesheet_Number', $tsn); $find->addFindCriterion('Job ID', $jid); $findResult = $find->execute(); $timesheet = $findResult->getFirstRecord(); $relatedSet = $timesheet->getRelatedSet('OnlineTS'); if (!FileMaker::iserror ($relatedSet)) { foreach ($relatedSet as $relatedRow) { $clientName = $relatedRow->getField('OnlinteTS::Client_Full_Name'); echo $clientName; }} Upon looking at our database, I find that the record stored in $timesheet is on a table related to OnlineTS through another table. I am ass…

I'm having a lot of trouble figuring out how I should be formatting a Time for input into a field. How should I do this? I was able to input a date by taking a date with the format MM-DD-YYYY and putting it through date() and setting a date field to that, but I can not for the life of me get time to work. I'm working from a form, so I can format the initial input to the page however I'd like, and just need to know how I can get FileMaker to accept it for a time field. Thanks all

Hi All, Need your help !! Recently i upgraded my FM Server to version, 13.0v9. With the earlier version of FM server, i had created a custom php solution which was running fine. Now, after the upgrade, i am not able to fetch records from the database and also can not run any FileMaker scripts from PHP. What could be reason/solution? Thanks in advance.