<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<br>
Thanks, Kate,<br>
<br>
Yes, indeed -- we just switched to Alma, so those are Alma IDs.<br>
<br>
I'm thinking I need to create a new User Defined Field for this, as
you suggest.<br>
<br>
(Our old Bib IDs remain part of the record in Alma, so we'll retain
them here in ASpace in the hitherto problematic legacy field....)<br>
<br>
Appreciatively,<br>
<br>
Mark<br>
<br>
<pre class="moz-signature" cols="72"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
<a class="moz-txt-link-abbreviated" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a>
</pre>
<div class="moz-cite-prefix">On 8/7/23 1:10 PM, Bowers, Kate A.
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:BL3PR07MB885151E4338FC10B9503EBAE800CA@BL3PR07MB8851.namprd07.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;}span.xgmailsignatureprefix
{mso-style-name:x_gmail_signature_prefix;}span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}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]-->
<div class="WordSection1">
<p class="MsoNormal">Since these look like Alma MMSIDs, I’d
advise that you move them to a text user-defined field rather
than a number field. I say this as someone who works with Alma
MMSIDs and external systems a lot.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Kate<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b>
<a class="moz-txt-link-abbreviated" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>
<a class="moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"><archivesspace_users_group-bounces@lyralists.lyrasis.org></a>
<b>On Behalf Of </b>Joshua D. Shaw<br>
<b>Sent:</b> Monday, August 7, 2023 11:24 AM<br>
<b>To:</b> Archivesspace Users Group
<a class="moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group@lyralists.lyrasis.org"><archivesspace_users_group@lyralists.lyrasis.org></a>;
<a class="moz-txt-link-abbreviated" href="mailto:jesse.martinez@bc.edu">jesse.martinez@bc.edu</a><br>
<b>Cc:</b> <a class="moz-txt-link-abbreviated" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] ASpace
3.4.0 and new ILMS Bib Number length<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">Agreed. This also
seems like an arbitrary limitation in the schema.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">jds<o:p></o:p></span></p>
</div>
<div class="MsoNormal" style="text-align:center" align="center">
<hr width="98%" size="2" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span
style="color:black">
<a
href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"
moz-do-not-send="true" class="moz-txt-link-freetext">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>
<<a
href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"
moz-do-not-send="true" class="moz-txt-link-freetext">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of Jesse Martinez <<a
href="mailto:jesse.martinez@bc.edu"
moz-do-not-send="true" class="moz-txt-link-freetext">jesse.martinez@bc.edu</a>><br>
<b>Sent:</b> Monday, August 7, 2023 11:18 AM<br>
<b>To:</b> Archivesspace Users Group <<a
href="mailto:archivesspace_users_group@lyralists.lyrasis.org"
moz-do-not-send="true" class="moz-txt-link-freetext">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Cc:</b> <a href="mailto:mcyzyk@jhu.edu"
moz-do-not-send="true" class="moz-txt-link-freetext">mcyzyk@jhu.edu</a>
<<a href="mailto:mcyzyk@jhu.edu" moz-do-not-send="true"
class="moz-txt-link-freetext">mcyzyk@jhu.edu</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] ASpace
3.4.0 and new ILMS Bib Number length</span>
<o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">I think this would be a good candidate
for a bug report since it's causing data retention
issues.
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Jesse<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Mon, Aug 7, 2023 at 10:55 AM
Joshua D. Shaw <<a
href="mailto:Joshua.D.Shaw@dartmouth.edu"
moz-do-not-send="true" class="moz-txt-link-freetext">Joshua.D.Shaw@dartmouth.edu</a>>
wrote:<o:p></o:p></p>
</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>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">Oh. Uggghh.
I see the issue. Even though the DB defines the
field as a varchar, the schema defines a
maxlength of 13 characters.
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">You <b>might
be able</b> to override that in a simple
plugin. Something like<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">schema_overrides<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black"> /schemas<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black"> user_defined_ext.rb<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">with
contents like<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">{<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">
"real_1" => {"type" => "string",
"maxlength" => 40, "required" => false},
<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">
"real_2" => {"type" => "string",
"maxlength" => 40, "required" => false},<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">
"real_3" => {"type" => "string",
"maxlength" => 40, "required" => false}<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">}<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">Though I
haven't tried overriding the base schema in that
way.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">Alternatively
(and probably better), you could alter the db
itself by updating the affected rows in the
user_defined table - either directly or with a
migration update in a plugin. You'd want to move
the data from the real_1, real_2, real_3 columns
to string_1, string_2, string_3 columns AND
update the user_mtime column to trigger any
index updates.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">Joshua<o:p></o:p></span></p>
</div>
<div class="MsoNormal" style="text-align:center"
align="center">
<hr width="98%" size="2" align="center">
</div>
<div id="x_m_8368433930541107935divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span
style="color:black"> Mark Cyzyk <<a
href="mailto:mcyzyk@gmail.com" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">mcyzyk@gmail.com</a>><br>
<b>Sent:</b> Monday, August 7, 2023 9:36 AM<br>
<b>To:</b> Joshua D. Shaw <<a
href="mailto:Joshua.D.Shaw@dartmouth.edu"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">Joshua.D.Shaw@dartmouth.edu</a>>;
<a href="mailto:mcyzyk@jhu.edu" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">mcyzyk@jhu.edu</a>
<<a href="mailto:mcyzyk@jhu.edu"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">mcyzyk@jhu.edu</a>>;
Archivesspace Users Group <<a
href="mailto:archivesspace_users_group@lyralists.lyrasis.org"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group]
ASpace 3.4.0 and new ILMS Bib Number length</span>
<o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
Thanks, Joshua,<br>
<br>
I think the issue here is that the DB is storing
our Bib "Numbers" as numbers, not text strings.<br>
<br>
Our new Bib Number format:<o:p></o:p></p>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="font-size:11.5pt;font-family:"Arial",sans-serif;color:#1D1C1D;background:white">991036635839707861</span><br>
<br>
<o:p></o:p></p>
</blockquote>
<p class="MsoNormal"><span
style="font-size:11.5pt;font-family:"Arial",sans-serif;color:#1D1C1D;background:white"><br>
Error when submitting:<br>
<br>
<br>
</span><o:p></o:p></p>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="font-size:11.5pt;font-family:"Arial",sans-serif;color:#1D1C1D;background:white">"Bib
Number - Must be a number with no more than
nine digits and five decimal places"</span><br>
<br>
<o:p></o:p></p>
</blockquote>
<p class="MsoNormal"><span
style="font-size:11.5pt;font-family:"Arial",sans-serif;color:#1D1C1D;background:white"><br>
Any way to convert to varchar text string
without data loss?<br>
<br>
Mark<br>
<br>
</span><o:p></o:p></p>
<pre><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><o:p> </o:p></pre>
<pre>Mark Cyzyk, M.A., M.L.S.<o:p></o:p></pre>
<pre>Library Applications Group<o:p></o:p></pre>
<pre>The Sheridan Libraries<o:p></o:p></pre>
<pre>The Johns Hopkins University<o:p></o:p></pre>
<pre><a href="mailto:mcyzyk@jhu.edu" target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">mcyzyk@jhu.edu</a><o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Verba volant, scripta manent. <o:p></o:p></pre>
<div>
<p class="MsoNormal">On 8/7/23 07:48, Joshua D.
Shaw wrote:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">Hi Mark<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">The
fields are defined in the db (via the
migrations). The real_x fields (and
integer_x and string_x fields) in
user_defined are varchars, so any limits
you're hitting aren't in the db. There's
also nothing in the plugin that would limit
the field lengths - unless you've customized
the plugin.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">What
issue are you seeing?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">Joshua<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div class="MsoNormal" style="text-align:center"
align="center">
<hr width="98%" size="2" align="center">
</div>
<div id="x_m_8368433930541107935x_divRplyFwdMsg">
<p class="MsoNormal"><b><span
style="color:black">From:</span></b><span
style="color:black">
<a
href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <a
href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"
target="_blank" moz-do-not-send="true">
<archivesspace_users_group-bounces@lyralists.lyrasis.org></a> on
behalf of Mark Cyzyk
<a href="mailto:mcyzyk@gmail.com"
target="_blank" moz-do-not-send="true"><mcyzyk@gmail.com></a><br>
<b>Sent:</b> Sunday, August 6, 2023 12:56 PM<br>
<b>To:</b> Archivesspace Users Group <a
href="mailto:archivesspace_users_group@lyralists.lyrasis.org"
target="_blank" moz-do-not-send="true">
<archivesspace_users_group@lyralists.lyrasis.org></a><br>
<b>Subject:</b> [Archivesspace_Users_Group]
ASpace 3.4.0 and new ILMS Bib Number length</span>
<o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"><br>
All,<br>
<br>
We recently upgraded to ASpace 3.4.0.
Everything is fine except for one <br>
thing:<br>
<br>
Insofar as we also recently migrated our
ILMS here, our Bib Numbers are <br>
now larger strings than before. They are
now 18 characters.<br>
<br>
How/where can I Up this field length? I've
looked in the various <br>
Locales files.<br>
<br>
As far as I can tell, Bib Number is in the <br>
resource_user_defined__real_1_ field, but
I'm not finding where the <br>
length of that field is limited.<br>
<br>
FYI, we are using the User Defined in Basic
plugin.<br>
<br>
Advice appreciated,<br>
<br>
Mark<br>
<br>
-- <br>
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><br>
Mark Cyzyk, M.A., M.L.S.<br>
Library Applications Group<br>
The Sheridan Libraries<br>
The Johns Hopkins University<br>
<a href="mailto:mcyzyk@jhu.edu"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">mcyzyk@jhu.edu</a><br>
<br>
Verba volant, scripta manent.<br>
<br>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a
href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a
href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=wwc_Z_TbmWbPFh7My2zRxmrGgCNO-71Fwzlmd8YZVUY&m=75PRFa6qLGdwxTUpMyaaU8jO9t3Vf_MHSM1LBcZdHXFmEJu6Fceoyfu5g0wNH95S&s=A5Z4iyoi-ozAiMXEjHqPTeTKHZ_3lLOJrMp8rqebHTg&e="
target="_blank" moz-do-not-send="true">https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=05%7C01%7Cjoshua.d.shaw%40dartmouth.edu%7Cba1914ced54d4d68822308db969e1237%7C995b093648d640e5a31ebf689ec9446f%7C0%7C0%7C638269377900220240%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=eTkrkrzpzmF%2BqHUamRGO0KT2uyhBVl1CYI2eRY0OxGg%3D&reserved=0</a><o:p></o:p></p>
</div>
</div>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a
href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a
href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=wwc_Z_TbmWbPFh7My2zRxmrGgCNO-71Fwzlmd8YZVUY&m=75PRFa6qLGdwxTUpMyaaU8jO9t3Vf_MHSM1LBcZdHXFmEJu6Fceoyfu5g0wNH95S&s=A5Z4iyoi-ozAiMXEjHqPTeTKHZ_3lLOJrMp8rqebHTg&e="
target="_blank" moz-do-not-send="true">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><span class="xgmailsignatureprefix">-- </span><o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Jesse Martinez<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Senior Library
Applications Developer<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">O'Neill Library, Boston
College<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a
href="mailto:jesse.martinez@bc.edu"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">jesse.martinez@bc.edu</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">617-552-2509<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">he/him/his<o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>