How do you do....it? Thread, converting random barcode numbers to admission numbers in Eclipse.net in Technical; Hi everyone - first post on here.
I'm working in a school (contracted) that has MLS Eclipse.net and NRS cashless ...
17th February 2012, 09:51 AM #1
- Rep Power
converting random barcode numbers to admission numbers in Eclipse.net
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.
IDG Tech News
17th February 2012, 06:35 PM #2
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).
20th February 2012, 01:02 PM #3
- Rep Power
This is the script:
Select AccountCode As MLSBarcode
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.
By Mcshammer_dj in forum MIS Systems
Last Post: 6th November 2013, 01:51 PM
By fiza in forum MIS Systems
Last Post: 11th October 2011, 07:39 PM
By reggiep in forum Home Access Plus+
Last Post: 28th April 2011, 02:23 PM
By Tony_Mc in forum How do you do....it?
Last Post: 30th October 2010, 10:20 AM
By Stuart_C in forum Windows
Last Post: 30th April 2009, 04:45 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)