Find Jobs
Hire Freelancers

Create Scripts for auto download of a data file and import into Database.

£20-250 GBP

Cancelled
Posted over 6 years ago

£20-250 GBP

Paid on delivery
I'll provide more info on successful shortlisting of Freelancers (see criteria below) but essentially what I need you to do is: 1. Create a new Database using the Data Schema I will provide (2 tables - one with 43 rows, one with 63 rows approximately) on my server. 2. Create scripts (php or otherwise) that can do the following, in this order: - Download ZIP files from URLs I provide (there are approximately 12 URLs) - Unzip each file which will contain a large CSV file - Extract the data in the CSV file and import it into the Database you created in the first action. More requirements: - I'd be looking for a script per URL so I have control of which scripts I run. - A Cron job will need to be created so I can configure when the scripts run automatically - An email will need to be sent to me with a summary of the import - I need a very simple front end HTML page that requires a login to access with a summary of the imports (see attached mock up) and the ability to trigger the scripts. More info: - The CSV files are structured in exactly the same way, so the mappings only need to be created once as they can be applied to all the CSV files that will be downloaded - There are other options when it comes to the files to be downloaded, see the attached screenshot. Process: - Ill review all submissions and bids - Ill shortlist the freelancers that I think can do the work based on their bid and what they write in their bid. Automated bidding will be ignored and you'll be removed from the project. - Shortlisted Freelancers will get a message with the Data Schema attached and an example of one of the CSVs with an opportunity to ask any questions. - Ill choose a Freelancer to work on the project.
Project ID: 15603541

About the project

