[COMPASS-4466] String field "1" is converted to boolean in export Created: 20/Oct/20  Updated: 29/Oct/23  Resolved: 17/Nov/20

Status: Closed
Project: Compass
Component/s: Import/Export
Affects Version/s: 1.22.1
Fix Version/s: 1.24.1

Type: Bug Priority: Major - P3
Reporter: Rhys Howell Assignee: Michael Rose (Inactive)
Resolution: Fixed Votes: 0
Labels: good-first-issue
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to COMPASS-4460 Empty strings are converted to “false... Closed
Story Points: 3
Documentation Changes: Not Needed
Sprint: Iteration Quince

 Description   

From slack conversation:
"When exporting to CSV a field with “1” string type, CSV is being taken as boolean and shows TRUE in the table as you can see in thread.This doesn’t happens when you export data via the Shell with mongoexport command."

Data set has documents with a field with a string value: "1", "2", "3", or it's empty
Cases where the documents have "1" as the string value have their values as TRUE in the exported csv.



 Comments   
Comment by Githook User [ 19/Nov/20 ]

Author:

{'name': 'Michael Rose', 'email': 'michael_rose@gmx.de', 'username': 'rose-m'}

Message: fix(compass-import-export): Pre-fill export filename and fix auto-conversion of strings COMPASS-4466 (#2055)
Branch: 1.24-releases
https://github.com/mongodb-js/compass/commit/b6f861ff7da9753fb875eafd95f8c6d8e06450b8

Comment by Githook User [ 16/Nov/20 ]

Author:

{'name': 'Michael Rose', 'email': 'michael_rose@gmx.de', 'username': 'rose-m'}

Message: fix(compass-import-export): Pre-fill export filename and fix auto-conversion of strings COMPASS-4466 (#2055)
Branch: COMPASS-4499-add-aggregation-stage-tooltip
https://github.com/mongodb-js/compass/commit/b6f861ff7da9753fb875eafd95f8c6d8e06450b8

Comment by Githook User [ 16/Nov/20 ]

Author:

{'name': 'Michael Rose', 'email': 'michael_rose@gmx.de', 'username': 'rose-m'}

Message: fix(compass-import-export): Pre-fill export filename and fix auto-conversion of strings COMPASS-4466 (#2055)
Branch: master
https://github.com/mongodb-js/compass/commit/b6f861ff7da9753fb875eafd95f8c6d8e06450b8

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