CiviCRM Community Forums (archive)

Hello All,

On our society aspiring members usually first go to one of the public events. They then sign up, and only then do they get access to the "members only" part of our website. I am now rebuilding our website using Drupal and CiviCRM, and I'm aiming for the following:
- Interested person visits the public part of our site (as anonymous user from the point of view of Drupal) and signs up for a public event. We collect some data, this becomes a contact in CiviCRM.
- When this person decides to become a member our secretary updates the membership status in the contact from "aspiring" to "full", enters some more info about the member, and automagically the following should happen:
    - A Drupal user is generate for this person, the uid is automatically generated from the first and last name.
    - A first password is generated and sent out.
    - A bill is sent out.

It's especially this creating a drupal user automatically that I am looking for. How do I this?

This might get you part-way there....

If your membership secretary uses the Drupal Administer >> Add User form and enters the same email address as the existing "aspiring" contact - then Drupal will create the user record (and can email their user info to them). AND CiviCRM will link the new user to the existing contact record.

So the CiviCRM contact data is linked to the Drupal users database on the email address field? That's interesting.
i was myself thinking more along the lines of soem kind of batch that just manipulates the mysql tables.