Finance | Project Operations, Human Resources, ...

Integration with flat files

(2) Share

Report

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)

All responses (5)

Answers (0)

André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Dev 451 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Layan Jwei 8,118 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Layan Jwei 8,118 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

Integration with flat files

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Integration with flat files

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates