==============================================================
Locating and Resolving Unauthorized Terms Used in Marc Records
==============================================================

.. note::

    This will work best if the tsv has been cleaned up first using the :ref:`galatea clean-tsv<clean-tsv>` command


This workflow is used to locate and resolve unauthorized terms in MARC record data found in a tsv file.
The workflow consists of the following steps:

1. Check for unauthorized terms in the tsv file.
    Use the :ref:`authorized-terms check command <authorized-terms_authorized-terms-check>` to find unauthorized terms in the tsv file.

    ``galatea authorized-terms check <source_tsv>``

2. Create a new transformation file with the unauthorized terms.
    if you don't already have a transformation file with the unauthorized terms, use the
    :ref:`authorized-terms new-transformation-file command <authorized-terms_new-transformation-file>`
    to create a new one.

    ``galatea authorized-terms new-transformation-file``

3. Fill in the transformation file with how you want specific unauthorized terms to resolve.

    .. Note::

        Don't have to start from scratch every time. If you have a transformation file that you have used before that
        has all the transformation defined, you can use that. In fact, you should be constantly improving a single one.


    The transformation file is the tsv file generated by the
    :ref:`authorized-terms new-transformation-file command <authorized-terms_new-transformation-file>`
    and will contain a list of two columns. By default, the name generated for the file by this command is
    "authorized_terms_transformation.tsv", but you can name it whatever you want.

    Open this file in whatever table editor you prefer, as Microsoft Excel. As long as the the application can open and
    save tsv files, it can be used for this step.

    The format of this file has the first column for unauthorized terms, and the second column is for the matching
    authorized term that should replace the unauthorized term.

    For example:

    You want the unauthorized term "Chicago, Ill." to change to "Chicago (Ill.)", and the unauthorized term "Washington, D.C." to change
    to "Washington (D.C.)", the tsv file should look like this:

    .. literalinclude:: authorized_terms_transformation.tsv

    .. warning::
        The first line of the tsv file is a header line, and should not be changed.

        After the header line, you can add as many lines as you want, but the first column should always be an
        unauthorized term, and the second column should be an authorized term.

3. Resolve the unauthorized terms to authorized terms in the tsv file.
    Using the transformation file you created in the previous step, use the
    :ref:`authorized-terms resolve command <authorized-terms_resolve>` to resolve the unauthorized terms in the tsv file.