Find Jobs
Hire Freelancers

Automization for reading table in an remote excel file from public ftp and storing data to mysql

$250-750 USD

Закрито
Опублікований over 9 years ago

$250-750 USD

Оплачується при отриманні
Please send me a relevant project you have completed with the bids.. thank you. You can find each detail below: Project is shortly finding, reading and transferring data from remote excel file available publicly in FTP. This excel file is stored in a public FTP and updated daily and the data cell sturcture of the excel file is always same. All excel files are systematicly updated and same. REQUIRED STEPS FOR SOFTWARE: 1- Search for daily updated excel file in a public ftp. 2- Transfer excel file to our server. 3- Read data from excel file (for example: 15 variable cells needs to be read) from the table inside the excel file. 4- Store the data from exel files to mysql database. 5- Create javascript line time series charts from the data stored in mysql. DETAILS OF THE STEPS: 1- FIND THE EXCEL FİLE: There are excel files in a public remote ftp. These files are updated daily in weekdays. Software will search the public FTP for the updated excel file. Updated are data are stored into new excel files each day. The name of the excel files follows a systematic date/month/year pattern according to the day's date. The files are only updated in weekdays, therefore, the software should only do the search in the weekdays. For the weekend files, software should search these in every Mondays. The daily excel files of the weekends are updated in Mondays again with the relevenant day files seperately. Instead of searching every day, software should do some logic for weekend files. There is an additional thing on this, the public days. Public days data are also not being updated in public days and these also updated in the following workday. Therefore, software should have more logic on searching daily files. -- I think that to solve this software can search excel files of last 10 days every time (some public holidays takes longer) and should check If that files already transferred or not to our server that way I think we can make sure that we got every file. -- As defined above, the files are updated daily. There is no spesific time for the update, It could be 9:00 in the monring or 14:00 in the afternoon in workhours. Therefore, the software should constantly search for the last missing daily excel file in every 5 minutes. I guess this can be achived by a cron job. 2-TRANSFER EXCEL FILE Excel file will be transferred to our server ftp. 3- READ DATA FROM CELLS: The data inside the excel file is needed. The tables in the excel files are always updated into same cells, table is always same cell structure, only the variables inside the data tables are updated for each day seperately. There is only one issue with the data cells inside the excel file: Data table inside the sheet is always same but sometimes the data table itself moves one cell right or left. This happens very rarely but happens and which could prevent reading the data completely. I mean software can't be programmed to read from cell B3 for example. I guess this can be solved by finding the first top left cell and by checking If there is a data considering rest of the cells has no data. Thay way, the table will be determined correctly because table structure is always same pattern. 4- STORE TO MYSQL: We need this data stored in mysql database. As you can understand, there are variables for each days which means there is times series. Therefore, we need to store the data with day unique id's and variable names on the columns. I will inform additionaly regarding the table structure. 5- CREATE A JS CHART: Now, we have the data in our server. We need to see trends by line charts for example in this time series data. This is the last ste, therefore, I will explain what we need after we complete the previous 4 steps. Please find attached the exce data table which needs to be read. As you can understand, most importing thing in this project is reading excel files timely and storing this to mysql correctly as a datatable.
ID проекту: 6824663

Про проект

