Forum OpenACS Development: Re: Extending User Properties

Collapse
Posted by Iuri Sampaio on
Does the latest OACS release have support to new user properties ?

What would be the best solution to extend users info?
Would plsql acs_attribute__create_attribute be useful in this case?

Best wishes,
I

Example:
select acs_attribute__create_attribute(
'user',
'purchased_plan',
'text',
'Purchased Plan',
'Purchased Plans',
'users',
'purchased_plans',
null,
1,
1,
null,
null,
'f'
);

Collapse
Posted by Gustaf Neumann on
There are several approaches for this
- ams: https://openacs.org/xowiki/ams
- dynamic types: https://openacs.org/xowiki/dynamic-types
- dynfields (in PO)
- xo dynfields https://gitlab.com/sussdorff/intranet-xotcl-dynfield

i have not used any of these, so i can't say, what's the best for your situation.

Collapse
Posted by Michael Aram on
In addition to that, you might also want to have a look at ACS Object Management. I have had a look at ams and acs-object-management some months ago. What I remember is, that I wondered why acs-object-management never made it into the core, as its approach seemed to be relatively "OpenACS-native".

Note as well, that XOTcl Core provides automatically created procs for db functions, e.g. ::xo::db::sql::acs_attribute proc create_attribute...