MongoDB CSV Export: One Array/Column & Array Index on rows, or vice versa
0
votes
2
answers
4992
views
I have a MongoDB schema that looks like this:
const batchSchema = mongoose.Schema({
_id: mongoose.Schema.Types.ObjectId,
time: {type: [Number]},
tmp: {type: [Number]},
hum: {type: [Number]},
co2: {type: [Number]},
coolRelay: {type: [Boolean]},
humRelay: {type: [Boolean]},
fanRelay: {type: [Boolean]},
lightRelay: {type: [Boolean]},
});
My goal is to have a csv file I can import to excel for use in creating charts, graphs, and other visuals based on the data.
Using Studio 3T(https://robomongo.org/) , this doesn't seem to be possible unless I'm just not understanding the settings. Doesn't really matter if the data is organized horizontally or vertically. As long as each is on it own column/row, excluding the
_id
field. 3T seems to be only capable of placing them all along the same row.
I just tried using mongo's native cli csv export tool but found that didn't seem to come with my release. I'm running version 3.6 on openSuse, arm64, on a raspberry pi.
mongoexport
as a command was not found, and when I ran the suggested cnf mongoexport
to find a package containing it, nothing was returned either.
I know that I can export one file, per array using 3T, then cut/paste them together, however I hadn't planned on paying the annual license for 3T and was only using the free trial to get a more usable gui while in development. Was hoping to be able to write predefined bash script that could be reused repeatedly to export each "batch" document as it was completed.
Is there something I am missing about mongoexport or is this a limitation of the aarch64 release? I really don't want to have to go back, learn, and re-write everything for postgreSQL at this point. I mean, I will if I have to, but wanted to check in with you all first.
Asked by AustinFoss
(119 rep)
Mar 31, 2019, 03:00 AM
Last activity: Apr 18, 2025, 09:00 AM
Last activity: Apr 18, 2025, 09:00 AM