Re: [IUG] SCAT table editing (Donna Peterson)

[Tasha Keagan <tkeagan at ucsc dot edu>]

Hi,

I've used Excel to create a tab-delimited version of our SCAT table.  I
created one column for each SCAT field, then merged the columns with ASAP
Utilities.  I find that being able to copy, paste, drag and drop in Excel
make editing the table entries much faster.  I also used a few formulas to
check for errors and overlap/gaps in numeric ranges.

The end result is a Notepad file full of lines that look like the example
below (start letter|start number|stop letter|stop
number|category|description):

DS|798.92|DS|799.999|475|DS798.92-799.9 Taiwan

I used an AutoIt script to delete the entire SCAT table and create a new one
using the Notepad file.  It is very fast.

I reiterate Joe's advice to be aware of the impact on statistics--we learned
this the hard way!

This method worked very well for us, but there may be an easier way.
Perhaps a script to attend to individual edits, rather than the entire
table?

Tasha Keagan


>
> 3.  SCAT table editing (Donna Peterson)
>
>
> Message: 3
> Date: Fri, 27 May 2011 12:24:16 -0500
> From: Donna Peterson <dpeterson at co dot carver dot mn dot us>
> Subject: [IUG] SCAT table editing
> To: IUG INNOPAC List <innopac at innovativeusers dot org>
> Message-ID:
>
> <39FC1D99B3AE1C45B89A64295B6C71440B80C917CD at CCEXCHANGE dot co dot carver dot mn dot us>
>
> Content-Type: text/plain; charset="us-ascii"
>
> Is there an easy way to edit a SCAT table? I want to change some of our
> category numbers and descriptions. Do I have to Delete the entry and then
> add it back in to change the category number or the description? Thanks!
> Donna L. Peterson
> Technical Services Manager
> Carver County Library
> 4 City Hall Plaza
> Chaska, MN  55318
> email: dpeterson at co dot carver dot mn dot us
> phone: 952-227-7605
> fax: 952-448-9392
>
>



-- 
University Library Electronic Resources/Records
University of California Santa Cruz
1156 High St
Santa Cruz, CA 95064
(831) 459-2005

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---