Importing Student Data
If you have the data in a certain format and can send a CSV or XLS formatted file , RunPTO will import the Student data in the database for you at no charge.
We prefer the following format in a CSV file
Student Data File
The csv file should be in the following format.
The first row should be header and should have the columns described as below:
Column 1: Name
Column 2: Parent 1 Name
Column 3: Parent 2 Name
Column 4: Grade
Column 5: Teacher
Column 6: Address 1
Column 7: Address 2
Column 8: Email 1
Column 9: Email 2
Column 10: Phone 1
Column 11: Phone 2
The subsequent rows will have values:
Example below
Column 1: John Brayden
Column 2: Jim Brayden
Column 3: Jill Brayden
Column 4: 1
Column 5: Olivia Smith
Column 6: 6509 Elf Dr,Harrisburg, PA 17112
Column 7:
Column 8: jim@yahoo.com
Column 9: jill@yahoo.com
Column 10: 7176870869
Column 11: 7891234567
Address should be separated by commas.(Street Address,City,State,PA 17112)
Teacher Name should be first name & last name of the teacher separated by a space.
Teachers should be already existing in RunPTO prior to loading students.
Teacher Data File
The csv file which has the records should be in the following format:
The first row should be header and should have the columns described as below:
Column 1: Name
Column 2: Title
Column 3: Grade
Column 4: Position
Column 5: Email
Column 6: Phone
Column 7: Website
Column 8: Budget Amount
The subsequent rows will have values:
Example below
Column 1: Olivia Smith
Column 2: Mrs
Column 3: 1
Column 4: Teacher
Column 5: olivia@demoschool.com
Column 6: 7176785678
Column 7: www.example.com
Column 7: 500
A budget record will be created if budget amount is greater than 0.