20 пропозицій(-ї)
Дистанційний проект
Активність 9 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
20 фрілансерів(-и) готові виконати цю роботу у середньому за $653 USD
Аватарка користувача
Hi Good Day I have done more than 600 projects here in freelancer.com only. I have worked in all the scenarios you have listed as connecting to remote server using ftp, transferring files, processing excel sheet and storing in mysql and creating charts. But I cannot find exactly where I did them in the big pool of projects. I am quite confident to work out your project. Looking forward to work with you. Thanks Rinsad
$368 USD за 7 дні(-в)
4,9 (1318 відгуки(-ів))
9,5
9,5
Аватарка користувача
I currently do not have a ready sample for your review. however I have extensive knowledge in PHP and MySQL to complete this job to your specifications.
$722 USD за 7 дні(-в)
5,0 (173 відгуки(-ів))
7,7
7,7
Аватарка користувача
Hi, i see you need a script which would fetch excel files regularly, transfer them to your server, then import the data into mysql providing a front end where the data appears as a line graph. I can get this done for you very quickly, am a well seasoned developer with over 8yrs experience. Worked on lots of intranet apps and a few web backends that import data from excel as well as those that involve plotting charts with javascript. you can be assured a job well done. I've looked through the files you attached. i'm guessing we'l just be storing the figures into the db with time matching dates to be rendered on the graph....right? Would be great to hear from you. Cheers.
$500 USD за 5 дні(-в)
4,9 (25 відгуки(-ів))
6,8
6,8
Аватарка користувача
Hi, It\'s Steve.. If you are available right now I would like to show you one of my previous work that grabs excel files (excel directly or zip file containing excel file both) and puts it on our server and then parses it, stores in mysql and creates different excel files populating with the related data that was inside the remote excel file. I prepared an admin panel from where the user can provide the ftp details and then just check daily for the newly created excel files populated with data. I did this for one of my previous clients so would not be able to show you its performance but still can show you admin panel and rest of the things. Waiting for your reply and I am going to charge a bit more just for js charts and etc but guarantee the perfection and performance of the work. Thanks
$944 USD за 7 дні(-в)
4,9 (43 відгуки(-ів))
6,3
6,3
Аватарка користувача
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$750 USD за 30 дні(-в)
4,9 (155 відгуки(-ів))
6,5
6,5
Аватарка користувача
Hi I have not done a similar project. But Iam 200% confident about this. because I am an expert in library phpexcel for reading excel files and about graph . My 2 projects in freelancer were for creating and customising graphs using data from db. I have created cron jobs also. If the file is publically available without using a password then it can be easily fetched and manipulated cell by cell. About you other concern that is week days we have plenty of date manipulation functions. if you are confident in me please accept my bid.
$250 USD за 10 дні(-в)
5,0 (37 відгуки(-ів))
6,2
6,2
Аватарка користувача
Hello, I have 14 years of experience in software development with strong technical background. I have strong development experience in Java, J2EE , C++,C#, data structure, algorithm, design pattern, Object Oriented Programming & RDBMS(My SQL, Oracle, SQL). I have participated in all phases of S/W development for desktop as well web based application. Few of projects are as following: 1. PDF com library for editing PDF file and rendering to printer and display device 2. Implementation of pattern search APIs based on fuzzy logic & Levenshtein distance algorithm. 3. Developing various automation tools to automate GIS data production & processes. 4. Tool for Testing planarity of graph and do embedding using DEMOUCRON algorithm. 5. Website for uploading & downloading files 6. STL(STereoLithography)Mesh Fixing like- Normal, Cacks, Holes, Overlap, Intersection, Disconnected facets, Noise Shells and Degenerate facet 7. MCrypt: Encryption/decryption S/W 8. Automatic Conversion of Java project to C# 9. Analysis & Design of ERP System For details about my project, please check my profile. I am confident that I can complete your work with good quality and according to your expectation. Let us discuss & finalize the development road map with measurable milestones. I am looking forward to work with you in your current project. If you need more information, please let me know. Thanks & Regards, AVASP
$288 USD за 15 дні(-в)
5,0 (7 відгуки(-ів))
5,8
5,8
Аватарка користувача
i can write this script .
$380 USD за 3 дні(-в)
4,8 (58 відгуки(-ів))
6,0
6,0
Аватарка користувача
Hello I am a full-time freelancer who has rich experience and high skills in PHP / MySQL / Javascript / ajax / jQuery / ... programming. I am sure that i can complete your project successfully. No problem. Can we talk about your project detail ? Best Regards.
$315 USD за 7 дні(-в)
5,0 (22 відгуки(-ів))
5,4
5,4
Аватарка користувача
Dear sir, I have read your requirement and excel attached file carefully. I have experience on domain of your project include: fpt file check and get, php, mysql and also real-time show result with js chart. I think I am a right person for your project. Please contact me to start right now. Thank you for your attention, thanhhungqb
$300 USD за 5 дні(-в)
5,0 (64 відгуки(-ів))
5,0
5,0
Аватарка користувача
we will develop a nice enterprise level application using open source softwares like apache camel, tomcat , database mysql and java. The camel is tool for integration purpose and rules can be implemented easily. specifically the rules about scanning the file on the gtp site. This will make the system really scalable and extendable for future. We are experienced java and JavaEE based system developer with 10 + years of experience. We had worked on integration projects before.
$778 USD за 10 дні(-в)
4,8 (6 відгуки(-ів))
4,4
4,4
Аватарка користувача
hi. i am a php developer. this is one of my last projects about saving data on excel file. https://www.freelancer.com/projects/excel-export.6705344.html i worked with high charts many times. i can finish you project in 5 days . thank you very much
$350 USD за 5 дні(-в)
5,0 (44 відгуки(-ів))
4,1
4,1
Аватарка користувача
A proposal has not yet been provided
$722 USD за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор TURKEY
new york, Turkey
5,0
5
На сайті з груд. 25, 2011

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.