Prepare DyKnow SIS Data Import Files

Follow

INTRODUCTION

To update school data in bulk DyKnow Administrators must prepare DyKnow SIS Data Import Files by inserting data from SIS exports into DyKnow import templates and verify that the data meets DyKnow import requirements. 

This document is a resource for DyKnow Administrators to understand:

Prerequisite: Importing data into DyKnow requires a DyKnow FTP folder connection. To setup your DyKnow FTP folder connection, read the Setup your DyKnow FTP Folder Connection article.

 

IMPORT GROUPS

Data files are imported into DyKnow via an Import Group. There are two Import Groups a DyKnow Administrator can use to successfully import SIS data files into DyKnow.

The chart below identifies both Import Groups and the names of the SIS Data Import Files that each group requires for data to successfully load into DyKnow.

File Name

Import Group 1

Import Group 2

Schools

X

X

Users

X

X

Schedule

X

 

Classes

 

X

Enrollments

 

X

To determine which Import Group you should prepare, review your school’s SIS exports/reports to identify those that correspond to the DyKnow data file requirements defined in Import File Data Requirements & Templates section. For example, if you choose to import your Schedule, you must also import files for School and Users, but you cannot import files for Classes and Enrollments. 

 

DYKNOW SIS DATA IMPORT FILE REQUIREMENTS & TEMPLATES

There are five types of .CSV import templates a DyKnow Administrator can use to manually import SIS data into DyKnow. Use the chart below to identify the file name and description for each DyKnow SIS Data Import file and download import templates and data requirements for each.

File Name

Description

Template

Requirements

Schools

Identifies the names of schools at a district.

Click here

Click here

Users

Identifies each unique user and assigns them a DyKnow role.

Click here

Click here

Schedule

Assigns teachers and students to their classes.

Click here

Click here

Classes

Creates classes and assigns them each a teacher.

Click here

Click here

Enrollments

Assigns students to their classes.

Click here

Click here

 

HOW TO CREATE SIS DATA IMPORT FILES

Follow the steps below to properly format your SIS data exports into DyKnow SIS Data Import files that can be uploaded to your DyKnow FTP folder.

1. To determine your DyKnow SIS Data File Import Group, login to your SIS as an Administrator and locate the Reports or the Data Export tab/section in your SIS.

2. Review your school’s SIS export options and identify those that best correspond to the DyKnow SIS Data Import File Names, Descriptions, and Group outlined in the chart above.

3. From your SIS, export the set of data that matches the first DyKnow SIS Data Import File Name for your selected Import Group.

4. Download the first DyKnow SIS Data Import File Template of your selected Import Group by clicking “Click Here” in the corresponding cell of the Template column above (see chart: DyKnow SIS Data Import File Requirements & Templates). A .CSV spreadsheet will begin downloading immediately.

5. Move the SIS data that you just exported into the appropriate columns in the downloaded DyKnow SIS Data Import File Template.

Note: Do not edit the column headers or the order of the columns, that appear in the downloaded DyKnow SIS Data Import File Templates.

6. Verify that the exported SIS data is properly formatted in the DyKnow SIS Data Import File Template using the DyKnow SIS Data Import File Requirements document as a reference. Review the downloaded import file template’s Requirements by clicking “Click Here” in the corresponding cell of the Requirements column above (see chart: DyKnow SIS Data Import File Data Requirements & Templates). A pdf document will begin downloading immediately.

7. Save your newly populated DyKnow SIS Data Import File to a location on your computer or network that is easily accessible; the name of the new DyKnow SIS Data Import File should correspond to the DyKnow SIS Data Import File Name/Template identified above (see chart: DyKnow SIS Data Import File Data Requirements & Templates), then close the document.

8. Repeat steps 1 thru 7 until all DyKnow SIS Data Import Files have been completed for your Import Group.

 

Next step? Upload DyKnow SIS Data Import Files to FTP Folder

 

 

Have more questions? Submit a request

Comments