Import patrons tool
Am I correct in assuming that this tool can only be used for batch updating of patron info if all of the existing info for each patron is included in the CSV file to be uploaded? In other words, I can't simply provide the bare minimum info & then whatever new info is desired because all of the blank field values will overwrite the values in the corresponding fields in Koha. Thank you, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast!
Whoops. I asked a similar question on the list 3 years ago & the answer is that fields will not be overwritten with null values as long as those columns are not included in the CSV file. So as long as you have the minimum fields required, the Patron Import tool can be used to update only select fields. Minimum fields = borrownumber or cardnumber + branchcode + categorycode + any fields marked as mandatory under the BorrowerMandatoryField global preference. Our plan is to update patron records with default userids & passwords & then send out an email encouraging folks to log in & take advantage of the various account features. Passwords will be something like last 6 digits of their library card number. Cheers, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast! On Mon, Dec 3, 2012 at 3:08 PM, Cab Vinton <bibliwho@gmail.com> wrote:
Am I correct in assuming that this tool can only be used for batch updating of patron info if all of the existing info for each patron is included in the CSV file to be uploaded?
In other words, I can't simply provide the bare minimum info & then whatever new info is desired because all of the blank field values will overwrite the values in the corresponding fields in Koha.
Thank you,
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH
Life is short. Read fast!
Thanks Cab, that's very helpful - it answered some of my questions about the patron upload. Elaine On Mon, Dec 3, 2012 at 8:38 PM, Cab Vinton <bibliwho@gmail.com> wrote:
Whoops. I asked a similar question on the list 3 years ago & the answer is that fields will not be overwritten with null values as long as those columns are not included in the CSV file.
So as long as you have the minimum fields required, the Patron Import tool can be used to update only select fields.
Minimum fields = borrownumber or cardnumber + branchcode + categorycode + any fields marked as mandatory under the BorrowerMandatoryField global preference.
Our plan is to update patron records with default userids & passwords & then send out an email encouraging folks to log in & take advantage of the various account features.
Passwords will be something like last 6 digits of their library card number.
Cheers,
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH
Life is short. Read fast!
On Mon, Dec 3, 2012 at 3:08 PM, Cab Vinton <bibliwho@gmail.com> wrote:
Am I correct in assuming that this tool can only be used for batch updating of patron info if all of the existing info for each patron is included in the CSV file to be uploaded?
In other words, I can't simply provide the bare minimum info & then whatever new info is desired because all of the blank field values will overwrite the values in the corresponding fields in Koha.
Thank you,
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH
Life is short. Read fast!
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://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)
participants (2)
-
Cab Vinton -
Elaine Bradtke