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