Bug 5379 - import_borrowers.pl fails with db insert/update errors
authorChris Nighswonger <cnighswonger@foundations.edu>
Fri, 12 Nov 2010 14:34:52 +0000 (09:34 -0500)
committerChris Cormack <chrisc@catalyst.net.nz>
Mon, 4 Jul 2011 23:15:00 +0000 (11:15 +1200)
commitae48ebbcaae50a0af7ceca00d04f2aedb8d5cc2c
treec2e2fa6f898ca4914fed66d9ac27a5fd948cfc4b
parent36c8531394f354c694d1f72d8769461dccc9591f
Bug 5379 - import_borrowers.pl fails with db insert/update errors

Some spreadsheet programs use smart quotes which causes the db to throw
an error when an insert/update is attempted due to improper processing
of the CSV file. This patch adds code to check for smart quotes and change
them to "dumb" quotes.

This patch also adds more logging of errors and a notice to the user to check
the logs for errors when they occur.

Signed-off-by: Liz Rea <wizzyrea@gmail.com>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
C4/Members.pm
C4/Members/Attributes.pm
tools/import_borrowers.pl