Blog Archives

Protected: Release Note: Emerge for Parents 0.1 Late 2013

There is no excerpt because this is a protected post.

Posted in Xpressions | Comments Off on Protected: Release Note: Emerge for Parents 0.1 Late 2013

Emerge 2.5.2+

  This release note covers the features added in the 2.5.2 and later family of Emerge releases across all supported platforms. This includes but is not limited to – 2.5.2 & 2.5.3 for iOS devices, and 2.52 for Android devices. … Continue Reading

Posted in Messenger v5 | Comments Off on Emerge 2.5.2+

Protected: Release Note: Messenger 5.5 December 2013

There is no excerpt because this is a protected post.

Posted in Messenger v5 | Comments Off on Protected: Release Note: Messenger 5.5 December 2013

Use of SQL Indexes

Groupcall XVault will continue to operate if the SQL database has indexes created within it; you should exercise caution in your indexing policy to ensure that you do not create excessive or duplicate indexes. The following SQL allows you to … Continue Reading

Posted in XVault | Comments Off on Use of SQL Indexes

Use of SQL Triggers

Groupcall XVault will continue to operate if the SQL database has triggers created within it; you should exercise caution in not causing excessive or recursive locks when invoking triggers.  The safest approach with triggers is to cause a change to … Continue Reading

Posted in Uncategorized, XVault | Comments Off on Use of SQL Triggers

SIF RefIds

SIF data objects are identified using RefIds; these are basically GUIDs with a different formatting. A RefId within a zone can be relied upon to be unique, however you should not rely on RefId to be unique between zones and … Continue Reading

Posted in XVault | Comments Off on SIF RefIds

XVault – Typical Integration Scenarios

This section details how to integrate with XVault for specific scenarios, providing example SQL where possible.                

Posted in XVault | Comments Off on XVault – Typical Integration Scenarios

SQL Tables per Data Object

Object Tables Join on SchoolInfo SchoolInfo (no sub-tables) LearnerPersonal LearnerPersonalOtherAddress, OtherEmail, OtherId, OtherPhoneNumber  OwnerRefId, OwnerType OwnerRefId, OwnerType OwnerRefId, OwnerType OwnerRefId, OwnerType LearnerSchoolEnrolment LearnerSchoolEnrolment (no sub-tables) WorkforcePersonal WorkforcePersonalCurrentAssignment OtherAddress, OtherEmail, OtherId, OtherPhoneNumber OwnerRefId, OwnerType OwnerRefId, OwnerType OwnerRefId, OwnerType OwnerRefId, OwnerType OwnerRefId, … Continue Reading

Posted in XVault | Comments Off on SQL Tables per Data Object

SIF Data Objects Entity Relationship Diagram

This diagram is available via the UK SIF Association website.  The UK SIF community develops the SIF standard for data in the UK.

Posted in XVault | Comments Off on SIF Data Objects Entity Relationship Diagram

SIF Data Objects

Groupcall XVault stores data in a slightly normalised version of the UK SIF data model, hence for any queries about data specification for a specific SIF data object, element, or attribute you should refer to the UK SIF specification. Object … Continue Reading

Posted in XVault | Comments Off on SIF Data Objects