francoisjacquet / rosariosis

RosarioSIS Student Information System for school management.

RosarioSIS Student Information System

License

RosarioSIS is "free" software released under the GNU General Public License version 2.

Your contributions are welcome.

Installation

Minimum requirements: PHP 5.5.9 & PostgreSQL 8.4 or MySQL 5.6/MariaDB.

For installation directions, consult the INSTALL.md file.

Documentation

Documentation: Quick Setup Guide, User Manuals, Report samples, Tips, Wiki.

Demo

Try RosarioSIS: access the online demonstration.

Official site

rosariosis.org: English • Español • Français

Screenshots

About

RosarioSIS has been designed to address the most important needs of administrators, teachers, support staff, parents, students, and clerical personnel. However, it also adds many components not typically found in Student Information Systems. Consider the following:

• Student screens that include all the critical information necessary for reports and decision-making can be accessed with a point and click. Several customizable features are also included that allow you to gather data important to your school or district.

• Employee screens that not only provide quick access to demographic information, but also assign email addresses, admittance to the system, passwords, and more.

• Students can be searched by not only gender, ethnicity, grade level, etc., but also by their schedule, activities, absences, eligibility, grades, GPA, and class rank, where appropriate.

• A comprehensive grade book that allows teachers to establish grade ranges, weight assignments, track assignments, and issue quarterly and semester grades as well as progress reports. Report card and transcripts are also available. Furthermore, report cards and transcripts can be configured to display grades for any or all of your schools marking periods on the fly.

• Attendance can be taken electronically by teachers and submitted to the office almost instantly. Also, office staff can modify attendance reports based on information not available at the time roll was taken. The attendance component further provides report capabilities to identify average daily attendance, to provide daily attendance summaries, and to track attendance each day.

• Middle grade and high school educators will appreciate the eligibility feature of RosarioSIS. No longer will paper or spreadsheets have to be used to report what students are eligible for athletic or academic activities; instead, the grade book will determine electronically if a student is passing or not. The teacher then merely verifies the information and sends it through the system.

• Scheduler in RosarioSIS allows the scheduling of entire classes or groups as well as the scheduling of a single student. Revisions to a students schedule can be performed quickly. Scheduling based on a students requests is extremely efficient. Running the scheduler on an entire high school takes minutes instead of hours. So, the scheduler can be run several times a day allowing you to scheduler more thoroughly. Also, each time you save a students requests, the scheduler is run under test mode for the student allowing you to resolve conflicts as you have the student in front of you.

• Courses can be added easily to include weights, instructional assignments, and periods. As well, you can determine if each course requires attendance, affects the honor roll and class rank, and/or has any restrictions. Of course, scheduling reports can be generated through this application also.

• A calendar is included that details events, activities and student assignments.

• A school set-up screen is used to establish marking periods, the grade levels in the building, and the number of periods scheduled each day. School demographic information (e.g., name, address, phone numbers, etc.) is entered on this same screen. Your schools can have any number of marking periods in three tiers. For instance, a school could use the conventional two semesters, four quarters, four progress periods model, or a school could establish its only system of marking periods with 3 semesters, 18 quarters, and 36 progress periods. Everything is completely customizable.

• Keep track of student billing by easily assigning fees and their corresponding payments. As well, you can consult balances, daily transactions and print statements.

• A full set of additional modules and plugins to expand the possibilities of your school and staff in terms of communication, additional reports, data import and integrations with other solutions.

You will find RosarioSIS to be a full-featured Student Information System that facilitates your decision-making, provides data necessary for reports to the federal or state governments as well as local boards, and affords convenient access to all of the stakeholders in your building or district. And, because it is web-based, the system can be logged into from any Internet connection.

rosariosis's Issues

Dafault Data

Please can i get a sample data of this management system. to better understand its concept and use

Student Class requests

Is there a way where students can add there own class requests instead of having the admin doing it for them? It saves admins a lot of time if they do it this way.

Group Drop issue

