Re: Fwd: automating Friends of GNOME names on website

[Olav Vitters <olav vitters nl>]

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 <clschwarm googlemail com>
> Date: Fri, Mar 5, 2010 at 4:03 PM
> Subject: Re: automating Friends of GNOME names on website
> To: "Jaap A. Haitsma" <jaap haitsma org>
> Cc: Stormy Peters <stormy gnome org>, Rosanna Yuen <zana gnome org>
> 
> 
> 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 <stormy gnome org> 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 <jaap haitsma org>
> > > 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 <stormy gnome org>
> > >> 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
> gnome-infrastructure gnome org
> http://mail.gnome.org/mailman/listinfo/gnome-infrastructure


-- 
Regards,
Olav