php excel help..
Moderator: General Moderators
- pavanpuligandla
- Forum Contributor
- Posts: 130
- Joined: Thu Feb 07, 2008 8:25 am
- Location: Hyderabad, India
php excel help..
hii..
i'm developing an online portal for an university, which contain maodules like admin, accounts.
admin's job is to enter student,staff records and upload them to the DB.for example, if an exam was conducted for UG, PG students the admin has to enter about 3000 records to the DB.so i didnt find any use of using HTML FRONT END FORMS,now i'm using EXCEL as my front end form with password protection.
This predefined EXCEL has around 20 columns like name, branch, year, exam type, area of study followed by subject codes.
<b>NOTE:
-excel files are constants
-rows entered under the excel are also constants like name, branch, year.only marks obtained for concern subjects wil change and if a student promoted to next sem then year will change.</b>
my doubt is,
any application should save end user's time and effort.so html forms will be time killing, to enter 3000 records individually from html form will take min 40 minutes.
if i use html forms, my DB will be a normalized one. as my front end is EXCEL, normaliztion will create more excel sheets and many problems to delete or update single record.
so i'vent normalized my DB.
by doing this way, end user's time will be saved very much..can anyone tel me whether this idea is a good practise or not..
NOTE: END USER SHOULD NOT AFFECT is my motto./
many thanks,
pavan.p
waiting for ur opinions guys..
i'm developing an online portal for an university, which contain maodules like admin, accounts.
admin's job is to enter student,staff records and upload them to the DB.for example, if an exam was conducted for UG, PG students the admin has to enter about 3000 records to the DB.so i didnt find any use of using HTML FRONT END FORMS,now i'm using EXCEL as my front end form with password protection.
This predefined EXCEL has around 20 columns like name, branch, year, exam type, area of study followed by subject codes.
<b>NOTE:
-excel files are constants
-rows entered under the excel are also constants like name, branch, year.only marks obtained for concern subjects wil change and if a student promoted to next sem then year will change.</b>
my doubt is,
any application should save end user's time and effort.so html forms will be time killing, to enter 3000 records individually from html form will take min 40 minutes.
if i use html forms, my DB will be a normalized one. as my front end is EXCEL, normaliztion will create more excel sheets and many problems to delete or update single record.
so i'vent normalized my DB.
by doing this way, end user's time will be saved very much..can anyone tel me whether this idea is a good practise or not..
NOTE: END USER SHOULD NOT AFFECT is my motto./
many thanks,
pavan.p
waiting for ur opinions guys..
Re: php excel help..
Maybe I don't understand the design but I'll give it a go:
When I did a website for a t-shirt company, we had to enter thousands of t-shirt designs. So I simply did an excel template and created a batch function. So the user worked in excel, saved it as a comma-separated txt file and then just uploaded the file to the server and the script did the rest. Doing single alterations to an item was simply handled by an html form.
Even though the user's shouldn't get affected by design etc you still want a dynamic solution.
When I did a website for a t-shirt company, we had to enter thousands of t-shirt designs. So I simply did an excel template and created a batch function. So the user worked in excel, saved it as a comma-separated txt file and then just uploaded the file to the server and the script did the rest. Doing single alterations to an item was simply handled by an html form.
Even though the user's shouldn't get affected by design etc you still want a dynamic solution.
- pavanpuligandla
- Forum Contributor
- Posts: 130
- Joined: Thu Feb 07, 2008 8:25 am
- Location: Hyderabad, India
Re: php excel help..
hii..
i'm importing the excel sheet as .xls only, why to convert it into csv and impoting??
i dun find any use in doint tht..
u can c my previous posts here:
viewtopic.php?f=2&t=89321
i'm importing the excel sheet as .xls only, why to convert it into csv and impoting??
i dun find any use in doint tht..
u can c my previous posts here:
viewtopic.php?f=2&t=89321
- pavanpuligandla
- Forum Contributor
- Posts: 130
- Joined: Thu Feb 07, 2008 8:25 am
- Location: Hyderabad, India
Re: php excel help..
@ papa..
if u need more details, i'll post my php code and exact DB..
mkany thanks,.
if u need more details, i'll post my php code and exact DB..
mkany thanks,.
Re: php excel help..
Hey I did it 5 years + ago. 
These subject codes (A1BS01 , S02...) what happens if you add a new subject? Do you create a new column for that?
These subject codes (A1BS01 , S02...) what happens if you add a new subject? Do you create a new column for that?
- pavanpuligandla
- Forum Contributor
- Posts: 130
- Joined: Thu Feb 07, 2008 8:25 am
- Location: Hyderabad, India
Re: php excel help..
A1BS01, A1BS02 .. are a total of 10 subjects..the subjects remain same, but the subject codes may change, so no need to add an extra column(subjects are fiexed, subject codes and names may change).
hope u understand.
hope u understand.
Re: php excel help..
Well this tread might be more on topic where you posted it before though. 
I see that you've gone some help from jaoudestudios.
It's hard for me to get a feel of the structure as you've not posted a decent scheme yet.
I see that you've gone some help from jaoudestudios.
It's hard for me to get a feel of the structure as you've not posted a decent scheme yet.
- pavanpuligandla
- Forum Contributor
- Posts: 130
- Joined: Thu Feb 07, 2008 8:25 am
- Location: Hyderabad, India
Re: php excel help..
but u did tht 5+ years ago..
u too said the same thing "DB schema not perfect"..
i'm now way related with DB rite..i asked you whether its a good practise or not..
when we use excel as fornt end, if we normalize the DB, the end user has to enter records in multiple work sheets.
suppose if he wanna update or delete any single record, then he has to search for multiple worksheets for records against tht particluar student..
hope u understand
u too said the same thing "DB schema not perfect"..
i'm now way related with DB rite..i asked you whether its a good practise or not..
when we use excel as fornt end, if we normalize the DB, the end user has to enter records in multiple work sheets.
suppose if he wanna update or delete any single record, then he has to search for multiple worksheets for records against tht particluar student..
hope u understand
Re: php excel help..
Yeah but it's hard for us to help if the only details we get is "I have a table with 100 columns, is it a good design?"
You can do these kinds of things in a hundred different ways and they can all be equally good.
I've never worked with huge projects but initally I feel that having that many columns in a single table might incline that the structure and design is not optimal.
You can do these kinds of things in a hundred different ways and they can all be equally good.
I've never worked with huge projects but initally I feel that having that many columns in a single table might incline that the structure and design is not optimal.
- pavanpuligandla
- Forum Contributor
- Posts: 130
- Joined: Thu Feb 07, 2008 8:25 am
- Location: Hyderabad, India
Re: php excel help..
hii
i'm not asking about the database, suggest me whether we can manage those many tables with an excel spreadsheet instead of using 100's of forms or not?
r u clear now??
if we normalize the database we may get around some 30 tables, so if i use html forms there will be no problem and the dataflow from form to MYSQL is not visisble to the data entry operator.
but if i use excel the data entryhas to be easy and time saving process..
update, delete operations are done in excel only, so tht i can delete them in DB with a script..
i'm not asking about the database, suggest me whether we can manage those many tables with an excel spreadsheet instead of using 100's of forms or not?
r u clear now??
if we normalize the database we may get around some 30 tables, so if i use html forms there will be no problem and the dataflow from form to MYSQL is not visisble to the data entry operator.
but if i use excel the data entryhas to be easy and time saving process..
update, delete operations are done in excel only, so tht i can delete them in DB with a script..
Re: php excel help..
Of course you can manage that many tables with an excel sheet. Depends on how you write the batch job...
But I think the question is bigger than that but hope you are satisfied with the answer.
But I think the question is bigger than that but hope you are satisfied with the answer.