By mirko on

Hi,

I am currently working on this Drupal website for a small city governement in my area and I have a problem, they are using an Access database to handle the list of societies in the area and they want to be able to use it to update the website.

Is there anyway that I can do this by integrating it directly to Drupal? Otherwise do you know any other scripts that I could use for this?

Thanks

⋅ Categories: Drupal 4.7.x

Comments

sepeck’s picture

sepeck commented

Export the database from the Access database into a csv file and then use CCK to build node types for it. Use import module to import the data into the database. Use Views to display and sort the data.

No more Access database licensing issues. Integrated site. Central place to update information on Societies.

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide

dgeilhufe@yahoo.com’s picture

dgeilhufe@yahoo.com commented

And they could maintain their list of societies within CiviCRM, accessible via the website. CiviCRM will handle most of the things I imagine they use their access database for.

CiviCRM Listings would generate the list of societies on the website directly from the database.

David Geilhufe
Managing Partner, CivicSpace

green monkey’s picture

green monkey commented

David
Thanks for this post, I've been searching this forum and the Civicrm threads for how to import additional information from Drupal into Civicrm - namely Address info fron any source, CCK, Profile, or Bio

I think your reference should help

mirko’s picture

mirko commented

Thanks to both for solutions, I will try both solutions on my testsite ;)
I will also try with flexinode and views I guess, since I am more familiar with it...

@steven: I really like your signature

Muslim guy’s picture

Muslim guy commented

104,000 User Profile from MS SQL .. thanks Sepeck and Mirko for asking :) So it can be done - but is CCK a must-have or can I like import user info into IMAGE-PRODUCT for a large scale E-COmmerce?