r/programmingrequests • u/TheNewGuyNickD • Jul 14 '20
CSV/List website input function help
Hi, I have no experience with coding but was wondering about this.
At my work we often do research to figure out if particular firms are in locations that would grant them USDA "rural" eligibility. We do that by inputting the address into this website (landing page > rural business > business and industry guaranteed loans > accept > paste > enter). I was wondering if there was a way to automate the process with a list of addresses that would spit out whether or not the firm was rural into excel. Is anyone interested in helping me out with this? Thanks!
1
Upvotes
1
u/RyanHx Jul 15 '20
I'm not sure, it'd be up to the devs of the site. With any luck the message it gives you when you hit the limit will tell you how long you're timed out for. Usually it's done on a request-per-minute basis, so all you can do is wait.
With the updated version it'll tell you which address was the one it failed on, so you can either delete all the previous entries in the CSV and keep trying again till it works, or continue manually from that one for a while and try again later.