aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPFieldMapperController.m
Commit message (Collapse)AuthorAgeFilesLines
* Change Sequel Pro's license from GPL (version 2) to MIT.stuconnolly2012-07-251-12/+21
|
* - When creating tables as a result of CSV imports into a new table, ↵rowanbeentje2012-05-291-5/+9
| | | | correctly build the column syntax if the last field(s) are set not to import, addressing Issue #1358.
* - Clean up SPMySQL and QueryKit inclusion and search methods, which should ↵rowanbeentje2012-03-271-4/+0
| | | | | | | fix nightly builds - Fix warnings
* tweaks to compile on Xcode 4 / 10.6 SDK for SP_REFACTORsqlprodev2012-03-271-0/+4
|
* - Fix an exception when attempting to preserve the selection in a table ↵rowanbeentje2012-03-241-3/+3
| | | | | | | | with a primary key with multiple columns of which the first of which is a blob or binary type - Clean up NSNull comparisons and add comments - Clear the selection when filtering a table, allowing reselection to look a little more consistent
* - Alter the import field mapper controller to support multiple primary keys ↵rowanbeentje2012-03-221-5/+9
| | | | in its current syntax builder by using the improved getter.
* Warning: this branch commit is largely untested, and known to throw ↵rowanbeentje2012-02-231-6/+7
| | | | | | | | | | | | exceptions as database structure retrieval is currently missing! Further work on SPMySQLFramework integration: - Improve SPMySQL framework build settings including correct ppc builds and a Distribution configuration for the build distributions to match - Add new convenience querying and result methods to the framework - Amend Sequel Pro source to use the new SPMySQL.framework methods everywhere, replacing MCPKit methods where they differ and improving some functions - Remove MCPKit from the source - Fix a number of warnings on Release-style builds
* - Fix "Multiple selection" still being displayed after multiple tables are ↵rowanbeentje2011-06-141-8/+6
| | | | | | | | | deleted - If multiple tables are selected when opening the SPFieldMapperController select the first to import into - Clean up tableName in tablesList - now returns nil if no tables are selected or multiple tables are selected, instead of returning an empty string for multiple tables
* Fixes source text encoding problems accidentally introduced in r3273sqlprodev2011-04-141-5/+5
|
* Fixes source text encoding problems accidentally introduced in r3273sqlprodev2011-04-141-6/+6
|
* SP_REFACTOR: Workaround for naming conflict with ↵sqlprodev2011-04-141-24/+4
| | | | postNotificationOnMainThread: which also exists in TCMPortMapper.framework; NSUserDefaults access now permitted in SP_REFACTOR blocks for a few prefs keys
* Make some minor changes after reviewing r3271:rowanbeentje2011-04-141-6/+6
| | | | | | - Fix a few encoding issues - Recode a few [NSApp keyWindow] uses back to [SPDatabaseDocument parentWindow] following discussion; possibly for later refactoring into use of an error method
* initial commit of SP_REFACTOR ifdefs, the start of a long quest to separate ↵sqlprodev2011-04-111-15/+57
| | | | UI code from functional code
* - Fix exceptions importing CSVs, caused by incorrect warnings cleanup in r3240rowanbeentje2011-03-221-3/+3
|
* - Fix more compiler warningsrowanbeentje2011-03-151-1/+1
| | | | | - Tweak README
* - Fix more warningsrowanbeentje2011-03-141-42/+43
|
* fixed compiler warningssqlprodev2011-03-011-10/+9
|
* • CSV field mapperBibiko2011-02-031-11/+22
| | | | | - reset import operators after each change of the chosen alignment - double-click at PathControl performs goBackToFileChooser delayed in order to avoid time racing issues
* • improve CSV field mapping method to align file header names with table ↵Bibiko2011-02-031-16/+72
| | | | | | | column names - first calculate Levenshtein distance; if it is greater than 0 then subtract the length of shared prefix, suffix, and in common character sequence - avoid mapping of already mapped file header names, instead take the next best match not mapped
* - Fix issues right-clicking in the empty table area ( http://spbug.com/l/1726 )rowanbeentje2010-11-271-1/+2
| | | | | | | - Improve 10.5 compatibility when clearing menus ( http://spbug.com/l/1508 , http://spbug.com/l/1829 , http://spbug.com/l/1818 ) - Fix a possible crash when updating database lists - Update localisable strings
* • CSV import now supports to import sequences of 0 and 1 into BIT fieldsBibiko2010-10-311-1/+3
| | | | | | • fixed several issues while importing a CSV file if this file contains empty lines or if a line has less columns as header - fixed issue for matching header names - fixed issue for user-defined SQL functions while importing; in such a case set the value to @"" to get the defaults
* • try to fix crash issue 1748Bibiko2010-10-291-6/+8
| | | | | - it seems that isKindOfClass: method to check length and data type of the csv source while creating a new table failed for empty cells or NULL; I tried to catch these issues - has to be checked further
* • CSV Import Field mapperBibiko2010-10-251-7/+13
| | | | | - fixed issues for tooltips of user-defined values - avoid double-calling the 'add value' sheet since it can be called via popupmenu and keyboard short-cut
* CSV Import Field MapperBibiko2010-10-251-26/+49
| | | | | | | | - a column placeholder will be wrapped into '…' if csv cell content is not NULL, in other words there's no need to write eg length('$1') instead simply write length($1) - fixed issue if csv cell content is NULL - fixed issue for deletion of global values if they were already in use - assigned keyboard short-cut ⌥⌘G to "Add value or expression…" menu item
* - Split out all of SPExportController's delegate methods to their own category.stuconnolly2010-10-241-3/+0
| | | | | | | | - Prepare for the implementation of PDF and HTML export by hiding the export options box for export types that don't need it. - Fix some spacing issues on the export dialog. - Create a new SPCategoryAdditions header that is included in the apps precompiled header, making all additions available to all classes. - Update strings files.
* • CSV Import Field Mapper SheetBibiko2010-10-231-7/+77
| | | | | - added the possibility to apply any sql function while importing set via "Add value or expression" sheet eg concat('$2', '$1', length('$3')) whereby $1 $2 $3 are the placeholder for the csv file columns 1 2 3 [first column starts with 1] • fixed ' escaping issue in MCPConnection
* • re-enabled three finger trackpad wiping gesture for controlling the ↵Bibiko2010-10-221-15/+23
| | | | | | | | table history • CSV Import Field Mapper Sheet - fixed issue for inserting a global value containing a ' - started preparations of the "Add value or expression" sheet for future enhancements
* Tidy up.stuconnolly2010-10-191-0/+1
|
* Considering nearly every class uses constants, import it via the prefix header.stuconnolly2010-10-191-1/+0
|
* Various improvements to server capability/version checking, including:stuconnolly2010-10-071-2/+3
| | | | | | | | | | | | | - Add a new ServerSupport class, for which an instance is created upon each new connection and is then subsequently accessible via SPDatabaseDocument. - Replace the majority of manual version checking with calls to properties in the above new class. - Improve the user manager's compatibility with MySQL 3 and 4 servers. Fixes issue #811 Other changes include: - Disable the encoding popup button when adding a new table or database to servers running pre MySQL 4.1 as it only contains one option, 'Default'. - Fix various potential memory leaks discovered during static analysis. - General tidy up and comments.
* • fixed exception while length checking for import into new table if ↵Bibiko2010-09-281-2/+2
| | | | | | checked value is not a NSString - fixes issue 1649
* - Remove a number of invalid [NSTableView makeFirstResponder] calls that ↵rowanbeentje2010-09-181-3/+3
| | | | | | | had crept into the source, replacing with the correct [NSWindow makeFirstResponder:NSTableView]. This fixes a number of exceptions. - Update localisable strings.
* * Fixes minor label length issues and one unlocalized stringdmoagx2010-09-171-3/+5
|
* • CSV Import into new table:Bibiko2010-09-061-4/+79
| | | | | | | | - do not create a field in beforehand if user set it to "Do Not Import" - added ROUGH field type guessing by parsing the up to 100 first rows distinguishing text versa integer and size: -- for integer distinguishes between INT and BIGINT due to number length -- for text distinguishes between VARCHAR(255), VARCHAR(32767) [for MySQL >= 5 only], and TEXT due to maximum string length
* • CSV Import Mapper sheet:Bibiko2010-09-061-44/+194
| | | | | | | | - added keyboard shortcut ⌘T to show available tables list - added chance to add a new columns to an existing table (⌘⌥A) - added chance to remove currently new added columns (⌘⌫) - context menu; to remove all new columns one can reselect the table Note: New columns will be added after pressing 'Import' and before the import process starts; if an error occurred the sheet keeps open to give the user the chance to correct errors whereby successfully created new columns won't be editable anymore.
* Minor enhancements to the CSV import dialogs new table info sheet (i.e. ↵stuconnolly2010-09-051-2/+6
| | | | | | | | | table encoding and type): - Make the sheet non-resizable, thus removing the visible resize triangle. - Add a cancel button so the user can discard their selection. - Only save the user's selection when they select 'OK'.
* • CSV Import into new TABLEBibiko2010-09-041-53/+141
| | | | | - added button "New" - added chance to change encoding and engine of the new table which will be saved in the Prefs
* • further improvements for CSV import into new tableBibiko2010-09-031-3/+58
| | | | | | | | | - fixed some RETURN/ENTER logic while editing a table cell - added context menu to table for: -- 'Set all Field Types to:' which sets all types to the current selected one ⌘= -- 'Add Column to Table Target' (not yet implemented) - some minor code issues - added Info button which will come up with a GUI for setting new table encoding and engine (not yet implemented)
* • further progress for CSV import into new tableBibiko2010-09-031-9/+64
| | | | | | - added some GUI validations - in new table mode changed 'type' column into self-learning NSComboBoxCells - fixed issue for closing sheet if user press RETURN, only close it if 'Import' button is enable
* • finished the first implementation of CSV Import into new tableBibiko2010-09-031-8/+174
| | | | note:What else is needed for such an import? table encoding settings? ... has to be discussed
* • first preparations to support a CSV import into a new table (not yet ↵Bibiko2010-09-021-55/+218
| | | | | | | | executable) - changed order of target tables: New Table, Refresh List, separator, list of all names - cleaned code a bit * removed check for available tables in SPDataImport, now if no table in db the CSV Field Mapper opens in "New Table" mode
* • CSV Import Field mapperBibiko2010-09-021-1/+0
| | | | - make sure that after Refresh Table List the mapping table will be updated as well
* Rename TableDump to SPDataImport and fix export selected tables functionality.stuconnolly2010-07-061-1/+1
|
* • after opening spfs file reset tabBar by looking at setting for ↵Bibiko2010-07-011-1/+7
| | | | | | | | | SPAlwaysShowWindowTabBar • fixed CSV Import file display in NSPathControl if SP runs localized - the problem is very likely a bug in [NSPathControl setURL:]; that's why create a new temporary NSPathControl and set the GUI's NSPathControl via [NSPathControl setPathComponentCells:[tempPathControl pathComponentCells]] - this should fix i751 • resized some components in CSV Import sheet to fit for localizations a bit better
* • fixed issue for Import from ClipboardBibiko2010-06-181-5/+1
| | | | - there's no need to check the passed path for clipboard content
* Rename TablesList to SPTablesList.stuconnolly2010-05-271-1/+1
|
* Rename CMTextView to SPTextView.stuconnolly2010-05-271-1/+1
|
* - In the CSV import field mapper controller, retain the primary key field ↵rowanbeentje2010-05-091-1/+3
| | | | to fix an autorelease crash. (Addresses http://spbug.com/l/266 )
* Rework alert sheets:rowanbeentje2010-05-091-1/+1
| | | | | | | - Change MCPConnection.m to no longer use a reference to tableWindow to attach sheets - instead use a delate error display method if available - Rework TableSource and TableContent sheetDidEnd methods into per-task methods rather than overloading contextInfo - Rework SPAlertSheets to perform actions on the main thread, with the loss of (unused) support for a didDismissSelector. This addresses a number of crashes logged by the crash reporter
* • added "Import from Clipboard" ⌥⇧⌘IBibiko2010-04-101-2/+11
| | | | | | - sheet showing the first 4kB of pasteboard content and the SQL/CSV accessory view - pasteboard content will be saved as temp file and read by using the current table/connection encoding