+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1

    Join Date
    Feb 2012
    Location
    leeds, west yorkshire
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    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.

    Thanks

  2. #2
    robk's Avatar
    Join Date
    Nov 2005
    Location
    Ashbourne
    Posts
    549
    Thank Post
    179
    Thanked 130 Times in 109 Posts
    Blog Entries
    1
    Rep Power
    49
    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).

  3. #3

    Join Date
    Feb 2012
    Location
    leeds, west yorkshire
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Other Telephone numbers in SIMS
    By Mcshammer_dj in forum MIS Systems
    Replies: 8
    Last Post: 6th November 2013, 12:51 PM
  2. [SIMS] Limit numbers in SIMS Detention
    By fiza in forum MIS Systems
    Replies: 1
    Last Post: 11th October 2011, 06:39 PM
  3. Convert Home access plus site to secure site in IIS 7?
    By reggiep in forum Home Access Plus+
    Replies: 1
    Last Post: 28th April 2011, 01:23 PM
  4. Replies: 14
    Last Post: 30th October 2010, 09:20 AM
  5. Replies: 7
    Last Post: 30th April 2009, 03:45 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •