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.
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!!.
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.
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!!
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).
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.
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!!
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.
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.
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!)
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?
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…
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
)
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.
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.”
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 !!
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.
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!!
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).
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.
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!!
Are you talking about the invoices file I use in my demo videos? That should be included with the plugin download. Is it not??
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: wenliangz@gmail.com? Thank you!!
I emailed it to you.
it’s so nice of you! Such a quick help!
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
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.
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.
Did you set it to PHP_LoadFunctions or just LoadFunctions..??
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!)
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?
Or were you saying that it’s working now the way you have it?
i think the problem may involve having & &
instead of
the & amp ; & amp format
i’m working on it
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
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
)
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.
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.”