red1.org

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

First, please download Cybernetics latest db dump at: http://www.red1.org/barn/Cybernetics/cybernetics300805.rar

1. At Intake Session window, intake session drop down menu not collecting data from the correct field. - PARTIALLY FIXED

2. Study track not working, updating program structure of one track overwrites program structure for another track. - NOT TESTED

3. Cannot pre-register student: Unknown column 'remark' in 'field list'. - FIXED

4. Cannot retrieve pre-registered student from pre-registration window: Unknown column 'remark' in 'field list'. - FIXED

5. At Student Enrolment -> Course Enrolment window, data is not passing correctly (no data). - FIXED

6. At Students' Stat - Intake vs Program window, individual program hits is not displaying. - FIXED

7. At Student Status window, program and intake are not displaying properly. When Reset Status, all information disappeared. - PARTIALLY FIXED

8. At Subject Registration Reports window, hitting ENTER on keyboard does not perform Get function. Information is not displaying properly. - PARTIALLY FIXED

9. At Reports window, $customField.get("$field") is included in “Display in Report” section. - FIXED

10. Always has Java lang memory problem (need to restart server around every 30mins when there is active usage of the system). - NOT TESTED ON REAL SITE

NOTE: Red remarks show the status of each bug as per tested in binary received by 04-September-2005.

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

Please update in the forum status for all bugs, so that I can plan my trip to Cybernetics and know what to expect. For your information, Khairin is expecting those bugs fixed by tomorrow so that he can continue with the registration processes.

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

