How to Process Credit Cards with FileMaker and PayPal Payments Pro by Drew | Last Updated Jul 29, 2015 | Published on Oct 27, 2011 | Blog, FileMaker, FileMaker, PayPal, PayPal, PayPal Custom Functions, Videos | 22 comments This video demonstrates how to utilize the Angell EYE PayPal Plugin for FileMaker to process credit cards with the Payments Pro (DirectPayment) web service API. See the documentation page for more details. 22 Comments Dino on March 20, 2013 at 8:18 am Absolutely amazing – I’ve just discovered this site and would like thank you warmly for making these resources free.. My jaw has literally dropped to the floor!. You mention in the video you would be making the invoices test file available on the site but I can’t seem to find it anywhere. Is this no longer being published? It’s just it would give me a great head start in implementing your gorgeous solution!!. Again – wow – I am in awe !! Reply Andrew Angell on March 20, 2013 at 10:11 am Unfortunately, I haven’t had the time to focus on this solution since I first released it. I have lots of plans for it, though. Stay tuned. I hope to get to it before too much longer. Reply Dino on March 20, 2013 at 10:36 am Thanks for getting back !, I don’t mind if it isn’t finished It looks a damn site better than the mess I’ve made and it’s been a work in progress for a few years now!!. I’ll offer to pay for it as well!! Reply Dino on March 20, 2013 at 10:38 am arghh.. meant to ask as well – is it possible to download new orders with these methods? all the videos seem to indicate that a specific order has to be quoted – how can new orders be received and if possible – historical transactions (although that’s less of a priority as these can just be downloaded through the site). Reply Andrew Angell on March 22, 2013 at 3:32 am You can use the TransactionSearch function for that. Admittedly, it’s not the smoothest process right now, but it does make the job pretty easy from FM. Take a look at it and let me know if you have any questions. If you want to bring in new orders in real-time, though, I would recommend hooking up IPN. I have an IPN solution you could install to a PHP web server using MySQL, and then you can use FM external SQL sources to bind the MySQL database to FM for easy access to the data. You can build layouts based on the MySQL data or you can create scripts to sync the MySQL tables with your FM tables accordingly. Reply Dino on March 22, 2013 at 6:54 am Nice idea – thanks for the tip. Guess I could run it on a schedule – can it run the transaction search and get all historical data by any chance? I’d probably get shot by paypal as it would need many small (100 or less transactions else not complete)!! or is the data in the CSV stream the same as the data it gets through the api? I found the transaction search function – it dumps all the data in one field as xml.. do you have any hints on parsing that? I ask incase you have any tips on that or have done it previously!. Can I offer assistance on any tasks on the fm invoices file you have? would really love to get my hands on it !! if not no worries!! Reply Andrew Angell on March 25, 2013 at 4:49 pm Are you talking about the invoices file I use in my demo videos? That should be included with the plugin download. Is it not?? wenliang on May 22, 2014 at 9:55 am I don’t see the invoice file in the download. Can you post it here? or could you please send me a copy by email: firstname.lastname@example.org? Thank you!! Reply Andrew Angell on May 22, 2014 at 10:23 am I emailed it to you. Reply wenliang on May 22, 2014 at 10:39 am it’s so nice of you! Such a quick help! Reply CliffStoll on February 24, 2015 at 2:56 pm Zooks – suddenly my reliable Filemaker – PayPal interface stopped working! I don’t know what I did … I don’t think I touched this area. Ver 1.0 This Filemaker line has a missing function. I don’t know what the function is, and I don’t know what happened to it! Set Variable [$PayPalResult; Value: (AE_PayPal_API_Config::Sandbox; AE_PayPalAPIConfig:APIUSERNAME; AE_PayPalAPIConfig:APIPassword; AE_PayPalAPIConfig:APISignature; “”; “”; $PayPal_Passed_Transaction_ID)] Many thanks for any help, hints, or pointers! -Cliff 2015-Feb-24 Reply Andrew Angell on February 25, 2015 at 12:19 am I’ve been adjusting the firewall on my server and I think it’s blocking some legitimate traffic to the web service that you’re hitting to load those. The XML file is located here. If you save that to your own server and update the FM solution to pull from that instead then it should load nicely for you. I’m going to be playing with this to get it resolved on my server, but I’m really not sure what rules I need to adjust yet, so I’m not sure how long it’ll be before I get it fixed. Reply CliffStoll on February 28, 2015 at 1:17 pm Aha! That explains the problem! Thank you! But now, I”m confused … sadly, I’m not much of Here’s the filemaker line in LoadFunctions: Set Variable [$LoadFunctionsResult; Value:PHP_LoadFunctionsFromURL(“http://www.angelleye.com/web-services/filemaker/phpx/PHPx_AE_PayPal.xml”)] I have created a file on my local windows machine (the same machine that I run Filemaker on. The file is located at c:\documents and settings … \AE_Functions.xml I then modified the filemaker script from “LoadFunctionsFromURL” to become “LoadFunctions” Now, $LoadFunctionsResult returns this error: 301 Invalid Package File This seems to be a problem in SmartPill, but I can’t seem to find much documentation on how SmartPill. I’m baffled. Reply Andrew Angell on February 28, 2015 at 8:30 pm Did you set it to PHP_LoadFunctions or just LoadFunctions..?? Reply CliffStoll on March 1, 2015 at 12:28 pm This is from LoadFunctions Set Variable[$LoadFunctionsResult; Value:PHP_LoadFunctions(“C:\Documents and Settings\Cliff Stoll\Desktop\AcmeInvoicesFM\PHP Files for Filemaker\AE_1.xml”)] (At minimum, I owe you a coffee for all your help, expertise, and kindess!) Andrew Angell on March 1, 2015 at 12:56 pm You may want to upload that file to your web server and then stick with the function it was using before but with your own URL. Would that work for you? Andrew Angell on March 1, 2015 at 12:57 pm Or were you saying that it’s working now the way you have it? CliffStoll on March 1, 2015 at 1:28 pm i think the problem may involve having & & instead of the & amp ; & amp format i’m working on it CliffStoll on March 1, 2015 at 1:51 pm Aha – I edited the local file so that all tags in the code are now in the format of ampersandy things instead of just & things. (I’m unable to post to this forum with exactly what I did, since the forum seems to interpret my use of ampersandy things as bad instructions, and then boots me off the forum!) At any rate, the filemaker PHP_LoadFunctions script step no longer returns an error! Yippee! But the system is not working – PayPal is not returning any information. I will continue to work on this. Sigh… -Cliff SUnday, around noon in Oaklnad CliffStoll on March 1, 2015 at 1:59 pm Oh – I should have said in the previous note: the is fixed — all the functions now appear in Filemaker. But the system is returning nothing after the call: PHPx_AE_PayPal_GetTransactionDetails( AE_PayPal_API_Config::Sandbox; AE_PayPal_API_Config::APIUsername; AE_PayPal_API_Config::APIPassword; AE_PayPal_API_Config::APISignature; “”; “”; $PayPal_Passed_Transaction_ID ) CliffStoll on March 1, 2015 at 2:25 pm Giving up. 1) The AE Library LoadFunctions seems to work properly, using PHP_LoadFunctions, and my local file which has been modified by Notepad++ so as to replace Java ampersandy thingies with xml formats. So I no longer see the error 301. All functions seem to have been loaded. That is, I do not see any lines in Filemaker. 2) THe function PHPx_AE_PayPal_GetTransactionDetails( xx-Sandbox; xx-APIUSername; xx-APIPassword; xx-Signature; … Transaction_ID ) returns nothing. I have checked that all variables are correct (ie, Sandbox is set to false, Username is exactly as it was a month ago, same with my password, and signature. I’m passing a valid transactionID. But the fuction returns nothing. *sigh* I’m going back to repairing a band saw. CliffStoll on March 1, 2015 at 5:54 pm no progress in the past few hours (fixed my band saw, however). I now see that several of my comments on here have been mangled because open brockets and ampersands cause my messages to drop words or whole lines, resulting in me looking like even more of an idiot than usual. Sigh. Just to set the matter straight; in my previous posting, the phrase “That is, I do not see any lines in Filemaker” should really read as ” That is, I do not see any open brocket function missing close brocket lines in Filemaker.” Reply Submit a Comment Cancel replyYour email address will not be published. Required fields are marked *Comment Name * Email * Website This site uses Akismet to reduce spam. Learn how your comment data is processed.