This little piggy went wee all the way home: Exporting your Oink data
I was an avid Oink user and was saddened to see it go away. Alas, services come and go and it's all good as long as you can export your data, right? Wrong!
Oink provided a bunch of CSVs and photos in a zip. CSVs tend to be messy to work with. I needed a JSON with all the information about the places and items. Instead the information provided by the Milk team was minimal (rating, reviews, foursquare_id). They didn't even include the name of the place visited!
I had to make sense of all this data in order to eventually export the data to another service (like Evernote). So, I wrote a Python script which outputs a nicely formatted JSON of all the Oink items including locations.
Script Features
- Exports to single JSON file
- Includes foursquare venue info (name, lat, long, address, etc.)
- Removes entries with no location
- Merges comments and ratings for those available
Requirements
- Oink export CSV (can be requested on http://oink.com)
- Foursquare OAUTH token (see section below)
- Python
- Terminal
Part 1: Get Foursqaure OAUTH Token
- Visit https://developer.foursquare.com/docs/explore#req=users/self
- Your token is everything after "OAuth token automatically added. https://api.foursquare.com/v2/users/self?oauth_token="
Part 2: Execution Instructions
- Copy oink_export.py to same folder as your Oink CSVs
- Open terminal to Oink CSV folder
- Run 'python oink_export.py --token=YOUR_OAUTH_TOKEN_HERE'
- Watch it fly through your data
Explore more here:

