RE: [IUG] inventory report

["Lin Light" <holight at llcoop dot org>]

Interesting to read that you are using Excel and Access in your process.
Those programs are being used now during our inventory process.
I create a list by location code, break it down into 1000 item groups, staff
will scan into an Excel spreadsheet and then I will import that section into
Access where I have created a table, then I run a dupcheck querry and that
runs a report for staff to find out why the item is in the report. We are
lucky, years ago we decided to place our barcodes on the outside back of the
book.  The reason for the 1000 items is that is about one person can do in
an hour.  Once the report is in hand add about 1-2 more hours and that
section of the collections has been inventoried.

Lin


-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org]On Behalf Of Diane J. Pittman
Sent: Wednesday, February 01, 2006 10:21 AM
To: bryantyson at earthlink dot net; IUG INNOPAC List
Subject: Re: [IUG] inventory report


Well, Bryan, I am only going by what I was told by
Innovative when we first started using the inventory module
several years ago and as some of our schools continue to
use it we have seen no change in the module.  So, if you
find out differently, the knowledge has not been passed on
to us as we struggled to understand it.  We now, for the
most part use Excel, Access and the old pencil and paper
list in most of our sites.  Diane

On Tue, 31 Jan 2006 23:45:43 -0500 "Bryan S. Tyson"
<bryantyson at earthlink dot net> wrote:

> On Tuesday 31 January 2006 3:02 pm, Diane J. Pittman wrote:
>
> > One reason for the large errors only is that the inventory
> > system arranges by barcode number not by call number.
>
> I would like to suggest that regardless of how poorly designed the
Millennium
> inventory module is, we can be virtually certain that it would not use
such a
> fallacious method for determining what is misshelved.
>
> Having said that, I fully agree that the report has plenty of room for
> improvement. When we had DRA, the report gave us the misshelved item with
the
> item before and after it to allow quickly locating it on the shelf. I
wonder
> why such an idea did not occur to the Millennium programmers instead of
tons
> of "misshelved" listings emanating from one truly misshelved book.
>
> Bryan
>
> ****************************************
> Powered by Mepis Linux 3.3.1
> KDE 3.3.2  KMail 1.7.2
> This is a Microsoft-free computer
>
> Bryan S. Tyson
> bryantyson at earthlink dot net
> ****************************************
>
> --
> This message was distributed through the Innovative Users Group INNOPAC
list
> Public replies:  INNOPAC at innopacusers dot org
> Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac

--------------------------------------
Diane J. Pittman
District Media Specialist
Poudre School District
2413 LaPorte Avenue
Fort Collins, CO 80521
970-4903635
dpittman at psdschools dot org



--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC at innopacusers dot org
Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac