{"id":2282,"date":"2012-12-03T15:43:25","date_gmt":"2012-12-03T15:43:25","guid":{"rendered":"http:\/\/blogs.oucs.ox.ac.uk\/adamweblearn\/?p=2282"},"modified":"2012-12-03T15:43:25","modified_gmt":"2012-12-03T15:43:25","slug":"oxcap-oxfords-use-of-share-point","status":"publish","type":"post","link":"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/2012\/12\/oxcap-oxfords-use-of-share-point\/","title":{"rendered":"OXCAP &#8211; Oxford&#8217;s use of Share Point"},"content":{"rendered":"<p><em>Thanks to Alex Dutton for the helping with this post.<\/em><\/p>\n<p>The OXCAP project is about collecting and distributing information about graduate training opportunities at The University of Oxford. This information is stored in the University&#8217;s Open Data Service (ODS) and is then used to drive a &#8216;course booking portal&#8217; and to publicise the excellent training that is on offer at Oxford. (There is an earlier blog post describing <a href=\"http:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/2012\/12\/data-flow-in-the-oxcap-project\/\">how graduate training data moves around the university<\/a> to make this possible.)\u00a0 Share Point plays a key role in this project.<\/p>\n<p>Share Point is used in two distinct ways:<\/p>\n<ul>\n<li>as a data entry system: we have an Info Path document which is used to capture all the relevant details about a course.<\/li>\n<li>as a document repository:\u00a0 there is a shared document library that houses XLSX (Excel) files describing courses offered by different training providers.<\/li>\n<\/ul>\n<h2>The Data Entry System<\/h2>\n<p>We have an Info Path document library for courses which cannot be &#8216;automatically&#8217; exported in an electronic format. The form is split into two: provider details and presentation details.<\/p>\n<p>We ask for basic details of the unit providing the training, this includes a University-wide &#8216;unit identifier&#8217; which is used as a unique key to identify the host department.<\/p>\n<p><a href=\"http:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-provider.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2285\" src=\"http:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-provider.jpg\" alt=\"\" width=\"1015\" height=\"941\" srcset=\"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-provider.jpg 1015w, https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-provider-300x278.jpg 300w\" sizes=\"auto, (max-width: 1015px) 100vw, 1015px\" \/><\/a><\/p>\n<p>The second part of the form collects information about a single instance of the course &#8211; this may be a single presentation or a series of individual sessions.<\/p>\n<p>We start with asking for basic information such as Title,\u00a0 Description (HTML) and a URL.<\/p>\n<p><a href=\"http:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2287\" src=\"http:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-1.jpg\" alt=\"\" width=\"976\" height=\"739\" srcset=\"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-1.jpg 976w, https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-1-300x227.jpg 300w\" sizes=\"auto, (max-width: 976px) 100vw, 976px\" \/><\/a><\/p>\n<p>We then ask who can see and book on the course and collect booking URLs,\u00a0 dates and a venue.<\/p>\n<p><a href=\"http:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2288\" src=\"http:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-2.jpg\" alt=\"\" width=\"963\" height=\"708\" srcset=\"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-2.jpg 963w, https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-2-300x220.jpg 300w\" sizes=\"auto, (max-width: 963px) 100vw, 963px\" \/><\/a><\/p>\n<p>We then ask for some sort of categorisation. JACS codes are not really applicable for graduate training so we have developed our own set of skills which are based on <a id=\"FormControl_V1_I1_H26\" title=\"\" href=\"http:\/\/www.vitae.ac.uk\/researchers\/428241\/Vitae-Researcher-Development-Framework.html\" target=\"_blank\">Vitae&#8217;s Researcher Development Framework.<\/a> We have cut down on the number of categories to make the tagging process more manageable.<\/p>\n<p><a href=\"http:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-3.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2289\" src=\"http:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-3.jpg\" alt=\"\" width=\"964\" height=\"752\" srcset=\"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-3.jpg 964w, https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-3-300x234.jpg 300w\" sizes=\"auto, (max-width: 964px) 100vw, 964px\" \/><\/a><\/p>\n<p>Finally we ask for booking details and information about the timings of individual session.<\/p>\n<p><a href=\"http:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2290\" src=\"http:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-4.jpg\" alt=\"\" width=\"961\" height=\"644\" srcset=\"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-4.jpg 961w, https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/files\/2012\/11\/data-entry-form-presentation-part-4-300x201.jpg 300w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a>We encourage training providers to base a new presentation on existing information, that is, open an existing form, just change the bits that are different and use the &#8216;Save As&#8217; functionality.<\/p>\n<p>Once data has been entered we are able to use the Share Point lists web service to enumerate the XML files that represent the courses, and use XSLT to turn these in XCRI-CAP which is then stored as RDF within ODS.<\/p>\n<h2>The Document Repository<\/h2>\n<p>Data about other courses are provided to us as Excel (XLSX) spreadsheets, which can be emailed (as attachments) to a Shared Document Library within Share Point. The format of the XLSX files is outlined in a document that gives <a href=\"https:\/\/weblearn.ox.ac.uk\/access\/content\/group\/b1f728b0-0902-4666-869f-7993ca7d03d5\/Mandatory%20Field%20Documents\/OxCAP%20guidelines%20for%20training%20providers.docx\" target=\"_blank\">comprehensive guidance for training providers<\/a>.<\/p>\n<p>The XLSX files (one per training provider) are retrieved from Share Point, transformed into the Resource Description Framework\u00a0 by an XSLT file and then stored within ODS. (See: <a href=\"https:\/\/github.com\/ox-it\/tei-spreadsheet\">https:\/\/github.com\/ox-it\/tei-spreadsheet<\/a>). (For other projects we&#8217;re investigating using Share Point lists directly, and have written a Python library and command-line tool for extracting data from Share Point, see: <a href=\"https:\/\/github.com\/ox-it\/python-sharepoint\">https:\/\/github.com\/ox-it\/python-sharepoint<\/a>).<\/p>\n<p>Once the data is stored within ODS, it can be transformed into XCRI-CAP using the same XSLT as for all other course data.<\/p>\n<p>We feel that Share Point \u2014 as part of our existing infrastructure \u2014 provides a good way to maintain our data where it&#8217;s not in already-existing systems.<\/p>\n<h2>Links<\/h2>\n<ul>\n<li><a href=\"https:\/\/weblearn.ox.ac.uk\/access\/content\/group\/b1f728b0-0902-4666-869f-7993ca7d03d5\/public\/oxcap.html\">About OxCAP<\/a><\/li>\n<li>Oxford&#8217;s <a href=\"https:\/\/data.ox.ac.uk\/\">Open Data Service<\/a><\/li>\n<li><a href=\"https:\/\/course.data.ox.ac.uk\/\">Courses on ODS<\/a><\/li>\n<li><a href=\"https:\/\/course.data.ox.ac.uk\/catalogues\/?uri=https%3A\/\/course.data.ox.ac.uk\/id\/catalogue&amp;format=xcricap\">XCRI-CAP v1.2 feed<\/a><\/li>\n<li><a href=\"http:\/\/www.oucs.ox.ac.uk\/oxpoints\/\">OxPoints<\/a><\/li>\n<li><a href=\"http:\/\/en.wikipedia.org\/wiki\/Resource_Description_Framework\">Resource Description Framework<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Thanks to Alex Dutton for the helping with this post. The OXCAP project is about collecting and distributing information about graduate training opportunities at The University of Oxford. This information is stored in the University&#8217;s Open Data Service (ODS) and &hellip; <a href=\"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/2012\/12\/oxcap-oxfords-use-of-share-point\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13785,90,105],"tags":[38390,40502],"class_list":["post-2282","post","type-post","status-publish","format-standard","hentry","category-oxcap","category-sakai","category-weblearn","tag-student-enrolment-system-ses","tag-weblearn"],"_links":{"self":[{"href":"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/wp-json\/wp\/v2\/posts\/2282","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/wp-json\/wp\/v2\/comments?post=2282"}],"version-history":[{"count":16,"href":"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/wp-json\/wp\/v2\/posts\/2282\/revisions"}],"predecessor-version":[{"id":2453,"href":"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/wp-json\/wp\/v2\/posts\/2282\/revisions\/2453"}],"wp:attachment":[{"href":"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/wp-json\/wp\/v2\/media?parent=2282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/wp-json\/wp\/v2\/categories?post=2282"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs-new.it.ox.ac.uk\/adamweblearn\/wp-json\/wp\/v2\/tags?post=2282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}