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 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

Re: [Djulia] Modify the value of createdByUserNum

By Dave - March 19, 2008

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