David:

90% of the Michigan metadata conversion is complete; I've put some files up 
on cunix so you can
begin testing the data load.  I'll try to provide an updated "final" 
version later today.  Note
that because I'm not using the standard "CLIOCon" program I've used with 
earlier data, there
may be some variations in format & spacing that I've overlooked.  If you 
find any of these that
mess up the loader, let me know and I'll try to fix.

I've split the data into two parts: 1) descriptive metadata 2) structural 
metadata (aka
"holdings", "image links")

1) DESCRIPTIVE:  Because of the length of the descriptive metadata, I 
wasn't able to create
standard MMF interface format output.  Although the individual data 
elements are correctly
converted, the file "package" is one of a couple of the Filemaker Pro 
export formats:  either
tab-delimited or comma-delimited (which FMP calls "BAS[IC]" for some 
reason).  NB: These are
both "one record per line" formats and some of the line lengths are upward 
of 3200 characters.
I'm going to have to ask you to figure out how to get these into the MMF 
loader ... ;}

The test descriptive files are at:

http://www.columbia.edu/cu/libraries/inside/projects/apis/michigan/output/umich_test.BAS
http://www.columbia.edu/cu/libraries/inside/projects/apis/michigan/output/umich_test.TAB

Here's a (short) example of a FMP BAS formatted record.

"cu001 | 1 | michigan.apis.2223","cu035 | 1 | (MiU)2223","cu090 | 1 | 
P.Mich. inv.
4534",,"","[P.Mich. inv. 4534]","","","","","cu300 | 1 |  Wood","cu524 | 1 
| , 0","","cu510 | 2
| Youtie LC, PColl Youtie II 113, 1930 -- BL VII, 38","cu500 | 1 | Source 
of description:
4","","","","","cu500 | 11 | Youtie unaware of previous 
publication","","",,"cu541 | 1 |
1924/1925: purchased by Prof. Boak in 
Egypt","","","","","","","","","","","cu655 | 1 |
Wood","","","","","erc | 1 | spd1","rmail | 1 | spd1","rtype | 1 | 
n","parent | 1 | 3","status
| 1 | 1","perm_group | 1 | w"

Instead of the usual:

cu001 | 1 | michigan.apis.2223
cu035 | 1 | (MiU)2223
cu090 | 1 | P.Mich. inv. 4534
[etc.]

DESCRIPTIVE ELEMENTS STILL TO BE CONVERTED CONVERTED:  DDBDP link
(cu510_dd), cuDate1, cuDate2

2) STRUCTURAL: The structural metadata is in standard MMF Interface format, at:

http://www.columbia.edu/cu/libraries/inside/projects/apis/michigan/output/umich_holdings.txt

These records include the cu001 of the parallel descriptive metadata 
record, so they can be
matched up correctly for loading.

SOMETHING NEW:  Because of the number & complexity of the tiled images, 
I've only converted the
"full size" images.  To compensate for this, I've also constructed a direct 
link back to the
original Michigan record, so that researchers can click back to the full 
story.  The new field
is: cu510_m (m for Michigan) and--like the new cu510_dd (link to DDBDP)--it 
needs to be made
into a URL link in the interface.  I've included it in the STRUCTURAL 
metadata, but it's
actually a link to the entire description. Here's a sample:

cu510_m  | 1 |
http://www.hti.umich.edu/bin/apis-idx.pl?q1=14&rgn1=Anywhere&operator1=And&q2=&rgn2=Anywhere&op
erator2=And&q3=&type=boolean&size=First+100

The key parameter is "q1=" which references the Michigan "Processing 
Number" (which we use as
the basis for the apis number, FYI); I have no idea whether the other stuff 
is necessary, but
it works as currently formatted.

INTERFACE QUESTION:  If we can implement the new cu510_m field, so that 
people can jump to the
Michigan description from the APIS description, what should the interface 
display say?  E.g.,

	"Connect directly to U. Michigan description for more detail."

EXAMPLE OF MMF INTERFACE FORMAT STRUCTURAL METADATA

NB: I have generated the p/v_caption & presentation_resolution fields from 
the Mich. data
element definitions and image access specs.

XXX
cu001    | 1 | michigan.apis.14
cu510_m  | 1 | 
http://www.hti.umich.edu/bin/apis-idx.pl?q1=14&rgn1=Anywhere&operator1=And
&q2=&rgn2=Anywhere&operator2=And&q3=&type=boolean&size=First+100
part_view_CAPTION | 1 | Full size front R1
presentation_RESOLUTION | 1 | 1 | thumbnail
presentation_ADDRESS | 1 | 1 | 
http://www.hti.umich.edu/collaboratory/gagos/img/10248o-tn.gif
presentation_RESOLUTION | 1 | 2 | 50% size
presentation_ADDRESS | 1 | 2 | 
http://www.hti.umich.edu/collaboratory/gagos/img/10248o-50.jpg
presentation_RESOLUTION | 1 | 3 | full size
presentation_ADDRESS | 1 | 3 | 
http://www.hti.umich.edu/collaboratory/gagos/img/10248o.jpg