Đã Đóng

Excel to MySQL DB - follow up possible

Target:

Import a Excel File from Webspace folder into a MySql Database.

Description:

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

AND

Display the current Date including the Name and Location.

eg:

Viw A:

Today:

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.

Mockup attached.

Some follow ups are possible. This is just the Start of the Project.

Kĩ năng: MySQL, PHP, SQL, Excel, Lập trình cơ sở dữ liệu

Về khách hàng:
( 0 nhận xét ) Sankt Pölten, Austria

ID dự án: #34051521

66 freelancer chào giá trung bình €26/giờ cho công việc này

(122 Nhận xét)
9.2
(760 Nhận xét)
9.0
seekdeveloper

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 Thêm

€18 EUR / giờ
(125 Nhận xét)
8.8
(576 Nhận xét)
8.5
tangramua

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] Thêm

€25 EUR / giờ
(192 Nhận xét)
8.4
(206 Nhận xét)
8.1
(48 Nhận xét)
8.2
(9 Nhận xét)
7.7
sashast

Hi, Greeting ⭐⭐⭐ [login to view URL] (recent works) ⭐⭐⭐ I am proficient in MySQL database design from Excel, CSV file I have good experience of 7+ years in this field and I have done a few projects similar to y Thêm

€30 EUR / giờ
(7 Nhận xét)
7.5
fenilrana129

Hello I can definitely help you to create PHP script to import excel file to MySQL database according to requirements, I am an experienced full-stack PHP developer with over 4 years of experience and I have worked on Thêm

€18 EUR / giờ
(198 Nhận xét)
7.5
(39 Nhận xét)
7.6
AwaisChaudhry

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 Thêm

€47 EUR / giờ
(54 Nhận xét)
7.3
(156 Nhận xét)
7.3
(216 Nhận xét)
7.4
(99 Nhận xét)
7.1
(186 Nhận xét)
7.0
(56 Nhận xét)
7.2
AndroPetre

Hello, my name is Daniel Andronic and I am a freelance web developer with several years experience working in this industry. My skill set matches your needs perfectly and I'd be more than happy to be the one who gets c Thêm

€35 EUR / giờ
(73 Nhận xét)
7.2
webmaestro2013

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 Thêm

€18 EUR / giờ
(206 Nhận xét)
7.1
(228 Nhận xét)
6.7