Re:Ask HN: If your job involves continually importing CSVs, ...
by iamwil on Thursday December 29, 2016 @01:09AM
(#13275923)
Oh, so like information from data.gov or other public data to verify people. That makes sense.
I'm guessing small businesses want to do integration with the web, but they didn't really have the engineers to do an API integration?
Re:Ask HN: If your job involves continually importing CSVs, ...
by byoung2 on Thursday December 29, 2016 @09:50AM
(#13277511)
Some of these companies didn't even have the data in CSV format...we had to buy it from another vendor in CSV form (https://www.aggdata.com).
Previously I worked for a company that provided a dashboard for small businesses to manage their listings (Yelp, Facebook, Google, Tripadvisor, etc). For multilocation clients, for initial setup we needed a list of all locations, addresses, phone, etc., and not a single client said "here's our api, grab the data in JSON format". Instead, we always got a CSV. We eventually gave them a CSV template file for them to copy/paste into.