Skip to main content
Kofax

Error running AP Data Import: Field at index n does not exist. You can ignore missing fields by setting MissingFieldFound to null

Article # 3035562 - Page views: 18

Issue

  • We get the following error when we import PO Lines data from po_lines.csv:  Field at index '8' does not exist. You can ignore missing fields by setting MissingFieldFound to null
  • We also get a similar error for erp_invoices.csv:  Field at index '3' does not exist. You can ignore missing fields by setting MissingFieldFound to null
  • .Is there any way to identify which row is causing the error? 
  • Where can I set MissingFieldFound?

 

Cause

  • Bug 1706270:Database columns width discrepancy. 

    • Table PO Lines, column UOM should be 50 symbols, but currently it's limited to 10.

    • Table BRWVendorMaster column Zip should be 50 symbols, but currently it's limited to 15.

  • MissingFieldFound is a sub in CsvHelper.Configuration.ConfigurationFunctions rather than a variable or setting.

 

Solution

 

Level of Complexity 

Moderate

 

Applies to  

Product Version Build Environment Hardware
AP Agility 2.4.1.0      

References

 

 

 

Article # 3035562