Skip to content

External Pupil Database ​

Looking a pupil up in your authority's or school's own pupil system from inside Xperios, so staff type a surname once rather than copying details between two screens.

Where to find it: Settings > Organisation > External Pupil Database

How the pieces fit together ​

One computer inside your network runs the Xperios ODBC Agent. It reads a view in your own pupil extract and dials out to Xperios to answer lookups. Xperios never connects in to you.

No credentials are held in Xperios, by design

The ODBC connection's user id and password stay on that machine, encrypted there. This screen holds only the view name and the field mappings — what the data is called, never how to get at it.

That split is what lets the feature work at all now that Xperios is hosted rather than installed: the old way needed an ODBC connection set up on every member of staff's desktop.

Getting it going ​

Pairing codeGenerates a code to type into the agent on the machine that will do the reading. It is used once, and that machine is then paired for good
View nameThe view in your extract, for example PUPIL_EXTRACT
Field mappingsWhich column in your view holds each thing Xperios wants
Value for male / Value for femaleHowever your system records sex, so Xperios can read it
Most rows to returnA sensible ceiling on a search
Make staff enter a date of birth before searchingNarrows a search to one child rather than every Patel in the authority
Offer the external pupil database to staffThe switch that puts it in front of anybody

Test with surname runs a real lookup through a chosen agent and shows you what came back — the thing to do after any change to the view or the mappings, rather than waiting for somebody to search for a pupil.

A mapped column that does not exist is reported, not guessed

After a test, any mapping naming a column the view does not have is listed back to you. Check the spelling, or run the test again if the view has changed since. A mapping is just a name until a lookup proves it.

The banner is the first thing to read ​

A line across the top says whether a lookup would work right now, and it does the diagnosis for you:

What it saysWhat to do
"...is not running, so pupils cannot be looked up... It starts when someone signs in to that computer, so signing in there will bring it back."Somebody signs in to that machine
"...is running, but it is not connected to this Xperios... Check the server address in that agent's own settings"The agent is pointed at the test system instead of the live one, or the reverse
"No machine has been paired to read the pupil database."Install the agent and pair it
"...has no view or field mappings set up yet."Finish the setup above
"...is switched off for this customer."Not a fault — the last switch above is off

The agent starts when somebody signs in to its machine

This is the one to know before anything else, because it is the commonest cause of "the pupil search has stopped working". A computer that rebooted overnight for Windows updates and has not been logged into since has no agent running.

The fix is somebody signing in to that machine — not reinstalling anything, and not a problem at our end. It is also the argument for pairing a machine that somebody signs into every morning rather than one in a cupboard.

The machines you have paired ​

Column
MachineIts name, with the agent's own name underneath where they differ
StatusConnected now, or not
Last seenWhen it last reported in
Pupil databaseWhether it can read the extract
LookupsHow many it has answered, and how many failed
VersionWhat it is running

Revoke stops a machine answering: "Revoke ...? It will stop answering pupil lookups immediately, and the agent on that computer will have to be paired again with a new code." Use it when a machine is replaced or leaves the network.

Last seen tells you more than Status does

Status is what this Xperios can see; Last seen comes from a record shared between the live and test systems. So an agent that is not connected but was seen a minute ago is alive and talking to the other environment — which is exactly the case the banner's second message is about.

See also ​

Paritor - Winslade Park, Manor Drive, Clyst St Mary, EX5 1FY