On Tue, Mar 9, 2010 at 5:38 AM, Olav Vitters <[email protected]> wrote:
I do not understand at which stage the data is supposed to be transferred from Paypal to www.gnome.org/friends/ At the time the payment is made to Paypal there is some type of API we can call. I don't know enough about it to explain it ... Stormy On Tue, Mar 9, 2010 at 5:38 AM, Olav Vitters <[email protected]> wrote: > On Mon, Mar 08, 2010 at 03:35:02PM -0700, Stormy Peters wrote: > > I'd like to automate adding the names to the Friends of GNOME page. > > (There's a lot of other thing about the process that I'd like to > > automate as well, if someone would like to help figure out how best to > > do that.) > > I've read attached, but it doesn't really go into detail. Yes, no > problem to have a database. What we're more concerned with is usage of > PHP. That is generally disliked. > > Especially mention of limited PHP experience.. then I fear the PHP > script won't take security enough into account. > > But the biggest thing which is lacking: How does www.gnome.org/friends/ > and Paypal connect? Intended as cronjob, called from Paypal when someone > makes a donation, something else? Really, the database part is the most > uninteresting bit. > > > I'm cc'ing a whole conversation here for background. > > Who uses that broken mailclient. This was very difficult to read. I've > fixed all the wrapping errors. > > > Basically, when someone makes a donation via paypal, we need to grab > > the "options" and if they opted to be recognized, we need to add their > > name to the list of donors. > > > > I can open a bugzilla request too but felt like I needed more info to > > be more concrete ... > > I do not understand at which stage the data is supposed to be > transferred from Paypal to www.gnome.org/friends/ > > Leaving the rest quoted as to make it easier for others to read. > > > ---------- Forwarded message ---------- > > From: Claus Schwarm <[email protected]> > > Date: Fri, Mar 5, 2010 at 4:03 PM > > Subject: Re: automating Friends of GNOME names on website > > To: "Jaap A. Haitsma" <[email protected]> > > Cc: Stormy Peters <[email protected]>, Rosanna Yuen <[email protected]> > > > > > > A text file reader/writer is just as easy to write as a database > > connection, IMHO. > > > > Anyway, it's the sysadmins' decision. They must approve of the > > solution. A database exists. > > > > But as I already said: This will break when we switch to Plone unless > > we keep using the current method for the /friends URL structure. > > > > Claus > > > > > > On Fri, 2010-03-05 at 22:47 +0100, Jaap A. Haitsma wrote: > > > I guess you could also write the names of the people who donated in a > > > text file and use that, but I'm not so sure how to do that in PHP as > > > my experience with it is quite limited. > > > > > > Jaap > > > > > > On Fri, Mar 5, 2010 at 22:35, Stormy Peters <[email protected]> wrote: > > > > What if we did something simpler and didn't worry about > > > > duplicates. We could use font size or color to denote different > > > > levels of sponsorship. > > > > > > > > And if they say "yes" to showing their name, just push their name > > > > on the top of the page. > > > > > > > > So it would look like: > > > > > > > > Friends of GNOME: > > > > > > > > Jaap A. Haitsma. Stormy Peters. Rosanna Yuen. Claus Schwarm. Joe > > > > Smith. Miguel Lopez. Marty Allison. Montse Villanova. ..... > > > > > > > > An alternative to using colors or font size or bold or italics > > > > would be to just put the level in parenthesis: > > > > > > > > Friends of GNOME: > > > > > > > > Jaap A. Haitsma (Philanthropist). Stormy Peters (Adopt a Hacker). > > > > Rosanna Yuen (Sponsor). Claus Schwarm (Friend). Joe Smith (Adopt a > > > > Hacker). Miguel Lopez (Sponsor). Marty Allison (Associate). Montse > > > > Villanova (Adopt a Hacker). ..... > > > > > > > > If people donated twice, their name would show up twice. > > > > > > > > Stormy > > > > > > > > On Fri, Mar 5, 2010 at 1:43 PM, Jaap A. Haitsma <[email protected]> > > > > wrote: > > > >> > > > >> Hi, > > > >> > > > >> The problem is clear to me. What is needed is access to a > > > >> database to store all the names and check if the person is > > > >> already in the database. I'm not sure how to get a database up > > > >> and running for this on the GNOME infrastructure. I think a MySQL > > > >> database is running but somebody should arrange access for it. > > > >> And I'm not really sure how handle security for this because the > > > >> source code is going to be public in git everybody would see > > > >> username password of the donation names database. Probably a > > > >> question for the sysadmin team. > > > >> > > > >> Jaap > > > >> > > > >> On Fri, Mar 5, 2010 at 16:19, Stormy Peters <[email protected]> > > > >> wrote: > > > >> > Jaap, Claus, > > > >> > > > > >> > I was thinking about sending this to the marketing list but > > > >> > thought I should check with you first. > > > >> > > > > >> > What do you think? I'm expressing clearly the problem? Is this > > > >> > something easy to do or will it require substantial work from > > > >> > someone? > > > >> > > > > >> > Thanks, > > > >> > > > > >> > Stormy > > > >> > > > > >> > Hi Marketing List, > > > >> > > > > >> > One of the things Rosanna and I have been working on with > > > >> > various other people is how to automate as much of the Friends > > > >> > of GNOME gift giving process as possible. > > > >> > > > > >> > Posting people's names on the website[1] is one option we could > > > >> > use help with. (It's an option they pick when they donate.) > > > >> > > > > >> > In the past we've done this by sorting in the spreadsheet. > > > >> > However, with Friends of GNOME subscriptions, that option is > > > >> > option #3 and Paypal only stores 2 options. So it's not > > > >> > possible to download the data from Paypal. > > > >> > > > > >> > Paypal suggested using their IPN to send a POST to a script on > > > >> > our site with all of the transaction data each time a > > > >> > transaction is made. > > > >> > > > > >> > Is there someone who could write a script that launches when > > > >> > someone pushes our donate button, checks to see if they want to > > > >> > be on the website, and if they do, adds their name to the > > > >> > website? > > > >> > > > > >> > Stormy > > > >> > > > > >> > P.S. I am manually going back through our records for 2009 to > > > >> > get everyone's name. > > > >> > > > > >> > [1] http://www.gnome.org/friends/previous-donors.html > > > >> > > > > > > > > > > > > _______________________________________________ > > gnome-infrastructure mailing list > > [email protected] > > http://mail.gnome.org/mailman/listinfo/gnome-infrastructure > > > -- > Regards, > Olav >
_______________________________________________ gnome-infrastructure mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-infrastructure
