This is NOT a manual entry job. This project requires you to create a small program or to create a script inside excel.
I have created an excelsheet ([url removed, login to view]) 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 ([url removed, login to view]). 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) [url removed, login to view]
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 ([url removed, login to view]) 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 [url removed, login to view]) 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 [url removed, login to view] 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!