Hi,We have worked out there is approximately 2000 unique templates on our server. I need to scan these for a string, because a project is underway meaning that some old (formula language) code will no longer work.
Does anyone have any suggestions whereby you can scan all the databases for a string? (not one at a time - altogether).
The only way I know of doing it would either be individually using design synposis for each one (pretty much an impossible task), or using TeamStudio’s tool ‘Configurator’ which also seems to work at the ‘individual database’ level…
Subject: I need to ‘scan’ or ‘find and replace’ in over 2000 databases…
If the formula is in an agent, you can use ScriptSearch from nsfTools:
http://www.nsftools.com/tools/ScriptSearch.htm
Subject: I need to ‘scan’ or ‘find and replace’ in over 2000 databases…
You can use TeamStudio and do a loop to find your string
They have a script
Function FindReplace( Byval srcDB As String, Byval strFind As String, Byval strReplace As String, retFound As Long, retReplaced As Long ) As Long
' need to dim variables to pass into CONFYFindAndReplace() even if we arenot going to use them
Dim retSearched As Long
'return 0 if successfull or an error code otherwise
FindReplace = CONFYFindAndReplace(_
srcDB,_ 'Database to search, can't be empty
"LogsConfig.nsf",_ 'Log database, empty string if not used - TMSLogs.ntf must be on the same machine that the script is running
strFind,_ 'Text to find, can't be empty
strReplace, _ 'Text to replace with, can be empty
CONFY_MATCH_DEFAULT,_ 'Things to match
CONFY_SEARCH_DESIGN+CONFY_SEARCH_MODE_REPLACE, _ 'Where to search
0,_ 'Compile or sign modified notes
"",_ 'String containing a formula or view to search with (only needed if CONFY_SEARCH_DATA is used), can be an empty string if not used
"",_ 'Context filter string, can be an empty string if not used
retSearched,_ 'specify a variable to recieve the number of notes/documents that were searched
retFound ,_ 'specify a variable to recieve the number of occurences that were found
retReplaced ) 'specify a variable to recieve the number of occurences that were replaced
End Function