<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<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="color: rgb(29, 28, 29); 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; orphans: 2; text-align: left;
text-indent: 0px; text-transform: none; widows: 2; word-spacing:
0px; -webkit-text-stroke-width: 0px; white-space: normal;
background-color: rgb(255, 255, 255); text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial; display: inline !important; float: none;">991036635839707861</span><br>
<span style="color: rgb(29, 28, 29); 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; orphans: 2; text-align: left; text-indent: 0px;
text-transform: none; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; white-space: normal;
background-color: rgb(255, 255, 255); text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial; display: inline !important; float: none;"></span></blockquote>
<span style="color: rgb(29, 28, 29); 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; orphans: 2; text-align: left; text-indent: 0px;
text-transform: none; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; white-space: normal;
background-color: rgb(255, 255, 255); text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial; display: inline !important; float: none;"><br>
Error when submitting:<br>
<br>
</span>
<blockquote><span style="color: rgb(29, 28, 29); 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; orphans: 2; text-align: left;
text-indent: 0px; text-transform: none; widows: 2; word-spacing:
0px; -webkit-text-stroke-width: 0px; white-space: normal;
background-color: rgb(255, 255, 255); text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial; display: inline !important; float: none;">"Bib Number -
Must be a number with no more than nine digits and five decimal
places"</span><br>
<span style="color: rgb(29, 28, 29); 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; orphans: 2; text-align: left; text-indent: 0px;
text-transform: none; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; white-space: normal;
background-color: rgb(255, 255, 255); text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial; display: inline !important; float: none;"></span></blockquote>
<span style="color: rgb(29, 28, 29); 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; orphans: 2; text-align: left; text-indent: 0px;
text-transform: none; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; white-space: normal;
background-color: rgb(255, 255, 255); text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial; display: inline !important; float: none;"><br>
Any way to convert to varchar text string without data loss?<br>
<br>
Mark<br>
</span>
<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>
Verba volant, scripta manent.
</pre>
<div class="moz-cite-prefix">On 8/7/23 07:48, Joshua D. Shaw wrote:<br>
</div>
<blockquote type="cite"
cite="mid:BL0PR03MB429284ABA75A9D6145653B90AB0CA@BL0PR03MB4292.namprd03.prod.outlook.com">
<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>
<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">
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);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
What issue are you seeing?<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">
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="divRplyFwdMsg" dir="ltr"><font style="font-size: 11pt;
color: rgb(0, 0, 0);" face="Calibri, sans-serif"><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>
on behalf of Mark Cyzyk <a class="moz-txt-link-rfc2396E" href="mailto:mcyzyk@gmail.com"><mcyzyk@gmail.com></a><br>
<b>Sent:</b> Sunday, August 6, 2023 12:56 PM<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><br>
<b>Subject:</b> [Archivesspace_Users_Group] ASpace 3.4.0 and
new ILMS Bib Number length</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span
style="font-size:11pt">
<div class="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 class="moz-txt-link-abbreviated" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a><br>
<br>
Verba volant, scripta manent.<br>
<br>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a
href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group"
data-auth="NotApplicable"
id="OWAd7988869-edb4-7d01-bfc2-fb83cee5db5b"
class="OWAAutoLink" 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><br>
</div>
</span></font></div>
</blockquote>
<br>
</body>
</html>