 |
Djulia
User
Mar 19, 2008, 9:29 AM
Post #1 of 7
(361 views)
Shortcut
|
|
Modify the value of createdByUserNum
|
Can't Post
|
|
Hi,
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
|
|
| |
|
Djulia
User
Mar 19, 2008, 9:39 AM
Post #2 of 7
(360 views)
Shortcut
|
|
Re: [Djulia] Modify the value of createdByUserNum
[In reply to]
|
Can't Post
|
|
Oops !!! 
Excuse my question, I found the answer.
In section Admin > Advanced Commands...
Djulia
|
|
| |
|
Djulia
User
Mar 19, 2008, 9:56 AM
Post #3 of 7
(359 views)
Shortcut
|
|
Re: [Djulia] Modify the value of createdByUserNum
[In reply to]
|
Can't Post
|
|
In fact, I need a help :
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)
Required : selected
Field Attributes :
System Field - restrict field editor access to this field (no selected)
Admin Only - Field can only be modified by program or section admin users (selected)
2) But, it seems that the field cannot be edited.
Error message : Field 'createdByUserNum' must be set to type 'none'.
Thank you for your assistance. 
Djulia
(This post was edited by Djulia on Mar 19, 2008, 10:12 AM)
|
|
| |
|
Dave
Staff
/ Moderator
Mar 19, 2008, 3:21 PM
Post #4 of 7
(346 views)
Shortcut
|
|
Re: [Djulia] Modify the value of createdByUserNum
[In reply to]
|
Can't Post
|
|
It's not editable, but here's some ways you can do it.
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.
Dave Edis - Senior Developer
interactivetools.com
|
|
| |
|
Djulia
User
Mar 19, 2008, 3:29 PM
Post #5 of 7
(344 views)
Shortcut
|
|
Re: [Dave] Modify the value of createdByUserNum
[In reply to]
|
Can't Post
|
|
Thank you Dave,
Oops ! I think that simplest is to employ a MySQL editing program.
Thanks,
Djulia
|
|
| |
|
Djulia
User
Mar 19, 2008, 3:35 PM
Post #6 of 7
(341 views)
Shortcut
|
|
Re: [Dave] Modify the value of createdByUserNum
[In reply to]
|
Can't Post
|
|
Another question.
You can give the values ?
0 == ???
1 == ???
2 == ??? (admin)
3 == ??? (user)
Thanks,
Djulia
|
|
| |
|
Dave
Staff
/ Moderator
Mar 19, 2008, 3:37 PM
Post #7 of 7
(340 views)
Shortcut
|
|
Re: [Djulia] Modify the value of createdByUserNum
[In reply to]
|
Can't Post
|
|
If you can, that's _definitely_ the simplest! :)
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
Dave Edis - Senior Developer
interactivetools.com
|
|
| |
|