I have tested on the latest binary (04-Sept-05) to verify bugs reported on 31-Aug-05 (http://red1.org/forum/viewtopic.php?p=2787#2787). I list down my comments only on bugs which are not perfectly fixed:

Point 1 - At Intake Session window, intake session drop down menu not collecting data from the correct field.
Comment: New Intake Session is created during pre-registration. This new Intake Session should also be added into the drop down menu.

Point 2 - Study track not working, updating program structure of one track overwrites program structure for another track.
Comment: I skipped point 2 as Sam has overwritten some Khairin’s settings in the database. Settings been overwritten are Portal Role, Portal User, Program-Subject Relationship, Program Track, and Program Structure.

Point 7 - At Student Status window, program and intake are not displaying properly. When Reset Status, all information disappeared.
Comment: Study Period does not align to Study Session correctly. Setting of student status does not result in correct logic.

Point 8 - At Subject Registration Reports window, hitting ENTER on keyboard does not perform Get function. Information is not displaying properly.
Comment - Hitting ENTER on keyboard still does not perform Get function.
a <tab> and <space> can be a gud workaround. I try to do the codes but too trvial to troubleshoot.. wana finish the receipt module first Ok, this feature is now done by Sam, so i can copy paste his codes to any get field needed. Pls inform and i will do it i will CVS and zip binary for deployment
Point 10 - Always has Java lang memory problem (need to restart server around every 30mins when there is active usage of the system).
Comment – Sam is to assist with memory allocation for tomcat server on Windows XP environment.

sbahrin · Regular Joined: 17 Dec 2004 Posts: 81 Location: Malaysia

There has been a major clean up in the database especially for the session data. Previous session
data was incorrectly entered by me (there were no confirmation from client at that time,
due to their busy times). After GAN get confirmation from En. Khairin lately, there are only
two study sessions per year, that is, May and November. (August is not a study session).

Furthermore, student's intake is based on Month + Year basis, not based on study session as i did
before. Student's intake can happened within the study session, not only during the first month
of study session, for example, if the study session is Mei 2005/2006, the intake are not only
in Mei-2005 but also in August-2005. The system shall detect that, if intake is August-2005, the
students are following the Mei 2005/2006 sessions.

For these requirements, changes has been made to the database tables.

Fields that was added to student_course table are:

intake_month int
intake_year int
intake_code varchar

intake_code is the combination of intake_month + intake_year in MMYY format.

All existing data need to be updated with the values for these new fields.
The value of intake_month and intake_year was derived from intake_session.
In the cybernetics database, month for intake are M, N and O.

The SQL scripts that updates these values are as below:

update student_course set intake_month = 5
where intake_session like '%-M';

update student_course set intake_month = 8
where intake_session like '%-O';

update student_course set intake_month = 11
where intake_session like '%-N';

update student_course set intake_month = 2
where intake_session like '%-F';

update student_course set intake_year = left(intake_session_temp, 4);

update student_course set intake_code = concat("0", intake_month);

update student_course set intake_code = right(intake_code, 2);

select intake_code from student_course group by intake_month;

update student_course set intake_code = concat(intake_code, right(intake_year, 2));

select intake_code from student_course group by intake_year, intake_month;

Because of the revamp of the study sessions, all data for student status need also be updated.
For this task, I have created a class to run updates for each students one by one. The class is

mecca.sis.registration.InitializeStudentStatus

To run this class, use the ant (resides in /ant folder). In the build.xml file for the ant task,
there is a target named initStudentStatus. To run this, go to the ant folder, and type this:

ant initStudentStatus

This will update more then 5800 students data, and will take some times.

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

First of all, please download the latest database dump from Sam at: http://www.red1.org/barn/Cybernetics/cybernetics050905.rar

As usual, I have tested the latest binary (05-Sept-05) to verify those reported bugs. Below are my comments:

Point 1 - At Intake Session window, intake session drop down menu not collecting data from the correct field.
New Intake Session is created during pre-registration. This new Intake Session should also be added into the drop down menu.
Comment: I think the Intake Session field is a lot confusing. When I register a student for Jan 2005 Intake, Jan 2005 does not appear in Intake Session field. When I refer to the enrolment details, I found that this particular student is registered of November 2005/2006 Intake Session! Sam told me that Session and Intake Mth/Yr is different. I also need to trash out with every1 especially with Khairin on this later.

Point 2 - Study track not working, updating program structure of one track overwrites program structure for another track.
Comment: I skipped point 2 as Sam has overwritten some Khairin’s settings in the database. Settings been overwritten are Portal Role, Portal User, Program-Subject Relationship, Program Track, and Program Structure. Settings has to be redone. I will ask Khairin. also on this track issue
Comment: The initial idea of having Study Track is to handle multiple Program Structures in a one Program of Study i.e. Student of intake batch MEI 2005/2006 and intake batch NOV 2005/2006 for Program A might own a different Program Structure, due to frequent changes from government. We believe the system is capable of handling hundreds of study period setting, but in term of user friendliness, Khairin and I think that creating study period repetitively can be very troublesome and error prone.

Bug reported in Point 7 has been fixed. However, bugs reported in Point 8 and Point 10 have not come to any update or conclusion.

Khairin's login settings, and his two staffs login has no been restored as well.

The database already been completely restored in CICT server and tested together with En Fikri. - Gan

sbahrin · Regular Joined: 17 Dec 2004 Posts: 81 Location: Malaysia

10. Always has Java lang memory problem (need to restart server around every 30mins when there is active usage of the system).

Setting JVM options for Tomcat

* Windows running Tomcat 5 and later : Go to the "Apache Tomcat 5.0" folder in the Start Menu. Start the "Configure Tomcat application".
Note: the configuration can only be started when Tomcat is not running.
Select the "Java VM" tab in the configuration dialog. You will see some pre-defined lines in the "Java Options" test box. Append your Java options at the bottom of the option list. For example, to set server mode and allow 512MB of heap memory, append the following:

-server
-Xmx400m

* Windows running Tomcat 4.1 or earlier : place the Java options into the CATALINA_OPTS environment variable. To do this, run Control Panel / System, select Environment Variables and create the CATALINA_OPTS variable, and set the desired option, for example "-server -Xmx400m".

* Linux : place the Java options into the CATALINA_OPTS environment variable. For example: "-server -Xmx400m".

Please click below links to view screen capture using wink:

http://61.6.67.102/wink/tomcat_opts.htm

With assistance from En Fikri, the JVM options for Tomcat already been set in CICT server as per instructions given by Sam. - Gan

sbahrin · Regular Joined: 17 Dec 2004 Posts: 81 Location: Malaysia

I have identified 7 tables that must be restored from the backup database.
These are:

To create the mysqldump for these tables, I run this command at the
mysql dir command prompt:

red1 · Posted: Wed Sep 14, 2005 9:31 am Post subject:

i am identifying bugs for myself here. (list will go on.., Others can add to it, if want me to solve them)
1) To disable browser navigation controls so that user cannot browse internet or back or refresh but do as controlled by Mecca U.
2) PaymentModule>ReceiptPrint - to copy from Student_Billing_Details that contain Fee_IDs. DONE