Group Drop is not working,
it shows that x number of students dropped successfully but when checking the enrollment, none of the students are really got dropped from the course enrollment.

Unfilled requests report generates error

Failure Notice:
DB Execute Failed.
Additional Information: ERROR: column "None" does not exist LINE 1: ..._ID,ssm.SCHOOL_ID AS LIST_SCHOOL_ID,ssm.GRADE_ID ,"None" AS ... ^

printing schedule > table format

Hi,
I am getting empty pdf file when choose to print the schedule and check the table checkbox.
the list option works fine

RosarioSIS Suggestion/Idea

To make RosarioSIS a lot more secure, someone should make a Windows or Mac client for Rosario. A client for only administrators and have the web based version for parents, students and teachers. A lot of commercial SIS' like "Zangle" do this. I don't know if this is possible. But its a great idea.

HOW TO INSTALL ROSARIO SIS ON WINDOWS

http://pastebin.com/BF7ccXSt

Calendars issues

in a system(2.4) where multiple calenders are setup
navigate to calendars page
select Calendar-A from the dropdown
select another calendar say Calendar-B
Go back to Calendar-A
Calendar-A days cleared out !!!???

Students Advanced report

Adding status to the fields which supposed to show active or inactive result

Input Final Grades - Rosario

Goodmorning Francois,

I have a version of Rosario on paid Webhosting.
When I clicked Input Final Grade (as Teacher or Admin), I encountered the following error:

We have a problem, please contact technical support...

Date: 07/15/2014 09:38:26

Failure Notice: DB Execute Failed.

