<div dir="ltr"><div>Paul-<br>If you are using the $i and it is linked in the maps and frameworks to items.stack, you may be having a problem since the stack field is a tinyint field and can't hold the data you are using.  You may want to consider using the stocknumber field in the items table.  I have been able to add data using the $j (stocknumber) field (through importing data- editing the items was not my priority in that particular usage).<br>
<br></div>Joy Nelson<br><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Oct 1, 2013 at 5:34 PM, Paul <span dir="ltr"><<a href="mailto:paul.a@aandc.org" target="_blank">paul.a@aandc.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Our cataloguers have asked for additional precision in specific stacks -- 952$j "Shelving control number" would appear to be perfect :=)<br>

<br>
However, any value entered (eg: LLF15 -- loose leaf folder #15) systematically saves as 0 and SchemaSpy doesn't appear to even mention this field which is in the "default template" with no apparent restrictions.<br>

<br>
Can anyone with good "corporate memory" of 952$j use and programming please assist?<br>
<br>
Many thanks and best regards -- Paul<br>
<br>
______________________________<u></u>_________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-<u></u>community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" target="_blank">http://lists.koha-community.<u></u>org/cgi-bin/mailman/listinfo/<u></u>koha-devel</a><br>
website : <a href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.<u></u>org/</a><br>
</blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr"><font color="#888888"><div>Joy Nelson<br></div><div>Director of Migrations<br><br></div><div><a href="http://bywatersolutions.com" target="_blank"><span style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">ByWater Solutions</span></a><span style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium;font-family:Helvetica"><span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-size:medium;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;font-size:medium;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><font color="#1e39f6" face="Calibri" size="3"><span style="font-size:12pt;font-family:Calibri"></span></font></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span><br>
<span style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Support and Consulting for Open Source Software<br></span><span style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:-webkit-auto;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-spacing:0px"><span style="border-collapse:separate;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-align:-webkit-auto;text-indent:0px"><span style="text-indent:0px"><span style="text-indent:0px"><span style="text-indent:0px"><span style="text-indent:0px"><span style="text-indent:0px"><span style="text-indent:0px"><span style="text-indent:0px"><span style="text-indent:0px"><span style="text-indent:0px"><font><font color="#1e39f6"><span style="font-size:16px"><b></b></span></font></font></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>Office: Fort Worth, TX<br>
Phone/Fax <a value="+18889008944" style="color:rgb(0,0,204)">(888)900-8944</a></span><br><span style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><a href="http://bywatersolutions.com/what-is-koha/" target="_blank">What is Koha? </a><br>
<br></span></div></font></div>
</div>