sbahrin · Regular Joined: 17 Dec 2004 Posts: 81 Location: Malaysia

Gan has given an idea to create the values for intake_month and intake_year, that is by extract it from the student matric number.
The idea was not from me, it was from Red1 and Khairin.. simple but we did not see realise it previously..

I did not think of this b4... Shocked

here are the SQL scripts that do the job.

red1 · Posted: Thu Oct 20, 2005 11:08 pm Post subject:

Gan reported a bug on manual Invoice Creation which show extra student records in payment selection... i will look into that rite away.

red1 · Posted: Fri Oct 21, 2005 7:35 am Post subject:

Semalam sampai pagi ni hambo dok tidur lagee kerana meyolosaikan bugs tertimbul dari Sam mengalihkan java X ke tanpa X tetapi tidak mengalihkan pindaan kod2 saya. Mojo dapat trace satu persatu... Take note that the Payment Module Search javas has to refer to the X Preregistration Module... (only this one as the search is by student_billing, and the nonX PreReg is by Student_deposit.

Now seems ok... Gan shuld test the basic PreReg to BatchGenerateInvoice to FIFO Payment. Manual Invoice bug has been found. Its due to the creation of BillingHdr even toh there is no invoice details due to blank FEES returned, and the searching of student_billing is not SQLSelectDistinct.

Dont want to touch BillingData.java yet to plug the empty Fees. Sam pls confirm first that NOT suppose to create Invoice if the Fees is empty. Then only i make the object return if so.

Also the FeeStructureReportModule, Sam deprecated my method Crying or Very sad

and replace with his IntakeCodeData.getIntakeCodeList which doesnt return full set for it to work.. so i //comment his one back out Evil or Very Mad

.. and now it works... jangan mare ya... minta ampun sifu...

red1 · Posted: Sat Oct 22, 2005 5:46 pm Post subject:

Download to CSV function in this program http://localhost/mecca.sis.registration.ReportModule has bug.

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

Pre-Registration (mecca.sis.preregistration.action.PreRegistrationMainModule)
1. Cannot register new student: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' , 10, 10, 2005)' at line 1 OK -red1
2. Create receipt in payment but does show Credit in Statement (mecca.sis.billing.StudentAccountDataModule) OK -red1
3. Direct Enter on keyboard does not work for Name Search and IC No. Search // reported previously not urgent

Student Batch Invoice (mecca.sis.billing.BatchInvoiceGenerateModul)
1. Does not generate for next active semester which has not been invoiced. not urgent

Student Individual Invoice (mecca.sis.billing.StudentInvoiceGenerateModule)
1. Manual invoice creation prob // reported previously OK -red1

Payment and Receipt (mecca.sis.payment.action.PaymentMainModule)
1. No negative payment -> refund yet doing..

Sponsor Invoice (mecca.sis.bursary.SponsorInvoiceModule)
1. Don't need Session selection eg: 2005/2006-M - MEI 2005/2006
2. Invoices in sponsor_invoice_list.vm repeated twice, not sure its error in VM or code, please assist. have to ask Sam if sometimes codes accidently runs twice or Eclipse bug during testing

red1 · Posted: Tue Mar 07, 2006 11:41 pm Post subject:

Billing.ReportData.java fixed to not report receipts that are 'cancel'. Tested and CVSed.

Statement of Account no change as the cancel field is already stated.

khairin · Regular Joined: 27 Apr 2005 Posts: 57

not sure if i'd posted this before.....

bursary module>

individual account statement>

seems that any invoice that is manually added won't appear in account statement or any invoice reports. these invoices previously have fee_id "credit" but recently changed to "debit".

for example: matric number 03061230 have two invoices:
1. a manually added invoice number: INV2209 of RM3,040.00
2. auto-generated INV00004 of RM725.00

red1 · Posted: Thu Mar 16, 2006 11:59 am Post subject:

ok.. this means that u havent created fee_id "debit" in the fee_structure_program. Just do that and it shall come out in the statement. Very Happy

khairin · Regular Joined: 27 Apr 2005 Posts: 57

under student registration > student enrollment >

tried to update Course Enrollment Information for this student:

06020001

message: not a valid intake

it also kept putting the student under TRIM A 2006 intake session (should be NOVEMBER 2005/2006).

red1 · Posted: Thu Mar 16, 2006 8:17 pm Post subject:

A workaround is to remove all the trimesters sessions in the Academic Sessions Module.

Otherwise Sam will put in a range check before

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

The above should provide a temporary solution. We may need to have a table for Intake Code and Sessions, to assign intake code to individual study session.
This is needed because intake code for certain programs do not happen within the defined study sessions. I.e. For Australian offered program at CICT, intake happen outside the defined start/end date of a study session.

red1 · Posted: Mon Mar 20, 2006 8:42 am Post subject:

While waiting for the update code, Sam already has done an UpdateProgram process to update all registered students with the latest subject changes in the respective programs.

So Gan pls take from Sam and run it for Client.

khairin · Regular Joined: 27 Apr 2005 Posts: 57

The refund process is changing the amounts of old invoices.

case study: student_id 03061204

On 25/2/06, this student was batched invoiced as follow:
invoice no.: INV00022
amount : RM725.00

On 21/3/06, a refund process was done on the student. It appears perfectly ok in the students Account Statement. But when a report on all invoices generated on that day, INV00022 seems to be regenerated to the amount of RM5500.00

this actually occur on all cases of refunds.

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

There are some missing logics need to be implemented. For temporary, please freeze any further refund action.

There are two options we can fix this.

1. We fall back to the dbdump before any refund action. We shall fix the logic and pass over. From there, we replicate all missing payment and refund again. This option is heavily dependant on the volumn of payment transaction done in between. As We have to make sure the resit number with same resit date (change server date when issue) is allocated to the same student.

2. We will fix the logic and write a special program to scrub the messed data. But, we need to know exactly the invoice date before overwritten happened. And, this might take a longer time.

khairin · Regular Joined: 27 Apr 2005 Posts: 57

BUG in subject enrolment

This bug arise in the situation when during pre-registration a student change his/her mind to another program.

eg. student 06030003 came to join DPP program. Halfway thru registration he changed his mind and want to join DIT program instead. Change of program was done using the STUDENT ENROLMENT > COURSE ENROLMENT > Update Button.

Later it was found out that his course structure still maintain the DPP program structure in addition to the new DIT program structure. In this case all the DPP subjects should be automatically removed...

We tried resetting the students subject but no success.

Tq...

red1 · Posted: Thu Apr 20, 2006 3:09 pm Post subject:

solved in StudentData.java-

khairin · Regular Joined: 27 Apr 2005 Posts: 57

some errors found in bursary reports > receipts

1. The list by receipt range doesn't work. Reminded me to a similar problem we had in march due to SQL statements (something about the r.receipt_no,6,4) where i think should be r.receipt_no,5,3.
Tested, it's been fixed in latest package - Gan