web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Right flat file format for DMF import for large data

(1) ShareShare
ReportReport
Posted on by 471
Hi,
 
I need to decide on the file format for the DMF import for large data. I believe flat file format is best and light for this.
I see multiple options for flat files like CSV , CSV unicode, colon separated, colon separated unicode. I am not sure which one to choose.
Unicode here uses standard encoding like UTF-8 or some other?
I need data in different languages and need to specify the format to the middleware.
 
 
 
Thanks!!
I have the same question (0)
  • Verified answer
    Martin Dráb Profile Picture
    239,880 Most Valuable Professional on at
    First of all, these are just names of formats that you can define when you click Configure data sources tile on data management workspace. You can create another ones, reconfigure existing ones etc. and you should go to there to see what exact configuration is hiding under the name.
     
    I would always use Unicode, unless you have business needs requiring something else. Microsoft also recommends it in DMF documentation. UTF-8 is indeed one of Unicode encodings, but not the only one (e.g. there is UTF-16). As mentioned, you need to look at details of the given format to understand how it's configured.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 461 Super User 2026 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 458 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 450

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans