Prison Pete

Monday, August 23, 2004
  My database reports.
I am having lots of fun with my "database" and am burning through the one-use ribbons with a vengeance.

Do you realize how slow daisywheel printers are for printing database reports? It takes about six minutes to type a page! Good thing the master list is only 1 3/4 pages.

Then I do a set of craft reports for Art, Leather, and Ceramics, the three subgroups. The master report is alphabetic on last name, and then I re-sort the eighty records by the locker number, for example L-01 or C-01 for Leather and Ceramics, and run a report selecting where craft is equal to Ceramics, Leather, or Art.

So, each week it takes about an hour to print the four reports, but at least I can do it without waiting for a staff member to update them on his computer! Actually, technically the typewriter is more functional, since the only "office" application they have on the computers here is WordPerfect.

Each department must buy a license for a spreadsheet or database program, and the computer services department turned down the Rec department’s request for a spreadsheet program. They do have a main database called "Sentry". It is mainframe in format, and the report generation is cryptic to say the least. They bring up the report access via windows, but it is just a text window through to the main database, I think.

We just need to verify name and ID number for inmates who sign up for various programs. Anyhow, they print a roster that has the names of over 2,000 inmates, more than forty pages.

It is obsolete in two weeks!

So I suggested, why not print an "update list" of those that arrived here after the date the last master list was printed?

Well, it took over a week to get the report, and then the first one was sorted by arrival date. Not very useful for looking up names!

Anyhow, my direct boss reran it, figured out how to get the time period right, and even sorted it alphabetically on last name.

But this time he forgot to print the first name field! Hopefully next week it will run OK.

The other staff solution was to just run another roster. Kill more trees.

We could really use a truly gifted application programmer, but instead we have him sitting around playing with a Displaywriter!

Well, anyhow, 11:00 PM and I must get this in the mail.
So what is it you exactly do? From what I gather from reading your post you work with ancient technology.
Hey .. whats up ? so how is prison.? I bet not good.... But Hey could u check out. my blogger and pass it on... and please post. somethin...
Post a Comment

View my profile
Contact Prison Pete
Contact the Editor
Blogroll Me!

December 2010
November 2010
October 2010
September 2010
August 2010
July 2010
June 2010
May 2010
April 2010
March 2010
February 2010
January 2010

December 2009
November 2009
October 2009
September 2009
August 2009
July 2009
June 2009
May 2009
April 2009
March 2009
February 2009
January 2009

December 2008
November 2008
October 2008
September 2008
August 2008
July 2008
June 2008
May 2008
April 2008
March 2008
February 2008
January 2008

December 2007
November 2007
October 2007
September 2007
August 2007
July 2007
June 2007
May 2007
April 2007
March 2007
February 2007
January 2007

December 2006
November 2006
October 2006
September 2006
August 2006
July 2006
June 2006
May 2006
April 2006
March 2006
February 2006
January 2006

December 2005
November 2005
October 2005
September 2005
August 2005
July 2005
June 2005
May 2005
April 2005
March 2005
February 2005
January 2005

December 2004
November 2004
October 2004
September 2004
August 2004
July 2004
June 2004
May 2004
April 2004


Powered by Blogger


Emily Dickinson
Janet Evanovich
Ian Fleming
Jonathan Franzen
Robert Fulghum
Sue Grafton
Tami Hoag
Jean Shepherd

Johann Sebastian Bach
Virgil Fox
Benny Goodman
Vladimir Horowitz
Itzhak Perlman
David Russell
Lonnie Smith

Radio and TV Shows
All Things Considered
Capitol Steps
Fawlty Towers
Fresh Air
The Infinite Mind
Jazz After Hours
Jeeves and Wooster
Pipe Dreams

Media, Publishers, Networks
Augsberg Fortress Press
Hamilton Bookseller
NY Daily News
NY Newsday
NY Times
PC Magazine
WNED Buffalo, NY

Helpful Organizations

Federal Bureau of Prisons
NY State Court of Appeals
NY State Department of Corrections

Typing with a Dvorak keyboard
Fastback Book Binding System
Who links to me?