Lengkap

Php script to load Excel data to MySQL

DO NOT BID WITHOUT READING THE DESCRIPTION FULLY. PLEASE.

This needs to be completed within max of 48 hours. The successful candidate could become part of the next phase of the project. Any innovative idea will be appreciated and rewarded.

Questions are welcome, but only after you read the scope of work in detail.

===============================================================

I need to develop a generic php script ([login to view URL]) that will read an excel file from a sub folder and load it into a mysql database based on the structure definition given in the ini file. This script will be used to upload various data that I am receiving from my suppliers.

1) I need to call the script with the subfolder parameter (example: [login to view URL]). The script should check the foldername and find a matching ini file in the root. For example, if the folder name is "folder1", then the ini file would be "[login to view URL]". A sample file structure is given below.

Root (Project Folder)

| [login to view URL]

| [login to view URL]

| [login to view URL]

|───folder1

| | [login to view URL]

| | [login to view URL]

| |───Porcessed

| | [login to view URL]

| | [login to view URL]

| |───Logs

| | [login to view URL]

| |───Error

| | [login to view URL]

|───folder2

| | [login to view URL]

| | [login to view URL]

| |───Porcessed

| | [login to view URL]

| | [login to view URL]

| |───Logs

| | [login to view URL]

| |───Error

| | [login to view URL]

2) The excel file will be either xls or xlxs. Both formats should be read.

3) The ini file contains the structure of the data to be uploaded. The script needs to check the ini file and understand the data structure before updating the database. A sample ini file is given below. The table_name to which the upload needs to happen is the first section of the ini file. The second section lists the columns to be updated. The key on the left is the column name in the table while the value on the right is the column name on the spreadsheet. The column names will always be on the first row of the spreadsheet. Only columns given in the ini file should be read and updated in the table. All other columns in the spreadsheet can be ignored.

[login to view URL]

=============

[table]

table_name="employees"

[column]

emp_name = "employee name",

title = "job title",

phone = "contact no"

=============

4) All the excel file in the selected folder should be uploaded one after the other and a nice progress bar should be shown to indicate the progress.

5) Once the file is successfully uploaded, the excel file should be moved to the processed folder. If the excel file has failed (even one record) then it should be moved to the Error folder using transaction control. A brief log of how many records has been updated and the error details (if any) should be created in the logs folder. The log file should be date/ time stamped.

6) The script needs to be able to support upto 25 columns. The script needs to be able to support upto 1000 rows in a spreadsheet. The excel data will always be in the first worksheet in the excel workbook.

7) The database connection parameters must be configurable at the top of the script.

8) Good error handling is a must to ensure all error scenarios are covered.

Kemahiran: HTML, Javascript, MySQL, PHP, Kejuruteraan Perisian

Lihat lagi: how to import xlsx file into mysql database using php, read excel file in php and insert into database, upload excel file in php example, how to import data from excel to mysql using phpmyadmin, import data in php, import excel to mysql using php code, import excel to mysql using php download, php excel import to mysql using phpexcel, php script pull html data, excel data mysql joomla, php script save checkbox status mysql table, php scripts generate reports data mysql, vba export excel data mysql, php load xml data mysql, php class import excel data mysql, linux script load excel mysql table, import excel data mysql using php, php script dump excel mysql, php import excel data mysql foreign keys, php script load media files mysql

Tentang Majikan:
( 13 ulasan ) Newark, United Arab Emirates

ID Projek: #19211160

Dianugerahkan kepada:

owebest

Hi, we have read your description carefully. we will be able to complete the tasks in the given timeframe as requested. Thanks Aakash

$100 USD dalam sehari
(299 Ulasan)
8.8

25 pekerja bebas membida secara purata $144 untuk pekerjaan ini

KashirinA

Nice to meet you. i read your description carefully and am very interesting in your project. i can start right now and can help you. if you hire me,i will do my best for you and you can get the best results. thanks

$155 USD dalam 3 hari
(125 Ulasan)
7.3
nataliaomelchenk

Hi. I am a full time developer and have high skills in web develop by PHP & MySQL. So I can complete this project. My price and time is negotiable. Let's discuss details via chat. I'll provide best service.

$155 USD dalam 3 hari
(62 Ulasan)
7.2
liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Lagi

