Bug #824

Make website deal with user tables in vegbank, not framework

Added by Michael Lee almost 20 years ago. Updated over 17 years ago.

Target version:
Start date:
Due date:
% Done:


Estimated time:


Ok for now. Need autofill in the certification form.

moveFrameworkIntoVegBank.jpg (306 KB) moveFrameworkIntoVegBank.jpg Michael Lee, 11/11/2003 12:15 PM
moveFrameworkDD.html (14.1 KB) moveFrameworkDD.html Michael Lee, 11/11/2003 12:59 PM

Related issues

Is duplicate of VegBank - Bug #825: [1033] Management accounts??Closed11/13/2002

Is duplicate of VegBank - Bug #836: database redesign for Intellectual Property Table for permissions for embargoed dataResolved11/13/2002

Blocks VegBank - Bug #1219: VegBank 1.0.2 model - implementedResolved11/21/2003


#1 Updated by John Harris over 19 years ago

This was done fall 2002.

#2 Updated by John Harris over 19 years ago

  • Bug 825 has been marked as a duplicate of this bug. ***

#3 Updated by Michael Lee over 19 years ago

Need to make sure that certification documents are emailed to the appropriate
parties when someone requests certification. This list of parties probably
should be an XML doc somewhere so that we could change easily who will get the

additionally, all fields that are public in the certification form need to be
editable from the "edit profile" page :

#4 Updated by Michael Lee almost 19 years ago

profile database (framework) does not need revision for the Nov1 milestone.
Certification just needs to work. AFter ceritifcation fucntionality works, put
this bug in the 2.0 bucket.

#5 Updated by P. Anderson almost 19 years ago

If a user is not logged in, fills out entire form, submits, message says, "log
in" and the form data is lost. Bad news for user.

Also, "What do the levels mean?" link is broken.

Also, since only logged in users can apply for cert, we don't need the email
address to be entered, or at least we can auto populate it.

#6 Updated by Michael Lee almost 19 years ago

Mark, your comments above I agree with. The "what do these levels mean" link is
perhaps being screwed up my renegade javascripts elsewhere in the page, ie
footer and header. This wasn't a good idea on my part and I will be removing
them. We can find another way of linking someone to context sensitive help.

#7 Updated by Michael Lee almost 19 years ago

  • Bug 836 has been marked as a duplicate of this bug. ***

#8 Updated by Michael Lee almost 19 years ago

Mark, I'll take this bug for now, with focus on model change implications.
Sounds like the certification email is working better now- just need to get the
from: address sorted out.

#9 Updated by Michael Lee almost 19 years ago

more info, akin to data-dictionary on its way

#11 Updated by Gabriel Farrell almost 19 years ago

I see no problems with the ERD id=89 particularily in relation to user,
certification, userPermissions and embargo, userDataset and datasetObs tables.

Supporting the userQuery, recordOwnership, partyMember and userNotify are over
my horizon for now but the model looks good.

I am concerned about the SQL queries stored in the userNotity and userQuery as
there may be a more abstract way to do this that would be more robust to model
and system changes, what that way might be is unclear to me so its a moot point
for now.

Also we currently have no way to persist user preferences we may want to add
another table(s) later to support this. This can be ignored for now in the
interest of finalizing this good work and getting it in place.

#12 Updated by Michael Lee almost 19 years ago

Once again changing the nature and summary of this bug. Here is the task of
making the website work with the correct, new tables inside vegbank, not in
framework. Certification, authentication, log-in, etc. all need to now read
through the new tables, which are presumably populated and happy in vegbank.

#13 Updated by P. Anderson over 18 years ago

New user system works great now!

#14 Updated by Michael Lee over 17 years ago

changed from components that are to be deleted to "misc" so that bugs don't get
deleted with component. Sorry for all the email.

#15 Updated by Redmine Admin over 9 years ago

Original Bugzilla ID was 824

Also available in: Atom PDF