How to Move Files/Data from Doc Library to SP List

1. Create temp folder on desktop (to be used for temporarily downloading/storing files)
2. Open:
   1. MOECS
   2. SharePoint LIst (new)
   3. SharePoint Document Library (old)
   4. View PD Data Workbook
   5. Master 16/17 SY SCECH Excel sheet

1. Copy the Program Approval # from the next available row in the Master SCECH 16/17 Excel sheet

2. Find the corresponding SCECH program in the SharePoint List (see screenshot below)

- Optionally search by Program Approval #
- Select the row
- Click on the "i" button to bring up the properties pane

3. Find the corresponding SCECH in MOECS (see screenshot below)

- Go to Professional Learning Programs tab
- Paste Program Number
- Click on Program Number
- Verify/Edit details from MOECS into SharePoint

4. In the SharePoint list properties pane,

* To verify Schools in Attendance, filter the View PD Data Workbook by the Program Approval #, then sort by school; Select each corresponding school from the dropdown in SharePoint.

5. Find the Program file in the SharePoint Document Library (old) by either navigating the folder structure or searching by Program Title

(Note: to preview a file, select its row and click the "i" button on the top right)

6. Download and rename the files into the temp desktop folder:

*7. Go back to the already filtered View PD Data workbook, and

1. open a new workbook
2. copy the table from the View PD Data workbook
3. paste data into new workbook
4. save as 'SCECH # Upload Results' into the temp folder

8. Select 'Add attachments' from the SharePoint List pane; select all the attachments, click Open

9. Finally, check off the SCECH program in the Master 16/17 SY SCECH Excel sheet and delete the files in the temp folder