Modify the value of createdByUserNum
7 posts by 2 authors in: Forums > CMS Builder
Last Post: March 19, 2008 (RSS)
By Djulia - March 19, 2008
I would like retroactively to modify the value of createdByUserNum in the sector of administration.
There is a solution ?
Thank you for your assistance.
Djulia
Re: [Djulia] Modify the value of createdByUserNum
By Djulia - March 19, 2008
Excuse my question, I found the answer.
In section Admin > Advanced Commands...
Djulia
Re: [Djulia] Modify the value of createdByUserNum
By Djulia - March 19, 2008 - edited: March 19, 2008
1) Which are the values for List Options ?
Admin > Section Editors > Field Editor
Field Label : Created By
Field Name : createdByUserNum
Field Type : list
Display As : pulldown
List Options : Use options listed below
0 == ???
1 == ???
2 == ??? (admin)
3 == ??? (user)[/#0080c0]
Required : selected
Field Attributes :
System Field - restrict field editor access to this field (no selected[/#ff0000])
Admin Only - Field can only be modified by program or section admin users (selected[/#ff0000])
2) But, it seems that the field cannot be edited.
Error message : Field 'createdByUserNum' must be set to type 'none'.[/#0000ff]
Thank you for your assistance. [:)]
Djulia
Re: [Djulia] Modify the value of createdByUserNum
By Dave - March 19, 2008
One simple way, is to just copy and paste and create a new record as the new user. That's not always practical though.
Another way is to use a MySQL editing program and change the value of the createdByUserNum field to a different user num.
And a third way would be as follows:
- Make sure you are logged in as an admin user with 'admin' access to 'All Menus'.
- Find the user number of the 'new' record owner by mousing over (or clicking) the modify link for their account under "User Accounts". The user number will be displayed in the url.
- Go to the section you want to change in the Section editor
- Enable "System Field Editing" (bottom left under "Advanced Commands"
- Edit "createdByUserNum" and change the field to "createdByUserNum2" with type "textfield"
- Go edit the records you want to change. createdByUserNum2 will show up as a text field and you can change the user number.
- When finished, go back and rename the field back to "createdByUserNum" with type "none"
Hope that helps, let me know if that works for you.
interactivetools.com
Re: [Dave] Modify the value of createdByUserNum
By Djulia - March 19, 2008
Oops ! I think that simplest is to employ a MySQL editing program.
Thanks,
Djulia
Re: [Dave] Modify the value of createdByUserNum
By Djulia - March 19, 2008
You can give the values ?
0 == ???
1 == ???
2 == ??? (admin)
3 == ??? (user)[/#0080c0]
Thanks, [:)]
Djulia
Re: [Djulia] Modify the value of createdByUserNum
By Dave - March 19, 2008
I use 'MySQL Query Browser' for that. It's free, runs on my desktop, and by the MySQL folks. phpMyAdmin is good for that too. Not all web hosts let you connect remotely to MySQL.
If anyone wants to check out MySQL Query Browser you can here:
http://www.mysql.com/products/tools/query-browser/
http://dev.mysql.com/downloads/gui-tools/5.0.html
interactivetools.com