angelleye

Yes, after I got that scrambled test page I removed and re-installed FM Server, went through fresh deployment, and then the test page worked nicely. So then my other stuff started working, too.

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

View File PayPal Notify FileMaker Overview Get data from PayPal transactions pushed into FileMaker automatically, instantly when the transactions occur. No more wasting time with manual data entry from PayPal into FileMaker! Our FileMaker PayPal IPN solution connects directly to FileMaker Server hosted databases using FileMaker’s PHP API. This provides instant, seamless integration of PayPal IPN into FileMaker. FileMaker PayPal IPN Data Solution File A FileMaker database that stores all of the PayPal IPN data. This needs to be hosted on a FileMaker Server FileMaker PayPal IPN PHP Solution Files A PHP application that processes the PayPal IPN data and updates the FileMaker solution file accordingly. This needs to be hosted on a web server with PHP 5.3 or higher installed What Can I Do With It? The basic functionality of the solution is to automatically save data about any transaction that hits your PayPal account to your FileMaker system. What this does for you is opens the door to automate tasks that could potentially chewing hours, days, even weeks of time! With a couple of simple table relationships and FileMaker scripts, the possibilities are endless. Just a Few Examples Create new orders in your FileMaker system when payments are received in PayPal. Update the PayPal payment status of orders in your FileMaker system. Update FileMaker product / order details when an order is refunded. Trigger FileMaker scripts based on IPN transaction types or payment status. Flag orders where a customer has filed a dispute with PayPal. The best part is that this all happens automatically, instantly when the transaction hits PayPal! Submitter angelleye Submitted 01/17/2016 Category Solutions FM Version FM Version: 1

Our PayPal for FileMaker solution will get that done for you. It supports calls to DoDirectPayment via External Functions in FileMaker, so it would be very quick and easy for you.

Ah, yes, sorry. Just wasn't thinking straight there. I guess I'll probably just do it the way I always have. I just wish I could remember where it was somebody told me the better way. It was in a forum somewhere (here, experts exchange, stack overflow, etc.) and somebody else was asking about to setup a relationship the way they needed. I answered with the method I'm talking about here, where you create a "relationship field" that always has the value you're matching on. Somebody else then responded telling me that was no longer necessary because FM introduced a new feature, and it worked great, but now I can't find it. Doh!

Hmmm...I don't think that was it. I'm not looking to display related records within a portal on a layout. I'm looking to create an entirely separate layout that would display nothing but the filtered records. So I would end up with 3 table occurrences from the same transactions table: transactions, transactions_verified, and transactions_invalid. So then I could create a layout based on transactions_verified and it would only show the verified records. Again, I can get it done using a global field with the value I want to filter by, but there was a much more elegant way to get it done added in FM not many versions ago that somebody pointed out to me...which I can't remember now.

I have a table named transactions with a field named ipn_status. The status can be either "Verified" or "Invalid". I'd like to make separate table occurrences that will display only Verified or Invalid records. In the past I would do this by creating a global field in the table called something like relVerified, and I would just put the value "Verified" inside this field. Then I could create a new table occurrence of the same transactions table, and I could setup the relationship like transactions::ipn_status = transactions::relVerified. This would get me what I want. Not long ago, though, somebody pointed out to me that this is no longer necessary, and there is a better way to handle such a scenario. I can't for the life of me remember how to do it, though..?? Any information on this would be greatly appreciated. Thanks!

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!

Ah, I forgot about the test page, actually. Sure enough, something seems completely messed up. I've attached a screenshot of what I get when I run the test on this server. Any idea why that would be happening or how to resolve it? In the status area it shows green check marks for everything like all is well, but obviously that's not the case.

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.

I've got a FM solution that I distribute as a runtime. I have 2 accounts included with the runtime: admin and user. Our users use the user account, and the first time they sign in it has them set their own password. This all works fine. People forget their passwords, though, and the only answer I've had for them is to uninstall and re-install the software. Obviously, this is not ideal. I'm looking into this a little more now and I see there is a script step for resetting an account password. This looks nice, but we'd still have to be signed in to some other account in order to get access to the script, right? We could at least do a screen share with the person, log in as our admin user, and then reset it for them, but we can't guarantee 24x7 support, so that's not ideal either. Is there some other method I could use to make this work nicely for everybody involved? I was thinking it would be nice to hook the user account system up to the user's local computer instead of using the built in FM accounts. That way they could manage all their usernames and passwords on their operating system, and those would then work to sign in to FM. I'm not finding any information about anything like that, though. Any information on how I could handle this in a nice way would be greatly appreciated. Thanks!

