Convert JSON data to BSON on the command line

Question

I'm on an Ubuntu system, and I'm trying to write a testing framework that has to (among other things) compare the output of a mongodump command. This command generates a bunch of BSON files, which I can compare. However, for human readability, I'd like to convert these to nicely formatted JSON instead, which I can do using the provided bsondump command. The issue is that this appears to be a one-way conversion.

While I can work around this if I absolutely need to, it would be alot easier if there was a way to convert back from JSON to BSON on the command line. Does anyone know of a command line tool to do this? Google seems to have come up dry.

I don't follow. What's the goal with the BSON file that you would create? — WiredPrairie
– WiredPrairie, Commented Jun 27, 2013 at 19:11
To then load back into the Mongo DB. Essentially I want the following connectivity: Mongo <-> BSON <-> JSON I have 3 out of the 4 links required to make this work. — Jonathan
– Jonathan, Commented Jun 27, 2013 at 19:14
Honestly, didn't realize there were two sets of import/export tools here. I'm still incredibly new to Mongo. From the mongoimport docs, I read "... Do not use mongoimport and mongoexport for full instance, production backups because they will not reliably capture data type information. Use mongodump and mongorestore ..." -- Not sure exactly what information is and isn't captured, but I think I'm going to play it safe and stick with importing the BSON dumps. That way I know the test tests every single record in the DB. — Jonathan
– Jonathan, Commented Jun 28, 2013 at 13:45
I don't follow your comment, nor why you're trying to import data via the command line tools for testing. (Why are you trying to reimport data that was exported)? A JSON file cannot necessarily represent all of the data types of BSON adaquately for the purposes of an import. — WiredPrairie
– WiredPrairie, Commented Jun 28, 2013 at 14:48

Webveloper · Accepted Answer · 2015-05-09 23:35:54Z

1

I haven't used them, but bsontools can convert from json, xml, or csv

answered May 9, 2015 at 23:35

Webveloper

1,07910 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jonathan · Accepted Answer · 2013-07-31 16:45:38Z

0

As @WiredPrarie points out, the conversion from BSON to JSON is lossy, and it makes no sense to want to go back the other way. Workarounds include using mongoimport instead of mongorestore, or just using the original BSON. See the comments for more deails (adding this answer mainly so I can close the question)

answered Jul 31, 2013 at 16:45

Jonathan

2,2632 gold badges15 silver badges17 bronze badges

Comments

menfon · Accepted Answer · 2018-10-27 12:50:39Z

0

You can try beesn, it converts data both ways. For your variant - JSON -> BSON - use the -x switch.

Example:

$ beesn -x -i test-data/01.json -o my.bson

Disclaimer: I am an author of this tool.

answered Oct 27, 2018 at 12:50

menfon

1,8572 gold badges15 silver badges31 bronze badges

Collectives™ on Stack Overflow

Convert JSON data to BSON on the command line

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related