The spreadsheet was one I made up quite a while back to help Rosalie when she needed a few numbers because she was waiting for barcodes. I didn't have the formula in front of me, so I reverse-engineered it and it may have some shortcomings. But the numbers I tested it on worked. -----Original Message----- From: Waylon Robertson [mailto:genjimoto@ezysurf.co.nz] 4/2/02 10:13:26 AM, Chris Cormack <chris@katipo.co.nz> wrote: You will find that this spreadsheet will not work. its not taking in account the 8 place multiplier, I think. Anyway, Koha has its own routine inside newmember.pl i think.. or is it member.pl. Anyway.. go to your admin page, and set AutoMemberNum to 1. that will get koha making its own card numbers.

Hi all

Further to my reply Olwen has sent through a spreadsheet that has the routine in it. Its in excel and as available for download from http://developer.koha.org/HLT2.xls

Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha