Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Suggested answer

Strange behavior of DMF Products V2 entity

(0) ShareShare
ReportReport
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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans