.png)
When manually entering resources or borrowers into the system, and especially if more than one person has been responsible for this, the user may have differences in the way that some words have been entered.
For example, the word ‘U.F.O.’ may have been entered onto a resource record but the immediate user would like the phrase to be written as ‘UFO’.
Data Cleanse Replacements is a table that the user may add words to, along with a replacement word. This means that when a resource or borrower has been added to the system, and includes a word listed in Data Cleanse Replacements table, the word is automatically changed to the one that has been specified as the replacement here.
Click Database / Lookup Maintenance / Data Cleanse Replacements from the top horizontal menubar in Management.
(1).png)
The Data Cleanse Replacements table will appear on-screen.
(1).png)
To Edit an existing record
(1).png){kind=small}
Click and select to highlight the desired record from the table, then click Edit from the Records toolbox on the right side of the screen.
To create a New record
(1).png){kind=small}
Click New from the Records toolbox on the right side of the screen.
After choosing either button, the Data Cleanse Replacements record card will appear on-screen.
(1).png)
Manually enter a phrase or Word and Replace With phrase into the fields as appropriate before clicking Save to commit changes and return to the previous screen.
Running these changes on the database
The setting must be enabled before this configuration will run against the library database.
Ensure the Apply data cleanse replacements checkbox is ticked in Tools / Data Tidy.
.png){kind=small}
Copyright © 2013 MLS