Trouble with mongoexport -query command

Question

I am trying to export a subset of documents that contain a specific ObjectId from a collection of Twitter searches. To do this, I am using the following script:

mongoexport --db twitter --collection tweets --csv --fieldFile CSVfields.txt --out .\tweets.csv --query query.txt

...where CSVfields.txt references the specific document keys that I want in the export and query.txt contains:

{ "search" : ObjectId("525f9cfdb3685db029000001") }

When I run this, I get an error saying:

assertion: 16619 code FailedToParse: FailedToParse: Expecting '{': offset:0

Any idea what I am doing wrong?

Thanks!

Gergo Erdosi · Accepted Answer · 2014-06-11 21:57:16Z

1

--query takes a JSON query, not a file.

So either of the following should work:

mongoexport --db twitter --collection tweets --csv --fieldFile CSVfields.txt --out .\tweets.csv --query `cat query.txt`

mongoexport --db twitter --collection tweets --csv --fieldFile CSVfields.txt --out .\tweets.csv --query '{ "search" : ObjectId("525f9cfdb3685db029000001") }'

edited Jun 11, 2014 at 21:57

Gergo Erdosi

42.3k21 gold badges122 silver badges95 bronze badges

answered Oct 18, 2013 at 19:14

Daniel Coupal

8256 silver badges9 bronze badges

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

2 Comments

jim_jones Over a year ago

Thanks Daniel for the response. I had tried the second option but not the first. Both keep giving me this error which I seem to be getting with everything I try: "ERROR: too many positional options"

jim_jones Over a year ago

I figured it out. My console wasn't escaping the JSON argument. When I nested my quotations starting with " and then ', it did the trick. This syntax worked: mongoexport --db twitter --collection tweets --csv --fieldFile CSVfields.txt --out tweets.csv --query "{ search : ObjectId('52613e36b3685db029000004') }"

Collectives™ on Stack Overflow

Trouble with mongoexport -query command

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related