mongodb - mongoexport export data

Question

I was using mongoexport to export data to csv format, and found that the data in some fields would be lost. I checked in the database and found that there was data in this field, but it was indeed missing in the exported table, and not every piece of data was there. It’s all like this. There are a few cases where this happens. I’ve looked for it myself but can’t find the reason. I’d like to ask some experts

Answer 1

It is recommended to open the exported file with a text editor first to see if it is really lost. From my personal experience, different editors have different support for CSV. I have indeed seen cases where the exported CSV to Excel does not display properly when opened.
First you have to post the abnormal parts.

Answer 2

It is recommended to check and provide the following information:

1. Export log error/alarm information;

2. Characteristics of fields with data loss;

3. Whether the field to be exported is an array, and if so, whether the format of the export command is written correctly.

For reference.

Love MongoDB! Have Fun!