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.
Bu iş için 66 freelancer ortalamada €26/saat teklif veriyor
Hi, I have read your post and understood your requirement. Looking for the freelancer to work on your next project? Or just need some issues/bugs/fixes ASAP? I have 11+ years of software experience in fortune 500 com Daha Fazla
Sehr geehrter Michael H., Wir haben 20 Jahre Erfahrung in PHP, Excel, SQL, MySQL, Database Programming, daher können wir dieses Projekt erfolgreich abschließen. Bitte überprüfen Sie unser Profil hier: [login to view URL] Daha Fazla
Hi there! I have read what you exactly need and I have great experience with Database Programming, MySQL, SQL, Excel and PHP. However I would like to ask you a few questions. I do work smart and do not rest until I get Daha Fazla
Dear Sir/Mam Before bid on this project , I looked attached xlsx template file , I will import excel records to mysql database based on date , name and location. I am master of Core PHP, MYSQL, HTML, CSS, AJAX, jque Daha Fazla