Finance | Project Operations, Human Resources, ...

Integration with flat files

(2) Share

Report

Posted on by Dev

471

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!

All responses (5)

Answers (0)

Sort by

André Arnaud de Cal... 307,856 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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 471 on at

Like (0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 8,421 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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 8,421 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

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