{"id":9293,"date":"2016-12-28T14:54:00","date_gmt":"2016-12-28T14:54:00","guid":{"rendered":"https:\/\/www.process.st\/templates\/how-to-move-filesdata-from-doc-library-to-sp-list\/"},"modified":"2024-02-28T20:50:12","modified_gmt":"2024-02-28T20:50:12","slug":"how-to-move-filesdata-from-doc-library-to-sp-list","status":"publish","type":"post","link":"https:\/\/www.process.st\/templates\/how-to-move-filesdata-from-doc-library-to-sp-list\/","title":{"rendered":"How to Move Files\/Data from Doc Library to SP List"},"content":{"rendered":"<section id=\"before-you-begin\">\n<h2> Before you begin... <\/h2>\n<div class=\"text-content\">\n<ol>\n<li>Create temp folder on desktop (to be used for&nbsp;temporarily downloading\/storing files)<\/li>\n<li>Open:\n<ol>\n<li><a href=\"https:\/\/mdoe.state.mi.us\/MOECS\/login.aspx\" rel=\"nofollow noopener\" target=\"_blank\">MOECS<\/a><\/li>\n<li><a href=\"https:\/\/nationalheritageacademies.sharepoint.com\/sites\/sitehub\/professionaldevelopment\/Lists\/Test%20PD%20Documentation%20List\/AllItems.aspx\" rel=\"nofollow noopener\" target=\"_blank\">SharePoint LIst (new)<\/a><\/li>\n<li><a href=\"https:\/\/nationalheritageacademies.sharepoint.com\/sites\/sitehub\/professionaldevelopment\/Documents\/Forms\/AllItems.aspx\" rel=\"nofollow noopener\" target=\"_blank\">SharePoint Document Library (old)<\/a><\/li>\n<li><a href=\"https:\/\/nationalheritageacademies.sharepoint.com\/sites\/nhapddata\/_layouts\/15\/guestaccess.aspx?guestaccesstoken=jT%2fe%2faaRlpiwgSakLaehw9%2b7Hhw2TbstOIb6b4TCtxU%3d&amp;docid=2_1c59978764d994eb2b285eb2136592851&amp;rev=1\" rel=\"nofollow noopener\" target=\"_blank\">View PD Data Workbook<\/a><\/li>\n<li><a href=\"https:\/\/nationalheritageacademies.sharepoint.com\/sites\/nhapddata\/_layouts\/15\/guestaccess.aspx?guestaccesstoken=vwq9jAOyLUgfXHVeUR%2bkRHnZTRSjxgOQcniYn1w2bRA%3d&amp;docid=2_1e7e80a4db05948aba48564f4e2e42a37&amp;rev=1\" rel=\"nofollow noopener\" target=\"_blank\">Master 16\/17 SY SCECH Excel sheet<\/a><\/li>\n<\/ol>\n<\/li>\n<\/ol><\/div>\n<\/section>\n<section id=\"look-up-and-enter-data-into-sharepoint-list\">\n<h2> Look up and enter data into SharePoint List <\/h2>\n<div class=\"text-content\">\n<p>1. Copy the Program Approval # from the next available row in the <strong>Master SCECH 16\/17&nbsp;Excel sheet<\/strong><\/p>\n<p>2. Find the corresponding SCECH program in the <strong>SharePoint List<\/strong> (see screenshot below)<\/p>\n<p><em>- Optionally search by Program Approval #<\/em><br \/><em>- Select the row<\/em><br \/><em>- Click on the &quot;i&quot; button to bring up the properties pane<\/em><\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/rrSsxhQ2j57zB0frK55LQg.png\" alt=\"\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/rrSsxhQ2j57zB0frK55LQg.png\" \/> <\/a><figcaption>\n   <\/figcaption><\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>3. Find the corresponding SCECH in <strong>MOECS <\/strong>(see screenshot below)<\/p>\n<p><em>- Go to Professional Learning Programs tab<\/em><br \/><em>- Paste Program Number<\/em><br \/><em>- Click on Program Number<\/em><br \/><em>- Verify\/Edit details from MOECS into SharePoint<\/em><\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/ul7t3VuS9ikK8hQffQNOCw.png\" alt=\"\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/ul7t3VuS9ikK8hQffQNOCw.png\" \/> <\/a><figcaption>\n   <\/figcaption><\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>4. In the <strong>SharePoint list<\/strong> properties pane,<\/p>\n<\/p><\/div>\n<div class=\"multi-select-content form-field-content\">\n<ul class=\"items\">\n<li class=\"item\">\n<div class=\"step-number-container\">\n<div class=\"step-number\">\n       1\n     <\/div>\n<\/p><\/div>\n<div class=\"step-checkbox-container\">\n<div class=\"step-checkbox\"><\/div>\n<\/p><\/div>\n<div class=\"item-name-static\">\n      Verify\/Enter the Start Date and End Date\n    <\/div>\n<\/li>\n<li class=\"item\">\n<div class=\"step-number-container\">\n<div class=\"step-number\">\n       2\n     <\/div>\n<\/p><\/div>\n<div class=\"step-checkbox-container\">\n<div class=\"step-checkbox\"><\/div>\n<\/p><\/div>\n<div class=\"item-name-static\">\n      Select &quot;N&quot; for Grant Funded\n    <\/div>\n<\/li>\n<li class=\"item\">\n<div class=\"step-number-container\">\n<div class=\"step-number\">\n       3\n     <\/div>\n<\/p><\/div>\n<div class=\"step-checkbox-container\">\n<div class=\"step-checkbox\"><\/div>\n<\/p><\/div>\n<div class=\"item-name-static\">\n      Verify\/Enter the Learning Hours (Min) &amp; (Max)\n    <\/div>\n<\/li>\n<li class=\"item\">\n<div class=\"step-number-container\">\n<div class=\"step-number\">\n       4\n     <\/div>\n<\/p><\/div>\n<div class=\"step-checkbox-container\">\n<div class=\"step-checkbox\"><\/div>\n<\/p><\/div>\n<div class=\"item-name-static\">\n      Verify\/Enter the Schools in Attendance*\n    <\/div>\n<\/li>\n<li class=\"item\">\n<div class=\"step-number-container\">\n<div class=\"step-number\">\n       5\n     <\/div>\n<\/p><\/div>\n<div class=\"step-checkbox-container\">\n<div class=\"step-checkbox\"><\/div>\n<\/p><\/div>\n<div class=\"item-name-static\">\n      Select School or Service Center Level\n    <\/div>\n<\/li>\n<\/ul><\/div>\n<div class=\"text-content\">\n<p>* To verify Schools in Attendance, filter the <strong>View PD Data Workbook<\/strong> by the Program Approval #, then sort by school; Select each corresponding school from the dropdown in SharePoint.<\/p>\n<\/p><\/div>\n<\/section>\n<section id=\"add-attachments\">\n<h2> Add Attachments <\/h2>\n<div class=\"text-content\">\n<p>5. Find the Program file in the&nbsp;<strong>SharePoint Document Library (old)<\/strong> by either navigating the folder structure or searching by Program Title<\/p>\n<p><em>(Note: to preview a file, select its row and click the &quot;i&quot; button on the top right)<\/em><\/p>\n<p>6. Download and rename the files into the temp desktop folder:<\/p>\n<\/p><\/div>\n<div class=\"multi-select-content form-field-content\">\n<ul class=\"items\">\n<li class=\"item\">\n<div class=\"step-number-container\">\n<div class=\"step-number\">\n       1\n     <\/div>\n<\/p><\/div>\n<div class=\"step-checkbox-container\">\n<div class=\"step-checkbox\"><\/div>\n<\/p><\/div>\n<div class=\"item-name-static\">\n      Download\/Rename the Agenda &amp; Application (in Word &amp; PDF if applicable)\n    <\/div>\n<\/li>\n<li class=\"item\">\n<div class=\"step-number-container\">\n<div class=\"step-number\">\n       2\n     <\/div>\n<\/p><\/div>\n<div class=\"step-checkbox-container\">\n<div class=\"step-checkbox\"><\/div>\n<\/p><\/div>\n<div class=\"item-name-static\">\n      Download\/Rename the Approved Application\n    <\/div>\n<\/li>\n<li class=\"item\">\n<div class=\"step-number-container\">\n<div class=\"step-number\">\n       3\n     <\/div>\n<\/p><\/div>\n<div class=\"step-checkbox-container\">\n<div class=\"step-checkbox\"><\/div>\n<\/p><\/div>\n<div class=\"item-name-static\">\n      Download\/Rename the Sign In sheets\n    <\/div>\n<\/li>\n<li class=\"item\">\n<div class=\"step-number-container\">\n<div class=\"step-number\">\n       4\n     <\/div>\n<\/p><\/div>\n<div class=\"step-checkbox-container\">\n<div class=\"step-checkbox\"><\/div>\n<\/p><\/div>\n<div class=\"item-name-static\">\n      Create\/Save the Upload Results* (see step 7 below)\n    <\/div>\n<\/li>\n<\/ul><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/pU95W6jTMmalYFAG-DNMFw.png\" alt=\"Add Attachments\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/pU95W6jTMmalYFAG-DNMFw.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>*7. Go back to the already filtered <strong>View PD Data workbook<\/strong>, and<\/p>\n<ol>\n<li>open a new workbook<\/li>\n<li>copy the table from the View PD Data workbook<\/li>\n<li>paste data into new workbook<\/li>\n<li>save as 'SCECH # Upload Results' into the temp folder<\/li>\n<\/ol><\/div>\n<div class=\"text-content\">\n<p>8. Select 'Add attachments' from the SharePoint List pane; select all the attachments, click Open<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/jyy2bJq1GynPZON0UN1CHQ.png\" alt=\"Add Attachments\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/jyy2bJq1GynPZON0UN1CHQ.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>9. Finally, check off the SCECH program in the <strong>Master 16\/17 SY SCECH Excel sheet <\/strong>and delete the files in the temp folder<\/p>\n<\/p><\/div>\n<\/section>\n","protected":false},"excerpt":{"rendered":"<p>Before you begin... Create temp folder on desktop (to be used for&nbsp;temporarily downloading\/storing files) Open: MOECS SharePoint LIst (new) SharePoint Document Library (old) View PD Data Workbook Master 16\/17 SY SCECH Excel sheet Look up and enter data into SharePoint List 1. Copy the Program Approval # from the next available row in the Master [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":9294,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"ep_exclude_from_search":false,"cover_icon_emoji":"","cover_icon_url":"","tasks_count":"3","template_description":"","template_id":"oL0JQouVO91xan07xhJLaA","task_0":"Before you begin...","task_slug_0":"before-you-begin","task_1":"Look up and enter data into SharePoint List","task_slug_1":"look-up-and-enter-data-into-sharepoint-list","task_2":"Add Attachments","task_slug_2":"add-attachments","task_3":"","task_slug_3":"","task_4":"","task_slug_4":"","task_5":"","task_slug_5":"","task_6":"","task_slug_6":"","task_7":"","task_slug_7":"","task_8":"","task_slug_8":"","task_9":"","task_slug_9":"","task_10":"","task_slug_10":"","task_11":"","task_slug_11":"","task_12":"","task_slug_12":"","task_13":"","task_slug_13":"","task_14":"","task_slug_14":"","task_15":"","task_slug_15":"","task_16":"","task_slug_16":"","task_17":"","task_slug_17":"","task_18":"","task_slug_18":"","task_19":"","task_slug_19":"","task_20":"","task_slug_20":"","task_21":"","task_slug_21":"","task_22":"","task_slug_22":"","task_23":"","task_slug_23":"","task_24":"","task_slug_24":"","task_25":"","task_slug_25":"","task_26":"","task_slug_26":"","task_27":"","task_slug_27":"","task_28":"","task_slug_28":"","task_29":"","task_slug_29":"","task_30":"","task_slug_30":"","task_31":"","task_slug_31":"","task_32":"","task_slug_32":"","task_33":"","task_slug_33":"","task_34":"","task_slug_34":"","task_35":"","task_slug_35":"","task_36":"","task_slug_36":"","task_37":"","task_slug_37":"","task_38":"","task_slug_38":"","task_39":"","task_slug_39":"","task_40":"","task_slug_40":"","task_41":"","task_slug_41":"","task_42":"","task_slug_42":"","task_43":"","task_slug_43":"","task_44":"","task_slug_44":"","task_45":"","task_slug_45":"","task_46":"","task_slug_46":"","task_47":"","task_slug_47":"","task_48":"","task_slug_48":"","task_49":"","task_slug_49":"","task_50":"","task_slug_50":"","task_51":"","task_slug_51":"","task_52":"","task_slug_52":"","task_53":"","task_slug_53":"","task_54":"","task_slug_54":"","task_55":"","task_slug_55":"","task_56":"","task_slug_56":"","task_57":"","task_slug_57":"","task_58":"","task_slug_58":"","task_59":"","task_slug_59":"","task_60":"","task_slug_60":"","task_61":"","task_slug_61":"","task_62":"","task_slug_62":"","task_63":"","task_slug_63":"","task_64":"","task_slug_64":"","task_65":"","task_slug_65":"","task_66":"","task_slug_66":"","task_67":"","task_slug_67":"","task_68":"","task_slug_68":"","task_69":"","task_slug_69":"","task_70":"","task_slug_70":"","task_71":"","task_slug_71":"","task_72":"","task_slug_72":"","task_73":"","task_slug_73":"","task_74":"","task_slug_74":"","task_75":"","task_slug_75":"","task_76":"","task_slug_76":"","task_77":"","task_slug_77":"","task_78":"","task_slug_78":"","task_79":"","task_slug_79":"","task_80":"","task_slug_80":"","task_81":"","task_slug_81":"","task_82":"","task_slug_82":"","task_83":"","task_slug_83":"","task_84":"","task_slug_84":"","task_85":"","task_slug_85":"","task_86":"","task_slug_86":"","task_87":"","task_slug_87":"","task_88":"","task_slug_88":"","task_89":"","task_slug_89":"","task_90":"","task_slug_90":"","task_91":"","task_slug_91":"","task_92":"","task_slug_92":"","task_93":"","task_slug_93":"","task_94":"","task_slug_94":"","task_95":"","task_slug_95":"","task_96":"","task_slug_96":"","task_97":"","task_slug_97":"","task_98":"","task_slug_98":"","task_99":"","task_slug_99":"","footnotes":""},"categories":[7,1],"tags":[],"class_list":["post-9293","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-miscellaneous","category-uncategorized"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/9293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/comments?post=9293"}],"version-history":[{"count":0,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/9293\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/media\/9294"}],"wp:attachment":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/media?parent=9293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/categories?post=9293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/tags?post=9293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}