En cours

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

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.

Compétences : Administration de Bases de données, HTML, Javascript, MySQL, PHP

en voir plus : net csv file import database, ruby extract xml file import database, spreadsheet data clean import database, sql server ftp file transfer, how to import .sql file into microsoft sql server management studio, automated csv import to sql server, import data from excel to sql server automatically, automate import excel into sql server, sql server ftp get file, how to import script in sql server 2008, how to import sql file in visual studio 2015, php, mysql, css, html, software development, data processing, python, database administration, database development

Concernant l'employeur :
( 42 commentaires ) Barnsley, United Kingdom

Nº du projet : #15603541

Décerné à:

BaNgan

Hi, So we have method of update: - Via cronjob which iterate over all url and process the parser to run the script - Via a frontend to manually manage the process Here are step I gonna do: - Download the zip fil Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% GBP en 3 jours
(207 Commentaires)
6.8

21 freelance font une offre moyenne de £181 pour ce travail

OutsourceMan

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 revie Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(247 Commentaires)
7.8
vyasrohan

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 Experie Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(164 Commentaires)
7.7
NickolaS

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," Соответствующие Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(363 Commentaires)
7.6
mascotindia123

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(229 Commentaires)
7.3
JabaMS

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, javasr Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(24 Commentaires)
5.3
schoudhary1553

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 Expe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(28 Commentaires)
5.3
parsysmedia

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, MySQ Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(8 Commentaires)
4.9
writingart

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(3 Commentaires)
3.5
istvanc5

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(2 Commentaires)
3.5
zhengyang19

Welcome you. I just read your description and made full understanding. I will do my best to keep prices as low as possible and execute your project to your full satisfaction. Relevant Skills and Experience I have suff Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(9 Commentaires)
3.3
inovativeeyes

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 subscri Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(5 Commentaires)
2.8
bryanschmidty

I will be able to provide a web app that meets all of your requirements, and will be easy for me or other developers to expand as needed. I have over 10 years of experience with PHP and MySql.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(3 Commentaires)
2.2
webzonenetwork80

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(3 Commentaires)
2.2
devinblood

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 plat Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(1 Évaluation)
0.9
Yamy31

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 expe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(2 Commentaires)
1.0
shubhamaglave

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 expe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(1 Évaluation)
0.4
Prashantluhar

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(0 Commentaires)
0.0
dev0304

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(0 Commentaires)
0.0
ravikumardba85

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 DB Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
0.0