Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 390
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!
  • Layan Jwei Profile Picture
    Layan Jwei 7,264 Super User 2024 Season 2 on at
    Integration with flat files
    Hi,

    Is your question answered, if yes then please verify the answers that helped
  • Suggested answer
    Layan Jwei Profile Picture
    Layan Jwei 7,264 Super User 2024 Season 2 on at
    Integration with flat files
    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
     
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Integration with flat files
    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
  • Dev Profile Picture
    Dev 390 on at
    Integration with flat files
    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.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,642 Super User 2024 Season 2 on at
    Integration with flat files
    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.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans