Re: [IUG] SCAT table editing (Donna Peterson)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Date: Wed, 1 Jun 2011 11:06:36 -0700
- From: Tasha Keagan <tkeagan at ucsc dot edu>
- Subject: Re: [IUG] SCAT table editing (Donna Peterson)
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
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
> 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>
> <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
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--- StripMime Report -- processed MIME parts ---
text/plain (text body -- kept)