[COMPASS-3451] CSV export fails to include all collection fields as output variable (columns) Created: 06/Feb/19  Updated: 06/Apr/22  Resolved: 16/Aug/19

Status: Closed
Project: Compass
Component/s: Compass
Affects Version/s: 1.16.3
Fix Version/s: None

Type: Bug Priority: Minor - P4
Reporter: Brian Blevins Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: File people-with-missing-fields.json    
Issue Links:
Related
is related to COMPASS-2841 Export to CSV creates date strings wi... Closed
is related to COMPASS-2843 Export to CSV or JSON ignores query P... Closed
Tested
tested by COMPASS-3824 Test behavior of new feature in relat... Closed

 Description   

In testing, it appears that the CSV export only includes the document fields found in the "first" document (natural order?) in the collection. This is true even after performing a schema analysis that does find all fields in the collection's documents.

Reviewing the exported CSV file, it appears that columns (variables) are missing.



 Comments   
Comment by Massimiliano Marcon [ 16/Aug/19 ]

We are reimplementing the import/export feature so we won't fix existing bugs. However, we will use existing bugs as a guideline for testing the new implementation.

Comment by Massimiliano Marcon [ 19/Feb/19 ]

viru4viren thank you for your comment.

We have in the backlog a set of improvements for the import/export functionality, I added this to the list as well. For the time being, as a workaround you can use mongoexport. We expect to expose a similar functionality in Compass at some point.

Comment by Virendra [ 07/Feb/19 ]

When i convert my collection into csv it there is lots of fields are missing.My collection is belongs to contacts so all person not having phone number or anniversary so there is less or more fields in each row.So please help me.

 

Generated at Wed Feb 07 22:33:14 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.