This is NOT a manual entry job. This project requires you to create a small program or to create a script inside excel.
Project details:
I have created an excelsheet ([login to view URL]) attached that I would like to automatically update.
Your program/script will do two things: 1) It will read the artist name from the excelsheet and search the corresponding information from the web ([login to view URL]). 2) It will return and update the values in the excelsheet. (It needs to be flexible enough to allow me to edit the information in case it does not pull the correct information).
The information I need to automatically update is 3 pieces of information:
1) Last album name (main studio albums only, not compilation albums, single or eps)
2) Last album release date (month/day/year)
3) Last review date (month/day/year)
For the sources, I would like to use:
For 1+2) [login to view URL]
For 3) i will give you a link to a website that i created, but that requires login info. So your program/script should be flexible enough to allow me to update the username/password.
A sample excel sheet ([login to view URL]) is attached. I will enter the artist name and everything else should fill out/update automatically. For artists we cannot match, we simply leave it blank or I enter it by hand afterwards so that I can maintain that excelsheet. I will add new artists almost every day.
I also attached a first attempt (called [login to view URL]) at creating the solution to this project so you have an idea how it should work. Instead of the year it should list the exact album date, so that it can be used to make some calculations as you can see in the [login to view URL] file. In the end, format should look exactly as in sample.xls.
I have 3 other projects where I need someone to extract data from websites, etc and create some scripts. If you are good we can immediately continue with those as well.
If you have any questions, feel free to ask me. Need this asap!Thanks!