moved out of the Open-ILS tree; these are implementation specific
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 5 Apr 2005 18:43:54 +0000 (18:43 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 5 Apr 2005 18:43:54 +0000 (18:43 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@450 dcc99617-32d9-48b4-a31d-7c20da2025e4

Evergreen/src/extras/import/import_clean_marc.pl [new file with mode: 0755]
Evergreen/src/extras/import/import_holdings.pl [new file with mode: 0755]
Evergreen/src/extras/import/lib_spliter.pl [new file with mode: 0755]
Evergreen/src/extras/import/pg-drop-create.sh [new file with mode: 0755]
Evergreen/src/extras/import/pines_libs.txt [new file with mode: 0644]

diff --git a/Evergreen/src/extras/import/import_clean_marc.pl b/Evergreen/src/extras/import/import_clean_marc.pl
new file mode 100755 (executable)
index 0000000..ac06eeb
--- /dev/null
@@ -0,0 +1,96 @@
+#!/usr/bin/perl -w
+use strict;
+use XML::LibXML;
+use Time::HiRes qw/time/;
+use Getopt::Long;
+use Data::Dumper;
+use Error qw/:try/;
+use open qw/:utf8/;
+
+$|=1;
+
+my ($userid, $sourceid, $rec_id, $entry_file, $marc_file, $map_file) = (1, 2, 1, 'record_entry.sql','record_marc.sql','record_id_map.pl');
+
+GetOptions (   
+       "sourceid"              => \$sourceid,
+       "entry_file=s"          => \$entry_file,
+       "marc_file=s"           => \$marc_file,
+       "tcn_map_file=s"        => \$map_file,
+       "userid=i"              => \$userid,
+       "first=i"               => \$rec_id,
+);
+
+my $tcn_map;
+
+open RE, ">$entry_file" or die "Can't open $entry_file!  $!\n";
+open RM, ">$marc_file" or die "Can't open $marc_file!  $!\n";
+
+print RE <<SQL;
+SET CLIENT_ENCODING TO 'UNICODE';
+COPY biblio.record_entry (id,editor,creator,source,tcn_value,last_xact_id) FROM STDIN;
+SQL
+
+print RM <<SQL;
+SET CLIENT_ENCODING TO 'UNICODE';
+COPY biblio.record_marc (id,marc,last_xact_id) FROM STDIN;
+SQL
+
+my $xact_id = time;
+
+my $parser = XML::LibXML->new;
+
+my $xml = '';
+while ( $xml .= <STDIN> ) {
+       chomp $xml;
+       next unless $xml;
+
+       my $tcn;
+       my $success = 0;
+       try {
+               my $doc = $parser->parse_string($xml);;
+               $tcn = $doc->documentElement->findvalue( '/*/*[@tag="035"][1]' );
+               $success = 1;
+       } catch Error with {
+               my $e = shift;
+               warn $e;
+               warn $xml;
+       };      
+       next unless $success;
+
+       $xml =~ s/\\/\\\\/go;
+       $xml =~ s/\t/\\t/go;
+
+       $tcn =~ s/^.*?(\w+)\s*$/$1/go;
+       
+       unless ($tcn) {
+               warn "\nNo TCN found for rec # $rec_id\n";
+               $xml = '';
+               $rec_id++;
+               next;
+       }
+
+       if (exists($$tcn_map{$tcn})) {
+               warn "\n !! TCN $tcn already exists!\n";
+               $xml = '';
+               next;
+       }
+
+       print ".";
+       $$tcn_map{$tcn} = $rec_id;
+
+       print RE join("\t", ($rec_id,$userid,$userid,$sourceid,$tcn,$xact_id))."\n";
+       print RM join("\t", ($rec_id,$xml,$xact_id))."\n";
+
+       $rec_id++;
+       $xml = '';
+}
+
+print RE "\\.\n";
+print RE "SELECT setval('biblio.record_entry_id_seq'::TEXT, $rec_id);\n";
+print RM "\\.\n";
+
+open MAP, ">$map_file" or die "Can't open $map_file!  $!\n";
+print MAP Data::Dumper->Dump([$tcn_map],['tcn_map']);
+
+
+
diff --git a/Evergreen/src/extras/import/import_holdings.pl b/Evergreen/src/extras/import/import_holdings.pl
new file mode 100755 (executable)
index 0000000..b1e0c7f
--- /dev/null
@@ -0,0 +1,128 @@
+#!/usr/bin/perl -w
+use strict;
+use XML::LibXML;
+use Time::HiRes qw/time/;
+use Getopt::Long;
+use Data::Dumper;
+use Error qw/:try/;
+use open qw/:utf8/;
+
+$|=1;
+
+my ($userid, $sourceid, $cn_id, $cp_id, $cp_file, $cn_file, $map_file, $lib_map_file) =
+       (1, 2, 1, 1, 'asset_copy.sql','asset_volume.sql','record_id_map.pl','lib-map.pl');
+
+GetOptions (   
+       "sourceid"              => \$sourceid,
+       "copy_file=s"           => \$cp_file,
+       "volume_file=s"         => \$cn_file,
+       "tcn_map_file=s"        => \$map_file,
+       "lib_map_file=s"        => \$lib_map_file,
+       "userid=i"              => \$userid,
+       "first_volume=i"        => \$cn_id,
+       "first_copy=i"          => \$cp_id,
+);
+
+my $tcn_map;
+my $lib_map;
+
+eval `cat $map_file`;
+eval `cat $lib_map_file`;
+
+open CP, ">$cp_file" or die "Can't open $cp_file!  $!\n";
+open CN, ">$cn_file" or die "Can't open $cn_file!  $!\n";
+
+
+print CP <<SQL;
+SET CLIENT_ENCODING TO 'UNICODE';
+COPY asset.copy (id,editor,creator,barcode,call_number,copy_number,available,loan_duration,fine_level,circulate,deposit,deposit_amount,price,ref,opac_visible) FROM STDIN;
+SQL
+
+print CN <<SQL;
+SET CLIENT_ENCODING TO 'UNICODE';
+COPY asset.call_number (id,editor,creator,record,label,owning_lib) FROM STDIN;
+SQL
+
+my $xact_id = time;
+
+my $parser = XML::LibXML->new;
+
+my $cn_map;
+
+my $xml = '';
+while ( $xml .= <STDIN> ) {
+       chomp $xml;
+       next unless $xml;
+
+       my $tcn;
+       my $doc;
+       my $success = 0;
+       try {
+               $doc = $parser->parse_string($xml);;
+               $tcn = $doc->documentElement->findvalue( '/*/*[@tag="035"][1]' );
+               $success = 1;
+       } catch Error with {
+               my $e = shift;
+               warn $e;
+               warn $xml;
+       };      
+       next unless $success;
+
+       $tcn =~ s/^.*?(\w+)\s*$/$1/go;
+       
+       unless ($tcn) {
+               warn "\nNo TCN found in rec!!\n";
+               $xml = '';
+               next;
+       }
+
+       unless (exists($$tcn_map{$tcn})) {
+               warn "\n !! TCN $tcn not in the map!\n";
+               $xml = '';
+               next;
+       }
+
+       my $rec_id = $$tcn_map{$tcn};
+
+       for my $node ($doc->documentElement->findnodes('/*/*[@tag="999"]')) {
+               my $barcode = $node->findvalue( '*[@code="i"]' );
+               my $label = $node->findvalue( '*[@code="a"]' );
+               my $owning_lib = $$lib_map{ $node->findvalue( '*[@code="m"]' ) };
+               my $price = $node->findvalue( '*[@code="p"]' );
+               my $copy_number = $node->findvalue( '*[@code="c"]' );
+               my $available = $node->findvalue( '*[@code="k"]' ) ? 1 : 0;
+
+               next unless $barcode;
+               next unless $owning_lib;
+               next unless $label;
+
+               $barcode =~ s/\\/\\\\/og;
+               $label =~ s/\\/\\\\/og;
+               $price =~ s/\$//og;
+               $price ||= '0.00';
+
+               unless (exists($$cn_map{"$rec_id/$owning_lib/$label"})) {
+                       $$cn_map{"$rec_id/$owning_lib/$label"} = $cn_id;
+                       print CN join("\t",($cn_id,$userid,$userid,$rec_id,$label,$owning_lib))."\n";
+                       print 'v';
+                       $cn_id++;
+               }
+
+# id,editor,creator,barcode,call_number,copy_number,available,loan_duration,fine_level,circulate,deposit,deposit_amount,price,ref,opac_visible
+
+               print CP join("\t", (   $cp_id,$userid,$userid,$barcode,
+                                       $$cn_map{"$rec_id/$owning_lib/$label"},
+                                       $copy_number,$available,2,2,1,0,'0.00',
+                                       $price,0,1 )
+                        )."\n";
+               print 'c';
+               $cp_id++;
+       }
+       $xml = '';
+}
+
+print CN "\\.\n";
+print CN "SELECT setval('asset.call_number_id_seq'::TEXT, $cn_id);\n";
+print CP "\\.\n";
+print CP "SELECT setval('asset.copy_id_seq'::TEXT, $cp_id);\n";
+
diff --git a/Evergreen/src/extras/import/lib_spliter.pl b/Evergreen/src/extras/import/lib_spliter.pl
new file mode 100755 (executable)
index 0000000..bace057
--- /dev/null
@@ -0,0 +1,64 @@
+#!/usr/bin/perl -w
+use strict;
+use Data::Dumper;
+use DBI;
+
+unless (@ARGV) {
+       print <<"       USAGE";
+       Usage:  $0 <db-name> <lib-map-output> < <lib-file>
+       USAGE
+       exit;
+}
+
+my %libs;
+my $lib_map = {};
+while (<STDIN>) {
+       chomp;
+       my ($policy, $lib, $sys) = split "\t";
+       my ($sys_pol) = split '-', $policy;
+
+       $libs{$sys_pol}{libs} ||= [];
+       $libs{$sys_pol}{name} = $sys;
+       $libs{$sys_pol}{type} = 2;
+       push @{ $libs{$sys_pol}{libs} }, {name => $lib, shortname => $policy, type => 3 };
+}
+
+my $dbh = DBI->connect("dbi:Pg:host=localhost;dbname=$ARGV[0]",'postgres');
+
+$dbh->begin_work;
+
+my $find_lib_ou = 'select id from actor.org_unit where shortname = ?';
+for my $sname (keys %libs) {
+       ($libs{$sname}{id}) = $dbh->selectrow_array($find_lib_ou,{},$sname);
+       $lib_map->{$sname} = $libs{$sname}{id};
+       for my $lib (@{ $libs{$sname}{libs} }) {
+               ($$lib{id}) = $dbh->selectrow_array($find_lib_ou,{},$$lib{shortname});
+               $lib_map->{$$lib{shortname}} = $$lib{id};
+       }
+}
+
+my $find_parent_ou = 'select parent_ou from actor.org_unit where shortname = ?';
+my $create_lib_ou = 'insert into actor.org_unit (name,shortname,parent_ou,ou_type) VALUES (?,?,?,?)';
+for my $sname (keys %libs) {
+       unless ($libs{$sname}{id}) {
+               $dbh->do($create_lib_ou,{},$libs{$sname}{name},$sname, 1,$libs{$sname}{type});
+               ($libs{$sname}{id}) = $dbh->selectrow_array($find_lib_ou,{},$sname);
+               $lib_map->{$sname} = $libs{$sname}{id};
+       }
+       ($libs{$sname}{parent_ou}) = $dbh->selectrow_array($find_parent_ou,{},$libs{$sname}{shortname});
+       my $pid = $libs{$sname}{id};
+       for my $lib (@{ $libs{$sname}{libs} }) {
+               unless ($$lib{id}) {
+                       $dbh->do($create_lib_ou,{},$$lib{name},$$lib{shortname}, $pid,$$lib{type});
+                       ($$lib{id}) = $dbh->selectrow_array($find_lib_ou,{},$$lib{shortname});
+                       $lib_map->{$$lib{shortname}} = $$lib{id};
+               }
+               ($$lib{parent_ou}) = $dbh->selectrow_array($find_parent_ou,{},$$lib{shortname});
+       }
+}
+
+open FH, ">$ARGV[1]" or die "Can't open $ARGV[1] to write the map file! $!";
+print FH Data::Dumper->Dump([$lib_map],['lib_map']);
+
+$dbh->commit;
+
diff --git a/Evergreen/src/extras/import/pg-drop-create.sh b/Evergreen/src/extras/import/pg-drop-create.sh
new file mode 100755 (executable)
index 0000000..71ac9ad
--- /dev/null
@@ -0,0 +1,3 @@
+#!/bin/sh
+dropdb open-ils-utf8-dev
+createdb -E UNICODE open-ils-utf8-dev
diff --git a/Evergreen/src/extras/import/pines_libs.txt b/Evergreen/src/extras/import/pines_libs.txt
new file mode 100644 (file)
index 0000000..d749eb0
--- /dev/null
@@ -0,0 +1,256 @@
+ARL-ATH        Athens-Clarke County Library    Athens Regional Library
+ARL-BKM        Bookmobile      Athens Regional Library
+ARL-BOG        Bogart Branch Library   Athens Regional Library
+ARL-DAN        Madison County Library  Athens Regional Library
+ARL-EAST       East Athens Community Center    Athens Regional Library
+ARL-ENSAT      Sandy Creek Nature Ctr  Athens Regional Library
+ARL-LAV        Lavonia-Carnegie Library        Athens Regional Library
+ARL-LAY        Lay Park Community Resource Ctr.        Athens Regional Library
+ARL-LEX        Oglethorpe County Library       Athens Regional Library
+ARL-LYNDON     Lyndon House Arts Ctr   Athens Regional Library
+ARL-ROY        Royston Branch Library  Athens Regional Library
+ARL-WAT        Oconee County Library   Athens Regional Library
+ARL-WINT       Winterville Branch Library      Athens Regional Library
+BROOK-HQ       Brooks County Library   Brooks County Library
+BTRL-BKM       Bookmobile      Bartram Trail Regional Library
+BTRL-MCD       Thomson-McDuffie County Library Bartram Trail Regional Library
+BTRL-MWL       Mary Willis Library     Bartram Trail Regional Library
+BTRL-TCL       Taliaferro County Library       Bartram Trail Regional Library
+CHAT-SMRVL     Chattooga County Library        Chattooga County Library
+CHAT-TRION     Trion Public Library    Chattooga County Library
+CHRL-CHICK     Chickamauga Public Library      Cherokee Regional Library
+CHRL-DADE      Dade County Public Library      Cherokee Regional Library
+CHRL-LW        LaFayette-Walker County Library Cherokee Regional Library
+CHRL-ROSS      Rossville Public Library        Cherokee Regional Library
+CLAYTN-FOR     Forest Park Branch Library      Clayton County Library System
+CLAYTN-HQS     Clayton County Library System   Clayton County Library System
+CLAYTN-JON     Jonesboro Branch Library        Clayton County Library System
+CLAYTN-LOV     Lovejoy Branch Library (projected)      Clayton County Library System
+CLAYTN-MOR     Morrow Branch Library   Clayton County Library System
+CLAYTN-RIV     Riverdale Branch Library        Clayton County Library System
+CPRL-A Victoria Evans Memorial Library Coastal Plain Regional Library
+CPRL-B Carrie Dorsey Perry Memorial Library    Coastal Plain Regional Library
+CPRL-BKM       Bookmobile      Coastal Plain Regional Library
+CPRL-C Cook County Library     Coastal Plain Regional Library
+CPRL-L Irwin County Library    Coastal Plain Regional Library
+CPRL-R Coastal Plain Regional Library  Coastal Plain Regional Library
+CPRL-T Tifton-Tift County Public Library       Coastal Plain Regional Library
+CRLS-DAWSN     Dawson County Library   Chestatee Regional Library
+CRLS-LMPKN     Lumpkin County Library  Chestatee Regional Library
+DCPL-CEN       Central Library Dougherty County Public Library
+DCPL-NW        Northwest Library       Dougherty County Public Library
+DCPL-SS        Southside Library       Dougherty County Public Library
+DCPL-TAL       Tallulah Massey Library Dougherty County Public Library
+DCPL-WT        Westtown Library        Dougherty County Public Library
+DTRL-BAKR      Baker County Library    DeSoto Trail Regional Library
+DTRL-BLAK      Lucy Maddox Memorial Library    DeSoto Trail Regional Library
+DTRL-CAMI      Hdqtrs Library/Camilla  DeSoto Trail Regional Library
+DTRL-JAKN      Jakin Public Library    DeSoto Trail Regional Library
+DTRL-PELH      Pelham-Carnegie Library Desoto Trail Regional Library
+DTRL-SYLV      Margaret Jones Public Library   DeSoto Trail Regional Library
+ECGR-APPBY     Appleby Branch Library  East Central Georgia Regional Library
+ECGR-AVTBC     Audio/Visual Center/TBC Library East Central Georgia Regional Library
+ECGR-BKM       Bookmobile      East Central Georgia Regional Library
+ECGR-BURKE     Burke County Library    East Central Georgia Regional Library
+ECGR-EUCHE     Euchee Creek Library    East Central Georgia Regional Library
+ECGR-FRMAN     Friedman Branch Library East Central Georgia Regional Library
+ECGR-GIBBS     Columbia County Libraries/Gibbs Memorial        East Central Georgia Regional Library
+ECGR-GLSCK     Glascock County Library East Central Georgia Regional Library
+ECGR-HARLM     Harlem Branch Library   East Central Georgia Regional Library
+ECGR-LINCN     Lincoln County Library  East Central Georgia Regional Library
+ECGR-MAIN      Augusta-Richmond County Public Library  East Central Georgia Regional Library
+ECGR-MIDVL     Midville Branch Library East Central Georgia Regional Library
+ECGR-MXWLL     Maxwell Branch Library  East Central Georgia Regional Library
+ECGR-SOAUG     South Augusta Branch Library/ Diamond Lakes Branch Library      East Central Georgia Regional Library
+ECGR-SRDIS     Sardis Branch Library   East Central Georgia Regional Library
+ECGR-WALLC     Wallace Branch Library  East Central Georgia Regional Library
+ECGR-WARRN     Warren County Library   East Central Georgia Regional Library
+ECPL-BKM       Bookmobile      Elbert County Public Library
+ECPL-BWMN      Bowman Library  Elbert County Public Library
+ECPL-ECPL      Elbert County Library   Elbert County Public Library
+FBHCL-MAIN     Fitzerald-Ben Hill County Library       Fitzgerald-Ben Hill Library
+FRRLS-BA       Barnesville-Lamar County Library        Flint River Regional Library
+FRRLS-FA       Fayette County Public Library   Flint River Regional Library
+FRRLS-FY       Monroe County Library   Flint River Regional Library
+FRRLS-GR       Griffin-Spalding County Library Flint River Regional Library
+FRRLS-JA       Jackson-Butts County Public Library     Flint River Regional Library
+FRRLS-PT       Peachtree City Library  Flint River Regional Library
+FRRLS-TY       Tyrone Public Library   Flint River Regional Library
+FRRLS-ZE       J. Joel Edwards Public Library  Flint River Regional Library
+HALL-BPL       Blackshear Place Library        Hall County Library System
+HALL-CL        Clermont Branch Library Hall County Library System
+HALL-EH        East Hall and Special Needs Library     Hall County Library System
+HALL-GVL       Hall County Library     Hall County Library System
+HALL-MV        Murrayville Branch Library      Hall County Library System
+HART-HQ        Hart County Library     Hart County Library
+HCLS-HA        Fortson Public Library  Henry County Library
+HCLS-LG        Locust Grove Public Library     Henry County Library
+HCLS-MD        Alexander Public Library        Henry County Library
+HCLS-ST        Cochran Public Library  Henry County Library
+HOU-CV Centerville Branch Library      Houston County Public Library
+HOU-PE Perry Public Library    Houston County Public Library
+HOU-WR Nola Brantley Memorial Library  Houston County Public Library
+JCL-BKMOBL     Bookmobile--See Louisville Public Library       Jefferson County Library
+JCL-LVILLE     Louisville Public Library       Jefferson County Library
+JCL-WADLEY     Wadley Public Library   Jefferson County Library
+JCL-WRENS      McCollum Public Library Jefferson County Library
+KRLS-AR        Arlington Branch Library        Kinchafoonee Regional Library
+KRLS-CA        Calhoun County Library  Kinchafoonee Regional Library
+KRLS-CL        Clay County Library     Kinchafoonee Regional Library
+KRLS-KI        Kinchafoonee Regional Library   Kinchafoonee Regional Library
+KRLS-RA        Randolph County Public LIbrary  Kinchafoonee Regional Library
+KRLS-TE        Terrell County Public Library   Kinchafoonee Regional Library
+KRLS-WE        Webster County Public Library   Kinchafoonee Regional Library
+LEE-LSB        Lee County Public Library       Lee County Public Library
+LEE-SMV        Smithville Library      Lee County Public Library
+MCCLS-BER      Berlin Community Library        Moultrie-Colquitt County Library
+MCCLS-BER      Berlin Community Library        Moultrie-Colquitt County Library
+MCCLS-BKM      Bookmobile-See Moultrie-Colquitt County Lib.    Moultrie-Colquitt County Library
+MCCLS-DOE      Monroe Memorial Library Moultrie-Colquitt County Library
+MCCLS-DOE      Monroe Memorial Library Moultrie-Colquitt County Library
+MCCLS-HQ       Moultrie-Colquitt County Library        Moultrie-Colquitt County Library
+MGRL-EW        East Wilkinson County Library   Middle Georgia Regional Library
+MGRL-GH        Genealogical and Historical  Department Middle Georgia Regional Library
+MGRL-GO        Gordon Public Library   Middle Georgia Regional Library
+MGRL-ID        Ideal Public Library    Middle Georgia Regional Library
+MGRL-JO        Jones County Public Library     Middle Georgia Regional Library
+MGRL-LB        Library for the Blind & Physically Handicapped  Middle Georgia Regional Library
+MGRL-MA        Marshallville Public Library    Middle Georgia Regional Library
+MGRL-MM        Bookmobile--See Washington Memorial Library     Middle Georgia Regional Library
+MGRL-MO        Montezuma Carnegie Public Library       Middle Georgia Regional Library
+MGRL-OG        Oglethorpe Public Library       Middle Georgia Regional Library
+MGRL-RC        Rocky Creek Branch Library      Middle Georgia Regional Library
+MGRL-RE        Regional Library        Middle Georgia Regional Library
+MGRL-RO        Crawford County Public Library  Middle Georgia Regional Library
+MGRL-RV        Riverside Branch Library        Middle Georgia Regional Library
+MGRL-SH        Shurling Branch Library Middle Georgia Regional Library
+MGRL-TW        Twiggs County Public Library    Middle Georgia Regional Library
+MGRL-WA        Washington Memorial Library     Middle Georgia Regional Library
+MGRL-WB        West Bibb Branch Library        Middle Georgia Regional Library
+MRLS-BKMB      Bookmobile-See Mountain Regional Lib. Sys.      Mountain Regional Library
+MRLS-FCPL      Fannin County Public Library    Mountain Regional Library
+MRLS-MRL       Mountain Regional Library System        Mountain Regional Library
+MRLS-TCPL      Towns County Public Library     Mountain Regional Library
+MRLS-UCPL      Union County Public Library     Mountain Regional Library
+NCLS-COVTN     Newton County Library Headqtrs. Newton County Library System
+NEG-BKMB       Bookmobile--See Clarkesville-Habersham Co.      Northeast Georgia Regional Library
+NEG-CLRKVL     Clarkesville-Habersham County Library   Northeast Georgia Regional Library
+NEG-CLVLND     "White County Library, Cleveland Branch"        Northeast Georgia Regional Library
+NEG-CORNEL     Cornelia-Habersham Library      Northeast Georgia Regional Library
+NEG-HELEN      "White County Library, Helen Branch"    Northeast Georgia Regional Library
+NEG-RABUN      Rabun County Library    Northeast Georgia Regional Library
+NEG-TOCCOA     Toccoa-Stephens County Library  Northeast Georgia Regional Library
+OCRL-DUBLN     Oconee Regional Library Oconee Regional Library
+OCRL-SANDR     Rosa M. Tarbutton Memorial Library/Washington Co.       Oconee Regional Library
+OCRL-SOPER     Treutlen County Library Oconee Regional Library
+OCRL-WRIGH     Johnson County Library  Oconee Regional Library
+OHOOP-BKML     Bookmbile--see Vidalia-Toombs County Library    Ohoopee Regional Library
+OHOOP-LADS     Ladson Genealogical Library     Ohoopee Regional Library
+OHOOP-LADS     Ladson Genealogical Library     Ohoopee Regional Library
+OHOOP-LYON     Nelle Brown Memorial Library    Ohoopee Regional Library
+OHOOP-MONT     Montgomery County Library       Ohoopee Regional Library
+OHOOP-TATG     Glennville Public Library       Ohoopee Regional Library
+OHOOP-TATR     Tattnall County Library Ohoopee Regional Library
+OHOOP-VIDT     Vidalia-Toombs County Library   Ohoopee Regional Library
+OKRL-APPL      Appling County Public Library   Okefenokee Regional Library System
+OKRL-BACON     Alma-Bacon County Public Library        Okefenokee Regional Library System
+OKRL-BKM       Bookmobile      Okefenokee Regional Library System
+OKRL-BLMEM     Blackshear Memorial Library     Okefenokee Regional Library System
+OKRL-CLNCH     Clinch County Public Library    Okefenokee Regional Library System
+OKRL-MA        Marian Anderson Public Library  Okefenokee Regional Library System
+OKRL-WWC       Waycross-Ware County Public Library     Okefenokee Regional Library System
+ORLS-BLE       Cochran-Bleckley/Tessie W. Norris       Ocmulgee Regional Library
+ORLS-EXT       Public Service Annex    Ocmulgee Regional Library
+ORLS-HDQ       Murrell Memorial Library        Ocmulgee Regional Library
+ORLS-PUL       M.E. Roden Public Library       Ocmulgee Regional Library
+ORLS-TEL       Telfair County Library  Ocmulgee Regional Library
+ORLS-WHE       Wheeler County Library  Ocmulgee Regional Library
+ORLS-WHE       Wheeler County Library  Ocmulgee Regional Library
+ORLS-WIL       Wilcox County Public Library    Ocmulgee Regional Library
+PIED-AUB       Auburn Public Library   Piedmont Regional Library System
+PIED-BKM       Piedmont-Bookmobile     Piedmont Regional Library System
+PIED-BRL       Braselton Library       Piedmont Regional Library System
+PIED-COM       Commerce Public Library Piedmont Regional Library System
+PIED-HOM       Banks County Public Library     Piedmont Regional Library System
+PIED-JEF       Jefferson Public Library        Piedmont Regional Library System
+PIED-MAY       Maysville Public Library        Piedmont Regional Library System
+PIED-NIC       Harold S. Swindle Public Library        Piedmont Regional Library System
+PIED-STA       Statham Public Library  Piedmont Regional Library System
+PIED-WIN       Piedmont Regional Library-Headquarters  Piedmont Regional Library System
+PMRLS-BPL      Butler Public Library   Pine Mountain Regional Library
+PMRLS-EXT      Extension Services      Pine Mountain Regional Library
+PMRLS-GPL      Greenville Area Public Library  Pine Mountain Regional Library
+PMRLS-HML      Hightower Memorial Library      Pine Mountain Regional Library
+PMRLS-MPL      Manchester Public Library       Pine Mountain Regional Library
+PMRLS-RCL      Reynolds Community Library      Pine Mountain Regional Library
+PMRLS-TCL      Talbot County Library   Pine Mountain Regional Library
+PMRL-YPL       Yatesville Public Library       Pine Mountain Regional Library System
+PPL-BPL        Byron Public Library    Peach Public Libraries
+PPL-LEC        Peach County Law Enforcement Center     Peach Public Libraries
+PPL-TPL        Thomas Public Library   Peach Public Libraries
+RML-MAIN       Roddenbery Memorial Library     Roddenbery Memorial Library
+ROCK-NG        Nancy Guinn Memorial Library    Conyers-Rockdale Library System
+SHRL-BKM       Outreach Collection     Sara Hightower Regional Library
+SHRL-CD        Cedartown Branch        Sara Hightower Regional Library
+SHRL-CS        Cave Spring Branch      Sara Hightower Regional Library
+SHRL-RK        Rockmart Branch Sara Hightower Regional Library
+SHRL-RM        Rome-Floyd County Library       Sara Hightower Regional Library
+SJRLS-BKM      Bookmoible-see Screvens County Library  Screven-Jenkins Regional Library
+SJRLS-JCES     Jenkins County Elementary School        Screven-Jenkins Regional Library
+SJRLS-JCHS     Jenkins County High School      Screven-Jenkins Regional Library
+SJRLS-JCML     Jenkins County Memorial Library Screven-Jenkins Regional Library
+SJRLS-SCL      Screven County Library  Screven-Jenkins Regional Library
+SRL-AMBR       Ambrose Public Library  Satilla Regional Library
+SRL-BKMO       Bookmbile--see Douglas-Coffee Co. Library       Satilla Regional Library
+SRL-BROX       Broxton Public Library  Satilla Regional Library
+SRL-DOUG       Douglas-Coffee County Library   Satilla Regional Library
+SRL-JDHAZ      Hazlehurst-Jeff Davis Public Library    Satilla Regional Library
+SRL-NICH       Nicholls Public Library Satilla Regional Library
+SRL-PEAR       Pearson Public Library  Satilla Regional Library
+SRL-WILLA      Willacoochee Public Library     Satilla Regional Library
+STATELIB-A     State Library of Georgia Admin. Offices Office of Public Library Services
+STATELIB-B     State Library of Georgia Library for the Blind  Office of Public Library Services
+STATELIB-L     State Library of Georgia Collection     Office of Public Library Services
+STRL-CLAX      Evans County Library    Statesboro Regional Library
+STRL-METT      L.C. Anderson Library   Statesboro Regional Library
+STRL-PEMB      Pembroke Public Library Statesboro Regional Library
+STRL-RHILL     Richmond Hill Public Library    Statesboro Regional Library
+STRL-SBORO     Statesboro Regional Library     Statesboro Regional Library
+STRL-SWAIN     Franklin Memorial Library       Statesboro Regional Library
+SWGRL-BKM      Bookmobile--see Gilbert H. Gragg Mem. Lib.      Southwest Georgia Regional Library
+SWGRL-DEC      Gilbert H. Gragg Memorial Library       Southwest Georgia Regional Library
+SWGRL-MIL      James W. Merritt Memorial Library       Southwest Georgia Regional Library
+SWGRL-MIL      Miller County Public Library    Southwest Georgia Regional Library
+SWGRL-SEM      Seminole Public Library Southwest Georgia Regional Library
+TLLS-LS        Lake Sinclair Library   Twin Lakes Library
+TLLS-MV        Mary Vinson Memorial Library    Twin Lakes Library
+TRRL-BKM       Bookmobile      Three Rivers Regional Library
+TRRL-BRANT     Brantley County Library Three Rivers Regional Library
+TRRL-CAMDN     Camden County Public Library    Three Rivers Regional Library
+TRRL-CHARL     Charlton Public Library Three Rivers Regional Library
+TRRL-GLYNN     Three Rivers Regional Library   Three Rivers Regional Library
+TRRL-LONG      Long County Library     Three Rivers Regional Library
+TRRL-MCINT     Ida Hilton Public Library       Three Rivers Regional Library
+TRRL-STMRY     St. Mary's Library      Three Rivers Regional Library
+TRRL-WAYNE     Wayne County Library    Three Rivers Regional Library
+URRLS-GR       Greene County Library   Uncle Remus Regional Library
+URRLS-HA       Hancock County Library  Uncle Remus Regional Library
+URRLS-JA       Jasper County Library   Uncle Remus Regional Library
+URRLS-MA       Morgan County Library   Uncle Remus Regional Library
+URRLS-MR       Monroe-Walton County Library    Uncle Remus Regional Library
+URRLS-OK       O'Kelly Memorial Library        Uncle Remus Regional Library
+URRLS-PU       Eatonton-Putnam County Library  Uncle Remus Regional Library
+URRLS-SC       W. H. Stanton Memorial Library  Uncle Remus Regional Library
+WGRL-BKM       Bookmobile      West Georgia Regional Library
+WGRL-BO        Warren P. Sewell Memorial Library of Bowdon     West Georgia Regional Library
+WGRL-BU        Buchanan - Haralson County Public Library       West Georgia Regional Library
+WGRL-BR        Warren P. Sewell Memorial Library of Bremen     West Georgia Regional Library
+WGRL-DC        Douglas County Public Library   West Georgia Regional Library
+WGRL-FR        Heard County Public Library     West Georgia Regional Library
+WGRL-HQ        Neva Lomason Memorial Library   West Georgia Regional Library
+WGRL-LS        Betty C. Hagler Public Library  West Georgia Regional Library
+WGRL-MR        Maude P. Ragsdale Public Library        West Georgia Regional Library
+WGRL-NG        New Georgia Public Library      West Georgia Regional Library
+WGRL-PC        Paulding County Public Library  West Georgia Regional Library
+WGRL-TA        Tallapoosa Public Library       West Georgia Regional Library
+WGRL-VR        Villa Rica Public Library       West Georgia Regional Library