Closed

Database & Web-Scraping Script

***Context & Introduction***

I am part of a small team whose mission is to help improve lives by reducing the delivered cost of energy. Ready access to high quality data is an important first step to achieving these aims; this project is aimed squarely at addressing that challenge.

***Project Overview***

We are looking to develop a database (data warehouse) to contain a large amount of historical data, which will have data added to it incrementally, approximately once every hour or day (depending on the data source) via automated processes. The scope of work consists of:

(1) database setup (table creation / structuring etc...),

(2) creation of an automated process to add real-time data from multiple sources.

The scripts from (2) will interact with multiple sources, primarily utilizing HTML:

(i) [login to view URL] (All data, as updated – approximately hourly)

(ii) [login to view URL] (All data, daily)

(iii) [login to view URL] (All data, daily)

(iv) All data from the following reports, retrievable via the dropdown menu from the following link: [login to view URL] -> ‘Current’:

a. Supply Adequacy Report (daily);

b. Supply Surplus Report (daily);

c. AS Trading – Volume Forecast (daily);

d. AIES Event Log (daily);

e. Actual Forecast (daily)

***Additional Details***

The database should contain all of the data items listed at the link above.

In order to avoid duplicate record creation the scripts should be sophisticated enough not to add data which has already been retrieved (data validation / duplicate avoidance).

***Deliverables***

(1) A means by which to receive or reconstitute the database shell (tables / structure / etc.); this can be via an SQL script.

(2) A script/daemon capable of adding new data whenever the source pages are updated, to keep each of the data streams listed above updated on the approximate time increments specified.

(3) Any pertinent instructions for the setup of the database or scripts

***Timing***

We would like to receive the deliverables no later than September 28th, 2018.

***What we're looking for in RFP responses***

We will be carefully reviewing all responses submitted to this request for proposals. In addition to standard demographic, credential and commercial information, it would be advantageous for you to include some content that would illustrate your initial thoughts on an approach to tackling the project.

Skills: Data Mining, Database Programming, MySQL, PHP, Web Scraping

See more: scrapy, web scraping tools open source, how to build a web scraper, web scraping python beautifulsoup, web scraping api, web scraping tutorial, how to crawl a website, python 3 web scraping, visual basic script database web connect, flash script search database web page, video database web script, kayak web scraping script, script update access database web form, php web scraping script, web scraping script, web scraping script perl, web scraping script php mysql, web scraping script builder, access database web scraping, php web scraping script repost

About the Employer:
( 2 reviews ) Calgary, Canada

Project ID: #17755499

25 freelancers are bidding on average $529 for this job

ramzitra

Hi, I would like to express my interest in your project related to scrape daily/hourly data from ets.aeso.ca. The script I will build will be in Python and I'll set it up on your server and I will create all the requi More

$750 CAD in 12 days
(262 Reviews)
7.6
bestit4u

Hi. I am very interested in your project, because I have much experience in such projects. I have good skills with the program language including C/C++, C#, java, php, asp.net, python, VB.NET. So I have expert and s More

$555 CAD in 10 days
(94 Reviews)
6.9
schoudhary1553

Hello! This is vibrant webtech and I was glad to see that you're looking for help for project Database & Web-Scraping Script. I've delivered more than 400 + projects in the last 5 years and this makes me very conf More

$750 CAD in 10 days
(57 Reviews)
6.4
priyank086

Hello Dear sir/mam i have viewed your project description and understand that you are looking for a Database & Web-Scraping Script expert please let me know all your requirement in detail so that we can start t More

$555 CAD in 10 days
(60 Reviews)
6.4
polarjin2017

Hi.. How are you? I saw your description carefully your project. Owing to my rich experience in data scraping , i can say i can do this perfectly. I have many top skills like python, scrapy,CSS,HTML ,PHP , BOOTST More

$555 CAD in 10 days
(72 Reviews)
6.5
Nawaz091993

Greetings! I am an expert Web Scraper and I will assume that for implementing this project you will be using a web server preferably a VPS. I will guarantee the completion of project within one week minimum and 9 da More

$800 CAD in 7 days
(113 Reviews)
6.7
zekovicm

Hi there,I am Miljan,Web Scraping expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within More

$444 CAD in 5 days
(62 Reviews)
6.5
joinwithsantanu

I have done google search result scraping to scrape the company data, company address, phone number, email, good reviews, bad reviews etc. Mainly that scraping is used to collect the reviews which will help into reputa More

$577 CAD in 10 days
(34 Reviews)
6.1
novepi

Hello, The requirements are quite clear and straightforward to implement. I've checked each source and everything looks good. Every report you want is simply served by a servlet as an html response. Script will pars More

$750 CAD in 7 days
(37 Reviews)
5.8
yongjin818

Dear I am an expert in web scraping. In before, I developed 400+ spiders using scrapy, php, selenium. For example, I scraped data for Many products informations from these sites(ex: ebay, amazon, welivv, [login to view URL], e More

$555 CAD in 10 days
(50 Reviews)
5.7
KGeorgy

Hello I am pleasure with your job for Database & Web-Scraping Script. Thanks for your job posting. I have throughout this description and think it's good fit for my skill-sets. As a senior expert on this job ,you c More

$555 CAD in 10 days
(26 Reviews)
4.9
yujun21

Hello! I saw your requirements.................... I have 10+ years of experience in WebScraping.......... I'm myself high skilled developer........................... I have already experienced it and have enoug More

$250 CAD in 3 days
(30 Reviews)
4.7
arjun366333

Ready to start the work to database & Web-Scraping Script, We can discuss more over chat, Thanks Regard Arjun S.

$333 CAD in 10 days
(19 Reviews)
4.7
leemilun

Hi Thank you for posting. I have read your post carefully. I have many experiences about the similar project with your post. And also my skill is talented. Please feel free to share me your detailed requirements. More

$333 CAD in 10 days
(16 Reviews)
4.4
mountian1997

Hi there. Nice to meet you. I'm a Web scrapting expert and FULL Time Developer. I have checked your requirements carefully. I have rich experience in web scraping, Python, PHP, Micro, MySQL, etc . I can start wor More

$555 CAD in 10 days
(14 Reviews)
4.3
wuricheng1985

Hello! Nice to meet you. I am a WebScraping expert and have 7 years of experience with webscraping using C#, Python, etc. I know how to complete your project, and can get this developed(fixed) for you quickly! If yo More

$300 CAD in 10 days
(12 Reviews)
4.6
d1scoveritech

Hi, I am interested to contain a large amount of historical data, which will have data added to it incrementally, approximately once every hour or day (depending on the data source) via automated processes Stylish yet More

$300 CAD in 10 days
(6 Reviews)
3.4
naishodayo

hello,sir. I'm a professional programmer with 9 years of experience. I've already done this kind of project before. If you award me, I'll implement all of your requirements in a short time. Database & Web-Scraping Scr More

$555 CAD in 4 days
(1 Review)
3.4
DarkKnight2206

I am a python developer.\nI have great experience in web scraping and I am an expert in it.\nI have all necessary skills by which I can scrape any website. I have even scraped sites like google, whatsapp web, etc. whic More

$500 CAD in 2 days
(10 Reviews)
4.1
iduyuncu

Hi ** Context & Information ** I am a computer science & engineering student from Hacettepe University Ankara/TURKEY Performed so many scraping projects successfully. So i collected all my recent scripts and build More

$622 CAD in 6 days
(3 Reviews)
2.8