Martha, Thanks for the tip on the DB table and field!
Yamil -------------------------------- Yamil Suarez, MCS Associate Director of Library Systems & Web Development Stan Getz Library Berklee College of Music 1140 Boylston St Boston, MA 02215 ysua...@berklee.edu 617-747-2617 On Fri, May 12, 2017 at 1:26 PM, Martha Driscoll <drisc...@noblenet.org> wrote: > Hi Yamil, > > Evergreen stores the Stripe approval code in > money.credit_card_payment.approval_code. > You will have multiple rows matching a given approval_code if the patron > paid for several charges. Stripe only records the lump sum paid under the > approval_code. > > Martha Driscoll > Systems Manager > North of Boston Library Exchange > Danvers, Massachusettswww.noblenet.org > > On 5/12/2017 1:04 PM, Yamil Suarez wrote: > > Terran or others, > > Thanks for the info and feedback. You are making me realize that I am > wondering about a couple separate things about Stripe use in Evergreen. > > First one, is figuring if patrons can be emailed a receipt from either > Stripe or EG if they paid a bill. Not sure if the EG Stripe implementation > supports this. This just as a convenience to the patron, and apparently if > Stripe get the patron email it will send the patron a receipt email. Though > I know the EG patron record will keep track of past payments, and library > staff should be able to look that up (maybe patrons too?). > > My second question is that I would like to see at at least one bit of > patron or transaction related info be sent to Stripe, just so if I need to > troubleshoot a payment I can tell transactions apart on Stripe.com. Right > now on the Stipe.com site I only see a transaction cost. Though maybe there > is a Stripe.com transaction number that is stored in EG so I can reference > each other? I checked on the EG staff client by looking at one of my test > Stripe payments, and did not seem to see one. Though it could be in the EG > database. > > Does anyone have any comments on suggestions based on my questions? > > Thanks in advance, > Yamil > > > > > On Fri, May 12, 2017 at 10:16 AM Terran McCanna < > tmcca...@georgialibraries.org> wrote: > >> Some of our libraries are using Stripe but we're not doing anything >> that's not built in. Interesting idea, but I wonder if it would be better >> to send the email through an action trigger notification instead so that it >> could be for any type of payment and without passing any extra information >> to an outside source? >> >> Terran McCanna >> PINES Program Manager >> Georgia Public Library Service >> 1800 Century Place, Suite 150 >> Atlanta, GA 30345 >> 404-235-7138 <%28404%29%20235-7138> >> tmcca...@georgialibraries.org >> >> >> On Fri, May 12, 2017 at 10:00 AM, Yamil Suarez <ysua...@berklee.edu> >> wrote: >> >>> Good Morning, >>> >>> To anyone using Stripe payments in EG, have you customized the relevant >>> code to send the patron email address to Stripe, so then Stripe can send >>> the patron a receipt email after payment? >>> >>> I am on EG 2.9 so this might be addressed in a later version of EG. Just >>> wondering if anyone has explored sending purposely to Stripe anty >>> additional patron metadata. We are also thinking of sending just the number >>> of bills paid in a particular Stripe transaction. >>> >>> Thanks in advance, >>> Yamil >>> >>> >>> >>> >>> -------------------------------- >>> >>> Yamil Suarez, MCS >>> Associate Director of Library Systems & Web Development >>> >>> Stan Getz Library >>> Berklee College of Music >>> 1140 Boylston St >>> Boston, MA 02215 >>> >>> ysua...@berklee.edu >>> 617-747-2617 <%28617%29%20747-2617> >>> >> >> > > > ------------------------------ > [image: Avast logo] <https://www.avast.com/antivirus> > > This email has been checked for viruses by Avast antivirus software. > www.avast.com <https://www.avast.com/antivirus> > >