Additional Information: ERROR: function credit(integer, unknown) does not exist LINE 1: ...ITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit(2, ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

This issue has been posted before, but was apparently discontinued by the opener. On basis of your response I checked the page source, however I cannot find the Web developer --> Page Source ?

I have another version on WAMP server where this problem does not occur.

Thank you.

WKHTMLTOPDF didn't return any data

when i try to print a page i get this error WKHTMLTOPDF didn't return any data on ubuntu 14.04

Food Service Problem

I recently upgraded to 1.4. I just wanted to let you know that there is something up with the food service module. Its giving me a SQL error of:
Date: 11/11/2013 06:16:32
Failure Notice:
DB Execute Failed.
SQL Stmt: ERROR: duplicate key value violates unique constraint "food_service_transaction_items_pkey"

Thanks.

Delete student enrollment / not just drop

Hi,
is there a way to delete student enrollment in a specific course and all its related information .
the reason I am asking for this is: I want to show the course request as unfilled if the student dropped the course for any reason ( Not attending ).

Installation Problem

Hi Francois,
After 3 days of banging my head, I now need your assistance.
I am using WAPP 5.4.23, PostgreSQL 9.3.1 running on localhost:5432 with PHP Version 5.4.23. running on win 7 64
Imported the sql file successfully ( all tables/views etc have been created ) in a database named rosariosis and filled out config.inc accordingly but I have a blank page when i load the app in the browser. Page source is blank as well. I really dont know what is wrong.
Any help will be appreciated

RosarioSIS "Resources" Module

Just one more problem. We use the resources module to access school email. However, since we upgraded to 2.0.1, we can't get the Resources module to appear on the left bar. I checked the config.inc.php and that module is set to "true". I tried to import it from the 1.4 version and still no luck. Is this module not supported anymore or is it a problem with the new version?

Thank you!

Side Scrolloing is not working for RSIS 2.2

So ever since we upgraded to RosarioSIS 2.0, we had a problem were the scrolling from side to side does not work. So if I try to scroll to the right when there more information on the right (like it is on the image I provided), it won't scroll. I'm assuming this is a bug.

Thanks for reading

-Anthony C.

I am getting this warning on apache error log

PHP Warning: array_key_exists() expects parameter 2 to be array, null given in /home/xxxx/public_html/functions/Inputs.php on line 203, referer: http://domain.com/index.php

RosarioSIS 2.5.6
PHP Version 5.4.20 Apache/2.2.25

Error in school information page

Version 2.4
in the school information page ( at the bottom of the page ) I am getting the following error
Failure Notice:
DB Execute Failed.
Additional Information: ERROR: relation "school_fields" does not exist LINE 1: ...ECT ID,TITLE,TYPE,DEFAULT_SELECTION,REQUIRED FROM SCHOOL_FIE... ^

Module Idea, "Tyler Pulse" like tool

This request might sounds like a custom development idea but I think that this idea should be bundled with every RosarioSIS download in the next update. Anyways, there should be a tool which tells teacher about their student's missing assignments not only in their class, but in other classes as well. It would also tell you the students percentage, letter grade, and how many absents he or she has in that course. This tool would be similar to the "Anomalous Grades" link, but it would be a different type of tool with more information. The tool would be available to parents, students, administrators.etc or how ever a System Administrator configures it. This is sorta like the "Tyler Pulse" tool if you search it up on Google. Please let me know.

Adding Assignments Issue

I get the following error while adding assignments:

"Date: 05/10/2014 08:19:39
Failure Notice: DB Execute Failed.
Additional Information: ERROR: duplicate key value violates unique constraint "gradebook_assignments_pkey" "

We upgraded to 2.5.1 recently. Is this a unsolved bug?

Custom fields in the letters

Hello ,

is there a way to use custom fields in the 'Print Letter' ?

How to enroll a student in two schools at the same time

How can I enroll a student into two schools? We have a vocational school and a high school. We would like to have data from both schools into RosarioSIS. How can both schools have access to students?

Advanced report generates error on a specific fields selections

Hi,
in the students >advanced report
if I select any of the following fields
*enrollment start date
*enrollment end date
*enrollment code
*drop code
the following error occured
Failure Notice:
DB Execute Failed.
Additional Information: ERROR: more than one row returned by a subquery used as an expression

Version 2 bug and Question

I was testing out RosarioSIS version 2.0b3 and I found a bug when you open the "Students" application. The error says: "Error: ajaxLink get http://localhost/demo/Modules.php?modname=Students/Search.php". Plus you can't open anything within the "Students" application. Just trying to report a bug here so we can release even sooner. And by the way, when should v2 be released do you think?

blank index page after installation

Hi,

I have installed rosariosis on linux, apache, postgre on shared hosting.
Have verified the versions of the above, config.inc.php, php.ini etc. My service provider has also gone through the forum and found nothing amiss.

Require advice on the way around.

Tks,
Mcnd

Events in Calendar

Creating events in the Calendar Section is not working.

A way to Link school email on the Left Frame

Is there any way I can link my school's email system on the left frame of RosarioSIS? Like make it as a module or something? This would be very helpful for teachers and administrators.

Input Final Grade

When I clicked Input Final Grade as Teacher, I encountered the following error:

Failure Notice:

DB Execute Failed.

Additional Information: ERROR: function credit(integer, unknown) does not exist LINE 1: ...ITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit(2, ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

RosarioSIS Report Cards Problem

We have a way of grading our students at the end of the semester. We give them a exam grade ("E"), a academic grade("A") meaning the grade before the exam was put in, the overall transcript mark, and the citizenship mark ("C") witch is the grading scale for how the student behaves in the class. 4 being bad and 1 being good. The exam, academic, and citizenship marks are defined in the "Report Card Comments" and "Comment Codes" modules. My problem is the legend scatters all the comment codes every where making it confusing for the parent to read their child's report cards. Is there a way we can organize this? Thanks!

Suggestion : Print Receipt after receive payment

HI

Just want to request some features, can you please add some functions to print some kind of receipt after payment has been made?

Currently there are only option to print statements, but all transactions will be printed along,

It would be great if user can print some kind of receipt, containing only the current payment that has been made, so that the receipt copy can be given to parents / student

Thanks

Setting up State Reporting

I would like to know how I can set up the State Reporting module. I unzipped the actual module and loaded its SQL file. But when I open it, it gives me a blank screen on he right frame and nothing works. What do I need to do to get this working right?

Connection to database problem

I had a problem connecting to my postgresql database (which i named 'rosariosis') from the 'database.inc.php' file. In this file the function db_start() contains the following lines:

global $DatabaseServer,$DatabaseUsername,$DatabasePassword,$DatabaseName,$DatabasePort;

$connectstring = '';
if($DatabaseServer!='localhost')
    $connectstring = "host=$DatabaseServer ";
if($DatabasePort!='5432')
    $connectstring .= "port=$DatabasePort ";
$connectstring .= "dbname=$DatabaseName user=$DatabaseUsername";
if(!empty($DatabasePassword))
    $connectstring.=" password=$DatabasePassword";
$connection = pg_connect($connectstring);

Actually I didn't understand exactly waht the tests

if($DatabaseServer!='localhost')
$connectstring = "host=$DatabaseServer ";
if($DatabasePort!='5432')
$connectstring .= "port=$DatabasePort ";

are supposed to bring.

I just commented them and it worked.

In fact with those tests you can't connect to the database from your localhost or with the default port 5432.

Thanks a lot for your work in this project. Respects

PS: Excuse my english.

RosarioSIS cannot connect to the Postgres database

hi

i install php and postgresql using bitnami apps

i already configure the database and all, but when i try to launch the rosariosis, nothing happen

when i run the diagnostic, this error appeared

"Error: RosarioSIS cannot connect to the Postgres database. Either Postgres is not running, it was not started with the -i option, or connections from this host are not allowed in the pg_hba.conf file. Last Postgres Error:"

can i know in detail on how to start postgres database with the -i option using bitnami apps?

and if there is an easier method to install php and postgresql without using bitnami apps, may i know how?

integration with moodle not working

dear sir ,

thanks to help us in the issue below

i have add the token , and url in the rosariosis and i have setup the web service in moodle , i use the admin user for that integration but i cant see any update happen in rosariosis
how can i check if this working or troubleshooting this issue .

Br ,
husam.shabeeb

HackingLog

Hi Francois
I already installed RosarioSis in a Windows computer. After Login, when I press any options in the Menu I received the following message:
"You're not allowed to use this program! This attempted violation has been logged and your IP address was captured."
Can you please help me ?
Thanks
Oscar

Webpage is blank after installation, problem in $LocalePath?

Hi,

I am running Rosariosis on WAPP. I have been successful in importing rosariosis.sql file to my postgres database. However, the index.php page shows blank and so do other pages.

I have checked the error log in Apache Web server. It says:

[Sat Jan 25 22:42:22.881514 2014] [:error] [pid 6700:tid 1076] [client ::1:54449] PHP Fatal error: Call to undefined function bindtextdomain() in C:\BitNami\wappstack-5.4.24-0\apache2\htdocs\rosariosis\Warehouse.php on line 57

The line 57 in warehouse.php says
bindtextdomain('rosariosis', $LocalePath); //binds the messages domain to the locale folder

What might be the problem?

BR
Sharad

When Creating Subject

When creating Subject in the Course section, I always encounter:
Failure Notice:
DB Execute Failed.
Additional Information: ERROR: syntax error at or near ")" LINE 1: ...column", rosario_id, moodle_id) VALUES ('subject_id', '4', ) ^

Can't login to rosario

Hi everyone!

I have a fresh install of 2.2 on ubuntu 12, with posrgres 9.3 and PHP Version 5.3.10-1ubuntu3.10.

I have tried everything to login and can't seem to get anywhere. I do have it working on my dev system with MAMP but not on my production server.

I tried the hack below and that didn't help either.

any help would be great

https://github.com/francoisjacquet/rosariosis/wiki/PHP-version-inferior-to-5.3.2,-can%27t-login

Attendance

Attendance Section is not working but not encountering any error.

Note after parent and teacher creation

The commit made to show a note after teacher and parent creation is not filtered. It should be intended for admin users only but shows up for parent and teacher users as well: commit - 4840bd4

Message: even for parent and teacher user
Note: Please add the administrator's ID (6) to the config.inc.php file.

List Export Issue

Hi

on old rosario version when you click on the save icon the system was prompting to download the list as excel file.
now when I click on the icon the system displays the list in the body of the page

right click > save link as is still working

also I would recommend changing the downloaded file extension from xls to csv as the file real format is csv not xls

thanks

Translation

Hi I install Rosario sis 1.4.4 and everything is working OK. The problem is I can not configure the spanish translation. Could you twll mw how cai i use it?. Thanks.

Input Final Grades Issue with 2.0.1 Release

I have a issue that when my staff enter progress report grades or report cards grades into the system, they get the follow error:
"Date: 01/17/2014 08:24:33
Failure Notice: DB Execute Failed.
Additional Information: ERROR: invalid input syntax for type numeric: "" at character 378". I can input grades without a problem with 1.4.6. I'm guessing this is a new bug. Please reply ASAP with a fix!

Thank you!

RosarioSIS 2.0.1 Version.

Suggestion for a seating chart

It would be pretty cool to have a seating chart. It would help teachers alot when they get new students in their classroom so they can get to know their names. Not to mention, substitute taking attendance.

New User Profile

Not added on the dropdown menu when creating new user at the User Info Section

GPA Calculation Problem

So, when ever I try to calculate the GPA on a student, It calculates ok, but it won't give me the GPA whenever I go into "Edit Student Grades". Take a look for yourself.
How could this be fixed?

Move a student to another school

Quoting Lennon:
"When you move a student to another school he leaves the school field blank and the student is no school. In case I can not put it into a school after this maneuver"

Custom field for multi-row entries (table-like structure)

Hi,

I tried to find custom field which will enable presenting data consisting of multiple rows. Something like table with few columns (e.g. Id, Name, Title, Date) and more than one row.
I did not manage to customize available custom fields (multiple selection types, long type) to do so.
I think brand new custom field would be the best option. I am eager to help with the development of this feature. Could You please give me some details where to begin my journey with this task :) ? Maybe some useful hints or URLs containing basic information useful for new developer (e.g. turning on debug mode, etc. ) ?

Translating RosarioSIS to Arabic

Hello,

I'm trying to translate rosariosSIS into arabic. I'm using poedit for this purpose. I encontered a problem with plural forms. Actually there is 6 plural forms in arabic. See : http://wiki.arabeyes.org/Plural_Forms but some messages in RosarioSIS have just two plural forms. The first one I saw is this

: functions/ListOutput.fnc.php:3 modules/Attendance/AttendanceCodes.php:148

: modules/Food_Service/MenuReports.php:181

: modules/Grades/EditReportCardGrades.php:252

: modules/Grades/FinalGrades.php:167 modules/Grades/ReportCards.php:275

: modules/Grades/Transcripts.php:226 modules/Users/Preferences.php:293

: modules/Users/Preferences.php:326 modules/Users/Preferences.php:364

msgid "."
msgid_plural "."
msgstr[0] "."
msgstr[1] "."

poedit error message:

LC_MESSAGES/rosariosis.po:6: nplurals = 6...
LC_MESSAGES/rosariosis.po:1047: ...but some messages have only 2 plural forms
PM: msgfmt: found 1 fatal error

Any suggestions how I can deal with that ?
PS: once I finished the translation I will profide you with the .po file. Still, another problem: Arabic is writing from left to right, the user interface has to be adapted so.

Error Creating Courses

When i try to create a new course i get the following error:
Date: 07/13/2014 10:14:25

Failure Notice: DB Execute Failed.

Additional Information: ERROR: syntax error at or near ")" LINE 1: ...column", rosario_id, moodle_id) VALUES ('subject_id', '2', ) ^

Thanks
Johntig