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

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

Re: [Djulia] Modify the value of createdByUserNum

By Djulia - March 19, 2008

Oops !!! [blush]

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

In fact, I need a help : [blush][blush]

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

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

Re: [Dave] Modify the value of createdByUserNum

By Djulia - March 19, 2008

Thank you Dave, [:)]

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

Another question.

You can give the values ?

0 == ???
1 == ???
2 == ??? (admin)
3 == ??? (user)[/#0080c0]


Thanks, [:)]

Djulia