Search the Community

Showing results for tags 'api'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Categories

  • Journal

Community Forums

  • Community Resources
    • FileMaker Pro 15 Discussions
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 15
    • FileMaker Server 14
    • FileMaker Custom SSL Certificates
    • External Server Authentication
    • Stand by Server Deployment
    • Legacy FileMaker Server Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
    • FileMaker Discussions
    • Brain Food
  • FileMaker and the Internet
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker

Categories

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

Calendars

  • FileMaker User Groups

Found 580 results

  1. I am having an issue with a value list not showing up on my php page consistently. Most times the value list appears as it should. Some times it will come up blank. If I REFRESH the page, then it usually appears. I don't think my coding is incorrect because it works most of the time. Why would I have to refresh the page for it to appear. Does it have to do with the server connection…? I do display other fields on the php page, like name and email address, but the value list is the only one that does not show up all the time. CorrectVL.tiff incorrectVL.tiff
  2. I am tasked with troubleshooting a web registration form that queries a Filemaker Pro v12 database via a Filemaker PHP API. The web form had been running well for a couple of months after major revision, when all of a sudden: All dropdowns are empty All radio buttons are missing These symptoms appear to be browser-independent. The appearance of these symptoms is mysterious: Nobody has modified the PHP code for the web form - I've done a compare with a backup done at the time when the web form was not broken and it is identical to what is currently on the server. The Filemaker Pro layout that the web form is querying is just fine - all the value lists for the dropdowns and radio buttons are present. I've created a stripped-down version of the web form: https://campmeetings.cccsda.org/test_form.php and I've also attached the php source code file. The date and record fields are populating correctly. Notice the empty dropdown list after "Church I attend." Could this be caused by an incompatibility between the FMP PHP API and PHP libraries on the server? Perhaps due to a PHP update on the server? Any ideas how to troubleshoot this? test_form.php
  3. Hi. I am trying to script the getting of some data from a website that has an API. I have BaseElementsPlugin and was given an example bit of code by the website: data = {'domain': domain, 'include_generic': True} headers = {'X-Api-Key': 'xyz123'} resp = requests.post('https://api.anymailfinder.com/v3.0/search/domain.json', data=data, headers=headers) I have never dealt with this kind of programming and am not even sure where this info would go or what script step(s) I would use to call this. Is this CURL? Are you aware of sample FM scripting that I could use as a model to figure this out? Thanks for any help with this!
  4. Version 1.0.0

    22 downloads

    Being unsatisfied with solutions I found on the internet and wanting a solution without plugin I created a set of custom functions that can read a path out of a json-string. Syntax: json_path ( json-string ; path ) examples: json_path( $user_prefs ; "Privileges/Modules" ) json_path( $json_data ; "Menus/Menu[10]/MenuItem[5]/Label" )

    Free

  5. Has anyone come across a way to have filemaker execute an online trade with a brokerage account? I want a DB to place a trade buy or sell with a brokerage house - probably thru an API Thanks in advance J
  6. Server: Windows R2 2008 SP1 FileMaker Server 13 Connections via PHP I have several databases that users connect to via a web browser using php. All has been working correctly until Friday 1/3. I have been assured by IT that the server has not changed. However, the PHP connections are no longer reliable. Sometimes, the user can log in fine. Other times, a user logs in, submits a request, and it looks fine to the user. However, the "Error: Did not receive an XML document from the server." is thrown. Other times, the error is thrown and the user knows something is wrong. Sometimes the form will display the correct information, and sometimes the form cuts off. No change has been made to the code other than adding a date picker. I'd appreciate any help as I'm truly stumped by this. I've included the php files in case you see any issues. Thanks.
  7. hello, i'm a beginner, i have problem with a php script, i run it (1/2 minutes), reaches the command execute() and then it stop with no error message. this is the script: $fm_a = new FileMaker($file, $host, $username, $password); $a_table = $fm_a ->newFindCommand('layout_name'); $a_table->addFindCriterion('online', '1'); $a_result = $a_table->execute(); if (FileMaker::isError($iconografia_result)) { ....... where i'm a wrong? thanx for your time and collaboration Simone
  8. Hey Guys, I've got two sets of results from two different queries. The fields in both tables are almost identical, the one field I need to access is. My question is before I continue to do the foreach loop to return the appropriate field, can I merge the two results together prior to my foreach loop? It would basically help condense some of the repetitive code. the only field I am interested in retrieving from both datasets is called dataPlot. $dataset1 = $fm->newFindAllCommand('table_dataset1'); $result1 = $dataset1->execute(); $dataset2 = $fm->newFindAllCommand('table_dataset2'); $result2 = $dataset2->execute(); Many thanks Jalz
  9. Good Morning, Stumped with a FileMaker Server 14 installation and getting the PHP web pages to work. Machine Specs: Mac OS X El Capitan v10.11.2 Mac Pro (Mid 2012) Processor: 3.2GHz Quad-Core Intel Xeon Memory: 12Gb FileMaker Server 14.0.4.412 installed SuperContainer 2.93 installed When viewing the FM 14 Console: FM Server is Green Web Server is Greyed out, PHP is enabled and XML is enabled (See attachment of screen shot) Web Publishing Engine is Green ODBC/JDBC is Green When trying to run the test page (Server > Open Test Page and clicking Test PHP Custom Web Publishing) Getting Not Found, The requested URL /fmi-test/phptest.php was not found on this server When I hit the server from a browser, I noticed it's hitting from the Web Server Path and NOT the FM Server path. FM Server: Library > FileMakerServer > HTTPServer > htdocs Web Server: Library > WebServer > Documents The web server path is serving up HTML and showing the PHP code and not processing it. Can anyone help with correcting this problem? We would greatly appreciate it.
  10. I have the same exact solution files setup on 2 separate server stacks. Everything is working perfectly one one, but on the other I'm getting this Communication Error (22) and I cannot figure out why.The message says specifically... The files are exactly the same, though. The FileMaker files themselves and the PHP files. The usernames and passwords are all exactly the same in both places. It's just that they are running on different server stacks. Both, though, are a combination of FileMaker (in-house) with a web server hosted by the same hosting provider.I have a very basic script setup to test the connection to FileMaker by displaying the available data sources, and it works perfectly (as well as everything else I do via PHP API) from one server. The same exact script on a different site hitting a different FileMaker server (with a copy of the same FM files on it) is giving me the 22 error.Everything points to the credentials being wrong or the FMPHP privilege not being set for the user, but that is simply not the case. Again, it's a mirror of something that works elsewhere, and of course I did check those credentials numerous times to be sure.The router at both FileMaker servers (working and not working) is setup with the same port forwarding rules, but that said, I am not quite as confident in the router configuration of the location where the connection is not working correctly as I am the other place. I am not finding any information while Googling about this issue being caused from network config, though. Everything just says to check the credentials, but I have, and that is not the problem.Any information I can get on how to potentially fix this would be greatly appreciated.
  11. I would like to edit a value list via a web interface- I have done this using a field ("Use values from field"), but that [I incorrectly assumed, see doughemi's suggestion below!] requires adding/editing a record for each value, while (if possible) the textarea box would allow the editing of the whole value list at once. Genx showed how to display a value list... $layout = $fm->getLayout('my_template'); $list = array_map("htmlentities",(array)$layout->getValueList('my_list')); I am hoping there is some easy way to send back an edited valuelist… We are using Filemaker Server 11 (not advanced). Thanks in advance!
  12. Version 1.2.0

    Easily integrate PayPal web service APIs into FileMaker applications using custom functions the same way you use any other function in FileMaker. Process credit cards, refund transactions, pull transaction details, and a whole lot more, all with the ease and comfort of the FileMaker scripting process. Our FileMaker PayPal custom functions make it quick and easy to integrate PayPal’s API platform into your FileMaker database solution. Simply open the solution file to load the PayPal custom functions into the system, and they will be available to be used within all of your FileMaker databases. The functions work exactly the same as any other function you use within a FileMaker calculation. You simply pass in request parameters and the function handles the rest. All PayPal response data is stored in the solution file in a single table as global fields so the data is immediately accessible via your FileMaker script to populate your own tables/layouts, make calculations, etc. Supported FileMaker PayPal APIs General AddressVerify DoNonReferencedCredit GetBalance GetTransactionDetails MassPay RefundTransaction TransactionSearch RefundTransaction Authorization and Capture DoAuthorization DoCapture DoReauthorization DoVoid DoDirectPayment Recurring Payments / Reference Transactions BillOutstandingAmount CreateRecurringPaymentsProfile DoReferenceTransaction GetBillingAgreementCustomerDetails GetRecurringPaymentsProfileDetails ManageRecurringPaymentsProfileStatus UpdateRecurringPaymentsProfile Demo Videos

    $89.00

  13. View File PayPal for FileMaker Easily integrate PayPal web service APIs into FileMaker applications using custom functions the same way you use any other function in FileMaker. Process credit cards, refund transactions, pull transaction details, and a whole lot more, all with the ease and comfort of the FileMaker scripting process. Our FileMaker PayPal custom functions make it quick and easy to integrate PayPal’s API platform into your FileMaker database solution. Simply open the solution file to load the PayPal custom functions into the system, and they will be available to be used within all of your FileMaker databases. The functions work exactly the same as any other function you use within a FileMaker calculation. You simply pass in request parameters and the function handles the rest. All PayPal response data is stored in the solution file in a single table as global fields so the data is immediately accessible via your FileMaker script to populate your own tables/layouts, make calculations, etc. Supported FileMaker PayPal APIs General AddressVerify DoNonReferencedCredit GetBalance GetTransactionDetails MassPay RefundTransaction TransactionSearch RefundTransaction Authorization and Capture DoAuthorization DoCapture DoReauthorization DoVoid DoDirectPayment Recurring Payments / Reference Transactions BillOutstandingAmount CreateRecurringPaymentsProfile DoReferenceTransaction GetBillingAgreementCustomerDetails GetRecurringPaymentsProfileDetails ManageRecurringPaymentsProfileStatus UpdateRecurringPaymentsProfile Demo Videos Submitter angelleye Submitted 01/17/2016 Category Plug-Ins FM Version FM Version: 1
  14. I'm using setResultLayout for the first time so I can search on one layout with all the find fields on them but then switch to a much simpler layout with just the fields required for the search results. My search looks like this: $request = $fm->newFindCommand('WebSearch'); $request->addFindCriterion('customerName', $_GET['contactName']); $request->setRange($skip, $max); // Set the layout to use for the Search Results $request->setResultLayout( 'WebSummaryList' ); // Perform the Find $result = $request->execute(); if (FileMaker::isError($result)) { if ($result->code = 401) { $findError = 'There are no Records that match that request: '. ' (' . $result->code . ')'; } else { $findError = 'Find Error: '. $result->getMessage(). ' (' . $result->code . ')'; } } else { $records = $result->getRecords(); } -- I'm finding that when I include the line $request->setResultLayout( 'WebSummaryList' ) that my test for an error fails - if (FileMaker::isError($result)). I'm performing some finds with criteria that I know does not exist but the $findError variable is not getting populated (it returns 0 records). If I remove the line $request->setResultLayout( 'WebSummaryList' ) then the $findError variable is getting populated correctly. Can anyone see what I might be doing wrong or is this expected behaviour etc? thanks, Steve
  15. Hi all I just helped someone else with this problem, so I'm posting again here to make it publicly available: THE PROBLEM: The PHP API function "getValueList" can break under FMS10 when there's an ampersand (&) in one of the values: "apples & oranges" > becomes > "apples apples &apples & oranges" The function has officially been "deprecated" in FMS10 -- and replaced with "getValueListTwoFields" -- but the ampersand is a case when the original function in fact _breaks_ when hosted in FMS10. Changing to the new function fixes the problem. (I don't know if any other characters also cause problems.) WHO THIS AFFECTS: - Anyone who has used the getValueList function with FMS9 -- whether via the Site Assistant or not -- and upgrades to FMS10 - Anyone who uses the getValueList function under FMS10 - Anyone who has or may someday have ampersands (or possibly other characters?) in any value-list values that are published to the Web via the PHP API under FMS10. REMEDY: When upgrading to FMS10: Replace all instances of "getValueList" with "getValueListTwoFields". When developing under FMS10: Always use "getValueListTwoFields". (While in FMS9, do NOT use "getValueListTwoFields" as the function does not exist.) I hope someone finds this helpful. Best, -Joel ~~~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro database & web design http://www.jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~~~
  16. Hi, I'm doing a newFindAllCommand in a db with 5000 records. I get no results unless I set my $myFind->setRange(0,500); , which only returns the first 500. 500 seems to be a cut-off point for some reason, Is this a thing? Also, I want a varCount that doesn't refresh back to '1' when the next 500 records are displayed, i.e. the next record numbers should say 501, 502... Thanks again!
  17. Hi, I'm trying to find records with a number field that are greater than or less than 2 numbers, i.e. if I'm looking for the records greater than 115 and less than 120. $myFind->addFindCriterion('ssvm', '>115'); $myFind->addFindCriterion('ssvm', '<120'); do I need $myFind->setLogicalOperator(FILEMAKER_FIND_AND); or am I way off base? Thanks for your advice!
  18. My permissions are set correctly with one Admin account with full access and one guest account with access to creating and editing only. I am not getting a password prompt when I delete records so anyone can delete them. Do I need a PHP validation code of some kind to require a password when deleting records? Thanks!!
  19. Hi, I have several fields I'd like to sort that are empty, like Email. Here are 2 snippets of code that are not returning results: $RandyFind->addFindCriterion("Email", ''); or $RandyFind->addFindCriterion("Email", "=="); Any thoughts? Also, is there a way to force null into a field when editing? Thanks a Bunch!!
  20. Hi Guys, I've built an application and one of my 'dialog' windows has a web viewer in it which contains a html text editor. I use api for php to add content back into a FileMaker database when someone submits the html form. This all works well, however I would also like to shut down my FileMaker dialog window, upon submit. Is this possible using the API for PHP somehow calling a client-side script to close window for the particular user? Thanks in advance
  21. A client of mine wants to tie their solution to Converge (https://www.myvirtualmerchant.com/VirtualMerchant/). They offer an XML option, so it look feasible, but I was wondering if anyone else has tied a Filemaker solution to Converge's API? Also, with the new EMV Chip Cards, does anyone recommend any particular payment gateway for Filemaker? Or do the new chip cards not affect anything? Any and all info about payment API's most welcome. FM Pro and Server 14, Mac OS X environment. Thanks!
  22. Hi, I'd like to sort records using value lists as well as text fields. My FirstName field works (try Steve) but I'm at a loss on how to make the valuelist sort records correctly. I want to search records from CA in my State valuelist. Here's a link and the php code. Thanks All! http://ssvtennis.com/valuelistsort.php valuelistsort.php
  23. I have lots of searchs that may return 'no records'. Is there coding that will not kill other php requests on the same page? Can I make an If statement that will search my db for a count of records before a result is executed: something like if ($_Get Count($field == 1) my field is 'lafall1'. it is a tennis tournament. when someone clicks 'yes' for lafall1, it returns the number '1'. this way, when someone plays 'lafall1', lafall2 and la fall3', a calculation field returns that 3 tournaments have been played. If no one has clicked 'yes' for 'lafall1', the query will return an error: no records match this request. It stops the script and the coding on the rest of my page dies. Here is a snippet of my code. Thanks! <?php $RandyFind = $fm->newFindCommand('mylayout'); $RandyFind->addFindCriterion('lafall1', '1'); $RandyFind->addSortRule('ssvm', 1, FILEMAKER_SORT_DESCEND); $RandyFind->setRange(0,500); $result = $RandyFind->execute(); if (FileMaker::isError($result)) { echo($result->getMessage()); exit; } ?> <?php $found = $result->getFoundSetCount(); if($found == 0) { $record_count = ''; } elseif($found >= 2) { $record_count = '(' . $found . ' players)'; } echo $record_count;?>
  24. Hi, I'd like my New Record.php to advance to an Edit.php upon clicking submit on the New Record form. I don't want to remain on the New Record.php, but doing otherwise gives me a 'no record created' message. Here's an example of my New Record.php Thanks! newinputplayer.php
  25. I am trying to create a login process based on the Accounts and Privileges in FMP. I have, as a guide, Johnathan Stark's article "Deliver Secure Web Applications with PHP and FileMaker Pro" from the February/March 2008 issue of FileMaker Advisor. Copying Johnathan's code is no problem and I understand how it works. However, I'm trying to do it a little different: 1. I have an "includes" folder which contains, among other things, a header.php file. This way I only have to go to one place to change things like the horizontal navigation. 2. The "includes" folder also has a functions.php file (based on Lance Hallberg's DVD series "FileMaker 9 & PHP Foundations") 3. The login page is Index.php I think I'm creating a bit of a circle, but I can't seem to get it clear in my head. The user fills out the form in Index.php which creates a Session. The Session provides the db_connect() function (in functions.php) with the username and password (whether storing a username and password is secure in a Session is another topic - I'd like to hear more about this, but for now I'm just trying to get this thing to work). The user is then taken to a dashboard. The header.php file calls the db_connect() function so the methods are (theoretically) available for all the pages. Finally, all pages have the following: if ($_SESSION['authenticated'] == False ) { header('Location: index.php'); } There are a number of things wrong with my system: 1. Even with the wrong username/password, access is granted. 2. With the correct username/password, I receive the same error messages (and granted access): Fatal error: Call to a member function newFindCommand() on a non-object in /Applications/MAMP/htdocs/FMP_Justic_POC/studio_list.php on line 10 Notice: Undefined index: authenticated in /Applications/MAMP/htdocs/FMP_Justic_POC/dashboard.php on line 3 Warning: Cannot modify header information - headers already sent by (output started at /Applications/MAMP/htdocs/FMP_Justic_POC/dashboard.php:3) in /Applications/MAMP/htdocs/FMP_Justic_POC/dashboard.php on line 4 Here is my relevant code for the files: index.php <?php session_start (); require ('includes/header.php'); date_default_timezone_set('America/Detroit'); // 1. Log in successful - Session in process if (isset ($_SESSION['authenticated']) && $_SESSION['authenticated'] == True ) { ob_end_clean(); // Destroy the buffer called in includes/header.php header ('Location: dashboard.php'); exit(); // 2. Form completed - verify data } elseif (isset($_POST['username']) && (isset($_POST['password']))) { $_SESSION['username'] = $_POST['username']; $_SESSION['password'] = $_POST['password']; $_SESSION['loggedin'] = time(); return; } // 3. Form incomplete - show form ?> <div class="grid_16"> <p>Welcome to the FileMaker database online. Please enter your username and password to gain access. If you do not have a username and password, please see your systems administrator.</p> </div> <div class="grid_8"> <form action='index.php' method="post"> <label for="username">Username</label><input type="text" name="username" /> <label for="password">Password</label><input type="password" name="password" /> <input type="hidden" name="submitted" value="true" /> <input type="submit" name="Login" value="Login" /> </form> </div> </div> <?php require ('includes/footer.html'); ?> header.php <?php // turn on output buffering ob_start(); include ('FileMaker.php'); include ('includes/functions.php'); $fm = db_connect(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" etc. functions.php // DATABASE CONNECT function db_connect() { if (isset($_SESSION['username'])) { $username = $_SESSION['username']; $password = $_SESSION['password']; $fm = new FileMaker('justice', '127.0.0.1', $username, $password); $result = $fm->listLayouts(); if (FileMaker::isError($result)) { echo '<p>Error</p>'; $_SESSION['authenticated'] = False; } else { echo '<p>No Error</p>'; $_SESSION['authenticated'] = True; } } } I would greatly appreciate any help! Thanks.