Import a Excel File from Webspace folder into a MySql Database.
The attached file should be uploaded to a MySql Database. It is requred to read each date selected by Name, Date and Location.
I would like to Display the whole sheet, based on the current Date orderd by week
Display the current Date including the Name and Location.
Name|Company |Type |Monday |Tuesday |Wednesday|Thursday |Friday |Saturday
Mr. X | CompanyA | Worker| Lacation A|Location B |Location C |LocationD| Location E| Location F
Mr. Y | etc. etc..................
All This views should be perfectly readable on a 55" TV screen. (Signage Display)
approximatly 15 Rows per page. At the ende there will be approx 5-6 Pages (the amount of employees is variable)
The file will be extended every week with one data sheet. At the end of the year there will be 52 to 56 data sheets depending on the Projects an schedule. (it´s more like a calendar)
The Data should be structured and added to da DB by adding a creation Date because it can happen, that the File will be updated multiple times a Day/Week. The displayed Data should always be up to Date when refreshing the site.
Every comany has its own color, so there should be at least 8 Colors predefinded
Every DB line should include the insert date and an unique ID as primary Key
Please prepare the Database to add several Years into it.
Every emty Row can be skipped when importing the file.
Preferd Language: Php
I will provide a
-DB Access if necessary
- The Template for the displayed table.
Some follow ups are possible. This is just the Start of the Project.