Koha:Bulk Patron Import
From TSAS Library
- In Wen-GAGE, create Data Object list including the following columns:
- Student UID
- Full Last Name First
- Is Enrolled (only midyear)
- On Time Graduation Year
- Birthdate
- Picture URL (not working ATM, but should be an easy batch download. Koha instructions here
- Remove terrible formatting from Wen-GAGE export (unmerge columns)
- Download starter .csv file
- Copy columns from export file to .csv, then delete any blank columns
- cardnumber = Student UID
- Divide Last, First names with Text to Columns in Excel
- Ensure .csv is comma-separated (the default)
- Enter following in Default Values box before submitting
- Home library
- Patron category
- Registration date (today, or August 1)
- Expiry date (five years from today, or August 1)
- Password