Requirements for Preparing Files for Single-School File Import

Before you begin importing using the Renaissance Single-School File import, we strongly recommend that you examine the files to make sure the data is formatted properly and that there are no errors which could cause problems during the import. This topic outlines the features a file needs to have in order to be a valid Single-School import file. Note: Only .csv file types can be imported.

Not every type of data needs to be present in a record being imported, but for each category, certain information is required; that information is in bold in the lists below.

Student Data:

  • Student ID
  • Student State ID
  • Student First Name
  • Student Middle Name
  • Student Last Name
  • Student Grade
  • Student Gender
  • Student Birthdate
  • Student Ethnicity
  • Student Language
  • Student Characteristics
  • Student User Name
  • Student Password

Personnel Data:

  • Teacher ID
  • Teacher State ID
  • Teacher First Name
  • Teacher Middle Name
  • Teacher Last Name
  • Teacher Gender
  • Teacher Position
  • Teacher User Name
  • Teacher Password

Class Data

  • Course ID
  • Course Name
  • Class ID
  • Class Name or Section Number
  • Class Subject

Delimiters

Data in Excel files is arranged in a grid, with one record per row and each row broken up into several columns. Each cell has a single piece of information in it, and all these pieces together compose a record. (Only .csv is accepted for the import, so be careful to save your file as .csv before importing.)

In comma-separated values (.csv) files, there are rows for the data, but no columns. In order to separate the pieces of information in a row from one another, you need to have a delimiter after each piece, either a tab or a comma. The presence of a delimiter means "this is the end of this piece of data; another piece follows." Multiple delimiters are equivalent to empty cells; for example, if you are using a comma as a delimiter, Adams,,,11/3/01 would be the equivalent of having an Excel file with two empty cells between the last name and date. Whichever delimiter you use in a file, it is advisable to use the same delimiter throughout the entire file.

Headers

The first row in your data file should be a header row. This row does not have any student, personnel, or class data in it; instead, it has codes that identify the data in each column.

Data Codes for Student Data:

  • Student ID: SID
  • Student State ID: SSTATEID
  • Student First Name: SFIRST
  • Student Middle Name: SMIDDLE
  • Student Last Name: SLAST
  • Student Grade: SGRADE
  • Student Gender: SGENDER
  • Student Birthdate: SBIRTHDAY
  • Student Ethnicity: SRACE
  • Student Language: SLANGUAGE
  • Student Characteristics: SCHARACTERISTICS
  • Student User Name: SUSERNAME
  • Student Password: SPASSWORD

Data Codes for Personnel Data

  • Personnel ID: TID
  • Personnel State ID: TSTATEID
  • Personnel First Name: TFIRST
  • Personnel Middle Name: TMIDDLE
  • Personnel Last Name: TLAST
  • Personnel Gender: TGENDER
  • Personnel Position: TPOSITION
  • Personnel User Name: TUSERNAME
  • Personnel Password: TPASSWORD

Data Codes for Class Data:

  • Course ID: COURSEID
  • Course Name: COURSE
  • Class ID: CLASSID
  • Class Name or Section Number: CLASS
  • Class Subject: SUBJECT

If you are using Excel, each header item should be in its own cell at the top of the appropriate columns. (Only .csv is accepted for the import, so be careful to save your file as .csv before importing.) In .csv files, add the delimiters you are using between the header items.

If the records you are importing do not have a certain type of data, you do not need to include a header item/column for that type of data. For example, if you had records that only contained students' first names, last names, user names, and grades, the header would only include SFIRST, SLAST, SUSERNAME, and SGRADE.

Data Specifications

Each of the 27 types of data has its own rules for format, maximum characters allowed, abbreviations used, and so on. Select one of the categories below to see the requirements for that data. Note: To avoid duplicate student records, it is a good idea to have student records include birthdays or IDs.

