Jump to content

Search the Community

Showing results for tags 'php'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Community Forums

  • The New FileMaker Platform
    • FileMaker Server 17
    • FileMaker Pro Advance 17
    • Command Line Data Migration Tool
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
    • GDPR
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker DataAPI
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • FileMaker Schema & Logical Functions
    • Script Workspace and Script Triggers
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • XML/XSL
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • FileMaker Platform
    • FileMaker Pro 16
    • Legacy FileMaker Platform Discussions
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • FileMaker Training Resources
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Member Lounge
  • FileMaker Friday Night Chat's Topics

Blogs

There are no results to display.

There are no results to display.

Categories

  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins

Product Groups

  • Site Donations
  • Site Advertising

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 80 results

  1. 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 inserting them, trying to track down where this error is creeping up. So please ignore. Please ask any additional questions, I am sure there are many. Cheers, Tony PublicPortal.zip
  2. jstewart30

    PHP getting blank page

    Running FMS 13 and trying to run a simple PHP page from my website to access a database, but I'm only getting a blank page. Not sure if it's a port forwarding issue or a PHP issue, or something else. If I put my .php file and the includes ("FileMaker.php" file and "FileMaker" folder from the FMS PHP .zip file) in the fmi-test folder on my FM server and access it locally (http://localhost/fmi-test/myphpfile.php), the PHP file works fine and returns data, so I don't think it has any inherent issues, and presumably my FMS is set up correctly. Putting the same .php file and includes on my web server, though, results in a blank page only. The includes are in the same directory as the php file itself. Here's the php file (I've changed the IP address and database names to protect the innocent but they're correct): <?php error_reporting(E_ALL); ini_set('display_errors', 1); include_once('FileMaker.php'); /* have also used require, include, and require_once with no change */ $fm = new FileMaker("MyDatabase", "http://myfilemakerserver:8888", "Admin", ""); /*no password*/ $findCommand = $fm->newFindCommand("MyDatabase"); $findCommand->addFindCriterion("Phone", "303-555-1234"); $findCommand->setRange(0, 1); $result = $findCommand->execute(); if (FileMaker::isError($result)) { echo($result->getMessage()); return; } $record = $result->getFirstRecord(); $name = $record->getField("Customer Name"); $status = $record->getField("Status"); echo("$name - $status"); ?> Infuriatingly I get no errors or feedback, just a blank page when I run this file from my website (but again it works fine locally on the FM server machine). I've confirmed PHP is working on my website as I can do a simple phpinfo() file in the same directory and it runs fine and displays the PHP info. If I direct a web browser to the same "http://myfilemakerserver:8888" (not the real address obviously, but it is port 8888) I get the "Filemaker Database Server Website" page, so the port forwarding seems to be correct. I have port 8888 forwarding to port 80 of my FM Server. I don't have port 443 forwarded to that machine as that's being used for another device on our network, but I assume if I'm not making "https" requests that it should work fine (but maybe that's my problem?). I assume it's just something simple but I've been beating my head against a wall for the better part of the day on this. Any help would be greatly appreciated.
  3. Martin Taylor

    12 to 16 php upgrade

    Hi all experts (hopefully), I have just upgraded from FMS12 to FMS16. On the FMS12 server we are running a php solution. I have installed 16 onto a new server, uploaded all the databases (all successfully running) and have copied the php website to the new location on the 16 server. I can see the website from home (so I know the website is in the right place and the DNS s working) BUT I can't seem to connect to the database successfully. Any help would be much appreciated. Thanks in advance. Oh, and it is accessed with https
  4. Hi, I'm trying to install in a drupal site the connection with Filemaker. I am developing the drupal site in my machine using MAMPRO as a web server and I have my database file hosted in a shared Filemaker server. After installing in Drupal, the Filemaker modules, and the FX folder with FX.php in the libraries folder, whenever I try to use the filemaker module I get the following notice "Can not find FX.php. Please place FX.php at sites/all/libraries/fxphp/FX." I'm sure that I've installed in that location the FX folder. So I am lost. I'd appreciate any help, thks. Armando
  5. 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 substring match. How can I search a checked value that actually just searches the whole checked value - not do a substring search? I'm I completely missing where to find this in the documentation? Pointing me to the documentation would help greatly. Thanks!
  6. 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 use a valuelist that finds that date [a related, global value] in a global table that consists of one record with various global values for the Timesheets table. <?php $fieldValue = "test " . $record->getField('Period Ending', 0) ; ?> <?php getInputChoices("radiobutton", $layout->getValueListTwoFields('Timesheet Period Ending Date', (isset($master_record)) ? $master_record->getRecordId() : $record->getRecordId()), $fieldValue, getFieldFormName('Period Ending', 0, $record, true, 'RADIOBUTTONS', 'text'), 'text', $submitDateOrder);?> is the ending date for the Current Pay Period.this appears as 2-Week Period Ending (MM/DD/YYYY): [Entry field with 07/04/2015 autoentered]07/04/2015 is the ending date for the Current Pay Period.And really works well (don't ask me about 'test ', it is ignored). To change the date format I tried doing a calculation [Day ( timesheets Period Ending global ) & "/" & Month ( timesheets Period Ending global ) & "/" & Year ( timesheets Period Ending global )] to change the order but it submits it in the MM/DD/YYYY format (other date fields ARE dealt with properly!!!). <?php $fieldValue = $record->getField('Period Ending', 0) ; ?> <?php getInputChoices("radiobutton", $layout->getValueListTwoFields('Timesheet Period Ending Date calc', (isset($master_record)) ? $master_record->getRecordId() : $record->getRecordId()), $fieldValue, getFieldFormName('Period Ending', 0, $record, true, 'RADIOBUTTONS', 'text'), 'text', $submitDateOrder);?> is the ending date for the Current Pay Period.2-Week Period Ending (DD/MM/YYYY): [Entry field with 04/07/2015 autoentered]04/07/2015 is the ending date for the Current Pay Period.This is entered as April, while in the other date fields in the same form 04/07/2015 is entered as July. I am doing this with Filemaker Server 11, using PHP/Apache on a mac mini client.
  7. I have this same solution I'm installing to 3 separate FM servers, but on one of them I can't get passed this Communication Error 22 for some reason. The error says it's the username or password, but it is imply not. I am using as basic as it gets with a username of "php" and a password of "1111". I also tried my regular admin account, but I get the same problem. I do have the FMPHP privilege set for both of these accounts... The server is on Windows with a fresh update of Java and then a fresh install of FMS14. Deployment seems to go smoothly, and everything shows nice green lights. The CWP test page loads just fine, too, which you can see in these images... I have also forwarded all of the ports that should be open for this machine. I am able to use Open Remote and open files from this server within FM Pro, but for some reason I cannot get the PHP API connection to work on this server. Again, I have the same thing setup on multiple servers. Here is a working example that spits out the available data sources. Here is the exact same test script that is hitting my other FileMaker server at a different location, but it's returning the error. I can't think of what else to look at. Any information on how I can get this working would be greatly appreciated. Thanks!
  8. Hi, As we know that we have option to configure FileMaker Server with PHP (which is installed on IIS).. Like the way.. I have another question.. Do we able to configure FileMaker server with PHP Which is installed on Apache (with Linux machine).. Please clarify.. If you already experienced please help us to configure Filemaker 12 server with Apache.. Many Thanks ~Guru
  9. I am attempting to use Filemaker as an ODBC datasource in place of MySQL. I am currently running PHP 5.5.3 and am attempting to create a PDO that will utilize the Filemaker ODBC connection. However, I am unable to successfully connect to the database as I am getting an error that says "Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in /Applications/MAMP/htdocs/OMIS/core/init.php:6 Stack trace: #0 /Applications/MAMP/htdocs/OMIS/core/init.php(6): PDO->__construct('odbcriver={Fi...', 'odbc', 'odbc') #1 {main} thrown in/Applications/MAMP/htdocs/OMIS/core/init.php on line 6" I know that the both the Filemaker ODBC Driver and the DSN for the database exist but I'm still getting the error. The code I'm using to temporarily test the connection is: PHP Code: $dsn = 'odbc:Driver={FileMaker ODBC};Server=localhost;Database=cwp_data;'; $pdo = new PDO($dsn, "odbc", "odbc"); I do have some questions. First, does the 'Server' param need to be where the DSN is configured (localhost in this case) or where the database is hosted (external server). Second, is the PDO being handled correctly here? I am unable to find any resources on using a Filemaker database with the PDO class, so I'm sort of winging it here. I'm still researching the topic so it's entirely possible that I've missed something.
  10. Hi, I am relatively new to FileMaker. I am a PHP developer currently working on a project that involves the FMS custom web publishing PHP API. I was able to successfully connect using the API, but the connection is no longer working. The error message says only "Unable to open file". My research says that this could be due to the database file not being open, or to a permissions issue. I can see in the FMS admin console that the database file is open, with "normal" status. The FMWEBDIRECT and PHP columns both have full circles, indicating that the database should be accessible through the PHP API. Both the web server and the web publishing engine are on, with green checks, and PHP is activated. I am using the same username and password that worked previously. I checked again in the database security settings and confirmed that the username and password are still correct and that the user account has the "fmphp" privelege. What else should I look for? In the web publishing error log I see entries that say: 127.0.0.1:63876 [USERNAME] - 802 563 "fmi/sml/fmresultset.xml?-db=[DB]&-lay=[LAYOUT]&-findany" Does the PHP API use the XML API? Also, here is the full var_dump() of the error object: object(FileMaker_Error)#6 (9) { ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["error_message_prefix"]=> string(0) "" ["mode"]=> int(1) ["level"]=> int(1024) ["code"]=> string(3) "802" ["message"]=> NULL ["userinfo"]=> NULL ["backtrace"]=> array(7) { [0]=> array(6) { ["file"]=> string(90) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/PEAR.php" ["line"]=> int(945) ["function"]=> string(11) "__construct" ["class"]=> string(10) "PEAR_Error" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> NULL [1]=> string(3) "802" [2]=> NULL [3]=> NULL [4]=> NULL } } [1]=> array(7) { ["file"]=> string(101) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Error.php" ["line"]=> int(52) ["function"]=> string(10) "PEAR_Error" ["class"]=> string(10) "PEAR_Error" ["object"]=> *RECURSION* ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> NULL [1]=> string(3) "802" } } [2]=> array(7) { ["file"]=> string(129) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/Parser/FMResultSet.php" ["line"]=> int(48) ["function"]=> string(15) "FileMaker_Error" ["class"]=> string(15) "FileMaker_Error" ["object"]=> *RECURSION* ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } [1]=> NULL [2]=> string(3) "802" } } [3]=> array(7) { ["file"]=> string(122) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/CommandImpl.php" ["line"]=> int(84) ["function"]=> string(5) "parse" ["class"]=> string(28) "FileMaker_Parser_FMResultSet" ["object"]=> object(FileMaker_Parser_FMResultSet)#5 (17) { ["Vcb5e100e"]=> string(3) "802" ["Vf5bf48aa"]=> array(3) { ["build"]=> string(10) "10/27/2016" ["name"]=> string(31) "FileMaker Web Publishing Engine" ["version"]=> string(10) "15.0.3.308" } ["V1ea7e575"]=> array(7) { ["database"]=> string(0) "" ["date-format"]=> string(0) "" ["layout"]=> string(0) "" ["table"]=> string(0) "" ["time-format"]=> string(0) "" ["timestamp-format"]=> string(0) "" ["total-count"]=> string(1) "0" } ["V9f81f3c0"]=> array(0) { } ["Vaae0d98d"]=> array(2) { ["count"]=> string(1) "0" ["fetch-size"]=> string(1) "0" } ["Vae581270"]=> array(0) { } ["V6e52c40b"]=> array(0) { } ["Ve13f1c92"]=> NULL ["V43432a31"]=> NULL ["V51bc3e3b"]=> NULL ["V26005321"]=> NULL ["V6468d939"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["V5431b8d4"]=> resource(28) of type (Unknown) ["V6de51026"]=> bool(false) ["_result"]=> NULL ["_layout"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(563) "" } } [4]=> array(7) { ["file"]=> string(130) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/Command/FindAnyImpl.php" ["line"]=> int(17) ["function"]=> string(10) "_getResult" ["class"]=> string(32) "FileMaker_Command_Implementation" ["object"]=> object(FileMaker_Command_FindAny_Implementation)#4 (19) { ["_findCriteria"]=> array(0) { } ["Vd65662c5"]=> array(0) { } ["Va9136a07"]=> array(0) { } ["Vf951bdce"]=> NULL ["V83f28691"]=> NULL ["V85fd701e"]=> NULL ["V6da136ea"]=> NULL ["V568aa2ec"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["_layout"]=> string(23) "BW Newsletter2Go Import" ["V7a2db0ea"]=> NULL ["_script"]=> NULL ["_scriptParams"]=> NULL ["_preReqScript"]=> NULL ["_preReqScriptParams"]=> NULL ["_preSortScript"]=> NULL ["_preSortScriptParams"]=> NULL ["V0b9a204c"]=> string(16) "FileMaker_Record" ["_recordId"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(563) "" } } [5]=> array(7) { ["file"]=> string(103) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Command.php" ["line"]=> int(137) ["function"]=> string(7) "execute" ["class"]=> string(40) "FileMaker_Command_FindAny_Implementation" ["object"]=> object(FileMaker_Command_FindAny_Implementation)#4 (19) { ["_findCriteria"]=> array(0) { } ["Vd65662c5"]=> array(0) { } ["Va9136a07"]=> array(0) { } ["Vf951bdce"]=> NULL ["V83f28691"]=> NULL ["V85fd701e"]=> NULL ["V6da136ea"]=> NULL ["V568aa2ec"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["_layout"]=> string(23) "BW Newsletter2Go Import" ["V7a2db0ea"]=> NULL ["_script"]=> NULL ["_scriptParams"]=> NULL ["_preReqScript"]=> NULL ["_preReqScriptParams"]=> NULL ["_preSortScript"]=> NULL ["_preSortScriptParams"]=> NULL ["V0b9a204c"]=> string(16) "FileMaker_Record" ["_recordId"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [6]=> array(7) { ["file"]=> string(64) "/Library/FileMaker Server/HTTPServer/htdocs/newsletter/index.php" ["line"]=> int(32) ["function"]=> string(7) "execute" ["class"]=> string(17) "FileMaker_Command" ["object"]=> object(FileMaker_Command_FindAny)#3 (1) { ["_impl"]=> object(FileMaker_Command_FindAny_Implementation)#4 (19) { ["_findCriteria"]=> array(0) { } ["Vd65662c5"]=> array(0) { } ["Va9136a07"]=> array(0) { } ["Vf951bdce"]=> NULL ["V83f28691"]=> NULL ["V85fd701e"]=> NULL ["V6da136ea"]=> NULL ["V568aa2ec"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["_layout"]=> string(23) "BW Newsletter2Go Import" ["V7a2db0ea"]=> NULL ["_script"]=> NULL ["_scriptParams"]=> NULL ["_preReqScript"]=> NULL ["_preReqScriptParams"]=> NULL ["_preSortScript"]=> NULL ["_preSortScriptParams"]=> NULL ["V0b9a204c"]=> string(16) "FileMaker_Record" ["_recordId"]=> NULL } } ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["callback"]=> NULL } Any help would be much appreciated!
  11. Hi there,  I am having the problems in accessing the data stored in container fields using  php. The containers are not remotely stored. A screenshot is attached showing the database settings for container field. I am able to access data stored in other fields from a remote computer using php api. But when I try to access the container fields... For: $image=$record->getField('container field');     $attach=$fm->getContainerData(urlencode($image));     if (FileMaker::isError($attach)) {       echo "Error: " . $attach->getMessage() . "n";     }  I get:: Error: getContainerData() does not support remote containers  For: echo $fm->getContainerDataURL(urlencode($record->getField('containerfield')));  I get a url in response simlilar to :: http://HOSTIP/fmi/xml/cnt/Untitled.jpg?-db=DATABASENAME&-lay=LAYOUTNAME&-recid=253&-field=containerfield  When try to open the url in a browser I get a  xml in return that has ::   <error code="959"/>   My server has php and xml access enabled for the privilege set I am using.  Thanks in advance   Â
  12. 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 the correct Content-Type header if($url == "jpg"){ header('Content-type: image/jpeg'); } else if($url == "gif"){ header('Content-type: image/gif'); } else{ header('Content-type: application/octet-stream'); } // save file local. file_put_contents('/srv/www/htdocs/testfilepicture.jpg', $fm->getContainerData($url_orig)); } I was using this reference: http://blog.myfmbutler.com/?p=104 This Code-Snipped works well, but only writes "getContainerData() does not support remote containers" into testfilepicture.jpg.. We are using FileMaker Server 14. Any Ideas? Thanks in advance and Cheers
  13. Database Application Lead: FileMaker Technology Team Location: Devon/Philadelphia Area, United States Relocation assistance is provided Is this you? You love staying current with latest technology, mobility and social media trends. You love mastering skills, whether it’s playing drums on the weekends or developing a cool mobile iOS or Android app. You aren’t picky about what tool you use – you just want to design and deliver high-value database apps for client success. If you've got passion for innovative technologies in the FileMaker Platform and are excited about database solutions especially in a world of smart phones and tablets, we'd love to have you join our company, full of "doers" and "thinkers" just like you! As a Database Application Tech Lead on our FileMaker Philly team, you will design database solutions on latest version of FileMaker Software while leading a team of developers deploy custom software. As a Technical Lead, you will... Analyze Needs Sharpening your solid experience in systems analysis and consulting, you’ll work with clients to define goals, propose solutions and evaluate alternatives. Design Applications Building off of your strong skills in application design and architecture, you’ll create prototypes, define project plans, make estimates and write technical specifications. Implement Systems As you hit the ground running with your solid relational database skills, you’ll provide deep technical expertise and lead delivery of FileMaker systems. Deliver Value As a reliable self-starter who likes helping people, you’ll deliver significant value for appreciative clients, and you’ll feel proud as you partner with clients on achieving their business goals. Mentor Teammates Deepening your natural teaching abilities, you’ll work alongside rising developers by teaching, training and encouraging. Grow Your Talents Building off of your intellectual curiosity and your degree(s) from top-tier school(s), you’ll improve your skills each year and collaborate with technology communities. Keywords: Database, FileMaker, FileMaker Pro, FileMaker Go, Developer, Consultant, Relational Database, MIS, Management Information Systems, MS Access, Lotus Notes, Domino, MySQL, XML, Oracle, Database Design, Data Manager, Project Manager, Data Solutions, Agile Development, Project Management, Iterative Estimates, Trusted Advisor, XP, Paired-Programming, Mobility, Web Development, PHP, Html 5, IT, Information Technology, iOS, Windows, Mac, Web Browsers Apply Online: https://soliant.recruiterbox.com/jobs/25605 Contact: Faridah Hemani e-mail: fhemani@soliantconsulting.com
  14. Hi all, I'm new here so I hope I get everything right. I've done a search already, but I can not find my issue listed. Sorry if it's been covered before. OK, here goes..... VMWare Server running on HP Prolient G7 tin 2 Virtual Cores 4Gb RAM Windows Server 2012 R2 DataCenter x64 IIS v8.5 (Default for 2012 R2) FileMaker Server 12 FileMaker Pro 12 Advanced with Bonjour JRE v7 This is a brand new build specificity for this use. I've installed FileMaker Server 12 on to the above setup with Custom Web Publishing using PHP I followed the deployment wizard and deployed for a single machine setup. I allowed FMS to install the provided version of PHP with it's own configuration. There is NO SSL configuration on the server at present. The admin console shows three green ticks to indicate that everything is happy. However, when I run the PHP Custom Web Publishing Test, I get the page displayed correctly, (PHP is working) and it identifies the name of the server, but below the main information box, I get the following error message: The PHP connection to the FMServer_Sample database failed. The PHP test was not able to communicate with the Web Publishing Engine. Make sure you have PHP publishing enabled and the database has the fmphp extended privilege enabled. (Error 22; Unknown error) The sample database is installed and it is listed in the admin console, status, normal and dots across the line. I can't imagine that it wasn't installed with the correct Extended Privileges for CWP and I would not be 100% confident to know what I should check for. I am viewing the CWP Test webpage on both the server and a client and getting the same error message. Can anyone suggest any further areas that I should be looking at? Cheers in advance, Barry.
  15. I'm having great success with the PHP site assistant aside from one major issue. I'm not able to display images stored in Supercontainer. The code below will return a broken link. If I take the reference link and paste it into any web browser on any computer on any network, the link works fine. What obvious step am I missing? <td rowspan="8" class="field_data"> <?php echo "<img src='http://74.119.147.179:80/SuperContainer/Files/CKD_Files/PDT/2009/1035/90101463440377643/IMG_6944.jpg' title='Error' alt='Error' />";?> </td>
  16. (Long story short.) I'm moving a complex solution from a local network to a hosted service. The solution uses (and needs to use) external authentication. In order to divorce the solution from the local network completely, we will no longer be using our active directory on the local network. Setting up security groups and users on the hosted server and configuring FM server to authenticate against it was very easy. Only one problem remains, How can users change their passwords? This isn't really a Filemaker question as the question becomes, how can you let a user change their password on windows servers if they do not have desktop access(on the server)? I have done a couple of google searches and found enough to know I could write some sort of custom solution (or likely adapt one that is already out there) but before going down that rabbit hole.... I thought I would ask the helpful people here.
  17. Kara Amsinger

    EMAILING BLANK FORMS

    I have setup through the PHP site assistant to be able to fill out a questionnaire online and the info submitted is entered into a new record, then the same info is emailed to me. About a month ago this process was working perfectly and now I was going back in to finish one last thing and come to realize that when I hit submit it sends me blank emails. But when I go into my database the information is there in it's own record. And when I run the SMTP Email Script from within the database it will then email me the all the information in the record. I have created new forms, pasted in old code that were back when it was working and nothing seems to get it back to the point where it emails me the sumbitted info. Any ideas of where I can start looking to fix the problem? I have several files of php code for this setup that I can attach if needed. Just didn't want to clutter the post with a bunch of code.
  18. AngeloCit

    keep format input

    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...
  19. dpistolenma

    PHP API Slowness

    Hey there, I'm currently building a web interface that interacts with our filemaker solution (FM Server 13) and have run into some performance issues. We have a table which has 161,000 records, and I am exposing 6 of its fields via a layout. When I run a filemaker find command via the API, looking for specific values in 3 of these fields, it takes extremely long for the results to be returned (up to a minute sometimes). The result is usually 1 or 2 records. For what its worth, I have another table with 73,000 records that does not have performance issues. I've tried to use xdebug to profile my PHP code, and the majority of the response time is this one findCommand and curl_exec, so I don't think the slowness is on the webserver. I've also looked at the statistics page on the server and when the call is made there are tens of thousands of "remote calls" for the client used by the PHP API, not sure if this is normal or not. I thought about maybe increasing the PHP memory limit on the server, but not sure which php.ini is used by FileMaker Web Services. We're running OSX mavericks and I changed the value in a php.ini file that I found in "FileMaker Server/Web Publishing/publishing-engine/php/mavericks/lib/" from 128M to 1024MB but did not see any performance increase (though I am not sure that the change took effect, nor that that is right PHP ini file). Anyone have any other ideas? The server that it is running on has 64GB of RAM, and finds are quick when using a filemaker software client.
  20. I have a php script that takes two PDF files and merges them into one file. I am using this in conjunction with the insert from URL script step. The way the script works is it takes two PDFs in container fields and base64encode each files. Then, those two base 64 strings are POSTed via insert from URL. I've tested the script forwards and backwards and it does combine the PDF files reliably. The issue is when posting from FileMaker. What typically happens is the first page is combined twice and that's my resultant PDF. My php script checks that both inputs are different and throws an error is they are identical. I don't get any errors there. Is there a way to POST a file from insert from URL?
  21. I am rewriting our 15 satellite offices to be on one web server, instead of individual FMP software solutions. I am rewriting anyway because my files are large and too much code and layouts are not used that happens from 20 years of adding on, it is just time... They will be able to share the database direct, but when it comes to iPad and iPhone, just downloading Filemaker Go and then emailing them the revised smaller designed layouts will give them the data access to the server database, correct? There is no need for webdirect. I would also like to have our customers forms update directly into our database from our website. So, my plan is to use PHP to connect the web data into the same Filemaker Server. Again, no need for webdirect and no need for those additional licenses, correct? Upgrading from Filemaker 12 to Filemaker 13 does not require us to use webdirect? Thanks
  22. 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 the session variables for the ID's. A few items of code had to be re-written & these elements now work fine, however I have just noticed a new problem & I have no idea how it is happening... The first step on the first page is to test for the existence of 2 variables. If these variables do not exist a record is created in the database and the 2 variables are set (see below). if (!isset($ID) AND !isset($recordID)){ $stepTwoEdit = $fm->newAddCommand('webCandidateFormStepTwo'); $result = $stepTwoEdit->execute(); if (FileMaker::isError($result)){ echo $result->code; die(); } $record=$result->getRecords(); $recordID=$record[0]->getRecordId(); $ID=$record[0]->getField('ID'); session_start(); $_SESSION['recordID']=$recordID; $_SESSION['ID']=$ID; session_write_close(); }//if record has not yet been created in the database create it so that we have an id Now this code works perfectly. I have echo-ed the variables onto the page and they are being set correctly & I have done tests to verify that the newAddCommand is only being performed once by echo-ing text inside the if statement. So it appears to all be working correctly, until you go and look in FileMaker. Blank records are being continuously created by the server, despite the fact that the newAddCommand is not being repeated. This command is called once and only once. These records are not just created on page refreshes or on navigation between form pages - they just keep being created every x seconds (there's no consistent interval)... Any ideas?!? Really need to get these clients onto our new server asap, so help would be massively appreciated! Thanks in advance! x
  23. I am experienced with both FileMaker and PHP, but I am new to the FileMaker PHP API, and I'm trying to find the easiest/best way to implement a sort of web service. I have a FileMaker script that currently does most of what I need, but I need to run it via the PHP API. A remote server submits a single http request with several variables to the FM web server, including an ID number. These values are stored in global fields in a FileMaker table. A FileMaker script then retrieves these values from the global fields, and searches the table for an existing record with the same ID number. If there is no record with the same ID, a new record is created and populated with the submitted values. This single record is returned, including additional values that must be calculated by Filemaker. If there is already an existing record with the same ID, the existing record is compared to the values submitted by the remote server to see how different they are. If the values are the same, or similar enough, then the record is considered a match. The values from the existing Filemaker record are returned. If the ID is the same, but the differences in the other values exceed a certain threshold, then the record is not a match, and an error is returned. The current script works by storing the remotely submitted values in global fields, then operating on those. But globals are session-specific, and from what I've seen, it doesn't look like the PHP API supports persistent sessions. Each transaction seems to be a separate session, so the globals are lost. I've read that it's possible to have globals persist for an entire session with XML or XLSLT, but I suck at XML, and really can't afford the time to learn. Is there a simple way to make globals persist for an entire session with the PHP API? Failing that, is there another simple way for me to use the existing script?
  24. We have a (fortunately) backup server we are trying to bring up and we testing our PHP/CWP solutions on it as the last step. Up to this point, everything seemed to be working fine: all the canned server tests (well, IWP and CWP) had worked OK; a couple of add-ons appeared to be working fine; client access was good; custom IWP solutions were good. Then we ran into a problem with the CWP solutions that we have. We have a login system where you start at an Index page, it reroutes you Login if you aren't logged in. The initial redirection and showing of the login page works OK. But when you log in, it apparently fails to authenticate you and just returns error: "XML error: Not well-formed (invalid token) at line 1" (or something like that). The failed login attempt doesn't show up in the FMS logs, either. So it is almost as if it isn't even contacting the server. These CWP pages are working fine under the live server (thankfully), which is configured very similarly: Windows 2008 R2 FMSA 12.05 SSL two plugins that run as tomcat processes IIS 7.5 (using URL re-write for HTTPS redirection) We have even had them running on an OSX based server without problems. I think that I discovered the apparent cause of the CWP problems, at least, but I would like to know WHY, and how to fix it if someone knows: I had to remove the 'hostspec' definition from the dbaccess.php file we use. remove the 'hostspec' definition from "dbaccess.php" = works define 'hostspec' in "dbaccess.php" = fails remove the 'hostspec' definition from "dbaccess.php" = works I found this because the canned FMS CWP test does not use a 'hostspec' definition. I suspect that it may have something to do with the php.ini or various other FMS configuration files around there. You see, we didn't have SSL installed at first, but installed it after FMS was setup. So during the installation of SSL, I have previously discovered that there are a few files you have to manually adjust (I posted about them here), even if you do a redeployment. But, it could also be because of some IIS redirection issue, it seems. Any ideas? Thanks, Justin
  25. XML error: No memory at line 1 Greetings, this error occurred when the Filemaker API cannot generate a bunch of records. (1000+ records and above) I've adjusted the time out settings for PHP even the memory limits. Is there any possible solution for this? According to some information, the error turns out that the 10 MB XML scripts is unchangeable. thanks.
×

Important Information

By using this site, you agree to our Terms of Use.