*cross-post from Database Managers Tessitura Community*Hi all,Has anyone managed a data import from the UK Government's schools database (used to be known as Edubase)? Here's the link: Get information about schools - GOV.UK (www.gov.uk)We'd like to start importing this data on an annual basis to help our reporting around which schools visit us over at the Gallery, and were wondering if anyone has managed this process before, or has a procedure for a recurring annual import of this data? I'm particularly interested to know how the process around attributes/attribute values works, as well as how to handle affiliations. Would love to chat to anyone that's managed this before or has any advice.If it helps, we're a Tessitura-hosted organisation running TNEW. We currently collect some information from schools that book via a web form, which gets converted into a CSI on the school's, but would love to keep what we ask here to questions directly relevant to the booking itself, rather than school demographics.
Hey James,
This is something that we've done at the Science Museum Group. Each year we download the data from the DfE's website and upload it into a local reference table. We then place the schools URN (unique reference number) as an attribute on their Tess record to link the data together.
There was quite a lot of discussion at TLCC in Gateshead about Education data and trying to find common themes in the what data we would all find useful for Education group visits, and I think this is a conversation we're going to pick up at a future EU Data and Insight community group meetup, so if you're not already a member of that group, you might want to join.
In the meantime, if you have any questions about how we handle this at the Science Museum Group then I'd be more than happy to jump on a call.
Grae
Hey Grae,Thanks for the detailed response; really good to know where you're at with this, and promising to know a yearly upload is doable! Would love to jump on a call to discuss if you have the time. Feel free to give me a shout on my email address with timings that work for you: jgallagher@npg.org.uk Thanks so much,James