Path Collision trying to Export Collection

Working with Data Developer Tools
#1

I’m completely new to Mongo so please bear with me. I’m using Compass and I’m able to view collections, query the data, etc. Everything is working fine.

When I try to export a whole collection, on most collections, it works fine.

When I tried to export 1 collection (all fields) to a CSV file, I get an error:

Path collision at Contact.Email remaining portion Email

I’m not selecting individual fields, or doing anything crazy. I’m just trying to export the whole collection.

I noticed that when I view the documents in the collection, I don’t even see the offending fields.

Screen Shot 2021-07-20 at 9.46.52 PM
Screen Shot 2021-07-20 at 9.46.52 PM1520×602 64.5 KB

#2

What is your Compass version?
Could be bug with latest version
Check this link

https://jira.mongodb.org/browse/COMPASS-4723?jql=project%20%3D%20COMPASS%20AND%20fixVersion%20%3D%201.24.1

#3

I’m having the same issues and I’m running the most recent Compass version.

#4

Did you try with lower version of Compass?

or try the fix given in that link-unselect the fields causing the error

#5

Hi,

I am facing the same issue while exporting a particular collection from compass version 1.30.1, I tired to omit the offending column, it stuck at next column.
However, I am able to export other collections.

Hope you can suggest a solution.

Thank you.
Siva

#6

Did you try with mongoexport from command line?
or use a lower version of Compass
Show the sample doc
How many records in this collection?

#7

Hi Ram,

Thanks for the response.

No, I did not try the command line option for export, I will try.

If compass version is the issue, I was able to export another document “Grades”.

The document that I am trying to export is “companies” under sample_training, it is having 9.500 records and of size 15.9MB.

The document and fields are too long to give here.

Cheers
Siva

#8

I’ve got the same issue.
My solution is:

  1. go back to “select fields”
  2. uncheck “contact.email” (and uncheck all fields under “contact”)
    The object-type “contact” will include all necessary data

It’s strange that some object-type is ok but some has issue… I’m not sure why

1 Like