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 anyone please explain HOW the source directories should be arranged, I have the stack-overflow xml dump (users.xml , posts.xml , votes.xml) inside a directory , I select it as the source directory , but can't get them imported , it tells me "Invalid source path." and also the sites list is empty!
Yes, the user is no longer an active member of Stack Overflow. You can find more information on this page in the API docs:
This affects "shallow user" fields most frequently.
For example, this question's owner has been deleted (a very rare occurrence). An API query for that question returns no user accordingly.
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.
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 ...