Scrab web table data
$30-250 USD
S-au achitat serviciile după ce au fost prestate
Summary of Project
This program should be batch a program. No UI required. Program should run from a properties file.
Objective is to query a public website( aspx website) , scrap the resulting table data to an excel file(column names come from table header on webpage) and use the scrapped data to query another page and enhance the data.
Property file Details
URL1
URL2
Query criteria 1: Should be stored in properties file. The file should ask for html element id ( name/whatever you need to fill element value) and value for that field to be used as query criteria.
Query criteria 2nd query: Should be stored in properties file. The file should ask for html element id ( or name) and excel column name(created in step1) for value of query criteria.
Steps to browse website
PHASE 1
1. Go to URL
2. Click on 2nd tab and Enter filter criteria from a properties file
3. hit search button
4. Click View button next to each record to go to next level.
5. Click "Get data" button on second level page.
6. Page will display one more table.
7. look for keyword "cancellation" in the new table
8. if found, update the record with cancel
9. for each record that is not cancelled get more details for it.
PHASE 2
9a. got to URL
9b. Get column(from properties file) values from excel sheet row, fill in search criteria for html element id ( names/or whatever u need) from properties file with values from excel column value
9c. click search button
9d. Add columns to the excel for all the labels in html if not present ( first time)
9e. Populate value for each column created for the current row.
9f. GO TO STEP 9 till last record.
ID Proiect: #426186
Detalii despre proiect
18 freelanceri plasează o ofertă medie de 121$ pentru proiect
This can certainly be done using Excel VBA. Please allow some days for communication, timeline difference, etc. I am ready to start IMMEDIATELY. Please refer to PM.
I am interested in this project and I am an expert in data mining and extraction. Looking forward to your cooperation.