I've been developing with FileMaker for a long time and I've always specialized in eBay and PayPal integration. I've got a pretty good reputation in the PayPal community (I got the star developer award in 2008, 2009, and 2011) and I've finally taken the time to develop a set of custom functions for FileMaker that give you direct access to PayPal's API's. I wish I would have done this years ago as it's already saved me loads of time. Get it Now The solution consists of a simple FileMaker database that when loaded, populates your External Functions with a bunch of custom functions that coincide with PayPal's API's. Just like any other function in FileMaker, all you have to do is populate the function parameters and it will take care of the rest for you. API calls included so far are: AddressVerify BillOutstandingAmount CreateRecurringPaymentsProfile DoAuthorization DoCapture DoDirectPayment DoNonReferencedCredit DoReauthorization DoReferenceTransaction DoVoid GetBalance GetBillingAgreementCustomerDetails GetRecurringPaymentsProfileDetails GetTransactionDetails ManagePendingTransactionStatus ManageRecurringPaymentsProfileStatus MassPay RefundTransaction TransactionSearch UpdateRecurringPaymentsProfile I will be adding more API's very soon to cover the rest of their web services, including Adaptive Payments. Right now all I have is the quick intro video on how it's used, but I'll be adding more detailed videos and documentation in the near future. Feedback is appreciated!

I just released a set of custom functions as a FileMaker PayPal Plugin that I think you'll find interesting. It provides direct access to their web service API's via FileMaker custom functions. It's already saved me loads of time and I'm sure you'll enjoy it, too. I'll be adding more documentation and training videos soon but it's pretty straight forward and it works great as it is now. Feedback appreciated!

I just finished up and released a set of custom functions as a PayPal plugin for FileMaker that provides direct access to their web service API's from within FileMaker. It's already saved me a boat load of time with PayPal clients and I figure I might as well make it available to other FileMaker developers as well. Feedback appreciated!

I've just released a PayPal plugin for FileMaker (more of a set of custom functions, really) that allows you to work directly with PayPal's API's from within FileMaker using custom functions just like any other functions you use within FM. It's very simple to use and I'm extremely happy to have it done myself just because of the time it's already saved me. I don't have much documentation yet, but it's pretty straight forward and it works great. I do have an overview video and I'm happy to answer any questions you might have about it. Feedback appreciated!

Speaking of PayPal web services and FileMaker, I just recently released a FileMaker PayPal Plugin that work directly with PayPal's API's. Makes it as simple as filling in function parameters to work directly with PayPal's web services (way beyond standard buttons)

Turns out the v3 updater includes the patch for the runtime files. Apparently applying that patch to v3 is what was causing my issue. I removed and reinstalled FM and then did the v3 updater only. Now when I do my runtime it seems to be ok.

I've got a FileMaker solution I've distributed as a runtime for quite some time now. I've never had any issues up until I started working with FM11. Seems like no matter what I try and I can't get things to work now. I'm on Windows 7 Ultimate running FileMaker Pro Advanced 11.0v3 and I've also followed the instructions for the runtime library update here: http://help.filemaker.com/app/answers/detail/a_id/7684/~/filemaker-pro-11-advanced-runtime-library-update. So then I open up developer utilities and create my runtime solution by simply adding my FM solution and then choosing the option to Create Runtime solution. It creates my runtime solution for me and I end up with my collection of files as expected. At this point, though, I try to run the executable and I end up with the attached screenshot error... "The primary file "DEBUG" cannot be found and is required for this application." Any information on this issue would be greatly appreciated. Thanks!

