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
