02-21-2012, 09:44 PM
I'm trying to figure out the best way to approach this.
I have a protected section on a website for employees. My client wants to add the employee schedule. She keeps this information in an Excel file. She wants to be able to just upload the excel file and have the information display. There will be many cells with data. She will be updating this file and uploading it daily.
I could have her save the excel file as html before uploading, but I'm not sure if that would display correctly on all platforms.
What's the best and most efficient way to do this?
02-21-2012, 11:32 PM
Save the file as a .csv (comma separated variable) file and upload that.
PHP can open the .csv file and do whatever you want with it.
Is there a reason she uses Excel?
Maybe there's a better way?
02-22-2012, 12:08 AM
She's in charge of the schedule for the employees and I think Excel is her program of choice for creating it.
She wants the schedule to be added to the website with minimal effort on her part, since there are hundreds of employees and she needs to update this daily.
I got the impression she has limited computer knowledge, so it can't be too complicated. She just wants the scheduled displayed. Nothing fancy at all.
I'll check out the csv route and see if that is something that might work.
02-22-2012, 12:16 AM
Find out if Excel can upload a CSV copy of the sheet automatically using FTP.
With hundreds of employees, I would expect they would be running a
professional personnel management system of some kind. Hundreds of
employees implies a larger company than just a mom and pop shop.
Even if they hired a programmer to create an exceptional custom system,
they can't afford to do that? No offense to you. I just think they could
afford a system that is above something a non-professional programmer would
do (like myself ... a guy with a PC on the kitchen table). Anything they
purchase is a business tax writeoff.
02-22-2012, 12:37 AM
02-22-2012, 12:41 AM
I'll have to see if they are running something like that.
She asked me because I've done a couple websites for them. I'm a web designer not developer, so I do have limited knowledge in php coding. They are a company that does contract work, so they have many employees that are not full time, so there are various schedules.
She originally just wanted a password protected document on the site. We've migrated to having an employee login section with the schedule.
02-22-2012, 12:49 AM
Thanks, I'll check this out. Looks like it may help with what I'm looking for.