Wednesday, October 31, 2007

Watch out when you delete Persons

Prior to version 9.0 of C-Cure, you could view and export pretty much all of the person/card data for deleted persons. With the database changes made in 9.0 (person and card data split to support multiple cards per person), fields associated with the card can no longer be viewed. This includes:
  • Activation
  • Expiration
  • Badge layout and print date
  • Lost and stolen flags
If ever will need to retrieve these fields for departed persons, disable the records, but do not delete. This is true even if you do not enable the multiple card/person feature.

Note: the data remains in the card record in the C-Cure database, but seems to be ignored when C-Cure displays person data. In a pinch, it can be accessed using ODBC.