$155 USD dalam 3 hari
(48 Ulasan)
6.9
jayshreeganeshha

hi ,php expert here and i would like to work on your [login to view URL] go through my reviews and discuss with me.I hope you would like to hire [login to view URL]

$250 USD dalam 2 hari
(105 Ulasan)
6.5
kipdev13

Nice to meet you. I've read the project description and can develop definitely. I'll provide you with the highly skilled & professional HTML/CSS, PHP/WordPress/CodeIgniter, JavaScript, MySQL, front & back-end web dev Lagi

$88 USD dalam 3 hari
(95 Ulasan)
6.5
ferozstk

Hello, After reading your project details I believe I'm suitable for this project. As I'm expert on it with more than 7 years experience. Please feel free to contact me. I am looking forward to hear from you. Lagi

$50 USD dalam 4 hari
(118 Ulasan)
6.5
yuriyes43

Hi, there! I am very interested in your job. I have been working as a full stack web developer for over 5 years. I am highly skilled in reading CSV and inserting to db so I feel confident that I can do your job with Lagi

$155 USD dalam 3 hari
(86 Ulasan)
6.7
emreg

Hi there I can complete your project with error handling by using this PHP library [login to view URL] less then 2 days. Thanks

$100 USD dalam 2 hari
(230 Ulasan)
6.3
adampohp79

Hi I am a full stack developer and I have rich experiences in Website development. My major skills is Full stack(Frontend, Backend). Backend: Laravel, WordPress, Django, Flask, Yii, Symfony, Node.js, ExpressJS Fro Lagi

$277 USD dalam 3 hari
(54 Ulasan)
6.1
artiboria

Hi, Thank you so much for the nice work opportunity. I am a Website and Mobile Application developer and having more than 12 years of experience in the industry. I do work on following technologies... Android Appli Lagi

$150 USD dalam 5 hari
(64 Ulasan)
5.7
zhaohm7

Thank you for your posting. I have more than 5 years experience of web development. I will show you a good result. Please Hire Me.

$155 USD dalam sehari
(36 Ulasan)
5.9
DaniilSpasov

Hello. How are you today? I just read your job description and it really attracts me. Your required skills are completely matched with my major skills. I have good knowledge and rich experience with PHP. I have done Lagi

$250 USD dalam 5 hari
(17 Ulasan)
5.7
testotorko

Hi. I want to achieve your project. PHP, MySQl, jQuery / Prototype, Javascript, HTML, CSS expert and can start right away.

$111 USD dalam 2 hari
(75 Ulasan)
5.6
kkc1985612

Hi, I'm interested in your job. I have 7+ experience in this field. Please send me a message so that we can discuss more. When I launch myself into a project I become obsessed and work tirelessly until completion of a Lagi

$100 USD dalam 3 hari
(47 Ulasan)
5.6
kovirijagdish

I believe in providing good quality code and services with security. I am a Web Security Researcher, Web Developer & Bug Bounty Hunter at HackerOne, BugCrowd, BountyFactory and many other Independent Bug Bounty Prog Lagi

$100 USD dalam sehari
(68 Ulasan)
4.6
AndreiVldmrvch

Hello client. I read carefully your proposal. I am a professional web and full stack developer. * No Upfront-Amount needed to Begin your Project * Ready to Start as Immediate, Unlimited Revisions & Proper Testing Lagi

$200 USD dalam 3 hari
(9 Ulasan)
4.8
sshyam24

Hi, Thanks for sharing your requirements here at freelancer. I am more than happy to help you on your project. I have excellent experience in Website Designing/Development. I believe my abilities would be perfect Lagi

$155 USD dalam 3 hari
(16 Ulasan)
3.7
virendrastarone

ph script to excel data High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I have gone through your Job post and I can understand your job requirement thoroughly. I have a t Lagi

$74 USD dalam 3 hari
(8 Ulasan)
3.6
KongHyongRan

Hi. I can do it perfectly on time. I have rich experiences but it's difficult to get task because I'm a new freelancer. Please hire me. Best quality, short time and low price! thanks.

$310 USD dalam 2 hari
(2 Ulasan)
1.4
kostya1207

I am web and app program Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer to feel the greatest satisfaction with low price. If you want to dev Lagi

$100 USD dalam 3 hari
(1 Ulasan)
1.7