Attachment 99413 Details for Bug 24584 – Bug 24584: Rewrite optional/sample_patrons to YAML

[patch] Bug 24584: Rewrite optional/sample_patrons to YAML

Bug-24584-Rewrite-optionalsamplepatrons-to-YAML.patch (text/plain), 83.25 KB, created by Martin Renvoize (ashimema) on 2020-02-21 16:39:57 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2020-02-21 16:39:57 UTC

Size: 83.25 KB

patch

obsolete

>From 11dd32142785be1e519c085084b061e3fa378f31 Mon Sep 17 00:00:00 2001
>From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
>Date: Wed, 5 Feb 2020 09:49:14 -0300
>Subject: [PATCH] Bug 24584: Rewrite optional/sample_patrons to YAML
>
>YAML version of optional sample_patrons
>
>To test:
>1) Same test plan of first patch, only check table
>   borrowers
>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>---
> .../data/mysql/en/optional/sample_patrons.sql |   51 -
> .../data/mysql/en/optional/sample_patrons.txt |    1 -
> .../data/mysql/en/optional/sample_patrons.yml | 2427 +++++++++++++++++
> 3 files changed, 2427 insertions(+), 52 deletions(-)
> delete mode 100644 installer/data/mysql/en/optional/sample_patrons.sql
> delete mode 100644 installer/data/mysql/en/optional/sample_patrons.txt
> create mode 100644 installer/data/mysql/en/optional/sample_patrons.yml
>
>diff --git a/installer/data/mysql/en/optional/sample_patrons.sql b/installer/data/mysql/en/optional/sample_patrons.sql
>deleted file mode 100644
>index d2f16a3650..0000000000
>--- a/installer/data/mysql/en/optional/sample_patrons.sql
>+++ /dev/null
>@@ -1,51 +0,0 @@
>-INSERT INTO `borrowers` (`borrowernumber`, `cardnumber`, `surname`, `firstname`, `title`, `othernames`, `initials`, `streetnumber`, `streettype`, `address`, `address2`, `city`, `zipcode`, `email`, `phone`, `mobile`, `fax`, `emailpro`, `phonepro`, `B_streetnumber`, `B_streettype`, `B_address`, `B_city`, `B_zipcode`, `B_email`, `B_phone`, `dateofbirth`, `branchcode`, `categorycode`, `dateenrolled`, `dateexpiry`, `gonenoaddress`, `lost`, `debarred`, `contactname`, `contactfirstname`, `contacttitle`, `borrowernotes`, `relationship`, `sex`, `userid`, `opacnote`, `contactnote`, `password`, `flags`, `sort1`, `sort2`) VALUES
>-(1,'1','Admin','Koha',NULL,NULL,'',NULL,NULL,'',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','S',NULL,'2099-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
>-(2,'23529000152273','Welch','Marcus',NULL,NULL,'',NULL,NULL,'5601 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRL','ST','1985-10-24','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000152273',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.43609457503641','0.38613959717205'),
>-(3,'23529000445172','Daniels','Tanya',NULL,NULL,'',NULL,NULL,'2035 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1966-10-14','MPL','PT','1990-08-22','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000445172',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62241429148467','0.95365269664084'),
>-(4,'23529000105040','Dillon','Eva',NULL,NULL,'',NULL,NULL,'8916 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-04-03','MPL','PT','1987-07-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000105040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.90102063948384','0.64414513823031'),
>-(5,'23529001000463','Acosta','Edna',NULL,NULL,'',NULL,NULL,'7896 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1980-04-24','MPL','PT','1990-11-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529001000463',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.72642678648832','0.6644830635418'),
>-(6,'23529000591678','Glass','Virgil',NULL,NULL,'',NULL,NULL,'6250 Library Rd.',NULL,'Santa Cruz, CA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1974-06-19','SPL','T','1985-02-13','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000591678',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.1431349889777','0.72222578499673'),
>-(7,'23529000080862','Middleton','Bobbie',NULL,NULL,'',NULL,NULL,'4619 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-07-24','SPL','J','1991-03-13','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000080862',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.18172398878422','0.74194261966454'),
>-(8,'23529000358268','Rivera','Olga',NULL,NULL,'',NULL,NULL,'6058 Library Rd.',NULL,'Mayfield Heights, OH','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1979-12-22','PVL','T','1986-04-17','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000358268',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.16454116270369','0.59687798525847'),
>-(9,'23529000429697','Waters','Annie',NULL,NULL,'',NULL,NULL,'5444 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1932-10-27','FRL','ST','1984-05-07','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000429697',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.49076646891494','0.66319841953292'),
>-(10,'23529000068917','Herring','Frances',NULL,NULL,'',NULL,NULL,'4024 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-02-13','SPL','PT','1993-03-12','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000068917',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84369272165344','0.22886838040209'),
>-(11,'23529000065863','Hawkins','Sam',NULL,NULL,'',NULL,NULL,'665 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1924-03-26','SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000065863',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.61326376778378','0.37971372844625'),
>-(12,'23529000878885','Mcknight','Marie',NULL,NULL,'',NULL,NULL,'4241 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','YA','1990-08-06','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000878885',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.058777369613552','0.15474569346266'),
>-(13,'23529000132291','Edwards','Roy',NULL,NULL,'',NULL,NULL,'9929 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1928-09-09','MPL','PT','1992-03-10','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000132291',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.59739638920631','0.5227448963772'),
>-(14,'23529000035726','Mccullough','Phillip',NULL,NULL,'',NULL,NULL,'410 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1943-11-23','SPL','PT','1986-01-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000035726',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.82153534500071','0.53944206660561'),
>-(15,'23529001203323','Peterson','Gordon',NULL,NULL,'',NULL,NULL,'6285 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1963-10-01','SPL','J','1984-09-11','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529001203323',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.23260432875958','0.54469547471469'),
>-(16,'23529000991266','Walker','Andrea',NULL,NULL,'',NULL,NULL,'4992 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1956-08-05','FRL','IL','1993-06-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000991266',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.025664418028355','0.49423569673135'),
>-(17,'23529000711078','King','Casey',NULL,NULL,'',NULL,NULL,'3438 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-09-23','SPL','S','1992-05-18','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000711078',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.39418526030535','0.48821924206635'),
>-(18,'23529000809559','Delgado','Floyd',NULL,NULL,'',NULL,NULL,'6661 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1968-02-01','MPL','K','1988-08-05','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000809559',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.25854046014933','0.82804460528125'),
>-(19,'23529000035676','Acevedo','Henry',NULL,NULL,'',NULL,NULL,'4345 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1958-05-30','MPL','S','1990-09-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000035676',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.36460167669188','0.33887459834933'),
>-(20,'23529000033739','Frazier','Sonia',NULL,NULL,'',NULL,NULL,'8165 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1945-09-16','MPL','PT','1984-06-21','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000033739',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60056799240463','0.98621619770882'),
>-(21,'23529000139858','Ballard','Ronnie',NULL,NULL,'',NULL,NULL,'5730 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1956-02-23','MPL','T','1989-06-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000139858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12937704206386','0.68823664792649'),
>-(22,'23529000224510','Gaines','Joyce',NULL,NULL,'',NULL,NULL,'6012 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1957-08-01','SPL','YA','1992-09-16','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000224510',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.053052144174513','0.20055080782673'),
>-(23,'23529000120056','Bryan','Johnny',NULL,NULL,'',NULL,NULL,'8180 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1961-10-24','MPL','PT','1990-08-22','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000120056',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84359763734378','0.61633579397233'),
>-(24,'23529000218553','Duffy','Joann',NULL,NULL,'',NULL,NULL,'1555 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1942-02-17','MPL','ST','1984-08-02','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000218553',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.55088608856395','0.90542309163643'),
>-(25,'23529000662701','Mejia','Armando',NULL,NULL,'',NULL,NULL,'8209 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1939-07-22','SPL','PT','1990-09-26','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000662701',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.87445722322395','0.65601687194409'),
>-(26,'23529000092040','Hendrix','Keith',NULL,NULL,'',NULL,NULL,'6546 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1944-04-05','SPL','PT','1987-12-12','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000092040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.65671272078223','0.31551301881253'),
>-(27,'23529000058017','Turner','Sherri',NULL,NULL,'',NULL,NULL,'1731 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1964-11-21','FRL','PT','1987-09-14','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000058017',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60742696244961','0.090595786544118'),
>-(28,'23529000299603','Cherry','Lillie',NULL,NULL,'',NULL,NULL,'263 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1931-01-19','MPL','PT','1993-03-19','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000299603',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.6306980761054','0.88170305162827'),
>-(29,'23529000121682','Schneider','Nicole',NULL,NULL,'',NULL,NULL,'1008 Library Rd.',NULL,'Centerville, CA','44306',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1954-01-12','FRL','ST','1985-09-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000121682',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.5164210605588','0.93699617864284'),
>-(30,'23529000240482','White','Jamie',NULL,NULL,'',NULL,NULL,'937 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1950-04-22','FRL','T','1990-02-03','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000240482',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.13571774227146','0.86760020616241'),
>-(31,'23529000714163','Burgess','Dawn',NULL,NULL,'',NULL,NULL,'7907 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','PT','1985-05-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000714163',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.93084783473131','0.051438585902973'),
>-(32,'23529000318858','Bennett','Pamela',NULL,NULL,'',NULL,NULL,'9898 Library Rd.',NULL,'Centerville, CA','44310',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1946-09-16','MPL','ST','1984-05-08','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000318858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.46464945605458','0.16893155329761'),
>-(33,'23529000526047','Hatfield','Lester',NULL,NULL,'',NULL,NULL,'393 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1983-01-22','SPL','ST','1988-07-30','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000526047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.45070942905798','0.74675251613069'),
>-(34,'23529000686353','Harper','Ruben',NULL,NULL,'',NULL,NULL,'6963 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1917-09-24','SPL','S','1991-02-19','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000686353',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.38163432421315','0.66791410340733'),
>-(35,'23529000719519','Kinney','Mae',NULL,NULL,'',NULL,NULL,'2114 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','J','1991-12-29','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000719519',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.19466757513086','0.96959559616595'),
>-(36,'23529000179433','Williamson','Catherine',NULL,NULL,'',NULL,NULL,'5879 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1930-12-18','FRL','K','1985-01-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000179433',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26397528617082','0.41108967308988'),
>-(37,'23529000197047','Charles','Lisa',NULL,NULL,'',NULL,NULL,'6813 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1982-10-14','MPL','K','1988-11-14','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000197047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26352253767058','0.084343699816934'),
>-(38,'23529000695412','Singleton','Bob',NULL,NULL,'',NULL,NULL,'4554 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1983-04-15','FRL','PT','1991-07-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000695412',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.63115091680656','0.90272351531566'),
>-(39,'23529000603242','Mcconnell','Terrence',NULL,NULL,'',NULL,NULL,'7200 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1949-06-10','SPL','PT','1984-05-31','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000603242',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62016485689223','0.39265376924784'),
>-(40,'23529000589458','Knight','Mabel',NULL,NULL,'',NULL,NULL,'8997 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-12-22','SPL','T','1985-04-17','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000589458',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.10277430629616','0.33591025447092'),
>-(41,'23529000054503','Odom','Gloria',NULL,NULL,'',NULL,NULL,'9156 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-04-05','SPL','S','1992-07-21','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000054503',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.37122838419976','0.84841118831971'),
>-(42,'23529000126806','Hopkins','Brent',NULL,NULL,'',NULL,NULL,'6692 Library Rd.',NULL,'Santa Cruz, CA','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1977-11-13','SPL','T','1984-06-28','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000126806',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12837081973289','0.096620564438981'),
>-(43,'23529000104159','Benson','Clinton',NULL,NULL,'',NULL,NULL,'4695 Library Rd.',NULL,'Atwater, OH','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','YA','1985-10-28','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000104159',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.097990393729872','0.20009030606606'),
>-(44,'23529000395609','Stuart','Shannon',NULL,NULL,'',NULL,NULL,'5011 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1951-02-13','FRL','PT','1986-01-16','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000395609',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.70648037987433','0.93213101190713'),
>-(45,'23529000050113','Alford','Jordan',NULL,NULL,'',NULL,NULL,'5129 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-05-27','MPL','ST','1985-09-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000050113',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.54121395064631','0.90967674824379'),
>-(46,'23529000053836','Mcfarland','Marilyn',NULL,NULL,'',NULL,NULL,'4600 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000053836',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.92474192001367','0.89467938607063'),
>-(47,'23529000774373','Morris','Lauren',NULL,NULL,'',NULL,NULL,'5436 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','PT','1986-03-20','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000774373',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.69917120104578','0.81181787775067'),
>-(48,'23529000117565','Palmer','Bill',NULL,NULL,'',NULL,NULL,'2761 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1984-01-10','SPL','PT','1991-10-07','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'M','23529000117565',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.96157581634966','0.37242547922994'),
>-(49,'23529000651225','Burton','Mary',NULL,NULL,'',NULL,NULL,'8131 Library Rd.',NULL,'Santa Cruz, CA','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1977-12-25','MPL','PT','1985-05-30','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529000651225',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.97739997783434','0.76972348221552'),
>-(50,'23529001223636','Peters','Tommy',NULL,NULL,'',NULL,NULL,'5171 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1951-06-14','SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'F','23529001223636',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.91641750830823','0.27291712562825');
>diff --git a/installer/data/mysql/en/optional/sample_patrons.txt b/installer/data/mysql/en/optional/sample_patrons.txt
>deleted file mode 100644
>index 850d4e3afc..0000000000
>--- a/installer/data/mysql/en/optional/sample_patrons.txt
>+++ /dev/null
>@@ -1 +0,0 @@
>-Sample patrons
>diff --git a/installer/data/mysql/en/optional/sample_patrons.yml b/installer/data/mysql/en/optional/sample_patrons.yml
>new file mode 100644
>index 0000000000..6cd018a0ef
>--- /dev/null
>+++ b/installer/data/mysql/en/optional/sample_patrons.yml
>@@ -0,0 +1,2427 @@
>+---
>+#
>+#  Copyright 2020 Koha Development Team
>+#
>+#  This file is part of Koha.
>+#
>+#  Koha is free software  you can redistribute it and/or modify it under the
>+#  terms of the GNU General Public License as published by the Free Software
>+#  Foundation  either version 2 of the License, or (at your option) any later
>+#  version.
>+#
>+#  Koha is distributed in the hope that it will be useful, but WITHOUT ANY
>+#  WARRANTY  without even the implied warranty of MERCHANTABILITY or FITNESS FOR
>+#  A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
>+#
>+#  You should have received a copy of the GNU General Public License along
>+#  with Koha  if not, write to the Free Software Foundation, Inc.,
>+#  51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
>+#
>+
>+description:
>+  - "Sample patrons"
>+
>+tables:
>+  - borrowers:
>+      translatable: [ ]
>+      multiline: []
>+      rows:
>+        - borrowernumber: 1
>+          cardnumber: 1
>+          surname: Admin
>+          firstname: Koha
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address:
>+          address2: ~
>+          city:
>+          zipcode: ~
>+          email: ~
>+          phone: ~
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: ~
>+          branchcode: MPL
>+          categorycode: S
>+          dateenrolled: ~
>+          dateexpiry: "2099-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: ~
>+          userid: ~
>+          opacnote: ~
>+          contactnote: ~
>+          password: ~
>+          flags: ~
>+          sort1: ~
>+          sort2: ~
>+
>+        - borrowernumber: 2
>+          cardnumber: 23529000152273
>+          surname: Welch
>+          firstname: Marcus
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 5601 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: ~
>+          branchcode: FRL
>+          categorycode: ST
>+          dateenrolled: "1985-10-24"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000152273
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.43609457503641
>+          sort2: 0.38613959717205
>+
>+        - borrowernumber: 3
>+          cardnumber: 23529000445172
>+          surname: Daniels
>+          firstname: Tanya
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 2035 Library Rd.
>+          address2: ~
>+          city: Portland, ME
>+          zipcode: 44236
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1966-10-14"
>+          branchcode: MPL
>+          categorycode: PT
>+          dateenrolled: "1990-08-22"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000445172
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.62241429148467
>+          sort2: 0.95365269664084
>+
>+        - borrowernumber: 4
>+          cardnumber: 23529000105040
>+          surname: Dillon
>+          firstname: Eva
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 8916 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1952-04-03"
>+          branchcode: MPL
>+          categorycode: PT
>+          dateenrolled: "1987-07-01"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000105040
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.90102063948384
>+          sort2: 0.64414513823031
>+
>+        - borrowernumber: 5
>+          cardnumber: 23529001000463
>+          surname: Acosta
>+          firstname: Edna
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 7896 Library Rd.
>+          address2: ~
>+          city: Portland, OR
>+          zipcode: 44240
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1980-04-24"
>+          branchcode: MPL
>+          categorycode: PT
>+          dateenrolled: "1990-11-23"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529001000463
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.72642678648832
>+          sort2: 0.6644830635418
>+
>+        - borrowernumber: 6
>+          cardnumber: 23529000591678
>+          surname: Glass
>+          firstname: Virgil
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 6250 Library Rd.
>+          address2: ~
>+          city: Santa Cruz, CA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1974-06-19"
>+          branchcode: SPL
>+          categorycode: T
>+          dateenrolled: "1985-02-13"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000591678
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.1431349889777
>+          sort2: 0.72222578499673
>+
>+        - borrowernumber: 7
>+          cardnumber: 23529000080862
>+          surname: Middleton
>+          firstname: Bobbie
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 4619 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1953-07-24"
>+          branchcode: SPL
>+          categorycode: J
>+          dateenrolled: "1991-03-13"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000080862
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.18172398878422
>+          sort2: 0.74194261966454
>+
>+        - borrowernumber: 8
>+          cardnumber: 23529000358268
>+          surname: Rivera
>+          firstname: Olga
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 6058 Library Rd.
>+          address2: ~
>+          city: Mayfield Heights, OH
>+          zipcode: 21234
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1979-12-22"
>+          branchcode: PVL
>+          categorycode: T
>+          dateenrolled: "1986-04-17"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000358268
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.16454116270369
>+          sort2: 0.59687798525847
>+
>+        - borrowernumber: 9
>+          cardnumber: 23529000429697
>+          surname: Waters
>+          firstname: Annie
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 5444 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1932-10-27"
>+          branchcode: FRL
>+          categorycode: ST
>+          dateenrolled: "1984-05-07"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000429697
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.49076646891494
>+          sort2: 0.66319841953292
>+
>+        - borrowernumber: 10
>+          cardnumber: 23529000068917
>+          surname: Herring
>+          firstname: Frances
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 4024 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1953-02-13"
>+          branchcode: SPL
>+          categorycode: PT
>+          dateenrolled: "1993-03-12"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000068917
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.84369272165344
>+          sort2: 0.22886838040209
>+
>+        - borrowernumber: 11
>+          cardnumber: 23529000065863
>+          surname: Hawkins
>+          firstname: Sam
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 665 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1924-03-26"
>+          branchcode: SPL
>+          categorycode: PT
>+          dateenrolled: "1984-05-09"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000065863
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.61326376778378
>+          sort2: 0.37971372844625
>+
>+        - borrowernumber: 12
>+          cardnumber: 23529000878885
>+          surname: Mcknight
>+          firstname: Marie
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 4241 Library Rd.
>+          address2: ~
>+          city: Centerville, CA
>+          zipcode: 44262
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: ~
>+          branchcode: SPL
>+          categorycode: YA
>+          dateenrolled: "1990-08-06"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000878885
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.058777369613552
>+          sort2: 0.15474569346266
>+
>+        - borrowernumber: 13
>+          cardnumber: 23529000132291
>+          surname: Edwards
>+          firstname: Roy
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 9929 Library Rd.
>+          address2: ~
>+          city: Portland, OR
>+          zipcode: 44240
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1928-09-09"
>+          branchcode: MPL
>+          categorycode: PT
>+          dateenrolled: "1992-03-10"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000132291
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.59739638920631
>+          sort2: 0.5227448963772
>+
>+        - borrowernumber: 14
>+          cardnumber: 23529000035726
>+          surname: Mccullough
>+          firstname: Phillip
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 410 Library Rd.
>+          address2: ~
>+          city: Portland, ME
>+          zipcode: 44236
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1943-11-23"
>+          branchcode: SPL
>+          categorycode: PT
>+          dateenrolled: "1986-01-23"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000035726
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.82153534500071
>+          sort2: 0.53944206660561
>+
>+        - borrowernumber: 15
>+          cardnumber: 23529001203323
>+          surname: Peterson
>+          firstname: Gordon
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 6285 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1963-10-01"
>+          branchcode: SPL
>+          categorycode: J
>+          dateenrolled: "1984-09-11"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529001203323
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.23260432875958
>+          sort2: 0.54469547471469
>+
>+        - borrowernumber: 16
>+          cardnumber: 23529000991266
>+          surname: Walker
>+          firstname: Andrea
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 4992 Library Rd.
>+          address2: ~
>+          city: Portland, OR
>+          zipcode: 44240
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1956-08-05"
>+          branchcode: FRL
>+          categorycode: IL
>+          dateenrolled: "1993-06-23"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000991266
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.025664418028355
>+          sort2: 0.49423569673135
>+
>+        - borrowernumber: 17
>+          cardnumber: 23529000711078
>+          surname: King
>+          firstname: Casey
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 3438 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1953-09-23"
>+          branchcode: SPL
>+          categorycode: S
>+          dateenrolled: "1992-05-18"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000711078
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.39418526030535
>+          sort2: 0.48821924206635
>+
>+        - borrowernumber: 18
>+          cardnumber: 23529000809559
>+          surname: Delgado
>+          firstname: Floyd
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 6661 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1968-02-01"
>+          branchcode: MPL
>+          categorycode: K
>+          dateenrolled: "1988-08-05"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000809559
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.25854046014933
>+          sort2: 0.82804460528125
>+
>+        - borrowernumber: 19
>+          cardnumber: 23529000035676
>+          surname: Acevedo
>+          firstname: Henry
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 4345 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1958-05-30"
>+          branchcode: MPL
>+          categorycode: S
>+          dateenrolled: "1990-09-23"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000035676
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.36460167669188
>+          sort2: 0.33887459834933
>+
>+        - borrowernumber: 20
>+          cardnumber: 23529000033739
>+          surname: Frazier
>+          firstname: Sonia
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 8165 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1945-09-16"
>+          branchcode: MPL
>+          categorycode: PT
>+          dateenrolled: "1984-06-21"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000033739
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.60056799240463
>+          sort2: 0.98621619770882
>+
>+        - borrowernumber: 21
>+          cardnumber: 23529000139858
>+          surname: Ballard
>+          firstname: Ronnie
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 5730 Library Rd.
>+          address2: ~
>+          city: Centerville, CA
>+          zipcode: 44262
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1956-02-23"
>+          branchcode: MPL
>+          categorycode: T
>+          dateenrolled: "1989-06-01"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000139858
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.12937704206386
>+          sort2: 0.68823664792649
>+
>+        - borrowernumber: 22
>+          cardnumber: 23529000224510
>+          surname: Gaines
>+          firstname: Joyce
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 6012 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1957-08-01"
>+          branchcode: SPL
>+          categorycode: YA
>+          dateenrolled: "1992-09-16"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000224510
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.053052144174513
>+          sort2: 0.20055080782673
>+
>+        - borrowernumber: 23
>+          cardnumber: 23529000120056
>+          surname: Bryan
>+          firstname: Johnny
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 8180 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1961-10-24"
>+          branchcode: MPL
>+          categorycode: PT
>+          dateenrolled: "1990-08-22"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000120056
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.84359763734378
>+          sort2: 0.61633579397233
>+
>+        - borrowernumber: 24
>+          cardnumber: 23529000218553
>+          surname: Duffy
>+          firstname: Joann
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 1555 Library Rd.
>+          address2: ~
>+          city: Portland, OR
>+          zipcode: 44240
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1942-02-17"
>+          branchcode: MPL
>+          categorycode: ST
>+          dateenrolled: "1984-08-02"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000218553
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.55088608856395
>+          sort2: 0.90542309163643
>+
>+        - borrowernumber: 25
>+          cardnumber: 23529000662701
>+          surname: Mejia
>+          firstname: Armando
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 8209 Library Rd.
>+          address2: ~
>+          city: Portland, OR
>+          zipcode: 44240
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1939-07-22"
>+          branchcode: SPL
>+          categorycode: PT
>+          dateenrolled: "1990-09-26"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000662701
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.87445722322395
>+          sort2: 0.65601687194409
>+
>+        - borrowernumber: 26
>+          cardnumber: 23529000092040
>+          surname: Hendrix
>+          firstname: Keith
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 6546 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1944-04-05"
>+          branchcode: SPL
>+          categorycode: PT
>+          dateenrolled: "1987-12-12"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000092040
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.65671272078223
>+          sort2: 0.31551301881253
>+
>+        - borrowernumber: 27
>+          cardnumber: 23529000058017
>+          surname: Turner
>+          firstname: Sherri
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 1731 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1964-11-21"
>+          branchcode: FRL
>+          categorycode: PT
>+          dateenrolled: "1987-09-14"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000058017
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.60742696244961
>+          sort2: 0.090595786544118
>+
>+        - borrowernumber: 28
>+          cardnumber: 23529000299603
>+          surname: Cherry
>+          firstname: Lillie
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 263 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1931-01-19"
>+          branchcode: MPL
>+          categorycode: PT
>+          dateenrolled: "1993-03-19"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000299603
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.6306980761054
>+          sort2: 0.88170305162827
>+
>+        - borrowernumber: 29
>+          cardnumber: 23529000121682
>+          surname: Schneider
>+          firstname: Nicole
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 1008 Library Rd.
>+          address2: ~
>+          city: Centerville, CA
>+          zipcode: 44306
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1954-01-12"
>+          branchcode: FRL
>+          categorycode: ST
>+          dateenrolled: "1985-09-09"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000121682
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.5164210605588
>+          sort2: 0.93699617864284
>+
>+        - borrowernumber: 30
>+          cardnumber: 23529000240482
>+          surname: White
>+          firstname: Jamie
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 937 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1950-04-22"
>+          branchcode: FRL
>+          categorycode: T
>+          dateenrolled: "1990-02-03"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000240482
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.13571774227146
>+          sort2: 0.86760020616241
>+
>+        - borrowernumber: 31
>+          cardnumber: 23529000714163
>+          surname: Burgess
>+          firstname: Dawn
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 7907 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: ~
>+          branchcode: MPL
>+          categorycode: PT
>+          dateenrolled: "1985-05-23"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000714163
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.93084783473131
>+          sort2: 0.051438585902973
>+
>+        - borrowernumber: 32
>+          cardnumber: 23529000318858
>+          surname: Bennett
>+          firstname: Pamela
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 9898 Library Rd.
>+          address2: ~
>+          city: Centerville, CA
>+          zipcode: 44310
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1946-09-16"
>+          branchcode: MPL
>+          categorycode: ST
>+          dateenrolled: "1984-05-08"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000318858
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.46464945605458
>+          sort2: 0.16893155329761
>+
>+        - borrowernumber: 33
>+          cardnumber: 23529000526047
>+          surname: Hatfield
>+          firstname: Lester
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 393 Library Rd.
>+          address2: ~
>+          city: Centerville, CA
>+          zipcode: 44262
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1983-01-22"
>+          branchcode: SPL
>+          categorycode: ST
>+          dateenrolled: "1988-07-30"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000526047
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.45070942905798
>+          sort2: 0.74675251613069
>+
>+        - borrowernumber: 34
>+          cardnumber: 23529000686353
>+          surname: Harper
>+          firstname: Ruben
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 6963 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1917-09-24"
>+          branchcode: SPL
>+          categorycode: S
>+          dateenrolled: "1991-02-19"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000686353
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.38163432421315
>+          sort2: 0.66791410340733
>+
>+        - borrowernumber: 35
>+          cardnumber: 23529000719519
>+          surname: Kinney
>+          firstname: Mae
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 2114 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: ~
>+          branchcode: SPL
>+          categorycode: J
>+          dateenrolled: "1991-12-29"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000719519
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.19466757513086
>+          sort2: 0.96959559616595
>+
>+        - borrowernumber: 36
>+          cardnumber: 23529000179433
>+          surname: Williamson
>+          firstname: Catherine
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 5879 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1930-12-18"
>+          branchcode: FRL
>+          categorycode: K
>+          dateenrolled: "1985-01-23"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000179433
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.26397528617082
>+          sort2: 0.41108967308988
>+
>+        - borrowernumber: 37
>+          cardnumber: 23529000197047
>+          surname: Charles
>+          firstname: Lisa
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 6813 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1982-10-14"
>+          branchcode: MPL
>+          categorycode: K
>+          dateenrolled: "1988-11-14"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000197047
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.26352253767058
>+          sort2: 0.084343699816934
>+
>+        - borrowernumber: 38
>+          cardnumber: 23529000695412
>+          surname: Singleton
>+          firstname: Bob
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 4554 Library Rd.
>+          address2: ~
>+          city: Centerville, CA
>+          zipcode: 44262
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1983-04-15"
>+          branchcode: FRL
>+          categorycode: PT
>+          dateenrolled: "1991-07-01"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000695412
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.63115091680656
>+          sort2: 0.90272351531566
>+
>+        - borrowernumber: 39
>+          cardnumber: 23529000603242
>+          surname: Mcconnell
>+          firstname: Terrence
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 7200 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1949-06-10"
>+          branchcode: SPL
>+          categorycode: PT
>+          dateenrolled: "1984-05-31"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000603242
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.62016485689223
>+          sort2: 0.39265376924784
>+
>+        - borrowernumber: 40
>+          cardnumber: 23529000589458
>+          surname: Knight
>+          firstname: Mabel
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 8997 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1952-12-22"
>+          branchcode: SPL
>+          categorycode: T
>+          dateenrolled: "1985-04-17"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000589458
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.10277430629616
>+          sort2: 0.33591025447092
>+
>+        - borrowernumber: 41
>+          cardnumber: 23529000054503
>+          surname: Odom
>+          firstname: Gloria
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 9156 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1952-04-05"
>+          branchcode: SPL
>+          categorycode: S
>+          dateenrolled: "1992-07-21"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000054503
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.37122838419976
>+          sort2: 0.84841118831971
>+
>+        - borrowernumber: 42
>+          cardnumber: 23529000126806
>+          surname: Hopkins
>+          firstname: Brent
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 6692 Library Rd.
>+          address2: ~
>+          city: Santa Cruz, CA
>+          zipcode: 21234
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1977-11-13"
>+          branchcode: SPL
>+          categorycode: T
>+          dateenrolled: "1984-06-28"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000126806
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.12837081973289
>+          sort2: 0.096620564438981
>+
>+        - borrowernumber: 43
>+          cardnumber: 23529000104159
>+          surname: Benson
>+          firstname: Clinton
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 4695 Library Rd.
>+          address2: ~
>+          city: Atwater, OH
>+          zipcode: 21234
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: ~
>+          branchcode: MPL
>+          categorycode: YA
>+          dateenrolled: "1985-10-28"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000104159
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.097990393729872
>+          sort2: 0.20009030606606
>+
>+        - borrowernumber: 44
>+          cardnumber: 23529000395609
>+          surname: Stuart
>+          firstname: Shannon
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 5011 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1951-02-13"
>+          branchcode: FRL
>+          categorycode: PT
>+          dateenrolled: "1986-01-16"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000395609
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.70648037987433
>+          sort2: 0.93213101190713
>+
>+        - borrowernumber: 45
>+          cardnumber: 23529000050113
>+          surname: Alford
>+          firstname: Jordan
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 5129 Library Rd.
>+          address2: ~
>+          city: Centerville, CA
>+          zipcode: 44262
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1952-05-27"
>+          branchcode: MPL
>+          categorycode: ST
>+          dateenrolled: "1985-09-09"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000050113
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.54121395064631
>+          sort2: 0.90967674824379
>+
>+        - borrowernumber: 46
>+          cardnumber: 23529000053836
>+          surname: Mcfarland
>+          firstname: Marilyn
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 4600 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: ~
>+          branchcode: SPL
>+          categorycode: PT
>+          dateenrolled: "1984-05-09"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000053836
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.92474192001367
>+          sort2: 0.89467938607063
>+
>+        - borrowernumber: 47
>+          cardnumber: 23529000774373
>+          surname: Morris
>+          firstname: Lauren
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 5436 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: ~
>+          branchcode: SPL
>+          categorycode: PT
>+          dateenrolled: "1986-03-20"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000774373
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.69917120104578
>+          sort2: 0.81181787775067
>+
>+        - borrowernumber: 48
>+          cardnumber: 23529000117565
>+          surname: Palmer
>+          firstname: Bill
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 2761 Library Rd.
>+          address2: ~
>+          city: Springfield, MA
>+          zipcode: 44224
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1984-01-10"
>+          branchcode: SPL
>+          categorycode: PT
>+          dateenrolled: "1991-10-07"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: M
>+          userid: 23529000117565
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.96157581634966
>+          sort2: 0.37242547922994
>+
>+        - borrowernumber: 49
>+          cardnumber: 23529000651225
>+          surname: Burton
>+          firstname: Mary
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 8131 Library Rd.
>+          address2: ~
>+          city: Santa Cruz, CA
>+          zipcode: 21234
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1977-12-25"
>+          branchcode: MPL
>+          categorycode: PT
>+          dateenrolled: "1985-05-30"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529000651225
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.97739997783434
>+          sort2: 0.76972348221552
>+
>+        - borrowernumber: 50
>+          cardnumber: 23529001223636
>+          surname: Peters
>+          firstname: Tommy
>+          title: ~
>+          othernames: ~
>+          initials: ""
>+          streetnumber: ~
>+          streettype: ~
>+          address: 5171 Library Rd.
>+          address2: ~
>+          city: Portland, ME
>+          zipcode: 44236
>+          email: ~
>+          phone: (212) 555-1212
>+          mobile: ~
>+          fax: ~
>+          emailpro: ~
>+          phonepro: ~
>+          B_streetnumber: ~
>+          B_streettype: ~
>+          B_address: ~
>+          B_city: ~
>+          B_zipcode: ~
>+          B_email: ~
>+          B_phone: ~
>+          dateofbirth: "1951-06-14"
>+          branchcode: SPL
>+          categorycode: PT
>+          dateenrolled: "1984-05-09"
>+          dateexpiry: "2020-12-31"
>+          gonenoaddress: ~
>+          lost: ~
>+          debarred: ~
>+          contactname: ""
>+          contactfirstname: ~
>+          contacttitle: ~
>+          borrowernotes: ~
>+          relationship: ~
>+          sex: F
>+          userid: 23529001223636
>+          opacnote: ~
>+          contactnote: ~
>+          password: 42b29d0771f3b7ef
>+          flags: ~
>+          sort1: 0.91641750830823
>+          sort2: 0.27291712562825
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 24584: 98464 | 98465 | 98466 | 98467 | 98468 | 98469 | 98470 | 98471 | 98472 | 98473 | 98474 | 98475 | 98476 | 98477 | 99402 | 99403 | 99404 | 99405 | 99406 | 99407 | 99408 | 99409 | 99410 | 99411 | 99412 | 99413 | 99414 | 99415 | 100352 | 100353 | 100354 | 100355 | 100356 | 100357 | 100358 | 100359 | 100360 | 100361 | 100362 | 100363 | 100364 | 100365