FmPro
Script Diff Demo Available for download...
How to search and replace text
within ScriptMaker scripts
Text within any script can be searched by entering a search
string in the Find text field, then clicking on the search button. Searches
are limited to the scripts stored within the folder tab where the search
button is clicked. Any piece of text, instruction name or fieldname
can be found anywhere within a group of scripts. A list of scripts containing
the search text is then displayed. Clicking on an individual script
within the list displays the full text of the script with the search
text highlighted in yellow. The Script Text field is automatically scrolled
to the first highlighted search result. Pressing the TAB key advances
to the next highlighted search result within the Script Text field.
Fieldnames can be searched by entering the field in the format Tablename::Fieldname
within the search field.
Search & Replace can be used to replace pieces of
text throughout a group of scripts, such as replacing "ABC Company"
with "XYX Company".
Fieldnames entered in the format Tablename::Fieldname can also be quickly
replaced within all scripts.
Replacing Table Occurance names can also be done in order to facilitate
multi-file to single-file database consolidations. In order to insure
success when performing a Table Occurance name change, it is important
to verify that the Table Occurance name does not consist of commonly
used words, XML attribute names, or ScriptMaker instruction names. A
good way to insure uniqueness, is to add some characters to the Table
Occurance name in the relationship graph before copying the scripts
from FileMaker.
To perform a Search and Replace within a group of scripts,
click on the blue triangle to the right of the search field, then select
Search & Replace from the pop-up menu.
A search and replace can be performed for text or Tablename::Fieldnames
within any group of scripts. When performing a search and replace within
the scripts, it can be helpful to use the Database1 or Database2 folder
tabs as scratchpad work areas for storing the scripts which will be
changed. The Script Repository tab could then be considered to be the
master copy of these scripts. When performing the search phase of the
Search & Replace, a search is performed of the Script Text fields.
Once a set of matching records is found, the replacement operation is
performed on the XML version of the script. Therefore it is recommended
that the entire search string should not exactly match any XML attribute
names or script step names. It is recommended that a test search be
performed first in order to verify the text which will actually be affected
by a Search and Replace operation.
Fieldnames receive special treatment during a Search &
Replace. FmPro Script Diff recognizes fieldnames as a special type of
text whenever fields are entered in the format Tablename::Fieldname.
One pass is made thru the XML of each script to replace Calculation
Formulas containing the combined Tablename::Fieldname text. A second
pass is made thru the XML to replace the Tablename and Fieldname info,
as these two pieces of info are stored as two different XML attributes.
.
