Custom Web Publishing

Hello, I have a problem I shall post a page index.php My I can not create or delete contacts I visualized, or search for a contact in my database it appears right Pourais someone watching or I wrong in my code thank you ------------------------------------------ <?php $addCommand = $fm->newAddCommand("web_contacts", $donnees); $result = $addCommand->execute(); if ( FileMaker::isError($result) ) { $erreur_ajout = "Erreur : " . $result->getMessage(); } } if( isset($_GET["action"]) && $_GET["action"] == "supprimer" ) { $deleteCommand = $fm->newDeleteCommand("web_contacts", $_GET['recid']);…

I am sure I should be able to do this, but I'm clearly missing something. Any help would be appreciated: I have created a test database with very little complexity in structure or security. The URL is here: https://www.charitypilot.org/FMS/testindex.php The database schema can be seen here: http://prntscr.com/6ai5gj Credentials for user [email protected], [email protected], and [email protected] are all password asdfasdfasdf. Login and see the results I'm getting. They are the right number of rows from the data array, but no field values. The layout being referenced is based on the Individuals table. The table/portal/field names for the referenced layout are visible…

HI all,  I am getting an issue while executing a FileMaker script through PHP API.  Issue: When i am sending a script parameter through a PHP API, the script is executed correctly. But, on web page, the script parameter gets displayed.  I am also attaching the screenshots of the PHP code as well as web page .  How can i resolve this issue?  Thanks in advance.  Â

Hello everyone. I'm plyaing for the first time with filemaker PHP API, and, even if I succeed on doing a basic newFindRequest (), I'm stuck on something that must be very simple but I can't get working. I have a layout called "Php Ipv4 Blocks" linked to a table that keep tracks of IPs as long and the country associated to thoses IPs. My table structure looks like this : In my php script, I transform an ip to a long value and then, I try to perform a newFindRequest() where I use this function to transfor IP to long : $longIp = printf("%un", ip2long($IP)); If I try with a random ip, for exemple : 173.176.47.188 Converted as long I find this…

I am trying to get results based from a range. I have Date_Start and Date_End which are exploded so they meet the filemaker formatting. Then I take a variable of $dateRange and get it to use those two fields mentioned above. I just get an error however of "errorCode=508&errorMsg=Invalid+value+entered+in+Find+mode" Can you see anything out of the ordinary? Thanks for your help and I appreciate your contributions on the forum. Your helping me out anyway. &lt;?php require_once('Connections/User.php'); ?&gt; &lt;?php //Setup date to be in US format from AU format $date_input1 = $_REQUEST['Date_Start']; $date_array1 = explode ("/", $dat…

I am working with the FMPHP_Sample.fmp12 database and php to understand how the API for PHP works. Mostly I have gotten things to work, but for a few errors I don't understand. I have a different host for the php files then where the FM server is. I placed the API Example php files on my host and included: FileMaker.php and the FileMaker folder. I can view the list in displayRecords.php and individual records inviewRecord.php I get the following error when I try to create a new record or delete a record (the records are created and deleted): Warning: Cannot modify header information - headers already sent by (output started at /home/smilep6/public_htm…

Hi folks, I am using: <input id="date" class="form-control" type="text" name="Date" data-data-format="dd/mm/yyyy" value="<?php echo date ("d/m/Y", strtotime ($found_flight_row->getField('Date') )); ?>" /> which allows me to have a date picker and also display dd/mm/yyyy via the 'strtotime'. What I am trying to do is have an edit query so I can edit the date and submit that. On my edit_response page I have the following for the date: //Setup date to be in US format from AU format $date_input = $_REQUEST['Date_Start']; $date_array = explode ("/", $date_input); $date_toFM = $date_array[1]."/".$date_array[0]."/".$date_array[2]; $edit_re…

Hello - Has anyone had any luck using logical operators in a compound find request? For example, here's a simple request (just for testing purposes): http://localhost/fmi...mresultset.xml? –db=Data_Libraries& –lay=web_Reports& –query=(q1,q2);(q3);!(q4)& –q1=pt_Name_First& –q1.value=Andrew& –q2=pt_Name_Last& –q2.value=Schools& –q3=pt_Social& –q3.value=1234567890& –q4=caseType& –q4.value=TEST& –findquery The request above searches for a patient with a first name of "Andrew", a last name of "Schools" and who has a social security # of "1234567890". It's omitting any r…

Hi everyone I am setting up a new site using filemaker php api and have started having a problem which I think is related to whether the filemaker connection is established or new. Basically when there is no connection already existing (ie the php connection is not visible on the server when I first attempt to load in the browser) the curl function of whatever is the first request to the database on the page timeouts out and when I trace through the error appears as no connection - fmExecuteSQL failed with error 28 (using FMWebFrame) However within a couple of seconds of attempting to load the page the connection is now visible on the server - the Curl functio…

Implementing a set of conditional value lists on a FileMaker layout is a relatively easy task. So, my question is how does one translate this to a PHP solution based on that layout? I understand that it can be done and that Jonathan Stark detailed one method for doing this in an article for the now dead Adviser magazine (an article that I can't seem to find anywhere). Can someone tell me how to get started doing this (getting the second value list field to populate correctly on a PHP created page) or point me in the direction of resources that will help me learn how to complete this task? I need this knowledge for several upcoming projects. Thank you fo…

Hi all, I am using FMStudio to do my PHP for me. I have a webpage where the clients can amend their contact details including their email address. When you hit the submit / save button everything updates perfectly but the email address whether you change it or not seems to add '' before the @ symbol. If I remove the @ symbol and hit save it doesn't add it. Seems to be something to do with the @. Any ideas at all?

hi, i have a INPUT that has special format FILEMAKER 13 as might make PHP take the same format? and that save register from PHP also in FileMaker the same format display? Thanks...

Any suggestions for logging in and it redirecting you to either the user page or the admin page based on your privilege. e.g. "user" privilege redirects to "user.php", "admin" privilege redirects to "admin.php"

I am currently using filemaker pro 5.5 to publish about 5 db files through custom CDML/HTML pages. I would like to publish these pages outside our firewall and our network admin suggested using a reverse proxy which he set up but unfortunately it does not work. When I try to gain access I only get back a blank page. When I look at the source of the page it seems to contain the following errors: err200: "OKrrNo Error.", err400: "Bad RequestrrThe server could not process your request due to a syntax error.", err403A: "ForbiddenrrYou do not have authorization to access this server.", err403B: "User Limit ExceededrrThe maximum number of licensed users are con…

I am looking into managing Google Calendar through FMP. I know there are plug-ins available to do this, but I am trying to keep costs at a minimum. I've gotten as far as figuring out the the Calendar API can be accessed through a REST request: https://developers.google.com/google-apps/calendar/firstapp#rest Which seems it should be able to compile a request like this: https://www.googleapis.com/calendar/v3/calendars/calendarID/events/eventID?parameters I think I should be able to perform the authentication through this method as well: https://developers.google.com/google-apps/calendar/auth The problem is I can't piece it all together. Has anyone …

Hello, my problem is with Filemaker 13 and PHP API i have this code: $request = $fm->newFindCommand($layout); $request->addFindCriterion($name, $request_name); $result = $request->execute(); and error throwing me is: [error_message_prefix] => [mode] => 1 [level] => 1024 => [message] => XML error: Not well-formed (invalid token) at line 1 who can guide me or help with this please...pleaseeee

Serious caveats: I'm new to FMS, WebDirect and IWP/PHP. This may be a really dumb question. I have FMS 13, hosted through a service. I want to use WebDirect for users of one hosted database. From what little I know it seems FM PHP would be better for users to another database. Two different user groups for different products, separate DBs hosted on the same server. It would help a lot to know if this is even possible before I begin. Can one server host two databases using different web interface schemes for each?

Hi, I have an Execute SQL Insert command that needs to run when a user clicks a button on our Custom Web Solution (PHP). The command should write data from my file to an outside user's MS SQL Server. The ODBC Connection to the outside MS SQL Server is set up on our FM 13 Server. The SQL Insert command works when ran manually on the client on the server. Also runs as a scheduled script. But will not work when called from the custom web solution. Code in the PHP page: $assetID = $_POST['assetID']; $newPerformScript =@ $fm->newPerformScriptCommand('Vision_Export', 'web_Push_Data_to_VISION', $assetID ); $result =@ $newPerformScript->execute(); …

We have just released a new plugin called "Synergize". This is a revolutionary plugin that allows you to use full web technologies within FileMaker Pro, including PHP. It supports the SQL command set supported by the FileMaker engine when using ODBC. You can use it for creating portals without the need for relationships (just name the database, table and fields you want to display), or use Javascript and PHP for creating graphical environments for charting, scheduling, (see http://fmscheduler.com/) a graphical webmail client, bar codes (including QR Codes), or any other web based technology within FileMaker Pro 13. Synergize has is it's own webserver integrated wi…

Hi I'm looking at converting a FM solution that is currently used with around 1000 users into an online service, and I want to keep using FileMaker as the backend. I have read this topic http://fmforums.com/forum/topic/90259-maximum-users-custom-web-publishing-concurrent-sessions/and am still not really clear - is there a limit on the number of PHP users that FileMaker can support. I'm also looking at expanding the solution to be used with a couple of other clients which could see the user count increase 5000+. (Of course, this is the total number of users, and the active number of users may only be 1/5th to 1/10th of this). Thanks Tim

Hello, I'm fairly new to PHP so I'm pretty sure I'm missing something easy here. I have a query that is returning 3 records that I want to loop through with a foreach loop and pull contents for each record from a particular field. After reading through the API, it sounds like they want you to assign the results to an array with the getRecords() method and then loop through the records with foreach loop. (At least that's what the API says...) Anyway, I have a simple query set up below: $fm = new FileMaker(); $query = $fm->newFindAllCommand('myLayout'); $result = $query->execute(); $records = $result->getRecords(); $foundSet = $result->getFoundSe…

so, my brother has a customer who is wanting a filemaker database built which he gave to me to do. Well, we found out about half way through that they also need it to interact with their website. now, i'm not going to lie...that's way over my head. so my brother asked me to see if i could find someone interested in making a couple hundred bucks just integrating a form online (website is already built, just need to tie the database to it) so that it pulls the customer list from the database and shows it on the webpage. it also needs to write the online form to the database on submit. i would imagine this would be fairly easy, but again...i know nothing about it. if y…

Hi guys. So I have this pretty huge and sophisticated database which is working fine but there's a need to extend it and turn it into a web-store, basically serving stuff for web front end - goods, pictures, placing orders et cetera. It's going to be managed entirely via the FM client so the work shouldn't be that hard. However I'm thinking of what the web programmers should go with. I do just the database stuff and want to relegate the web programming to someone else. With FM Server 13 the options are there so what would you suggest based on experience for us to use? Should we use FM's PHP API or should we use ODBC connector called via PHP methods? Unfortunately I can't …

All, Trying to run a `hello world` filemaker script using the PHP API. Getting field not found error (105). Doesn't seem to matter if I call a script that exists or not. Any ideas on how to get a basic script working? Big picture goal is to pass a parameter, do a commit records request and get a return value but first things first, need to execute any script. Sample code below. Thanks! Aaron // PHP PAGE $script_name = "Hello World"; $layout_name = ""; // why does it need a layout? //when specifying a valid layout name, get error 3 - Command is unavailable (for example, wrong operating system, wrong mode, etc.) $parameters = null; // basic, matches API code…

I have a Filemaker database that I sell as a static runtime solution for PC and Mac. (Each record also involves container fields embedded image files.) I am wanting to take the database online as a membership site that will allow customers to access it via web browser which would allow for access by mobile devices as well regardless of platforms. It will also be static with no need for customers having any content modification or write privileges of any sort. Access would need to accommodate multiple people accessing/viewing the site at once (but again, no write ability) There will be a membership login interface front end that will handle secured access. I'm not sure if …

Hi all I'm new to PHP in general, as well as the FM PHP API. So please be patient as the question might not actually make any sense. We need our clients to be able to access some records in our database (hosted on Filemaker Server 13). We would like them to do this through a website, which is being developed by a 3rd party. The website would use PHP to pull data from our database. As I understand it, if the database were SQL, then you can have your web server completely separate from the database server. PHP would just connect using credentials and manipulate data as per user requests. Is this same route possible with FileMaker? Can you have PHP pages conn…

I'm wondering if anyone knows if the plug-in API returns the script result when calling a script from a plug-in. I know you can pass parameters, but I'm wondering if you call a script with a plug-in and that script has an Exit Script[] step in it that includes a script result, does the API return that script result? I checked several plug-ins that have functions for calling scripts in FM databases and they don't include a function for getting the script result so I imagine the answer is no, but I thought I should ask the question before assuming. I have a long knowledge of using plug-ins, but the API is a mystery to me hence the question. Thanks

Hi there, We have a Filemaker DB hosted on FMS 13. Our hosting provider hasn't enabled custom web publishing. We do have web direct through. We want to create a simple web form (that will reside on our website) that will submit data to one single table in our FM DB. From what I can piece together we need to use the FM API for php but this requires Custom Web publishing enabled (which we don't have) Is there any other solution to collecting web form data? Is it possible through web direct? - keeping in mind the form needs to be available on our website without a user logging in...

I am finding on mature systems with lots of found records that the WPE gets bogged down when FMPS passes the found set to it. This can even cause PHP to timeout and throw an error. Plus no user wants to wait that long. Normall I would deal with this with paging. Pagination still has the full found set passing from FMPS to the WPE, then PHP sends just the current pages records to the browser. This is better but still boggs the Server down. Best WPE efficiency comes from transferring small amounts of data. But some times there be something else that slower performance down ... C

I am running FileMaker Server 12 Advanced (12.0.4.405) on a MacMini. It is hosting 6 databases (7 if you count the sample) that are all used as sources for the PHP api. The web server is running on an OpenSUSE LAMP stack and has a special site that just checks for the existence of and connection to the six databases. Everything runs smoothly and the databases serve up news, store, and jobs databases while the special site is checked by an outside service every five min to look for errors (when it will email me). Between once a week and once a month, all the sites will lose connection to the database for something between 1 and 3 hours. If I don't get to it in time it …

Total newbie questions about a simple PHP search using addFindCriterion to match checkbox value. I have 3 checkboxes in a field called "myChoices_field" containing the following choices - where "airport" is selected. [ ] air [x] airport [ ] air vent So that means that "myChoices_fld" contains only the value "airport". If I do a search via PHP looking for a record that matches only the choice "air" - this is what I would use: $findCommand->addFindCriterion('myChoices_field', "air"); I should expect it NOT to match anything since "air" does not equal to "airport". However - I'm getting back the record that matches "airport". Clearly - it's just doing a substr…

Hi All I am experiencing a very odd problem with a web form we created for our clients. The web form worked absolutely perfectly on the Apache server we started the clients off on. We're now trying to move them to a new IIS server on a much more powerful machine, however there have been some issues. On entry of the first page a record is created in the database & when the form is posted, that record is edited & continues to be edited on subsequent form pages after filemaker's record ID and the primary key are stored as session variables. NOTE: There is an included page prior to the code I have entered below which sets $ID & $recordID to the value of th…

I'm playing around with the PHP API, and was converting a solution which was originally designed for IWP. The IWP version had an interesting design: the IWP user had access only to a single-record table with global fields. It would populate these fields, then run a script (which ran with full access permissions) which would do a custom search, and return values (if any) in the global fields. The reason it was designed this way was for security: the IWP user has zero access to the underlying data, which seemed like a smart design given all the issues with IWP (for example, if the user hits 'reload' they would often be moved to seeing record #1 in a given layout). Anywa…

Goodday, I have a script that mails an invoice to the user. This takes to long to have the user wait for it. Would it be possible to trigger the mailsending script in an iframe and continue the flow ? I assume (!) once triggered, the script will continue to run when the iframe is closed ( the user has gone to the next page.) Any experience with this ? Alternative would be to do a server script that polls the database. I'm just not that big fan of server scripts and polling in general. Cheers ! Frank.

I am working with the PHP API and its not sending messages back. I'm getting conflicting messages from the server. See images for what I'm referring to. Â Nothing is happening when I talk to the API. No returns. FileMaker Server 13, Mac OSX Mavericks 10.9.3 Â I looked up my processor (1.4GHz Intel Core 2 Duo Processor) an its 64-bit. Â Its just a local install of FMS for testing. Â Any thoughts? Thanks.

I want to do a online shop that link to FileMaker. What is the best option for online shop. 1)Magento 2)osCommerce 3)Zencart 4)Virtuemart (Joomla) 5)Ubercart (Drupal) Thanks. Kent

