> ---------- 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
> > >> >
> > >
> > >
