Article Details
Id:10249
Product:finPOWER Connect
Type:FIX
Version:1.06.00
Opened:28/06/2012
Closed:28/06/2012
Released:01/08/2012
Job: J009906

File Reader; CSV file including a header record with a blank column not working properly

The ISFileReader object in finPOWER Connect was not working properly under the following scenario:

1. Importing CSV file.
2. CSV file includes a header record.
3. Header record has a blank column, ie no name.

In this case the data is read and shifted to the left, ie all columns after the blank column header are noted as the incorrect column.

This issue can be seen in Postcodes and Addressing, "Supplemental Postcodes", when attempting to import a file. The following message may occur "Failed to Import Supplemental Postcodes. Failed to add new record in UpdateQueryBuilder. The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.".