Opensis on a hosting service. Importing student data!

I have found an easy way to install OpenSIS through Softaculous. But unfortunately I can't find any easy way to import my student data. But I think it can be done through PHPMyadmin. I will share about my attempts and hopefully success here to make it easier for you.

Open PhpMyadmin through your hosts CPanel

I opened the database/students view the structure, looks like this:

Here is how to export the database as a csv file:

When I exported and opened it in excel it looks like this:

Notice there are no headings.

So, now if I want, I can use this excel file to transfer existing student info and then import back in. I'll first gve it a try by just altering the 1 students info. It may add a new student or update? I will not change the ID number (1) so I can see.

I think we can backup the original data be renaming the file students_temp, and then import the new file with the same original name "students"

We do the import under the tab Operations - 

That's all for now, bed time. I will confirm this way and get back with an updated post, bye!

----------------------------------------------------------------------------------------------------------------------

I can confirm that this works. I now have setup a larger file and I will confirm again that the import works.

So. yes I was successful, however, before importing, I deleted old sample students, and I see some info, like the login name remained, probably from another page of the database, and I only see the first 10, which was the number of students in the sample data. I'll have to figure out why.