RE: [IUG] A truly "dumb question," but ...

["Seeman, Corey" <cseeman at bus dot umich dot edu>]

Thanks Sheryl -- That is a nice shortcut!

Corey 


Corey Seeman

Director
Kresge Business Administration Library
Stephen M. Ross School of Business
University of Michigan
701 Tappan Street, K3330
Ann Arbor, Michigan 48109-1234
(734) 764-9969
Cell Phone (734) 717-9734
Fax (734) 764-3839
cseeman at umich dot edu 

http://www.bus.umich.edu/kresgelibrary/
http://www-personal.umich.edu/~cseeman/index.html  
-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of LLC Sheryl
VanderWagen
Sent: Friday, December 22, 2006 4:18 PM
To: IUG INNOPAC List
Subject: RE: [IUG] A truly "dumb question," but ...

Seeing this message, there is one other little shortcut to this that I
find 
very useful and then you needn't worry about delimiters, etc.  

Open Excel as Corey notes below and instead of Import Data, you can
Import 
New Web Query and set up your stat report from that screen like you
would in 
your web browser.  Once the results are in the display, then follow the
Excel 
commands to import the table and it will actually self format for you
right 
into the correct columns, etc.

Sheryl VanderWagen
System Librarian
Lakeland Library Cooperative
616-559-5253 x210
616-559-4329 (Fax)
sheryl at llcoop dot org

---------- Original Message -----------
From: "Seeman, Corey" <cseeman at bus dot umich dot edu>
To: "IUG INNOPAC List" <innopac at innopacusers dot org>
Cc: "Seeman, Corey" <cseeman at bus dot umich dot edu>
Sent: Fri, 22 Dec 2006 14:50:01 -0500
Subject: RE: [IUG] A truly "dumb question," but ...

