Forum OpenACS Q&A: OpenACS tables description

Collapse
1: OpenACS tables description
Posted by Min Chen on 02/28/02 10:04 PM
Is there any document about the OpenACS tables description?

I want to migrate data from an existing FileMaker application to a new
one based on OpenACS.  This includes users accounts, which means that
I have to create new users accounts on OpenACS for every user I got in
the old application.  But I dont want to do this manually.  That's why
I need to know which tables are involved in OpenACS "add user" process
to program my own "migration module".  I've been looking at the source
code in every "user-add*" file, but I dont see any "insert" sql
statement.  I guess there are functions that contains those statements
I am looking for.  Is there any easier way to solve my problem?

Thanks!

Collapse
2: Response to OpenACS tables description (response to 1)
Posted by Jonathan Ellis on 02/28/02 10:13 PM
openacs 3.x or 4.x?
Collapse
3: Response to OpenACS tables description (response to 1)
Posted by Min Chen on 02/28/02 10:39 PM
OpenACS 4.x
Collapse
4: Response to OpenACS tables description (response to 1)
Posted by Gilbert Wong on 02/28/02 10:58 PM
You can use the acs__add_user/acs.add_user plsql functions directly to add users but it's better to use the ad_user_new TCL function because the passwords are encrypted in the database.  If you use the plsql scripts directly, you could just insert a random password and when the user trys to login, the server can reset the password and email it to the user.