Archive
Monthly
Go
|
|
DNN Blog
Mar
2
Posted by:
Lorraine Young
Friday, March 02, 2007 3:00 PM
I recently used the repository module to manage a number of training videos and although team work and collaboration is how we all prefer to work, sometimes the responsibility of managing website content will fall to one individual. So I needed to upload each video however this automatically added me as the author. Although it would have been great to take credit for the hard work of others, it seemed a bit naughty - and so Philip Beadle kindly wrote the below SQL statement for me which enabled me to manage the author name and email fields using the Host > SQL page:
update grmRepositoryObjects
SET Author='author',
AuthorEmail='email'
WHERE ItemID = 50
Firstly, you will need to know the ItemId number of the items you need to update. You can find this by going to the edit page of the item. The ItemID is displayed at the end of the URL. Then simply change the author and email to the required information and Execute.
Thanks Philip, it's great for a non-developer to get this kind of administrative freedom.
5 comment(s) so far...
Re: SQL Script to change the Author details for the Repository module
I use the author field as the name of the author of the repository entry. When I need to have a separate field for the author of the object, and I have a limited number of authors, I use a property.
By hooligannes on
Tuesday, March 13, 2007 3:52 PM
|
Re: SQL Script to change the Author details for the Repository module
Hi, this is a perfect tip, however is this script can be used to change other fields. For example added date, or downloads count on repository module?
By greenflash on
Tuesday, March 13, 2007 3:55 PM
|
Re: SQL Script to change the Author details for the Repository module
glad you were able to find a work around, in the upcoming 3.1.12 release, you will be able to use a template setting to control the edit mode of the author name and author email address fields. The following edit options will be 1) use the original author info, 2) use the current user info, and a second setting will allow you to make either or both fields editable or non-editable.
That should meet the requirements of most use-cases and allow the module adminstrator to use the author name and email fields as they wish.
By sfabian@gooddogs.com on
Tuesday, March 13, 2007 4:19 PM
|
Re: SQL Script to change the Author details for the Repository module
Is it possible to use the username (Display Name) in the form instead of the current authorname (First Name Last Name)?
By ac3 on
Monday, March 26, 2007 10:31 PM
|
Re: SQL Script to change the Author details for the Repository module
ac3, check out the comment by Steve Fabian which will answer your question. Please post any more dev questions to the Repository forum.
By Lorraine Young on
Monday, March 26, 2007 10:33 PM
|
|