Forum OpenACS Q&A: 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!

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?

3: Response to OpenACS tables description (response to 1)

Posted by Min Chen on 02/28/02 10:39 PM

OpenACS 4.x

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.