PayPal Notify FileMaker Install and Setup Guide

• Open the /_assets/PayPal_IPN.fmp12 database file that was included with your download in FileMaker Pro.
  • Username: Admin
  • Password:  Pr0t3ct!  (That is a zero in the middle)

Login to the PayPal IPN FileMaker database.

• Go to File -> Manage -> Security
• Enter the same username and password again to enter the user accounts section.

Enter the admin credentials for the PayPal IPN database to manager user accounts.

• Double click the Admin account to open it.
• Click the Change button for the Password, and enter your own value.
• Click the Set Password Button, and then click OK.

Change the password for the admin user account.

• Go back to File -> Manage -> Security again.
• Login again with the admin account and your new password that you just set.
• Next to Privilege Set, click the Edit button.
• Scroll to the bottom of the Extended Privileges list.
• Check the box for Access via PHP Web Publishing.
• Click OK three times to commit your changes (If prompted, enter your admin account credentials once more to verify the changes.)

Enable PHP Web Publishing for the user account.

• Go to File -> Sharing -> Upload to FileMaker Server.
• Accept the prompt to close the file.
• Choose your FileMaker Server from the Hosts list.
• Enter the FileMaker Server credentials on the right, and then click Next.
• Review the file you will be uploading, and click the Upload button to send the database to your FileMaker server.
• When completed, leave the box checked to open the file in Pro, and click Done.

Upload the PayPal IPN database file to FileMaker Server.

NOTE: If you would rather, you can also upload the PayPal IPN database file manually.

• Open the file /includes/config-sample.php
• Follow the instructions in the code comments to fill out each section of the config file with your proper values.
• Save the file as config.php in the /includes directory next to the config-sample.php file.

PHP snippet from the PayPal IPN FileMaker PHP app config file.

• Upload the PHP application files to a directory on your web server where you would like it to run.
  • This can be done using an FTP client, a web-based cPanel, or SSH connection.
• Remember the location where you uploaded the application because this will be used as your IPN URL in your PayPal account settings.
  • For example, if you uploaded the application to /paypal/ipn/ on your server, your IPN URL would be http://www.yourdomain.com/paypal/ipn/

• Load the /test directory of the PHP application in a browser.
  • For example, if the application is installed at http://www.yourdomain.com/paypal/php/ you would load http://www.yourdomain.com/paypal/php/test/ to run the connection test.
• The test page should simply list the FileMaker databases that are available to the PHP application.
  • If you do not see the PayPal_IPN database in this list you need to double check that you got the PHP Web Publishing privilege (FMPHP) enabled for the user account credentials you added to the PHP config file.

FileMaker Server databases with FMPHP privilege added are listed by the test.

• Login to http://developer.paypal.com using your PayPal account credentials.
  • If you have not ever done this may be asked a few questions while it creates your PayPal Developer account.  This is necessary to use the developer tools provided here.
• Click Dashboard at the top of the page.
• Click IPN Simulator under the Sandbox section in the menu on the left.
• Enter your IPN URL in the “IPN Handler URL” field.
• Choose an IPN type to test from the “Transaction Type” drop-down box.
• At the bottom of the form, click the Send button to simulate this IPN with your new IPN solution.
• Now move back to FileMaker Pro where you have the PayPal IPN solution file open.
  • Switch to the ipn_raw layout, and you should now see the IPN data that you simulated shown here.

Data showing in FileMaker from the PayPal IPN Simulator.

• Follow the instructions provided here for configuring IPN in your live PayPal account.
• The URL you will use depends on the install location of the PHP application on your web server.
  • For example, if you uploaded the PHP solution files to /paypal/ipn/ on your server, then your URL would be http://www.yourdomain.com/paypal/ipn/

PayPal IPN configuration within the PayPal account.