{"id":22770,"date":"2021-05-24T16:14:01","date_gmt":"2021-05-24T20:14:01","guid":{"rendered":"https:\/\/inside.wooster.edu\/technology-documentation\/?page_id=268"},"modified":"2022-08-09T16:07:52","modified_gmt":"2022-08-09T20:07:52","slug":"room-assignments-file-format","status":"publish","type":"epkb_post_type_1","link":"https:\/\/inside.wooster.edu\/technology\/knowledge-base\/room-assignments-file-format\/","title":{"rendered":"Room Assignments File Format"},"content":{"rendered":"\n\t\t<div id=\"eckb-article-page-container-v2\" class=\"eckb-article-page-content-counter eckb_ap_active_theme_twentytwentytwo \" data-mobile_breakpoint=\"768\">    \t\t\t\t<a href=\"#eckb-article-content\" class=\"eckb-skip-link eckb-screen-reader-text\">Skip to main content<\/a>   <div id=\"eckb-article-header\" >\n\t\t<div id=\"epkb-ml__module-search\" class=\"epkb-ml__module \">   \n\t\t\t<!-- Classic Search Layout -->\n\t\t\t<div id=\"epkb-ml-search-classic-layout\">    \t\t<h2 class=\"epkb-ml-search-title\">What can we help you with?<\/h2>   \t\t\t\t<form id=\"epkb-ml-search-form\" class=\"epkb-ml-search-input-height--medium\" method=\"get\" onsubmit=\"return false;\" data-collection-id=\"1\" data-collection-token=\"0ea277a406\">\n\t\t\t\t<input type=\"hidden\" id=\"epkb_kb_id\" value=\"1\" >\n\n\t\t\t\t<!-- Search Input Box -->\n\t\t\t\t<div id=\"epkb-ml-search-box\">\n\t\t\t\t\t<input class=\"epkb-ml-search-box__input\" type=\"text\" name=\"s\" value=\"\" aria-label=\"Search the documentation...\"\n\t\t\t\t\t        placeholder=\"Search the documentation...\" aria-controls=\"epkb-ml-search-results\" >\n\t\t\t\t\t<button class=\"epkb-ml-search-box__btn\" type=\"submit\">\n                        <span class=\"epkb-ml-search-box__text\"> Search<\/span>\n                        <span class=\"epkbfa epkbfa-spinner epkbfa-ml-loading-icon\"><\/span>\n                    <\/button>\n\t\t\t\t<\/div>\n\n\t\t\t\t<!-- Search Results -->\n\t\t\t\t<div id=\"epkb-ml-search-results\" aria-live=\"polite\"><\/div>\n\t\t\t<\/form>\n\t\t<\/div>  \n\t\t<\/div>  <\/div>\n\t\t\t<div id=\"eckb-article-body\">  <div id=\"eckb-article-left-sidebar\" ><\/div>\n\t\t        <article id=\"eckb-article-content\" tabindex=\"-1\" data-article-id=\"22770\" >                        <div id=\"eckb-article-content-header-v2\" ><div id=\"eckb-article-content-header-row-1\"><div class=\"eckb-article-content-header-row-left-group\"><div id=\"eckb-article-back-navigation-container\"><div class=\"eckb-navigation-back  \"  style=\"margin-top: 4px; margin-right: 15px; margin-bottom: 4px; margin-left: 4px;\" ><div tabindex=\"0\" class=\"eckb-navigation-button\"  style=\"padding-top: 5px; padding-right: 10px; padding-bottom: 5px; padding-left: 10px; color: #1e73be; background-color: #ffffff; font-size:14px;border-radius: 3px; border-style: solid; border-width: 1px; border-color: #b5b5b5;\"  onclick=\"history.go(-1);\" >&lt; All Topics<\/div><\/div><\/div><div id=\"eckb-article-content-breadcrumb-container\">\n\t<div class=\"eckb-breadcrumb\"  style=\"padding-top: 0px; padding-right: 4px; padding-bottom: 0px; padding-left: 4px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-size:14px;\" >    \t\t<nav class=\"eckb-breadcrumb-outline\" aria-label=\"Breadcrumb\">\n\t\t\t<ul class=\"eckb-breadcrumb-nav\">       <li  style=\"font-size:14px;\" >\t<span class=\"eckb-breadcrumb-link\"><a tabindex=\"0\" href=\"https:\/\/inside.wooster.edu\/technology\/knowledge-base\/\"><span  style=\"color: #1e73be;\"  >Main<\/span><\/a><span class=\"eckb-breadcrumb-link-icon ep_font_icon_arrow_carrot_right\" aria-hidden=\"true\"><\/span>\t<\/span><\/li><li  style=\"font-size:14px;\" >\t<span class=\"eckb-breadcrumb-link\"><a tabindex=\"0\" href=\"https:\/\/inside.wooster.edu\/technology\/knowledge-base\/category\/software\/\"><span  style=\"color: #1e73be;\"  >Software<\/span><\/a><span class=\"eckb-breadcrumb-link-icon ep_font_icon_arrow_carrot_right\" aria-hidden=\"true\"><\/span>\t<\/span><\/li><li  style=\"font-size:14px;\" >\t<span class=\"eckb-breadcrumb-link\"><a tabindex=\"0\" href=\"https:\/\/inside.wooster.edu\/technology\/knowledge-base\/category\/software\/software-for-teaching\/\"><span  style=\"color: #1e73be;\"  >Faculty Software<\/span><\/a><span class=\"eckb-breadcrumb-link-icon ep_font_icon_arrow_carrot_right\" aria-hidden=\"true\"><\/span>\t<\/span><\/li><li  style=\"font-size:14px;\" >\t<span class=\"eckb-breadcrumb-link\"><span aria-current=\"page\" style=\"color: #1e73be;\"  >Room Assignments File Format<\/span>\t<\/span><\/li>\t\t\t<\/ul>\n\t\t<\/nav>\n\n\t<\/div>          <\/div><\/div><div class=\"eckb-article-content-header-row-right-group\"><div id=\"eckb-article-content-toolbar-container\">\n\t\t<div class=\"eckb-article-content-toolbar-button-container\">\n\t\t\t<span class=\"eckb-print-button-container\" tabindex=\"0\" role=\"button\" aria-label=\"Print\">\t\t\t<span class=\"eckb-toolbar-button-text\">Print<\/span><span class=\"eckb-toolbar-button-icon epkbfa epkbfa-print\"><\/span>\t\t\t<\/span>\n\t\t<\/div> <\/div><\/div><\/div><div id=\"eckb-article-content-header-row-2\"><div class=\"eckb-article-content-header-row-left-group\"><div id=\"eckb-article-content-title-container\"><h1 class=\"eckb-article-title\">Room Assignments File Format<\/h1><\/div><\/div><\/div><div id=\"eckb-article-content-header-row-3\"><div class=\"eckb-article-content-header-row-left-group\">\n\t\t<div class=\"eckb-article-content-last-updated-date-container\">\t\t<span class=\"eckb-meta-data-feature-icon epkbfa epkbfa-pencil-square-o\"><\/span><span class=\"eckb-meta-data-feature-text\">Updated<\/span><span class=\"eckb-meta-data-feature-value\"><time datetime=\"2022-08-09T16:07:52-04:00\">August 9, 2022<\/time><\/span>\t\t<\/div> <\/div><\/div><\/div><div id=\"eckb-article-content-body\" >\n<p>Room assignments can be loaded into Colleague given a file of room assignments. To do this, create an Excel spreadsheet with the following columns, filling in the needed data for each room assignment:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Person ID &#8211; ID of the person being given the room assignment. It does not need to be zero padded, the program will fix this if needed.<\/li><li>Term 1 &#8211; Term of the room assignment, ie. 1617FA<\/li><li>Term 2 &#8211; Optional second term of the room assignment, ie. 1617SP<\/li><li>Start date of assignment (optional, for summer only)<\/li><li>End date of assignment (optional, for summer only)<\/li><li>Building &#8211; 3 letter building code for the room assignment<\/li><li>Room &#8211; Room for the assignment. The program should fix any missing leading zeros if Excel removes them.<\/li><li>Rate &#8211; 3 letter code for the rate (may be left blank &#8211; non-blank invalid rate codes will produce an error and the room will not be created)<\/li><\/ul>\n\n\n\n<p>Example: 1048662,1617FA,1617SP,,,MGN,401,DBL<\/p>\n\n\n\n<p>Once complete, save the file as a csv (comma separated values) and send it to IT for import.<\/p>\n\n\n\n<p><strong>Note<\/strong>: Since summer housing dates vary from student to student, these dates for each student should be included in the start and end date columns as noted above. If students have multiple stays, they may be put on multiple lines with the appropriate date range on each. Assignments are automatically split if they span June 30\/July 1 so that they may be billed separately.<\/p>\n<\/div><div id=\"eckb-article-content-footer\" >\n\t\t<div class=\"epkb-article-navigation-container \">            \t\t\t\t<div class=\"epkb-article-navigation__previous\"> <a href=\"https:\/\/inside.wooster.edu\/technology\/knowledge-base\/resources-for-class-projects\/\" rel=\"prev\">\n\t\t\t\t\t<span class=\"epkb-article-navigation__label\">\n\t\t\t\t\t    <span class=\"epkb-article-navigation__label__previous__icon epkbfa epkbfa-caret-left\"><\/span>\n\t\t\t\t\t    Previous\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<span title=\"Resources for Class Projects\" class=\"epkb-article-navigation-article__title\">\n\t\t\t\t\t\t<span class=\"epkb-article-navigation__previous__icon epkbfa ep_font_icon_document\"><\/span>\n\t\t\t\t\t\tResources for Class Projects\n\t\t\t\t\t<\/span>\n\t\t\t\t<\/a>\t\t\t\t<\/div>  \t\t\t\t<div class=\"epkb-article-navigation__next\"><a href=\"https:\/\/inside.wooster.edu\/technology\/knowledge-base\/screen-recording\/?seq_no=2\" rel=\"next\">\n\t\t\t\t\t<span class=\"epkb-article-navigation__label\">\n\t\t\t\t\t    Next\n\t\t\t\t\t    <span class=\"epkb-article-navigation__label__next__icon epkbfa epkbfa-caret-right\"><\/span>\n                    <\/span>\n\t\t\t\t\t<span title=\"Screen Recording\" class=\"epkb-article-navigation-article__title\">\n\t\t\t\t\t\tScreen Recording\n\t\t\t\t\t\t<span class=\"epkb-article-navigation__next__icon epkbfa ep_font_icon_document\"><\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t<\/a>\n\t\t\t   \t\t\t\t<\/div>  \n\t\t<\/div>        <\/div>\n\t\t        <\/article><!-- \/#eckb-article-content -->     <div id=\"eckb-article-right-sidebar\" >\n\t\t\t<div class=\"eckb-article-toc  eckb-article-toc--bmode-between eckb-article-toc-reset \"\t\t\t\t\n\t\t\t\tdata-offset=\"130\"\n\t\t\t\tdata-min=\"2\"\n\t\t\t\tdata-max=\"6\"\n\t\t\t\tdata-speed=\"300\"\n\t\t\t\tdata-exclude_class=\"\"\n\t\t\t\t><div class=\"eckb-article-toc__title\">Table of Contents<\/div><\/div>\n\t\t\t<\/div>\n\t\t\t<\/div><!-- \/#eckb-article-body -->              <div id=\"eckb-article-footer\" ><\/div>\n\t\t<\/div><!-- \/#eckb-article-page-container-v2 -->\n\n\t\t<style id=\"eckb-article-styles\" type=\"text\/css\">@media only screen and (min-width:768px){#eckb-article-page-container-v2 #eckb-article-body #eckb-article-content #eckb-article-content-header-v2 #eckb-article-content-header-row-1,#eckb-article-page-container-v2 #eckb-article-body #eckb-article-content #eckb-article-content-header-v2 #eckb-article-content-header-row-2,#eckb-article-page-container-v2 #eckb-article-body #eckb-article-content #eckb-article-content-header-v2 #eckb-article-content-header-row-3,#eckb-article-page-container-v2 #eckb-article-body #eckb-article-content #eckb-article-content-header-v2 #eckb-article-content-header-row-4,#eckb-article-page-container-v2 #eckb-article-body #eckb-article-content #eckb-article-content-header-v2 #eckb-article-content-header-row-5{flex-direction:row;}}#eckb-article-content-header-row-1{margin-bottom:8px;}#eckb-article-content-header-row-1 .eckb-article-content-header-row-left-group,#eckb-article-content-header-row-1 .eckb-article-content-header-row-right-group{align-items:center;}.eckb-article-content-toolbar-button-container{background-color:#ffffff;padding:10px 10px 10px 10px;margin:0px 0px 0px 0px;border-radius:0px;border-width:0px;border-color:#ffffff;border-style:solid;}.eckb-article-content-toolbar-button-container .eckb-toolbar-button-text{color:#000000;font-size:15px;}.eckb-article-content-toolbar-button-container .eckb-toolbar-button-icon{color:#000000;font-size:20px;}.eckb-article-content-toolbar-button-container:hover{background-color:#ffffff;}.eckb-article-content-toolbar-button-container:hover .eckb-toolbar-button-text{color:#000000;}.eckb-article-content-toolbar-button-container:hover .eckb-toolbar-button-icon{color:#000000;}#eckb-article-content-header-row-2{margin-bottom:0px;}#eckb-article-content-header-row-2 .eckb-article-content-header-row-left-group,#eckb-article-content-header-row-2 .eckb-article-content-header-row-right-group{align-items:flex-end;}#eckb-article-content .eckb-article-title{font-size:50px !important;}#eckb-article-content-header-row-3{margin-bottom:32px;}#eckb-article-content-header-row-3 .eckb-article-content-header-row-left-group,#eckb-article-content-header-row-3 .eckb-article-content-header-row-right-group{align-items:flex-end;}#eckb-article-content-footer .epkb-article-navigation-container a{background-color:#f7f7f7;color:#1e73be;}#eckb-article-content-footer .epkb-article-navigation-container a:hover{background-color:#dee3e5;color:#6d6d6d;}#eckb-article-body .eckb-article-toc ul a.active{background-color:#24629b;color:#ffffff;}#eckb-article-body .eckb-article-toc ul a:hover{background-color:#f2f2f2;color:#000000;}#eckb-article-body .eckb-article-toc__inner{border-color:#9ccdfb;font-size:14px !important;background-color:#fcfcfc;}#eckb-article-body .eckb-article-toc__inner a{color:#9ccdfb;font-size:14px !important;}#eckb-article-body .eckb-article-toc__title{color:#9ccdfb;font-size:15px !important;}<\/style>   ","protected":false},"excerpt":{"rendered":"<p>Skip to main content What can we help you with? Search &lt; All Topics Main Software Faculty Software Room Assignments File Format Print Room Assignments File Format UpdatedAugust 9, 2022 Room assignments can be loaded into Colleague given a file of room assignments. To do this, create an Excel spreadsheet with the following columns, filling [&hellip;]<\/p>\n","protected":false},"author":385,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","footnotes":""},"epkb_post_type_1_category":[355,474,385],"epkb_post_type_1_tag":[],"coauthors":[449],"class_list":["post-22770","epkb_post_type_1","type-epkb_post_type_1","status-publish","hentry","epkb_post_type_1_category-administrative-software","epkb_post_type_1_category-colleague","epkb_post_type_1_category-software-for-teaching"],"acf":[],"featured_image_urls":{"full":"","thumbnail":"","medium":"","medium_large":"","large":"","1536x1536":"","2048x2048":""},"post_excerpt_stackable":"<p>Skip to main content What can we help you with? Search &lt; All Topics Main Software Faculty Software Room Assignments File Format Print Room Assignments File Format UpdatedAugust 9, 2022 Room assignments can be loaded into Colleague given a file of room assignments. To do this, create an Excel spreadsheet with the following columns, filling in the needed data for each room assignment: Person ID &#8211; ID of the person being given the room assignment. It does not need to be zero padded, the program will fix this if needed.Term 1 &#8211; Term of the room assignment, ie. 1617FATerm 2&hellip;<\/p>\n","category_list":"<a href=\"https:\/\/inside.wooster.edu\/technology\/knowledge-base\/category\/software\/administrative-software\/\" rel=\"category tag\">Administrative Software<\/a>, <a href=\"https:\/\/inside.wooster.edu\/technology\/knowledge-base\/category\/software\/colleague\/\" rel=\"category tag\">Colleague<\/a>, <a href=\"https:\/\/inside.wooster.edu\/technology\/knowledge-base\/category\/software\/software-for-teaching\/\" rel=\"category tag\">Faculty Software<\/a>","author_info":{"name":"Matthew E. Baker","url":"https:\/\/inside.wooster.edu\/technology\/author\/mbakerwooster-edu\/"},"comments_num":"0 comments","uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Matthew E. Baker","author_link":"https:\/\/inside.wooster.edu\/technology\/author\/mbakerwooster-edu\/"},"uagb_comment_info":0,"uagb_excerpt":"Skip to main content What can we help you with? Search &lt; All Topics Main Software Faculty Software Room Assignments File Format Print Room Assignments File Format UpdatedAugust 9, 2022 Room assignments can be loaded into Colleague given a file of room assignments. To do this, create an Excel spreadsheet with the following columns, filling&hellip;","_links":{"self":[{"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/epkb_post_type_1\/22770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/epkb_post_type_1"}],"about":[{"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/types\/epkb_post_type_1"}],"author":[{"embeddable":true,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/users\/385"}],"replies":[{"embeddable":true,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/comments?post=22770"}],"version-history":[{"count":1,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/epkb_post_type_1\/22770\/revisions"}],"predecessor-version":[{"id":24376,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/epkb_post_type_1\/22770\/revisions\/24376"}],"wp:attachment":[{"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/media?parent=22770"}],"wp:term":[{"taxonomy":"epkb_post_type_1_category","embeddable":true,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/epkb_post_type_1_category?post=22770"},{"taxonomy":"epkb_post_type_1_tag","embeddable":true,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/epkb_post_type_1_tag?post=22770"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/coauthors?post=22770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}