I want convert some bson file to some json file. I do it by the using of bsondump function.
bsondump exemple.bson > example.json
By the old version 2.4.9 of the bsondump (depended on the version of mongodb) I get right output in the form of valid JSON file (it is actually some dictionary with the key-value pairs). Occasionaly I did upgrade for my system and have now mongodb 2.6.3. It has a concequence for my output... If some value in the dictionary is numeric, every time I get additional supplement to my number in the form of:
For me is important to have the output in the simple form:
because I want import my JSON file in the Python code. In the Python code I use Pandas to convert my JSON to DataFrame. For this I use
function, which get me the error message, because it can find the valid JSON string. I want read the JSON direct in the pandas, consequently I need the valid JSON format. My question is, how I can get direct the valid JSON format after upgrade in the version 2.6.3. Currently I did a code to remove "NumberLong" in every line, but I have the files with the huge number of lines, consequently it is the question of the time. How I can get the valid JSON format with the new version of the MongoDB?