From ecbc556ad0ed6e6c66c76145085a524bf8d6035d Mon Sep 17 00:00:00 2001 From: Bibiko Date: Sat, 6 Mar 2010 14:42:51 +0000 Subject: =?UTF-8?q?=E2=80=A2=20CSV=20Import=20Field=20Mapper=20-=20added?= =?UTF-8?q?=20to=20INSERT=20advanced=20option=20"Skip=20existing=20rows"?= =?UTF-8?q?=20This=20option=20allows=20to=20insert=20only=20those=20source?= =?UTF-8?q?=20file=20rows=20which=20primary=20keys=20do=20not=20exist.=20I?= =?UTF-8?q?t=20executes=20INSERT=20INTO=20=E2=80=A6=20ON=20DUPLICATE=20KEY?= =?UTF-8?q?=20UPDATE=20`pri=5Fkey=5Fname`=20=3D=20`pri=5Fkey=5Fname`.=20Th?= =?UTF-8?q?is=20statement=20suppresses=20all=20warnings/errors=20regarding?= =?UTF-8?q?=20to=20duplicates=20pri=20keys=20etc.=20BUT=20it=20gives=20an?= =?UTF-8?q?=20error=20if=20an=20INSERT=E2=80=A6=20statement=20of=20a=20rem?= =?UTF-8?q?aining=20row=20was=20erroneous.?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- Interfaces/English.lproj/DataMigrationDialog.xib | 84 ++++++++++++++++++++++-- 1 file changed, 77 insertions(+), 7 deletions(-) (limited to 'Interfaces/English.lproj') diff --git a/Interfaces/English.lproj/DataMigrationDialog.xib b/Interfaces/English.lproj/DataMigrationDialog.xib index 53f1370f..489491c5 100644 --- a/Interfaces/English.lproj/DataMigrationDialog.xib +++ b/Interfaces/English.lproj/DataMigrationDialog.xib @@ -12,7 +12,7 @@ YES - + YES @@ -937,7 +937,7 @@ -2038284033 - 134217857 + 436207745 200 @@ -1025,6 +1025,28 @@ 293 YES + + + 268 + {{227, 62}, {134, 18}} + + YES + + -2080244224 + 131072 + Skip existing rows + + + 1211912703 + 2 + + + + + 200 + 25 + + 274 @@ -2257,6 +2279,22 @@ 395 + + + skipexistingRowsCheckBox + + + + 398 + + + + advancedCheckboxValidation: + + + + 399 + @@ -2943,6 +2981,7 @@ + Advanced View for INSERT @@ -3156,6 +3195,20 @@ + + 396 + + + YES + + + + + + 397 + + + @@ -3294,6 +3347,9 @@ 39.IBPluginDependency 392.IBPluginDependency 393.IBPluginDependency + 396.IBAttributePlaceholdersKey + 396.IBPluginDependency + 397.IBPluginDependency 40.IBPluginDependency 41.IBPluginDependency 42.IBPluginDependency @@ -3326,9 +3382,9 @@ YES com.apple.InterfaceBuilder.CocoaPlugin - {{99, 328}, {522, 348}} + {{361, 389}, {522, 348}} com.apple.InterfaceBuilder.CocoaPlugin - {{99, 328}, {522, 348}} + {{361, 389}, {522, 348}} {{387, 725}, {432, 282}} @@ -3378,7 +3434,7 @@ ToolTip - Go back to file chooser (⌥←) + Go back to file chooser (⇧⌥⌘←) com.apple.InterfaceBuilder.CocoaPlugin @@ -3537,6 +3593,16 @@ com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin + + ToolTip + + ToolTip + + Do not import existing rows identified by the PRIMARY KEY + + + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin @@ -3583,7 +3649,7 @@ - 395 + 399 @@ -3666,6 +3732,7 @@ advancedUpdateView alignByPopup alignByPopupLabel + customQueryInstance delayedCheckBox delayedReplaceCheckBox fieldMapperTableScrollView @@ -3693,6 +3760,7 @@ replaceAfterSavingCheckBox rowDownButton rowUpButton + skipexistingRowsCheckBox tableTargetPopup theDelegate @@ -3711,6 +3779,7 @@ id id id + id NSTableView id NSPathControl @@ -3729,12 +3798,13 @@ id NSMenuItem id - id + CMTextView id NSButton id id id + id NSPopUpButton id -- cgit v1.2.3