OpenNews's Source publishes articles by and for newsroom developers and data journalists on tools, data analysis, and visualization.
Commenters call it the watercooler for news nerds and link it for its OCR tool comparison and the Tabula PDF table extractor.
Hi there, I'm the senior dev for NPR Visuals and the person who worked on White Lies (linked above, for which we did, in fact, use this guide). As a general rule, I don't comment here. But I did think this is worth responding to, because it speaks to the degree to which newsroom developers are still not visible even within the industry, much less outside.
At this time, NPR's News Apps team is about five people, for a large national newsroom. That's actually pretty small! If you look at the kinds of teams that do this kind of work at places like the LA Times (which has both a graphics department and an award-winning Data Desk) or the NYT (last I checked, they had 40+ people on their graphics desk, plus an interactive team in editorial that works on projects like elections) or the Washington Post (big and still hiring). But many newsrooms (both print and broadcast) have at least small teams or single devs that work on big projects like this, even if they're not "flush with staff." That's because having an interactive team inside editorial is a force-multiplier for digital journalism--it lets us combine writing, video, audio, animation, and data in ways that makes the entire package better, so that hopefully people are more likely to pay for it.
And if you have a team, you need a procedure for managing their resources and producing quality work, and that's all this document is. Sure, it's 38 pages long, but a few points: A) we don't follow this letter-by-letter on every…
Look for information you would want to see in your available media -- find a dataset and build it into a useful app to be filtered and queried in different ways. Map data points to physical locations. Correlate those things. At some point it all starts to look like a population density heat map, but sometimes you find good stuff in there. And people want to see it. They need more tangible access to all the real world data we have been collecting. Otherwise, what's the point?
I worked for a year at a newspaper and built apps and stuff like that -- it was the most fulfilling work I've ever done and I wish the situation had been able to work out. If I ever get a chance to do real news apps again, I would jump on it. Enjoy your opportunity, Anders, and be prepared to show your work.
Sometimes, the phrase "if you build it, they will come" is applicable. If you build something that shows you CAN build something, show it to the right people and you will attract attention.
Some inspiration:
http://blog.apps.chicagotribune.com/
http://blog.apps.npr.org/
https://source.opennews.org/en-US/
http://flowingdata.com/
The New York Times | New York, New York | Onsite | Full-time
Come work in the newsroom of The New York Times and write code to shape the future of journalism. The Interactive News Team is looking for full-stack developers (ones with ops experience would be particularly welcome at this point) who care about the news and want to help make it better.
We believe in work-life balance, shipping working products, and open source. Working in a newsroom isn't like working at a startup or a big company. Try it, you'll like it.
Full job description: http://www.nytco.com/careers/newsroom/interactive-news-developer/
Apply by emailing newsdev-jobs@nytimes.com
More about the NYT: https://news.ycombinator.com/item?id=9038615
And the journalism and code commnunity: https://source.opennews.org/en-US/organizations/new-york-times/
Our open source code: https://github.com/newsdev/ https://github.com/nytimes/
Other NYT tech jobs: http://www.nytco.com/careers/technology/
You do not want OCR for this. You want either ABBYY FineReader (around $99 for a license), or, if you prefer open source, Tabula:
https://source.opennews.org/en-US/articles/introducing-tabula/
The main advantage of ABBYY is that if you need to do OCR, it is, in my opinion, the best consumer-level package. And it does a pretty good job of doing OCR and conversion to Excel. Here's a Github repo that demonstrates some results:
https://github.com/dannguyen/abbyy-finereader-ocr-senate
But to reemphasize, the above repo demonstrates ABBYY maintaining table structure with PDFs that are scanned images, which is considerably harder than the situation you're in.
I've started a repo that eventually will compare text-to-table tools, which is what you want: https://github.com/dannguyen/pdftotablestable
The project is on GitHub at https://github.com/cantino/huginn
You can also use Huginn to automate many other processes. It's basically an open source IFTTT.
I also learned recently that it's being used at the New York Times: https://source.opennews.org/en-US/articles/open-source-bot-factory
Here is another article about how to use Huginn to send you weather alerts: http://blog.andrewcantino.com/blog/2014/01/12/never-forget-your-umbrella-again-with-huginn
Details about the redesign and technology overhaul: http://source.opennews.org/en-US/articles/behind-scenes-nyt-redesign/
i.e. "… using Github instead of SVN for version control, Vagrant environments, Puppet deployment, using requireJS so five different versions of jQuery don’t get loaded, proper build/test frameworks, command-line tools for generating sprites, the use of LESS with a huge set of mixins, a custom grid framework, etc."