ADDITIONAL BATCH MODE OPTIONS

This section was added to the program options in version 247.

It is divided into three tabs or pages: General, MARC, and Excel.

GENERAL OPTIONS

DISPLAY INTERNAL MESSAGE ID

If selected, this options prepends the program's message id (an 8-12 digit number) to the full message. This option also requires that the 'Full message' option on the main form be selected. By default this option is not selected.

This option was previously located on the main form.

SHOW FULL PATHNAMES

If selected, this option displays (in the report header) the full pathnames of any sets (option files) used during the run. By default this option is not selected.

This option was previously located on the main form.

ADD RECORD/CONTENT TYPE

If selected, this option adds a textual representation of the type of record being reported to the record header. This option applies only to 'By Record' mode. By default this option is not selected.

The option first checks for an RDA Content Type term or code, and if that isn't found, falls back to the leader record type data.

Here is an example of the 336 format:

Record No. 1  [RDA Content Type: two-dimensional moving image], Control Number: ...

and here is one, for the same record type, based on the leader:

Record No. 1  [Type of record: projected medium], Control Number: ...

This option was previously located on the main form.

MARC OPTIONS

INCLUDE TAG OCCURRENCE

If selected (the default), this option will include the occurrence number of every tag that is reported. In 'By Record' mode, the tag occurrence is given with the brief message, after the tag, eg.,

264-002: _4 Does not end in punct.

In 'By Problem' mode, this option requires that 'Display MARC field being reported' is selected (because here the brief message needs to reference all possible occurrences of a tag).

TRUNCATE LONG FIELD AT …

In the past, long fields were truncated after 128 bytes, and a '~' added to the remainder (as a visible indicator that the report is displaying incomplete data).

This option was added in version 247 to offer more flexibility in the amount of data being reported. Any value from 1 to 1000 may be entered here. The default is 128.

WRITE MESSAGE ID TO TAG/SUBF

If selected, this option will, for each error message, write the message id to the Tag and subfield specified. The Tag/Subf specification must use the format NNNa, where 'N' is a number (0-9) and 'a' is a number or lowercase letter (a valid MARC subfield code).

If there is more than one message found for a record, an additional subfield in the specified tag will be added for each one (up to a maximum of 20).

Here is an example from a run that specified '999a' in this option:

999   $a700713611004$a42640004$a43360056$a25050001

This option requires that 1) a MARC File Output optionis selected, 2) the 'Writer error' checkbox is set, and 3) a valid Tag/Subf is specified. If no MARC Output is configured, or the checkbox is not set, the option is ignored (so you can set a tag here and it will stick until activate it).

By default this option is not selected.

USER TAG 1, 2

Use these options to add your own tags to the error report. For example, for each record reported, you may want to display–in addition to the MARC field of the error–some data from other tags in the record (such as local fields that indicate holdings location, cataloging source, alternate system number, etc.)

The Tag/Subf specification must use the format NNNa*, where 'N' is a number (0-9) and 'a*' is zero or more numbers or lowercase letters (valid MARC subfield codes). If no subfield code is given, then the complete field for the specified tag will be displayed.

Note that if the specified tag repeats, each occurrence will be displayed. To force the program to display only the first occurrence of a user tag, add '/1' to the Tag/Subf specification, eg.

852ac/1

Note also that in 'By Problem' mode, this option requires that the 'Display MARC field being reported' option (on the main form) be selected. In 'By Record' mode, this option is active whether or not that is the case.

'EXCEL' OPTIONS

These options are ignored unless the corresponding option on the main form–'Automatically generate report suitable for Excel–is selected.

SELECT FIELDS TO OUTPUT

This box lists all of the fields (or columns) that are available for the tabular format. By default, they are all selected. Uncheck any column that you do not want in the output.

The green checkbox on the right quickly toggles all of the checkboxes on and off.

ABOUT THE COLUMNS

Rsn: This column contains the record's sequence number in the source file, eg., the first record in the file has RSN '1', the second has RSN '2', and so on.

CtrlNum: This column contains the data from the Tag/Subf given in the 'Control number field' option on the main Batch option form.

RecTyp: This column contains either a 2- or 3-character code. The later is taken from the first 336; if that field is not found, a 2-character code consisting of the 000/06 and 000/07 is given instead.

ErrCountR: This column contains the number of errors reported for the current record (i.e., the record being reported on by the current row).

ErrMesg: This column contains the 'Brief message' for the error (i.e. the message that appears in the Brief Message list on the right-side of an Edit Session).

ErrNote: This column contains the long note, or Full message, for the error being reported.

ErrId: This column contains a numeric key (8-12 digits long) for the error being reported. This number (which is not guaranteed to be unique) is another way to organize similar messages. If the option 'Display internal message Id' is not selected, this column contains '0'.

ErrCode: This column contains a one-character code that indicates the type of message. A list of codes follows:

      'I' - invalid content designator
      'C' - TMQ cataloging check
      'M' - mandatory content designator
      'N' - non-repeatable content designator
      'O' - obsolete content designator
      'D' - old (pre-AACR2) content designator, do not use
      'U' - user-defined validation check
      'Z' - content designator is valid, but do not use

ErrTag: This column contains the MARC Tag in which the current error was reported.

MarcField: This column contains the MARC field (including the tag and Indicators) for which the current error is reported. If the option 'Display MARC field being reported' (on the main Batch options form) is not selected, this column contains a '0'.

User1, User2: These columns contain the data found in the corresponding User Tag(s) specified on the 'Marc tab' of the Additional Batch options form. If a tag repeats, each occurrence will be separated by ' ; '.

ErrCountP: This column contains the number of times the current error was reported during the run.

OUTPUT FORMAT

There are two output formats to choose from:

1. Tab delimited
2. CSV

In the former, each column but the last is output followed by a tab character; a carriage return and linefeed follows the last column. In the latter, the contents of each column are double-quoted, and each column is followed by a comma, except the last, which is followed by a carriage return and linefeed.

In general, our CSV format follows the specifications given in the wikipedia article here https://en.wikipedia.org/wiki/Comma-separated_values

The third option, 'CSV (semi-colon)', follows the CSV format except that it uses a semi-colon as the column separator, instead of a comma. This might be required by European applications.

Note that when importing the CSV, Excel will truncate leading zeroes in columns that contain only a MARC tag number. This is a problem with Excel and not with CSV. After researching this a bit, we decided not to use any of the 'tricks' that might force Excel to accept these leading zeroes, because all of these 'tricks' will break the format for other applications.