18 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
18 freelancers are bidding on average £176 GBP for this job
User Avatar
Surely, We are ready to help you with create Scripts for auto download of a data file and import into Database. we have understood your requirement. Let discuss little more? Relevant Skills and Experience Please review our profile and past work here: https://www.freelancer.com/u/OutsourceMan Proposed Milestones £142 GBP - Just trust us and get started! Looking forward to getting started today Vaishali
£142 GBP in 3 days
4.9 (503 reviews)
8.7
8.7
User Avatar
Hello I have experience with datafeedr API that can grab merchant items from various online stores. I have worked with affiliate stores I think I have good skills required for this project. Relevant Skills and Experience I have experience with writing scripts to CRUD operations with database, sending out automated emails with reports, setting up cron jobs, and much more tasks required in this project. Proposed Milestones £206 GBP - Estimated price, to be discussed. When would you like this project to be started? When do you want it to be finished?
£206 GBP in 3 days
4.9 (357 reviews)
8.0
8.0
User Avatar
Hello, I'm sure that will be able to complete this zip CSV importer for you within a day. But, please explain what you meant by "There are other options when it comes to the files to be downloaded," Соответствующие навыки и опыт 12 years PHP, back in 2009 was in top50 providers here before going to private sector Предлагаемые промежуточные платежи £250 GBP - full escrow =============================================================================== Update of message because the room for question is too small. Please, explain what you meant by "There are other options when it comes to the files to be downloaded,". As I can see from your screen, that is list of settings like output format which is CSV (current project) or XML (will require new project). Next there is format of compression. Then just a checker for internal filter in source system. So how that is related to this importer tool ?
£250 GBP in 1 day
5.0 (407 reviews)
7.9
7.9
User Avatar
Hello I have understood your Create Scripts for auto download of a data file and import into Database. , I'm sure that will be able to complete this zip CSV importer for you within a day. We can work with you on any level of your project that you may need support with. As a team having 11 + years of experience in this field we can assure you that you will get a high-quality Solution in respect of design and functionality. Looking forward to providing you best work. To know more about us and to view our past works, kindly check our portfolio on https://www.freelancer.com/u/mascotindia123 We look forward to hear from you soon. Thanks and regards, Harpreet Singh
£220 GBP in 5 days
4.9 (294 reviews)
7.7
7.7
User Avatar
Greeting, I have understood your Create Scripts for auto download of a data file and import into Database. task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Database Administration, HTML, Javascript, MySQL, PHP Proposed Milestones £160 GBP - Create Scripts for auto download of a data file and import into Database.
£160 GBP in 3 days
4.9 (115 reviews)
7.1
7.1
User Avatar
I am flexible, good and expertise with WordPress, and can troubleshoot problems and have quick solutions. I did much work to adjust sites for their requirements doing PHP and Wordpress programming for e-mail subscriptions, pop-ups alerts, not standard registration forms and complicated pop-up menus. I am also expertise with AWS and Linux as well. Kindly get back to me Thanks Geet
£150 GBP in 3 days
5.0 (37 reviews)
5.9
5.9
User Avatar
I have a team of expert developers and im also a developer we have done many task like ur task in our SOFTWARE HOUSE Stay tuned, I'm still working on this proposal.
£150 GBP in 3 days
5.0 (39 reviews)
5.3
5.3
User Avatar
Hello, my name is Mladen, I would like to work on your importation script, since I did it before (scraping data, which is very similar to your needs). Relevant Skills and Experience I am profesional php, mysql, javasrcipt programmer and html, css and wordpress developer. Very fiew of my past projects you can see on my portfolio. Also please check my reviews from other employers. Proposed Milestones £200 GBP - CSV TO MYSQL
£200 GBP in 5 days
4.9 (27 reviews)
5.4
5.4
User Avatar
Hey I can create the script you are looking to build.I am very much confident that I will be able to provide you script in very less time. Relevant Skills and Experience Database Administration, HTML, Javascript, MySQL, PHP Proposed Milestones £68 GBP - 1
£68 GBP in 2 days
5.0 (8 reviews)
4.9
4.9
User Avatar
I plan to do this in NodeJS with I logged almost 2000 hours on another site with perfect customer satisfaction. There'll be cron scripts for each feed and also a web based front end. Relevant Skills and Experience Web Scraping APIs NodeJS MySQL ExpressJS Email sending Proposed Milestones £240 GBP - Scripts and web front-end delivered Let me know what you think, Istvan
£240 GBP in 3 days
5.0 (2 reviews)
3.5
3.5
User Avatar
Hi, I have worked on similar projects before that required downloading external static files and importing them to the db. I can write a script that will download and parse the csv files. Depending on the size of the files, we may need to break it down into chunks so that the server doesn't time out. Then, we can load the data into the DB and send out a simple phpmailer email to notify you of the successful upload. For the interface, we can use JQuery datatables that provides a lot of functionality out of the box. I'd need a bit more info on the requirements of the interface before I'm able to quote. Happy to chat with you about this in more detail.
£244 GBP in 7 days
5.0 (4 reviews)
3.4
3.4
User Avatar
I guarantee you a first class service with the quality and in the time it deserves by putting at your disposal all my knowledge and years of practice. Habilidades y experiencia relevante I’ve more than 6 years of experience in the role of data architecture, working theoretically and practically with the concepts proposed and others such as: replication, migration, ETL, big data, etc. Htos propuestos £222 GBP - Development and materialization of the requirements
£222 GBP in 3 days
5.0 (2 reviews)
1.0
1.0
User Avatar
Hi, I am a software solutions developer web, desktop and otherwise, this is as clear and articulate a project description as I can imagine, I think upon discussing the details, such as the URLs and the underlying platform (does it permit sending emails? for example), the process will be straightforward from coding to deployment, some of the proposed solutions can be implemented more efficiently but that is my job, isn't it? Skill set: - A clear understanding of web technologies architecture - Core php/MySQL - Proper English, (nobody these days seems to have a clue when it comes to it) we can decide on milestones afterwards. I look forward to hearing back from you.
£240 GBP in 5 days
5.0 (1 review)
0.9
0.9
User Avatar
We are a Software Development Company. We have specialization in the Mobile (Android, iOS) App Development, Game Development, Web Development and Database management. Relevant Skills and Experience We have highly experienced team available in the Data Management( Back End Development) who have successfully delivered many projects similar to this requirement in their experience of 8+ years. Proposed Milestones £20 GBP - SRS Freezing £40 GBP - Completion of the Project
£60 GBP in 3 days
5.0 (1 review)
0.4
0.4
User Avatar
A proposal has not yet been provided
£111 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£111 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a B.E in (Computer Science Eng.) and 8+ years of Experience as an Oracle Database Administrator in IT industry and I've done my Oracle 11g (OCP) and ITIL certification. Relevant Skills and Experience Fulfill DBA daily activities Including Installation as Standalone/RAC clusters 11g/12c database,Build DR,Applying Oracle Patching,Up-gradation, Migration,RMAN,Cloning,OVM,AWS,Performance Tuning etc.. Proposed Milestones £150 GBP - . Additional Services Offered £1 GBP - I will get you very low cost and will support you if any other tasks without additional cost.. Kindly contact me to discuss your issues and provide you best support..
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Barnsley, United Kingdom
5.0
50
Payment method verified
Member since Mar 1, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.