Column Delimiter

YouTube: How to Configure the Column Delimiter in Import PUV (Text File) Configuration?

How to Configure the Column Delimiter in Import PUV (Text File) Configuration?

In this tutorial, we will learn how to use the "Column Delimiter" option while importing a Purchase Text File in Logic ERP.

This option allows you to define the character used to separate different columns in the text file, ensuring that the system correctly identifies and imports each field.

---

Select the Text File Import Type

• Navigate to the Import Purchase Vouchers from External File module.

• Open the Configuration window.

• Select Text File as the Import File Type.

Column Delimiter

• Locate the option labeled as

"Column Delimiter"

• This option defines how the different columns in the text file are separated.

• The selected delimiter must match the separator used in the source text file.

  • For this tutorial, we are using a comma (,) as an example.

---

Review the Purchase Text File

Before importing the file, let's review its format.

As you can see, the different fields in the purchase text file are separated using commas.

For example:

• Item Code, Item Name, Quantity, Rate

• Here, the comma is used to separate each column.

---

Import the Purchase Text File

Now, let's proceed with the import.

• Select the required purchase text file.

• Start the import process.

System Behavior

As you can see, the system successfully identifies the individual columns based on the configured comma delimiter.

Each field is correctly separated and mapped according to the text file structure.

---

Verify the Imported Purchase Voucher

• Proceed with importing the purchase details.

• Once the import is completed successfully, open the Purchase Voucher module.

• Locate and open the imported document.

Result

As you can see, the purchase details have been successfully imported and correctly reflected in the Purchase Voucher.

---

Key Benefits

• Allows the system to correctly read structured text files.

• Ensures proper separation of imported fields.

• Helps prevent incorrect column mapping during import.

• Supports flexible text file formats by allowing different delimiters.

Final Outcome

By configuring the "Column Delimiter" according to the separator used in the source text file, Logic ERP can correctly identify and import each column during the Purchase Voucher import process.