Find Jobs
Hire Freelancers

Create a automization for reading table in an excel file from public ftp and store 15 variable data of this into mysql

$15-25 USD / hour

Ditutup
Dibuat lebih dari 9 tahun yang lalu

$15-25 USD / hour

Project is shortly reading and transferring data from excel file uploaded in FTP. This excel file is stored in a public FTP and updates daily and the data table inside the excel file is always has same data table in same cells. All excel files are systematic and same. REQUIRED STEPS: 1- Search excel file in a public ftp 2- Transfer excel file to our server ftp 3- Read data (15 variable cells needs to be readed) from data table inside 4- Store this 15 variable data to database 5- Create a javascript line charts from the database DETAILS: 1- System will search the public FTP, If there is a new excel file created. Excel files are updated daily and only in weekdays. The name of the excel files follows a systematic date/month/year pattern according to the current day's date. The files are only updated in weekdays, therefore, the search should only work in weekdays. And every Mondays, the daily excel files are updated with the files of weekend, therefore, these all files needs to be searched on Mondays* *To solve this system can search excel files of last 10 days (there are also public holidays which is longer than weekdays) and checks If It is also transferred to our server that way we can make sure that we got every file. 2- Excel file will be transferred to our server (this will be used also for confirming weekend excel files) 3- The data inside the excel file will be read. The data tables are always updated into same cells, table is always same, only the 15 variable data is updated. *Data table inside the sheet is always same but sometimes the start of data tables changes (very rare but happens) I guess this can be solved by finding the first top left cell and by checking If there is a data, thay way, the table will be determined, table has always has same pattern. 4- Store this 15 variable data into mysql with date and weekday variables. 5- Create a javascript based line charts (for example highcharts) from this (I can explain what we need after the completion of previous steps of excel reading) PLease find attached the exce data table for your information.
ID Proyek: 6542594

Tentang proyek

13 proposal
Proyek remot
Aktif 9 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
13 freelancer menawar dengan rata-rata $22 USD/jam untuk pekerjaan ini
Avatar Pengguna
Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No subcontractors. see my recent work for the technical expertise along with reviews & feedback on my profile page.
$25 USD dalam 30 hari
5,0 (99 ulasan)
8,3
8,3
Avatar Pengguna
Hello! With 99% completion rate, 700 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wrong choosing me :) I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
$36 USD dalam 10 hari
5,0 (537 ulasan)
7,6
7,6
Avatar Pengguna
I am an expert in delivering custom scripts and software willing to discuss further about the project needs
$21 USD dalam 3 hari
4,8 (129 ulasan)
7,3
7,3
Avatar Pengguna
A proposal has not yet been provided
$15 USD dalam 40 hari
4,9 (94 ulasan)
6,9
6,9
Avatar Pengguna
Hello I can help you, i have a lot of experience parsing excel files from ftp servers. I can do this job for you smoothly. I can start right away. Regards,
$16 USD dalam 5 hari
4,9 (91 ulasan)
6,4
6,4
Avatar Pengguna
Need to discuss this in detail,please tell me how we can start the discussion on this requirement. We have a team of 34 professionals,they have more than 11 year of experience, expertise in php/mysql and their MVC frameworks like laravel-4,symfony-2,cakephp,html,html-5,bootstrap, etc, so we can manage this work.
$15 USD dalam 40 hari
2,4 (27 ulasan)
6,7
6,7
Avatar Pengguna
A proposal has not yet been provided
$26 USD dalam 30 hari
4,9 (15 ulasan)
4,9
4,9
Avatar Pengguna
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$20 USD dalam 3 hari
4,9 (38 ulasan)
4,8
4,8
Avatar Pengguna
Hi, I have 2+ years experience working with similar skills, I can get the task done for you, so if you are interested in a collaboration please contact me..... With warm regards
$21 USD dalam 25 hari
4,9 (12 ulasan)
4,2
4,2
Avatar Pengguna
Hi, Thanks for specifying the requirement clearly. I have been in web development with Javascript, HTML, PHP, JAva, Mysql , Oracle etc for last 5 years. I have worked on a number of similar projects where I had to write code for accessing servers via FTP and read/write files. The details you have given can be implemented easily by me as I did similar works in the past. Please let me know if you are interested in working with me or if you have any question. Thanks, Ayan Dasgupta.
$16 USD dalam 3 hari
5,0 (11 ulasan)
4,0
4,0
Avatar Pengguna
Hello, Hope you had a great day today. I know you are looking for I.T. Programming partners to work on your projects. I will not tell you that we can do this and that; alternatively I would like to find the solution for your need from our existing database. So the project that you are looking for is implemented before the deadlines. Also we keep our rates reasonable if the project has the similarity with the one, which we have done before. If the project is not from our database we will quote a very good and reasonable price for the custom development. We have good database of the software, apps, games, and websites. Those databases can be used only if client permits us to do else we start from scratch and deliver the desired results. We have worked on: Apps Restaurant app, GPS Navigation apps, Enterprise Apps, Climatic apps, Guide apps, Radio apps, Chat apps, Music apps, IEMI apps, Domain Reg. apps, Social networking apps, Banking apps, File manager apps, Directory apps, Ticketing apps, Real estate apps, Medical apps, Deal apps, QR code apps, Recharge apps, Video editing apps, Shopping apps, etc. Games 3D hunter game, Fighting game, Talking Tom games, Basketball game, Cricket game, Chess game, Volleyball game, Dice game, Farmville game, Casino game, Golf game, Pet game, Racing game, Running game, Soccer game, etc. Looking forward to your reply and expect an inquiry from you. Thanks Ben
$25 USD dalam 30 hari
5,0 (3 ulasan)
3,4
3,4
Avatar Pengguna
Hello. First thank you for the well made project. It's refreshing to work with someone who knows what he/she wants. I can code such a system for you. It should take no more than 5 working hours. Message me back when you can. --Vinicius Zolin
$22 USD dalam 6 hari
5,0 (3 ulasan)
2,4
2,4

Tentang klien

Bendera TURKEY
new york, Turkey
5,0
5
Anggota sejak Des 25, 2011

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.