converting random barcode numbers to admission numbers in Eclipse.net

[colwatso]

Hi everyone - first post on here.

 

I'm working in a school (contracted) that has MLS Eclipse.net and NRS cashless catering solution. - the two are joined so that in the library - the finger prints of the kids are read, passed to the CC system and their records pulled from there. (just for the fingerprint)

 

A number of the kids are coming up with a random number (from eclipse) rather than their sims admission number which is assigned by the CC system. I've run MLS connect to get the db upto date - but for some reason the y7 and a number of the kids that have arrived after the start of the academic year, do not get assigned their admission number but the random number.

 

I've been told that there is a way of converting the random barcode numbers into the proper admission numbers automatically rather than manually.

 

(does any of this make sense to you all - coz in my mind it's how i see the problem)

 

 

Does anyone know of the patch/app/upgrade that does the conversions.

 

Thanks

[robk]

Where is the elipse library card no being read from? Theres a sql statement in the NRS library tool (click on the toolbar icon and go to settings).

[colwatso]

This is the script:

 

Select AccountCode As MLSBarcode

From Account

Inner Join Purses

On Purses.AccountGUID = Account.AccountGUID

Inner Join Biometric.dbo.Template

On Biometric.dbo.Template.BIOID = Cast(Purses.CardNumber As Int)

Where Biometric.dbo.Template.BIOID = @bioID

 

 

Interestingly enough - on the third tab (Micro Librarian Mapping) - it's blank - (not knowing much about the system as yet.) but I dont think it should be.