It is a test.

ID Card Printing and MIFARE® Encoding at Cambridge University Library

Cambridge University Library Logo CardExchange Producer Logo

 

A card management installation in a university is never easy, and our latest one at

Cambridge University Library certainly got Ben's mind working!

 

An Oracle database connected via ODBC, multiple tables without common unique identifiers and transposing data to print information which wasn't actually stored in the database as well as writing back to other tables with all of the card date for importing into other systems. To top it off, we had multiple designs all with different requirements!!

Often there are strong policies in place for not writing back to the main database when it comes to ensuring data integrity so we had to read from an Oracle database and write back to a bespoke postgresSQL database.

Oracle Database Logo

Usually we wouldn't have issues with reading from multiple tables in a database but this would normally rely on having common unique identifiers, in this instance this was not possible as there were multiple instances of each record as cardholders may have multiple records.  We looked at creating a view of the various tables so we could connect to that but the vendor of the database was unable to help and any changes to the main database would be in breach of licence agreements! 

This was going to be complicated!

CardExchange Producer

Thankfully CardExchange™ is able to create its own views internally by using SQL script and the SELECT and INNER JOIN commands!  We were able to create an internal relational view based on multiple tables simply, tidily and without having to change anything in the main database (with a bit of SQL knowledge of course!).

We then had the issue of having to print information which was related to but was not exactly stored in the database, we were able to use the functions and variables function within CardExchange™ and create rules which would take a value in the database and return a value which related to that field eg, values 14, 17 and 32 may return a specific value whereas 23, 56 or 22 would return another - sounds simple, well it is if you know how! 

Finally, we had to create MIFARE® read and write definitions, this is the simple part when it comes to CardExchange™, you can create a read definition to enable you to store the CSN (or UID) as well as write to as many sectors as you may want, or indeed simply locking down the remaining sectors on the card so that someone else can't!  MIFARE® encoding requires a background knowledge of the breakdown of the cards, sectors and blocks, something we are very well versed in!  MIFARE-logo

 

So, to cut a long story short, we ended up reading from multiple databases and tables reading and storing CSNs and writing to specific sectors as well as encrypting the cards. 

 

If you are looking for a card management solution and would like to discuss your specific needs or wishes, please get in touch via email, chat or call us on 01604 422422.

 

Nic Posted by Nic

Related Articles

ID Card Centre, working with Cambridge University Library to issue new MIFARE® library cards
  Cambridge University is undoubtedly one of the most prestigious education establishments in the world and their 600 year old library, housing over 8 million books is a vital, central resource to the students of the university and colleges.  Driven by a need to upgrade their student and staff cards to ‘smart’ MIFARE® cards, and realising that their current software or hardware did not support MIFARE® encoding, ID Card Centre were pleased to be able to offer a solution. The Brief – A New Card Management System When Camb..
How to licence CardExchange to a Licence Dongle
CardExchange™ offers a number of flexible licencing solutions based on different requirements.If you have a single or a few licences but need to be able to use these on various machines then using a licence dongle is often the best solution to this rather than purchasing additional licences.  Step by Step Guide to Licensing CardExchange™ to a Licence DongleIt is important that the driver of the dongle is installed before connecting the dongle to your PC and activating the license.This is the old licence dongle:   This is how the latest licence dongle looks:In the main page ..
ID Card Encoding Options
Following on from my recent piece surrounding security options today we’re going to take a more detailed look at encoding options and security cards/fobs. At ID Card Centre we can supply, print and encode a wide variety of smart technology cards therefore we have a product to suit whichever systems you possess. Whether it be for access control, cashless catering, library management or print and copy release we have you covered. Let's take a look at the ID Card encoding options you have available… ID Card Encoding There really is a mind boggling amount of different access control pr..
Sign up to our newsletter and never miss an offer again!

Exclusive money saving offers

The latest product and technology updates relevant to your business

Our ‘Spam Free’ guarantee! (We’ll only send you occasional emails about stuff we know you’ll find useful and you can unsubscribe at any time.)