Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Suggested answer

Strange behavior of DMF Products V2 entity

Posted on by 10
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
 
 
  • Suggested answer
    Anthony DG Profile Picture
    Anthony DG 7 on at
    Strange behavior of DMF Products V2 entity
    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.
    1. Find the row with the longest description.
    2. Cut/Paste it to make it the second row, right below the column names.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans