aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPFieldMapperController.m
Commit message (Collapse)AuthorAgeFilesLines
* • CSV Import Field MapperBibiko2010-03-221-7/+26
| | | | | - added the chance to mark a global value as SQL statement in the sheet to allow to use a calculated value like LENGTH(`foo`) or NOW() while inserting/replacing/updating • added ^⌥⌘N short-cut Navigator (still hidden)
* • CSV ImportBibiko2010-03-221-8/+13
| | | | | | | | - 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)
* • fixed bug while CSV importBibiko2010-03-221-1/+17
| | | | - calculate correctly whether global variables are used or not to avoid a crash if the number of columns in the csv file differs
* • CSV Import Field MapperBibiko2010-03-141-0/+15
| | | | - added to table target popup menu "Refresh List" menu item, since the user can add/change a table in an other connection window
* • CSV Import Field MapperBibiko2010-03-061-7/+37
| | | | | - added to INSERT advanced option "Skip existing rows" This option allows to insert only those source file rows which primary keys do not exist. It executes INSERT INTO … ON DUPLICATE KEY UPDATE `pri_key_name` = `pri_key_name`. This statement suppresses all warnings/errors regarding to duplicates pri keys etc. BUT it gives an error if an INSERT… statement of a remaining row was erroneous.
* • CSV Import Field MapperBibiko2010-03-061-5/+12
| | | | | - fixed some issues for displaying the default values for auto_increment and time_stamp • added possibility to change the tab stop width in each CMTextView via Preference setting in Editor window
* • CSV Import Field MapperBibiko2010-03-051-1/+0
| | | | - implemented "Insert remaining rows" for import method UPDATE; if the UPDATE statement does't affect any row and this row via INSERT INTO…
* • CSV Import Field MapperBibiko2010-03-051-6/+15
| | | | | | - improved some validation logic - added "Match Field" to source file field popup to be consistent if UPDATE is chosen - the label "Advanced" is now clickable as well
* • CSV Import Field MapperBibiko2010-03-051-54/+192
| | | | | | | | | | | - removed Advanced sheet, instead resize the main sheet and display these settings in it - added advanced options LOW/HIGH_PRIORITY - improved logic for adv. settings, disabling UPDATE if target table has less than 2 fields, etc. - fixed URL for displaying the source file name - removed Help text since it's too large - should be go to the general help • CMTextView - fixed bug if ESC Completion is invoked if caret position is 0 • fixed document URL handling to come up with the correct icons etc.
* • CSV Import Field MapperBibiko2010-03-041-6/+9
| | | | | | | - added UPDATE method which allows to configure an import statement à la: UPDATE t1 SET col1=foo1, col2=foo2 WHERE col3=baz1 AND col4=baz2 - Insert remaining rows (which are not matched) isn't implemented yet - note: further tests are needed to ensure it works as expected
* • CSV Import Field MapperBibiko2010-03-031-3/+41
| | | | - further work on UPDATE (not yet activated)
* Localise SPExtendedTableInfo.m and remove use of multiple comments for ↵stuconnolly2010-03-031-2/+2
| | | | localised strings.
* • CSV Field MapperBibiko2010-03-021-11/+26
| | | | | | - REPLACE as import method is only enabled if target table has a primary key or at least one field which is set to unique - if user set a field to "Ignore Field" display as "import value" the field's default value greyed - some minor code cosmetics
* • CSV Import Field MapperBibiko2010-02-211-6/+96
| | | | | - added Advanced sheet for setting IGNORE, DELAYED, ON DUPLICATE KEY UPDATE '<string>' for INSERT/REPLACE INTO • if during import CSV Import an error occurred show SP Console
* • applied new SPTableData keys "PRIMARY" and "UNIQUE" information to the ↵Bibiko2010-02-201-10/+12
| | | | | | mapping table - set tokenField to noWrap
* • CSV Import Field MapperBibiko2010-02-191-7/+45
| | | | | | | - added to csv field popup menu: "Ignore all fields", "Import all fields" - if user changed a matching pair field change the "Align fields by:" to "custom order" to make it more transparent - if user inserts a just added global var to a field which was set to "Ignore field" set it to "Import field" - unified some messages
* • CSV Import Field MapperBibiko2010-02-181-16/+21
| | | | | - some tiny improvements like "Add global value…" adds a new value automatically; if checkbox "Use current value" is ticked use that value in mapping array automatically to speed up defining global vars - some code cosmetics
* • CSV Import Field MapperBibiko2010-02-181-2/+27
| | | | | | | | | - added the csv source field popu: "Ignore field" to set the current field to doNotImport "Add global value…" which opens the global value sheet - removed "Add global value" button Note: still not the optimal solution - further work is needed. esp. avoid jittering if user selects "Ignore field" or "Add value…"
* • CSV Import Field MapperBibiko2010-02-181-2/+41
| | | | | - allow to define a list of global variables (incl. a true NULL value) - such a global variable will be inserted into the mapped table target field for all rows imported
* • further progress for 'add global source value'Bibiko2010-02-171-94/+240
| | | | | | | | | | | | • remember last chosen field alignment in csv field mapper in the prefs • improved 'matching names' algorithm; now it can handle this: csv: a b c table: c d a b → c - c d a - a b - b
* • csv file import mapperBibiko2010-02-171-9/+14
| | | | | | - added button "Go Back" ⌥← to go back to the file chooser (mainly for correcting delimiter etc.) - improved selecting csv file columns for the case that column was set as 'Do not import'; now if set to 'Do not import' the value is hidden, click the user on it the popup menu appears and the operator is set to 'Do import' automatically • TableDump now remembers the last chosen csv file name
* • csv field mapperBibiko2010-02-161-2/+46
| | | | | - added chance to align the csv field and table field names via 'matching names' which uses the Levenshtein distance [first approach] if csv file's first line is an header
* • csv field mapperBibiko2010-02-161-1/+30
| | | | | | - added target table field primary key info - added to align the csv fields by 'file order' and 'reversed file order'
* • csv field mapperBibiko2010-02-161-6/+42
| | | | | | - added target table field type and default info - disable Import button if no target table fields are available
* • removed arrowsBibiko2010-02-161-7/+18
| | | | • fixed spellings
* • field mapper controllerBibiko2010-02-161-2/+11
| | | | | | | | | | - fixed precocious releasing of mapper settings - fixed boolean binding for displaying "1 of first 100 records" - added further gui elements (not yet activated) - sheet dimensions are now auto-saved - bound keystroke ⇢ and ⇠ to row stepper - renamed some stuff - added clarification notes
* • re-factored and outsourced the entire CSV import field mapper sheetBibiko2010-02-161-35/+250
| | | | | | | | | | | | | | | | | | - changed the way to choose whether a source field should be imported or not by introducing a new table column 'operators' - clicking at the 'operator's header toggles all operators to 'Import' or 'Do not import' - added tooltips for each table cell; if file's first line are the headers show them in the tooltips as well - added checkbox "First line contains fields names" since it'll be clear in this pane whether a file has a header line or not (will be sync with prefs) - added the possibility to choose the import method: INSERT INTO or REPLACE INTO • deleted all old field mapper stuff from TableDump and DBView.xib Notes: - tests are needed to be sure that this change does not cause mismatches while importing - symbols for Do (not) import are tendative - maybe use images - a further import method UPDATE plus an operator '=' will be added soon - chance to add a new global source variable will come soon - displaying of source field types will come soon - semi-automatically matching of source field names and header names will come soon - the GUI needs some improvements afterwards
* • some further progress for the new csv import field mapper sheetBibiko2010-02-151-5/+40
|
* • some further work at the new field mapper sheetBibiko2010-02-051-7/+28
|
* • further work on SPFieldMapperControllerBibiko2010-02-021-1/+105
|
* • CMTextView: switch off syntax highlighting if text buffer size is larger ↵Bibiko2010-02-011-0/+31
than SP_SYNTAX_HILITE_BIAS (has to be improved) • added SPFieldMapperController