Find Jobs
Hire Freelancers

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

$250-750 USD

Κλειστή
Αναρτήθηκε πάνω από 9 χρόνια πριν

$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.
Ταυτότητα εργασίας: 6824663

Σχετικά με την εργασία

20 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 9 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
20 freelancers δίνουν μια μέση προσφορά $653 USD για αυτή τη δουλειά
Avatar Χρήστη
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
Avatar Χρήστη
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
Avatar Χρήστη
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
Avatar Χρήστη
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
Avatar Χρήστη
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
Avatar Χρήστη
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
Avatar Χρήστη
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
Avatar Χρήστη
i can write this script .
$380 USD σε 3 ημέρες
4,8 (58 αξιολογήσεις)
6,0
6,0
Avatar Χρήστη
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
Avatar Χρήστη
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
Avatar Χρήστη
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
Avatar Χρήστη
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
Avatar Χρήστη
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

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.