Changes to Variable Fields in Patron Records MLN2 (Global Update)
This document reviews how changes can be made to variable fields in patron records using Global Update for the MLN2 libraries.
Table of Contents
Global Update Features
Global Update is a very powerful tool that enables many types of edits. Using Global Update incorrectly can make far-reaching, unintended changes in your organization's database. Consider this when authorizing staff for the Global Update function.
With Global Update, you can
simultaneously modify fields and subfields in single or multiple records
find and replace tags or subfield indicators
insert new variable-length fields
find and replace data within variable-length fields and subfields
add to the beginning of variable-length fields
add to the end of variable-length fields
copy variable-length fields
delete variable-length fields and subfields
change the value of special fields
delete duplicate fields
copy MARC fields to non-MARC fields and vice versa
Please note that Global Update does not allow you to update all records simultaneously. Updating all records at once could result in serious performance issues for your system.
Use review files to create a search or query to process record changes using Global Update.
Changes to Variable Fields in Patron Records
Changing Variable-length Fields
Go to the Global Update function from the drop-down menu.
Change the Select records section from the Record Type of Bibliographic to Patron by unchecking the box for Bibliographic and checking the Patron box.
Search for the review file that contains the patron records whose variable length field you want to change.
Tip: you can type the number of your Create List review file to find it faster.
Choose Change variable-length field from the Choose Command Type dialog box to open the Change Variable-length Field dialog box. Click the OK button.
Options Check Boxes
From the Change Variable-length Field (New Command) display, you can select the Use Displayed Field, Match Case, Match Whole Field, and Match Whole Subfield check boxes as desired.
Use Displayed Field: This feature allows you to limit changes to the field displayed on the Select Records tab. It has no advantage since you can set the same limit in the command input tab. If you select the "Use Displayed Field" option and attempt to change a field other than the one displayed in "Select Records," you cannot make the change. For patron records, Global Update displays the Barcode field by default. To display a different field in the browse list as the target for change, toggle to the desired field.
Note: You should compare searches with the "Use Displayed Field" option, both checked and unchecked, to see if there is a difference.
Match Whole Field: The information in the Find data text box must match the entire field, or Global Update will make no change.
Match Case: The information in the Find data text box must match the text case found in the corresponding record field, or Global Update makes no change.
Match Whole Subfield: Information in the Find data text box must match the entire subfield, or Global Update will make no change.
To change variable-length field data:
Using the data you enter in the Find data fields, Global Update locates all selected records containing the specified tag, indicators, and data. It replaces the corresponding data in those records with the tag and data you specify in the Replace data fields.
In the Find text boxes, enter the field group tag, MARC tag, indicators, and data you want to change. The system updates only the fields in the selected records that meet all of the specified criteria.
Enter the field group tag and data you want to replace in the Replace data fields. The system does not change fields with the default value of <no change>.
By leaving the Replace Data field blank, you can delete all or a portion of the variable-length field data. The system then deletes the field or subfield you entered in the Find Data field.
Note that you must enter data in the Find Data field. You cannot search for the "existence of a subfield" without specifying its contents.
Required Input
To change variable-length field data, select (check) the Use Displayed Field or enter the Find Field Group Tag or Find MARC Tag field. After specifying the Find and Replace data, choose OK to close the dialog box and return to the Command input tab.
Here is an example of the variable-length field of message being changed.
The command row includes a Command column and an Action column. The Command column indicates the type of command you specified. (Change = change variable-length field.) The Action column indicates the target data criteria and the data to change in the format target criteria ==> change data. MARC tags appear in parentheses, and indicators appear in brackets.
A wild card character or word, such as a period ('.'), an equal sign ('='), or <any>, might represent some data fields with unspecified (default) content.
The command you created appears as a single line. Here is an example.
You can view the effects of your commands by selecting the Preview tab. Then, you can apply the changes by selecting the Process button.
Here is an example of the Preview tab.
The system displays the Process Changes box, asking if you are sure you want to process updates to selected records. Click Yes to proceed. Click No to cancel the process.
Once you click Yes, the changes will be made, and the system will display the number of records changed in the Statistics tab.
Here is an example for the Statistics tab.
Copying a Variable-length Field
Go to the Global Update function from the drop-down menu.
Change the Select records section from the Record Type of Bibliographic to Patron by unchecking the box for Bibliographic and checking the Patron box.
Search for the review file that contains the patron records whose variable length field you want to change.
Tip: you can type the number of your Create List review file to find it faster.
Choose Copy variable-length field from the Choose Command Type dialog box to open the Copy a Variable-length Field dialog box.
Options Check Boxes
You can select the Use Displayed Field, Match Case, Match Whole Field, and Match Whole Subfield check boxes as desired from the Copy Variable-length Field (New Command) display. The following checkboxes appear in the Copy Variable-length Field dialog box.
Use Displayed Field: This feature allows you to limit changes to the field displayed on the Select Records tab. It has no advantage since you can set the same limit in the command input tab. If you select the "Use Displayed Field" option and attempt to change a field other than the one displayed in "Select Records," you cannot make the change. For patron records, Global Update displays the Barcode field by default. To display a different field in the browse list as the target for change, toggle to the desired field.
Note: You should compare searches with the "Use Displayed Field" option, both checked and unchecked, to see if there is a difference.
Match Whole Field: The information in the Find data text box must match the entire field, or Global Update will make no change.
Match Case: The information in the Find data text box must match the text case found in the corresponding record field, or Global Update makes no change.
Match Whole Subfield: Information in the Find data text box must match the entire subfield, or Global Update will make no change.
To copy variable-length field data:
Global Update uses the data you enter in the Find text boxes to identify the field in the selected records to copy to the field specified by the Add text boxes.
In the Find text boxes, enter the field group tag, MARC tag, indicators, and data defining the field you want to copy. The system copies only the fields in the selected records that meet all of the specified criteria.
Required Input
In the Add data text boxes, identify the destination field for the copy.
After specifying the Find and Add criteria, choose OK to close the dialog box and return to the Command input tab.
The command row includes a Command column and an Action column. The Command column indicates the type of command you specified. (Copy = copy variable-length field.) The Action column indicates the copy target field criteria and the destination criteria in the format target criteria ==> destination criteria. MARC tags appear in parentheses, and indicators appear in brackets. A wild card character or word, such as a period ('.'), an equal sign ('='), or <any>, may represent some data fields with unspecified (default) content.
The command you created appears as a single line, for example:
Choose the Preview tab to view the effects of your commands. Choose the Process button in the Preview tab to apply the changes.
The system displays the Process Changes box, asking if you are sure you want to process updates to selected records. Click Yes to proceed. Click No to cancel the process.
Once you click Yes, the changes will be made, and the system will display the number of records changed in the Statistics tab.
Deleting Variable-length Fields
Go to the Global Update function from the drop-down menu.
Change the Select records section from the Record Type of Bibliographic to Patron by unchecking the box for Bibliographic and checking the Patron box.
Search for the review file that contains the patron records whose variable length field you want to change.
Tip: you can type the number of your Create List review file to find it faster.
Choose the Delete variable-length field from the Choose Command Type dialog box to open the Delete Variable-length Field dialog box. Click the OK button.
Options Check Boxes
You can select the Use Displayed Field, Match Case, Match Whole Field, and Match Whole Subfield check boxes as desired from the Delete Variable-length Field (New Command) display. The following checkboxes appear in the Delete Variable-length Field dialog box.
Use Displayed Field: Use Displayed Field: This feature allows you to limit changes to the field displayed on the Select Records tab. It has no advantage since you can set the same limit in the command input tab. If the "Use Displayed Field" option is selected and you attempt to change a field other than the one displayed in "Select Records," you cannot make the change. For patron records, Global Update displays the Barcode field by default. To display a different field in the browse list as the target for change, toggle to the desired field.
Note: You should compare searches with the "Use Displayed Field" option, both checked and unchecked, to see if there is a difference.
Match Whole Field: The information in the Find data text box must match the entire field, or Global Update will make no change.
Match Case: The information in the Find data text box must match the text case found in the corresponding record field, or Global Update makes no change.
Match Whole Subfield: Information in the Find data text box must match the entire subfield, or Global Update will make no change.
To delete variable-length fields:
In the Delete text boxes, enter the Field Group Tag, MARC tag, indicators, and data that define the fields you want to delete. The system deletes only the fields in the selected records that meet all of the specified criteria.
After specifying the data to delete, choose OK to close the dialog box and return to the Command input tab.
Required Input
The command row includes a Command column and an Action column. The Command column indicates the type of command you specified. (Delete = delete variable-length field.) The Action column indicates the target data criteria and the data to delete in the format target criteria ==> delete data. MARC tags appear in parentheses and indicators appear in brackets. A wild card character or word, such as a period ('.'), an equal sign ('='), or <any>, may represent some data fields with unspecified (default) content.
The command you created appears as a single line, for example:
You can view the effects of your commands by selecting the Preview tab. Then, you can apply the changes by selecting the Process button in the Preview tab.
The system displays the Process Changes box, asking if you are sure you want to process updates to selected records. Click Yes to proceed. Click No to cancel the process.
Once you click Yes, the changes will be made, and the system will display the number of records changed in the Statistics tab.
You can check your work by going back to the Select records tab and using the toggle feature to search for the records in the review file by message to see if it was removed. Blank results mean the information in the record does not exist.
Inserting Variable-length Fields
Go to the Global Update function from the drop-down menu.
Change the Select records section from the Record Type of Bibliographic to Patron by unchecking the box for Bibliographic and checking the Patron box.
Search for the review file that contains the patron records whose variable length field you want to change.
Tip: you can type the number of your Create List review file to find it faster.
Choose the Insert variable-length field from the Choose Command Type dialog box to open the Insert Variable-length Field dialog box. Click the OK button.
To insert variable-length fields:
Global Update uses the data you enter to insert a variable-length field into each selected record.
To insert a MARC field, select (check) the MARC Field check box.
To insert a non-MARC field, clear (uncheck) the MARC Field, disabling the MARC Tag, Ind1, and Ind2 text boxes. For this example, we are going to uncheck the MARC Field box. Enter the field group tag, MARC tag, indicators, and data you want to insert into the selected records.
If you leave the default value of <auto select> in the Field Group Tag text box, Global Update automatically assigns a field group tag based on the MARC tag you enter.
Here is an example of a Field Group Tag of Language that will be inserted in the patron records. In the example, unchecking the MARC Field worked best. Click the OK button.
The command row includes a Command column and an Action column. The Command column indicates the type of command you specified. (Insert = Insert variable-length field.) The Action column indicates the data for insertion. MARC tags appear in parentheses, and indicators appear in brackets. A wild card character or word, such as a period ('.'), an equal sign ('='), or <any>, may represent some data fields with unspecified (default) content.
The command you created appears as a single line, for example:
You can view the effects of your commands by choosing the Preview tab. Then, you can select Process to apply the changes.
The system displays the Process Changes box, asking if you are sure you want to process updates to selected records. Click Yes to proceed. Click No to cancel the process.
Once you click Yes, the changes will be made, and the system will display the number of records changed in the Statistics tab.
Returning to the Select records tab, you can toggle to the Language to see what information was added to the patron records in the review file.
Adding to the Beginning of Variable-length Fields
Go to the Global Update function from the drop-down menu.
Change the Select records section from the Record Type of Bibliographic to Patron by unchecking the box for Bibliographic and checking the Patron box.
Search for the review file that contains the patron records whose variable length field you want to change.
Tip: you can type the number of your Create List review file to find it faster.
Choose Add to beginning of variable-length field from the Choose Command Type dialog box to open the Add to Beginning of Variable-length Field dialog box. Click the OK button.
Options Check Boxes
You can select the Use Displayed Field, Match Case, Match Whole Field, and Match Whole Subfield check boxes as desired from the Add to Beginning of Variable-length Field (New Command) display. The following checkboxes appear in the Add to Beginning of Variable-length Field dialog box.
Use Displayed Field: Use Displayed Field: This feature allows you to limit changes to the field displayed on the Select Records tab. It has no advantage since you can set the same limit in the command input tab. If you select the "Use Displayed Field" option and attempt to change a field other than the one displayed in "Select Records," you cannot make the change. For patron records, Global Update displays the Barcode field by default. To display a different field in the browse list as the target for change, toggle to the desired field.
Note: You should compare searches with the "Use Displayed Field" option, both checked and unchecked, to see if there is a difference.
Match Whole Field: The information in the Find data text box must match the entire field, or Global Update will make no change.
Match Case: The information in the Find data text box must match the text case found in the corresponding record field, or Global Update makes no change.
Match Whole Subfield: Information in the Find data text box must match the entire subfield, or Global Update will make no change.
Global Update uses the data you enter in the Find text boxes to identify the corresponding fields in the selected records and inserts the data from the Add text box at the beginning of those fields.
How Global Update defines the beginning of a field depends on whether you specify the subfield and delimiter in the Add text box and whether the target field is MARC or non-MARC.
After specifying the Find criteria and Add data, choose OK to close the dialog box and return to the Command input tab.
The command you created appears as a single line, for example:
Required Input
The command row includes a Command column and an Action column. The Command column indicates the type of command you specified. (AddBegin = add to the beginning of the variable-length field.) The Action column indicates the target field criteria and the data for insertion in the format target criteria ==> add data. MARC tags appear in parentheses and indicators appear in brackets. A wild card character or word, such as a period ('.'), an equal sign ('='), or <any>, might represent some data fields with unspecified (default) content. In the example above, Global Update inserts the data "On or before 9/21/04: " at the beginning of fields with a field group tag of 'x' in the selected records.
You can view the effects of your commands by selecting the Preview tab. Then, you can apply the changes by selecting the Process button in the Preview tab.
The system displays the Process Changes box, asking if you are sure you want to process updates to selected records. Click Yes to proceed. Click No to cancel the process.
Once you click Yes, the changes will be made, and the system will display the number of records changed in the Statistics tab.
Adding to the End of Variable-length Fields
Go to the Global Update function from the drop-down menu.
Change the Select records section from the Record Type of Bibliographic to Patron by unchecking the box for Bibliographic and checking the Patron box.
Search for the review file that contains the patron records whose variable length field you want to change.
Tip: you can type the number of your Create List review file to find it faster.
Choose Add to end of variable-length field from the Choose Command Type dialog box to open the Add to End of Variable-length Field dialog box.
Options Check Boxes
You can select the Use Displayed Field, Match Case, Match Whole Field, and Match Whole Subfield check boxes as desired from the Add to End of Variable-length Field (New Command) display. The following checkboxes appear in the Add to End of Variable-length Field dialog box.