Kapalı

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.

Beceriler: MySQL, PHP, SQL, Excel, Veritabanı Programlama

Müşteri Hakkında:
( 0 değerlendirme ) Sankt Pölten, Austria

Proje NO: #34051521

Bu iş için 66 freelancer ortalamada €26/saat teklif veriyor

(122 Değerlendirme)
9.2
(760 Değerlendirme)
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 Daha Fazla

€18 EUR / saat tutarından itibaren
(125 Değerlendirme)
8.8
(576 Değerlendirme)
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] Daha Fazla

€25 EUR / saat tutarından itibaren
(192 Değerlendirme)
8.4
(206 Değerlendirme)
8.1
(48 Değerlendirme)
8.2
(9 Değerlendirme)
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 Daha Fazla

€30 EUR / saat tutarından itibaren
(7 Değerlendirme)
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 Daha Fazla

€18 EUR / saat tutarından itibaren
(198 Değerlendirme)
7.5
(39 Değerlendirme)
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 Daha Fazla

€47 EUR / saat tutarından itibaren
(54 Değerlendirme)
7.3
(156 Değerlendirme)
7.3
(216 Değerlendirme)
7.4
(99 Değerlendirme)
7.1
(186 Değerlendirme)
7.0
(56 Değerlendirme)
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 Daha Fazla

€35 EUR / saat tutarından itibaren
(73 Değerlendirme)
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 Daha Fazla

€18 EUR / saat tutarından itibaren
(206 Değerlendirme)
7.1
(228 Değerlendirme)
6.7