Half a chance for a Cameroonian orphanage

When we were in Cameroon in 2007 we became friends with Hannah, an English girl who was working at HOTPEC - an orphanage just outside Buea.

Hev and Hannah with some of the HOTPEC children

HOTPEC is an amazing place, there are so many kids, crammed into cramped and crumbling dormitories. It's not a miserable place though, the kids are buzzing with energy and there's a great atmosphere about the place. I had a great time playing football with the kids there. We saw many amazing things while we were in Cameroon, but our visit to HOTPEC was easily the most moving.

Hannah emailed us today to say that HOTPEC has been given the opportunity to take part in the Global Giving global open challenge.

achiever, our little struggler...

What this means is that for a limited time (until December 31st) HOTPEC has an online donation page for their dormitory building project. This is a great opportunity for them, as collecting online donations is extremely challenging for Cameroonian charities. The technical and bureaucratic challenges are such that for most small charities, it is simply not possible, cutting them off from a source of support that could keep their projects running.

Which is why the challenge aspect of this opportunity is so important: HOTPEC has to raise $4,000 from 50 donors by December 31st in order to earn a permanent spot on GlobalGiving. If they achieve this, they will have established an important source of income that will enable them to continue helping Cameroonian orphans as they have been.

This is a fantastic opportunity for HOTPEC to take a step towards sustainability. Please will you help? Any amount will do, the number of donors is as important as the amount raised.

One of the children showing off some chillis from the HOTPEC farm

Your £1 donation really could make the difference:

please contribute to building an orphanage dormitory

Also, please tweet this, put it on Facebook, etc.

permalink for this entry: http://www.josephbloggs.com/entry.php?entry_id=1016

HOTPEC donation page: http://www.globalgiving.org/projects/hotpec-orphanage-dormitory-project/

let's get HOTPEC over the line!

Update!

We're making progress - we've crossed the half-way line! Less than $2000 to go now!

I also appear to have agreed to come to work dressed as an elf on the Friday before Christmas IF the target is reached by then. So go on, tell your friends,your efforts could provide food and shelter for a Cameroonian orphan and make me look an idiot. What better way to spend your time/money...

comment on this entry permanent link to this entry

Porting blog posts and comments into Drupal

I'm trying to work out how to port the content of an existing blog (this one) into Drupal. The problem I have is that this blog isn't currently running on an established blogging platform (Blogger, Wordpress, Moveable type, etc...) that someone may have written an import module for. Rather this blog is run on a MySQL and php monstrosity I hacked together myself some years ago.

I guess the good news is that I understand the structure of the existing data and have complete control over it.

The bad news is that I'm not sure how how to do it.

What I'd like to do is take all my existing blog posts which basically consist of a title, body and published date (there is author information as well, but this isn't vital) and put them into Drupal article nodes (I'm using Drupal 7). Additionally (and this is where it may get a bit more tricky) I'd like to bring the comments in as well, such that comments (body, author, submitted data) gets put into Drupal article comments.

As I see it, there are three ways to go about this:

  1. export all my data in a format that can be imported into Drupal, e.g. as an RSS feed which can be consumed by the Drupal Feeds module. This seems do-able but I can't see how to set comments fields as targets in a feed importer.

  2. Find some way for Drupal to connect to my MYSQL database and grab to data directly.

  3. Tinker around in SQL to grab the data from my database and stick into the Drupal database.

I favour option one, but that's only because it's the only one I have any experience with...

Does anyone have any bright ideas how I might go about this?

If so, please leave a comment and I promise to port the comment over to Drupal, if I can...

comment on this entry permanent link to this entry

There's one comment for this entry

Maybe a combo of options 1 and 3?

Use feeds to add the blog post data in, and add the original entry_id's as an extra field in the 'article' nodes to give a unique id for entries between the two db's, then do some SQL Wrangling outside of Drupal to push in the comment data directly into the appropriate table(s)?

comment left by Miriam Umm Ibni

Photo Chronology 2010

Blimey, doesn't time fly: it's that time of year again, photo chronology day, so another opportunity to place a little marker in time as it whizzes by.

We were on Holiday in Croatia for photo day this year (which was nice), but much more importantly, we've got a whole new member of the family to include this year (which may account for the almost total lack of blog posts in the last year...) So presenting:

Photo chronology, now with 50% extra!

To celebrate the expansion of the project (oh, and the family [waves hand dismissively...]) I also created a little documentary extra:

Marcie: The Making of...

comment on this entry permanent link to this entry

"There hasn't been a decent World Cup since 1986"

Alex Ferguson, you miserable, blinkered old duffer...

comment on this entry permanent link to this entry

I'm not bitter, but...

All Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce.

All Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce.

All Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce, all Sepp Blatter and no video replay makes World Cup a farce.

comment on this entry permanent link to this entry

Previously: