1) Allow the user to specify the row in the target file to begin at when scraping (this would help in the event of unexpected interruptions, to pick back up where the interruption occurred). I found that for some reason my Norton 360 had interrupted the macro from trying to surf to docket navigator, after allowing it nearly 1000 times, it suddenly though docket navigator was a fishing sight. This happened at least twice, thus interrupting the run. Being able to restart the run from a specific row in the file that lists the URLs would be useful.
2) Also I have a need to scrape more data than the “PTAB Institutions” button provides. I would also like to scrape the “Determinations” button, but only when the “PTAB Institutions” “Result” field was NOT “Denied”. When the result is Denied, there will be no Determination to scrape. I’d like the scrape the determination and date to the same file as the rest of the data.
3) I would also like to be able to scrape data from the docket entries, button. I would like to see if there was an appeal - this corresponds to a "notice of appeal" entry in the docket entries. happy to walk through this during chat if confusing.
Currently we have the following columns:
"Case Number Patents Grounds Claim Numbers Result Date"
to these columns I would like to add these additional columns:
"Determination Date CAFC Appeal Date"
where "CAFC Appeal" would be yes or no and "Determination" might be "cancellation', for example
Setup is the same as the prior project, to use Excel VBA macro, and delivery the source code.
If there is anyway to speed up the scraping without overloading the docket navigator site this would be a plus.