[Archon-L] Record Groups Identification Question

[Chris Prom]

As Kyle said, this is an issue we are actively investigating.

We'd like to keep the classification mgr as simple as possible, 
and hope to find a way to accomodate the request.  The issue 
comes in with sorting on the public display side of things, so if 
anyone has any grand insight on how to define intuitive sorting 
rules for only alpha, only numbers, and a combo of both, please 
let us know.

Thanks,

Chris


On Tue, 3 Jun 2008, Wood, Thomas J wrote:

> In May of last year we exchanged some e-mails with Chris Prom about the
> issue of using letters in the number field of the classification
> manager. This was his advice:
>
> "Go into the MySQL server or SQL server where the raw archon database is
> stored.  Once in, open the Table titled tblCol_Classifications, then
> change the field type for the 'Number' field from 'int' or 'number' to
> 'varchar' I'd choose a relatively short field length, such as 10
> characters."
>
> It seems to have worked.
>
> Thomas J Wood
> Archivist
> Archives/Special Collections
> Norris L Brookens Library, Room 144
> University of Illinois at Springfield
> One University Plaza, MS BRK 140
> Springfield IL 62703-5407
> 217-206-6520 | wood at uis.edu | <http://www.uis.edu/archives/>
>
>
> -----Original Message-----
> From: archon-bounces at archon.org [mailto:archon-bounces at archon.org] On
> Behalf Of Kyle Fox
> Sent: Monday, June 02, 2008 11:02 AM
> To: Kyle Rimkus
> Cc: archon at archon.org
> Subject: Re: [Archon-L] Record Groups Identification Question
>
> I'm curious as to how this worked as well. The database fields are
> designated as INTs, so even if you edited the php, the database would
> still try to reject your letters.
>
> On this subject, though, we're considering relaxing the requirement that
> classifications have numbers. No guarantees at the moment, but this
> change may appear in a release sometime in the near future.
>
> On Wed, May 21, 2008 at 2:09 PM, Kyle Rimkus <kyle.rimkus at gmail.com>
> wrote:
>> Hi Thomas,
>>
>> I'm also curious about why that works in your install.  We have a
>> non-public install of Archon 2.1, and have noticed the same thing that
>
>> the others on list have commented on.  Namely, the first field in the
>> Classification Manager is "Number", and gives an error message when I
>> try to add letters.  We would also like to be able to add letters in
>> that field at the University of Miami.
>>
>> Best,
>>
>> Kyle
>>
>> On Tue, May 20, 2008 at 2:54 PM, Wood, Thomas J <twood1 at uis.edu>
> wrote:
>>> In the classification manager, I choose "add new," type in the record
>
>>> group's letter and title and other creator information, and click
> "add."
>>> That doesn't work?
>>>
>>>
>>> Thomas J Wood
>>> Archivist
>>> Archives/Special Collections
>>> Norris L Brookens Library, Room 144
>>> University of Illinois at Springfield One University Plaza, MS BRK
>>> 140 Springfield IL 62703-5407 217-206-6520 | wood at uis.edu |
>>> <http://www.uis.edu/archives/>
>>>
>>>
>>>
>>> ________________________________
>>> From: archon-bounces at archon.org [mailto:archon-bounces at archon.org] On
>
>>> Behalf Of Calvin Fenton
>>> Sent: Tuesday, May 20, 2008 11:40 AM
>>> To: archon at archon.org
>>> Subject: [Archon-L] Record Groups Identification Question
>>>
>>> I have just begun to use Archon in our small school archives. I want
>>> to enter our record groups but we use letters instead of numbers (AC
>>> - Academic Dept.; SU - Superintendent's Office, etc.). In
>>> Classification Manager, only numbers are allowed to identify record
>>> groups. Is there a work-around that will enable me to use our already
> assigned letter classifications?
>>>
>>>  Thanks.
>>> _______________________________________________
>>> Archon mailing list
>>> Archon at archon.org
>>> http://archon.org/mailman/listinfo/archon_archon.org
>>>
>>>
>>
>>
>>
>> --
>> Kyle R. Rimkus
>> Librarian Assistant Professor
>> Digital Projects Librarian
>> University of Miami Libraries
>> Otto G. Richter Library
>> 1300 Memorial Drive
>> Coral Gables, FL 33146
>>
>> personal: kyle.rimkus at gmail.com
>> work: kyle at miami.edu
>> (305) 284 - 6221
>>
>> _______________________________________________
>> Archon mailing list
>> Archon at archon.org
>> http://archon.org/mailman/listinfo/archon_archon.org
>>
>
>
>
> --
> Kyle Jordan Fox
>
>
> Senior in Computer Science
> Developer - Archon Simple Archival Information System
> Tour Manager/Internet Officer - Varsity Men's Glee Club
> -
> University of Illinois at Urbana/Champaign
>
> <kylefox2 at uiuc.edu>
>
> _______________________________________________
> Archon mailing list
> Archon at archon.org
> http://archon.org/mailman/listinfo/archon_archon.org
>
> _______________________________________________
> Archon mailing list
> Archon at archon.org
> http://archon.org/mailman/listinfo/archon_archon.org
>