aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPDataImport.m
Commit message (Collapse)AuthorAgeFilesLines
* - Add a new CSV import field escape setting, as a new default, supporting ↵rowanbeentje2012-01-061-1/+6
| | | | both backslash and double-character escaping. This will mean the vast majroty of CSVs selected for import will be read correctly by default, fixing issues such as Issue #1252
* - Speculative fix for Issue #1154 (problems using some field separators ↵rowanbeentje2011-09-121-0/+3
| | | | during CSV import)
* - If the field mapper was cancelled, abort the CSV import at once to avoid ↵rowanbeentje2011-08-251-4/+10
| | | | crashes if a new table name to create was entered
* Minor tidy up.stuconnolly2011-07-111-35/+34
|
* - When importing CSVs, or editing custom query results, set numeric fields ↵rowanbeentje2011-05-091-2/+23
| | | | to NULL instead of 0 if an empty string is entered. This matches TableContent behaviour and addresses Issue #1034.
* - Fix progress bar accuracy when importing gzipped or bzipped CSVsrowanbeentje2011-05-081-11/+35
|
* Fix more compiler warnings, including a few bugsrowanbeentje2011-03-081-9/+10
|
* fixed compiler warningssqlprodev2011-03-011-0/+1
|
* fixed compiler warningssqlprodev2011-03-011-1/+0
|
* • fixed bug while CSV Import for method UPDATE and INSERT remaining rows Bibiko2011-02-151-1/+1
| | | | | | - appended a ',' to the wrong NSString - fixes i978
* - Show and hide the custom query info area based on whether custom query ↵rowanbeentje2010-12-041-0/+1
| | | | | | | | | | errors occurred, starting off hidden - Add "errors"/"no errors" prefix to the custom query status area - Add an import cancelled line to the import error list when stopping imports after errors - Fix custom query error highlighting by scrolling to the error - Update localisable strings
* - Change the CSV import accessory view to a general import accessory view, ↵rowanbeentje2010-11-291-4/+40
| | | | | | | | | based on a tab view - When importing SQL, use the accessory view to ask how to handle errors: Ask (the new default), which prompts the user on each error whether to continue, stop, or ignore all errors; and ignoring all errors, which matches the old behaviour. This addresses Issue #901. - When showing the reconnection dialog ensure the window isn't minimised - Update localisable strings
* Add a new category to SPDatabaseDocument, allowing code cleanup and moving ↵rowanbeentje2010-11-031-5/+1
| | | | | | | | | | | central functionality out of SPTablesList: - Centralise control over table loading, moving it away from SPTablesList and into SPDatabaseDocument and the new SPDatabaseViewController category - Centralise control over the main tab view, moving control away from SPTablesList and into SPDatabaseDocument and the new SPDatabaseViewController category - Simplify and clean up view loading logic - Improve thread safety - Update localisable strings
* • CSV import now supports to import sequences of 0 and 1 into BIT fieldsBibiko2010-10-311-9/+40
| | | | | | • 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
* - Fix incorrect quoting of BLOB fields on SQL exportsrowanbeentje2010-10-251-3/+14
| | | | | | - Use indeterminate progress bars when importing BZIPped SQL files - Support .tsv as a CSV extension, and automatically choose the field delineator based on .csv/.tsv extension
* CSV Import Field MapperBibiko2010-10-251-25/+16
| | | | | | | | - 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-4/+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-6/+86
| | | | | - 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
* Considering nearly every class uses constants, import it via the prefix header.stuconnolly2010-10-191-1/+1
|
* • fixed issue of unnecessary string escaping for importing spatial data ↵Bibiko2010-10-101-1/+1
| | | | | | via GeomFromText() • minor code cosmetics
* • enabled SRID editing of spatial fields via WKT stringBibiko2010-10-091-1/+1
| | | | | - the SRID value will be appended at the WKT string like POINT(1 1),101 which will be transformed to GeomFromText('POINT(1 1)',101) on the fly - otherwise the SRID information will be deleted after editing a geometry field
* • some code cleaning, speed improvements, commenting stuffBibiko2010-10-091-5/+9
|
* • CSV Import (incl. import from clipboard)Bibiko2010-10-091-33/+41
| | | | | - if mapped target table field is of type GEOMETRY import csv data via GeomFromText() - replaced succeeding appendString lines by appendFormat since tests have shown that allocating memory once is faster than do it several times
* * One label was too short in Content Filter Managerdmoagx2010-09-261-4/+6
| | | | * Changed some NSLocalizedString() comments to be more descriptive - keep in mind that the comment is the only thing that can provide context here.
* Update Localizable.strings and resolve the use of multiple comments for the ↵stuconnolly2010-09-211-4/+4
| | | | same string.
* • finished the first implementation of CSV Import into new tableBibiko2010-09-031-8/+31
| | | | 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-11/+11
| | | | | | | | 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
* Encoding changes and improvements, particularly to increase compatibility ↵rowanbeentje2010-08-251-3/+3
| | | | | | | | | | | with extended characters in MySQL identifiers (names of dbs/tables/cols): - Move encoding queries and control into MCPKit, with newly cleaned-up methods, and switch a number of locations to using the new code. - Use UTF8 connections for many identifier-based queries (selecting and listing databases, tables, stored procs, table information). This fixes selection and creation of table and database names containing extended characters, also fixing exceptions and errors. - Improve UTF8 over Latin1 to correctly set the client character set encoding as well, fixing custom queries and edits; remove custom code in SPTableContent achieving the same thing in a single location. - Fix database encoding detection routines - Update localisable strings
* • overall replacement of:Bibiko2010-08-201-8/+8
| | | | | | | | | [aString appendString:[NSString stringWithFormat:]] by [aString appendFormat:] since it's much more faster • first look at loop where several [aStr appendString:] occur to try to combine them into one appendString or appendFormat since the allocation of memory takes really time Note: I tested all my changes but we should test it further to be sure that I didn't a mistake!
* - Add support for automatically converting \r and \r\n linebreaks in query ↵rowanbeentje2010-07-291-2/+22
| | | | | | | | syntax to \n. This addresses Issue #652. - Clean up SPSQLParser, and use a few more CFString methods to avoid obj-c messaging in loops - When importing SQL using autodetect, perform a manual SET NAMES if possible to cope with poorly-exported files.
* - Fix positioning bug when using Import From Clipboardrowanbeentje2010-07-251-25/+79
| | | | | - Add controllable encoding support when importing CSV and SQL files, including a new default "Autodetect" option. Add UniversalDetector framework to support encoding autodetection. This should address Issue #720.
* In addition to Gzip compression support when exporting SQL dumps add the ↵stuconnolly2010-07-241-12/+14
| | | | | | | | | | | | | | | | | | ability to use Bzip2 compression. Other changes include: + Enable the use of export compression (Gzip and Bzip2) for all export formats. + Move the compression options in the export dialog to the 'Advanced' export settings view. + Simplify the setting of common exporter properties (e.g. the connection, use of compression). + Fix a potential memory leak in the dot exporter. + Update the data importer to recognise Bzip2 compressed files. + Fix several display issues on export dialog. + Restore the default .csv file extension of CSV exports. + Correctly update the default export filename when selecting a output compression type. The addition of Bzip2 compression support implements issue #688.
* - Clean up SPDataImport, removing unused methods and cleaning up order and ↵rowanbeentje2010-07-191-182/+189
| | | | | | | | | methods - Improve error handling when the connecting dies during import (previous the sheet would stay open) - Fix localised strings for error messages (label and text the wrong way round) - Improve comments
* Rename TableDump to SPDataImport and fix export selected tables functionality.stuconnolly2010-07-061-0/+1438