{"id":8312,"date":"2014-10-19T12:46:46","date_gmt":"2014-10-19T11:46:46","guid":{"rendered":"https:\/\/myworldofit.net\/?p=8312"},"modified":"2014-10-19T16:35:52","modified_gmt":"2014-10-19T15:35:52","slug":"moodle-and-capita-sims-database-enrolment-a-short-how-to","status":"publish","type":"post","link":"https:\/\/myworldofit.net\/?p=8312","title":{"rendered":"Moodle and Capita SIMS &#8211; Database enrolment (a short how to)"},"content":{"rendered":"<p><a href=\"https:\/\/myworldofit.net\/wp-content\/uploads\/2014\/10\/Portal.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-8426\" src=\"https:\/\/myworldofit.net\/wp-content\/uploads\/2014\/10\/Portal.jpg\" alt=\"Just like this :)\" width=\"430\" height=\"356\" srcset=\"https:\/\/myworldofit.net\/wp-content\/uploads\/2014\/10\/Portal.jpg 900w, https:\/\/myworldofit.net\/wp-content\/uploads\/2014\/10\/Portal-300x248.jpg 300w\" sizes=\"auto, (max-width: 430px) 100vw, 430px\" \/><\/a>One of the holy grails of Moodle is having it such that students are added to the right courses in an automated way. This becomes particularly true if you have individual courses for each and every class each of which could have up to 30 enrolments to go through (just far to many to do using manual methods).<\/p>\n<p>Moodle has a number of ways to automate the process out of the box and my favourite way at the moment is using an external database&#8230;<\/p>\n<p>So in this post I will show how to use SIMS reports (generated using CommandReporter.exe) to populate student and teacher enrolments in courses as part of\u00a0a Moodle install using the External\u00a0database enrolment plugin (more on this here &#8211; <a href=\"https:\/\/docs.moodle.org\/27\/en\/External_database_enrolment\">https:\/\/docs.moodle.org\/27\/en\/External_database_enrolment<\/a>).<\/p>\n<h4>Pre requisites&#8230;<\/h4>\n<ul>\n<li>First up you will need to <strong>know your way around Capita SIMS<\/strong> (in particular creating custom reports) as well as\u00a0the <strong>basics of SQL server management<\/strong> (in particular adding a database to an instance) and\u00a0<strong>Microsoft SQL Server Integration Services<\/strong> (there is a great video series on SSIS here &#8211; <a href=\"https:\/\/www.youtube.com\/playlist?list=PLNIs-AWhQzcmPg_uV2BZi_KRG4LKs6cRs\">https:\/\/www.youtube.com\/playlist?list=PLNIs-AWhQzcmPg_uV2BZi_KRG4LKs6cRs<\/a>).<\/li>\n<li>Next you will need a <strong>SQL server running Standard edition or higher<\/strong> (this gives you access to SSIS as per <a href=\"http:\/\/msdn.microsoft.com\/en-gb\/library\/cc645993.aspx\">http:\/\/msdn.microsoft.com\/en-gb\/library\/cc645993.aspx<\/a>), <strong>if you only have Express edition installs<\/strong> in your environment then there <strong>isn&#8217;t much point in following this guide until you do<\/strong>.<\/li>\n<li>This guide also assumes that you are using <strong>LDAP authentication<\/strong> in your Moodle site and that you <strong>have your course lists already populated with the course shortname the same as the course name as it appears in SIMS<\/strong> (it is possible to generate courses using the Database Enrolment method but that&#8217;s something for another guide).<\/li>\n<li>Finally you must have the <strong>SIMS.net client<\/strong> (which includes CommandReporter.exe) <strong>installed on the SQL server from which you will be running the job to get the class lists into Moodle<\/strong> (more on this a little later).<\/li>\n<\/ul>\n<h4>Capita SIMS setup<\/h4>\n<p>For best results create a <strong>new SIMS user<\/strong> that will be used exclusively for your <strong>Moodle Reports<\/strong>, then login with that user and follow the instructions below.<\/p>\n<p><!-- default-view.php -->\n<div\n\tclass=\"ngg-galleryoverview default-view\n\t ngg-ajax-pagination-none\t\"\n\tid=\"ngg-gallery-6912a3b3569c39b310cb92b96feec233-1\"\n\tdata-nextgen-gallery-id=\"92\"\n\tdata-gallery-id=\"92\"\n\t\tdata-gallery-name=\"MoodleClassSIMSExport\"\n\t>\n\n\t\t<!-- Thumbnails -->\n\t\t\t\t<div id=\"ngg-image-0\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/1.PNG?t=1413732964\"\n\t\t\ttitle=\"First up create a new report in SIMS with the focus on Class, add the class name as well as the Person_id of the students to the report.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/1.PNG?t=1413732964\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_1.PNG?t=1413732964\"\n\t\t\tdata-image-id=\"771\"\n\t\t\tdata-image-name=\"1.PNG\"\n\t\t\tdata-title=\"1\"\n\t\t\tdata-description=\"First up create a new report in SIMS with the focus on Class, add the class name as well as the Person_id of the students to the report.\"\n\t\t\tdata-image-slug=\"1-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"6912a3b3569c39b310cb92b96feec233\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"1\"\n\t\t\t\t\talt=\"1\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_1.PNG?t=1413732964\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-1\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/2.PNG?t=1413720076\"\n\t\t\ttitle=\"Add a filter to the report to show only the current academic year (in this case 2014 for 2014-15).\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/2.PNG?t=1413720076\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_2.PNG?t=1413720076\"\n\t\t\tdata-image-id=\"772\"\n\t\t\tdata-image-name=\"2.PNG\"\n\t\t\tdata-title=\"2\"\n\t\t\tdata-description=\"Add a filter to the report to show only the current academic year (in this case 2014 for 2014-15).\"\n\t\t\tdata-image-slug=\"2-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"6912a3b3569c39b310cb92b96feec233\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"2\"\n\t\t\t\t\talt=\"2\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_2.PNG?t=1413720076\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-2\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/3.PNG?t=1413720076\"\n\t\t\ttitle=\"No need to define any sorting.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/3.PNG?t=1413720076\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_3.PNG?t=1413720076\"\n\t\t\tdata-image-id=\"773\"\n\t\t\tdata-image-name=\"3.PNG\"\n\t\t\tdata-title=\"3\"\n\t\t\tdata-description=\"No need to define any sorting.\"\n\t\t\tdata-image-slug=\"3-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"6912a3b3569c39b310cb92b96feec233\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"3\"\n\t\t\t\t\talt=\"3\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_3.PNG?t=1413720076\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-3\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/4.PNG?t=1413720076\"\n\t\t\ttitle=\"Use the current date as the effective date for the report.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/4.PNG?t=1413720076\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_4.PNG?t=1413720076\"\n\t\t\tdata-image-id=\"774\"\n\t\t\tdata-image-name=\"4.PNG\"\n\t\t\tdata-title=\"4\"\n\t\t\tdata-description=\"Use the current date as the effective date for the report.\"\n\t\t\tdata-image-slug=\"4-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"6912a3b3569c39b310cb92b96feec233\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"4\"\n\t\t\t\t\talt=\"4\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_4.PNG?t=1413720076\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-4\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/5.PNG?t=1413720076\"\n\t\t\ttitle=\"Set the presentation mode to text with the format as Comma separated.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/5.PNG?t=1413720076\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_5.PNG?t=1413720076\"\n\t\t\tdata-image-id=\"775\"\n\t\t\tdata-image-name=\"5.PNG\"\n\t\t\tdata-title=\"5\"\n\t\t\tdata-description=\"Set the presentation mode to text with the format as Comma separated.\"\n\t\t\tdata-image-slug=\"5-8\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"6912a3b3569c39b310cb92b96feec233\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"5\"\n\t\t\t\t\talt=\"5\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_5.PNG?t=1413720076\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-5\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/6.PNG?t=1413720076\"\n\t\t\ttitle=\"Save the report giving it a descriptive name (this name will be needed later when running the report through SSIS).\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/6.PNG?t=1413720076\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_6.PNG?t=1413720076\"\n\t\t\tdata-image-id=\"765\"\n\t\t\tdata-image-name=\"6.PNG\"\n\t\t\tdata-title=\"6\"\n\t\t\tdata-description=\"Save the report giving it a descriptive name (this name will be needed later when running the report through SSIS).\"\n\t\t\tdata-image-slug=\"6-6\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"6912a3b3569c39b310cb92b96feec233\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"6\"\n\t\t\t\t\talt=\"6\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_6.PNG?t=1413720076\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-6\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/7.PNG?t=1413720076\"\n\t\t\ttitle=\"Its pretty much the same for the teachers, set the focus of a new report on the class and add the ID of the teacher (this is the same as the Person_id) along with the name of the class.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/7.PNG?t=1413720076\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_7.PNG?t=1413720076\"\n\t\t\tdata-image-id=\"766\"\n\t\t\tdata-image-name=\"7.PNG\"\n\t\t\tdata-title=\"7\"\n\t\t\tdata-description=\"Its pretty much the same for the teachers, set the focus of a new report on the class and add the ID of the teacher (this is the same as the Person_id) along with the name of the class.\"\n\t\t\tdata-image-slug=\"7-5\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"6912a3b3569c39b310cb92b96feec233\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"7\"\n\t\t\t\t\talt=\"7\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_7.PNG?t=1413720076\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-7\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/8.PNG?t=1413720076\"\n\t\t\ttitle=\"Define a filter to show only the current academic year and in addition here I have chosen to filter all of the classes which don&#039;t have any students.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/8.PNG?t=1413720076\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_8.PNG?t=1413720076\"\n\t\t\tdata-image-id=\"767\"\n\t\t\tdata-image-name=\"8.PNG\"\n\t\t\tdata-title=\"8\"\n\t\t\tdata-description=\"Define a filter to show only the current academic year and in addition here I have chosen to filter all of the classes which don&#039;t have any students.\"\n\t\t\tdata-image-slug=\"8-5\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"6912a3b3569c39b310cb92b96feec233\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"8\"\n\t\t\t\t\talt=\"8\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_8.PNG?t=1413720076\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-8\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/9.PNG?t=1413720076\"\n\t\t\ttitle=\"Again no need to sort the results.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/9.PNG?t=1413720076\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_9.PNG?t=1413720076\"\n\t\t\tdata-image-id=\"768\"\n\t\t\tdata-image-name=\"9.PNG\"\n\t\t\tdata-title=\"9\"\n\t\t\tdata-description=\"Again no need to sort the results.\"\n\t\t\tdata-image-slug=\"9-2\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"6912a3b3569c39b310cb92b96feec233\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"9\"\n\t\t\t\t\talt=\"9\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_9.PNG?t=1413720076\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-9\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/10.PNG?t=1413720077\"\n\t\t\ttitle=\"Use the current date as the effective date (if you want to pre-stage the next years classes in Moodle you can change this during the summer holiday for example and setup all of the teachers in their new classes).\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/10.PNG?t=1413720077\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_10.PNG?t=1413720077\"\n\t\t\tdata-image-id=\"769\"\n\t\t\tdata-image-name=\"10.PNG\"\n\t\t\tdata-title=\"10\"\n\t\t\tdata-description=\"Use the current date as the effective date (if you want to pre-stage the next years classes in Moodle you can change this during the summer holiday for example and setup all of the teachers in their new classes).\"\n\t\t\tdata-image-slug=\"10-2\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"6912a3b3569c39b310cb92b96feec233\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"10\"\n\t\t\t\t\talt=\"10\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_10.PNG?t=1413720077\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-10\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/11.PNG?t=1413720077\"\n\t\t\ttitle=\"Again set the presentation type to text and choose comma separated values for the format, be sure to save the report again with a descriptive name.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/11.PNG?t=1413720077\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_11.PNG?t=1413720077\"\n\t\t\tdata-image-id=\"770\"\n\t\t\tdata-image-name=\"11.PNG\"\n\t\t\tdata-title=\"11\"\n\t\t\tdata-description=\"Again set the presentation type to text and choose comma separated values for the format, be sure to save the report again with a descriptive name.\"\n\t\t\tdata-image-slug=\"11-2\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"6912a3b3569c39b310cb92b96feec233\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"11\"\n\t\t\t\t\talt=\"11\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssimsexport\/thumbs\/thumbs_11.PNG?t=1413720077\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\n\t<br style=\"clear: both\" \/>\n\n\t\n\t\t<div class=\"ngg-clear\"><\/div>\n\t<\/div>\n<\/p>\n<p><!--more--><\/p>\n<h4>SQL server setup<\/h4>\n<p>To make everything work you will need a <strong>SQL database spun up on a SQL server<\/strong> (in this example its called PortalClasses as we call the Moodle install where I work Portal). Don&#8217;t worry about creating tables in that database as SSIS will do that for us.<\/p>\n<p><!-- default-view.php -->\n<div\n\tclass=\"ngg-galleryoverview default-view\n\t ngg-ajax-pagination-none\t\"\n\tid=\"ngg-gallery-5455ee2c3eefd2591e77d03f4ffd2803-1\"\n\tdata-nextgen-gallery-id=\"93\"\n\tdata-gallery-id=\"93\"\n\t\tdata-gallery-name=\" MoodleClassSQLserver\"\n\t>\n\n\t\t<!-- Thumbnails -->\n\t\t\t\t<div id=\"ngg-image-0\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssqlserver\/1.PNG?t=1413732965\"\n\t\t\ttitle=\"Spin up a new SQL server database and give it a descriptive name (in this demo I have called it PortalClasses as our Moodle install goes by the trade name of Portal).\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssqlserver\/1.PNG?t=1413732965\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssqlserver\/thumbs\/thumbs_1.PNG?t=1413732965\"\n\t\t\tdata-image-id=\"776\"\n\t\t\tdata-image-name=\"1.PNG\"\n\t\t\tdata-title=\"1\"\n\t\t\tdata-description=\"Spin up a new SQL server database and give it a descriptive name (in this demo I have called it PortalClasses as our Moodle install goes by the trade name of Portal).\"\n\t\t\tdata-image-slug=\"1-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"5455ee2c3eefd2591e77d03f4ffd2803\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"1\"\n\t\t\t\t\talt=\"1\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclasssqlserver\/thumbs\/thumbs_1.PNG?t=1413732965\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\n\t<br style=\"clear: both\" \/>\n\n\t\n\t\t<div class=\"ngg-clear\"><\/div>\n\t<\/div>\n<\/p>\n<h4>SSIS setup<\/h4>\n<p>Now things get interesting, spin up a new SSIS project with a suitable name and jump through the instructions below. As part of tying things in with the SIMS\u00a0CommandReporter.exe tool you will need the paths\/arguments below, the first is the path to the .exe you will need, the second shows the fields to populate and the their is a demo of how the arguments might appear.<\/p>\n<blockquote><p>C:\\Program Files (x86)\\SIMS\\SIMS .net\\CommandReporter.exe \/USER:&lt;yourusername&gt; \/PASSWORD:&lt;yourpassword&gt; \/SERVERNAME:&lt;servername\\sqlinstance&gt;\u00a0\/DATABASENAME:&lt;databasename&gt; \/REPORT:&#8221;&lt;reportname&gt;&#8221; \/OUTPUT:&#8221;&lt;pathtooutput.csv&gt;&#8221; \/USER:moodlereports \/PASSWORD:N0Tt3llingu \/SERVERNAME:SIMSDB10\\SIMS2008 \/DATABASENAME:OxfordSpiresOX \/REPORT:&#8221;MoodleTeacherExport&#8221; \/OUTPUT:&#8221;C:\\SIMSReports\\SIMStoPortal\\teachers.csv&#8221;<\/p><\/blockquote>\n<p><!-- default-view.php -->\n<div\n\tclass=\"ngg-galleryoverview default-view\n\t ngg-ajax-pagination-none\t\"\n\tid=\"ngg-gallery-be23036f1dd67531ac17e5c87341874a-1\"\n\tdata-nextgen-gallery-id=\"94\"\n\tdata-gallery-id=\"94\"\n\t\tdata-gallery-name=\"MoodleClassSSIS\"\n\t>\n\n\t\t<!-- Thumbnails -->\n\t\t\t\t<div id=\"ngg-image-0\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/1.PNG?t=1413732966\"\n\t\t\ttitle=\"For our SSIS package we will have 4 steps, first 2 steps to generate the reports for the data, then to delete the existing data in the database that Moodle will read and finally to modify the data in the reports to a Moodle compatible format and import that into our SQL server.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/1.PNG?t=1413732966\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_1.PNG?t=1413732966\"\n\t\t\tdata-image-id=\"784\"\n\t\t\tdata-image-name=\"1.PNG\"\n\t\t\tdata-title=\"1\"\n\t\t\tdata-description=\"For our SSIS package we will have 4 steps, first 2 steps to generate the reports for the data, then to delete the existing data in the database that Moodle will read and finally to modify the data in the reports to a Moodle compatible format and import that into our SQL server.\"\n\t\t\tdata-image-slug=\"1-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"1\"\n\t\t\t\t\talt=\"1\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_1.PNG?t=1413732966\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-1\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/2.PNG?t=1413731014\"\n\t\t\ttitle=\"Create a new connection manager and link it to the SQL server, instance and database that you will be using for Moodle to read from.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/2.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_2.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"786\"\n\t\t\tdata-image-name=\"2.PNG\"\n\t\t\tdata-title=\"2\"\n\t\t\tdata-description=\"Create a new connection manager and link it to the SQL server, instance and database that you will be using for Moodle to read from.\"\n\t\t\tdata-image-slug=\"2-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"2\"\n\t\t\t\t\talt=\"2\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_2.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-2\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/3.PNG?t=1413731014\"\n\t\t\ttitle=\"Add a pair of &#039;Execute Process&#039; tasks, set the executable to the path of CommandReporter.exe and the arguments to the required settings for your environment (see the examples in the main article) running a report for both the Teachers and Students. Note that the password to login to SIMS is stored in plain text.\r\nTo help with the next few steps its worth running the SSIS package with just these two steps which will in turn generate the CSVs with the students and staff in.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/3.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_3.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"785\"\n\t\t\tdata-image-name=\"3.PNG\"\n\t\t\tdata-title=\"3\"\n\t\t\tdata-description=\"Add a pair of &#039;Execute Process&#039; tasks, set the executable to the path of CommandReporter.exe and the arguments to the required settings for your environment (see the examples in the main article) running a report for both the Teachers and Students. Note that the password to login to SIMS is stored in plain text.\r\nTo help with the next few steps its worth running the SSIS package with just these two steps which will in turn generate the CSVs with the students and staff in.\"\n\t\t\tdata-image-slug=\"3-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"3\"\n\t\t\t\t\talt=\"3\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_3.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-3\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/4.PNG?t=1413731014\"\n\t\t\ttitle=\"Next add a &#039;Execute a SQL&#039; task, set the Connection to the connection manager that you setup earlier (which talks to your database which hosts the class lists) and enter the SQL statement &#039;Delete from [&lt;databasename&gt;].[dbo].[&lt;nameoftheclasslisttable&gt;]&#039; note that the first time you debug this section it will fail as the table doesn&#039;t exist yet.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/4.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_4.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"787\"\n\t\t\tdata-image-name=\"4.PNG\"\n\t\t\tdata-title=\"4\"\n\t\t\tdata-description=\"Next add a &#039;Execute a SQL&#039; task, set the Connection to the connection manager that you setup earlier (which talks to your database which hosts the class lists) and enter the SQL statement &#039;Delete from [&lt;databasename&gt;].[dbo].[&lt;nameoftheclasslisttable&gt;]&#039; note that the first time you debug this section it will fail as the table doesn&#039;t exist yet.\"\n\t\t\tdata-image-slug=\"4-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"4\"\n\t\t\t\t\talt=\"4\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_4.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-4\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/5.PNG?t=1413731014\"\n\t\t\ttitle=\"The next step for this SSIS package is a Data Flow task which reads the two CSVs that CommandReporter.exe generates, adds a new column so that Moodle knows who is a teacher and who is a student and then joins this data together separating out any null values before importing them into the table.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/5.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_5.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"788\"\n\t\t\tdata-image-name=\"5.PNG\"\n\t\t\tdata-title=\"5\"\n\t\t\tdata-description=\"The next step for this SSIS package is a Data Flow task which reads the two CSVs that CommandReporter.exe generates, adds a new column so that Moodle knows who is a teacher and who is a student and then joins this data together separating out any null values before importing them into the table.\"\n\t\t\tdata-image-slug=\"5-9\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"5\"\n\t\t\t\t\talt=\"5\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_5.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-5\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/6.PNG?t=1413731014\"\n\t\t\ttitle=\"By way of example here is the Flat File Connection manager setup to read the teachers CSV, note that the format is set to Delimited, the text quantifier is &quot; and that the box for column names in the first row is ticked (do the same with the students import as well).\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/6.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_6.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"789\"\n\t\t\tdata-image-name=\"6.PNG\"\n\t\t\tdata-title=\"6\"\n\t\t\tdata-description=\"By way of example here is the Flat File Connection manager setup to read the teachers CSV, note that the format is set to Delimited, the text quantifier is &quot; and that the box for column names in the first row is ticked (do the same with the students import as well).\"\n\t\t\tdata-image-slug=\"6-7\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"6\"\n\t\t\t\t\talt=\"6\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_6.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-6\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/7.PNG?t=1413731014\"\n\t\t\ttitle=\"Be sure to visit the columns page to check that the data is showing up as expected.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/7.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_7.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"790\"\n\t\t\tdata-image-name=\"7.PNG\"\n\t\t\tdata-title=\"7\"\n\t\t\tdata-description=\"Be sure to visit the columns page to check that the data is showing up as expected.\"\n\t\t\tdata-image-slug=\"7-6\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"7\"\n\t\t\t\t\talt=\"7\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_7.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-7\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/8.PNG?t=1413731014\"\n\t\t\ttitle=\"Attached to the data flow for the Teachers add a derived column with a name of role and an expression of &quot;editingteacher&quot;.\r\nThe screen shot also shows a field called uniqueid - this isn&#039;t required and was just something I was playing around with when first setting this up.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/8.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_8.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"791\"\n\t\t\tdata-image-name=\"8.PNG\"\n\t\t\tdata-title=\"8\"\n\t\t\tdata-description=\"Attached to the data flow for the Teachers add a derived column with a name of role and an expression of &quot;editingteacher&quot;.\r\nThe screen shot also shows a field called uniqueid - this isn&#039;t required and was just something I was playing around with when first setting this up.\"\n\t\t\tdata-image-slug=\"8-6\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"8\"\n\t\t\t\t\talt=\"8\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_8.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-8\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/9.PNG?t=1413731014\"\n\t\t\ttitle=\"Its pretty much the same for the students data flow but instead you are adding the role with the value of student.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/9.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_9.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"792\"\n\t\t\tdata-image-name=\"9.PNG\"\n\t\t\tdata-title=\"9\"\n\t\t\tdata-description=\"Its pretty much the same for the students data flow but instead you are adding the role with the value of student.\"\n\t\t\tdata-image-slug=\"9-3\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"9\"\n\t\t\t\t\talt=\"9\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_9.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-9\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/10.PNG?t=1413731014\"\n\t\t\ttitle=\"Now add in a Union all transformation to combine the values from both sets of data into a single set.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/10.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_10.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"777\"\n\t\t\tdata-image-name=\"10.PNG\"\n\t\t\tdata-title=\"10\"\n\t\t\tdata-description=\"Now add in a Union all transformation to combine the values from both sets of data into a single set.\"\n\t\t\tdata-image-slug=\"10-3\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"10\"\n\t\t\t\t\talt=\"10\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_10.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-10\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/11.PNG?t=1413731014\"\n\t\t\ttitle=\"Again not required but in my data set I have a data conversion which sets the uniqueid value to a string (DT_STR from DT_WSTR).\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/11.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_11.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"778\"\n\t\t\tdata-image-name=\"11.PNG\"\n\t\t\tdata-title=\"11\"\n\t\t\tdata-description=\"Again not required but in my data set I have a data conversion which sets the uniqueid value to a string (DT_STR from DT_WSTR).\"\n\t\t\tdata-image-slug=\"11-3\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"11\"\n\t\t\t\t\talt=\"11\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_11.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-11\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/12.PNG?t=1413731014\"\n\t\t\ttitle=\"After the Union all add in a conditional split to remove any blank values from the class idnumber to ensure you aren&#039;t importing invalid data into your database.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/12.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_12.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"779\"\n\t\t\tdata-image-name=\"12.PNG\"\n\t\t\tdata-title=\"12\"\n\t\t\tdata-description=\"After the Union all add in a conditional split to remove any blank values from the class idnumber to ensure you aren&#039;t importing invalid data into your database.\"\n\t\t\tdata-image-slug=\"12-2\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"12\"\n\t\t\t\t\talt=\"12\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_12.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-12\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/13.PNG?t=1413731014\"\n\t\t\ttitle=\"Once thats done hook up the valid data results into your database destination, you can use the &#039;New&#039; button here to automatically add in the table with all of the settings required.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/13.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_13.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"780\"\n\t\t\tdata-image-name=\"13.PNG\"\n\t\t\tdata-title=\"13\"\n\t\t\tdata-description=\"Once thats done hook up the valid data results into your database destination, you can use the &#039;New&#039; button here to automatically add in the table with all of the settings required.\"\n\t\t\tdata-image-slug=\"13-1\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"13\"\n\t\t\t\t\talt=\"13\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_13.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-13\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/14.PNG?t=1413731014\"\n\t\t\ttitle=\"Be sure to head to mappings to map the output from this SSIS package to the correct fields in the table.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/14.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_14.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"781\"\n\t\t\tdata-image-name=\"14.PNG\"\n\t\t\tdata-title=\"14\"\n\t\t\tdata-description=\"Be sure to head to mappings to map the output from this SSIS package to the correct fields in the table.\"\n\t\t\tdata-image-slug=\"14-1\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"14\"\n\t\t\t\t\talt=\"14\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_14.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-14\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/15.PNG?t=1413731014\"\n\t\t\ttitle=\"Now its time to deploy the SSIS package to your SQL server of choosing...\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/15.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_15.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"782\"\n\t\t\tdata-image-name=\"15.PNG\"\n\t\t\tdata-title=\"15\"\n\t\t\tdata-description=\"Now its time to deploy the SSIS package to your SQL server of choosing...\"\n\t\t\tdata-image-slug=\"15-1\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"15\"\n\t\t\t\t\talt=\"15\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_15.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-15\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/16.PNG?t=1413731014\"\n\t\t\ttitle=\"and lastly use the SQL Server Agent job scheduler to automate the running of this package (I set mine to 0730hrs each morning which is roughly an hour before Moodle syncs up with the database allowing me plenty of time to fix it in the event that the jobs fails).\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/16.PNG?t=1413731014\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_16.PNG?t=1413731014\"\n\t\t\tdata-image-id=\"783\"\n\t\t\tdata-image-name=\"16.PNG\"\n\t\t\tdata-title=\"16\"\n\t\t\tdata-description=\"and lastly use the SQL Server Agent job scheduler to automate the running of this package (I set mine to 0730hrs each morning which is roughly an hour before Moodle syncs up with the database allowing me plenty of time to fix it in the event that the jobs fails).\"\n\t\t\tdata-image-slug=\"16-1\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"be23036f1dd67531ac17e5c87341874a\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"16\"\n\t\t\t\t\talt=\"16\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassssis\/thumbs\/thumbs_16.PNG?t=1413731014\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\n\t<br style=\"clear: both\" \/>\n\n\t\n\t\t<div class=\"ngg-clear\"><\/div>\n\t<\/div>\n<\/p>\n<h4>Active Directory setup<\/h4>\n<p>Next up you will need the employeeID field set for all of your AD users to match the personID in SIMS, its a long task to do the first time round (especially with 100s+ of users to deal with) however there are many rewards other than just linking SIMS and Moodle. If required you can generate a report in SIMS to show the list of names against the personID filed using the 3rd party integrations &gt; ID.<\/p>\n<p><!-- default-view.php -->\n<div\n\tclass=\"ngg-galleryoverview default-view\n\t ngg-ajax-pagination-none\t\"\n\tid=\"ngg-gallery-74883ecc66c365ccc28e1c3d1394861e-1\"\n\tdata-nextgen-gallery-id=\"95\"\n\tdata-gallery-id=\"95\"\n\t\tdata-gallery-name=\"MoodleClassAD\"\n\t>\n\n\t\t<!-- Thumbnails -->\n\t\t\t\t<div id=\"ngg-image-0\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassad\/1.PNG?t=1413732967\"\n\t\t\ttitle=\"You can find the employeeID field in AD by taking a look at the Attribute Editor on a user account. Be sure to set these the same as they appear for Person_id in SIMS.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassad\/1.PNG?t=1413732967\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassad\/thumbs\/thumbs_1.PNG?t=1413732967\"\n\t\t\tdata-image-id=\"793\"\n\t\t\tdata-image-name=\"1.PNG\"\n\t\t\tdata-title=\"1\"\n\t\t\tdata-description=\"You can find the employeeID field in AD by taking a look at the Attribute Editor on a user account. Be sure to set these the same as they appear for Person_id in SIMS.\"\n\t\t\tdata-image-slug=\"1-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"74883ecc66c365ccc28e1c3d1394861e\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"1\"\n\t\t\t\t\talt=\"1\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassad\/thumbs\/thumbs_1.PNG?t=1413732967\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-1\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassad\/2a.PNG?t=1413731388\"\n\t\t\ttitle=\"Next up head to Site administration &gt; Plugins &gt; Authentication &gt; LDAP server on your Moodle install\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassad\/2a.PNG?t=1413731388\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassad\/thumbs\/thumbs_2a.PNG?t=1413731388\"\n\t\t\tdata-image-id=\"794\"\n\t\t\tdata-image-name=\"2a.PNG\"\n\t\t\tdata-title=\"2a\"\n\t\t\tdata-description=\"Next up head to Site administration &gt; Plugins &gt; Authentication &gt; LDAP server on your Moodle install\"\n\t\t\tdata-image-slug=\"2a\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"74883ecc66c365ccc28e1c3d1394861e\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"2a\"\n\t\t\t\t\talt=\"2a\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassad\/thumbs\/thumbs_2a.PNG?t=1413731388\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-2\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassad\/2b.PNG?t=1413731388\"\n\t\t\ttitle=\"And set the ID number field to employeeID (which will be read from AD), if you have already got users actively using Moodle then you will want to Update local to on login to ensure this number propagates to Moodle.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassad\/2b.PNG?t=1413731388\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassad\/thumbs\/thumbs_2b.PNG?t=1413731388\"\n\t\t\tdata-image-id=\"795\"\n\t\t\tdata-image-name=\"2b.PNG\"\n\t\t\tdata-title=\"2b\"\n\t\t\tdata-description=\"And set the ID number field to employeeID (which will be read from AD), if you have already got users actively using Moodle then you will want to Update local to on login to ensure this number propagates to Moodle.\"\n\t\t\tdata-image-slug=\"2b\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"74883ecc66c365ccc28e1c3d1394861e\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"2b\"\n\t\t\t\t\talt=\"2b\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassad\/thumbs\/thumbs_2b.PNG?t=1413731388\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\n\t<br style=\"clear: both\" \/>\n\n\t\n\t\t<div class=\"ngg-clear\"><\/div>\n\t<\/div>\n<\/p>\n<h4>Moodle setup<\/h4>\n<p>In this instance the Moodle server is running on IIS, as before you will need the following strings as part of the guide which are used when setting up a scheduled task to sync the users from the DB. The top line is the path to the installation of PHP that I am using in my Moodle install (you can find this by going to <span tabindex=\"0\">Site administration &gt;<\/span>\u00a0<span tabindex=\"0\">Server &gt;<\/span>\u00a0PHP info) and the second is the path to the database sync script (you will find this in your moodle installation under enrol).<\/p>\n<blockquote><p>&#8220;C:\\Program Files (x86)\\PHP\\v5.4\\php-win.exe&#8221; &#8220;E:\\IIS\\Portal2\\enrol\\database\\cli\\sync.php&#8221;<\/p><\/blockquote>\n<p><!-- default-view.php -->\n<div\n\tclass=\"ngg-galleryoverview default-view\n\t ngg-ajax-pagination-none\t\"\n\tid=\"ngg-gallery-dafddfcb001705ababdba4f60a7d222c-1\"\n\tdata-nextgen-gallery-id=\"96\"\n\tdata-gallery-id=\"96\"\n\t\tdata-gallery-name=\"MoodleClassMoodle\"\n\t>\n\n\t\t<!-- Thumbnails -->\n\t\t\t\t<div id=\"ngg-image-0\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/1.PNG?t=1413732967\"\n\t\t\ttitle=\"Almost there! If you haven&#039;t already enable the External database enrolment plugin on your Moodle install (found under Site Administration &gt; Plugins &gt; Enrolments &gt; Manage enrol plugins).\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/1.PNG?t=1413732967\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_1.PNG?t=1413732967\"\n\t\t\tdata-image-id=\"797\"\n\t\t\tdata-image-name=\"1.PNG\"\n\t\t\tdata-title=\"1\"\n\t\t\tdata-description=\"Almost there! If you haven&#039;t already enable the External database enrolment plugin on your Moodle install (found under Site Administration &gt; Plugins &gt; Enrolments &gt; Manage enrol plugins).\"\n\t\t\tdata-image-slug=\"1-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"dafddfcb001705ababdba4f60a7d222c\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"1\"\n\t\t\t\t\talt=\"1\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_1.PNG?t=1413732967\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-1\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/2.PNG?t=1413732635\"\n\t\t\ttitle=\"Now head into the External database settings.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/2.PNG?t=1413732635\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_2.PNG?t=1413732635\"\n\t\t\tdata-image-id=\"796\"\n\t\t\tdata-image-name=\"2.PNG\"\n\t\t\tdata-title=\"2\"\n\t\t\tdata-description=\"Now head into the External database settings.\"\n\t\t\tdata-image-slug=\"2-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"dafddfcb001705ababdba4f60a7d222c\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"2\"\n\t\t\t\t\talt=\"2\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_2.PNG?t=1413732635\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-2\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/3.PNG?t=1413732635\"\n\t\t\ttitle=\"Set the database drive to mssqlnative and the database host to your server which is hosting the SQL database that we setup in the previous steps. In addition enter the database name, the username and password to a user which can connect to that database (using SQL authentication).\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/3.PNG?t=1413732635\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_3.PNG?t=1413732635\"\n\t\t\tdata-image-id=\"798\"\n\t\t\tdata-image-name=\"3.PNG\"\n\t\t\tdata-title=\"3\"\n\t\t\tdata-description=\"Set the database drive to mssqlnative and the database host to your server which is hosting the SQL database that we setup in the previous steps. In addition enter the database name, the username and password to a user which can connect to that database (using SQL authentication).\"\n\t\t\tdata-image-slug=\"3-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"dafddfcb001705ababdba4f60a7d222c\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"3\"\n\t\t\t\t\talt=\"3\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_3.PNG?t=1413732635\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-3\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/4.PNG?t=1413732635\"\n\t\t\ttitle=\"Under Remote Enrolment Sync enter the names of the fields that are being used in your database to match up with the fields required by Moodle to enrol the users in your courses.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/4.PNG?t=1413732635\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_4.PNG?t=1413732635\"\n\t\t\tdata-image-id=\"799\"\n\t\t\tdata-image-name=\"4.PNG\"\n\t\t\tdata-title=\"4\"\n\t\t\tdata-description=\"Under Remote Enrolment Sync enter the names of the fields that are being used in your database to match up with the fields required by Moodle to enrol the users in your courses.\"\n\t\t\tdata-image-slug=\"4-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"dafddfcb001705ababdba4f60a7d222c\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"4\"\n\t\t\t\t\talt=\"4\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_4.PNG?t=1413732635\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-4\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/5.PNG?t=1413732635\"\n\t\t\ttitle=\"Be sure to set the External unenrol action to a setting of your choice (docs on this can be found on the Moodle help pages).\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/5.PNG?t=1413732635\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_5.PNG?t=1413732635\"\n\t\t\tdata-image-id=\"800\"\n\t\t\tdata-image-name=\"5.PNG\"\n\t\t\tdata-title=\"5\"\n\t\t\tdata-description=\"Be sure to set the External unenrol action to a setting of your choice (docs on this can be found on the Moodle help pages).\"\n\t\t\tdata-image-slug=\"5-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"dafddfcb001705ababdba4f60a7d222c\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"5\"\n\t\t\t\t\talt=\"5\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_5.PNG?t=1413732635\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-5\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/6.PNG?t=1413732635\"\n\t\t\ttitle=\"Last up save changes.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/6.PNG?t=1413732635\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_6.PNG?t=1413732635\"\n\t\t\tdata-image-id=\"801\"\n\t\t\tdata-image-name=\"6.PNG\"\n\t\t\tdata-title=\"6\"\n\t\t\tdata-description=\"Last up save changes.\"\n\t\t\tdata-image-slug=\"6-8\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"dafddfcb001705ababdba4f60a7d222c\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"6\"\n\t\t\t\t\talt=\"6\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_6.PNG?t=1413732635\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-6\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/7.PNG?t=1413732635\"\n\t\t\ttitle=\"Now jump onto the server that is hosting your Moodle install and start a new scheduled task to run the script which reads the database and updates the enrolments on Moodle.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/7.PNG?t=1413732635\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_7.PNG?t=1413732635\"\n\t\t\tdata-image-id=\"802\"\n\t\t\tdata-image-name=\"7.PNG\"\n\t\t\tdata-title=\"7\"\n\t\t\tdata-description=\"Now jump onto the server that is hosting your Moodle install and start a new scheduled task to run the script which reads the database and updates the enrolments on Moodle.\"\n\t\t\tdata-image-slug=\"7-7\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"dafddfcb001705ababdba4f60a7d222c\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"7\"\n\t\t\t\t\talt=\"7\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_7.PNG?t=1413732635\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-7\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/8.PNG?t=1413732635\"\n\t\t\ttitle=\"I&#039;ve got mine set to run at 0830hrs in the morning which is about an hour after the database is updated, the theory being is that this is enough time to fix any issues if something goes wrong with the database.\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/8.PNG?t=1413732635\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_8.PNG?t=1413732635\"\n\t\t\tdata-image-id=\"803\"\n\t\t\tdata-image-name=\"8.PNG\"\n\t\t\tdata-title=\"8\"\n\t\t\tdata-description=\"I&#039;ve got mine set to run at 0830hrs in the morning which is about an hour after the database is updated, the theory being is that this is enough time to fix any issues if something goes wrong with the database.\"\n\t\t\tdata-image-slug=\"8-7\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"dafddfcb001705ababdba4f60a7d222c\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"8\"\n\t\t\t\t\talt=\"8\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_8.PNG?t=1413732635\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-8\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/9.PNG?t=1413732635\"\n\t\t\ttitle=\"You will need to direct the task to run the php-win.exe program with an argument set to run the script which is stored in the Moodle install. (more details on the paths are in the main article).\"\n\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/9.PNG?t=1413732635\"\n\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_9.PNG?t=1413732635\"\n\t\t\tdata-image-id=\"804\"\n\t\t\tdata-image-name=\"9.PNG\"\n\t\t\tdata-title=\"9\"\n\t\t\tdata-description=\"You will need to direct the task to run the php-win.exe program with an argument set to run the script which is stored in the Moodle install. (more details on the paths are in the main article).\"\n\t\t\tdata-image-slug=\"9-4\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"dafddfcb001705ababdba4f60a7d222c\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"9\"\n\t\t\t\t\talt=\"9\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/moodleclassmoodle\/thumbs\/thumbs_9.PNG?t=1413732635\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\n\t<br style=\"clear: both\" \/>\n\n\t\n\t\t<div class=\"ngg-clear\"><\/div>\n\t<\/div>\n<\/p>\n<h4>All done!<\/h4>\n<p>Hopefully you will now have a Moodle install which automates the process of adding students and teachers to classes; its also worth noting that this process can be used with other MISs &#8211; its just a matter of getting the data out in a report form and feeding it into SSIS.<\/p>\n<p>Please do comment in the box below if you have any ways to improve the process (at some point I will make an article on doing the same for course generation)!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the holy grails of Moodle is having it such that students are added to the right courses in an automated way. This becomes particularly true if you have individual courses for each and every class each of which could have up to 30 enrolments to go through (just far to many to do using manual methods). Moodle has&#8230; <a class=\"read-more\" href=\"https:\/\/myworldofit.net\/?p=8312\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[24],"tags":[255,124,243,253,254],"series":[],"class_list":["post-8312","post","type-post","status-publish","format-standard","hentry","category-mobile-working","tag-capita-sims","tag-moodle","tag-sims","tag-sql-server","tag-ssis"],"_links":{"self":[{"href":"https:\/\/myworldofit.net\/index.php?rest_route=\/wp\/v2\/posts\/8312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myworldofit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myworldofit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myworldofit.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myworldofit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8312"}],"version-history":[{"count":26,"href":"https:\/\/myworldofit.net\/index.php?rest_route=\/wp\/v2\/posts\/8312\/revisions"}],"predecessor-version":[{"id":8434,"href":"https:\/\/myworldofit.net\/index.php?rest_route=\/wp\/v2\/posts\/8312\/revisions\/8434"}],"wp:attachment":[{"href":"https:\/\/myworldofit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myworldofit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myworldofit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8312"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/myworldofit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fseries&post=8312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}