Uploading user list from existing DB to create MPL

[GoogleCodeExporter]

Feature Name: Uploading user list

What it will do:
Take as input a CSV file with the following fields:

Name, Roll Number, Year of Graduation

and create defunct[change this adjective to mean users without emails]
users in the system with unique usernames, and blank emails [or a custom,
error-handling email].

Original issue reported on code.google.com by animesh on 24 Sep 2008 at 8:36

[GoogleCodeExporter]

Original comment by animesh on 24 Sep 2008 at 8:51

• Added labels: Milestone-Release1.0

[GoogleCodeExporter]

Original comment by animesh on 24 Sep 2008 at 8:53

• Added labels: Milestone-V2.1-Saamne
• Removed labels: Milestone-Release1.0

[GoogleCodeExporter]

For the table, add two more columns -- Branch, and Degree obtained.

Original comment by animesh on 5 Oct 2008 at 8:44

[GoogleCodeExporter]

Kindly correct some of my assumptions below -

We have the following information about each person in MPL as a CSV

- Name (FIRST + Optional MIDDLE and LAST)
- Roll No
- YY - Year of Graduation
- BBB - Branch Codes (branch names?)
- N types of Degrees (to be mapped to Degree Codes?)

For each person, we'll create a blocked / disabled account in Drupal.

Map users registered on ITBHUGlobal.org to MPL, add details(passwd, email, 
roles etc) 
and activate them.

Do we have any other databases to import users?

Original comment by jindal.s...@gmail.com on 5 Oct 2008 at 5:17

[GoogleCodeExporter]

Your assumptions about columns are correct. However, nothing specific to 
ITBHUGlobal.org

Current task simply involves creating the ability to add users from a CSV file.

Yes, we do have a whole bunch of CSV files from univ. records.

The task of importing users from itbhuglobal.org into it is another issue :).

Original comment by animesh on 5 Oct 2008 at 5:21

[GoogleCodeExporter]

There can be two approaches here -

(a) A simple script / program, that directly manipulates Drupal's mysql tables

(b) A Drupal module, which can be utilized by an authorized user to import 
users from 
a CSV file.

Given that importing MPL is one time job, (a) would be way more simpler.

Original comment by jindal.s...@gmail.com on 5 Oct 2008 at 5:29

[GoogleCodeExporter]

The MPL will need to be updated every year also, as new students graduate etc.
I don't think the drupal module route will be much more difficult. Use standard 
drupal code for

- check if user is admin
- read data of a file
- add users with certain properties

Original comment by animesh on 5 Oct 2008 at 6:27