Replacement Tool

I know it is a basic no-no to hard code user's names into formulas , but sometimes it can't be helped.  Anyway my question is this, Suppose a manager leaves the company and a new one is hired to replace him/her. Is there a tool that one could use on a database to seek out and replace the old name with the new one?  Or even(and I know the first question was stretching it) a tool that could do this on multiple databases at a time? I am entering 25 points in case the answer is no, but would like to give something for effort. If I am given useful information, I will bump it to 250.  Thanks in advance.
schmad01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ArunkumarCommented:
change name via admin may not help you because you are bringing in a new person and not an existing persons name change.

Did you try options with Teamstudio ? It can do lots of wonders !!!

;-)
0
ArunkumarCommented:
Its TeamStudio Configurator..... !!!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
p_parthaCommented:
As arun has poitnted out, Teamstudio is an excellent tool but rememebr it's not free, so if it is a hardcoded field, then u can write an agent and do a all document level search. If it is a part of the design element, then i would prefer you to take a design synopsis and paste it in a word , and do a find and replace....

Arun , long since i snatched ur points

Partha
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

ArunkumarCommented:
Here i am snatching yours !!!!

We are talking about Data change and not design element changes !!!

LOL ...

No one gets pts...
0
p_parthaCommented:
Arun,
I have given answer for both.

schmad01
if its data change just write a agent to run on all documents with this simpel formula

@replacesubstring(fieldname;"<personnametobereplaced>";"<newpersonname>")

Hope i make sense


Partha
0
CRAKCommented:
If the names are only used in reader- or authorname type of fields, then use the database' administration server.
For names or text fields, p_partha's agent will do. If names are stored in design elements, a full design change is required. If a manual change is not an option, Configurator will help you out. It'll change any occurance in any place in the design AND in any document.
0
ArunkumarCommented:
okay we will share points !
0
CRAKCommented:
You forgot to ask for a raise...
0
ArunkumarCommented:
thats yours and Parthas job... !!!

LOL...
0
schmad01Author Commented:
This tool is exactly what I need. I hope it does what it says it can do.  Thanks for the referral.
0
CRAKCommented:
It does.... I use it myself occasionally. It also recompiles lotusscripts after a modification of script libraries. To be honest, that's what I use it for mostly! Replacements of "use" with "Use" + recompilation.... If I don't I sometimes get all sorts of errors.
Congrats Arun!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.