Yale / APIS Conversion: Special Processes
Last updated: 04/03/01
NB: This document is to be used in conjuction with the Yale
/ APIS Conversion Data Map, which includes requirements for
straightforward data conversions. More complex conversions (e.g., those
involving multiple fields or data manipulation) are documented below.
#1 APIS ID creation
Yale APIS records have no sequential record number suitable for use as a record control
number. Because of the desirability of having a unique, stable, derivable number based
on record content, a number constructed from the Yale Filemaker Pro "PIN" element was used as the basis for the APIS number to use as an APIS ID. The conversion spec for the numeric
portion of the ID (i.e., the portion of the identifier that follows "yale.apis.") follows:
| Char 1-2 |
Prefix |
'DP' =
'44' (ASCII "D")
'DPg' = '31'(ASCII "1")
'DPm' = '32'(ASCII "2")
Else '00'
|
| Char 3-6 |
Sequence Number (PIN) |
numeric
based on PIN, left zero fill |
| Char 7-8 |
Suffix 1 (A/B) |
'(A)'
= '41' (ASCII "A")
'(B)' = '42' (ASCII "B")
Else = '00' |
| Char 9-10 |
Suffix 2 (Text no.) |
'First text' = '31'
(ASCII '1')
'Second text' = '32'
(ASCII '2')
'Third text' = '33'
(ASCII '3') etc.
Else = '00' |
The designations "fol" and "qua" are ignored;
all internal spaces are removed.
Examples:
| ORIGINAL YALE PIN |
DERIVED APIS NUMBER |
| 7 |
yale.apis.0000070000 |
| 13(A) |
yale.apis.0000134100 |
| DP 13(First text) qua |
yale.apis.4400130031 |
| 5000:5 |
yale.apis.0050000035 |
For details of the conversion scripts used, see 001.pdf
|
|
#2 DDBDP Link creation
Some Yale records as exported include a link to the corresponding
DDBDP record in the form:
<a href="http://www.perseus.tufts.edu/cgi-bin/papytext?series=P.Yale&lookup=1.74">
This reflects the older syntax for DDBDP linking, and for APIS
has been converted into a cu510_dd reference such as:
cu510_dd | 1 | P.Yale:1:74
This is processed by the APIS interface into a new-style DDBDP
link such as:
http://www.perseus.tufts.edu/cgi-bin/ptext?doc=Perseus:abo:pap,P.Yale:1:74
|
#3
Language Note, Language Codes
SUMMARY: Create two CU data elements from Yale LAN element:
a) Move the entire contents of Yale LAN field to cu545, e.g.,
LAN "Egyptian\Coptic"
to:
cu546 "Egyptian\Coptic"
b) Scan field for first occurrence of one of the language names listed in the first column below, and create an cuLCODE field with the corresponding equivalent code. (NB: No matter how many languages are recorded in the original field, only one cuLCODE will be used.)
|
Yale LAN field begins
|
|
cuLCode field |
|
(A)Arabic
|
=
|
ara |
|
(A)Greek
|
=
|
grc |
|
(A)Latin
|
=
|
lat |
|
Arabic
|
=
|
ara |
|
Aramaic
|
=
|
arc |
|
Coptic
|
=
|
cop |
|
Demotic
|
=
|
egy |
|
Egyptian\Coptic
|
=
|
cop |
|
Egyptian\Demotic
|
=
|
egy |
|
Egyptian\Hieratic
|
=
|
egy |
|
Egyptian\Hieroglyphic
|
=
|
egy |
|
Greek
|
=
|
grc |
|
Latin
|
=
|
lat |
|
Hebrew
|
=
|
heb |
|
Hieratic
|
=
|
egy |
|
Hieroglyphic
|
=
|
egy |
|
Italian
|
=
|
ita |
|
Middle Persian
|
=
|
pal |
|
Parthian
|
=
|
ira |
|
Syriac
|
=
|
syr |
|
|
#4
Title Statement (cu245ab) Creation
NB: Yale records lack a Title element; a title must be constructed
from the Genre element if present.
- Create cu245ab title statement by combining two Yale fields:
GEN "Contract"
DTE "Roman-Byzantine [RD]"
into a single cu245ab field,
inserting comma+space ahead of Yale DTE data if present,.as follows:
"cu245ab | 1 | Contract, Roman-Byzantine [RD]"
- If there is no GEN field, create substitute title with content
"Uncertain genre" as follows:
"cu245ab | 1 | Uncertain genre"
|
#5.
Image Links
Yale image links as received were combined into a single
"ThumbImb" field, e.g.,
<img src="/papyrimg/T4512565.JPG" alt="[2016 (A)]">
<A HREF="/papyrimg/S4512565.JPG">Screen</A>
<A HREF="/papyrimg/Z4512565.JPG">Zoom</A>
<img src="/papyrimg/T4512566.JPG" alt="[2016 (B)]">
<A HREF="/papyrimg/S4512566.JPG">Screen</A>
<A HREF="/papyrimg/Z4512566.JPG">Zoom
These were converted to the cu APIS Interface Format as:
part_view_CAPTION | 1 | [2016 (A)]
presentation_RESOLUTION | 1 | 1 | thumbnail
presentation_ADDRESS | 1 | 1 | http://inky.library.yale.edu/papyrimg/T4512565.JPG
presentation_RESOLUTION | 1 | 2 | Screen
presentation_ADDRESS | 1 | 2 | http://inky.library.yale.edu/papyrimg/S4512565.JPG
presentation_RESOLUTION | 1 | 3 | Zoom
presentation_ADDRESS | 1 | 3 | http://inky.library.yale.edu/papyrimg/Z4512565.JPG
part_view_CAPTION | 2 | [2016 (B)]
presentation_RESOLUTION | 2 | 1 | thumbnail
presentation_ADDRESS | 2 | 1 | http://inky.library.yale.edu/papyrimg/T4512566.JPG
presentation_RESOLUTION | 2 | 2 | Screen
presentation_ADDRESS | 2 | 2 | http://inky.library.yale.edu/papyrimg/S4512566.JPG
presentation_RESOLUTION | 2 | 3 | Zoom
presentation_ADDRESS | 2 | 3 | http://inky.library.yale.edu/papyrimg/Z4512566.JPG
|
|
#6: Creation of cu655 field
Most Yale records have no form-type genre headings, e.g., "papyri",
"wood tablets". This data is instead found in the
COL field, e.g.,
Paper, 90 x 49 mm, (A) 6 lines, no margins, (B) 4 (?) lines,
no margins
Create a new "cu655" field from the content of the Yale
COL field as follows:
|
Yale COL Field begins:
|
|
cu655 field |
|
Banana leaf
|
=
|
Banana leaves |
|
Bronze tablet
|
=
|
Bronze tablets |
|
Fragments
|
=
|
Papyri, fragments |
|
Lead tablet
|
=
|
Lead tablets |
|
Leather
|
=
|
Leather |
|
Matched ...
|
=
|
Papyri, fragments |
|
Missing ...
|
=
|
Papyri |
|
Paper
|
=
|
Paper |
|
Palm
|
=
|
Palm |
|
Parchment
|
=
|
Parchment |
|
Seal
|
=
|
Seals |
|
Set aside, Parchment
|
=
|
Parchment |
|
Set aside ...
|
=
|
Papyri |
|
Stylus
|
=
|
Styli |
|
Wax tablet
|
=
|
Wax tablets |
|
Waxed tablet
|
=
|
Wax tablets |
|
Wood
|
=
|
Wood |
|
Wooden tablet
|
=
|
Wooden tablets |
|
[any other data]
|
=
|
Papyri |
|
|
#7: cuDate1 / cuDate2
Because there are no normalized date fields in the Yale records,
it is necessary to create cuDate1 and cuDate2 fields by detailed
scanning & evaluation of the Yale DTE field, e.g.,
| YALE DTE |
cuDate1 |
cuDate2 |
| Roman-Byzantine-Medieval CE vi-viii [?] |
500 |
799 |
In some cases date fields were manually assigned, something that
would also be required in any subsequent reload from a new Yale
file. See also: detailed (FileMaker Pro)
scripts for Yale date conversions.
|
|