Saturday, February 13, 2010

Working Experience on "office automation" project."



We are working on office automation project , this is the project will reduce the office work with help of computer applications. There will be no need of calculating funds again and again , also no need of making paper records for the various funds transactions.
Our seniors had also tried their hands on this project and they were very close in completion. but, their were some problems in implementation of the project.
I along with my classmate Daljeet Singh Pathania again start working on this project under Dr. H.S.Rai sir's guidance.We started our journey of making project from the collection of previous work done and other details of the project available with Dr. H.S Rai sir. We both were very excited to work on this project and we goes as following:-

First we can try to run on Linux its difficult because our seniors made this on Windows . So our main problem is Linux is case sensitive and Windows not . So we can rename all the files according to file name is used in other files . So we can read all the files and modified according to need . And also make links between the files .
Second major problem is different version of same software a used by the our seniors and Now a we are use different Version . So there are some Keywords which are not support by older or new version .Some of the statement are Not working in new Version software . So we are modified these files .
In between these problems we are also get help from our respected teacher Dr. Hsrai sir . I was facing the problem of using username and password use in this software . Me used the Database username and password on that place by misunderstanding . So I told our sir , about this problem than they will tell to me thats username & password was not databases username & password , its a username which are written by in database tables .


Rai sir's guidance and motivation was always there to help and support us throughout the project.
We were facing the problem in “logging in“ in the software . We were using the database user and password in logging in the project but Rai sir suggest us the write user name and password (i.e. Which stored in the database table).
Now we are able to solve these problem and our project is on 90% worked condition.

Problems still facing

  1. How to add new users in the project and how to set the password for the new users.
  2. we also have to make amendments in the project according to the current policies of the college.
  3. Create the .odt file .
Now I can able to add the user  user ,but how to set the different password for new users , we cannot able to set this. but try in future ..
Now go to second Problem .
Our seniors are make this software according to  that time it need , but now there are many changes which we have to change
1. Add the one new field  in final reports which is generate that is " Higher Education tax" .
To add that field first  we change the database TABLE NAME "amt"  we can add new field that is "hedu" .
After this we can change the  whole system  files to display and also make calculations to add that data in TOTAL AMOUNT  and change the Service TAX ,EDUCATION TAX according to need.
Thats  diffcult job to read and modifly the whole system files ,but we can do it
2. The  SUSPENCE REPORT  is not Working  for ALL  the fields Which user required.
For this  we can modify some programming  files in which the SUSPENCE is not working .
3. In SUSPENCE REPORT  we are not able to get the DATE of CHECK /DD NUMBER .
For this we first add the DATE option in which the user can add  the date of CHECK / DD NUMBER  , than  its this date  can go to database TABLE NAME suspence  ,than  we can retrieve the date form database than Display on the Final SUSPENCE REPORT..
4. User also want to display the extra field in SUSPENCE REPROT  like TDS Amonut , Balance , Service tax and Total Amount.
so we can change this account to requirement .
5. Now the big issue is to generate the "" PROFORMA BILL REPROT"", BILL FEE REPORT" .For the addition of Proforma Bill & Bill Report we can again working with database file and add two tables PROFROBILL and BILL in database TC .After this we can add a new option in MENU.PHP ,than Create on the user interface for this field to add our data in database. Than we can retrieve the data form database tables and able to Create the report according to the user need.
6 .User also required to add the "SOIL" Field in the INSTITUTIONAL phase
7 .Problem with _POST method is working with the string value in PHP ....... This can be solved with help of Hsrai sir....... by using Inter values can be used without any quite, but string values need to be enclosed in single quote.
So Now we can working on this ...............


 

No comments:

Post a Comment