I'm looking for someone to write a script for me that will import a few pieces of information from my bigcommerce store. I need a few bits of customer information, as well as the order details. Is it possible to do this with "one click" from file maker? Would anyone be interested in writing this script for me? Regards, Ryan

Here is my code: $compoundFind =& $fm->newCompoundFindCommand('MyJobs'); $findreq =& $fm->newFindRequest('MyJobs'); $findreq->addFindCriterion('JobStatus', 'Complete'); $findreq->setOmit(true); $compoundFind->add(1,$findreq); $compoundFind->addSortRule('CustomerNumber', 1, FILEMAKER_SORT_DESCEND); $result = $compoundFind->execute(); I expect this to return all of MyJobs that are NOT marked as complete from MyJobs layout. Instead I get ONLY the jobs that ARE marked as Complete. It seems so simple, yet I am so confused.

I have a Searchloads.php file that is showing a lsit of my records im pulling from filemaker. right now its hardcoded to sort records based on two fields. How do i allow the user to sort records based on what they choose in a drop down menu? Or maybe two sort drop down menus? and if the second isnt set then it just works off the first one.

below is some code that i loop through records creating an unordered list. basically a table just in list form. What i want to do is in the url i have a variable being passes called page= and whatever page number i get at that time. I have a css style that when im on a specific page the pagination link that corresponds to that page should be green so i know by looking at pagination links what page im on instead of looking at the url for page number. how do i do that? $n = 1; while ($n <= $totalLinks and $totalLinks > 1) if ($page == $n) { echo '<li><a href="' . $_SERVER[…

Ive attached my code pages. The issue i have is if the login credentials is correct it redirects great but of not then it doesn't work and displays an error of below. Whats goin wrong? I used some of the functions from a plugin that i own to play with and they work just not if its wrong login. login.zip

Hello, I want to create a product listing in eBay, with images. I looked at the API's at eBay, overwhelming . Did somebody do this already from Filemaker and can show me an example? TIA

Simple problem here: I have two different Filemaker servers. On one file of Server A, I am trying to run a script via PHP, on a layout with all the fields that are at all referenced. At one point, I am trying to set a field with the contents of another, related field, in a file on Server B. Both files have PHP permissions enabled, with the same username and password (verified and tested), but I can't seem to access the field from Server B, while running php on Server A. The relationship and script works fine on the client. Is there some sort of networking permission I need to set to allow Server A and Server B to talk to each other with php? They talk together jus…

Is there a way to do something like this with the filemaker php api? INSERT INTO Table ( Column1, Column2 ) VALUES ( Value1, Value2 ), ( Value1, Value2 ) I know I could do something like this but I have to insert 37000 records and I would prefer not to make 37000 commits: $valuesArray = array('Name' => 'Robin', 'Year' => 2011, 'Week' => '6/5/2011') $rec = $fm->createRecord('web_layout'; $valuesArray); $result = $rec->commit(); Any ideas? Thank you!

My office has gotten accustomed to interacting with our custom DBs, and there is plenty of sensitive information in there (names, addresses, et c.). So I'm looking forward to telling senior staff that after a recent move & some structural LAN changes, I have a static IP set aside and a dedicated terminal and they'll be able to access their calendars and Rolodexes from home. Before I go live with that, though, I'm thinking about security. We've always maintained this data on a closed network behind a firewalled router, so I've never used any particular measures (logins, passwords) to get access. If I'm going to putting people's home addresses on a public terminal, I …

Hello, I am currently developing a PHP script to speak to a MySQL database and then insert information into FileMaker (11 Server Advanced). However, I am having a lot of problems obtaining the values within a value list. It is a custom value list. For example, one of the values in the value list is "Assigned" but when I try to set the field to this it returns that I did not provide a value within the list. I decided to try and obtain the custom value list in order to determine why it was not working but it simply returns an empty array with no keys or values. Here is the snippet of code I am using to grab the values within a custom value list: Also…

Hello, There are only three of us at this small company. One computer hosts a FileMaker database ... (I primarily work from this station). The other two employees connect to my database via "Open Remote". Then they connect to my FileMaker database when my computer shows up under "Local Hosts". One of these computers that is connecting to my computer is a laptop. Can the employee that works from this laptop take the laptop home and still be able to connect back to my computer at the office? Yes, the office has a static IP address. No, we don't want to use Instant Web Publishing. All of the computers are Mac Computers (OS X 10.6.8) running FileMaker Pro 11.0…

Does CWP trigger On First Window Open/ On Last Window Close scripts? It doesn't seem to on my system. I'm looking for some way to log when CWP logs into the database. Any ideas?

I have a script that performs a find based on related fields. Here's a very simplified version of script Go To Layout ["Primary_Table"] Enter Find Mode [] Set Field [related_table::name] Perform Find I have the <<related_table::name>> field on the Primary_Table layout. If I run this within Filemaker Pro it works and finds desired subset. If I run it as a Server script it works and finds desired subset. But, if I trigger it from PHP it finds ALL the records in the Primary_Table. The following, however, does work and finds a subset of records from Primary_Table: Go To Layout ["Primary_Table"] Enter Find Mode [] Set Field [Primary_Table::…

I wonder if anyone could shed some light on this. Sorry a bit slow. I was wondering what exactly is the type of hosting required to publish view and share etc Filemaker on the web. I have had a look round but still a bit vague. I have linux hosting at the min but would change if need be. Thanks for anyone who could explain in a basic form. Thanks again.

Hi Guys, I'm just creating a new web app that needs to integrate into our FileMaker database. The website is running PHP 5.5.3. Is there an issues with the API & 5.5.3 Thanks, Scott

I've setup a site that's using the FileMaker API for PHP, I have a page that displays images, it usually works out great except when the image that's being displayed was added to the FileMaker 12 Database via a FileMaker Go client (where as the ones that work fine are ones that were dragged into the FileMaker Windows or Mac desktop client). This is the error in FireFox (in Chrome I just get a picture of a broken image icon): The image “ cannot be displayed because it contains errors. In my PHP file I specfiically declare a header type of image/jpeg (it works for PNGs too I've noticed), the files are from iOS and are JPG files or are from the camera app on iO…

I have layout called (studentinfo). Studentinfo layout show records from "STUDENTS" table from database. when I run the code below I get all fields data expect: inq_FAM Family 1 [c]::BB_studentID inq_FAM Family 1 [c]::BB_ParentA_ID inq_FAM Family 1 [c]::Pa_first inq_FAM Family 1 [c]::Pa_last inq_FAM Family 1 [c]::BB_ParentB_ID inq_FAM Family 1 [c]::Pb_first inq_FAM Family 1 [c]::Pb_last inq_FAM Family 2 [c]::BB_ParentA_ID inq_FAM Family 2 [c]::Pa_first inq_FAM Family 2 [c]::Pa_last P2b_relation inq_FAM Family 2 [c]::BB_ParentB_ID inq_FAM Family 2 [c]::Pb_first inq_FAM Family 2 [c]::Pb_last On filemaker pro I noticed the ones that are showing have…

Assuming we are using FileMaker Server, Is it possible to stream data to a wide number of other websites? Let's assume we get a css container on a a bunch of websites. Can we stream data to those containers? How is that done?

hi, Earlier in FileMaker Server 11, there was option for PHP Site Assistant, but in FileMaker Server 12, this option has been removed. Is there any option available in FMS 12 for PHP Site Assistant or how can we use PHP Site Assistant ? Thanks.

Hello! I am wondering what the maximum number of users have been deployed on FileMaker database using Custom Web Publishing. I know that FM12 support 200 concurrent users but theoretically, this could mean a significant higher number of users could be using the system via CWP - only 200 can actually submit and update at a single moment… is my understanding correct? Looking for some real world success stories implementing CWP in environments with more than 200 users. Thanks!

Hello everyone. Im quite new to filemaker php api and also php but starting to get the hang of it. what i need help with is that when i try to get the id of a portal record i get a php 500 error. if i comment out the part i add in it works fine but when i leave them in i get the error. the reason i need to get the id of the portal record is cause i use supercontainer to store my document and their linked by the id document. <?php require_once 'Filemaker.php'; include 'includes/dbaccess_asset.php'; if(isset($_GET['search']) and $_GET['search'] != '') { $search = $_GET['search']; $request =& $fm->newFindCommand('IWP_Documents_Lis…

Hello, We use FM11 Server Advanced to host several databases, and use php extensively. This works perfect. But we want to upgrade to FM12 Server Advanced. Every php script that should edit the content of a field doesn't work. We can read/display the contents of fields, add records, delete records, but, strange enough, not change field contents. The code below does not change the contents of any of the fields mentioned. It seems to do nothing, and end with, when made visible php strict errors, and calling the isError function 'should be called statically'. Hardware: Mac mini, new (our test server) running MacOS 10.8.5 with Server 2.2.2 and FM12 Advanced Server …

LS, So, Mavericks got installed. Now calling a php-file in safari, just displays the php-code. It appears apache2 was installed. Does anyone have an idea on how to get it functioning again ? TIA

If I have a FileMaker server with static IP address accessable from the internet, is it possible to access from FileMaker Pro through Open Remote dialog? Thanks JW

Hello: I'm looking to possibly use Filemaker with WordPress and I'm looking for someone that has either actually done this or someone who can give me a high level overview of how I can get my Filemaker fields into the WordPress backend MySQL tables and just a very high level - how to? Dom

Using FileMaker Server 11 for a Users database and I have setup a website (using PHP) for people to search the database. Searches (and results) are working properly, but I can't get an error message when no results are found. When this happens, I get the top part of the web page, but then nothing else (the page has a mix of PHP and HTML)... Ideas? (header with stylesheet information removed) <div id="container"> <div id="top"><a href="http://medicine.yale.edu/pathology/index.aspx">Yale Department of Pathology</a></div> <!-- end #top --> <div id="header">Yale Pathology Directory</div> <!-- end #heade…

Hello everyone, I'm a noob at PHP web publishing and I have been trying to get some records to display from my database. Everything was going fine hosting the site and getting the database set up in till I tried to call the layout in question. I get the error PHP Warning: urlencode() expects parameter 1 to be string, object given in C:Program FilesFileMakerFileMaker ServerWeb Publishingpublishing-enginephpFileMakerImplementationFileMakerImpl.php on line 339 From this code $findCommand =& $fm->newFindAllCommand("organizationsPHPs"); $result = $findCommand->execute(); I'm not sure what is going on and I need help debugging it.

Hello, I don't know if I'm in the right forum but I try. I'm experienced in FMP for 10 years but not in PHP, and SOAP requests. I need to interact with a webservice for sending orders (products ID and quantity). I've got the WSDL from the service ,read a lot on SOAP but I'm not able to write my SOAP request to test it. Can someone help me and put me on the way ? In the WSDL (attached file) I need just to use the vetapswuploadorder, not the product search or the command search. As you see there is a test URL : Test WSDL: https://test.vetpoint.ch/images/wsdl/ServiceVetTapswUploadOrder.wsdl Test URL: https://test.vetpoint.ch/webtools/control/SOAPServi…

I have a PHP application that accesses a FileMaker file using a special layout with the fields that I need. GetFields returns the fields from the layout table, but not the fields from a related table that is in another file. Are there possible reasons for this? Perhaps some security settings?

LS, This must be so simple, but don't get php and how it works not very well with php ( using newAddRecord and execute ). I have created a new record and set data in that record. The questions I have are : 1. how do I set more data in the same record ? 2. when I create the record can I get the contents of an auto-enter create primary-key field back as a result ? Hope this makes sense ! TIA Joost

I just created a relational database using Filemaker Pro 9 Advanced . It is a catalog of 290 individual manta rays with unique ID numbers and a series of attributes that are assigned to each individual. I would like to publish to my current website so that whenever a diver photographs a manta ray they can login to my website, access the database, perform an attribute search to find those individuals with similar attributes, and determine if their animal is new or one that matches an individual in the catalog. I don't want to host the database on my computer since I only have a laptop and it is usually offline. I'd prefer to publish it to my hosted website (GoDad…

Hello again! I am attempting to create an array of results from a found set of Filemaker records within the FIlemaker PHP API. I've managed to get the interactions working correctly but I'm having some difficulty in displaying the found fields and records. I'm hoping that somebody more familiar with the way that PHP works can point me in the right direction. Basically, I have performed a find command on an existing layout with two criterions: $findMedicalProvider =& $fm->newFindCommand('MedicalProviders'); $findMedicalProvider->addFindCriterion('companyName', $providerName); $findMedicalProvider->addFindCriterion('comp…

After updating to Filemaker Server 12.4, our web portal stopped working. I have tracked it down to a server error (22) but while troubleshooting the issue I also ran into some problems with the actual PHP itself. I'm not sure if this is the correct place to post this, but I have a question regarding how the below PHP code is functioning. {//There is a token, check it... $find=$fm->newFindCommand('CWP_Users'); $find->addFindCriterion('request_token', $token); $find->addFindCriterion('request_expires', date('m/d/Y g:i:s A').".."); $result=$find->execute(); $temperror=''; // If an error is found, return a message and exit. if (File…

Hello, I am searching for a reference document that describes the FM PHP API. What would you all recommend? I have found bits and pieces, but not a good old fashioned, comprehensive reference document. The best I have found so far is from Jonathan Starks website: http://jonathanstark.com/fm/filemaker-api-for-php-documentation.php That is more of a 'table of contents' format, but it was helpful. My current problem: I am having a little difficulty executing a FM script from PHP. The general method I am trying is: $newPerformScript = $fm->newPerformScriptCommand($layoutName, $scriptName, ''); $result = $newPerformScript->execute(); (By the way,…

I've got a table called Products and another table called Scans that are related by a field called ScanID. Via the FM PHP API, I'm connecting to a layout in the Scans table. When I use getField('ScanID') that works great because the field actually resides in Scans. However, I also have fields on this layout from the related Products table (ie. Products::ItemNumber) However, when I try that with getField('Products::ItemNumber') I get nothing back. Simply blank values. I'm also not getting any errors back when calling getField() on these fields. Any information on what I'm doing wrong would be greatly appreciated. Thanks!

We've created a PHP front end to a FMSA12 backend. These PHP web pages have popup "help" when the user hovers over a field. The source of the help content is a Help table in the FM db. The odd part is that we have updated the help content in the tables but the updated content it is not showing on the web pages. I have flushed the cache on my browser, tried alternate browsers, tried alternate laptops but the same old help text remains. I even tried rebooting the server without success. Anyone have a suggestion where the old content is hiding and how I can force an update? Thanks

I am trying to send clickable links which trigger a script in FileMaker databases via email to PC Outlook users via plain text emails (generated by a FileMaker database).  The users are on locked-down workstations in a hospital environment and can not add file protocol associations to Outlook's settings. Since this configuration of Outlook *does* convert URLs that start with "http" into clickable links, I was thinking that I could get around the Outlook limitation by sending an http: link that looks something the URL in the attachment  (i had trouble inserting the URL via <code> into this post (it kept coming up blank), so, I've attached an image of it. …

Good day all, I am in the middle of trying to create this script so I can view our filemaker pro databases on the web. However, it seems to only be returning the last found record. I use $result = $cmd->execute(); $records = $result->getRecords(); which shows me the script finds 3 results, however all the content is outputted as if it were the last record. Find the entire code set below: <?php ini_set('error_reporting', 1); //config removed $return_field =array("ID", "Primary"); # set the layout name for this page $layout_name = 'Asset'; # this is the include for the API for PHP require_once ('Filemaker.php');…

Does anyone know of a free or commercial grid control that works with CWP?

Hi all, I've scoured the web but all I've found were a handful of unanswered pleas for help. Hopefully one of you fine folk has dealt with this before! In trying to connect to a database via PHP, I'm getting this error: Communication Error: (22) The requested URL returned error: 403 - This can be due to an invalid username or password, or if the FMPHP privilege is not enabled for that user. Now, to describe the situation further, I am 100% sure that: - PHP is installed properly (phpinfo() works fine, and I can connect to other FM databases on other servers, from the same PHP pages) - PHP is enabled on FMSA - The username and password I'm sending are corr…

Hi, I had a fellow do some work to access our database via our web site which has sort of worked but I'm not entirely sure he knew what he was doing, FM API wise, and he is no longer ! Anyway, there's a number of records which are being listed in creation order even though he's apparently put a sort order (as we had requested), the following seems to be the relevant code. # grab search criteria, if any has been sent $criteria1 = htmlspecialchars($_POST['refno']); $criteria2 = htmlspecialchars($_POST['claimno']); $criteria3 = htmlspecialchars($_SESSION['LinkingID']); $criteria4 = htmlspecialchars($_GET['type']); # grab the sort column, if any ha…

I am wanting to show contact info for a family. The output I get is putting everything on one line. It is ignoring the carriage returns. My field in my database is a calculated field with carriage returns after certain info. See below for how I want the output to look. I am displaying the data in a table. This is the line where I call the getField function. $table3_data .= $related_record->getField('HOH Info::DirectoryCombinedText'); Output looks like: Parent1 Name & Parent2 Name Children: Child1, Child2, etc Address City, State Zip (h) (111)111-1111 Parent1 Name (111)111-1111 Parent2 (111)111-1111 Parent2 Name - [email protected] Parent2 Name - em…

Hi everyone I want to get a list of all the Account Name and Password that is created using File -> Manage -> Security.is it possible by the script or any plugins? thanks

Just wanted to let people know about an update to the Filemaker-Ruby adapter, Rfm. Ginjo-rfm is a fork of the Lardawge-rfm Ruby gem that continues to refine and enhance the Ruby Filemaker adapter, making it easier than ever for Ruby scripts and Rails applications to work with Filemaker servers and data. If you're not using Ruby with Filemaker, I highly recommend checking it out. Whether you're serving web pages to the public, sending Filemaker data to Google Callendar, or reading tweets into your database, Ruby and Rfm are wonderfull tools for working with Filemaker server. And if you're already using a previous version of Rfm, have a look at Ginjo-rfm 2.0. …

I have an older filemaker database that was converted from filemaker pro 6. We have been converting the CDML to use php code. I'm having trouble pulling images from the container objects with this database. I've set up the questionnaire demo and it works fine. So I know there is nothing wrong with my configuration and that my containerbridge.php code works. Any ideas of what the differences in the database might be. Here is the broken image string I'm getting is: <img src="BLContainerBridge.php?path=%2Ffmi%2Fxml%2Fcnt%2FUntitled.pct%3F-db%3DBig_Lake_Database%26amp%3B-lay%3DChemical%2520%26amp%3B%2520Physical%26amp%3B-recid%3D10%26amp%3B-field%3DDOGraph%281%29">

Hi, I have 12,000,000 (12 million) books in an FMPro Database including book images and descriptions. I want to put this database up on the web and allow visitors to search through it, pick out books, put them in a cart and buy them with Paypal. With this many books and images it has to be "fast" enough so we don't lose visitors who have to wait too long for their search to complete. Not sure how to get this accomplished with FMPro. I've tried some open source stores but can't believe there isn't a simple setup to do it mostly in FMPro. Looking for cheap, turn key solution. Any ideas? Thanks, David

Hi folks, I've been developing a web front end using Django for our office's filemaker database. Occassionally when there are a lot of simultaneous submissions to the database I get an "error 306:Record modification ID does not match" I cannot find anywhere on the internet what this error may mean. Any help with the meaning of this error would be a great help to me! Thanx!

Hi If can somebody help me pls because i can´t connect my database with php, and i have more than 1 day. Thank you. Error: Communication Error: (22) The requested URL returned error: 404 Not Found - This can be due to an invalid username or password, or if the FMPHP privilege is not enabled for that user. Error This is the error that display me. the code is filemaker examples for filemaker page. I have windows server 2012 and filemaker server 12 v2

Ok, I'm pretty new to PHP, so please be gentle with me :-) The page that I'm working on shows events listings by date. When the user initially comes to the page, all events that are in the future show on a results table. Said another way, all past events are already filtered out. By default, the events are shown in date order. The page has drop down menus to filter the results further. The drop down menus are dynamic from the Filemaker database, and they only show data from events in the future (not the past). The filter at issue here is the one for the Type of Event (conference, webinar, etc). On Filemaker, the data is in just one table - no related table, n…

We have an export job that grabs and worked flawlessly up until an upgrade this last weekend. We upgraded from 10 to 11 and all the subsequent updates. Basically the user specifies a date range on our external website, which then hits the code igniter framework (on the internal web server) to instantiate FileMaker.php and grab the records and serve them back to the external website. Like I said, this all worked well prior to our upgrade over the weekend. I JUST inherited this whole system, I know very little about FileMaker but have been reading and testing. Sample FileMaker code works, is able to list databases. Parts involved: CodeIgniter Fra…

Hi all.. Sorry if this is not where i should have posted this.. I am looking for a know site/company with good reputation at hosting filemaker databases...Any one with an idea please fill me in... Quick Question....When hosting a database...do i get a domain name that when entered in the url takes me to my database???

I would like to perform a search on a DB served and created on a FM11 server using the PHP site setup tools. This web site I would simply like to search the field “NT” for values of say 120. I expected something simple like: http://lgdfm3.ncifcr...list.php?NT=120 But alas I seem to have too high expectations and it seems like I will have to build a form php page to perform a search via a URL?

Is there a way to have a Carriage Return advance to the next field (like Tab does) on the Web interface? (IWP)

I am writing a phone dialing application to integrate with our case management system and can't figure one "logical" problem out. Each morning I generate an on the fly list based on certain criteria of the clients to be called for that day. The agents login to the system and it returns one record at a time and then they have to "wrap up" the call before getting the next lead. My problem is this . . . One of the "wrap up" options is to schedule for a callback at a later date and time. The date doesn't bother me, but I can't think of an easy way to make sure that that lead is triggered at that time? When they schedule it I write to a TS field, but when I am only pullin…

I have a few users accessing db via web browser. They are basically submitting jobs and I was hoping they could SUBMIT when done and then send me an email of the job request. However, appears the SendMail step not available through web access, any other alternatives? I basically want to be notified of any new job requests, even willing to go to db myself if some way to receive an alert. Hoping users don't have to close out and then send separate email. As you can probably tell, I'm not a FM expert. Thanks so much.

Hi all, I've been hitting a wall with this and hope someone can help me out. Thanks in advance! I am trying to use a simple $record->getRelatedSet('TOCNAME') command on a ToC that references a table in a different Filemaker file (same server), and cannot get it to work. I know I have my syntax right, because I have tested the same code on a ToC within the same database file, and it works. The portal and field I need is on the layout I am accessing, and there IS a related record, with a valid field value. Is there anything I have to do different for related records in different files? The error message says: Related set "TOCNAME" not present, with no actual err…

I have a table with fields State, StateDataThisYear, and StateDataNextYear. I want to end up with two html tables (one for this year and one for next) with the StateData in the table. The StateData is either the state name and a link to an anchor further down the page, or just the state name. This table will be used as a Table of Contents for other data on the page. The objective is to allow the page user to quickly see if there are events in a state and navigate to details if there are. I think I want the data in a php array formatted like this: Array ( [<<State>>] => Array ( [0] => <<StateDataThisYear>> …

HI I'm new to FM PHP API and got stuck right after the first steps. I can open a DB alright: $fm = new FileMaker(); echo "Verion: ".$fm->getAPIVersion()."<br>n"; // -> 1.1 $fm->setProperty('database', 'Testfile'); $fm->setProperty('hostspec', 'http://192.168.0.2'); $fm->setProperty('username', 'xxx'); $fm->setProperty('password', 'xxx'); $databases = $fm->listDatabases(); But the next call fails, for instance: $layouts = $fm->listLayouts(); Here is the error object: FileMaker_Error Object ( [_fm] => FileMaker_Implementation Object ( [V73ee434e] => Array ( …

I have a simple database with 3 fields, Name, Date, Location, and an Image container field. It is to be made available to fisherman who can add false killer whale sightings each time they encounter one. When a sighting is made, they would log onto the database, enter their name, the date, the location of the sighting, and upload a photo of the animal if they had one. What is the best way to host this kind of database? The fishermen wont have Filemaker on their machines. A website with a PHP survey form with file attachment capability would not be ideal and a lot of work to transfer emailed sightings into the database. In a perfect world, the fisherman could simply dr…

Hi I have an array ( $Seg6 ) which contains multiply values and could have as many as 60..... I need to use it in a compound find, where the number of values in $Seg6 decides how many find requests, that should be created in the compound find. However, I have tried with: // Create search request and criteria and add it to $compoundFind for each value in $seg6 for($x=1; $x <= count($seg6); $x++){ $findreq[$x] = $this->fmcon->newFindRequest('WEB-ART-Artikel'); $findreq[$x]->addFindCriterion('_seg_6','='. $seg6[$x]); $findreq[$x]->addFindCriterion('__kf_DEB','=='. $_SESSION['deb_id']); $findreq[$x]->addFindCriterion('_WebSubKat',…

hello, I used this post: http://fmforums.com/forum/topic/84194-change-password-for-filemaker-account-via-php-api/ and when you change a password with special characters like ñ, is successfully changed the FMP, but when logging API with PHP, I can not, apparently the password is incorrect, my scripts are in UTF-8, as q the FMSERVER. I need urgent help, thanks! PS: My English is bad.

Hey all, I've got the following find command statement. I need it to search on 4 fields, the first 3 being standard items, but the 4th field containing a possible of 4 different options. Any ideas how can I achieve this? Many thanks as always $request = $fm->newFindCommand('Cars'); $request->addFindCriterion('Color','=='.$_POST['Color']); $request->addFindCriterion('Distance',$_POST['Distance']); $frequest>addFindCriterion('Age',$_POST['Age']); $request->setLogicalOperator(FILEMAKER_FIND_OR); $request->addFindCriterion('Type', 'Coupe'); $request->addFindCriterion('Type', 'Estate'); $frequest>addFindCriterion(''Type, 'Hatchback'); …

Hi all! I have a small problem, and I'm sure the solution is obvious, but I can't get it... I have a field with a list of values. On the layout, the field is set to display values as radiobuttons. In the php file « addrecord.php » (generated by the PHP Assistant), the values are written « back to back ». This make the web page cumbersome as the values appears in the same line (approx 10 values). So, the question is : where (and how) in the addrecord.php file can I put some code to make the radiobutton appears one above the other, just like that : Radiobutton 1 Radiobutton 2 Radiobutton 3 ... Thanks a lot ! Martin

On a web entry form with radio buttons using a valuelist, some of the choices have the radio button on the far right of the line above the wording of the choice, making that choice confusing. Is there a way to force each value to have a new line? (Or enforce orphan protection, so at least each choice has a couple of words next to the radio button?) Here is an example where there is a button for BISC650 next to BISC432 text: Here is the current code (Valuelist and field are both called 'position'): <?php $fieldValue = $record->getField('position', 0) ; ?><?php getInputChoices("radio", $layout->getValueListTwoFields('position'…