Showing posts from November, 2022

Microsoft Dynamics 365 Business Central: How to Import Data Using a CSV Buffer - Business Central CSV Buffer - Import CSV Data

Hi Everyone, This post is requested by many readers. I'm going to explain to you with a simple example. I've made a page and a table. The table holds the relevant fields in the CSV file and the Page has the important Procedures to read the CSV file, get the exact value and import the file into the business central CSV File Below is the CSV file I am going to import into the business central Table Create a new table as shown below Page Follow the steps. 1. Declare the page-level variables 2. Create the procedures to  read the CSV file. Get the value from the CSV file Import the CSV data to Business Central We need the File management Codeunit to get the file 3. Call ReadCSV() and ImportCVSData() procedures in the Page action event. Now execute the code.  For detailed instructions check this video

Part 1 of an introduction to Business Central's custom function and user defined procedures

Introduction One of the most fundamental ideas in computer programming is function. The first thing a developer does while writing code is to create an algorithm. This need can be satisfied in a function for easy reuse in the future. The ability to add new functions is available in all areas of Business Central where triggers and preexisting functions are used. You are free to implement your own logic and code in these methods. You'll study the basics of function definition and the distinction between local and global functions in this lesson. You can use parameters to tailor the behavior of a function to specific needs. The module's focus is on teaching you how to pass parameters into a function, as well as the many kinds of parameters that can be passed in. Why Functions? The reason for creating custom functions is to: Organize the program. Create self-explaining code. Simplify the development process. Make code reusable, which reduces work. Reduce errors. Help make modificat

Regular Expression in Business Central - Validate fields using business central

Introduction to Regular Expression Information can be easily extracted from any text using regular expressions (regex or regexp) by searching for one or more matches of a given search pattern (that is, a particular set of ASCII or Unicode letters). Validation, parsing/replacing text, translating data to different formats, and web scraping are just a few of the many possible applications. Once you're familiar with the syntax, this tool may be used in virtually any programming language (JavaScript, Java, Visual Basic, C#, C/C++, Python, Perl, Ruby, Delphi, R, Tcl, and many more), with only minor differences across languages and engine versions for the most sophisticated functionality. Let's get started with some illustrations and clarifications. Basic Characters Anchors - ^ and $ ^The        matches any string that starts with The -> Try it! end$ finds strings that end with that character. Exact string matching (begins and ends with The end) with the value "^The end$&qu