Skip to main content
  • EN

I tried to delete the record from MongoDB collection setting the fme_db_operation = Delete.

But the error is:

'fme_feature_operation' has invalid value 'Delete'. Possible values include: 'Insert', 'Put'

Setting the "Table Handling" = "Drop and Create" could help as bypass, just rewriting the records that should not be deleted. But I don't like that I need to rewrite something shouldn't be deleted.

Any better ideas?

Best regards,

Irena

Did you set feature operation accordingly?

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?

 

 

Which version of FME are you using?

Which version of FME are you using?

FME Desktop 2017.0.1.1 (32-bit) - Build 17291

 

 

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.

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".

 

 

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.

 

Reply


Community Stats

30,185
Posts
114,572
Replies
37,848
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.