aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPFieldMapperController.m
Commit message (Collapse)AuthorAgeFilesLines
* • 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