XML Schema Updating

Everytime the custom data is modified, BadgePass will increment the XML schema number for that entity by 1.  There is no progress bar that will tell you when it is done updating the schema of all entities, but you can view it in SQL by running the following query by replacing Person1 with Employee, Visitor, Person1, Person2, or Person3 and %person% with employee or visitor:

Depending on how many records are in the database, you should get results that look similar to this:

For this example, this record is on schema 0 noted by Person1_0 in the customData portion.  You can check how many total records are in the 0 schema by running the following query:

We modify the like '%person1_0%' to match the schema that we want to check the progress on and you should see a flat count.

To temporarily speed up the record updates, you can right click and choose Modify on EmployeeInsertAndUpdate inside of the Triggers section of the entity.  Leave this SQL script open to re-add the script once you are finished.  Now right click and delete the EmployeeInsertAndUpdate trigger.  Now go back to Management Console and make a change to the entity to start the update process.  Once it has finished, go back to the script and change ALTER TRIGGER to CREATE TRIGGER and hit Execute.