Very useful tool and very well programmed. However, it doesn't work with latest Aug-2012 data dump. Probably XML schema of dumped data changed from previous version, and now for questions and answers without views, the value for the attribute ViewCount is an empty string. That cause the error mentioned by others in this post "Input string was not in a ...
Can you add a green to the votes to random questions on the whole questions list which are accepted by owner and add a checkmark on the accepted answer of question?
On the questions page:
On 2nd accepted question from questions page:
The accepted answer bumps to the top of the answers list unless it is the question asker's own answer, by ...
You can get the schema for the data dump and SEDE in this Meta Stack Exchange post.
The architecture of the production database is not available to non-corporate customers (if it's available at all). But, you can grab one of the public domain Stack Exchange clones; their schema is no-doubt similar.
This is not an official API, but it is not too hard to simulate the login via OAuth2 and use the session to start executing a query, poll the job that executes it and retrieve the results in the end. I do most of my Stack Exchange development work in Java, but it should be easy to port to other languages even if you don't know Java. I'm using fairly standard ...
The case sensitivity in the error message turns out to be the culprit.
I had to disable case sensitive table names in MySQL on a linux host. In the my.cnf, add lower_case_table_names = 1. Restart MySQL. This bypasses the case sensitivity of the underlying file system for storing the MySQL data.
I was on the right track by trying to maually create the ...
I've been searching for a Stack Exchange offline version, for research purposes at my University, then I found this.
I have been trying to figure out how to exactly run the software program on my Mac OS X Yosemite. I have downloaded the entire data dump and everything that it requires:
Python, version 2.7.12
Java, version 1.8....
Additionally, if you need to import a data-dump to PostGreSQL (or MS-SQL), this will help:
It's very efficient with memory consumption, it uses the original schema, it checks the data (serialization to type - exception if invalid), and it works on Linux/Mono, too.
You could also add Firebird ...