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.".