Hi GNOME Infrastructure team, 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'm cc'ing a whole conversation here for background. 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 ... Thanks in advance, Stormy ---------- 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
