How to map Number property with decimal type source column for ExtOTDS application?

Question

In a External Object Type Data Source application,
Allowed data types: Text,Text (multi-line),Choose from list,Choose from list (multi-select),Boolean,Number (integer, 32-bit).

But I have many decimal and long type source column from external application and I need to map them with M-Files Properties. I tried with the answer in this question - https://community.m-files.com/forums-1552881334/f/general-discussion-feedback/8549/null-date-in-source-column-for-external-object-type-data-source-application-creates-issue-with-property-definition-how-to-solve-it but it didn't work.

There is workaround to save decimal/long source columns values in string property but it is not acceptable as per client's requirement. How to solve it? I greatly appreciate your kind help.

Craig Hawker · Answer

A bug was recently identified in the External Object Type Data Source (IML) template. The issue is that the double data type is not mapped correctly. 
 If you update your Visual Studio template package to the one released earlier this week, then create a new project, the issue should be solved in that project. 
 To solve this on an existing project you need to update the various M-Files package references to >= 22.5.1, and then change the mapping in DataSourceConnection.cs such that double is mapped to DBTYPE_R8:

How to map Number property with decimal type source column for ExtOTDS application?

Top Replies