how to import custom text file in business Central

(0) Share

Report

Posted on by ravuri suresh

246

Hi all,

I want import custom text file into table in business central.

Please tell me how to do.

Advance

Thank you

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

JAngle 133 on at

Like (0)

Report

Closest thing in standard to this is using data exchange definitions. This blog shows you can add an action to a page to call a specific data exchange definition and place the table in a chosen table: joshanglesea.wordpress.com/.../

Resource on data exchange too: docs.microsoft.com/.../across-set-up-data-exchange

Was this reply helpful? Yes No
ravuri suresh 246 on at

Like (0)

Report

Hi Josh,

Thanks for response,

i want do in Business central Extension, is it possibile to import the custom file in table.

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

Try an XMLport then. You will need a page action to call it. It's a more direct route. Here is a resource that might help with the XMLport: www.hougaard.com/.../

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (1)

Report

You need to create an xmlport , please check the below link for an example

stoneridgesoftware.com/.../

Was this reply helpful? Yes No
Suggested answer

mahmoud_algindy 281 on at

Like (0)

Report

Hi Suresh

There are many ways, one is a semisimple and the other require Coding

I will start with the simple:

1- You can use the Data Exchange Definition, using the built-in Import Payroll in the General journal explained here Import Payrolls in Business Central - Roberto Stefanetti Blog - Microsoft Dynamics 365 Business Central (robertostefanettinavblog.com)

2- Use Edit in Excel.

3- Use Rapid Start ( Conf. Packages).

The other way is to implement an extension with AL code

(39) Import data with the AL Excel Buffer into Business Central - YouTube

File Handling and Text Encoding - Business Central | Microsoft Docs

Was this reply helpful? Yes No
ravuri suresh 246 on at

Like (0)

Report

Thank you suresh for your response, i have followed accordingly but i am getting issues after importing file.

Was this reply helpful? Yes No
ravuri suresh 246 on at

Like (0)

Report

Hi Suresh,

now i am able to import file by using Upload function and by reading data from instream variable using readtext functions.

Thank you

Suresh Ravuri

Was this reply helpful? Yes No