News for hackers. Stuff that matters.
Re:Ask HN: If your job involves continually importing CSVs, ... by byoung2 on Thursday December 29, 2016 @12:57AM (#13275890)
I am currently working on a project for a client in real estate management. They are aggregating data from state licensing agencies, insurance rating agencies, etc., and there are a lot that only provide CSV data. I imagine on the other side of the fence there is some guy or gal managing all this info in Excel, and CSV is the easiest path for the data to flow out.

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.

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).