<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#1F497D">Please read below and let me know what you think as soon as you can. Mariella<o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#1F497D"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Soprano, Maria (Mariella)
<br>
<b>Sent:</b> Friday, November 14, 2014 6:36 AM<br>
<b>To:</b> ArchivesSpace<br>
<b>Subject:</b> Fwd: Caltech's FileMaker to ArchivesSpace migration<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">It sounds very useful. Tommy and Ian, would you like to consider this before we call Glenn? Please let me know asap.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Mariella <br>
<br>
Sent from my iPad<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
Begin forwarded message:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><b>From:</b> "Nathan Stevens" <<a href="mailto:ns96@nyu.edu">ns96@nyu.edu</a>><br>
<b>To:</b> "Ian Roberts" <<a href="mailto:ian@library.caltech.edu">ian@library.caltech.edu</a>><br>
<b>Cc:</b> "Soprano, Maria (Mariella)" <<a href="mailto:mariella@caltech.edu">mariella@caltech.edu</a>>, "Brad Westbrook" <<a href="mailto:brad.westbrook@lyrasis.org">brad.westbrook@lyrasis.org</a>><br>
<b>Subject:</b> <b>Re: Caltech's FileMaker to ArchivesSpace migration</b><o:p></o:p></p>
</div>
</blockquote>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi All, <br>
<br>
I finally had a chance to test out importing of the excel file provided using the ASpace Migration Tool (<a href="https://github.com/ns96/ASpaceMigrator">https://github.com/ns96/ASpaceMigrator</a>).
<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">The Migrator Tool was updated to pre-process the excel file to merge the rows, and I also had to make a minor modification to the excel file (see attached) to allow scripts to work. The format of column A need
to be change to Text.<o:p></o:p></p>
</div>
<p class="MsoNormal">Take a look at the sample mapper script and if there is further interest to work with the Migrator Tool we can setup a quick Skype to quickly run through the technical details.
<br>
<br>
Ideally, if one of the team member is familiar with Java/Javascript, it shouldn't be too hard to review the program code and script to see how to modify it to import the entire accession records.
<br>
<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">I am also attaching an ASpace v1.1.0 database dump for you to take a quick look at the migrated sample records.<o:p></o:p></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal">In any case, based on your overall migration requirements it might be worth while to invest the time in learning to employ the Data Migration tool. However, If it's just Accession records being considered for import, then you probable
better of continuing on the current path. <o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Tue, Nov 11, 2014 at 11:35 AM, Nathan Stevens <<a href="mailto:ns96@nyu.edu" target="_blank">ns96@nyu.edu</a>> wrote:<o:p></o:p></p>
<div>
<p class="MsoNormal">Not has yet, hopefully by the end of the week.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Tue, Oct 28, 2014 at 7:03 PM, Ian Roberts <<a href="mailto:ian@library.caltech.edu" target="_blank">ian@library.caltech.edu</a>> wrote:<o:p></o:p></p>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Nathan-<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Here is the map and the last export I ran from FileMaker. I left out a number of fields that will not be relevant (internal FM references, patron use info, etc.), but this should
cover what we expect to get into the Accession.CSV, and it may need to be pared down a bit more after a final review of the mapping spreadsheet.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">To create the Accession Number and get a reasonably reliable accession date I have been working with the following process in Excel:<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Insert three columns labeled:<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">accession_number_1<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">accession_number_2<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">accession_accession_date<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">To get the accession_accession_date I run a pair of =IF(ISBLANK formulas. The first is to get either the Acquisitions by Item ID:Date if there is one, otherwise drop in the Date
Record Created value, and the second one (run in the accession_accession_date column) will pick up either the better of those date, or if they are both lacking, we roll back to the Date Record Modified. This should result in a date for every record, with preference
given to the most accurate date available. The results are formatted to display in the YYYY-MM-DD format.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">accession_number_1 is generated from a formula to pull the year from the accession date.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">accession_number_2 uses a COUNTIF formula on accession_number_1, giving us a running count for each year, and formatted to display as 5 digits<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">ex: 1987.00021<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">For previous tests I then copied these columns and pasted the values over them (so I could trim out the other columns without losing any info), and consulted the mapping file to
rename the remaining columns to be used. I have mostly been doing limited tests with specific fields, not using all possible columns at once.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Please let me know if there is anything else I can pass along, and thanks for looking into this!<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">-Ian<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Ian Roberts<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Caltech Library<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a href="tel:626-395-6429" target="_blank">626-395-6429</a><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a href="mailto:ian@library.caltech.edu" target="_blank">ian@library.caltech.edu</a><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<br>
-- <o:p></o:p></p>
<div>
<p class="MsoNormal">Nathan Stevens<br>
Programmer/Analyst<br>
Digital Library Technology Services<br>
New York University<br>
<br>
<a href="tel:1212-998-2653" target="_blank">1212-998-2653</a><br>
<a href="mailto:ns96@nyu.edu" target="_blank">ns96@nyu.edu</a><o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<br>
-- <o:p></o:p></p>
<div>
<p class="MsoNormal">Nathan Stevens<br>
Programmer/Analyst<br>
Digital Library Technology Services<br>
New York University<br>
<br>
1212-998-2653<br>
<a href="mailto:ns96@nyu.edu" target="_blank">ns96@nyu.edu</a><o:p></o:p></p>
</div>
</div>
</div>
</blockquote>
</div>
</body>
</html>