MySQL User Folder - adding additional user datafields.
I am planning on using MySQL User Folder with a Plone member's only site. I have it working in ZOPE for user signin and that works. I want to add a number data fields for each user, typical fields like ADDRESS, PHONE, POSTAL CODE, TITLE... I need to be able to update and report the data from outside ZOPE, that's why I choose MySQL. While the documentation for MySQL User Folder goes into more depth than most ZOPE products, it is unclear how to best accomplish this task. I want to be able to load the basic user info (title, email, first name, last name) into the REQUEST object at login so I can display and use it throughout the site. There seem to be two methods (NOTE: This is a small site so volume of data is not an issue). 1) enhance the "User" table by adding needed data fields; 2) use the "MiscData" table to hold the data fields. I need the end-users to be able to update some of these fields, such as TELEPHONE. My questions: 1) Which is better storage approach - (1 or 2 from above)? 2) Where can I insert code to load the additional user data into the REQUEST object? It is unclear to me what modules are called when or after the user authenticates by either direct login/http or cookie login. 3) How does ZOPE know to map a user onto a user's folder. 4) I assume I can use any approach for SQL databases to allow the user to update selected user data fields (TELEPHONE, TITLE...). I am looking for a concrete example (ideally with some code to model my work after) or a HowTo to make this happen. Also -- is there some documentation on the USER object in ZOPE (and Plone). It looks like MySqUserFolder loads data into a USER object, but I am unclear how to use that to hold and get the information I am looking for. (I would be open to alternative approaches if the satisfied my requirements) Thanks, David ======================================= David T. Washburn DWashburn@AmInfo.com Amherst, MA USA 413 256-3103
participants (1)
-
David Washburn