[TOOLS-64] dotted field names should produce nested objects in mongoimport - MongoDB

Details

Type: Bug
Status: Closed
Priority: Major - P3
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 2.8.0-rc0
Component/s: mongoimport
Labels:
None

Documentation Changes:
Completed
Epic Link:
Tools

Description

test file attached

Issue Links

is related to

TOOLS-57 Creating a document which contains key with dots (.) embedded is allowed with mongoimport

Closed

TOOLS-1335 mongoimport imports fields with dots (.)

Accepted

TOOLS-473 --upsertFields argument is not validated

Closed

DOCS-4439 In 2.8 mongoimport and mongoexport support nested/embedded documents

Closed

Activity

Comments

Ascending order - Click to sort in descending order

Hide

Permalink

Mathias Stearn added a comment - Aug 25 2011 10:51:21 PM +00:00

for some reason it wouldn't let me attach the file...

$ cat /tmp/test.csv
foo,bar.baz,bar.qux,_id
1,hello world,"hello, world",123
,"Hello
World",,12
asdf,asdf,asdf,1

Show

Mathias Stearn added a comment - Aug 25 2011 10:51:21 PM +00:00 for some reason it wouldn't let me attach the file... $ cat /tmp/test.csv foo,bar.baz,bar.qux,_id 1,hello world,"hello, world",123 ,"Hello World",,12 asdf,asdf,asdf,1

8 older comments

Hide

Permalink

Githook User added a comment - Dec 18 2014 09:05:06 PM +00:00

Author:

{u'username': u'deafgoat', u'name': u'Wisdom Omuya', u'email': u'deafgoat@gmail.com'}

Message: ~~TOOLS-64~~/~~TOOLS-70~~: add TSV support tests

Former-commit-id: c031252f537f6555f7a9a539af61906a02051223
Branch: master
https://github.com/mongodb/mongo-tools/commit/0eb1631256b8a58c17ee2e769d0fd1e5ac347c61

Show

Githook User added a comment - Dec 18 2014 09:05:06 PM +00:00 Author: {u'username': u'deafgoat', u'name': u'Wisdom Omuya', u'email': u'deafgoat@gmail.com'} Message: TOOLS-64 / TOOLS-70 : add TSV support tests Former-commit-id: c031252f537f6555f7a9a539af61906a02051223 Branch: master https://github.com/mongodb/mongo-tools/commit/0eb1631256b8a58c17ee2e769d0fd1e5ac347c61

Hide

Permalink

Githook User added a comment - Dec 18 2014 09:05:08 PM +00:00

Author:

{u'username': u'deafgoat', u'name': u'Wisdom Omuya', u'email': u'deafgoat@gmail.com'}

Message: ~~TOOLS-64~~/~~TOOLS-70~~: code review updates

Former-commit-id: 7071f24d047714ecccdf07727ec277516d076ed6
Branch: master
https://github.com/mongodb/mongo-tools/commit/ad2f74587d026d3becd71b1964782fe4906dc1d5

Show

Githook User added a comment - Dec 18 2014 09:05:08 PM +00:00 Author: {u'username': u'deafgoat', u'name': u'Wisdom Omuya', u'email': u'deafgoat@gmail.com'} Message: TOOLS-64 / TOOLS-70 : code review updates Former-commit-id: 7071f24d047714ecccdf07727ec277516d076ed6 Branch: master https://github.com/mongodb/mongo-tools/commit/ad2f74587d026d3becd71b1964782fe4906dc1d5

Hide

Permalink

Githook User added a comment - Dec 18 2014 09:05:11 PM +00:00

Author:

{u'username': u'deafgoat', u'name': u'Wisdom Omuya', u'email': u'deafgoat@gmail.com'}

Message: ~~TOOLS-64~~/~~TOOLS-70~~: clean up tests

Former-commit-id: 863b79a86e8730585f3e572f723418d66f4eb46d
Branch: master
https://github.com/mongodb/mongo-tools/commit/9268f4f6fec70d2025003ba364635ad1b8c28f86

Show

Githook User added a comment - Dec 18 2014 09:05:11 PM +00:00 Author: {u'username': u'deafgoat', u'name': u'Wisdom Omuya', u'email': u'deafgoat@gmail.com'} Message: TOOLS-64 / TOOLS-70 : clean up tests Former-commit-id: 863b79a86e8730585f3e572f723418d66f4eb46d Branch: master https://github.com/mongodb/mongo-tools/commit/9268f4f6fec70d2025003ba364635ad1b8c28f86

Hide

Permalink

Githook User added a comment - Dec 18 2014 09:05:14 PM +00:00

Author:

{u'username': u'deafgoat', u'name': u'Wisdom Omuya', u'email': u'deafgoat@gmail.com'}

Message: ~~TOOLS-64~~/~~TOOLS-70~~: fix validation check

Former-commit-id: deb3812f5b8ff8faa9d067443b951b0c64470793
Branch: master
https://github.com/mongodb/mongo-tools/commit/0cc08c83a6d45279a57cfb14b62a2035f5226c81

Show

Githook User added a comment - Dec 18 2014 09:05:14 PM +00:00 Author: {u'username': u'deafgoat', u'name': u'Wisdom Omuya', u'email': u'deafgoat@gmail.com'} Message: TOOLS-64 / TOOLS-70 : fix validation check Former-commit-id: deb3812f5b8ff8faa9d067443b951b0c64470793 Branch: master https://github.com/mongodb/mongo-tools/commit/0cc08c83a6d45279a57cfb14b62a2035f5226c81

Hide

Permalink

Sumit Sharma added a comment - Sep 02 2015 07:36:02 AM +00:00

This fix does not support Array type. I have exported my collection with hashtags as Array type and it has the header line as below

bei.hashtags.1.tag bei.hashtags.2.wt bei.hashtags.2.tag bei.hashtags.3.wt bei.hashtags.3.tag bei.hashtags.4.wt

now, when I am importing the same I am getting this as Object rather as as Array with below structure

"hashtags" : {
"0" :

{ "wt" : NumberInt(5), "tag" : "avgeek" }

,
"1" :

{ "wt" : NumberInt(5), "tag" : "FWWYN" }

,
"2" :

{ "wt" : NumberInt(1), "tag" : "gethereearly" }

,
"3" :

{ "wt" : "", "tag" : "" }

This index values are unnecessary and mongo import is not considering this number as Array index location.

Thanks
Sumit

Show

Sumit Sharma added a comment - Sep 02 2015 07:36:02 AM +00:00 This fix does not support Array type. I have exported my collection with hashtags as Array type and it has the header line as below bei.hashtags.1.tag bei.hashtags.2.wt bei.hashtags.2.tag bei.hashtags.3.wt bei.hashtags.3.tag bei.hashtags.4.wt now, when I am importing the same I am getting this as Object rather as as Array with below structure "hashtags" : { "0" : { "wt" : NumberInt(5), "tag" : "avgeek" } , "1" : { "wt" : NumberInt(5), "tag" : "FWWYN" } , "2" : { "wt" : NumberInt(1), "tag" : "gethereearly" } , "3" : { "wt" : "", "tag" : "" } This index values are unnecessary and mongo import is not considering this number as Array index location. Thanks Sumit

People

Assignee:

Wisdom Omuya

Reporter:

Ian Whalen

Votes:

5 Vote for this issue

Watchers:

15 Start watching this issue

Dates

Created:

Aug 25 2011 10:42:20 PM +00:00

Updated:

Jul 20 2016 09:21:50 PM +00:00

Resolved:

Nov 10 2014 09:43:09 PM +00:00

Agile

View on Board