I've got a FM solution that I've been developing over the past few years. I wrap it up into a runtime and I distribute it to both Windows and Mac users, which has always worked great for me. I've released a few updated versions of the software and I've got people on all versions of Windows (98, XP, Vista, 7) using it without any problems. On Windows I always create the runtime solution and then I would use InstallShield to create an actual installer. Always worked great before (and the previous version still installs just fine.) I noticed that after installing the software now with my latest release, the first time I open it up when I'm asked to change my password I end up with an error message that the file cannot be modified. I'm forced to go into my /Program Files/software_name/ folder and manually add modify rights to the Users account on the machine. Then it works fine. At first, I thought it was InstallShield giving me issues but then I realized that even if I wrap the runtime files into a zip file and extract to Program Files it looses the Modify rights on the Users account. Then I even applied the modify rights to the software folder on my desktop, then copied and pasted into Program Files, and it lost the rights again. So then I'm thinking, ok, that must be a Windows 7 thing or something, however, the previous version of the same FM solution that was wrapped in a runtime never had this problem on Windows 7 or any other version. The ONLY thing I can think of that's different is that I'm using FileMaker Pro 11 now instead of 9 or 10 like I was when I did this previously with the same solution. Is there anything that changed in FM11 that would cause runtimes to act this way on Windows? I just can't think of what would be causing this and it's driving me crazy. Any information on what could be causing this and possible solutions would be greatly appreciated. Thanks!

I've got a Filemaker database connected to MySQL using ESS. I've got a basic layout in FileMaker that simply displays the MySQL data and allows me to edit it accordingly. For some reason, though, any values I place in text fields from within this FM layout get chopped down to the first character that I placed. The MySQL database is using varchar field types with 250 char maxes. Updating records directly in MySQL works just fine. In FM, again, it's trimming all of the text fields to a single character. the number fields are just fine. I've never had this problem and I've used ESS quite a bit so I'm completely stumped. Any information on this would be greatly appreciated. thanks!

I'm running FileMaker Server Advanced 11 and connecting to it from FMP 11 clients. A few days ago something very strange started happening. I can't seem to get into Define Fields (manage -> database) from Mac clients but I can from Windows clients. Here's what's been going on... We've had FMSA running on Windows Server 2003 for some time now. We had upgraded it to 11 when it came out and weren't having any issues other than sometimes it just seemed pretty slow. Well, here lately my client has been complaining that he can't into Manage -> Database on some of his files. I was able to confirm this at his location and I also cannot get into that area on my own Macbook from any location, on-site or remote. When I open up Windows in a VM, though, and connect to FM from it I can get into it without any problems at all. It actually seems to run quite a bit quicker in general, too. Well, my client decided he wanted to go ahead try out and Xserve instead of the Windows server. I went in yesterday and installed FMSA 11 on an Xserve with OS X 10.5, dual quad core xeons, and 16gb ram. Installation went smoothly and I fired up all of the databases on this new server hoping that many of our issues would be solved. They're not. In fact it seems even worse. We still can't get into Define Fields on any Mac machines on or off location. Windows machines still work fine, and in fact, still seem to run a lot faster than Macs in general. The whole thing seems quite a bit slower in general than when it was on the Win2k3 machine with a single CPU and only 2GB ram. This just doesn't make sense to me and my client is getting frustrated. I'd appreciate any information I can get to try and troubleshoot these issues. Thanks!

Yup, I always close down files and back them up before I move them around. What it came down to was the fmsadmin user not being added to the files when I copied them over. All I had to do was add that to the security for all of the FM files and they loaded up just fine. I've never had to do anything like that on Windows servers, though. I've always just moved the files over and loaded them. I guess the permissions just differ enough that OSX wasn't able to automatically set that. Anyway, thanks for the response!

I'm currently running FileMaker Server Advanced 11 on Windows Server 2003. We're trying to move to an X-Server. I've got OS X 10.5 installed and FileMaker 11 Server Advanced along with it. All of that went smoothly. I then closed down all of the files on the Windows server and proceeded to copy them over the network to my new server. They show up in my new FM admin as expected, but when I try and open them nothing happens. Nothing. No disk activity. The status doesn't change. No spinning wheel. Nothing. I try open all, nothing. I try to open 1 at a time. Nothing. The sample file opens and closes just fine. Just not the ones I copied over. Any information on why this might be happening would be greatly appreciated. Thanks!