• CSV Import

- if a parsed row in the csv file doesn't have the same number of columns as the first row fill the missing columns with SPNotLoaded to allow while importing that these missing data can be replaced by the table column's DEFAULT value
- fixed tiny issue for field mapper sheet to display the correct tooltip for default values
• SPTableData
- ATTENTION: changed the object for returned key 'default': if its value is NULL now it returns a [NSNull null] object
- changed instances to handle this  [NSNull null] object (must be checked)

1 files changed, 4 insertions, 2 deletions

diff --git a/Source/SPCSVParser.m b/Source/SPCSVParser.m
index d9a77a62..e4755a7e 100644
--- a/Source/SPCSVParser.m
+++ b/Source/SPCSVParser.m
@@ -24,6 +24,7 @@
 //  More info at <http://code.google.com/p/sequel-pro/>
 
 #import "SPCSVParser.h"
+#import "SPNotLoaded.h"
 
 /**
  * Please see the header files for a general description of the purpose of this class.
@@ -294,11 +295,12 @@
 	}
 
 	// Capture the length of the first row when processing, and ensure that all
-	// subsequent rows contain that many cells
+	// subsequent rows contain that many cells (fill them with [SPNotLoaded notLoaded]
+	// to allow to replace these by the table column's DEFAULT value)
 	if (fieldCount == NSNotFound) {
 		fieldCount = [csvRowArray count];
 	} else if ([csvRowArray count] < fieldCount) {
-		for (j = [csvRowArray count]; j < fieldCount; j++) [csvRowArray addObject:[NSNull null]];
+		for (j = [csvRowArray count]; j < fieldCount; j++) [csvRowArray addObject:[SPNotLoaded notLoaded]];
 	}
 
 	// Return the row