Capturing data in Drupal 6.22 and export into database

Events happening in the community are now at Drupal community events on www.drupal.org.
Anonymous's picture
Posted by Anonymous on July 15, 2011 at 2:14pm

Hi all,

I recently accepted a position with a not-profit organization as the Website Coordinator. One of my responsibilities involves overseeing the organization's web properties. Since they have been bringing me up to speed, the organization is working with an outside vendor on four microsites that will be developed using Drupal 6.22.

What we are looking to do is capture the data when constituents sign up for the eNewsletters (first name, last name, email address, & zip code) and export the data (which will be mapped) into Sphere and/or Raiser's Edge.

Since I don't have a database background, I would like to know what are the best practices when it comes to Drupal database and mapping the data to export into Sphere and/or Raiser's Edge?

Categories: , , , ,

Comments

Take some time and search

Posted by bleen on July 15, 2011 at 10:05pm
bleen's picture

Take some time and search drupal.org to see if there are any modules that already exist specifically for Sphere/Raisers Edge.

If there arent any, you have three options:
1) perhaps you can use the services module to connect up your data with one of those services
2) you can create a module
3) (simplest, but least automated) use the webform module. This will help you collect the data and you can pretty easily get it out of the DB as a CSV (or whatever) ... also this integrates well with rules so you can trigger some things.

Thanks...

Posted by oacruz77 (not verified) on July 20, 2011 at 3:38pm
oacruz77's picture

Seems like option three will be the route we will take and provide the specifications to the vendor in terms of how we want the data to be formatted.

Are Blackbaud products a given?

Posted by fathershawn on July 16, 2011 at 1:08pm
fathershawn's picture

If they are not committed to Blackbaud's expensive, proprietary solutions then consider CiviCRM. It interfaces directly with Drupal and is FSF's recommended solution for non-profits....

Drupaling in NYC since 2009!

Thank you

Posted by oacruz77 (not verified) on July 20, 2011 at 3:41pm
oacruz77's picture

We have two years remaining with Blackbaud. I looked into CiviCRM and suggested to my manager that this would be something to look into should we migrate the organizational site from BlackBaud to Drupal/CiviCRM.

I am not crazy about BlackBaud and have my own issues when it comes to the services they provide, particularly the slowness of their CMS once its afternoon.