Student Data Specifications:

  • Maximum length: 20
    Format: character or numeric
    Required if student data present? No, but recommended
    If this is not in the file, the user name is used.

  • Maximum length: 50
    Format: character or numeric
    Required if student data present? No

  • Maximum length: 35
    Format: characters
    Required if student data present? Yes

  • Maximum length: 35
    Format: characters
    Required if student data present? No

  • Maximum length: 35
    Format: characters
    Required if student data present? Yes

  • Maximum length: 5
    Format: character or numeric
    Required if student data present? No*

    *Grades are not required when you import student information, but grades are required before students can take Star tests and when you add or edit student information.

    Grade codes accepted:

    • Pre-K (Pre-Kindergarten)
    • K (Kindergarten)
    • 1 (Grade 1)
    • 2 (Grade 2)
    • 3 (Grade 3)
    • 4 (Grade 4)
    • 5 (Grade 5)
    • 6 (Grade 6)
    • 7 (Grade 7)
    • 8 (Grade 8)
    • 9 (Grade 9)
    • 10 (Grade 10)
    • 11 (Grade 11)
    • 12 (Grade 12)
    • 12+ (Greater than 12)
    • Other (Other)
  • Maximum length: 1
    Format: character
    Required if student data present? No

    Gender codes accepted:

    • M (Male)
    • F (Female)
    • U (Unassigned; this is also the default if no code is specified for a student)
  • Maximum length: 10
    Format: mm/dd/yyyy
    Required if student data is present? No

  • Maximum length: 1
    Format: character
    Required if student data present? No

    Ethnicity codes accepted:

    • I (for American Indian or Alaskan Native)
    • A (for Asian)
    • B (for Black)
    • H (for Hispanic)
    • M (for Mixed)
    • P (for Hawaiian or Pacific Islander)
    • C (for White)

    If no code is entered, "None Specified" will be selected for ethnicity.

  • Maximum length: 3
    Format: character
    Required if student data present? No

    Language codes accepted:

    • ARA (Arabic)
    • CAN (Chinese: Cantonese)
    • MND (Chinese: Mandarin)
    • CHI (Chinese: Unspecified)
    • ENG (English)
    • FRE (French)
    • GER (German)
    • GUJ (Gujarati)
    • CRP (Haitian Creole)
    • HMG (Hmong)
    • JPN (Japanese)
    • CAM (Khmer)
    • KOR (Korean)
    • LAO (Lao)
    • MAY (Malay)
    • NAV (Navajo)
    • OTH (Other)
    • POL (Polish)
    • POR (Portuguese)
    • RUS (Russian)
    • SCC (Serbo-Croatian)
    • SOM (Somali)
    • SPA (Spanish)
    • TAG (Tagalog or Filipino)
    • URD (Urdu)
    • VIE (Vietnamese)
    • blank (None Specified)
  • Maximum length: 755
    Format: dash (-) separated character string
    Required if student data present? No

    Characteristic codes accepted:

    • ADA (for Americans with Disabilities)
    • AR (for At-Risk Students)
    • BIL (for Bilingual Education)

    • DL (for Dyslexic)
    • ESL (English as a Second Language)
    • FL (for Free Lunch)
    • GT (for Gifted/Talented)
    • LD (for Learning Disabled)
    • LEP (for Limited English Proficiency)
    • MG (for Migrant)
    • NA (for Non-Resident Alien)
    • PD (for Physically Disabled)
    • RL (for Reduced-Price Lunch Program)
    • SE (for Special Education)
    • T1 (for Title 1)
  • Maximum length: 50
    Format: character or numeric
    Required if student data present? No, but recommended
    Notes: If this is not in the file, a user name is automatically generated using the student’s first initial and the first four letters of the last name (e.g., jsmit for Jane Smith). If that user name is already used, a number is added (e.g. jsmit2 for John Smithers). Student user name cannot be exactly the same as the student password.

  • Maximum length: 20
    Format: case sensitive character or numeric
    Required if student data present? No, but recommended
    Notes: If passwords are not in the file, all students will be given the same default password: abc. Renaissance student password requirements: 2-character minimum, uppercase, lowercase, number, special character (!#$%-_=+<>*). Student password cannot be exactly the same as the student user name.

Personnel Data Specifications

  • Maximum length: 20
    Format: character or numeric
    Required if personnel data present? No
    Note: If this is not in the file, the person’s user name is used for the ID.

  • Maximum length: 50
    Format: character or numeric
    Required if personnel data present? No

  • Maximum length: 35
    Format: characters
    Required if personnel data present? Yes

  • Maximum length: 35
    Format: characters
    Required if personnel data present? No

  • Maximum length: 35
    Format: characters
    Required if personnel data present? Yes

  • Maximum length: 1
    Format: character
    Required if personnel data present? No

    Gender codes accepted:

    • M (for Male)
    • F (for Female)
    • U (for Unassigned; this is also the default if no code is specified for a personnel member)
  • Maximum length: 1
    Format: character
    Required if personnel data present? No

    Position codes accepted:

    • T (Teacher)
    • P (School Level Administrator, such as Principal)
    • S (School Staff)
  • Maximum length: 50
    Format: character or numeric
    Required if personnel data present? No
    Notes: If this is not in the file, a user name is automatically generated using the person’s first initial and entire last name (e.g., rjones for Robert Jones). If that user name is already used, a number is added (e.g. rjones2 for Rita Jones). Personnel user name cannot be exactly the same as the personnel password.

  • Maximum length: 20
    Format: case sensitive character or numeric
    Required if personnel data present? No

    Notes: By default, Renaissance requires at least one number in staff passwords. If passwords are not in the file, personnel members use their user name as the password when they log in to Renaissance software.

Class Data Specifications

  • Maximum length: 265
    Format: character or numeric
    Required if class data present? No

  • Maximum length: 100
    Format: character or numeric
    Required if class data present? Yes

  • Maximum length: 265
    Format: character or numeric
    Required if class data present? No

  • Maximum length: 50
    Format: character or numeric
    Required if class data present? No

  • Maximum length: 11
    Format: character
    Required if class/course data present? No

    Subject codes accepted for courses:

    • ARTS (Arts)
    • ENG (English)
    • HEALTH (Health)
    • RE/LA  (Language Arts)
    • MATH (Mathematics)
    • OTHER (Other)
    • RDG (Reading)
    • SCI (Science)
    • SE (Special Education)
    • SOC (Social Studies)
    • WR (Writing)

Additional Preparation Instructions

For Your Files

  • Every row of data in the file must be a single record.
  • There can only be one header row for a set of records, and every item in the header row must be unique. If you have accidentally included more than one header row, the first one in the file will be chosen as the header. If that is not the correct row, you can select the correct row during the import.
  • If the files have columns of data that can't be imported because it isn't from one of the 27 types allowed, you can either remove that data from the files or use a "fake" header item for that data (such as XYZ or DoNotImport) and instruct the program to ignore that column during the import.
  • It is possible to combine different types of data (student, personnel, or class) into one record. You can't do this with the same types of data; for example, a record could have a student and class in it, but not a student and another student. (Note that adding class data to student and/or personnel data will affect the options you can choose during the import process.)
  • Example of a record with student data and class data (header and one record):

    SLAST,SFIRST,COURSE,CLASS
    Roberts,Timothy,English,Creative Writing

    This would be interpreted as a student record for Timothy Roberts, who is enrolled in Creative Writing, a class in the English course.

    Example of a record with personnel and class data (header and one record):

    TLAST,TFIRST,COURSE,CLASS
    Andrews,Sally,English,Creative Writing

    This would be interpreted as a personnel record for Sally Andrews, who is assigned as a teacher to the Creative Writing class in the English course.

    Example of a record with student data, personnel data, and class data (header and one record):

    SLAST,SFIRST,TLAST,TFIRST,COURSE,CLASS
    Roberts,Timothy,Andrews,Sally,English,Creative Writing

    This would be interpreted as a student record for Timothy Roberts, who is enrolled in Creative Writing, a class in the English course with Sally Andrews as the assigned class teacher. This is the best type of file because it allows you to import students and personnel, enroll students into classes, and assign personnel to classes all at once.

    Example of a record with student data and personnel data (header and one record)

    SLAST,SFIRST,TLAST,TFIRST
    Roberts,Timothy,Andrews,Sally

    This would import a student record for Timothy Roberts and a personnel record for Sally Andrews. The result would be the same as importing two separate records, one for the student and one for the personnel member, since there is no class data associated with either record that would join the two in any way.

  • Every row must have the same number of items in it, in the same order as the header row. If some information is unavailable for a record, use placeholders (empty table cells, commas, or tabs depending on your file) to make the number of items in each row the same. One of the ways the software determines if a row of data should be imported is by counting the number of items in every row and seeing how many the majority of rows have. This is considered the "standard" number of items, and any record with more or fewer items will be ignored during the import.

For Renaissance

  • One of the first steps during an import is to select a school and a school year to import data into.

Which School Year? You can import into either the current school year or a future school year. If you choose a future school year, be very careful that the grades of the students in your import file will match the grades they will be in during the future school year.

Examples of File Preparation

.csv File (in Plain-Text Editor), Comma-Separated Values

The sample file below requires some corrections. In this example, each row has two types of data: a student and a personnel record. Since there is no class data included, two separate, unrelated records will be created in Renaissance for each row during this import: a student record and a personnel record.

Knight,Bethany,Lynn,F,January 10 2011,NNM15K,Hendricks,Shelley,Anne,TZP27N
Bass,Chancellor,Herbert,M,08/13/2011,HOT80F,Nolan.Julie,Johanna,JCZ10O
Sharp,Aretha,Christina,01/31/2010,GWJ54C,F,Justice,Wyatt,Kevin,MEU82T
Johns,Holly,Olivia,F,04/26/2012,MIR71A,Talley,Jason,Humbert,LJS85M
Ware,Kylie,Erasmus,M,03/09/2012,ZKT47K,Wiley,Kylan,Alan,
Osborn,Ila,Dierdre,F,06/10/2012,ZQV90O,,Warren,Hannah,Huntington,BLX83T

The file has the following problems:

  • The file doesn't have a header row.
  • In the first row (Bethany Knight), the student's birth date is formatted incorrectly.
  • In the second row (Chancellor Bass), a period is used instead of a comma to separate Nolan from Julie. This will prevent the program from seeing the names as separate, and when the items in each row are counted to determine the "standard" number, these two names will be counted as one, throwing off the item count for the row (9 instead of 10).
  • In the third row (Aretha Sharp), the gender is in a different place - after the ID instead of before the birth date as in the other rows.
  • In the last row (Ila Osborn), there is an extra comma after the first ID (ZQV90O). The program will count this as an "empty cell," which will make it count an extra field in this row (11 fields instead of 10). Since the program will find 10 fields in most rows, it will ignore any fields after 10 in rows that have more.

Watch out for extra delimiters at the end of rows. In the fifth record above (Kylie Ware), note that there is a comma at the end of the row. In this case, the comma is correct because the record has no value for the last ID (teacher ID), so the comma will be interpreted as an "empty cell" and included when the items in the row are counted. If the record had an ID, and the comma was included by accident, it would mean that this row had one too many fields.

Here is the corrected file:

SLAST,SFIRST,SMIDDLE,SGENDER,SBIRTHDAY,SID,TLAST,TFIRST,TMiddle,TID
Knight,Bethany,Lynn,F,01/10/2011,NNM15K,Hendricks,Shelley,Anne,TZP27N
Bass,Chancellor,Herbert,M,08/13/2011,HOT80F,Nolan,Julie,Johanna,JCZ10O
Sharp,Aretha,Christina,F,01/31/2010,GWJ54C,Justice,Wyatt,Kevin,MEU82T
Johns,Holly,Olivia,F,04/26/2012,MIR71A,Talley,Jason,Humbert,LJS85M
Ware,Kylie,Erasmus,M,03/09/2012,ZKT47K,Wiley,Kylan,Alan,
Osborn,Ila,Dierdre,F,06/10/2012,ZQV90O,Warren,Hannah,Huntington,BLX83T

.csv File in Microsoft® Excel®

The sample Excel file below also needs a few corrections. In this example, each row has three types of data (student, personnel, and course/class). This means that three separate records will be created from each row during the import - a student record, a personnel record, and a course/class record. Also, the student will be enrolled in the class, and personnel member will be assigned to the class. (Only .csv is accepted for the import, so be careful to save your file as .csv before importing.)

SFIRST SLAST SBIRTHDAY SGRADE SGENDER TFIRST TLAST TGENDER COURSE CLASS
Kyra Barrera 03/04/2011 1st F John Cantu M Reading Young Readers I
Colt M. Pollard 12/14/2010 2 M Hanae Steele F Math Add It Up!
Yvonne Sims 04/13/20011 1 M Dora Shepard F Reading Story Share
Kiayada Benson 09/07/2011 1 F Johnny Cantu M Reading Young Readers I
Martin Mann 10/13/2012 K M Dora Shepard F Reading "Story Time"
Nyssa Howard 05/09/2010 2 F Alvin Beasley M Math Productivity
Chad Estes 10/22/2010 2 M Brent McKay M Math
Divide and Conquer!

The file has the following problems:

  • In the header row, two of the fields are identical ("Gender" in columns 5 and 8).
  • Kyra Barrera's record should have a numerical grade (1) as in the other records, not "1st."
  • In the third row (Colt), a middle initial has been included with the first name; it should be removed to make this record like the others.
  • In the fourth row (Yvonne), the students' birthday (SBIRTHDAY) has an extra "0" in the year.
  • If the teacher "Johnny Cantu" in Kiayada's record is the same as "John Cantu" in Kyra's record, then either "John" or "Johnny" should be used in both records.
  • In the sixth row (Martin), the name of the class has quotes around it. All characters in a cell will be included in the import, so make sure there are no unintentional punctuation marks or word spaces.
  • In the seventh row (Nyssa), the teacher's first and last name are in a merged cell instead of separate cells.
  • In the last row (Chad), the class name has a return before it. This may cause a problem during import.

Here is the corrected file:

SFIRST SLAST SBIRTHDAY SGRADE SGENDER TFIRST TLAST TGENDER COURSE CLASS
Kyra Barrera 03/04/2011 1 F John Cantu M Reading Young Readers I
Colt Pollard 12/14/2010 2 M Hanae Steele F Math Add It Up!
Yvonne Sims 04/13/2011 1 M Dora Shepard F Reading Story Share
Kiayada Benson 09/07/2011 1 F John Cantu M Reading Young Readers I
Martin Mann 10/13/2012 K M Dora Shepard F Reading Story Time
Nyssa Howard 05/09/2010 2 F Alvin Beasley M Math Productivity
Chad Estes 10/22/2010 2 M Brent McKay M Math Divide and Conquer!