https:\/\/support.office.com\/en-gb\/Search\/results?query=trim+function<\/a><\/pre>\n","protected":false},"excerpt":{"rendered":"Introduction With the Senior Programme Administrator or\u00a0Programme Administrator role you can enrol yourself or a colleague on any Blackboard course in your School. If you need to enrol colleagues on a large number of courses, you can make use of the Batch Enrol function. Batch-enrol: how to do it This option is only available from the System Admin tab, not from within a course. Go to Admin >Courses and click on Enrol Users. This allows you to upload a file and process multiple course or organisation enrolments at one time. The file can be created easily in Excel, but it must be correctly formatted to work: The file must have one record on each line of the file Each record in the file must be in the following field order: Course ID*, Username *, Course Role, System Availability, Course Availability The first two fields must be completed, the others are optional. But \u2018Course Role\u2019 is vital if you are enrolling staff users.Valid course roles are: EE\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0External Examiner B\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Course Builder CBS\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Course Builder with Stream G\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Marker M\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Mentor P\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Instructor PR\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Periodic Reviewer S\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Student T\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Teaching Assistant TAS\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Teaching Assistant with Stream U\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Guest NON_UoR\u00a0 \u00a0 \u00a0 Non UoR Staff If you don\u2019t enter anything in the Course Role field, Blackboard will assume that the user should be enrolled as a student. Read more on course roles. Needless to say, if you get the Blackboard Course ID or Username wrong, the import will fail \u2013 or, even worse, you will enrol the wrong users on the wrong course. The easiest way to create your file is in Excel. The spreadsheet should look like this Note that There is no header row You can use this method to enrol multiple users onto a single course or multiple courses; or one or more users onto multiple courses; and to enrol staff with different roles on different courses. You should save the file as a CSV file \u2013 in Excel choose File > Save As and select CSV from the Save as type drop-down list. On the Blackboard Enrol Users screen, click on Browse to locate and upload your CSV file. You do not have to specify a \u2018Delimiter Type\u2019 as Blackboard should be able to determine this. If in doubt, before you attempt to upload a file, click on More Help to open a Blackboard help page in a new window. When ready, press Submit. You will see a screen recording the success of the Batch Enrol process. Any errors are shown in red, and Blackboard normally provides sufficient information to diagnose what caused the problem (most likely a data entry error in Excel). Please note that the message \u201cError: Identifying fields are not unique\u201d simply means that the user in question was already enrolled on this courses. Tips 1. Identifying Relevant Blackboard Courses In order to run a batch enrolment, you will need to know the exact Blackboard Course ID for every course you wish to enrol users onto the IT \/ Blackboard username of all users you wish to enrol. Here is a suggested way to obtain a list of Blackboard Course IDs. Go to System Admin > Courses To find courses for the 2019\/20 academic year, change the Search settings to Course ID Starts with Date Created After 01\/05\/2019 This may not be 100% \u00a0accurate, but should pick up most course copies requested in advance of the main course rollover. Courses will be listed by course code, but if desired you could click on the \u2018Date Created\u2019 or \u2018Term\u2019 column heading to reorder the results. Alternatively, you could search for – Term – Starts with 2019 (or 2018 as appropriate) leave Date Created to the default settings i.e. Before today\u2019s date 2. Preparing your Excel file When you have the courses in the desired order, scroll to the bottom of the page and click Show All. Using your mouse, highlight all of the search results. Then right-click or use Ctrl+C to Copy. Open a new Excel workbook. From the menu choose Paste > Paste Special. This should result in the courses list being displayed in a manageable way, with each Blackboard field in a separate column. Ultimately you will only need the Course ID column. But having the data in this way will enable you to identify which courses you require. For instance, there is no point in enrolling users onto a Disabled Blackboard course (this probably means that the course did not run). And into the second term of the academic year, if you find courses marked Unavailable, with no instructors, then you can probably assume that this course is not being used in Blackboard. Such courses can be deleted from your list. Once you have the definitive list of courses, either copy the Course ID column into a new workbook, or just delete all the other columns. You need to end up with a spreadsheet with three columns, showing Course ID, Username and Course Role. You can enrol multiple users onto multiple courses, using just one spreadsheet e.g. Remember to save the file as a CSV file, not an Excel spreadsheet. Removing spaces from your Excel file When you paste a list of course codes into Excel from Blackboard, you might find that there are trailing spaces at the…<\/p>\n","protected":false},"author":57,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"image","meta":{"om_disable_all_campaigns":false,"_lmt_disableupdate":"","_lmt_disable":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}},"_links_to":"","_links_to_target":""},"categories":[351],"tags":[],"jetpack_publicize_connections":[],"yoast_head":"\n
Programme Administrators: How to Batch-enrol Users in a Blackboard Course - Blackboard Help for Staff - University of Reading<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Programme Administrators: How to Batch-enrol Users in a Blackboard Course - Blackboard Help for Staff - University of Reading\" \/>\n<meta property=\"og:description\" content=\"Introduction With the Senior Programme Administrator or\u00a0Programme Administrator role you can enrol yourself or a colleague on any Blackboard course in your School. If you need to enrol colleagues on a large number of courses, you can make use of the Batch Enrol function. Batch-enrol: how to do it This option is only available from the System Admin tab, not from within a course. Go to Admin >Courses and click on Enrol Users. This allows you to upload a file and process multiple course or organisation enrolments at one time. The file can be created easily in Excel, but it must be correctly formatted to work: The file must have one record on each line of the file Each record in the file must be in the following field order: Course ID*, Username *, Course Role, System Availability, Course Availability The first two fields must be completed, the others are optional. But \u2018Course Role\u2019 is vital if you are enrolling staff users.Valid course roles are: EE\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0External Examiner B\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Course Builder CBS\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Course Builder with Stream G\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Marker M\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Mentor P\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Instructor PR\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Periodic Reviewer S\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Student T\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Teaching Assistant TAS\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Teaching Assistant with Stream U\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Guest NON_UoR\u00a0 \u00a0 \u00a0 Non UoR Staff If you don\u2019t enter anything in the Course Role field, Blackboard will assume that the user should be enrolled as a student. Read more on course roles. Needless to say, if you get the Blackboard Course ID or Username wrong, the import will fail \u2013 or, even worse, you will enrol the wrong users on the wrong course. The easiest way to create your file is in Excel. The spreadsheet should look like this Note that There is no header row You can use this method to enrol multiple users onto a single course or multiple courses; or one or more users onto multiple courses; and to enrol staff with different roles on different courses. You should save the file as a CSV file \u2013 in Excel choose File > Save As and select CSV from the Save as type drop-down list. On the Blackboard Enrol Users screen, click on Browse to locate and upload your CSV file. You do not have to specify a \u2018Delimiter Type\u2019 as Blackboard should be able to determine this. If in doubt, before you attempt to upload a file, click on More Help to open a Blackboard help page in a new window. When ready, press Submit. You will see a screen recording the success of the Batch Enrol process. Any errors are shown in red, and Blackboard normally provides sufficient information to diagnose what caused the problem (most likely a data entry error in Excel). Please note that the message \u201cError: Identifying fields are not unique\u201d simply means that the user in question was already enrolled on this courses. Tips 1. Identifying Relevant Blackboard Courses In order to run a batch enrolment, you will need to know the exact Blackboard Course ID for every course you wish to enrol users onto the IT \/ Blackboard username of all users you wish to enrol. Here is a suggested way to obtain a list of Blackboard Course IDs. Go to System Admin > Courses To find courses for the 2019\/20 academic year, change the Search settings to Course ID Starts with Date Created After 01\/05\/2019 This may not be 100% \u00a0accurate, but should pick up most course copies requested in advance of the main course rollover. Courses will be listed by course code, but if desired you could click on the \u2018Date Created\u2019 or \u2018Term\u2019 column heading to reorder the results. Alternatively, you could search for - Term - Starts with 2019 (or 2018 as appropriate) leave Date Created to the default settings i.e. Before today\u2019s date 2. Preparing your Excel file When you have the courses in the desired order, scroll to the bottom of the page and click Show All. Using your mouse, highlight all of the search results. Then right-click or use Ctrl+C to Copy. Open a new Excel workbook. From the menu choose Paste > Paste Special. This should result in the courses list being displayed in a manageable way, with each Blackboard field in a separate column. Ultimately you will only need the Course ID column. But having the data in this way will enable you to identify which courses you require. For instance, there is no point in enrolling users onto a Disabled Blackboard course (this probably means that the course did not run). And into the second term of the academic year, if you find courses marked Unavailable, with no instructors, then you can probably assume that this course is not being used in Blackboard. Such courses can be deleted from your list. Once you have the definitive list of courses, either copy the Course ID column into a new workbook, or just delete all the other columns. You need to end up with a spreadsheet with three columns, showing Course ID, Username and Course Role. You can enrol multiple users onto multiple courses, using just one spreadsheet e.g. Remember to save the file as a CSV file, not an Excel spreadsheet. Removing spaces from your Excel file When you paste a list of course codes into Excel from Blackboard, you might find that there are trailing spaces at the...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/\" \/>\n<meta property=\"og:site_name\" content=\"Blackboard Help for Staff - University of Reading\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-04T11:48:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-10T08:21:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sites.reading.ac.uk\/wp-content\/uploads\/sites\/30\/2019\/03\/sa15.png\" \/>\n<meta name=\"author\" content=\"Sev Raychev\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@UniRdg_TEL\" \/>\n<meta name=\"twitter:site\" content=\"@UniRdg_TEL\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sev Raychev\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/\"},\"author\":{\"name\":\"Sev Raychev\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/640d7afe549491adc1dee885a5869d46\"},\"headline\":\"Programme Administrators: How to Batch-enrol Users in a Blackboard Course\",\"datePublished\":\"2019-03-04T11:48:07+00:00\",\"dateModified\":\"2021-09-10T08:21:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/\"},\"wordCount\":842,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#organization\"},\"articleSection\":[\"Programme Administration\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/\",\"url\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/\",\"name\":\"Programme Administrators: How to Batch-enrol Users in a Blackboard Course - Blackboard Help for Staff - University of Reading\",\"isPartOf\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#website\"},\"datePublished\":\"2019-03-04T11:48:07+00:00\",\"dateModified\":\"2021-09-10T08:21:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sites.reading.ac.uk\/tel-support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Programme Administrators: How to Batch-enrol Users in a Blackboard Course\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#website\",\"url\":\"https:\/\/sites.reading.ac.uk\/tel-support\/\",\"name\":\"Blackboard Help for Staff - University of Reading\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sites.reading.ac.uk\/tel-support\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#organization\",\"name\":\"University of Reading\",\"url\":\"https:\/\/sites.reading.ac.uk\/tel-support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/logo\/image\/\",\"url\":\"\/wp-content\/uploads\/sites\/30\/2018\/10\/rdg.jpg\",\"contentUrl\":\"\/wp-content\/uploads\/sites\/30\/2018\/10\/rdg.jpg\",\"width\":317,\"height\":317,\"caption\":\"University of Reading\"},\"image\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/twitter.com\/UniRdg_TEL\",\"https:\/\/www.youtube.com\/channel\/UCem8bKo2tjqIZnyGA4aNizw\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/640d7afe549491adc1dee885a5869d46\",\"name\":\"Sev Raychev\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d291c30fbc4ff89a61d36261c3764100?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d291c30fbc4ff89a61d36261c3764100?s=96&d=retro&r=g\",\"caption\":\"Sev Raychev\"},\"url\":\"https:\/\/sites.reading.ac.uk\/tel-support\/author\/tel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Programme Administrators: How to Batch-enrol Users in a Blackboard Course - Blackboard Help for Staff - University of Reading","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_GB","og_type":"article","og_title":"Programme Administrators: How to Batch-enrol Users in a Blackboard Course - Blackboard Help for Staff - University of Reading","og_description":"Introduction With the Senior Programme Administrator or\u00a0Programme Administrator role you can enrol yourself or a colleague on any Blackboard course in your School. If you need to enrol colleagues on a large number of courses, you can make use of the Batch Enrol function. Batch-enrol: how to do it This option is only available from the System Admin tab, not from within a course. Go to Admin >Courses and click on Enrol Users. This allows you to upload a file and process multiple course or organisation enrolments at one time. The file can be created easily in Excel, but it must be correctly formatted to work: The file must have one record on each line of the file Each record in the file must be in the following field order: Course ID*, Username *, Course Role, System Availability, Course Availability The first two fields must be completed, the others are optional. But \u2018Course Role\u2019 is vital if you are enrolling staff users.Valid course roles are: EE\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0External Examiner B\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Course Builder CBS\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Course Builder with Stream G\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Marker M\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Mentor P\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Instructor PR\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Periodic Reviewer S\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Student T\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Teaching Assistant TAS\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Teaching Assistant with Stream U\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Guest NON_UoR\u00a0 \u00a0 \u00a0 Non UoR Staff If you don\u2019t enter anything in the Course Role field, Blackboard will assume that the user should be enrolled as a student. Read more on course roles. Needless to say, if you get the Blackboard Course ID or Username wrong, the import will fail \u2013 or, even worse, you will enrol the wrong users on the wrong course. The easiest way to create your file is in Excel. The spreadsheet should look like this Note that There is no header row You can use this method to enrol multiple users onto a single course or multiple courses; or one or more users onto multiple courses; and to enrol staff with different roles on different courses. You should save the file as a CSV file \u2013 in Excel choose File > Save As and select CSV from the Save as type drop-down list. On the Blackboard Enrol Users screen, click on Browse to locate and upload your CSV file. You do not have to specify a \u2018Delimiter Type\u2019 as Blackboard should be able to determine this. If in doubt, before you attempt to upload a file, click on More Help to open a Blackboard help page in a new window. When ready, press Submit. You will see a screen recording the success of the Batch Enrol process. Any errors are shown in red, and Blackboard normally provides sufficient information to diagnose what caused the problem (most likely a data entry error in Excel). Please note that the message \u201cError: Identifying fields are not unique\u201d simply means that the user in question was already enrolled on this courses. Tips 1. Identifying Relevant Blackboard Courses In order to run a batch enrolment, you will need to know the exact Blackboard Course ID for every course you wish to enrol users onto the IT \/ Blackboard username of all users you wish to enrol. Here is a suggested way to obtain a list of Blackboard Course IDs. Go to System Admin > Courses To find courses for the 2019\/20 academic year, change the Search settings to Course ID Starts with Date Created After 01\/05\/2019 This may not be 100% \u00a0accurate, but should pick up most course copies requested in advance of the main course rollover. Courses will be listed by course code, but if desired you could click on the \u2018Date Created\u2019 or \u2018Term\u2019 column heading to reorder the results. Alternatively, you could search for - Term - Starts with 2019 (or 2018 as appropriate) leave Date Created to the default settings i.e. Before today\u2019s date 2. Preparing your Excel file When you have the courses in the desired order, scroll to the bottom of the page and click Show All. Using your mouse, highlight all of the search results. Then right-click or use Ctrl+C to Copy. Open a new Excel workbook. From the menu choose Paste > Paste Special. This should result in the courses list being displayed in a manageable way, with each Blackboard field in a separate column. Ultimately you will only need the Course ID column. But having the data in this way will enable you to identify which courses you require. For instance, there is no point in enrolling users onto a Disabled Blackboard course (this probably means that the course did not run). And into the second term of the academic year, if you find courses marked Unavailable, with no instructors, then you can probably assume that this course is not being used in Blackboard. Such courses can be deleted from your list. Once you have the definitive list of courses, either copy the Course ID column into a new workbook, or just delete all the other columns. You need to end up with a spreadsheet with three columns, showing Course ID, Username and Course Role. You can enrol multiple users onto multiple courses, using just one spreadsheet e.g. Remember to save the file as a CSV file, not an Excel spreadsheet. Removing spaces from your Excel file When you paste a list of course codes into Excel from Blackboard, you might find that there are trailing spaces at the...","og_url":"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/","og_site_name":"Blackboard Help for Staff - University of Reading","article_published_time":"2019-03-04T11:48:07+00:00","article_modified_time":"2021-09-10T08:21:33+00:00","og_image":[{"url":"https:\/\/sites.reading.ac.uk\/wp-content\/uploads\/sites\/30\/2019\/03\/sa15.png"}],"author":"Sev Raychev","twitter_card":"summary_large_image","twitter_creator":"@UniRdg_TEL","twitter_site":"@UniRdg_TEL","twitter_misc":{"Written by":"Sev Raychev","Estimated reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/#article","isPartOf":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/"},"author":{"name":"Sev Raychev","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/640d7afe549491adc1dee885a5869d46"},"headline":"Programme Administrators: How to Batch-enrol Users in a Blackboard Course","datePublished":"2019-03-04T11:48:07+00:00","dateModified":"2021-09-10T08:21:33+00:00","mainEntityOfPage":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/"},"wordCount":842,"commentCount":0,"publisher":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#organization"},"articleSection":["Programme Administration"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/","url":"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/","name":"Programme Administrators: How to Batch-enrol Users in a Blackboard Course - Blackboard Help for Staff - University of Reading","isPartOf":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#website"},"datePublished":"2019-03-04T11:48:07+00:00","dateModified":"2021-09-10T08:21:33+00:00","breadcrumb":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2019\/03\/04\/support-centre-administrators-how-to-batch-enrol-users-in-a-blackboard-course\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sites.reading.ac.uk\/tel-support\/"},{"@type":"ListItem","position":2,"name":"Programme Administrators: How to Batch-enrol Users in a Blackboard Course"}]},{"@type":"WebSite","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#website","url":"https:\/\/sites.reading.ac.uk\/tel-support\/","name":"Blackboard Help for Staff - University of Reading","description":"","publisher":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sites.reading.ac.uk\/tel-support\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#organization","name":"University of Reading","url":"https:\/\/sites.reading.ac.uk\/tel-support\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/logo\/image\/","url":"\/wp-content\/uploads\/sites\/30\/2018\/10\/rdg.jpg","contentUrl":"\/wp-content\/uploads\/sites\/30\/2018\/10\/rdg.jpg","width":317,"height":317,"caption":"University of Reading"},"image":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/twitter.com\/UniRdg_TEL","https:\/\/www.youtube.com\/channel\/UCem8bKo2tjqIZnyGA4aNizw"]},{"@type":"Person","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/640d7afe549491adc1dee885a5869d46","name":"Sev Raychev","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d291c30fbc4ff89a61d36261c3764100?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d291c30fbc4ff89a61d36261c3764100?s=96&d=retro&r=g","caption":"Sev Raychev"},"url":"https:\/\/sites.reading.ac.uk\/tel-support\/author\/tel\/"}]}},"modified_by":"taralehane","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p9WwLV-1l9","_links":{"self":[{"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts\/5155"}],"collection":[{"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/users\/57"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/comments?post=5155"}],"version-history":[{"count":5,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts\/5155\/revisions"}],"predecessor-version":[{"id":11386,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts\/5155\/revisions\/11386"}],"wp:attachment":[{"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/media?parent=5155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/categories?post=5155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/tags?post=5155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"\/wp-content\/uploads\/sites\/30\/2019\/03\/sa15.png\")
<\/p>\n![\"Excel](\"\/wp-content\/uploads\/sites\/30\/2019\/03\/sa16.png\")
<\/p>\n![\"\"](\"\/wp-content\/uploads\/sites\/30\/2019\/03\/sa17-1.png\")
<\/p>\n![\"\"](\"\/wp-content\/uploads\/sites\/30\/2019\/03\/sa18.png\")
<\/p>\n![\"\"](\"\/wp-content\/uploads\/sites\/30\/2019\/03\/sa19.png\")
<\/p>\n![\"\"](\"\/wp-content\/uploads\/sites\/30\/2019\/03\/sa4.png\")
<\/p>\n![\"\"](\"\/wp-content\/uploads\/sites\/30\/2019\/03\/sa24.png\")
<\/pre>\n![\"\"](\"\/wp-content\/uploads\/sites\/30\/2019\/03\/sa25.png\")
<\/p>\n![\"\"](\"\/wp-content\/uploads\/sites\/30\/2019\/03\/sa26.png\")
<\/p>\n![\"\"](\"\/wp-content\/uploads\/sites\/30\/2019\/03\/sa27.png\")
<\/p>\n![\"\"](\"\/wp-content\/uploads\/sites\/30\/2019\/03\/sa28.png\")
<\/p>\n![\"\"](\"\/wp-content\/uploads\/sites\/30\/2019\/03\/sa29.png\")
<\/p>\n