Change Username? 3

[polymath5]

Running GM 6.5

Employee got married and I would like to change her Username and name in the system from Nancy Smith to Nancy Jones.

It looks like I can change the Full Name, but not the Username. She has a lot of notes and history that I need to make sure stays linked with her.

Can this be done?

Thanks very much.

=============
Mens et Manus
=============

 

[RobColborne]

Hi

You can't change the username. The best approach is to clone the user, and then rollover her scheduled activities to the newly created user.

Historic activities will have to stay the same, and the history can't be change like a Hollywood movie.

 

[polymath5]

Hi Rob,

Thanks very much for the help.

Just so I'm clear. If I clone the user, I can move Pending/scheduled stuff to her. But any history she has will remain attached to the original username, correct?

=============
Mens et Manus
=============

 

[RobColborne]

Hi

Yes that is correct.

You would move the schedule item over from the Activity List by viewing all dates in the Open tab and using the Rollover function.

 

[polymath5]

Thanks again Rob!

=============
Mens et Manus
=============

 

[goner]

http://www.redstonesoftbase.com

The GOLDBOX utility has a username changer built just for this problem.

Doug Castell
Castell Computers
(310)601-4738

http://www.castellcomputers.com

 

[polymath5]

Cool. I have GB, so I'll have to check that out. Only thing I don't like about GB is it's whacky interface. But perhaps that's just because I so rarely need to use it.

Thanks for the help!

=============
Mens et Manus
=============

 

[goner]

I agree that the interface can be a bit non-standard at times, but it's a very powerful application..

Doug Castell
Castell Computers
(310)601-4738

http://www.castellcomputers.com

 

[ddeegan]

I created a stored procuedure that has worked well

in query analyzer -

sp_changename 'Mrs. Smith', 'Miss Smith'

....after she was married

CREATE PROCEDURE sp_changename
@newusername varchar(8),
@oldusername varchar(8)
AS
update cal
set
userid = @newusername
where userid= @oldusername
update cal
set
createby = @newusername
where createby=@oldusername
update cal
set
lastuser=@newusername
where lastuser=@oldusername
update contact1
set
createby=@newusername
where createby=@oldusername
update contact1
set
lastuser=@newusername
where lastuser=@oldusername
update conthist
set
userid=@newusername
where userid=@oldusername
update conthist
set
lastuser=@newusername
where lastuser=@oldusername
update conthist
set
createby=@newusername
where createby=@oldusername
update contsupp
set
lastuser=@newusername
where lastuser=@oldusername
update forms
set
userid=@newusername
where userid=@oldusername
update mailbox
set
userid=@newusername
where userid=@oldusername
update report32
set
userid=@newusername
where userid=@oldusername
update report32
set
lastuser=@newusername
where lastuser=@oldusername
update scriptsw
set
lastuser=@newusername
where lastuser=@oldusername
update tracks
set
userid=@newusername
where userid=@oldusername
update userlog
set
userid=@newusername
where userid= @oldusername





GO

 

[polymath5]

Thanks for the SP, but I'm running the dbase version of 6.5. I know, I know... <G>

But I'll keep this SP for the future if we ever do upgrade to the SQL version.

Thanks again.

=============
Mens et Manus
=============

 

[goner]

Note that this SP would NOT be sync friendly... Nice job tho, for a non-synchronizing system

Doug Castell
Castell Computers
(310)601-4738

http://www.castellcomputers.com