{"id":943,"date":"2022-09-21T16:02:06","date_gmt":"2022-09-21T16:02:06","guid":{"rendered":"https:\/\/help.theprismsystems.com\/?p=943"},"modified":"2023-10-14T19:38:44","modified_gmt":"2023-10-14T19:38:44","slug":"how-to-import-students-with-a-csv-tsv-file","status":"publish","type":"post","link":"https:\/\/help.prismsis.com\/?p=943","title":{"rendered":"How to import students with a csv\/tsv file"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"943\" class=\"elementor elementor-943\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7349e7a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7349e7a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fc32028\" data-id=\"fc32028\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0f5f702 elementor-widget elementor-widget-text-editor\" data-id=\"0f5f702\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>1. Click on <strong>Files<\/strong> drop-down arrow in the side navigation. <img decoding=\"async\" class=\"alignnone wp-image-945 size-medium\" src=\"https:\/\/help.prismsis.com\/wp-content\/uploads\/2022\/09\/files-nav-300x52.png\" alt=\"\" width=\"300\" height=\"52\" srcset=\"https:\/\/help.prismsis.com\/wp-content\/uploads\/2022\/09\/files-nav-300x52.png 300w, https:\/\/help.prismsis.com\/wp-content\/uploads\/2022\/09\/files-nav.png 498w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bec20fc elementor-widget elementor-widget-text-editor\" data-id=\"bec20fc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>2. From the drop down list select <strong>Import Students from SIS<\/strong>. <img decoding=\"async\" class=\"alignnone wp-image-946 size-medium\" src=\"https:\/\/help.prismsis.com\/wp-content\/uploads\/2022\/09\/import-files-nav-300x92.png\" alt=\"\" width=\"300\" height=\"92\" srcset=\"https:\/\/help.prismsis.com\/wp-content\/uploads\/2022\/09\/import-files-nav-300x92.png 300w, https:\/\/help.prismsis.com\/wp-content\/uploads\/2022\/09\/import-files-nav.png 494w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ecfcaa8 elementor-widget elementor-widget-text-editor\" data-id=\"ecfcaa8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>3. Each school will require its own import file.&nbsp; Select your School Board and the correct School from the drop down menus. Then click the Choose File button to find the file on your computer. Once you have slected the file and selected your School Board and School you will need to click the Upload File button.&nbsp;<img decoding=\"async\" class=\"alignnone size-full wp-image-712\" src=\"https:\/\/help.prismsis.com\/wp-content\/uploads\/2022\/09\/Screen-Shot-2022-09-06-at-2.42.53-PM.png\" alt=\"\" width=\"129\" height=\"33\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-947\" src=\"https:\/\/help.prismsis.com\/wp-content\/uploads\/2022\/09\/import-files-form-1024x917.png\" alt=\"\" width=\"1024\" height=\"917\" srcset=\"https:\/\/help.prismsis.com\/wp-content\/uploads\/2022\/09\/import-files-form-1024x917.png 1024w, https:\/\/help.prismsis.com\/wp-content\/uploads\/2022\/09\/import-files-form-300x269.png 300w, https:\/\/help.prismsis.com\/wp-content\/uploads\/2022\/09\/import-files-form-768x688.png 768w, https:\/\/help.prismsis.com\/wp-content\/uploads\/2022\/09\/import-files-form.png 1528w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d19bfb3 elementor-alert-info elementor-widget elementor-widget-alert\" data-id=\"d19bfb3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"alert.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-alert\" role=\"alert\">\n\n\t\t\t\t\t\t<span class=\"elementor-alert-title\">File Format<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"elementor-alert-description\">Please ensure the file is formatted properly to ensure a successful import. The proper format order is listed in screen capture above. To create a basic student record in PRISM, the fields required are the OEN, First Name, and Last Name.<\/span>\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-859fd5c elementor-widget elementor-widget-text-editor\" data-id=\"859fd5c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>4. You will receive a file import success notification or an alert box will appear with the errors encountered while processing the file that was uploaded.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>1. Click on Files drop-down arrow in the side navigation. 2. From the drop down list select Import Students from SIS. 3. Each school will require its own import file.&nbsp; Select your School Board and the correct School from the drop down menus. Then click the Choose File button to find the file on your computer. Once you have slected the file and selected your School Board and School you will need to click the Upload File button.&nbsp; File Format Please ensure the file is formatted properly to ensure a successful import. The proper format order is listed in screen capture above. To create a basic student record in PRISM, the fields required are the OEN, First Name, and Last [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[13],"class_list":["post-943","post","type-post","status-publish","format-standard","hentry","category-dual-credit","tag-technical-documentation"],"_links":{"self":[{"href":"https:\/\/help.prismsis.com\/index.php?rest_route=\/wp\/v2\/posts\/943","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.prismsis.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.prismsis.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.prismsis.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.prismsis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=943"}],"version-history":[{"count":8,"href":"https:\/\/help.prismsis.com\/index.php?rest_route=\/wp\/v2\/posts\/943\/revisions"}],"predecessor-version":[{"id":1487,"href":"https:\/\/help.prismsis.com\/index.php?rest_route=\/wp\/v2\/posts\/943\/revisions\/1487"}],"wp:attachment":[{"href":"https:\/\/help.prismsis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=943"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.prismsis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=943"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.prismsis.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=943"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}