Terminé

Retrieve data from Excel file then connect to website SQL database and push updated data into 4 tables

Hi there,

I'm looking for someone to set up PHP on my office PC and create a PHP script that runs every X minutes (probably X = 5) , connects to my website's SQL server with a given IP and credentials, and pushes only data that has been updated in the last X minutes.

The data source on the office PC is 2 Excel files consisting of 5 spreadsheets. On the website, Table 1 has 20 fields, Table 2 has 2 fields, Table 3 has 4 fields, Table 4 has 5 fields.

Thank you.

- jt

Compétences : PHP, MySQL, Excel, Architecture Logicielle, SQL

en voir plus : import data from excel to sql server using query, vba code to import data from excel to sql server, import data from excel to azure sql database, how to export data from sql server to excel using query, inserting data from excel to sql table using query, how to import data from excel to sql server, import data from excel to sql server automatically, sql select * from excel sheet, making website sql database, connect website product database, file upload php sql database, generate static website sql database, moving website sql database, binary file uploading aspnet sql database, clone website sql database, excel visual basic retrieve excel file, insert file content microsoft sql database, registration form php connect form sql database, connect access sql database, joomla website sql database

Concernant l'employeur :
( 11 commentaires ) Dubai, United Arab Emirates

Nº du projet : #27463715

Décerné à:

sumon355

Hello, Is the database in ms sql server or MySQL? As you will run the program in local computer in schedule, i think php would not be the right choice. If you prefer, i can develop a program based on .Net. Let's discu Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(336 Commentaires)
7.7

30 freelances font une offre moyenne de 166 $ pour ce travail

(165 Commentaires)
8.2
gopalvora

Hi i can Retrieve data from Excel file then connect to website SQL database and push updated data into 4 tables i am good at Php , Excel , SQL , MySql so lets do talk more about it Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(538 Commentaires)
8.4
esalem

Hi, I am interested in your project and like to handle it. But I have question about the project. Why you like to use PHP scripts while you can have it as windows desktop application or as windows service that work in Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(55 Commentaires)
7.6
(554 Commentaires)
7.7
ykarora26

Hello sir, I already gone through the all information or description which is detailed by you. You are looking for Retrieve data from Excel file then connect to website SQL database and push updated data into 4 tables Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(255 Commentaires)
7.4
(104 Commentaires)
7.3
(178 Commentaires)
7.0
(51 Commentaires)
6.2
goodwork20k

Hello, I am a powershell and php expert, Could you please confirm you are only looking solution from PHP or you are good with Powershell? if you are ok with Powershell i can quickly provide the solution because i did s Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(55 Commentaires)
5.8
Shendiqerimi

hello , Sir? I have read your proposal very carefully. I'm very confident in the project, so I can get this done within 24 hours. I'm looking forward to working on your project Hope your kind contact. Thanks

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(23 Commentaires)
5.8
akritisood94

Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(72 Commentaires)
5.6
tutulsoft

-- i can give you a desktop tool, which perfectly work for you that you have expected. I have ready tool, just mapping your website table and your excel. thank you

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(29 Commentaires)
5.5
turaab

should be a cinch as i have already been doing syncing job on daily basis between csv (can do xls as well) and mySQL server using php. kindly let me know if you consider me

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(96 Commentaires)
5.4
scriptzguru

Okay sir, I will automate it all. I will install PHP on your Offic PC and then I will set it up all to retrieve data from Excel frok your pc for X minutes and then pushes data to yours MySQL server . Please let me k Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(33 Commentaires)
5.2
nizamfarhas

Hello How are you? I checked your description "Retrieve data from Excel file then connect to website SQL database and push updated data into 4 tables". I'm a senior PHP developer with 9 years of experience. I will de Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(19 Commentaires)
5.4
sejaltanna

Dear Client, I am glad to inform you that I can create PHP script to upload Excel data in tables. Let's discuss more in details to tell you exact cost. I have 10+ years of experience in technologies like PHP, HTML Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(44 Commentaires)
5.1
rnawaz

Hi there, I am php expert with lot of experience in csv data manipulation. I have recently done similar project. Please get in touch and I will deliver you a solution in a day or two. Best regards Rab

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(18 Commentaires)
5.0
yash99nimavat

Hello, we are team of experienced and professional developers and designers. we believe in deliver best quality product to our clients. for more information visit our website [login to view URL]

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(16 Commentaires)
4.6
vw8098368vw

Hi There, I can build solution using .net technology and it will fetch data by specified interval and update to SQL Server database. Looking forward to discuss. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(7 Commentaires)
4.2
adibonchis99

Hello I hope you are doing well. I have many experiences in manipulating excel data. A few weeks before, I have completed the projects that parse the two xls files into array and compare them and display the result. I Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
2.6