> David -- An example of a truly dumb question might be...Who is Harry
> Potter?
> 
> The download feature of Millennium Web Reports (I assume that this is
> what you are looking at) works pretty well.  If you are at the report
> you want, click on the download button and allow the file to be
> downloaded.  Save it to your desktop or wherever.
> 
> Then open Excel.  Go to Data --> Import External Data --> Import Data
> 
> (and find the file.  The default is for the file to download without 
> an extension, so you need to find the file using All Files *.* as 
> the file type).
> 
> Once you have found the file, you then choose Delimited (should be
> selected); click NEXT; then Change the Delimiter from the Tab 
> (selected) to OTHER and key a pipe "|" in the other box.  This 
> should split up your data very nicely.
> 
> Hopefully this will do the trick.  In Millennium Statistics, the
export
> automatically opens up Excel. For my money, still one of the greatest
> things since sliced bread.
> 
> Best -- Corey
> 
> Corey Seeman
> 
> Director
> Kresge Business Administration Library
> Stephen M. Ross School of Business
> University of Michigan
> 701 Tappan Street, K3330
> Ann Arbor, Michigan 48109-1234
> (734) 764-9969
> Cell Phone (734) 717-9734
> Fax (734) 764-3839
> cseeman at umich dot edu
> 
> http://www.bus.umich.edu/kresgelibrary/
> http://www-personal.umich.edu/~cseeman/index.html  
> -----Original Message-----
> From: innopac-bounces at innopacusers dot org
> [mailto:innopac-bounces at innopacusers dot org] On Behalf Of
> David dot W dot Brown at kp dot org
> Sent: Friday, December 22, 2006 2:10 PM
> To: innopac at innopacusers dot org
> Subject: [IUG] A truly "dumb question," but ...
> 
> Greetings.
> 
> When I wish to download a report from the INNOPAC Millennium 
> statistics, I find myself unable to do so in a way that allows for a 
> decent Excel file.
> 
> Being pretty techno dumb, what I get looks like this:
> 
> Please, any suggestions as to what I am doing wrong and what I can 
> do right? ("HELP" has not been much help)
> 
> Thank you.
> 
> David
> 
> David W. Brown, MA, MLS
> Library Technical Services Coordinator
> Kaiser Permanente
> Physician Education and Development
> 1800 Harrison St, 21st floor
> Oakland, CA 94612
> 
> Telephone: 510-625-2369 or tie-line 8-428-2369
> FAX: 510-625-2342 or tie-line 8-428-2342
> 
> NOTICE TO RECIPIENT:  If you are not the intended recipient of this
> e-mail, you are prohibited 
> from sharing, copying, or otherwise using or disclosing its contents.
> If 
> you have received this e-mail in error, please notify the sender 
> immediately by reply e-mail and permanently delete this e-mail and 
> any attachments without reading, forwarding or saving them.  Thank
you.
> 
> "LLC Sheryl VanderWagen" <sheryl at llcoop dot org>
> Sent by: innopac-bounces at innopacusers dot org
> 12/22/2006 10:47 AM
> Please respond to IUG INNOPAC List
> 
>         To:     IUG INNOPAC List <innopac at innopacusers dot org>
>         cc: 
>         Subject:        Re: [IUG] Transfer of holds
> 
> Beth, part of the confusion depends on what type of Paging you have
set
> up 
> on 
> your system.
> 
> If you are using Item Level Paging, the transfer time calculates 
> based on the time the paging slip is printed by staff.
> 
> If you are on Title Level Paging, the transfer time calculates
according
> 
> to 
> the time the hold is first paged which is usually the time the 
> request is placed.
> 
> The transfer process in either case is set up as a cron job and will 
> run
> 
> at 
> the same time every day on your system and uses the circ option 
> setting for the time to transfer.  So at 4:00 a.m., for example, it 
> would look at your
> 
> file to find those pages that have been in the file longer than the
> number 
> of 
> hours you have set in the circ option and the transfer is conducted 
> at that time.  Pages that have not been in the file long enough 
> according to your set time remain in the file until the next day 
> when the process runs again and
> 
> checks to see how old the pages are and transfers again.
> 
> FYI- on our system when we were on Item Level Paging, we set that
> transfer
> 
> time to 12 hours because it based on when the library printed the
paging
> 
> slip.  When we changed over to Title Level Paging so we could use the
> new 
> Priority Paging, we extended that transer period to 48 hours because 
> of differences in the way to two paging models function.
> 
> Feel free to contact me off list if you have any other specific
> questions.
> 
> Sheryl VanderWagen
> System Librarian
> Lakeland Library Cooperative
> 616-559-5253 x210
> 616-559-4329 (Fax)
> sheryl at llcoop dot org
> 
> ---------- Original Message -----------
> From: "Beth Lunn" <bethl at pioneerland dot lib dot mn dot us>
> To: "III Listserv" <innopac at innopacusers dot org>
> Sent: Mon, 18 Dec 2006 10:14:37 -0600
> Subject: [IUG] Transfer of holds
> 
> > I've been struggling with how long I should set the "number of hours

> > before page can be transferred". Everything I read in the manual 
> > said the counting starts at 4:00am. The helpdesk people say it 
> > starts from the time the "page" is printed. If that is the case; how

> > do you handle libraries that are closed certain days of the week and

> > what have you found to work the best when setting number of hours?
> > 
> > Thanks
> > 
> > Beth
> > 
> > _______________________
> > 
> > Beth Lunn
> > 
> > Pioneerland Library System
> > 
> > 320-235-6106 x29
> > 
> > Fax 320-214-0187
> > 
> > --- StripMime Report -- processed MIME parts ---
> > multipart/alternative
> >   text/plain (text body -- kept)
> >   text/html
> > ---
> > --
> > 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
> ------- End of Original Message -------
> 
> --
> 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
> 
> --- StripMime Report -- processed MIME parts ---
> multipart/related
>   multipart/alternative
>     text/plain (text body -- kept)
>     text/html
>   image/gif
> ---
> --
> 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
> 
> --
> 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
------- End of Original Message -------

--
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