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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Integration with flat ...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Integration with flat files

(2) ShareShare
ReportReport
Posted on by Dev 451
Hi,
 
We have a requirement where we want to import item details sent to f&o in flat file format and we need to import the details in F&O.
Using DMF we can import in formats like xml, csv but not flat file so should we use a middleware to transform the data into one format supported by f&o or we have a solution to import flat files as it is.
 
Thanks!
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,085 Super User 2026 Season 1 on at
    Hi Dev,
     
    Can you tell us more about the file format details of this flat file? Is it a text file with a line per record? In that case, it might be possible to use it with Data Management.
  • Dev Profile Picture
    Dev 451 on at
    Hi Andre,
     
    0                1                  2                  3
    123456789012345678901234567890
    004        TEST
     
    Above is the example where 1-7 is item number and 8-11 is item type just as an example.
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Hi,
    To import item details in flat file format into F&O, you can consider using a middleware such as Azure Logic Apps or Microsoft Power Automate to transform the flat file data into a supported format like XML or CSV. These middleware solutions can help you define data transformation logic and then trigger the import process through F&O's Data Management Framework.
    If using a middleware to transform the data, you'll need to design the transformation logic to map the fields and structure from the flat file to the required format for F&O. Once the data is transformed into the appropriate format, it can be imported into F&O using DMF.
    Alternatively, if direct import of flat files into F&O is desirable, custom development may be needed to create a solution that allows F&O to directly consume flat files for import.
    Best regards,
    Kevin
  • Suggested answer
    Layan Jwei Profile Picture
    Layan Jwei 8,165 Super User 2026 Season 1 on at
    Hi Dev,
     
    You can do a customization, where you can create a menu item for importing the file.
    Then you can loop through the file lines and utilize substr method to say that for example if you want to insert into a table:
    Table.itemId =substr(_line, 1, 7) and so on
     
    Thanks,
    Layan Jweihan
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
     
  • Layan Jwei Profile Picture
    Layan Jwei 8,165 Super User 2026 Season 1 on at
    Hi,

    Is your question answered, if yes then please verify the answers that helped

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 309

#3
Diego Mancassola Profile Picture

Diego Mancassola 259

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans