Sample SQL Server 2008 code for extracting XCRI CAP 1.2 XML from a relational database

Modern relational databases tend to have good XML support, so it should be possible to extract XCRI CAP 1.2 from them using SQL. This is true for Microsoft SQL Server 2008, and here is some code that will do just that.

This example uses the sample database built in Sample SQL Server 2008 code for building an XCRI-CAP-1.2-compatible relational database and populated in Populating the sample SQL Server 2008 XCRI-CAP-1.2-compatible relational database, so if you want to run the code, follow those steps first.

A function to build course description elements

To save on some repetitive and slightly tricky code, here is a function which is used to build the description elements which are described in XCRI Terms 1.2.

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Tavis Reddick -- Create date: 2012-03-28 -- Modified: 2012-03-31 -- Description: For an instance of a course, a particular type of description in a specified language, returns an XCRI CAP description element. -- ============================================= CREATE FUNCTION [dbo].[udf_XcriCapDescription] ( -- Add the parameters for the function here @CourseId dbo.URI, @LanguageId NVARCHAR(50), @TermId dbo.URI, @VocabularyId dbo.URI ) RETURNS XML AS BEGIN -- The return variable is XML DECLARE @Result XML; WITH XMLNAMESPACES ( 'http://xcri.org/profiles/1.2/catalog/terms' AS xcriTerms, 'http://purl.org/dc/terms/' AS dcterms, 'http://www.w3.org/1999/xhtml' AS xhtml, 'http://www.w3.org/2001/XMLSchema-instance' AS xsi, DEFAULT 'http://xcri.org/profiles/1.2/catalog') -- Add the T-SQL statements to compute the return value here SELECT @Result = ( SELECT 'xcriTerms:' + @TermId AS 'dcterms:description/@xsi:type' ,Text AS 'dcterms:description' FROM dbo.Course INNER JOIN dbo.CourseDescription ON Course.CourseId = CourseDescription.CourseId WHERE Course.CourseId = @CourseId AND CourseDescription.LanguageId = @LanguageId AND CourseDescription.TermId = @TermId AND CourseDescription.VocabularyId = @VocabularyId FOR XML PATH(''), TYPE ) -- Return the result of the function RETURN @Result /* --Test SELECT dbo.udf_XcriCapDescription('http://kelpiecollege.org.uk/courses(HDLANG)', 'en', 'careerOutcome', 'http://xcri.org/profiles/catalog/terms') */ /* --Expected result <dcterms:description xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" xsi:type="xcriTerms:careerOutcome"> <div xmlns="http://www.w3.org/1999/xhtml"> <p>After picking up a smattering of Cetacean: Harbour Dolphin dialect, you could be on your way to a career as:</p> <ul> <li>dolphin gopher;</li> <li>harbourmaster's assistant.</li> </ul> </div> </dcterms:description> */ END GO

A stored procedure to return XCRI CAP 1.2 XML

This stored procedure builds a fairly comprehensive XCRI CAP 1.2 document from the sample database. It validates against the schema, but it does not (yet) pass all the tests at Craig Hawker's XCRI-CAP 1.2 Online Validator, so more work will be need for that.

