Export student / parent data

This site is best viewed in a modern browser with JavaScript enabled.

hanspumpel

Is there a possibility to export student AND associated parent data into one file? We'd like to use the data we curate in Rosario to import into our financial management software. Because we bill students and charge their parents, we need both sets of data in one record.

hanspumpel

Or, if there isn't, how are the user Ids calculate from one year to the next? The table "staff" contains the original user Ids, while the table "students_join_users" contains the current ones. How can I match those user ids in order to generate a list which shows students AND parent data in one set?

hanspumpel

So I've found the rollover ID column in the Staff table, but strangely enough, neither Adminer nor the export function in Webmin will export the first 200 or so values from this column. I see them fine in the table view, but when I export this table, I loose values along the way.

francoisjacquet

Hello hanspumpel

hanspumpel I've found the rollover ID column in the Staff table

The ROLLOVER_ID column is useful if you want to retrieve past year's user IDs.

Users are rolled. So if a user had an account in the past school year, after Rollover, he will have a new entry in the staff table.

To get users for the current school year, you must also query the SYEAR column.

About the students_join_users table:

user IDs in this table will match the ones in the staff table for the current school year.
user IDs are updated during Rollover, after rolling users.

hanspumpel

Thank you again. After realizing that, users don't have a rollover ID when they are added after rollover, and figuring out which ones were not rolled over from last year in the first place, Everything made sense, after finding out that rolled over users get a new record.
I still wonder if there is a possibility, to run an export of both parents AND associated students from within Rosario.
That way, the school's administration could do it, without keeping me from my sleep. It would be the reverse of the students and parents import premium, I guess.

francoisjacquet

hanspumpel I still wonder if there is a possibility, to run an export of both parents AND associated students from within Rosario

I guess not.

A custom module including this type of report can be developed.

If you want a quotation for such a development, please contact me at https://www.rosariosis.org/services/ and send your exact requirements or an example.