[Building Sakai] significance of hex USER_ID and placement

[D. Stuart Freeman]

On Fri, Oct 22, 2010 at 12:29:32PM -0700, bruceballou at olk12.com wrote:
>    Hello All,
>     
>    A question about the hex USER_ID number.
>     
>    I understand that it is a unique number for internal processing, but could
>    someone explain the significance of it's structure:
>     
>    6e6174d1-29af-46f5-acbb-5be0ac32ea8d
>     
>    The way I see this is 5 segments, consisting of 8h-4h-4h-4h-12h in each
>    USER_ID.

They're UUIDs, see
http://en.wikipedia.org/wiki/Universally_unique_identifier

>     
>    I am looking to load a lot of users through a MySQL using 2 statements,
>    one that updates SAKAI_USER and SAKAI_USER_ID_MAP. 
>     
>    I have found a way to create the unique hex number in an excel
>    spreadsheet, I output it to a csv file and load the data into the tables.
>     
>    I was told that by uploading users this way, a couple of things don't work
>    correctly, such as portfolios.
>     
>    I guess the base question is where else does this USER_ID number get put
>    that it used by some of the modules?
>     
>    Sorry so chatty, just want to give enough info for folks to process.
>     
>    Thanx,
>     
>    Bruce

> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"


-- 
D. Stuart Freeman
Georgia Institute of Technology
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101022/611c8bc0/attachment.bin