Share
ReportHi all,
I want import custom text file into table in business central.
Please tell me how to do.
Advance
Thank you
Categories:
You’re offline. This is a read only version of the page.
246
Hi all,
I want import custom text file into table in business central.
Please tell me how to do.
Advance
Thank you
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
Thank you suresh for your response, i have followed accordingly but i am getting issues after importing file.
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
You need to create an xmlport , please check the below link for an example
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/.../
Hi Josh,
Thanks for response,
i want do in Business central Extension, is it possibile to import the custom file in table.
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
#1
YUN ZHU
304
Super User 2025 Season 1
#2
Mansi Soni
219
#3
Sagar_Dangar_MCP
180
All responses (
Answers (
