<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">
Hi Mark,</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">
It's possible, but I believe it requires adding properties to the user_defined table in the database, which puts you at risk of problems whenever a new ArchivesSpace release requires database migrations. -k<br>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Mark Cyzyk
<mcyzyk@gmail.com><br>
<b>Sent:</b> Tuesday, August 8, 2023 9:32 AM<br>
<b>To:</b> Joshua D. Shaw <Joshua.D.Shaw@dartmouth.edu>; Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org>; jesse.martinez@bc.edu <jesse.martinez@bc.edu><br>
<b>Cc:</b> mcyzyk@jhu.edu <mcyzyk@jhu.edu><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] ASpace 3.4.0 and new ILMS Bib Number length</font>
<div> </div>
</div>
<div>A follow up question: <br>
<br>
Are the total number of User Defined Fields hard-coded, or open-ended? I.e. and E.g., in /locales/en.yml there is<br>
<br>
<blockquote>string_1<br>
string_2<br>
string_3<br>
string_4<br>
</blockquote>
<br>
and in our implementation, all of them are in use!<br>
<br>
Can I simply create a "string_5"?<br>
<br>
I'm sensing I cannot. But is this true?<br>
<br>
Mark<br>
<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 class="x_moz-txt-link-abbreviated" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a>
Verba volant, scripta manent.
</pre>
<div class="x_moz-cite-prefix">On 8/7/23 11:24, Joshua D. Shaw wrote:<br>
</div>
<blockquote type="cite"><style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div class="x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Agreed. This also seems like an arbitrary limitation in the schema.</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)">
jds<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b>
<a class="x_moz-txt-link-abbreviated" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <a class="x_moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
<archivesspace_users_group-bounces@lyralists.lyrasis.org></a> on behalf of Jesse Martinez
<a class="x_moz-txt-link-rfc2396E" href="mailto:jesse.martinez@bc.edu"><jesse.martinez@bc.edu></a><br>
<b>Sent:</b> Monday, August 7, 2023 11:18 AM<br>
<b>To:</b> Archivesspace Users Group <a class="x_moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group@lyralists.lyrasis.org">
<archivesspace_users_group@lyralists.lyrasis.org></a><br>
<b>Cc:</b> <a class="x_moz-txt-link-abbreviated" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a>
<a class="x_moz-txt-link-rfc2396E" 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</font>
<div> </div>
</div>
<div>
<div dir="ltr">I think this would be a good candidate for a bug report since it's causing data retention issues.
<div><br>
</div>
<div>Jesse</div>
</div>
<br>
<div class="x_x_gmail_quote">
<div dir="ltr" class="x_x_gmail_attr">On Mon, Aug 7, 2023 at 10:55 AM Joshua D. Shaw <<a href="mailto:Joshua.D.Shaw@dartmouth.edu" class="x_moz-txt-link-freetext">Joshua.D.Shaw@dartmouth.edu</a>> wrote:<br>
</div>
<blockquote class="x_x_gmail_quote" style="margin:0px 0px 0px
0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div class="x_x_msg8368433930541107935">
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
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)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
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)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
schema_overrides</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span> </span>/schemas</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<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)">
<span><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span>with contents like</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span>{<br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span> "real_1" => {"type" => "string", "maxlength" => 40, "required" => false},
<div> "real_2" => {"type" => "string", "maxlength" => 40, "required" => false},</div>
"real_3" => {"type" => "string", "maxlength" => 40, "required" => false}<br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
}</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
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)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
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)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Joshua<br>
</div>
<hr style="display:inline-block; width:98%">
<div id="x_x_m_8368433930541107935divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt; color:rgb(0,0,0)"><b>From:</b> Mark Cyzyk <<a href="mailto:mcyzyk@gmail.com" target="_blank" class="x_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" class="x_moz-txt-link-freetext">Joshua.D.Shaw@dartmouth.edu</a>>;
<a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a> <<a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a>>; Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank" class="x_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</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; float:none; color:rgb(29,28,29); background-color:rgb(255,255,255); display:inline">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; float:none; color:rgb(29,28,29); background-color:rgb(255,255,255); display:inline"></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; float:none; color:rgb(29,28,29); background-color:rgb(255,255,255); display:inline"><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; float:none; color:rgb(29,28,29); background-color:rgb(255,255,255); display:inline">"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; float:none; color:rgb(29,28,29); background-color:rgb(255,255,255); display:inline"></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; float:none; color:rgb(29,28,29); background-color:rgb(255,255,255); display:inline"><br>
Any way to convert to varchar text string without data loss?<br>
<br>
Mark<br>
</span>
<pre 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" id="x_x_m_8368433930541107935OWAedb00dfb-bb12-7e4a-276d-c087a982a393" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a>
Verba volant, scripta manent.
</pre>
<div>On 8/7/23 07:48, Joshua D. Shaw wrote:<br>
</div>
<blockquote type="cite">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Hi Mark</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div 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 style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
What issue are you seeing?<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div 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 style="display:inline-block; width:98%">
<div id="x_x_m_8368433930541107935x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt; color:rgb(0,0,0)"><b>From:</b>
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" id="x_x_m_8368433930541107935OWAc554f626-f2d8-01fe-fde7-1e79ad922d0b" target="_blank" class="x_moz-txt-link-freetext">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" id="x_x_m_8368433930541107935OWAf8eb3d39-7a43-f4f7-7612-112342330779" target="_blank">
<archivesspace_users_group-bounces@lyralists.lyrasis.org></a> on behalf of Mark Cyzyk
<a href="mailto:mcyzyk@gmail.com" id="x_x_m_8368433930541107935OWA685298c3-2a2b-0049-5dca-5c08311dd3e6" target="_blank">
<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" id="x_x_m_8368433930541107935OWAe4a38bcc-0def-d69f-c8b4-d63b53ff3cea" target="_blank">
<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><font size="2"><span style="font-size:11pt">
<div><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" id="x_x_m_8368433930541107935OWA202114af-18de-a2d7-4fa4-58899686a546" target="_blank" class="x_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" id="x_x_m_8368433930541107935OWAa812ee17-b026-7114-2023-6aa255dad02c" target="_blank" class="x_moz-txt-link-freetext">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" originalsrc="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" shash="GkZyXAsDi7unZtwbmcInD3nGUoCyBomjnHeYl17TuApuvwW32ciycZx9I7kNz8+ZQgiRKRYKgdRy/rd6n6+H+WlQB1RWX82e71Kdtuug/kvTxz0pPzG+dBECY3GDkeE6w+kEtnIfc5sdJRxoliHN9pp2uqbE2FKqp4UhzvxzMCs=" originalsrc="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" shash="Uj8VFu3FLpofcTr90rFcmW5IiZp7TZna2N5WWJXHFUbnC0tkHWAV5+aWmvNI+KRiqAkdHgp8YBpOwRcVfID3cN472A0+RVbQa6FfBKjqiSiAllg0gexZUUHAzq1+/AOs0SAABOOKylhlfYhfenqTF3/F96U/udXQywJG61UeRTo=" id="x_x_m_8368433930541107935OWA9c22fcc5-16b3-a61b-bbd8-85c46d2d7a7f" target="_blank">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>
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank" class="x_moz-txt-link-freetext">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" originalsrc="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" shash="CwgHdlvZJpn5XduyPBKgHfrFr0olNJTgKOTxFG53fdHaFMaI+RHh9uJjXL59axQQ9bkP+gaHRnbzF+da7Vn3TYfywmQrmeAcVftAgOvi52n3ho8dPz3/dqpLYKrsf0CjGVJQqGueQEqJ43lj+Vc/2MzrKECfpuBcDHx5Ee+exSA=" originalsrc="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" shash="AmSPLLC+RygXD8LHOHhtRn9qPbyOckqECDr0ea02KgO5h6TxyaC4aSLFJdjNy1H9sjzM6wIe4/k5J+3gw5M9JYxoytwrWNlGYu4hfvD++hP4DA1Mj5Q0LDOvIsY6mY7hioPFLjK5le84zpcuYQ+CX7bRmBAyQiwnYlI885gn2rY=" rel="noreferrer" target="_blank" class="x_moz-txt-link-freetext">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
<span class="x_x_gmail_signature_prefix">-- </span><br>
<div dir="ltr" class="x_x_gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div>Jesse Martinez<br>
</div>
<div>Senior Library Applications Developer</div>
<div>O'Neill Library, Boston College</div>
<div><a href="mailto:jesse.martinez@bc.edu" target="_blank" class="x_moz-txt-link-freetext">jesse.martinez@bc.edu</a></div>
<div>617-552-2509</div>
<div>he/him/his</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
</div>
</body>
</html>