@@ -, +, @@ - Verify the Smithsonian has been removed from all translated installers - Verify the files are still valid SQL and install correctly there were two Authority z39.50 servers as well. Text files properly reflect the removal. SQL 'source' of SQL files worked properly. Was able to Z39.50 search for all of the 'en'. --- installer/data/mysql/de-DE/optional/sample_z3950_servers.sql | 3 +-- installer/data/mysql/de-DE/optional/sample_z3950_servers.txt | 3 ++- installer/data/mysql/en/optional/sample_z3950_servers.sql | 3 +-- installer/data/mysql/en/optional/sample_z3950_servers.txt | 1 - installer/data/mysql/es-ES/optional/sample_z3950_servers.sql | 11 ++++++----- installer/data/mysql/es-ES/optional/sample_z3950_servers.txt | 3 ++- installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql | 3 +-- installer/data/mysql/pl-PL/optional/sample_z3950_servers.txt | 1 - 8 files changed, 13 insertions(+), 15 deletions(-) --- a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql +++ a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql @@ -3,8 +3,7 @@ INSERT INTO z3950servers ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'), ('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'), ('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'), -('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'), -('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',0,0,'USMARC','MARC-8','biblio'); +('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'); #Insert SRU server INSERT INTO z3950servers --- a/installer/data/mysql/de-DE/optional/sample_z3950_servers.txt +++ a/installer/data/mysql/de-DE/optional/sample_z3950_servers.txt @@ -1,4 +1,5 @@ Vorkonfigurierte Z39.50-Server: LIBRARY OF CONGRESS +LIBRARY OF CONGRESS NAMES (Normsätze) +LIBRARY OF CONGRESS SUBJECTS (Normsätze) COLUMBIA UNIVERSITY -SMITHSONIAN INSTITUTION LIBRARIES --- a/installer/data/mysql/en/optional/sample_z3950_servers.sql +++ a/installer/data/mysql/en/optional/sample_z3950_servers.sql @@ -3,8 +3,7 @@ INSERT INTO z3950servers ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'), ('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'), ('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'), -('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'), -('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',0,0,'USMARC','MARC-8','biblio'); +('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'); #Insert SRU server INSERT INTO z3950servers --- a/installer/data/mysql/en/optional/sample_z3950_servers.txt +++ a/installer/data/mysql/en/optional/sample_z3950_servers.txt @@ -2,4 +2,3 @@ LIBRARY OF CONGRESS LIBRARY OF CONGRESS NAMES (authority records) LIBRARY OF CONGRESS SUBJECTS (authority records) COLUMBIA UNIVERSITY -SMITHSONIAN INSTITUTION LIBRARIES --- a/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql +++ a/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql @@ -1,8 +1,9 @@ -INSERT INTO `z3950servers` -(`host`, `port`, `db`, `userid`, `password`, `servername`, `id`, `checked`, `rank`, `syntax`, `encoding`) VALUES -('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,1,'USMARC','utf8'), -('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',6,0,0,'USMARC','MARC-8'), -('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',10,0,0,'USMARC','MARC-8'); +INSERT INTO z3950servers +(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES +('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'), +('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'), +('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'), +('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'); #Insert SRU server INSERT INTO z3950servers --- a/installer/data/mysql/es-ES/optional/sample_z3950_servers.txt +++ a/installer/data/mysql/es-ES/optional/sample_z3950_servers.txt @@ -1,3 +1,4 @@ LIBRARY OF CONGRESS +LIBRARY OF CONGRESS NAMES +LIBRARY OF CONGRESS SUBJECTS COLUMBIA UNIVERSITY -SMITHSONIAN INSTITUTION LIBRARIES --- a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql +++ a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql @@ -4,8 +4,7 @@ INSERT INTO z3950servers ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'), ('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'), ('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'), -('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'), -('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',0,0,'USMARC','MARC-8','biblio'); +('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'); #Insert SRU server INSERT INTO z3950servers --- a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.txt +++ a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.txt @@ -3,4 +3,3 @@ BIBLIOTEKA KONGRESU BIBLIOTEKA KONGRESU FORMALNE (Hasła wzorcowe) BIBLIOTEKA KONGRESU PRZEDMIOTOWE (Hasła wzorcowe) COLUMBIA UNIVERSITY -SMITHSONIAN INSTITUTION LIBRARIES --