1	E-journals: Can you See me now? By John Wynstra University of Northern Iowa http://www.uni.edu/~wynstra/iug2003
2	Presentation Goals
3	Getting to Know You Academic/Public/Special/School ER databases?Why? E-journals in Catalog? plan to? Use Serials Solutions Use a vendor other than Serials Solutions Looking into Link Server Technology Like e-journals, hate e-journals
4	UNI Rod Library University of Northern Iowa 13,000 students Rod Library (CVLC) 900,000 Books & Bound Periodical volumes 164 subscription databases 15,000 Electronic Journal access points 60 full time staff (22 library faculty) 100 plus public Workstations
5	Electronic Resources Committee 2 Library Information Technologies 2 Reference Department 2 Cataloging Department 1 Acquisitions Department 1 Collection Management Department
6	Library Info Tech Specialist Innovative System Admin (1 of 3) Web Application Developer Librarian My Role in this project Programmer/integrator
7	What are we Doing? Getting an inventory of full text e-journals from Serials Solutions Generating brief bib records in Marc format using the 6 data items provided in the Serials Solutions inventory Loading them into our Catalog
8	E-journal Inventory data # Titles = 11,000 (14,000 + access points) #Vendors = 16 #Data Elements Title ISSN Start Date End Date Provider URL Cost = 2000 plus
9	Brief Bibs in Marc Format 1 record per title (not per access point) Added Author for provider Coverage in Notes Proxifying the URL [Electronic Resource] gmd Load Table instructions (949) Add item record Genre index
10	Updating the catalog Load new records (note record ranges) Unload old records (using record range Time = 6-15 hours every two months Serials Solutions profiling - 6-10 hours Transforming data – 1-2 hours Loading records - 3 hours
11	Why? Short Answer – Single source of data Long Answer - Natural step in development of ER database Excuse - Lack of Better Alternatives at the time
12	Guiding Principles “Leverage the Catalog” “Catalog for retrieval and not just for description”
13	The Process in a Nutshell Update Serials Solutions profile Receive Dataload from SS(.html,.csv) Data Checklist Remove column headers Run SSTransform Run Marc Maker (marc edit) FTS file up to Catalog Preprocess Load Remove Old Data Test
14	Tools Perl Interpreter (Active Perl) http://www.activestate.com/Products/ActivePerl/ Perl Script – SSTransform.pl http://www.uni.edu/~wynstra/iug2003 Marc Edit http://oregonstate.edu/~reeset/marcedit/html Innovative FTS
15	How does the program work? Open 2 files Input = “rep.csv” Output=“marc_ready.txt” Read Title and Title Details(1 line at a time) Proxify URLs Print to “marc_ready.txt” Close files – DONE!
16	Demo How does the program work? Open, read, transform, print Show Rep.csv Show output of SSTransform.pl Show Marc Edit in action Show SSTransform.pl Code
17	Customizing the Program LDR 001 003 005 008
18	LDR print marc_ready "=LDR 00000nas\\\\2200000\\a\\4500\n";
19	001 Control Number print marc_ready "=001 SS-$i\n"; This number is automatically generated within SSTransform. You may want to Change the SS prefix, but you don’t have to.
20	003 Control Number Identifier Example print marc_ready “=040 \\\\\$aNIU\$cNIU\n”;
21	005 Date and Time of Last Transaction print marc_ready "=005 20030211000000.0\n"; You may want to set this every other month when you run the program. I never got around to automating this.
22	008 Fixed Length Data Elements print marc_ready "=008 020401nuuuu\\\\\\\\xx\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\eng\\d\n"; Update(mmyydd) the date here. Be careful of the \\. \\ is equivalent to a blank.
23	040 Cataloging Source Example print marc_ready “=040 \\\\\$aNIU\$cNIU\n”; Replace NIU with your own symbol.
24	049 Location Code print marc_ready "=049 \\\\\$aNIUU\n"; Replace NIUU with your own location code.
25	599 print marc_ready "=599 \\\\\$aUNI: Full access restricted to individuals affiliated with UNI.\n"; Change the red portion to what ever you want or delete the whole line altogether.
26	856 URL If you want to bypass the proxify subroutine change the following two lines: $proxyurl = proxify ($ur[$s],$prov[$s]); print marc_ready "=856 40\$zConnect to $prov[$s]\$u$proxyurl\n"; To this: #$proxyurl = proxify ($ur[$s],$prov[$s]); print marc_ready "=856 40\$zConnect to $prov[$s]\$u $ur[$s]\n";
27	949 Local Load instructions print marc_ready "=949 \\\\\$a*recs-b;bn-1intr;b3-s;\n"; print marc_ready "=949 \\1\$l1intr\$t15\$se;\n\n"; The information in this field is specific to our load tables, location codes, etc. You may reconfigure or delete these two lines.
28	Customizing Proxify Subroutine proxify $proxiedurl = "http://" .$port ."-" .$server .".unistan.uni.edu:80/" .$dir; Comment out the 12 lines begin at $testphrase1
29	Thank You Have a nice day Good Luck John.wynstra@uni.edu