I got this figured out -- just double quote the whole thing as a string. Ex:" SCHOOL:MIDDLE SCHOOL,CURYEAR:2015,CURGRADE:06,SID:091,GRADYEAR:2055,TEACHER:SMITH" Thanks! On Fri, May 22, 2015 at 1:48 PM, Chad Roseburg <croseburg@ncrl.org> wrote:
I have 6 extended patron attributes but only the first will show up after the import.
My csv header looks like this: cardnumber, surname, firstname, address, city, state, zipcode, phone, branchcode, categorycode, dateenrolled, dateexpiry, borrowernotes, password, userid, patron_attributes
Some sanitized sample data: 2903045,OWENS,BUCK,999 FICTITIOUS PL,RICE,WA,99075,(900) 999-999,LIBMAIN,STUDENT,05/22/2015,10/31/2021,ONLINE_STUDENT,pass,93,SCHOOL:MIDDLE SCHOOL,CURYEAR:2015,CURGRADE:06,SID:091,GRADYEAR:2055,TEACHER:SMITH
Only SCHOOL shows in staff client.
-- Chad Roseburg Automation Dept. North Central Regional Library
-- Chad Roseburg Automation Dept. North Central Regional Library