[COMPASS-4971] CSV export omits explicitly included fields Created: 24/Jul/21  Updated: 03/Oct/23  Resolved: 17/Feb/22

Status: Closed
Project: Compass
Component/s: Compass, Import/Export
Affects Version/s: 1.28.1
Fix Version/s: 1.31.0

Type: Bug Priority: Major - P3
Reporter: Jason R. Coombs Assignee: Leonardo Rossi (Inactive)
Resolution: Done Votes: 2
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

macOS 11.5


Attachments: PNG File image-2021-07-24-15-02-38-549.png     PNG File image-2021-07-24-15-03-53-914.png     PNG File image-2021-07-24-15-04-19-779.png    
Issue Links:
Duplicate
is duplicated by COMPASS-5363 Adding Fields to csv export does not ... Closed
Related
related to COMPASS-4332 Compass doesn't export all existing f... Closed
is related to COMPASS-5700 CSV export doesn't contain fields man... Closed
Story Points: 3
Documentation Changes: Not Needed
Sprint: Iteration Seoul, Iteration Utica, Iteration Versailles

 Description   

Since https://jira.mongodb.org/browse/COMPASS-4332 was closed as fixed and not re-opened when users reported that the issue wasn't fixed, and since I encountered the issue with the latest stable release, I'm reporting a new issue.

Problem Statement/Rationale

There are two issues: First, when exporting a collection, not all the fields in the collection are present in the selection dialog.

It would be nice if the selection dialog included fields at least from the first and last documents of the collection if not a sample of the whole collection.

Second, and more importantly, even if one explicitly adds the missing fields to the export, they're not included in the export.

~ $ head -n 2 ~/Desktop/statuses.csv
_id,bps,ch,lock,pps,seq,snq,ss
60f9e3b8970d2eea35726954,0,auto:34,atsc3,0,0,100,100

Steps to Reproduce

Create two documents in a collection, {'a': 1} and {'b': 2}. Attempt to export the collection to CSV and have `b` appear in the output. Can't be done.

Expected Results

What do you expect to happen?

It should be trivial to export the full collection to CSV.

Actual Results

What do you observe is happening?

Fields are missing from the export.

Additional Notes

Any additional information that may be useful to include.



 Comments   
Comment by Jason R. Coombs [ 08/Apr/22 ]

Confirmed that 1.31.1 does address the issue for explicitly included fields.

Comment by Githook User [ 25/Feb/22 ]

Author:

{'name': 'Leonardo Rossi', 'email': 'leonardo.rossi@gmail.com', 'username': 'leorossi'}

Message: bug(compass-import-export): Include manually added fields in CSV output COMPASS-4971 (#2784)
Branch: 1.31-releases
https://github.com/mongodb-js/compass/commit/52f3c27c5e5d6bce8627246539dbc81e58a85ab1

Comment by Githook User [ 23/Feb/22 ]

Author:

{'name': 'Leonardo Rossi', 'email': 'leonardo.rossi@gmail.com', 'username': 'leorossi'}

Message: bug(compass-import-export): Include manually added fields in CSV output COMPASS-4971 (#2784)
Branch: COMPASS-5506-update-item
https://github.com/mongodb-js/compass/commit/52f3c27c5e5d6bce8627246539dbc81e58a85ab1

Comment by Githook User [ 22/Feb/22 ]

Author:

{'name': 'Leonardo Rossi', 'email': 'leonardo.rossi@gmail.com', 'username': 'leorossi'}

Message: bug(compass-import-export): Include manually added fields in CSV output COMPASS-4971 (#2784)
Branch: move-query-history-to-left-of-query-bar
https://github.com/mongodb-js/compass/commit/52f3c27c5e5d6bce8627246539dbc81e58a85ab1

Comment by Githook User [ 22/Feb/22 ]

Author:

{'name': 'Leonardo Rossi', 'email': 'leonardo.rossi@gmail.com', 'username': 'leorossi'}

Message: bug(compass-import-export): Include manually added fields in CSV output COMPASS-4971 (#2784)
Branch: remove-bootstrap
https://github.com/mongodb-js/compass/commit/52f3c27c5e5d6bce8627246539dbc81e58a85ab1

Comment by Githook User [ 18/Feb/22 ]

Author:

{'name': 'Leonardo Rossi', 'email': 'leonardo.rossi@gmail.com', 'username': 'leorossi'}

Message: bug(compass-import-export): Include manually added fields in CSV output COMPASS-4971 (#2784)
Branch: e2e-aggregations
https://github.com/mongodb-js/compass/commit/52f3c27c5e5d6bce8627246539dbc81e58a85ab1

Comment by Githook User [ 17/Feb/22 ]

Author:

{'name': 'Leonardo Rossi', 'email': 'leonardo.rossi@gmail.com', 'username': 'leorossi'}

Message: bug(compass-import-export): Include manually added fields in CSV output COMPASS-4971 (#2784)
Branch: main
https://github.com/mongodb-js/compass/commit/52f3c27c5e5d6bce8627246539dbc81e58a85ab1

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