Ignore Column Caption (First Row in File)

YouTube: How to Ignore the Header Row in Import PUV Configuration?

How to Ignore the Header Row in Import PUV Configuration?

In this tutorial, we will learn how to use the "Ignore Column Caption (First Row in File)" option while importing a Purchase Voucher from an external file in Logic ERP.

This option allows the system to ignore the column headings in the first row of the external file and begin importing the purchase data from the following row.

---

Access to the Import Configuration

To access the required option:

• Navigate to Import Purchase Vouchers from External File.

• Open the Configuration window.

• Locate the option labeled as:

"Ignore Column Caption (First Row in File)"

Before enabling this option, let's first understand its default behavior.

---

Review the Purchase File

• Before importing the document, let's review the purchase file.

• As you can see, the first row contains the column headings that identify the different fields in the file.

Now, let's import the file while "Ignore Column Caption (First Row in File)" is disabled.

---

Import with the Option Disabled

• Keep "Ignore Column Caption (First Row in File)" disabled.

• Proceed with importing the Purchase Excel file.

System Behavior

Since the option is disabled, the system considers the first row, including the column headings, as part of the purchase data during the import process.

This means the system attempts to process the first row along with the actual purchase details.

---

Let's Enable Ignore Column Caption

Now, let's enable the option and observe the difference.

• Return to the Configuration window.

• Enable "Ignore Column Caption (First Row in File)".

• Save the configuration changes.

• Import the same purchase file again.

System Behavior

As you can see, the system now ignores the first row containing the column headings.

The import process starts from the next row, which contains the actual purchase details.

---

Verify the Imported Purchase Voucher

Now, let's proceed with importing the document.

• Complete the import process.

• Open the Purchase Voucher module.

• Open the imported Purchase Voucher.

• Verify the imported purchase details.

Result

As you can see, the purchase details have been successfully reflected in the Purchase Voucher, while the first row containing the column headings has been excluded from the imported data.

---

Final Outcome

By enabling "Ignore Column Caption (First Row in File)", Logic ERP skips the header row of the external file and starts importing the purchase data from the next row. This is useful when the first row of the file contains column headings rather than actual purchase data.