<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Oh. Uggghh. I see the issue. Even though the DB defines the field as a varchar, the schema defines a maxlength of 13 characters.
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
You <b>might be able</b> to override that in a simple plugin. Something like</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
schema_overrides</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span> </span>/schemas</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span> <span> </span>user_defined_ext.rb</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span>with contents like</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span>{<br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span class="ContentPasted0"> "real_1" => {"type" => "string", "maxlength" => 40, "required" => false},
<div class="ContentPasted0"> "real_2" => {"type" => "string", "maxlength" => 40, "required" => false},</div>
"real_3" => {"type" => "string", "maxlength" => 40, "required" => false}<br>
</span></div>
<div id="appendonsend"></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
}</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Though I haven't tried overriding the base schema in that way.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
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.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Joshua<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size: 11pt; color: rgb(0, 0, 0);" face="Calibri, sans-serif"><b>From:</b> Mark Cyzyk <mcyzyk@gmail.com><br>
<b>Sent:</b> Monday, August 7, 2023 9:36 AM<br>
<b>To:</b> Joshua D. Shaw <Joshua.D.Shaw@dartmouth.edu>; mcyzyk@jhu.edu <mcyzyk@jhu.edu>; Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] ASpace 3.4.0 and new ILMS Bib Number length</font>
<div> </div>
</div>
<div><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:<br>
<br>
<blockquote><span style="font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: left; text-indent: 0px; text-transform: none; word-spacing: 0px; white-space: normal; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none; color: rgb(29, 28, 29); background-color: rgb(255, 255, 255);">991036635839707861</span><br>
<span style="font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: left; text-indent: 0px; text-transform: none; word-spacing: 0px; white-space: normal; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none; color: rgb(29, 28, 29); background-color: rgb(255, 255, 255);"></span></blockquote>
<span style="font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: left; text-indent: 0px; text-transform: none; word-spacing: 0px; white-space: normal; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none; color: rgb(29, 28, 29); background-color: rgb(255, 255, 255);"><br>
Error when submitting:<br>
<br>
</span>
<blockquote><span style="font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: left; text-indent: 0px; text-transform: none; word-spacing: 0px; white-space: normal; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none; color: rgb(29, 28, 29); background-color: rgb(255, 255, 255);">"Bib
Number - Must be a number with no more than nine digits and five decimal places"</span><br>
<span style="font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: left; text-indent: 0px; text-transform: none; word-spacing: 0px; white-space: normal; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none; color: rgb(29, 28, 29); background-color: rgb(255, 255, 255);"></span></blockquote>
<span style="font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: left; text-indent: 0px; text-transform: none; word-spacing: 0px; white-space: normal; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none; color: rgb(29, 28, 29); background-color: rgb(255, 255, 255);"><br>
Any way to convert to varchar text string without data loss?<br>
<br>
Mark<br>
</span>
<pre class="x_moz-signature" cols="72"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
<a href="mailto:mcyzyk@jhu.edu" class="x_moz-txt-link-abbreviated OWAAutoLink" id="OWAedb00dfb-bb12-7e4a-276d-c087a982a393" data-loopstyle="linkonly">mcyzyk@jhu.edu</a>
Verba volant, scripta manent.
</pre>
<div class="x_moz-cite-prefix">On 8/7/23 07:48, Joshua D. Shaw wrote:<br>
</div>
<blockquote type="cite">
<div class="x_elementToProof" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi Mark</div>
<div class="x_elementToProof" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="x_elementToProof" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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.</div>
<div class="x_elementToProof" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="x_elementToProof" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
What issue are you seeing?<br>
</div>
<div class="x_elementToProof" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="x_elementToProof" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Joshua<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font style="font-size: 11pt; color: rgb(0, 0, 0);" face="Calibri, sans-serif"><b>From:</b>
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="x_moz-txt-link-abbreviated OWAAutoLink" id="OWAc554f626-f2d8-01fe-fde7-1e79ad922d0b" data-loopstyle="linkonly">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="x_moz-txt-link-rfc2396E OWAAutoLink" id="OWAf8eb3d39-7a43-f4f7-7612-112342330779" data-loopstyle="linkonly">
<archivesspace_users_group-bounces@lyralists.lyrasis.org></a> on behalf of Mark Cyzyk
<a href="mailto:mcyzyk@gmail.com" class="x_moz-txt-link-rfc2396E OWAAutoLink" id="OWA685298c3-2a2b-0049-5dca-5c08311dd3e6" data-loopstyle="linkonly">
<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" class="x_moz-txt-link-rfc2396E OWAAutoLink" id="OWAe4a38bcc-0def-d69f-c8b4-d63b53ff3cea" data-loopstyle="linkonly">
<archivesspace_users_group@lyralists.lyrasis.org></a><br>
<b>Subject:</b> [Archivesspace_Users_Group] ASpace 3.4.0 and new ILMS Bib Number length</font>
<div> </div>
</div>
<div class="x_BodyFragment"><font size="2"><span style="font-size:11pt">
<div class="x_PlainText"><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" class="x_moz-txt-link-abbreviated OWAAutoLink" id="OWA202114af-18de-a2d7-4fa4-58899686a546" data-loopstyle="linkonly">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" class="x_moz-txt-link-abbreviated OWAAutoLink" id="OWAa812ee17-b026-7114-2023-6aa255dad02c" data-loopstyle="linkonly">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" data-auth="Verified" originalsrc="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" shash="p/sgh9uA/poaEjtf5y6OgPMsMrqPTVDaZ5AxXRMubJwMeUNK/IVex01yieJo6rxWiA+dRf6dM4Nq6UCFg30UweHcNUdo3r24rctGiGODCSMzhguL3nYSLAcMd9VybfMFBy15kEALuC+P/CnfoaFz4m7YzwUX7PPZOjJI8M8CeEI=" id="OWA9c22fcc5-16b3-a61b-bbd8-85c46d2d7a7f" class="x_OWAAutoLink" data-loopstyle="linkonly">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><br>
</div>
</span></font></div>
</blockquote>
<br>
</div>
</body>
</html>