The procedure calls on the function (above); apart from that, it relies on FOR XML PATH for the main structure building.

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Tavis Reddick -- Create date: 2012-03-25 to 2012-03-31 -- Description: Extracts course data in XCRI CAP 1.2 XML format. -- Licence: This work is licensed under the Creative Commons Attribution 3.0 Unported License. -- To view a copy of this license, visit http://creativecommons.org/licenses/by/3.0/ or send a -- letter to Creative Commons, 171 Second Street, Suite 300, San Francisco, California, 94105, USA. -- ============================================= CREATE PROCEDURE [dbo].[usp_Course] -- CREATE not ALTER as was the error in original published code, sorry -- Add the parameters for the stored procedure here @schemaName NVARCHAR(25) = 'XCRI CAP 1.2', -- only 'XCRI CAP 1.2' supported here @providerIdentifier NVARCHAR(25) = '0000X00XX0', -- your organizational identifier --@providerName NVARCHAR(50) = 'Acme University', -- your organizational name @language NVARCHAR(50) = 'en' -- language of text AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here IF @schemaName = 'XCRI CAP 1.2' BEGIN -- Build the XCRI CAP 1.2 XML using correlated subqueries with FOR XML PATH. WITH XMLNAMESPACES ( 'http://xcri.org/profiles/1.2/catalog/terms' AS xcriTerms, 'http://purl.org/net/cm' AS credit, 'http://purl.org/dc/elements/1.1/' AS dc, 'http://purl.org/dc/terms/' AS dcterms, 'http://purl.org/net/mlo' AS mlo, 'http://www.w3.org/1999/xhtml' AS xhtml, 'http://www.w3.org/2001/XMLSchema-instance' AS xsi, DEFAULT 'http://xcri.org/profiles/1.2/catalog') -- Attributes for root catalog element. SELECT GETDATE() AS "@generated", 'http://xcri.org/profiles/1.2/catalog http://www.xcri.co.uk/bindings/xcri_cap_1_2.xsd http://xcri.org/profiles/1.2/catalog/terms http://www.xcri.co.uk/bindings/xcri_cap_terms_1_2.xsd' AS "@xsi:schemaLocation", ( -- Attributes for child provider element. SELECT @providerIdentifier AS 'dcterms:identifier', Provider.CommonName AS 'dcterms:title', ProviderLocation.Street AS 'mlo:location/mlo:street', ProviderLocation.Town AS 'mlo:location/mlo:town', ProviderLocation.Postcode AS 'mlo:location/mlo:postcode', ProviderLocation.Address AS 'mlo:location/mlo:address', ( -- Multiple course elements. SELECT -- Use a function to return each descriptive element. dbo.udf_XcriCapDescription(Course.CourseId, @language, 'careerOutcome', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'contactHours', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'contactPattern', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'events', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'indicativeResource', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'leadsTo', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'policy', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'providedResource', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'requiredResource', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'specialFeature', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'structure', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'studyHours', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'support', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'teaching Strategy', 'http://xcri.org/profiles/catalog/terms'), dbo.udf_XcriCapDescription(Course.CourseId, @language, 'topic', 'http://xcri.org/profiles/catalog/terms'), Course.CourseId AS 'dc:identifier', -- Multiple subject elements. ( SELECT [Subject].TermId AS '@identifier' ,[Subject].Label AS 'text()' FROM dbo.Term AS [Subject] INNER JOIN dbo.CourseAttribute ON CourseAttribute.TermId = [Subject].TermId AND CourseAttribute.VocabularyId = [Subject].VocabularyId WHERE CourseAttribute.CourseId = Course.CourseId AND CourseAttribute.VocabularyId = 'http://kelpiecollege.org.uk/courses/subjects' FOR XML PATH('dc:subject'), TYPE ), COALESCE(CourseTitle.Prefix + ' ', '') + CourseTitle.MainSort + COALESCE(' ' + CourseTitle.Suffix, '') AS 'dcterms:title', Course.Url AS 'mlo:url', CourseAbstract.Text AS abstract, -- Multiple qualification elements. ( SELECT Qualification.Title AS 'mlo:qualification/dc:title', Qualification.EducationLevel AS 'mlo:qualification/dcterms:educationLevel', AwardingBody.CommonName AS 'mlo:qualification/awardedBy', AccreditingBody.CommonName AS 'mlo:qualification/accreditedBy' FROM dbo.Qualification INNER JOIN dbo.CourseQualification ON Qualification.QualificationId = CourseQualification.QualificationId LEFT OUTER JOIN dbo.Organization AS AwardingBody ON AwardingBody.OrganizationId = Qualification.AwardedBy LEFT OUTER JOIN dbo.Organization AS AccreditingBody ON AccreditingBody.OrganizationId = Qualification.AccreditedBy WHERE Course.CourseId = CourseQualification.CourseId FOR XML PATH(''), TYPE ), -- Multiple credit elements. ( SELECT CourseCredit.CreditSchemeId AS 'mlo:credit/credit:scheme', CourseCredit.CreditId AS 'mlo:credit/credit:level', CourseCredit.Value AS 'mlo:credit/credit:value' FROM dbo.CourseCredit WHERE Course.CourseId = CourseCredit.CourseId FOR XML PATH(''), TYPE ), -- Multiple presentation elements. ( SELECT Presentation.PresentationId AS 'dcterms:identifier', Presentation.Start AS 'mlo:start', Presentation.[End] AS 'end', -- Multiple studyMode elements. ( SELECT StudyMode.TermId AS '@identifier', StudyMode.Label AS 'text()' FROM dbo.Term AS StudyMode INNER JOIN dbo.PresentationAttribute ON PresentationAttribute.TermId = StudyMode.TermId AND PresentationAttribute.VocabularyId = StudyMode.VocabularyId WHERE PresentationAttribute.PresentationId = Presentation.PresentationId AND PresentationAttribute.VocabularyId = 'http://xcri.org/profiles/catalog/1.2/studyMode' FOR XML PATH('studyMode'), TYPE ), -- Multiple attendanceMode elements. ( SELECT AttendanceMode.TermId AS '@identifier', AttendanceMode.Label AS 'text()' FROM dbo.Term AS AttendanceMode INNER JOIN dbo.PresentationAttribute ON PresentationAttribute.TermId = AttendanceMode.TermId AND PresentationAttribute.VocabularyId = AttendanceMode.VocabularyId WHERE PresentationAttribute.PresentationId = Presentation.PresentationId AND PresentationAttribute.VocabularyId = 'http://xcri.org/profiles/catalog/1.2/attendanceMode' FOR XML PATH('attendanceMode'), TYPE ), -- Multiple attendancePattern elements. ( SELECT AttendancePattern.TermId AS '@identifier', AttendancePattern.Label AS 'text()' FROM dbo.Term AS AttendancePattern INNER JOIN dbo.PresentationAttribute ON PresentationAttribute.TermId = AttendancePattern.TermId AND PresentationAttribute.VocabularyId = AttendancePattern.VocabularyId WHERE PresentationAttribute.PresentationId = Presentation.PresentationId AND PresentationAttribute.VocabularyId = 'http://xcri.org/profiles/catalog/1.2/attendancePattern' FOR XML PATH('attendancePattern'), TYPE ), Organization.IndustrialId AS 'venue/provider/dc:identifier', Organization.CommonName AS 'venue/provider/dc:title', Location.Street AS 'venue/provider/mlo:location/mlo:street', Location.Town AS 'venue/provider/mlo:location/mlo:town', Location.Postcode AS 'venue/provider/mlo:location/mlo:postcode', Location.Address AS 'venue/provider/mlo:location/mlo:address' FROM dbo.Presentation INNER JOIN dbo.Course AS PresentationCourse ON PresentationCourse.CourseId = Presentation.CourseId LEFT OUTER JOIN dbo.ProviderVenue ON ProviderVenue.ProviderId = Presentation.ProviderId AND ProviderVenue.LocationId = Presentation.LocationId LEFT OUTER JOIN dbo.Location ON ProviderVenue.LocationId = Location.LocationId LEFT OUTER JOIN dbo.Organization ON ProviderVenue.ProviderId = Organization.OrganizationId WHERE PresentationCourse.CourseId = Course.CourseId FOR XML PATH('presentation'), TYPE ) FROM dbo.Course LEFT OUTER JOIN dbo.CourseTitle ON Course.CourseId = CourseTitle.CourseId AND CourseTitle.LanguageId = @language LEFT OUTER JOIN dbo.CourseAbstract ON Course.CourseId = CourseAbstract.CourseId AND CourseAbstract.LanguageId = @language FOR XML PATH('course'), TYPE ) FOR XML PATH('provider'), TYPE ) FROM dbo.Organization AS Provider LEFT OUTER JOIN dbo.ProviderVenue ON Provider.OrganizationId = ProviderVenue.ProviderId LEFT OUTER JOIN dbo.Location AS ProviderLocation ON ProviderLocation.LocationId = ProviderVenue.LocationId WHERE Provider.IndustrialId = @providerIdentifier FOR XML PATH('catalog') END; /* --Test EXEC dbo.usp_Course EXEC dbo.usp_Course @schemaName = 'XCRI CAP 1.2', @providerIdentifier = '0000X00XX0', @language = 'en' */ END;

