Problem uploading patrons
We're running 3.18.04. One (and only one) of my colleagues is unable to upload patron files. It's very curious, she has all the permissions, and I and another colleague have uploaded the same file without a problem. I have even logged into her account and uploaded the file successfully. But whenever she tries she gets a long string of error messages that boil down to Koha not parsing the header row. I've asked her to clear her browser (Firefox) history and cookies (there's an 8 hour time difference so I won't know if this works til tomorrow) Other than that I don't know why she can't do it and we can. Any ideas what might be causing the problem? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
Elaine Bradtke schreef op do 28-05-2015 om 23:38 [+0100]:
But whenever she tries she gets a long string of error messages that boil down to Koha not parsing the header row.
Is she doing something funny to the file before importing? Like getting it, opening it, and resaving it? -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
We get an export from our membership database, run it through some batch edits in another piece of software that spits out a .CSV file with the proper headers. The .CSV file she sent me is the one she tried to use. It works fine for me, and another colleague, and for me using her login (just to make sure it isn't her account). I'm thinking it may be something local to her computer. The file, and the permissions on her account seem to be just fine. On Thu, May 28, 2015 at 11:43 PM, Robin Sheat <robin@catalyst.net.nz> wrote:
Elaine Bradtke schreef op do 28-05-2015 om 23:38 [+0100]:
But whenever she tries she gets a long string of error messages that boil down to Koha not parsing the header row.
Is she doing something funny to the file before importing? Like getting it, opening it, and resaving it?
-- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
Greetings, I'm curious if this is a windows/linux CR/LF issue? Are the files the identical size? If not, then this might be a possibility. GPML, Mark Tompsett -----Original Message----- From: Elaine Bradtke Sent: Thursday, May 28, 2015 6:58 PM To: Robin Sheat Cc: koha Subject: Re: [Koha] Problem uploading patrons We get an export from our membership database, run it through some batch edits in another piece of software that spits out a .CSV file with the proper headers. The .CSV file she sent me is the one she tried to use. It works fine for me, and another colleague, and for me using her login (just to make sure it isn't her account). I'm thinking it may be something local to her computer. The file, and the permissions on her account seem to be just fine.
Interesting question, but I don't think it's the problem She's running a fairly recent version of Windows. Probably the same version of Windows that her colleague is using who successfully uploaded the file. Still, I'll ask. I tested it via a windows emulator running XP (I know, but I only use Windows for legacy database software) and had no problem with it. We've never had trouble with other CSV files. I suspect operator error somewhere, but because we're not in the same room (or country for that matter) it's hard for me to see where she's going wrong. The complicated step is converting the file from the membership database to the correct format for Koha. She did that perfectly. It's odd that she stumbled at the final hurdle. On Fri, May 29, 2015 at 12:25 AM, Mark Tompsett <mtompset@hotmail.com> wrote:
Greetings,
I'm curious if this is a windows/linux CR/LF issue? Are the files the identical size? If not, then this might be a possibility.
GPML, Mark Tompsett
-----Original Message----- From: Elaine Bradtke Sent: Thursday, May 28, 2015 6:58 PM To: Robin Sheat Cc: koha Subject: Re: [Koha] Problem uploading patrons
We get an export from our membership database, run it through some batch edits in another piece of software that spits out a .CSV file with the proper headers. The .CSV file she sent me is the one she tried to use. It works fine for me, and another colleague, and for me using her login (just to make sure it isn't her account). I'm thinking it may be something local to her computer. The file, and the permissions on her account seem to be just fine.
-- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
Hi, Elaine-- Could she make a video of what she's doing using some tool like Jing, that records what she's doing on her computer, to send to you? That way she could record exactly what she's doing and then send the video to you, which might help you figure out if it's operator error or not. Cheerio! heather ~~~~~~~~~~~~~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center 415-561-7032, heather_hernandez@nps.gov http://www.nps.gov/safr/learn/historyculture/museum-collections.htm "The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg
It has taken a while to figure out what caused the patron import to fail. The CSV file that failed has returns between each patron instead of new line. Koha doesn't parse returns as new lines and so the file kept failing. Unfortunately, the software that we get the data from exports it with returns instead of new lines, and there's not a way to fix it on their end. I'd like to find a way to convert the returns to new lines so that the assistant librarian can do the uploads without my intervention. Excel doesn't seem to do the trick, unless there's a secret setting somewhere (if you know, do tell!). Does Open Office work better? Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 On Tue, Jun 2, 2015 at 8:38 AM Hernandez, Heather <heather_hernandez@nps.gov> wrote:
Hi, Elaine--
Could she make a video of what she's doing using some tool like Jing, that records what she's doing on her computer, to send to you? That way she could record exactly what she's doing and then send the video to you, which might help you figure out if it's operator error or not.
Cheerio! heather ~~~~~~~~~~~~~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center 415-561-7032, heather_hernandez@nps.gov http://www.nps.gov/safr/learn/historyculture/museum-collections.htm
"The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg
Hi Elaine You can use a text editor like Notepad++ to edit the file and remove the returns. Once you open the file go to replace and choose extended, search for \r\n and choose replace by \n. "\r" is the return and "\n" is new line. Then save as csv file and try to upload it again. Regards, Alvaro |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com Le mar. 2 avr. 2019 à 13:37, Elaine Bradtke <eb@efdss.org> a écrit :
It has taken a while to figure out what caused the patron import to fail. The CSV file that failed has returns between each patron instead of new line. Koha doesn't parse returns as new lines and so the file kept failing. Unfortunately, the software that we get the data from exports it with returns instead of new lines, and there's not a way to fix it on their end. I'd like to find a way to convert the returns to new lines so that the assistant librarian can do the uploads without my intervention. Excel doesn't seem to do the trick, unless there's a secret setting somewhere (if you know, do tell!). Does Open Office work better?
Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999
On Tue, Jun 2, 2015 at 8:38 AM Hernandez, Heather < heather_hernandez@nps.gov> wrote:
Hi, Elaine--
Could she make a video of what she's doing using some tool like Jing, that records what she's doing on her computer, to send to you? That way she could record exactly what she's doing and then send the video to you, which might help you figure out if it's operator error or not.
Cheerio! heather ~~~~~~~~~~~~~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center 415-561-7032, heather_hernandez@nps.gov http://www.nps.gov/safr/learn/historyculture/museum-collections.htm
"The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Elaine, If you can access a Linux command prompt on your Koha server, you could use the command: tr '\r' '\n' < infile > outfile (replacing infile and outfile with the appropriate file names) You might also explore the command dos2unix which will convert dos-style lie terminators (return+linefeed) to Linux style (just linefeed) Hope this helps. Chris Brown On Tue, Apr 2, 2019 at 7:36 PM Elaine Bradtke <eb@efdss.org> wrote:
It has taken a while to figure out what caused the patron import to fail. The CSV file that failed has returns between each patron instead of new line. Koha doesn't parse returns as new lines and so the file kept failing. Unfortunately, the software that we get the data from exports it with returns instead of new lines, and there's not a way to fix it on their end. I'd like to find a way to convert the returns to new lines so that the assistant librarian can do the uploads without my intervention. Excel doesn't seem to do the trick, unless there's a secret setting somewhere (if you know, do tell!). Does Open Office work better?
Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999
On Tue, Jun 2, 2015 at 8:38 AM Hernandez, Heather < heather_hernandez@nps.gov> wrote:
Hi, Elaine--
Could she make a video of what she's doing using some tool like Jing, that records what she's doing on her computer, to send to you? That way she could record exactly what she's doing and then send the video to you, which might help you figure out if it's operator error or not.
Cheerio! heather ~~~~~~~~~~~~~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center 415-561-7032, heather_hernandez@nps.gov http://www.nps.gov/safr/learn/historyculture/museum-collections.htm
"The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
I've also used notepad++ to fix this issue in the past. Another similar issue to watch for is UTF-8 byte order marks: Koha doesn't like them, at least in our environment, and Notepad++ can clear those out, too. Joel Coehoorn Director of Information Technology 402.363.5603 *jcoehoorn@york.edu <jcoehoorn@york.edu>* *Please contact helpdesk@york.edu <helpdesk@york.edu> for technical assistance.* The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society On Tue, Apr 2, 2019 at 3:32 PM Chris Brown <chris@stayawake.co.uk> wrote:
Hi Elaine,
If you can access a Linux command prompt on your Koha server, you could use the command:
tr '\r' '\n' < infile > outfile
(replacing infile and outfile with the appropriate file names)
You might also explore the command dos2unix which will convert dos-style lie terminators (return+linefeed) to Linux style (just linefeed)
Hope this helps.
Chris Brown
On Tue, Apr 2, 2019 at 7:36 PM Elaine Bradtke <eb@efdss.org> wrote:
It has taken a while to figure out what caused the patron import to fail. The CSV file that failed has returns between each patron instead of new line. Koha doesn't parse returns as new lines and so the file kept failing. Unfortunately, the software that we get the data from exports it with returns instead of new lines, and there's not a way to fix it on their end. I'd like to find a way to convert the returns to new lines so that the assistant librarian can do the uploads without my intervention. Excel doesn't seem to do the trick, unless there's a secret setting somewhere (if you know, do tell!). Does Open Office work better?
Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142 Charity Registered in England and Wales No. 305999
On Tue, Jun 2, 2015 at 8:38 AM Hernandez, Heather < heather_hernandez@nps.gov> wrote:
Hi, Elaine--
Could she make a video of what she's doing using some tool like Jing, that records what she's doing on her computer, to send to you? That way she could record exactly what she's doing and then send the video to you, which might help you figure out if it's operator error or not.
Cheerio! heather ~~~~~~~~~~~~~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center 415-561-7032, heather_hernandez@nps.gov http://www.nps.gov/safr/learn/historyculture/museum-collections.htm
"The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
On Tue, Apr 02, 2019 at 11:36:36AM -0700, Elaine Bradtke wrote:
It has taken a while to figure out what caused the patron import to fail. The CSV file that failed has returns between each patron instead of new line. Koha doesn't parse returns as new lines and so the file kept failing. Unfortunately, the software that we get the data from exports it with returns instead of new lines, and there's not a way to fix it on their end. I'd like to find a way to convert the returns to new lines so that the assistant librarian can do the uploads without my intervention. Excel doesn't seem to do the trick, unless there's a secret setting somewhere (if you know, do tell!). Does Open Office work better?
In Linux or UNIX, this command will do the trick: perl -i -p -e 'tr/\x0d/\x0a/' FILE (Option -i means "change the file in place"; _perldoc perlrun_ can help you understand the other options.) To do the same but keeping a backup with extension .bak: perl -i.bak -p -e 'tr/\x0d/\x0a/' FILE To copy from FILE1 to FILE2, changing CR to LF: perl -p -e 'tr/\x0d/\x0a/' < FILE1 > FILE2 Paul. -- Paul Hoffman <paul@flo.org> Software Manager Fenway Library Organization 550 Huntington Ave. Boston, MA 02115 617-989-5032
Hi Paul, you can use SciTE. View > End of Line Options > Line End Characters Options > Convert Line End Characters https://en.wikipedia.org/wiki/SciTE Regards, Holger -----Ursprüngliche Nachricht----- Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von Paul Hoffman Gesendet: Mittwoch, 3. April 2019 16:32 An: koha@lists.katipo.co.nz Betreff: Re: [Koha] Problem uploading patrons On Tue, Apr 02, 2019 at 11:36:36AM -0700, Elaine Bradtke wrote:
It has taken a while to figure out what caused the patron import to fail. The CSV file that failed has returns between each patron instead of new line. Koha doesn't parse returns as new lines and so the file kept failing. Unfortunately, the software that we get the data from exports it with returns instead of new lines, and there's not a way to fix it on their end. I'd like to find a way to convert the returns to new lines so that the assistant librarian can do the uploads without my intervention. Excel doesn't seem to do the trick, unless there's a secret setting somewhere (if you know, do tell!). Does Open Office work better?
In Linux or UNIX, this command will do the trick: perl -i -p -e 'tr/\x0d/\x0a/' FILE (Option -i means "change the file in place"; _perldoc perlrun_ can help you understand the other options.) To do the same but keeping a backup with extension .bak: perl -i.bak -p -e 'tr/\x0d/\x0a/' FILE To copy from FILE1 to FILE2, changing CR to LF: perl -p -e 'tr/\x0d/\x0a/' < FILE1 > FILE2 Paul. -- Paul Hoffman <paul@flo.org> Software Manager Fenway Library Organization 550 Huntington Ave. Boston, MA 02115 617-989-5032 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Sorry Paul, I meant: Hi Elaine. -----Ursprüngliche Nachricht----- Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von Paul Hoffman Gesendet: Mittwoch, 3. April 2019 16:32 An: koha@lists.katipo.co.nz Betreff: Re: [Koha] Problem uploading patrons On Tue, Apr 02, 2019 at 11:36:36AM -0700, Elaine Bradtke wrote:
It has taken a while to figure out what caused the patron import to fail. The CSV file that failed has returns between each patron instead of new line. Koha doesn't parse returns as new lines and so the file kept failing. Unfortunately, the software that we get the data from exports it with returns instead of new lines, and there's not a way to fix it on their end. I'd like to find a way to convert the returns to new lines so that the assistant librarian can do the uploads without my intervention. Excel doesn't seem to do the trick, unless there's a secret setting somewhere (if you know, do tell!). Does Open Office work better?
In Linux or UNIX, this command will do the trick: perl -i -p -e 'tr/\x0d/\x0a/' FILE (Option -i means "change the file in place"; _perldoc perlrun_ can help you understand the other options.) To do the same but keeping a backup with extension .bak: perl -i.bak -p -e 'tr/\x0d/\x0a/' FILE To copy from FILE1 to FILE2, changing CR to LF: perl -p -e 'tr/\x0d/\x0a/' < FILE1 > FILE2 Paul. -- Paul Hoffman <paul@flo.org> Software Manager Fenway Library Organization 550 Huntington Ave. Boston, MA 02115 617-989-5032 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Thanks everyone for your advice - I know you can fix this with Linux or Unix (that's how it was fixed this time around), but that's not something the assistant librarian is able to do. We will try the other approaches. Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 On Wed, Apr 3, 2019 at 7:32 AM Paul Hoffman <paul@flo.org> wrote:
On Tue, Apr 02, 2019 at 11:36:36AM -0700, Elaine Bradtke wrote:
It has taken a while to figure out what caused the patron import to fail. The CSV file that failed has returns between each patron instead of new line. Koha doesn't parse returns as new lines and so the file kept failing. Unfortunately, the software that we get the data from exports it with returns instead of new lines, and there's not a way to fix it on their end. I'd like to find a way to convert the returns to new lines so that the assistant librarian can do the uploads without my intervention. Excel doesn't seem to do the trick, unless there's a secret setting somewhere (if you know, do tell!). Does Open Office work better?
In Linux or UNIX, this command will do the trick:
perl -i -p -e 'tr/\x0d/\x0a/' FILE
(Option -i means "change the file in place"; _perldoc perlrun_ can help you understand the other options.)
To do the same but keeping a backup with extension .bak:
perl -i.bak -p -e 'tr/\x0d/\x0a/' FILE
To copy from FILE1 to FILE2, changing CR to LF:
perl -p -e 'tr/\x0d/\x0a/' < FILE1 > FILE2
Paul.
-- Paul Hoffman <paul@flo.org> Software Manager Fenway Library Organization 550 Huntington Ave. Boston, MA 02115 617-989-5032 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
It turns out Libre Office saving as text files, give an option that allows you to choose the line termination. Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 On Thu, Apr 4, 2019 at 9:19 AM Elaine Bradtke <eb@efdss.org> wrote:
Thanks everyone for your advice - I know you can fix this with Linux or Unix (that's how it was fixed this time around), but that's not something the assistant librarian is able to do. We will try the other approaches. Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999
On Wed, Apr 3, 2019 at 7:32 AM Paul Hoffman <paul@flo.org> wrote:
On Tue, Apr 02, 2019 at 11:36:36AM -0700, Elaine Bradtke wrote:
It has taken a while to figure out what caused the patron import to fail. The CSV file that failed has returns between each patron instead of new line. Koha doesn't parse returns as new lines and so the file kept failing. Unfortunately, the software that we get the data from exports it with returns instead of new lines, and there's not a way to fix it on their end. I'd like to find a way to convert the returns to new lines so that the assistant librarian can do the uploads without my intervention. Excel doesn't seem to do the trick, unless there's a secret setting somewhere (if you know, do tell!). Does Open Office work better?
In Linux or UNIX, this command will do the trick:
perl -i -p -e 'tr/\x0d/\x0a/' FILE
(Option -i means "change the file in place"; _perldoc perlrun_ can help you understand the other options.)
To do the same but keeping a backup with extension .bak:
perl -i.bak -p -e 'tr/\x0d/\x0a/' FILE
To copy from FILE1 to FILE2, changing CR to LF:
perl -p -e 'tr/\x0d/\x0a/' < FILE1 > FILE2
Paul.
-- Paul Hoffman <paul@flo.org> Software Manager Fenway Library Organization 550 Huntington Ave. Boston, MA 02115 617-989-5032 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (9)
-
Alvaro Cornejo -
Chris Brown -
Coehoorn, Joel -
Elaine Bradtke -
Hernandez, Heather -
Holger Meissner -
Mark Tompsett -
Paul Hoffman -
Robin Sheat