In this project, I want Data Scraped from websites into a MS Access VBA Script with Form and CSV Tab Delimited Output file.
This project requires you to do the following:
• Create a form with the following options:
o Add New Sites
o Modify Existing Sites
o Add New Fields
o Modify Existing Fields
o Check for Duplicates
o Create Output
• Tool to scrape different websites and store the data in MS Access tables called SITENAME
o SITENAME table should store all the required data to scrape individual websites
Each site can have different class or div elements that will be used when scrapping that site.
o As part of this project I will give you 2 URL’s for you to set up Scrape and store data. Data scraped should be in a new table SITENAME-DATA table – one table for each site. This will allow to check for duplicated data when site is re-scraped in the future.
Ability to add additional sites in the future
Ability to add additional fields in the future
o Option in the script to check for duplicate data in the Event Name field in the SITENAME-DATA table and chose yes/no to have it included in the output CSV file.
o Create a CSV output file in UTF-8 Tab delaminate with the data below:
Ability to have some fields prepopulated based on the site that being scrapping OR scrapped (see valid data below).
Three of the data fields will be dates and I will need to be modified and formatted UTF-8 M/D/YY HH:MM for the CSV output.
The field titles and info that I want for each field of my output:
Event Name Valid Data: text from site
Description Valid Data: text from site // or text that I enter should allow me to concatenate Event Name and Location with other words.
Start Date Valid Data: text from site Format: UTF-8 M/D/YY HH:MM
End Date Valid Data: text from site Format: UTF-8 M/D/YY HH:MM
Logo Valid Data: will be a URL scraped from site with the image // or a URL that I enter
Location Valid Data: I want to enter and store this based on the site being scraped
Website Valid Data: URL from site scraped // or a URL that I enter
Website Title Valid Data: this will be the same data as the Event Name
43 freelancere byder i gennemsnit $507 på dette job
I am an expert scraper and delivered many projects Relevant Skills and Experience proven track record in crawling and scraping on this site Proposed Milestones $333 USD - milestone
Hello,i am highly experienced in web scraping and data search. I can scrap any website. Relevant Skills and Experience Web Scraping Proposed Milestones $277 USD - Please ping me lets discuss before starting the task.
Hi, I can do this in a day, done it a lot of times. Please send me a message if you're interested. Relevant Skills and Experience 8 years Proposed Milestones $1000 USD - completed solution