Now, when you EXECUTE the stored procedure (try running the commented-out test statements at the end of the above code), you should get XCRI-CAP 1.2 output such as below:

<catalog xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" generated="2012-04-01T22:19:37.703" xsi:schemaLocation="http://xcri.org/profiles/1.2/catalog http://www.xcri.co.uk/bindings/xcri_cap_1_2.xsd http://xcri.org/profiles/1.2/catalog/terms http://www.xcri.co.uk/bindings/xcri_cap_terms_1_2.xsd"> <provider xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:identifier>0000X00XX0</dcterms:identifier> <dcterms:title>Kelpie College</dcterms:title> <course xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:description xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" xsi:type="xcriTerms:careerOutcome"> <div xmlns="http://www.w3.org/1999/xhtml"> <p>After picking up a smattering of Cetacean: Harbour Dolphin dialect, you could be on your way to a career as:</p> <ul> <li>dolphin gopher;</li> <li>harbourmaster's assistant.</li> </ul> </div> </dcterms:description> <dcterms:description xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" xsi:type="xcriTerms:topic"> <div xmlns="http://www.w3.org/1999/xhtml"> <p>Harbour dolphins are friendly creatures, excellent guides and reliable marine navigators. They are also very chatty.</p> <p>This introductory course will let you confidently:</p> <ul> <li>exchange pleasantries;</li> <li>ask for directions;</li> <li>barter in the local currency (the all-important commercial fish vocabulary).</li> </ul> </div> </dcterms:description> <dc:identifier>http://kelpiecollege.org.uk/courses(HDLANG)</dc:identifier> <dc:subject xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="http://kelpiecollege.org.uk/courses/subjects(S01)">interspecies linguistics</dc:subject> <dcterms:title>Conversational Cetacean Harbour Dolphin Dialect</dcterms:title> <mlo:url>http://www.kelpiecollege.org.uk/courses(HDLANG)</mlo:url> <abstract>Learn to speak the Harbour Dolphin dialect of Cetacean and converse, question and barter with these friendly and helpful creatures.</abstract> <presentation xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:identifier>C0918328-1979-E111-99C1-02F3E9FFDFEB</dcterms:identifier> <mlo:start>2012-09-01T00:00:00+01:00</mlo:start> <end>2013-05-20T00:00:00+01:00</end> <studyMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="FL">Flexible</studyMode> <attendanceMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="CM">Campus</attendanceMode> <attendancePattern xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="DT">Daytime</attendancePattern> <venue> <provider> <dc:identifier>0000X00XX0/1</dc:identifier> <dc:title>Pict Harbour College</dc:title> <mlo:location> <mlo:street>Port Street</mlo:street> <mlo:town>Picton</mlo:town> <mlo:postcode>PCT1</mlo:postcode> </mlo:location> </provider> </venue> </presentation> <presentation xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:identifier>004DA3F4-E579-E111-99C1-02F3E9FFDFEB</dcterms:identifier> <mlo:start>2013-09-01T00:00:00+01:00</mlo:start> <end>2014-05-20T00:00:00+01:00</end> <studyMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="FT">Full time</studyMode> <attendanceMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="CM">Campus</attendanceMode> <attendancePattern xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="DT">Daytime</attendancePattern> <venue> <provider> <dc:identifier>0000X00XX0/1</dc:identifier> <dc:title>Pict Harbour College</dc:title> <mlo:location> <mlo:street>Port Street</mlo:street> <mlo:town>Picton</mlo:town> <mlo:postcode>PCT1</mlo:postcode> </mlo:location> </provider> </venue> </presentation> </course> <course xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:description xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" xsi:type="xcriTerms:careerOutcome"> <div xmlns="http://www.w3.org/1999/xhtml"> <p>Even brief contact with the Hive mind may produce mental burnout or enslavement, leading to opportunities as:</p> <ul> <li>a vegetable (crispy);</li> <li>a slave (creepy).</li> </ul> </div> </dcterms:description> <dcterms:description xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" xsi:type="xcriTerms:topic"> <div xmlns="http://www.w3.org/1999/xhtml"> <p>The Hive are the only sentient species of the Tenth Planet. They have amazing mindsharing abilities, which they use to form one colossal, connected mind.</p> <p>They can telepathically communicate with other species as well, and this course will introduce you to Hive Mind Speak. Delivered by our guest Hive lecturer, you will learn:</p> <ul> <li>telepathic communication protocols;</li> <li>the lesser and greater obsequies;</li> <li>Mind Speak knock-knock jokes.</li> </ul> </div> </dcterms:description> <dc:identifier>http://kelpiecollege.org.uk/courses(HLANG1)</dc:identifier> <dc:subject xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="http://kelpiecollege.org.uk/courses/subjects(S01)">interspecies linguistics</dc:subject> <dcterms:title>Hive Mind Speak level 1</dcterms:title> <mlo:url>http://www.kelpiecollege.org.uk/courses(HLANG1)</mlo:url> <abstract>Learn the telepathic Mind Speak of the Hive, and commune humbly with our near-neighbours from the Tenth Planet!</abstract> <presentation xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:identifier>20867645-E679-E111-99C1-02F3E9FFDFEB</dcterms:identifier> <mlo:start>2012-09-01T00:00:00+01:00</mlo:start> <end>2013-05-20T00:00:00+01:00</end> <studyMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="FT">Full time</studyMode> <attendanceMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="CM">Campus</attendanceMode> <attendancePattern xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="DT">Daytime</attendancePattern> <venue> <provider> <dc:identifier>0000X00XX0/1</dc:identifier> <dc:title>Pict Harbour College</dc:title> <mlo:location> <mlo:street>Port Street</mlo:street> <mlo:town>Picton</mlo:town> <mlo:postcode>PCT1</mlo:postcode> </mlo:location> </provider> </venue> </presentation> <presentation xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:identifier>21867645-E679-E111-99C1-02F3E9FFDFEB</dcterms:identifier> <mlo:start>2013-09-01T00:00:00+01:00</mlo:start> <end>2014-05-20T00:00:00+01:00</end> <studyMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="PF">Part of a full time programme</studyMode> <attendanceMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="CM">Campus</attendanceMode> <attendancePattern xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="CS">Customised</attendancePattern> <venue> <provider> <dc:identifier>0000X00XX0/1</dc:identifier> <dc:title>Pict Harbour College</dc:title> <mlo:location> <mlo:street>Port Street</mlo:street> <mlo:town>Picton</mlo:town> <mlo:postcode>PCT1</mlo:postcode> </mlo:location> </provider> </venue> </presentation> </course> <course xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:description xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" xsi:type="xcriTerms:careerOutcome"> <div xmlns="http://www.w3.org/1999/xhtml"> <p>On finishing this course the sky is the limit, as you can launch into careers such as:</p> <ul> <li>shuttlesmith;</li> <li>shield welder;</li> <li>solar panel beater.</li> </ul> </div> </dcterms:description> <dcterms:description xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" xsi:type="xcriTerms:topic"> <div xmlns="http://www.w3.org/1999/xhtml"> <p>Traditional metalworking methods come together with cutting edge space technology in this practical course.</p> <p>By the end of your studies, you should have launched a working space probe in wrought iron, cast bronze or sheet-hammered tin.</p> </div> </dcterms:description> <dc:identifier>http://kelpiecollege.org.uk/courses(HNCMS)</dc:identifier> <dc:subject xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="http://kelpiecollege.org.uk/courses/subjects(S02)">future industries</dc:subject> <dcterms:title>Metalwork and Spacecraft</dcterms:title> <mlo:url>http://www.kelpiecollege.org.uk/courses(HNCMS)</mlo:url> <abstract>Traditional metalworking methods come together with cutting edge space technology in this practical course.</abstract> <mlo:qualification xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dc:title>Highly Notional Certificate</dc:title> <awardedBy>Kelpie College</awardedBy> <accreditedBy>Swampland Qualifications Agency</accreditedBy> </mlo:qualification> <mlo:credit xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <credit:scheme>http://example.org/sqa/credit</credit:scheme> <credit:level>3</credit:level> <credit:value>60</credit:value> </mlo:credit> <presentation xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:identifier>00862458-F87B-E111-8C49-02F3E9FFDFEB</dcterms:identifier> <mlo:start>2012-08-20T00:00:00+01:00</mlo:start> <end>2013-05-25T00:00:00+01:00</end> <attendanceMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="CM">Campus</attendanceMode> <attendancePattern xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="DT">Daytime</attendancePattern> <venue> <provider> <dc:identifier>0000X00XX0/2</dc:identifier> <dc:title>Celt Harbour College</dc:title> <mlo:location> <mlo:street>Harbour Lane</mlo:street> <mlo:town>Celtville</mlo:town> <mlo:postcode>CLT2</mlo:postcode> </mlo:location> </provider> </venue> </presentation> </course> <course xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:description xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" xsi:type="xcriTerms:careerOutcome"> <div xmlns="http://www.w3.org/1999/xhtml"> <p>A career in the shipping lanes of our solar system awaits successful apprentices from this course, such as:</p> <ul> <li>assistant navigator;</li> <li>first contact hero/alien food animal.</li> </ul> </div> </dcterms:description> <dcterms:description xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" xsi:type="xcriTerms:topic"> <div xmlns="http://www.w3.org/1999/xhtml"> <p>This made-up apprenticeship teaches the basics of navigating between the various bodies of the solar system, using a variety of instruments you will build yourself. Plot your course to make best use of gravity, take parallax readings, and avoid that big shiny thing in the middle.</p> </div> </dcterms:description> <dc:identifier>http://kelpiecollege.org.uk/courses(ISN1)</dc:identifier> <dc:subject xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="http://kelpiecollege.org.uk/courses/subjects(S03)">notional navigation</dc:subject> <dcterms:title>Intra-System Navigation level 1</dcterms:title> <mlo:url>http://www.kelpiecollege.org.uk/courses(ISN1)</mlo:url> <abstract>Learn the art of navigating around the solar system at apprentice level. In a spaceship. Obviously.</abstract> <mlo:qualification xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dc:title>Mock Apprenticeship</dc:title> <awardedBy>Kelpie College</awardedBy> <accreditedBy>Swampland Qualifications Agency</accreditedBy> </mlo:qualification> <mlo:credit xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <credit:scheme>http://example.org/sqa/credit</credit:scheme> <credit:level>2</credit:level> <credit:value>40</credit:value> </mlo:credit> <presentation xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:identifier>B0173B78-F87B-E111-8C49-02F3E9FFDFEB</dcterms:identifier> <mlo:start>2012-08-20T00:00:00+01:00</mlo:start> <end>2014-05-25T00:00:00+01:00</end> <attendanceMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="CM">Campus</attendanceMode> <attendancePattern xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="DR">Day/Block release</attendancePattern> <venue> <provider> <dc:identifier>0000X00XX0/3</dc:identifier> <dc:title>The Schooner "Privateering and Slavedriving"</dc:title> <mlo:location> <mlo:town>Celtville</mlo:town> <mlo:postcode>CLT2</mlo:postcode> <mlo:address>Offshore anchorage, Celt Harbour</mlo:address> </mlo:location> </provider> </venue> </presentation> <presentation xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:identifier>C03D9D80-F87B-E111-8C49-02F3E9FFDFEB</dcterms:identifier> <mlo:start>2013-08-21T00:00:00+01:00</mlo:start> <end>2015-05-26T00:00:00+01:00</end> <attendanceMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="CM">Campus</attendanceMode> <attendancePattern xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="DT">Daytime</attendancePattern> <venue> <provider> <dc:identifier>0000X00XX0/3</dc:identifier> <dc:title>The Schooner "Privateering and Slavedriving"</dc:title> <mlo:location> <mlo:town>Celtville</mlo:town> <mlo:postcode>CLT2</mlo:postcode> <mlo:address>Offshore anchorage, Celt Harbour</mlo:address> </mlo:location> </provider> </venue> </presentation> </course> <course xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:description xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" xsi:type="xcriTerms:careerOutcome"> <div xmlns="http://www.w3.org/1999/xhtml"> <p>Underwater basketweaver, what else?</p> </div> </dcterms:description> <dcterms:description xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" xsi:type="xcriTerms:topic"> <div xmlns="http://www.w3.org/1999/xhtml"> <p>Learn this traditional craft, using quality local materials, in the comfort of a swimming pool.</p> <p>Full snorkelling kit and reed thimbles are provided.</p> </div> </dcterms:description> <dc:identifier>http://kelpiecollege.org.uk/courses(UWBKW)</dc:identifier> <dc:subject xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="http://kelpiecollege.org.uk/courses/subjects(S04)">unreal crafts</dc:subject> <dcterms:title>Underwater Basketweaving</dcterms:title> <mlo:url>http://www.kelpiecollege.org.uk/courses(UWBKW)</mlo:url> <abstract>Learn the traditional craft of underwater basketweaving, using quality local materials, in the comfort of a swimming pool.</abstract> <presentation xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:identifier>C09780AC-F87B-E111-8C49-02F3E9FFDFEB</dcterms:identifier> <mlo:start>2012-09-01T00:00:00+01:00</mlo:start> <end>2012-12-15T00:00:00Z</end> <attendanceMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="CM">Campus</attendanceMode> <attendancePattern xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="DR">Day/Block release</attendancePattern> <venue> <provider> <dc:identifier>0000X00XX0/4</dc:identifier> <dc:title>The Barque "Acquired Tacking"</dc:title> <mlo:location> <mlo:town>Picton</mlo:town> <mlo:postcode>PCT1</mlo:postcode> <mlo:address>Berth 4, Pict Harbour</mlo:address> </mlo:location> </provider> </venue> </presentation> <presentation xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:identifier>90E902B8-F87B-E111-8C49-02F3E9FFDFEB</dcterms:identifier> <mlo:start>2012-09-01T00:00:00+01:00</mlo:start> <end>2012-12-15T00:00:00Z</end> <attendanceMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="CM">Campus</attendanceMode> <attendancePattern xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="CS">Customised</attendancePattern> <venue> <provider> <dc:identifier>0000X00XX0/1</dc:identifier> <dc:title>Pict Harbour College</dc:title> <mlo:location> <mlo:street>Port Street</mlo:street> <mlo:town>Picton</mlo:town> <mlo:postcode>PCT1</mlo:postcode> </mlo:location> </provider> </venue> </presentation> <presentation xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms"> <dcterms:identifier>2061C3D6-F87B-E111-8C49-02F3E9FFDFEB</dcterms:identifier> <mlo:start>2013-01-12T00:00:00Z</mlo:start> <end>2013-03-26T00:00:00+01:00</end> <attendanceMode xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="CM">Campus</attendanceMode> <attendancePattern xmlns="http://xcri.org/profiles/1.2/catalog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:mlo="http://purl.org/net/mlo" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:credit="http://purl.org/net/cm" xmlns:xcriTerms="http://xcri.org/profiles/1.2/catalog/terms" identifier="DT">Daytime</attendancePattern> <venue> <provider> <dc:identifier>0000X00XX0/2</dc:identifier> <dc:title>Celt Harbour College</dc:title> <mlo:location> <mlo:street>Harbour Lane</mlo:street> <mlo:town>Celtville</mlo:town> <mlo:postcode>CLT2</mlo:postcode> </mlo:location> </provider> </venue> </presentation> </course> </provider> </catalog>

There are still some issues with the design and code, but it is not far off a complete working solution. The procedure should run quickly, but has not been tested on a large sample database.

If you spot any errors or have any comments, please supply feedback using the Contact method on this website.

A working demonstration of the web pages built from this code scan be found on the fictional Kelpie College website courses section.

For more information on the standard, see the XCRI Knowledge Base.

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 Unported License.

Back to Code and Examples for XCRI CAP 1.2.

Last updated: .