XML import validation routines

You can use several pre-programmed validation routines in your XML Import.

Overview

These routines are for particular types of data including International Standard Book Numbers (ISBN) validation. There are a few validation routines for use with importing names and dates from MARC XML.

You can enter these validation routines in the XML Import Configuration window, on the Field Mappings tab, in the Validation column. For more information on creating an XML Import configuration, see Create or update records in bulk with XML Import.

ISBN_NO

Purpose

ISBN_NO is the primary argument for an XML Import validation that checks that incoming data is a valid ISBN or ISSN number. If on the initial look, the data is not an ISBN or ISSN, the validation will remove any extra characters including any appended, and check again. For instance 0-7897-2441-3 and 0/7897/2441/3 (pb) will both pass the test and be imported, but ISBN: 0-7897-2441-3 and 0-7897-2441-4 will not.

If the incoming data is not an ISBN or ISSN, nothing will be imported to the field.

Argument structure

Enter ISBN_NO as the validation. There are no further arguments.

MARC_LNAME

Purpose

MARC_LNAME is the primary argument for an XML Import validation that isolates the family name of a full name that is given in RDA format. For example:

Family Name, Given Name(s), Dates/Title etc

For instance if the incoming data was Joyce, James, then the word Joyce would be isolated for importing to the destination field (probably LAST_NAME).

This validation works in conjunction with MARC_FNAME, which works on the same initial data, isolating the given name.

Argument structure

Enter MARC_LNAME as the validation. There are no further arguments.

MARC_FNAME

Purpose

MARC_FNAME is the primary argument for an XML Import validation that isolates the given name of a full name that is given in RDA format. For example:

Family Name, Given Name(s), Dates/Title etc

For instance if the incoming data was Joyce, James, then the word James would be isolated for importing to the destination field (probably FIRST_NAMES).

This validation works in conjunction with MARC_LNAME, which works on the same initial data, isolating the family name.

Argument structure

Enter MARC_FNAME as the validation. There are no further arguments.

MARC_DOB

Purpose

MARC_DOB is the primary argument for an XML Import validation that isolates the date of birth from a lifespan given in the following format:

Year of Birth - Year of Death

For instance, if the incoming data was 1900-1999, then the year 1900 would be isolated for importing to the destination field (probably BIRTHDATE).

If the incoming data does not include a death date (for example, 1976 or 1976-), then the birth year will be extracted anyway (that is, 1976).

This validation works in conjunction with MARC_DOD, which works on the same initial data, isolating the given name.

Argument structure

Enter MARC_DOB as the validation. There are no further arguments.

MARC_DOD

Purpose

MARC_DOD is the primary argument for an XML Import validation that isolates the date of birth from a life span given in the following format:

Year of Birth - Year of Death

For instance, if the incoming data was 1900-1999, then the year 1999 would be isolated for importing to the destination field (probably DEATHDATE). If the incoming data does not include a death date (for example, 1976 or 1976-), then the extracted value will be null "", and nothing will be imported to the field.

This validation works in conjunction with MARC_DOB, which works on the same initial data, isolating the given name.

Argument structure

Enter MARC_DOD as the validation. There are no further arguments.

MARC_INITIALS

Purpose

MARC_INITIALS is the primary argument for an XML Import validation that constructs the initials for a given name of a full name that is given in RDA format. For example:

Family Name, Given Name(s)

For instance if the incoming data was Jones, Abby Billie Charlotte then the value obtained would be A B C which could then be imported to the INITIALS field.

This validation works in conjunction with MARC_FNAME, which works on the same initial data, isolating the given names.

Argument structure

Enter MARC_INITIALS as the validation. There are no further arguments.

GET_FROM_BRACKETS

Purpose

GET_FROM_BRACKETS is the primary argument for an XML Import validation that can be applied to any incoming element that has the required data encompassed in brackets. The brackets and anything outside them will be stripped off.

For instance, the q subfield of person fields in MARCXML are used to give a fuller form of the name, for example:

<subfield code="a">Meyer, R. J.</subfield>

<subfield code="q">(Robert John),</subfield>

You could use the GET_FROM_BRACKETS validation on the subfield code="q" to extract Robert John for import. That is, any brackets and extra characters are stripped off.

Argument structure

Enter GET_FROM_BRACKETS as the validation. There are no further arguments.