[Imc-bookkeeper] can now do custom auto-response to Paypal payments! got IPN working for UCIMC, Bike Project, etc. [was: [UCIMC-Tech] Re: IMC membership - paypal follow-up]

[Barry Isralewitz]

Hello,
> On Wed, Jul 16, 2008 at 10:55 AM, Nicole Pion <nicole.pion at gmail.com> wrote:
> 
> > HI everyone,
> > As Jay mentioned, I'm happy to do this.  This afternoon, I am going to
> > introduce myself at the Bike Project open hours, so if there is someone
> > there who has a moment to chat with me about what you are looking for that
> > would be great.  That said, I can also coordinate with the group over email,
> > since it seems pretty straightforward.  Will this be specific to the Bike
> > Project or more generally introduce members to the IMC?
> > I should be able to get something out to you all by tomorrow.
> > Nicole
>
On Wed, Jul 16, 2008 at 07:36:42PM -0600, Jay Schubert wrote:
> Nicole,
> 
> My understanding is that something is needed generally for the whole IMC.
> 
> Thanks,
> Jay
> 

   Welcome to town, Nicole!  Looking forward to meet you soon.  Hope the
following isn't too hard to follow; you are welcome to call my cell (217)
419-4061 to discuss any time -- except for tomorrow, I'll be out of town on a
canoe trip.  Back by  Friday (July 18).


Among the events Paypal sends notification for are:
 New Subscriptons
 Subscription renewals
 Subscription expirations
 Subscription cancellations.

  To reply for UCIMC membership actions, I'd imagine you'd want different
letters for each case.  

You may want to echo much of the specific information about the transaction
back to the recipient.  I copied below the information which my test script
provides in order to give you a sense of the sort of information avaiable.  As
you can see, not all fields are provided from paypal for all transactions.

How about you write your letter in this style, 
==========
Dear $First_name $Last_name,

  Thanks for joining UCIMC.  Your subscription info is
Subscription Date: $Subscr_date
Subscription#  $Subscr_id 

    Love,

    UCIMC
=========
(that is, mix,  into each of your form letters' text, some data-field names
from the below examples.  Use the code of putting a dollar-sign ('$') before
each data-field name) This will help me use the text for automatic output.  If
this is eventually done with the "Civi-CRM" software instead of home-made
scripts, no effort lost, the same data-fields will be available. 
   
Here's the transaction info from test scripts. Again, just pasting this to give
you an idea of the sort of data you have to work with.

A subscription sign-up notification (note no money mentioned outside of user-set titles)
===============================
Item_name = The Bike Project - Annual Membership Subscription ($00.07/yr., test
+rate);
Item_number = 2000-0023-test2;
Address_name = Barry Isralewitz;
 Address_street = 305 W. Park Street, Apt. 1;
 Address_city= Urbana; Address_state = IL; Address_zip = 61801;
Contact_phone = ;
Custom = ;
Business = imc-paypal at ucimc.org; (Note: this is a Paypal bug, for Bike Project
stuff this should be thebikeproject at gmail.com.  Paypal says they're trying to
fix]
Tax = ;
Memo = ;
Payment_date = ;
Txn_id = ;
Parent_txn_id = ;

Subscription-only Info
========================
Txn_type = subscr_signup;
Subscr_date = 11:05:15 Jul 03, 2008 PDT;
Subscr_effective = ;
Period3 = 1 Y;
Amount3 = 0.07;
Mc_amount3 = 0.07;
Mc_currency =USD;
Recurring = 1;
Reattempt = 1;
Retry_at = ;
Recur_times = ;
Username = pp-shuntbig;
Password = REDACTED (although is encrytped, and only has power to alter subscription, not any other Paypal transaction);
Subscr_id = S-7XH02761GG070245W;
========================
First_name = Barry; Last_name = Isralewitz;
Payer_email = isralewi at uiuc.edu; Payment_amount = USD; Country = United States
+(US)
Payment_status =
Receiver_email = imc-paypal at ucimc.org
=============================

...and here the associated and distinct payment notification.  Note that this
one _does_ mention money in the Paypal-generated fields.

=======================
Item_name = The Bike Project - Annual Membership Subscription ($00.07/yr., test
+rate);
Item_number = 2000-0023-test2;
Address_name = Barry Isralewitz;
 Address_street = 305 W. Park Street, Apt. 1;
 Address_city= Urbana; Address_state = IL; Address_zip = 61801;
Contact_phone = ;
Custom = ;

Business = imc-paypal at ucimc.org;
Tax = ;
Memo = ;
Payment_date = 11:05:18 Jul 03, 2008 PDT;
Txn_id = 6H923329JU240872V;
Parent_txn_id = ;

Subscription-only Info
========================
Txn_type = subscr_payment;
Subscr_date = ;
Subscr_effective = ;
Period3 = ;
Amount3 = ;
Mc_amount3 = ;
Mc_currency =USD;
Recurring = ;
Reattempt = ;
Retry_at = ;
Recur_times = ;
Username = pp-shuntbig;
Password = REDACTED; 
Subscr_id = S-7XH02761GG070245W;
========================
First_name = Barry; Last_name = Isralewitz;
Payer_email = isralewi at uiuc.edu; Payment_amount = 0.07USD; Country = United
+States (US)
Payment_status = Completed
Receiver_email = imc-paypal at ucimc.org
==============================================


   

              Cheers,

              Barry
-- 
Barry Isralewitz, Ph. D.   Theoretical and Computational Biophysics Group, UIUC
Beckman 3043    Office Phone: (217) 244-1612   Home Phone: (217) 337-6364
email: barryi at ks.uiuc.edu      http://www.ks.uiuc.edu/~barryi