I am going to be inserting my own users via a CSV file and noticed that there is an init and a mail field which both seem to have the same email address. I'm wondering if I fill in both and also if there is anything else in particular I should watch out for.

Thanks

Comments

yanger’s picture

Did you ever successfully do this? :)

---------------------------
yanger

sangamreddi’s picture

you can import users with user import module. Although i haven't tested it. http://drupal.org/node/31940

Though its needs cvs file, format may be diffrent.

Sunny                      
www.gleez.com | www.sandeepone.com

yarozar’s picture

I'm also wondering what is the purpose of 'init' field in users table and how it's purpose differs from 'mail' field. Any idea?

P.S.: Is there somewhere Drupal's database schema description?

sangamreddi’s picture

From my obervations, i found the init is being used at first time, mean during register it stores the email and when you update the email, the change is not being reflected in init. This is what i cna say and I dont know whats the use of init field and why it stores the email again there.

Sunny                      
www.gleez.com | www.sandeepone.com

sepeck’s picture

Remember that you can log on with an affiliate id, like @drupal.org. So looking in more detail at mine, init is the intial login id, mail is what actually holds the mail that was supplie by the user. So for email, use email address. Also keep in mind, you need a working email address if you are creating an account that sends your passwor/link login. SO init seems to store that even if you change it later in mail.

This is merely guess and speculation.

-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

yarozar’s picture

Thank for your comments guys. I suspected something like that.

Are there Drupal's database structure explanation somewhere?

sangamreddi’s picture

I thought soemthing of that kind but i didnt test it. Anyway thanks for the explanation and saving my time too.

Sunny                      
www.gleez.com | www.sandeepone.com

deumatasha’s picture

This was very enlightening guys, thank you so much