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.
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:
.