{"id":1413,"date":"2022-10-17T16:00:41","date_gmt":"2022-10-17T16:00:41","guid":{"rendered":"https:\/\/help.theprismsystems.com\/?p=1413"},"modified":"2023-10-14T19:38:01","modified_gmt":"2023-10-14T19:38:01","slug":"elearning-how-to-import-students-via-sftp-server-automation","status":"publish","type":"post","link":"https:\/\/help.prismsis.com\/?p=1413","title":{"rendered":"How to import students via SFTP server automation"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1413\" class=\"elementor elementor-1413\">\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-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\">Board Privileges<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"elementor-alert-description\">Please contact help@theprismsystems.com to ensure your Board has access to the SFTP server automation. <\/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-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. Upload your student import files to our SFTP server with the provided credentials. Each school should be in their own file labelled SchoolMidentNumber.csv or SchoolMidentNumber.tsv. You may also compress all the individual files into a zip file (zip filename does not matter in this case), and that file can be uploaded to the specified folder on the SFTP server.<\/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. Each night PRISM will process the files in the specified folder. Successful files will have their student data imported into the production environment and any invalid files or rows will be noted and included within the daily email log.<\/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>Board Privileges Please contact help@theprismsystems.com to ensure your Board has access to the SFTP server automation. 1. Upload your student import files to our SFTP server with the provided credentials. Each school should be in their own file labelled SchoolMidentNumber.csv or SchoolMidentNumber.tsv. You may also compress all the individual files into a zip file (zip filename does not matter in this case), and that file can be uploaded to the specified folder on the SFTP server. 2. Each night PRISM will process the files in the specified folder. Successful files will have their student data imported into the production environment and any invalid files or rows will be noted and included within the daily email log.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[13],"class_list":["post-1413","post","type-post","status-publish","format-standard","hentry","category-elearning","tag-technical-documentation"],"_links":{"self":[{"href":"https:\/\/help.prismsis.com\/index.php?rest_route=\/wp\/v2\/posts\/1413","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=1413"}],"version-history":[{"count":5,"href":"https:\/\/help.prismsis.com\/index.php?rest_route=\/wp\/v2\/posts\/1413\/revisions"}],"predecessor-version":[{"id":1480,"href":"https:\/\/help.prismsis.com\/index.php?rest_route=\/wp\/v2\/posts\/1413\/revisions\/1480"}],"wp:attachment":[{"href":"https:\/\/help.prismsis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.prismsis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.prismsis.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}