Anyone familiar on how I can mass import Courses, Students,Parents & Grades.
I have over 100 students, alot of courses and 3 years of grade history I need to get into this fresh install.
I've done various searches but there doesn't seem to be this question out there on how to import. Alternatively understanding the DB structure might help for directly inserting to relevant tables.
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm working on this to. I'm starting with about 1000 students. I've uploaded them to the "Students" table but that isn't enough to get them to show up in the system. If I work out anything I'll keep you updated.
Mike
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I managed to figure it out. It's really helpful if you get access to to the SQL server to see the table structures using a database management application. The hard part is knowing which tables are dependent to get openSIS working properly.
Last edit: Michael Gross 2018-04-04
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
For our school, I developed an online registration process for the parents that ties into opensis. Data comparisions can be made and then "pushed" to opensis, lunch and library systems for full integration without data corruption from human entry. But to "mass" add students in bulk (assuming your familiar with mysql), you'll need to INSERT INTO the following tables: students, student_enrollment, medical_info and login_authentication with the necessary minimal information to get basic student information in. These tables are required in order to create a "functional" student record. I do have some php scripts that will bulk entry depending on what additional information using custom student fields your needs require. It wouldn't be hard to create an upload CSV php code to write the generic information into Opensis. The screen shots below show both a full data review process and a "differential" review process. It compares the currently saved opensis data against the uploaded data either from registration or from batch entry before database committal. It also saves an image of the database before modification.
I have developed a script that mass imports students via a current csv file into the sql database. It fills out the information necessary for the tables students, student_enrollment and medical_info. The students show up on the openSIS system, however once you click on them the table in which you would normally see UI manual imported students does not show up. Does anyone have any insight as to this? Maybe i am missing a table or information that is required.
I do import via a access databse and I also include the tbl login_authentication. I also import addresses and contacts but I'm not sure if they are necessary.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks for the reply chris. Once you import the information and open a student on openSIS do you see the proper table (info.png)? If so, i may be missing the login_authentication.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anyone familiar on how I can mass import Courses, Students,Parents & Grades.
I have over 100 students, alot of courses and 3 years of grade history I need to get into this fresh install.
I've done various searches but there doesn't seem to be this question out there on how to import. Alternatively understanding the DB structure might help for directly inserting to relevant tables.
Thanks
I, too, am hoping for an import option.
I'm working on this to. I'm starting with about 1000 students. I've uploaded them to the "Students" table but that isn't enough to get them to show up in the system. If I work out anything I'll keep you updated.
Mike
I managed to figure it out. It's really helpful if you get access to to the SQL server to see the table structures using a database management application. The hard part is knowing which tables are dependent to get openSIS working properly.
Last edit: Michael Gross 2018-04-04
For our school, I developed an online registration process for the parents that ties into opensis. Data comparisions can be made and then "pushed" to opensis, lunch and library systems for full integration without data corruption from human entry. But to "mass" add students in bulk (assuming your familiar with mysql), you'll need to INSERT INTO the following tables: students, student_enrollment, medical_info and login_authentication with the necessary minimal information to get basic student information in. These tables are required in order to create a "functional" student record. I do have some php scripts that will bulk entry depending on what additional information using custom student fields your needs require. It wouldn't be hard to create an upload CSV php code to write the generic information into Opensis. The screen shots below show both a full data review process and a "differential" review process. It compares the currently saved opensis data against the uploaded data either from registration or from batch entry before database committal. It also saves an image of the database before modification.
Last edit: Nathan Shaffer 2018-04-17
Hi Nathan,
Can you share the php scripts?
Hello,
I have developed a script that mass imports students via a current csv file into the sql database. It fills out the information necessary for the tables students, student_enrollment and medical_info. The students show up on the openSIS system, however once you click on them the table in which you would normally see UI manual imported students does not show up. Does anyone have any insight as to this? Maybe i am missing a table or information that is required.
Last edit: Roy Xia 2018-06-20
I do import via a access databse and I also include the tbl login_authentication. I also import addresses and contacts but I'm not sure if they are necessary.
Thanks for the reply chris. Once you import the information and open a student on openSIS do you see the proper table (info.png)? If so, i may be missing the login_authentication.
Yes, I believe the login_authentication is what you are missing.
Worked like a charm buddy. Thanks for the help, appreciate it.
Happy to help!
Hi Roy
Are you willing to share your script "I have developed a script that mass imports students via a current csv file into the sql database."
Hello Chris / Roy,
Would it be possible for you to please share your mdb files for us new ones?
This is very specific to our database we currently import from but here it is.
Thats very nice of you, thank you. I think with a community so active this is going to be a breeze.