Sedang Disiapkan

Database and web scraping Project

Hi All,

I have an existing Microsoft Access database that I would like either upgraded or converted to a quicker and less buggy database. It is currently cumbersome and often produces errors.

The current database, which I will provide, downloads event related CSV files from one website, creates a unique Id for each row of the CSV file, and combines this file with a results file I download manually. The code for this is included in the database I will provide, as is the lookup table that matches the two files as they have different identifiers for location, e.g. Sydney = Syd.

For this upgrade project I am happy to use a program other than Access, at your recommendation, and I would like the following improvements:

- automate download of results files as well as just event files,

- combine files, and once event and results files are combined, have them readily available for future analysis

- ability to apply filters to database quickly and easily

- easy download to CSV or excel format post application of filters (or in entirety)

- additional columns, or a seperate database, that applies excel formulas to the raw database. These are generally sumifs/averageifs or one field minus another field. These formulas can be provided, and essentially compare one competitor to other competitors within that event.  I would need to be able to amend the relevant excel formulas over [login to view URL] ADVISE IF YOU DON'T BELIEVE THIS IMPROVEMENT IS POSSIBLE.

I am happy with any database format that is user friendly on windows, and can continue to use Access if preferred. Note the database would be large with 400,000+ rows so not suited to excel.

I would propose to pay 25% upfront, 25% at a milestone, 25% upon completion and a further 25% 3-6months later subject to your ongoing support.

I would like the end product to include 1 year of recent data already completed.

Please ensure you comment on how you would achieve the outcome of the project in your bid.

Many thanks!

Kemahiran: Pembangunan Pangkalan Data, Excel, Microsoft Access, Pembangunan Perisian, Pengikisan Web

Lihat lagi: web setup project database, web setup project database asp, web scraping project, scrapy to database, web scraping tools open source, web scraping python, web scraping tutorial, intro to web scraping, web scraping database, web scraping into database, sql server web scraper, aspnet database web service project, web scraping project payment amount, web setup project sql database, car database web project, estimation web scraping project, part time web based project jobs home sri lanka, sample project web scraping asp net, web scraping project desktop freelancing, web scraping project report

Tentang Majikan:
( 2 ulasan ) Cammeray, Australia

ID Projek: #17959776

Dianugerahkan kepada:

srsumitroy

Hi, Quiet a interesting project. I have done this kind of work before. But mine was transporting data from Foxpro to Oracle (with code and UI). About me: I am having over 20 years of experience in IT field and last Lagi

$555 AUD dalam 20 hari
(0 Ulasan)
0.0

33 pekerja bebas membida secara purata $509 untuk pekerjaan ini

schoudhary1553

I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid Lagi

$400 AUD dalam 5 hari
(278 Ulasan)
7.6
ramzitra

Hi, I am interested in your project related to build a scraper for events data from one website and put data to a local database. Please send me a message so that we can discuss all the details. Thanks, Ramzi

$750 AUD dalam 10 hari
(255 Ulasan)
7.6
seaanddream

Hi, my name is Selim. I will write a java-based desktop app with a simple UI, which will perform the tasks and export the outcome into an access database, as you prefer... I read your "Database and web scraping Projec Lagi

$555 AUD dalam 10 hari
(329 Ulasan)
7.8
mirniyazuddin92

Hi there, I can do database and web scraping for you. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

$555 AUD dalam 10 hari
(305 Ulasan)
7.7
mhmhz

Hi I can create a desktop application that scrapes the data and store it in Access or Mysql db. Can work on a demo if you like. Thanks

$1000 AUD dalam 10 hari
(90 Ulasan)
7.3
fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As Lagi

$277 AUD dalam 10 hari
(87 Ulasan)
7.3
$250 AUD dalam 4 hari
(276 Ulasan)
7.5
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 Lagi

$493 AUD dalam 10 hari
(97 Ulasan)
7.0
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Lagi

$500 AUD dalam 5 hari
(104 Ulasan)
6.1
royalcalif

I had read line by line in proposal. Still i need to discuss little bit more about the download CSV from website. and reports, process of whole access database and i would like to review the existing database as well. Lagi

$250 AUD dalam 6 hari
(96 Ulasan)
5.9
sonarkaushik

Sir,      I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you Lagi

$489 AUD dalam 14 hari
(59 Ulasan)
5.8
mladenbiz

Greetings I am python developer and i have all the right tools for sorting yout your database. 1. Python a rich csv libary called pandas, that can be used for fixing existing database 2. When it comes to webscrap Lagi

$722 AUD dalam 10 hari
(60 Ulasan)
5.6
shinelancer

*** I have checked your description in detail. I have good experience on scraping/MSAccess/SQL. Do you need desktop app? I want to discuss with you about this project. thanks.

$400 AUD dalam 10 hari
(21 Ulasan)
5.2
mateenbhatti94

Dear sir I have read the requirements and completely understand the project.I will build a desktop application that can store unlimited data and will not have any errors.I will build the application according to you Lagi

$250 AUD dalam 3 hari
(45 Ulasan)
5.5
osmanaydin

Hello sir, I have completed web/data scraping jobs many times. I am interested in your project as well. I would like to discuss details via pm. I look forward to hearing from you soon. Best Regards,

$599 AUD dalam 10 hari
(19 Ulasan)
4.3
leemilun

Hi, Dear. Nice to meet you. I've read your post carefully. I'm Web Scrapping expert. Please discuss more details by chatting. Regards. Gao M.

$555 AUD dalam 5 hari
(12 Ulasan)
4.3
dataexplorer

"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your and able to provide accurate and quick service. You know! I’m efficient and exper Lagi

$250 AUD dalam 3 hari
(10 Ulasan)
3.2
RemonRamzy04

Manual data scraping sir . Hello, sir! (First Bidder to offer this) I hope I will be awarded from you. ************I agree for any price you will set ** You can test me over chat before you award me! give it a try Lagi

$250 AUD dalam 3 hari
(3 Ulasan)
3.2
limillion819

Hi there. I am very interested in your proposal. I can instantly help you with your starting project with a successful completion. As a professional scrapper, I ensure for a perfect ongoing project. You will never Lagi

$700 AUD dalam 10 hari
(5 Ulasan)
3.3
dionisiotumbaga

Hi, I am interested. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.

$490 AUD dalam 6 hari
(4 Ulasan)
3.1