Import sample files

Administration
1

Hi Ross,

I’m currently trying to migrate user data into Gibbon v12 stable, which I find rather difficult.

I get the following message:
“User with username 1025 had some information malformations”

It’s the first entry in the csv file.

I think, I’m having a problem with the structure. The error message is rather vague. It would help me, if I had working import sample files for all available imports, e.g. users, families, etc.

Kind regards,
Roman

2

Roman,

Yes, more useful error messages and sample files would be ideal : ) Sadly, we have yet to find the time/resources to put these into place.

For user import you can find a sample file, and detailed instructions, at https://gibbonedu.org/support/administrators/importing-users-into-gibbon/.

In the meantime, if you cannot find the cause of the problem, email the file to support@gibbonedu.org and we will look at it for you.

Thanks,

Ross

3

Hi Ross,

Thanks for the instructions!

Finally I was able to successfully import the data. It turned out to be a missing entry in role.

Do you use the import tool on a regular basis in your school?

Kind regards,
Roman

4

Hi Ross,

A few more questions…

In which table are the imported users stored? Does it depend on the user role?

Is there a way to import customized fields, e.g. the student middle name?

I don’t use “Preferred Name” and “Official Name”. Is there a way to make them non required?

Kind regards,
Roman

5

Roman,

I’ll answer these here this time, but in future, please start a new thread for every question. It helps to keep the forum organised and more useful for others.

Users are stored in gibbonPerson, whatever their role. If they are students, they then get an additional record in gibbonStudentEnrolment. If they are staff, they get an extra record in gibbonStaff.

At current there is no way to import custom fields.

You may not use Preferred Name and Official Name, but the system does: pretty much every time a name is output to the screen, it is preferredName that you see. Official Name is used for reporting and other official business, where the name needs to be just so. From our experience with many systems, it would be bad to run a school system without these fields.

Ross

6

This info is very helpful! Thank!