Dynamics Community Forum Thread Details

Strange behavior of DMF Products V2 entity

Hi guys,

I've found a strange behavior, during the use of DMF for entity Products V2 import.

In detail, I've created a simple excel file with 2 fields, ProductNumber and ProductDescription.

The purpose of this file Is update description on Products already existent.

Unfortunately when I've tried to import the file, I found in staging the description field truncated at 255 characters.

In the excel there are rows with description both higher and lower the 255 characters.

Checking as technical perspective I saw that description is a field of 1000 characters.

The strange behavior Is regarding the sort of records based on description size. I mean if I have 1000 rows for example, and I put as first rows description lower or equal 255 characters, also for rows higher then 255 characters, in staging table I see description truncated.

But, if I take the same file and I sort by description size, putting as first rows records with description higher then 255 characters, nothing Is truncated and I see correctly in staging description not truncated.

I didn't find anything on Lcs Issue search. Do you have any idea or suggestion/experiences on this?

Version used Is D365f&o 10.0.33. There Is no customization on this entity and related staging. It's totally standard.

Thanks in advance

Hi,

Your data may be truncated to 255 characters if the first 8 records for the field(s) being truncated contain 255 or fewer characters. The Microsoft Excel ODBC driver will, by default, scan the first 8 rows of your data to determine the type of data in each column.

I do not know if there is a parameter that can be modified to make sure that D365 always reads the whole content of the cells. But this simple manipulation is a good workaround.