Ignore Column Caption (First Row in File)
YouTube: How to Ignore the Header Row in Import Sale Configuration?
How to Ignore the Header Row in Import Sale Configuration?
In this tutorial, we will learn how to use the "Ignore Column Caption (First Row in File)" option while importing Sale Bills 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 start importing the actual Sale Bill data from the next row.
Access to the Import Configuration
Navigate to the Import Sale Bills from External File module.
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 Sale Bill File
Before importing the document, let's review the Sale Bill Excel 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 Sale Bill Excel file.
System Behavior
Since the option is disabled, the system considers the first row containing the column headings as part of the Sale Bill data during the import process.
As a result, the system attempts to process the column headings along with the actual Sale Bill 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 Sale Bill 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 Sale Bill details.
Verify the Imported Sale Bill
Now, let's proceed with importing the document.
Complete the import process.
Open the Sale Bill module.
Locate the imported Sale Bill.
Verify the imported details.
Result
As you can see, the Sale Bill details have been successfully reflected in the Sale Bill module, without considering the column headings from the first row as Sale Bill data.
Key Benefits
Skips Header Row: Prevents column headings from being treated as transaction data.
Accurate Import: Ensures that actual Sale Bill details are imported correctly.
Simplifies File Processing: Makes it easier to import files that contain column headings.
Reduces Import Errors: Prevents incorrect data from being generated from the first row.
Final Outcome
By enabling "Ignore Column Caption (First Row in File)", Logic ERP skips the header row of the external Sale Bill file and begins importing the actual transaction details from the following row.
Last updated