MongoDB - delete record

david_r wrote:

Did you set feature operation accordingly?

Yes. The error mentioned above would be the result. It seems that no delete is available for MongoDB, or I'm wrong?

 

 

david_r wrote:

Which version of FME are you using?

FME Desktop 2017.0.1.1 (32-bit) - Build 17291

 

 

irena_mitton wrote:

Yes. The error mentioned above would be the result. It seems that no delete is available for MongoDB, or I'm wrong?

 

 

Excellent question, the docs aren't very clear about it: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/mongodb/mongodb-ft-param-w.htm

 

Hopefully someone from Safe can help... @RylanAtSafe @NatalieAtSafe

 

Hi @irena_mitton

 

FME currently does not support update and deletes with MongoDB yet, even with the presence of the fme_db_operation. I have filed a PR to rectify the documentation, to better document the MongoDB operations we currently support.

 

 

In the meantime, if you would like MongoDB Updates and Deletes to be implemented into FME, please create an idea over on the ideas page: https://knowledge.safe.com/content/idea/list.html

 

Developers use this when looking at which features should be updated with new functionality!

I hope that helps.

trentatsafe wrote:

Hi @irena_mitton

 

FME currently does not support update and deletes with MongoDB yet, even with the presence of the fme_db_operation. I have filed a PR to rectify the documentation, to better document the MongoDB operations we currently support.

 

 

In the meantime, if you would like MongoDB Updates and Deletes to be implemented into FME, please create an idea over on the ideas page: https://knowledge.safe.com/content/idea/list.html

 

Developers use this when looking at which features should be updated with new functionality!

I hope that helps.

Thank you! Yes, at least just to know and eventually add the feature in the next version. ;)

 

The update itself is available for MongoDB (FME Desktop 2017.0.1.1) by setting "Feature Operation = Put" and "Table Handling = Use Existing".

 

 

irena_mitton wrote:

Thank you! Yes, at least just to know and eventually add the feature in the next version. ;)

 

The update itself is available for MongoDB (FME Desktop 2017.0.1.1) by setting "Feature Operation = Put" and "Table Handling = Use Existing".

 

 

Hi @irena_mitton,

 

There is a subtle difference between Updates and Puts for MongoDB.

 

 

If the existing record is : "A" : 'a', "B" : 'b'

 

and you have a new record : "B" : 'b', "C" : 'c'

 

 

Put will change the results to:

 

"B" : 'new b', "C" : 'new c'

 

Update would change the results to:

 

"A" : 'a', "B" : 'new b', "C" : 'new c'

 

 

I hope that helps.