Re: [Treebase-devel] harvesting

[Hilmar L. <hl...@ne...>]

On Feb 1, 2012, at 12:17 PM, William Piel wrote:

> The only "missing" functionality is when the admin person needs to create a new submission for someone else -- in some cases because they can't seem to do *anything* for themselves.

I see. And the problem here would only be if the user for whom you want to create a submission has already an account. (Because otherwise you could also create the account for them, and when done with your part, ask them to reset the password if they want to polish up anything.)

> In other cases because I discover that a submission is corrupt in some way, and the most efficient solution is for me to create a new submission for them, re-upoad non-corrupting data, and then delete the old one.

So here the user would indeed already have an account.

> the ability for the admin person to move a submission from one user to a different user. 
> 
> I don't think it would be significant work -- at least the SQL is pretty minor -- just two updates within the same transaction: 
> 
> UPDATE submission SET user_id = <new user> WHERE study_id = 10; 
> UPDATE study SET user_id = <new user> WHERE study_id = 10; 

That looks fairly minor indeed - and presumably you can do that already now, no?

> Harry isn't funded for TreeBASE, so while minor tweaks might be okay (out of the kindness of his heart), major thinks like redoing the authentication system need to be budgeted.  But perhaps this is the ideal use for the emergency funds (the one ones that Karen is now dipping into regarding the student worker) ?

So based on the above I'm still hoping this could be done in a way that isn't a major thing, or equivalent to redoing the authentication system.

Either way, I agree it's worthwhile to consider whether we can use the emergency funds for this. One difficulty here is obviously how we'd do this without adding Yale's 60% overhead rate - perhaps we can hire Harry on an outside contractor basis for this task if he does work on the side? Could you or Harry give me an estimate of effort in number of hours? 

	-hilmar
-- 
===========================================================
: Hilmar Lapp  -:- Durham, NC -:- informatics.nescent.org :
===========================================================