MERGED r262:266 from branches/stuart02 to trunk to include new project structure.

1 files changed, 1892 insertions, 0 deletions

diff --git a/Source/TableDump.m b/Source/TableDump.m
new file mode 100644
index 00000000..277ed3e7
--- /dev/null
+++ b/Source/TableDump.m
@@ -0,0 +1,1892 @@
+//
+//  TableDump.m
+//  sequel-pro
+//
+//  Created by lorenz textor (lorenz@textor.ch) on Wed May 01 2002.
+//  Copyright (c) 2002-2003 Lorenz Textor. All rights reserved.
+//
+//  This program is free software; you can redistribute it and/or modify
+//  it under the terms of the GNU General Public License as published by
+//  the Free Software Foundation; either version 2 of the License, or
+//  (at your option) any later version.
+//
+//  This program is distributed in the hope that it will be useful,
+//  but WITHOUT ANY WARRANTY; without even the implied warranty of
+//  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+//  GNU General Public License for more details.
+//
+//  You should have received a copy of the GNU General Public License
+//  along with this program; if not, write to the Free Software
+//  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+//
+//  More info at <http://code.google.com/p/sequel-pro/>
+//  Or mail to <lorenz@textor.ch>
+
+#import "TableDump.h"
+#import "TableDocument.h"
+#import "TablesList.h"
+#import "TableSource.h"
+#import "TableContent.h"
+#import "CustomQuery.h"
+#import "SPGrowlController.h"
+
+@implementation TableDump
+
+//IBAction methods
+- (IBAction)reloadTables:(id)sender
+/*
+ get the tables in db
+ */
+{
+	CMMCPResult *queryResult;
+	int i;
+	
+	//get tables
+	[tables removeAllObjects];
+	queryResult = (CMMCPResult *)[mySQLConnection listTables];
+	
+	if ([queryResult numOfRows]) [queryResult dataSeek:0];
+	for ( i = 0 ; i < [queryResult numOfRows] ; i++ ) {
+		[tables addObject:[NSMutableArray arrayWithObjects:
+						   [NSNumber numberWithBool:YES], [[queryResult fetchRowAsArray] objectAtIndex:0], nil]];
+	}
+	
+	[exportDumpTableView reloadData];
+	[exportMultipleCSVTableView reloadData];
+	[exportMultipleXMLTableView reloadData];
+	
+}
+
+- (IBAction)selectTables:(id)sender
+/*
+ selects or deselects all tables
+ */
+{
+	NSEnumerator *enumerator;
+	id theObject;
+	
+	[self reloadTables:self];
+	
+	enumerator = [tables objectEnumerator];
+	while ( (theObject = [enumerator nextObject]) ) {
+		if ( [sender tag] ) {
+			[theObject replaceObjectAtIndex:0 withObject:[NSNumber numberWithBool:YES]];
+		} else {
+			[theObject replaceObjectAtIndex:0 withObject:[NSNumber numberWithBool:NO]];
+		}
+	}
+	
+	[exportDumpTableView reloadData];
+	[exportMultipleCSVTableView reloadData];
+	[exportMultipleXMLTableView reloadData];
+}
+
+- (IBAction)closeSheet:(id)sender
+/*
+ ends the modal session
+ */
+{
+	[NSApp stopModalWithCode:[sender tag]];
+}
+
+#pragma mark -
+#pragma mark export methods
+
+- (void)exportFile:(int)tag
+/*
+ invoked when user clicks on an export menuItem
+ */
+{
+	NSString *file;
+	NSString *contextInfo;
+	NSSavePanel *savePanel = [NSSavePanel savePanel];
+	NSString *currentDate = [[NSDate date] descriptionWithCalendarFormat:@"%d.%m.%Y" timeZone:nil locale:nil];
+	
+	switch ( tag ) {
+		case 5:
+			// export dump
+			[self reloadTables:self];
+			file = [NSString stringWithFormat:@"%@_dump %@.sql", [tableDocumentInstance database], currentDate];
+			[savePanel setAccessoryView:exportDumpView];
+			contextInfo = @"exportDump";
+			break;
+			
+			// Export the full resultset for the currently selected table to a file in CSV format
+		case 6:
+			file = [NSString stringWithFormat:@"%@.csv", [tableDocumentInstance table]];
+			[savePanel setAccessoryView:exportCSVView];
+			contextInfo = @"exportTableContentAsCSV";
+			break;
+			
+			// Export the full resultset for the currently selected table to a file in XML format
+		case 7:
+			file = [NSString stringWithFormat:@"%@.xml", [tableDocumentInstance table]];
+			contextInfo = @"exportTableContentAsXML";
+			break;
+			
+			// Export the current "browse" view to a file in CSV format
+		case 8:
+			file = [NSString stringWithFormat:@"%@ view.csv", [tableDocumentInstance table]];
+			[savePanel setAccessoryView:exportCSVView];
+			contextInfo = @"exportBrowseViewAsCSV";
+			break;
+			
+			// Export the current "browse" view to a file in XML format
+		case 9:
+			file = [NSString stringWithFormat:@"%@ view.xml", [tableDocumentInstance table]];
+			contextInfo = @"exportBrowseViewAsXML";
+			break;
+			
+			// Export the current custom query result set to a file in CSV format
+		case 10:
+			file = @"customresult.csv";
+			[savePanel setAccessoryView:exportCSVView];
+			contextInfo = @"exportCustomResultAsCSV";
+			break;
+			
+			// Export the current custom query result set to a file in XML format
+		case 11:
+			file = @"customresult.xml";
+			contextInfo = @"exportCustomResultAsXML";
+			break;
+			
+			// Export multiple tables to a file in CSV format
+		case 12:
+			[self reloadTables:self];
+			file = [NSString stringWithFormat:@"%@.csv", [tableDocumentInstance database]];
+			[savePanel setAccessoryView:exportMultipleCSVView];
+			contextInfo = @"exportMultipleTablesAsCSV";
+			break;
+			
+			// Export multiple tables to a file in XML format
+		case 13:
+			[self reloadTables:self];
+			file = [NSString stringWithFormat:@"%@.xml", [tableDocumentInstance database]];
+			[savePanel setAccessoryView:exportMultipleXMLView];
+			contextInfo = @"exportMultipleTablesAsXML";
+			break;
+		default:
+			NSLog(@"ERROR: unknown export item with tag %d", tag);
+			return;
+			break;
+	}
+	
+	// Open the savePanel
+	[savePanel beginSheetForDirectory:[prefs objectForKey:@"savePath"]
+								 file:file modalForWindow:tableWindow modalDelegate:self
+					   didEndSelector:@selector(savePanelDidEnd:returnCode:contextInfo:) contextInfo:contextInfo];
+}
+
+/*
+ Save the export file; open a file handle, pass it to the appropriate data-writing function for streaming the export, and close the handle.
+ */
+- (void)savePanelDidEnd:(NSSavePanel *)sheet returnCode:(int)returnCode contextInfo:(NSString *)contextInfo
+{
+	NSFileHandle *fileHandle = nil;
+	BOOL success;
+	
+	[sheet orderOut:self];
+	
+	if ( returnCode != NSOKButton )
+		return;
+	
+	// Save path to preferences
+	[prefs setObject:[sheet directory] forKey:@"savePath"];
+	
+	// Error if the file already exists and is not writable, and get a fileHandle to it.
+	if ( [[NSFileManager defaultManager] fileExistsAtPath:[sheet filename]] ) {
+		if ( ![[NSFileManager defaultManager] isWritableFileAtPath:[sheet filename]]
+			|| !(fileHandle = [NSFileHandle fileHandleForWritingAtPath:[sheet filename]]) ) {
+			NSBeginAlertSheet(NSLocalizedString(@"Error", @"error"), NSLocalizedString(@"OK", @"OK button"), nil, nil, tableWindow, self, nil, nil, nil,
+							  NSLocalizedString(@"Couldn't replace the file. Be sure that you have the necessary privileges.", @"message of panel when file cannot be replaced"));
+			return;
+		}
+		
+		// Truncate the file to zero bytes
+		[fileHandle truncateFileAtOffset:0];
+		
+		// Otherwise attempt to create a file
+	} else {
+		if ( ![[NSFileManager defaultManager] createFileAtPath:[sheet filename] contents:[NSData data] attributes:nil] ) {
+			NSBeginAlertSheet(NSLocalizedString(@"Error", @"error"), NSLocalizedString(@"OK", @"OK button"), nil, nil, tableWindow, self, nil, nil, nil,
+							  NSLocalizedString(@"Couldn't write to file. Be sure that you have the necessary privileges.", @"message of panel when file cannot be written"));
+			return;
+		}
+		
+		// Retrieve a filehandle for the file, attempting to delete it on failure.
+		fileHandle = [NSFileHandle fileHandleForWritingAtPath:[sheet filename]];
+		if ( !fileHandle ) {
+			[[NSFileManager defaultManager] removeFileAtPath:[sheet filename] handler:nil];
+			NSBeginAlertSheet(NSLocalizedString(@"Error", @"error"), NSLocalizedString(@"OK", @"OK button"), nil, nil, tableWindow, self, nil, nil, nil,
+							  NSLocalizedString(@"Couldn't write to file. Be sure that you have the necessary privileges.", @"message of panel when file cannot be written"));
+			return;
+		}
+	}
+	
+	// Export the tables selected in the MySQL export sheet to a file
+	if ( [contextInfo isEqualToString:@"exportDump"] ) {
+		success = [self dumpSelectedTablesAsSqlToFileHandle:fileHandle];
+		
+		// Export the full resultset for the currently selected table to a file in CSV format
+	} else if ( [contextInfo isEqualToString:@"exportTableContentAsCSV"] ) {
+		success = [self exportTables:[NSArray arrayWithObject:[tableDocumentInstance table]] toFileHandle:fileHandle usingFormat:@"csv"];
+		
+		// Export the full resultset for the currently selected table to a file in XML format
+	} else if ( [contextInfo isEqualToString:@"exportTableContentAsXML"] ) {
+		success = [self exportTables:[NSArray arrayWithObject:[tableDocumentInstance table]] toFileHandle:fileHandle usingFormat:@"xml"];
+		
+		// Export the current "browse" view to a file in CSV format
+	} else if ( [contextInfo isEqualToString:@"exportBrowseViewAsCSV"] ) {
+		success = [self writeCsvForArray:[tableContentInstance currentResult] orQueryResult:nil
+							toFileHandle:fileHandle
+						outputFieldNames:[exportFieldNamesSwitch state]
+							terminatedBy:[exportFieldsTerminatedField stringValue]
+							  enclosedBy:[exportFieldsEnclosedField stringValue]
+							   escapedBy:[exportFieldsEscapedField stringValue]
+								lineEnds:[exportLinesTerminatedField stringValue]
+								silently:NO];
+		
+		// Export the current "browse" view to a file in XML format
+	} else if ( [contextInfo isEqualToString:@"exportBrowseViewAsXML"] ) {
+		success = [self writeXmlForArray:[tableContentInstance currentResult] orQueryResult:nil
+							toFileHandle:fileHandle
+							   tableName:[tableDocumentInstance table]
+							  withHeader:YES
+								silently:NO];
+		
+		// Export the current custom query result set to a file in CSV format
+	} else if ( [contextInfo isEqualToString:@"exportCustomResultAsCSV"] ) {
+		success = [self writeCsvForArray:[customQueryInstance currentResult] orQueryResult:nil
+							toFileHandle:fileHandle
+						outputFieldNames:[exportFieldNamesSwitch state]
+							terminatedBy:[exportFieldsTerminatedField stringValue]
+							  enclosedBy:[exportFieldsEnclosedField stringValue]
+							   escapedBy:[exportFieldsEscapedField stringValue]
+								lineEnds:[exportLinesTerminatedField stringValue]
+								silently:NO];
+		
+		// Export the current custom query result set to a file in XML format
+	} else if ( [contextInfo isEqualToString:@"exportCustomResultAsXML"] ) {
+		success = [self writeXmlForArray:[customQueryInstance currentResult] orQueryResult:nil
+							toFileHandle:fileHandle
+							   tableName:@"custom"
+							  withHeader:YES
+								silently:NO];
+		
+		// Export multiple tables to a file in CSV format
+	} else if ( [contextInfo isEqualToString:@"exportMultipleTablesAsCSV"] ) {
+		success = [self exportSelectedTablesToFileHandle:fileHandle usingFormat:@"csv"];
+		
+		// Export multiple tables to a file in XML format
+	} else if ( [contextInfo isEqualToString:@"exportMultipleTablesAsXML"] ) {
+		success = [self exportSelectedTablesToFileHandle:fileHandle usingFormat:@"xml"];
+		
+		// Unknown operation
+	} else {
+		NSLog(@"Unknown export operation: %@", [contextInfo description]);
+		return;
+	}
+	
+	// Close the file handle
+	[fileHandle closeFile];
+	
+	if ( !success ) {
+		NSBeginAlertSheet(NSLocalizedString(@"Error", @"error"), NSLocalizedString(@"OK", @"OK button"), nil, nil, tableWindow, self, nil, nil, nil,
+						  NSLocalizedString(@"Couldn't write to file. Be sure that you have the necessary privileges.", @"message of panel when file cannot be written"));
+	}
+    
+    // Export finished Growl notification
+    [[SPGrowlController sharedGrowlController] notifyWithTitle:@"Export Finished" 
+                                                   description:[NSString stringWithFormat:NSLocalizedString(@"Finished exporting to %@",@"description for finished exporting growl notification"), [[sheet filename] lastPathComponent]] 
+                                              notificationName:@"Export Finished"];
+}
+
+#pragma mark -
+#pragma mark import methods
+
+- (void)importFile
+/*
+ invoked when user clicks on an import menuItem
+ */
+{
+	NSOpenPanel *openPanel = [NSOpenPanel openPanel];
+	[openPanel setAccessoryView:importCSVView];
+	
+	// Show openPanel
+	[openPanel beginSheetForDirectory:[prefs objectForKey:@"openPath"]
+								 file:nil
+					   modalForWindow:tableWindow
+						modalDelegate:self
+					   didEndSelector:@selector(openPanelDidEnd:returnCode:contextInfo:)
+						  contextInfo:nil];
+}
+
+- (IBAction)changeFormat:(id)sender
+{
+	[importCSVBox setHidden:![[[importFormatPopup selectedItem] title] isEqualToString:@"CSV"]];
+}
+
+- (IBAction)changeTable:(id)sender
+{	
+	[tableListView selectRowIndexes:[NSIndexSet indexSetWithIndex:[[tablesListInstance tables] indexOfObject:[fieldMappingPopup titleOfSelectedItem]]] byExtendingSelection:NO];
+	
+	//set up tableView
+	currentRow = 0;
+	fieldMappingArray = nil;
+	[self setupFieldMappingArray];
+	[rowDownButton setEnabled:NO];
+	[rowUpButton setEnabled:([importArray count] > 1)];
+	[recordCountLabel setStringValue:[NSString stringWithFormat:@"%i of %i records", currentRow+1, [importArray count]]];
+	
+	[self updateFieldMappingButtonCell];
+	[fieldMappingTableView reloadData];
+}
+
+- (void)openPanelDidEnd:(NSOpenPanel *)sheet returnCode:(int)returnCode contextInfo:(NSString *)contextInfo
+/*
+ reads mysql-dumpfile
+ */
+{
+	NSString *dumpFile;
+	NSError **errorStr; 
+	NSMutableString *errors = [NSMutableString string];
+	NSString *fileType = [[importFormatPopup selectedItem] title];
+	
+	[sheet orderOut:self];
+	
+	if ( returnCode != NSOKButton )
+		return;
+	
+	//save path to preferences
+	[prefs setObject:[sheet directory] forKey:@"openPath"];
+	
+	//load file into string
+	if ( [NSString respondsToSelector:@selector(stringWithContentsOfFile:encoding:error:)] ) {
+		// mac os 10.4 or later
+		dumpFile = [NSString stringWithContentsOfFile:[sheet filename]
+											 encoding:[CMMCPConnection encodingForMySQLEncoding:[[tableDocumentInstance encoding] cString]]
+												error:errorStr];
+	} else {
+		// mac os pre 10.4
+		dumpFile = [NSString stringWithContentsOfFile:[sheet filename]];
+	}
+	
+	if ( !dumpFile ) {
+		NSBeginAlertSheet(NSLocalizedString(@"Error", @"Title of error alert"),
+						  NSLocalizedString(@"OK", @"OK button"),
+						  nil, nil,
+						  tableWindow, self,
+						  nil, nil, nil,
+						  NSLocalizedString(@"Couldn't open file. Be sure that the path is correct and that you have the necessary privileges.", @"Message of panel when file cannot be opened"));
+		return;
+	}
+	
+	// reset interface
+	[errorsView setString:@""];
+	[errorsView displayIfNeeded];
+	[singleProgressText setStringValue:NSLocalizedString(@"Reading...", @"text showing that app is reading dump")];
+	[singleProgressText displayIfNeeded];
+	[singleProgressBar setDoubleValue:0];
+	[singleProgressBar displayIfNeeded];
+	
+	if ( [fileType isEqualToString:@"SQL"] ) {
+		
+		//import dump file
+		NSArray *queries;
+		int i;
+		
+		//open progress sheet
+		[NSApp beginSheet:singleProgressSheet
+		   modalForWindow:tableWindow
+			modalDelegate:self
+		   didEndSelector:nil
+			  contextInfo:nil];
+		
+		[singleProgressBar setIndeterminate:YES];
+		[singleProgressBar setUsesThreadedAnimation:YES];
+		[singleProgressBar startAnimation:self];
+		
+		//get array with an object for each mysql-query
+		queries = [self splitQueries:dumpFile];
+		
+		[singleProgressBar stopAnimation:self];
+		[singleProgressBar setUsesThreadedAnimation:NO];
+		[singleProgressBar setIndeterminate:NO];
+		
+		//perform all mysql-queries
+		for ( i = 0 ; i < [queries count] ; i++ ) {
+			[singleProgressBar setDoubleValue:((i+1)*100/[queries count])];
+			[singleProgressBar displayIfNeeded];
+			[mySQLConnection queryString:[queries objectAtIndex:i]];
+			
+			if (![[mySQLConnection getLastErrorMessage] isEqualToString:@""] && ![[mySQLConnection getLastErrorMessage] isEqualToString:@"Query was empty"]) {
+				[errors appendString:[NSString stringWithFormat:NSLocalizedString(@"[ERROR in query %d] %@\n", @"error text when multiple custom query failed"), (i+1),[mySQLConnection getLastErrorMessage]]];
+			}
+		}
+		
+		//close progress sheet
+		[NSApp endSheet:singleProgressSheet];
+		[singleProgressSheet orderOut:nil];
+		
+		//display errors
+		if ( [errors length] ) {
+			[errorsView setString:errors];
+			[NSApp beginSheet:errorsSheet
+			   modalForWindow:tableWindow
+				modalDelegate:self
+			   didEndSelector:nil
+				  contextInfo:nil];
+			
+			[NSApp runModalForWindow:errorsSheet];
+			
+			[NSApp endSheet:errorsSheet];
+			[errorsSheet orderOut:nil];
+		}
+		
+		////////////////
+		// IMPORT CSV //
+		////////////////
+		
+	} else if ( [fileType isEqualToString:@"CSV"] ) {
+		//import csv file
+		int code;
+		NSPopUpButtonCell *buttonCell = [[NSPopUpButtonCell alloc] init];
+		
+		//open progress sheet
+		[NSApp beginSheet:singleProgressSheet
+		   modalForWindow:tableWindow
+			modalDelegate:self
+		   didEndSelector:nil 
+			  contextInfo:nil];
+		
+		[singleProgressBar setIndeterminate:YES];
+		[singleProgressBar setUsesThreadedAnimation:YES];
+		[singleProgressBar startAnimation:self];
+		
+		//put file in array
+		if ( importArray )
+			[importArray release];
+		
+		importArray = [[self arrayForCSV:dumpFile
+							terminatedBy:[importFieldsTerminatedField stringValue]
+							  enclosedBy:[importFieldsEnclosedField stringValue]
+							   escapedBy:[importFieldsEscapedField stringValue]
+								lineEnds:[importLinesTerminatedField stringValue]] retain];
+		
+		//close progress sheet
+		[NSApp endSheet:singleProgressSheet];
+		[singleProgressSheet orderOut:nil];
+		[singleProgressBar stopAnimation:self];
+		[singleProgressBar setUsesThreadedAnimation:NO];
+		[singleProgressBar setIndeterminate:NO];
+		
+		
+		CMMCPResult *theResult;
+		int i;
+		theResult = (CMMCPResult *) [mySQLConnection listTables];
+		if ([theResult numOfRows]) [theResult dataSeek:0];
+		for ( i = 0 ; i < [theResult numOfRows] ; i++ ) {
+			[fieldMappingPopup addItemWithTitle:[[theResult fetchRowAsArray] objectAtIndex:0]];
+		}
+		
+		if ([tableDocumentInstance table] != nil && ![(NSString *)[tableDocumentInstance table] isEqualToString:@""]) {
+			[fieldMappingPopup selectItemWithTitle:[(TableDocument *)tableDocumentInstance table]];
+		} else {
+			[fieldMappingPopup selectItemAtIndex:0];
+		}
+		
+		[tableListView selectRowIndexes:[NSIndexSet indexSetWithIndex:[[tablesListInstance tables] indexOfObject:[fieldMappingPopup titleOfSelectedItem]]] byExtendingSelection:NO];
+		
+		//set up tableView
+   		currentRow = 0;
+		fieldMappingArray = nil;
+		[self setupFieldMappingArray];
+		[rowDownButton setEnabled:NO];
+		[rowUpButton setEnabled:([importArray count] > 1)];
+		[recordCountLabel setStringValue:[NSString stringWithFormat:@"%i of %i records", currentRow+1, [importArray count]]];
+		
+		//set up tableView buttons
+		[buttonCell setControlSize:NSSmallControlSize];
+		[buttonCell setFont:[NSFont labelFontOfSize:[NSFont smallSystemFontSize]]];
+		[buttonCell setBordered:NO];
+		[[fieldMappingTableView tableColumnWithIdentifier:@"value"] setDataCell:buttonCell];
+		[self updateFieldMappingButtonCell];
+		[fieldMappingTableView reloadData];
+		
+		// show fieldMapping sheet
+		[NSApp beginSheet:fieldMappingSheet
+		   modalForWindow:tableWindow
+			modalDelegate:self
+		   didEndSelector:nil
+			  contextInfo:nil];
+		
+		code = [NSApp runModalForWindow:fieldMappingSheet];
+		
+		[NSApp endSheet:fieldMappingSheet];
+		[fieldMappingSheet orderOut:nil];
+		
+		if ( code ) {
+			//import array into db
+			NSMutableString *fNames = [NSMutableString string];
+			//NSMutableArray *fValuesIndexes = [NSMutableArray array];
+			NSMutableString *fValues = [NSMutableString string];
+			int i,j;
+			
+			//open progress sheet
+			[NSApp beginSheet:singleProgressSheet
+			   modalForWindow:tableWindow
+				modalDelegate:self
+			   didEndSelector:nil
+				  contextInfo:nil];
+			
+			// get fields to be imported
+			for (i = 0; i < [fieldMappingArray count] ; i++ ) {		
+				if ([[fieldMappingArray objectAtIndex:i] intValue] > 0) {
+					if ( [fNames length] )
+                        [fNames appendString:@","];
+					
+					[fNames appendString:[NSString stringWithFormat:@"`%@`", [[tableSourceInstance fieldNames] objectAtIndex:i]]];
+				}
+			}
+			
+			//import array
+			for ( i = 0 ; i < [importArray count] ; i++ ) {
+				//show progress bar
+				[singleProgressBar setDoubleValue:((i+1)*100/[importArray count])];
+				[singleProgressBar displayIfNeeded];
+				
+                if ( !([importFieldNamesSwitch state] && (i == 0)) ) {
+					//put values in string
+					[fValues setString:@""];
+					
+                    for ( j = 0 ; j < [fieldMappingArray count] ; j++ ) {
+						
+						if ([[fieldMappingArray objectAtIndex:j] intValue] > 0) {
+							if ( [fValues length] )
+								[fValues appendString:@","];
+							
+							if ([[[importArray objectAtIndex:i] objectAtIndex:([[fieldMappingArray objectAtIndex:j] intValue] - 1)] isMemberOfClass:[NSNull class]] ) {
+								[fValues appendString:@"NULL"];
+							} else {
+								[fValues appendString:[NSString stringWithFormat:@"'%@'",[mySQLConnection prepareString:[[importArray objectAtIndex:i] objectAtIndex:([[fieldMappingArray objectAtIndex:j] intValue] - 1)]]]];
+							}
+						}
+					}
+					
+					//perform query
+					[mySQLConnection queryString:[NSString stringWithFormat:@"INSERT INTO `%@` (%@) VALUES (%@)",
+												  [fieldMappingPopup titleOfSelectedItem],
+												  fNames,
+												  fValues]];
+					
+					if ( ![[mySQLConnection getLastErrorMessage] isEqualToString:@""] ) {
+						[errors appendString:[NSString stringWithFormat:NSLocalizedString(@"[ERROR in line %d] %@\n", @"error text when reading of csv file gave errors"), (i+1),[mySQLConnection getLastErrorMessage]]];				
+					}
+				}
+			}
+			
+			//close progress sheet
+			[NSApp endSheet:singleProgressSheet];
+			[singleProgressSheet orderOut:nil];
+		}
+		
+		[tableContentInstance reloadTableValues:self];
+		
+		//display errors
+		if ( [errors length] ) {
+			[errorsView setString:errors];
+			[NSApp beginSheet:errorsSheet
+			   modalForWindow:tableWindow
+				modalDelegate:self
+			   didEndSelector:nil
+				  contextInfo:nil];
+			
+			[NSApp runModalForWindow:errorsSheet];
+			
+			[NSApp endSheet:errorsSheet];
+			[errorsSheet orderOut:nil];
+		}
+		
+		//free arrays
+		fieldMappingArray = nil;
+		importArray = nil;
+	}
+	
+    // Import finished Growl notification
+    [[SPGrowlController sharedGrowlController] notifyWithTitle:@"Import Finished" 
+                                                   description:[NSString stringWithFormat:NSLocalizedString(@"Finished importing %@",@"description for finished importing growl notification"), [[sheet filename] lastPathComponent]] 
+                                              notificationName:@"Import Finished"];
+}
+
+- (void)setupFieldMappingArray
+/*
+ sets up the fieldMapping array to be shown in the tableView
+ */
+{
+	int i, value;
+	
+    if ( fieldMappingArray ) {
+		
+		//        for ( i = 0 ; i < [fieldMappingArray count] ; i++ ) {
+		//			
+		//			if ( [[[importArray objectAtIndex:currentRow] objectAtIndex:i] isKindOfClass:[NSNull class]] ) {
+		//                [fieldMappingArray replaceObjectAtIndex:i withObject:0];
+		//				
+		//            } else {
+		//                [fieldMappingArray replaceObjectAtIndex:i withObject:[[importArray objectAtIndex:currentRow] objectAtIndex:0]];
+		//            }
+		//        }
+		
+    } else {
+        fieldMappingArray = [NSMutableArray array];
+		
+		for (i = 0; i < [[tableSourceInstance fieldNames] count]; i++) {
+			if (i < [[importArray objectAtIndex:currentRow] count] && ![[[importArray objectAtIndex:currentRow] objectAtIndex:i] isKindOfClass:[NSNull class]]) {
+				value = i + 1;
+			} else {
+				value = 0;
+			}
+			
+            [fieldMappingArray addObject:[NSNumber numberWithInt:value]];
+        }
+		
+        [fieldMappingArray retain];
+    }
+	
+    [fieldMappingTableView reloadData];
+}
+
+/*
+ * Update the NSButtonCell items for use in the field mapping display
+ */
+- (void)updateFieldMappingButtonCell
+{
+	int i;
+	
+	[fieldMappingButtonOptions setArray:[importArray objectAtIndex:currentRow]];
+	for (i = 0; i < [fieldMappingButtonOptions count]; i++) {
+		if ([[fieldMappingButtonOptions objectAtIndex:i] isNSNull]) {
+			[fieldMappingButtonOptions replaceObjectAtIndex:i withObject:[NSString stringWithFormat:@"%i. %@", i+1, [prefs objectForKey:@"nullValue"]]];
+		} else {
+			[fieldMappingButtonOptions replaceObjectAtIndex:i withObject:[NSString stringWithFormat:@"%i. %@", i+1, [fieldMappingButtonOptions objectAtIndex:i]]];
+		}
+	}
+}
+
+- (IBAction)stepRow:(id)sender
+/*
+ displays next/previous row in fieldMapping tableView
+ */
+{
+	if ( [sender tag] == 0 ) {
+		currentRow--;
+	} else {
+		currentRow++;
+	}
+	[self updateFieldMappingButtonCell];
+	
+	//-----------[self setupFieldMappingArray];
+	[fieldMappingTableView reloadData];
+	
+	[recordCountLabel setStringValue:[NSString stringWithFormat:@"%i of %i records", currentRow+1, [importArray count]]];
+	
+	// enable/disable buttons
+	[rowDownButton setEnabled:(currentRow != 0)];
+	[rowUpButton setEnabled:(currentRow != ([importArray count]-1))];
+}
+
+#pragma mark -
+#pragma mark format methods
+
+
+/*
+ Dump the selected tables to a file handle in SQL format.
+ */
+- (BOOL)dumpSelectedTablesAsSqlToFileHandle:(NSFileHandle *)fileHandle
+{
+	int i,j,t,rowCount, progressBarWidth, lastProgressValue, queryLength;
+	CMMCPResult *queryResult;
+	NSString *tableName;
+	NSArray *fieldNames;
+	NSArray *theRow;
+	NSMutableArray *selectedTables = [NSMutableArray array];
+	NSMutableString *headerString = [NSMutableString string];
+	NSMutableString *cellValue = [NSMutableString string];
+	NSMutableString *sqlString = [NSMutableString string];
+	NSMutableString *errors = [NSMutableString string];
+	NSStringEncoding connectionEncoding = [mySQLConnection encoding];
+	NSScanner *sqlNumericTester;
+	id createTableSyntax;
+	
+	// Reset the interface
+	[errorsView setString:@""];
+	[errorsView displayIfNeeded];
+	[singleProgressText setStringValue:NSLocalizedString(@"Dumping...", @"text showing that app is writing dump")];
+	[singleProgressText displayIfNeeded];
+	progressBarWidth = (int)[singleProgressBar bounds].size.width;
+	[singleProgressBar setDoubleValue:0];
+	[singleProgressBar displayIfNeeded];
+	
+	// Open the progress sheet
+	[NSApp beginSheet:singleProgressSheet
+	   modalForWindow:tableWindow modalDelegate:self
+	   didEndSelector:nil contextInfo:nil];
+	
+	// Copy over the selected table names into a table in preparation for iteration
+	for ( i = 0 ; i < [tables count] ; i++ ) {
+		if ( [[[tables objectAtIndex:i] objectAtIndex:0] boolValue] ) {
+			[selectedTables addObject:[NSString stringWithString:[[tables objectAtIndex:i] objectAtIndex:1]]];
+		}
+	}
+	
+	// Add the dump header to the dump file.
+	[headerString setString:@"# Sequel Pro dump\n"];
+	[headerString appendString:[NSString stringWithFormat:@"# Version %@\n",
+								[[NSBundle mainBundle] objectForInfoDictionaryKey:@"CFBundleVersion"]]];
+	[headerString appendString:@"# http://code.google.com/p/sequel-pro\n#\n"];
+	[headerString appendString:[NSString stringWithFormat:@"# Host: %@ (MySQL %@)\n",
+								[tableDocumentInstance host], [tableDocumentInstance mySQLVersion]]];
+	[headerString appendString:[NSString stringWithFormat:@"# Database: %@\n", [tableDocumentInstance database]]];
+	[headerString appendString:[NSString stringWithFormat:@"# Generation Time: %@\n", [NSDate date]]];
+	[headerString appendString:@"# ************************************************************\n\n"];
+	[fileHandle writeData:[headerString dataUsingEncoding:connectionEncoding]];
+	
+	// Loop through the selected tables
+	for ( i = 0 ; i < [selectedTables count] ; i++ ) {
+		lastProgressValue = 0;
+		
+		// Update the progress text and reset the progress bar to indeterminate status while fetching data
+		tableName = [selectedTables objectAtIndex:i];
+		[singleProgressText setStringValue:[NSString stringWithFormat:NSLocalizedString(@"Table %i of %i (%@): Fetching data...", @"text showing that app is fetching data for table dump"), (i+1), [selectedTables count], tableName]];
+		[singleProgressText displayIfNeeded];
+		[singleProgressBar setIndeterminate:YES];
+		[singleProgressBar setUsesThreadedAnimation:YES];
+		[singleProgressBar startAnimation:self];
+		
+		// Add the name of table
+		[fileHandle writeData:[[NSString stringWithFormat:@"# Dump of table %@\n# ------------------------------------------------------------\n\n", tableName]
+							   dataUsingEncoding:connectionEncoding]];
+		
+		
+		// Add a "drop table" command if specified in the export dialog
+		if ( [addDropTableSwitch state] == NSOnState )
+			[fileHandle writeData:[[NSString stringWithFormat:@"DROP TABLE IF EXISTS `%@`;\n\n", tableName]
+								   dataUsingEncoding:connectionEncoding]];
+		
+		// Add the create syntax for the table if specified in the export dialog
+		if ( [addCreateTableSwitch state] == NSOnState ) {
+			queryResult = [mySQLConnection queryString:[NSString stringWithFormat:@"SHOW CREATE TABLE `%@`", tableName]];
+			if ( [queryResult numOfRows] ) {
+				createTableSyntax = [[queryResult fetchRowAsDictionary] objectForKey:@"Create Table"];
+				if ( [createTableSyntax isKindOfClass:[NSData class]] ) {
+					createTableSyntax = [[[NSString alloc] initWithData:createTableSyntax encoding:connectionEncoding] autorelease];
+				}
+				[fileHandle writeData:[createTableSyntax dataUsingEncoding:connectionEncoding]];
+				[fileHandle writeData:[[NSString stringWithString:@";\n\n"] dataUsingEncoding:connectionEncoding]];
+			}
+			if ( ![[mySQLConnection getLastErrorMessage] isEqualToString:@""] ) {
+				[errors appendString:[NSString stringWithFormat:@"%@\n", [mySQLConnection getLastErrorMessage]]];
+				if ( [addErrorsSwitch state] == NSOnState ) {
+					[fileHandle writeData:[[NSString stringWithFormat:@"# Error: %@\n", [mySQLConnection getLastErrorMessage]] dataUsingEncoding:connectionEncoding]];
+				}
+			}
+		}
+		
+		// Add the table content if required
+		if ( [addTableContentSwitch state] == NSOnState ) {
+			queryResult = [mySQLConnection queryString:[NSString stringWithFormat:@"SELECT * FROM `%@`", tableName]];
+			fieldNames = [queryResult fetchFieldNames];
+			rowCount = [queryResult numOfRows];
+			
+			// Update the progress text and set the progress bar back to determinate
+			[singleProgressText setStringValue:[NSString stringWithFormat:NSLocalizedString(@"Table %i of %i (%@): Dumping...", @"text showing that app is writing data for table dump"), (i+1), [selectedTables count], tableName]];
+			[singleProgressText displayIfNeeded];
+			[singleProgressBar stopAnimation:self];
+			[singleProgressBar setUsesThreadedAnimation:NO];
+			[singleProgressBar setIndeterminate:NO];
+			[singleProgressBar setDoubleValue:0];
+			[singleProgressBar displayIfNeeded];
+			
+			if (rowCount) {
+				[queryResult dataSeek:0];
+				queryLength = 0;
+				
+				// Construct the start of the insertion command
+				[fileHandle writeData:[[NSString stringWithFormat:@"INSERT INTO `%@` (`%@`)\nVALUES\n\t(",
+										tableName, [fieldNames componentsJoinedByString:@"`,`"]] dataUsingEncoding:connectionEncoding]];
+				
+				// Iterate through the rows to construct a VALUES group for each
+				for ( j = 0 ; j < rowCount ; j++ ) {
+					theRow = [queryResult fetchRowAsArray];
+					[sqlString setString:@""];
+					
+					// Update the progress bar
+					[singleProgressBar setDoubleValue:((j+1)*100/rowCount)];
+					if ((int)[singleProgressBar doubleValue] > lastProgressValue) {
+						lastProgressValue = (int)[singleProgressBar doubleValue];
+						[singleProgressBar displayIfNeeded];
+					}
+					
+					for ( t = 0 ; t < [theRow count] ; t++ ) {
+						
+						// Add NULL values directly to the output row
+						if ( [[theRow objectAtIndex:t] isMemberOfClass:[NSNull class]] ) {
+							[sqlString appendString:@"NULL"];
+							
+							// Add data types directly as hex data
+						} else if ( [[theRow objectAtIndex:t] isKindOfClass:[NSData class]] ) {
+							[sqlString appendString:@"X'"];
+							[sqlString appendString:[mySQLConnection prepareBinaryData:[theRow objectAtIndex:t]]];
+							[sqlString appendString:@"'"];
+							
+						} else {
+							[cellValue setString:[[theRow objectAtIndex:t] description]];
+							
+							// Add empty strings as a pair of quotes
+							if ([cellValue length] == 0) {
+								[sqlString appendString:@"''"];
+								
+							} else {
+								
+								// Test whether this cell contains a number
+								sqlNumericTester = [NSScanner scannerWithString:cellValue];
+								
+								// If it does contain a number, add the number directly
+								if ([sqlNumericTester scanFloat:nil] && [sqlNumericTester isAtEnd]) {
+									[sqlString appendString:cellValue];
+									
+									// Otherwise add a quoted string with special characters escaped
+								} else {
+									[sqlString appendString:@"'"];
+									[sqlString appendString:[mySQLConnection prepareString:cellValue]];
+									[sqlString appendString:@"'"];
+								}
+							}
+						}
+						
+						// Add the field separator if this isn't the last cell in the row
+						if (t != [theRow count] - 1) [sqlString appendString:@","];
+					}
+					
+					queryLength += [sqlString length];
+					
+					// Close this VALUES group and set up the next one if appropriate
+					if (j != rowCount - 1) {
+						
+						// Add a new INSERT starter command every ~250k of data.
+						if (queryLength > 250000) {
+							[sqlString appendString:[NSString stringWithFormat:@");\n\nINSERT INTO `%@` (`%@`)\nVALUES\n\t(",
+													 tableName, [fieldNames componentsJoinedByString:@"`,`"]]];
+							queryLength = 0;
+						} else {
+							[sqlString appendString:@"),\n\t("];
+						}
+					} else {
+						[sqlString appendString:@")"];
+					}
+					
+					// Write this row to the file
+					[fileHandle writeData:[sqlString dataUsingEncoding:connectionEncoding]];
+				}
+				
+				// Complete the command
+				[fileHandle writeData:[[NSString stringWithString:@";\n\n"] dataUsingEncoding:connectionEncoding]];
+				
+				if ( ![[mySQLConnection getLastErrorMessage] isEqualToString:@""] ) {
+					[errors appendString:[NSString stringWithFormat:@"%@\n", [mySQLConnection getLastErrorMessage]]];
+					if ( [addErrorsSwitch state] == NSOnState ) {
+						[fileHandle writeData:[[NSString stringWithFormat:@"# Error: %@\n", [mySQLConnection getLastErrorMessage]]
+											   dataUsingEncoding:connectionEncoding]];
+					}
+				}
+			}
+		}
+		
+		// Add an additional separator between tables
+		[fileHandle writeData:[[NSString stringWithString:@"\n\n"] dataUsingEncoding:connectionEncoding]];
+	}
+	
+	// Close the progress sheet
+	[NSApp endSheet:singleProgressSheet];
+	[singleProgressSheet orderOut:nil];
+	
+	// Show errors sheet if there have been errors
+	if ( [errors length] ) {
+		[errorsView setString:errors];
+		[NSApp beginSheet:errorsSheet
+		   modalForWindow:tableWindow modalDelegate:self
+		   didEndSelector:nil contextInfo:nil];
+		[NSApp runModalForWindow:errorsSheet];
+		
+		[NSApp endSheet:errorsSheet];
+		[errorsSheet orderOut:nil];
+	}
+	
+	return TRUE;
+}
+
+/*
+ Takes an array and writes it in CSV format to the supplied NSFileHandle
+ */
+- (BOOL)writeCsvForArray:(NSArray *)array orQueryResult:(CMMCPResult *)queryResult toFileHandle:(NSFileHandle *)fileHandle outputFieldNames:(BOOL)outputFieldNames terminatedBy:(NSString *)fieldSeparatorString
+			  enclosedBy:(NSString *)enclosingString escapedBy:(NSString *)escapeString lineEnds:(NSString *)lineEndString silently:(BOOL)silently;
+{
+	NSStringEncoding tableEncoding = [CMMCPConnection encodingForMySQLEncoding:[[tableDocumentInstance encoding] cString]];
+	NSMutableString *csvCell = [NSMutableString string];
+	NSMutableArray *csvRow = [NSMutableArray array];
+	NSMutableString *csvString = [NSMutableString string];
+	NSString *nullString = [NSString stringWithString:[prefs objectForKey:@"nullValue"]];
+	NSString *escapedEscapeString, *escapedFieldSeparatorString, *escapedEnclosingString, *escapedLineEndString;
+	NSString *dataConversionString;
+	NSScanner *csvNumericTester;
+	BOOL quoteFieldSeparators = [enclosingString isEqualToString:@""];
+	BOOL csvCellIsNumeric;
+	int i, j, startingRow, totalRows, progressBarWidth, lastProgressValue;
+	
+	if (queryResult != nil && [queryResult numOfRows]) [queryResult dataSeek:0];
+	
+	// Detect and restore special characters being used as terminating or line end strings
+	NSMutableString *tempSeparatorString = [NSMutableString stringWithString:fieldSeparatorString];
+	[tempSeparatorString replaceOccurrencesOfString:@"\\t" withString:@"\t"
+											options:NSLiteralSearch
+											  range:NSMakeRange(0, [tempSeparatorString length])];
+	[tempSeparatorString replaceOccurrencesOfString:@"\\n" withString:@"\n"
+											options:NSLiteralSearch
+											  range:NSMakeRange(0, [tempSeparatorString length])];
+	[tempSeparatorString replaceOccurrencesOfString:@"\\r" withString:@"\r"
+											options:NSLiteralSearch
+											  range:NSMakeRange(0, [tempSeparatorString length])];
+	fieldSeparatorString = [NSString stringWithString:tempSeparatorString];
+	NSMutableString *tempLineEndString = [NSMutableString stringWithString:lineEndString];
+	[tempLineEndString replaceOccurrencesOfString:@"\\t" withString:@"\t"
+										  options:NSLiteralSearch
+											range:NSMakeRange(0, [tempLineEndString length])];
+	[tempLineEndString replaceOccurrencesOfString:@"\\n" withString:@"\n"
+										  options:NSLiteralSearch
+											range:NSMakeRange(0, [tempLineEndString length])];
+	[tempLineEndString replaceOccurrencesOfString:@"\\r" withString:@"\r"
+										  options:NSLiteralSearch
+											range:NSMakeRange(0, [tempLineEndString length])];
+	lineEndString = [NSString stringWithString:tempLineEndString];
+	
+	// Updating the progress bar can take >20% of processing time - store details to only update when required
+	progressBarWidth = (int)[singleProgressBar bounds].size.width;
+	lastProgressValue = 0;
+	[singleProgressBar setDoubleValue:0];
+	[singleProgressBar displayIfNeeded];
+	
+	if ( !silently ) {
+		
+		// Set the progress text
+		[singleProgressText setStringValue:NSLocalizedString(@"Exporting...", @"text showing that app is exporting to text file")];
+		[singleProgressText displayIfNeeded];
+		
+		
+		// Open progress sheet
+		[NSApp beginSheet:singleProgressSheet
+		   modalForWindow:tableWindow modalDelegate:self
+		   didEndSelector:nil contextInfo:nil];
+	}
+	
+	// Set up escaped versions of strings for substitution within the loop
+	escapedEscapeString = [NSString stringWithFormat:@"%@%@", escapeString, escapeString];
+	escapedFieldSeparatorString = [NSString stringWithFormat:@"%@%@", escapeString, fieldSeparatorString];
+	escapedEnclosingString = [NSString stringWithFormat:@"%@%@", escapeString, enclosingString];
+	escapedLineEndString = [NSString stringWithFormat:@"%@%@", escapeString, lineEndString];
+	
+	// Determine the total number of rows and starting row depending on supplied data format
+	if (array == nil) {
+		startingRow = outputFieldNames ? -1 : 0;
+		totalRows = [queryResult numOfRows];
+	} else {
+		startingRow = outputFieldNames ? 0 : 1;
+		totalRows = [array count];
+	}
+	
+	// Walk through the supplied data constructing the CSV string
+	for ( i = startingRow ; i < totalRows ; i++ ) {
+		
+		// Update the progress bar
+		[singleProgressBar setDoubleValue:((i+1)*100/totalRows)];
+		if ((int)[singleProgressBar doubleValue] > lastProgressValue) {
+			lastProgressValue = (int)[singleProgressBar doubleValue];
+			[singleProgressBar displayIfNeeded];
+		}
+		
+		// Retrieve the row from the supplied data
+		if (array == nil) {
+			
+			// Header row
+			if (i == -1) {
+				[csvRow setArray:[queryResult fetchFieldNames]];
+			} else {
+				[csvRow setArray:[queryResult fetchRowAsArray]];
+			}
+		} else {
+			[csvRow setArray:[array objectAtIndex:i]];		
+		}
+		
+		[csvString setString:@""];
+		for ( j = 0 ; j < [csvRow count] ; j++ ) {
+			
+			// For NULL objects supplied from a queryResult, add an unenclosed null string as per prefs
+			if ([[csvRow objectAtIndex:j] isKindOfClass:[NSNull class]]) {
+				[csvString appendString:nullString];
+				if (j < [csvRow count] - 1) [csvString appendString:fieldSeparatorString];
+				continue;
+			}
+			
+			// Retrieve the contents of this cell
+			if ([[csvRow objectAtIndex:j] isKindOfClass:[NSData class]]) {
+				dataConversionString = [[NSString alloc] initWithData:[csvRow objectAtIndex:j] encoding:tableEncoding];
+				[csvCell setString:[NSString stringWithString:dataConversionString]];
+				[dataConversionString release];
+			} else {
+				[csvCell setString:[[csvRow objectAtIndex:j] description]];
+			}
+			
+			// For NULL values supplied via an array add the unenclosed null string as set in preferences
+			if ( [csvCell isEqualToString:nullString] ) {
+				[csvString appendString:nullString];
+
+			// Add empty strings as a pair of enclosing characters.
+			} else if ( [csvCell length] == 0 ) {
+				[csvString appendString:enclosingString];
+				[csvString appendString:enclosingString];
+				
+			} else {
+				
+				// Test whether this cell contains a number
+				if ([[csvRow objectAtIndex:j] isKindOfClass:[NSData class]]) {
+					csvCellIsNumeric = FALSE;
+				} else {
+					csvNumericTester = [NSScanner scannerWithString:csvCell];
+					csvCellIsNumeric = [csvNumericTester scanFloat:nil] && [csvNumericTester isAtEnd];
+				}
+				
+				// Escape any occurrences of the escaping character
+				[csvCell replaceOccurrencesOfString:escapeString
+										 withString:escapedEscapeString
+											options:NSLiteralSearch
+											  range:NSMakeRange(0,[csvCell length])];
+				
+				// Escape any occurrences of the enclosure string
+				if ( ![escapeString isEqualToString:enclosingString] ) {
+					[csvCell replaceOccurrencesOfString:enclosingString
+											 withString:escapedEnclosingString
+												options:NSLiteralSearch
+												  range:NSMakeRange(0,[csvCell length])];
+				}
+				
+				// Escape occurrences of the line end character
+				[csvCell replaceOccurrencesOfString:lineEndString
+									 withString:escapedLineEndString
+										options:NSLiteralSearch
+										  range:NSMakeRange(0,[csvCell length])];
+
+				// If the string isn't quoted or otherwise enclosed, escape occurrences of the
+				// field separators
+				if ( quoteFieldSeparators || csvCellIsNumeric ) {
+					[csvCell replaceOccurrencesOfString:fieldSeparatorString
+											 withString:escapedFieldSeparatorString
+												options:NSLiteralSearch
+												  range:NSMakeRange(0,[csvCell length])];
+				}
+				
+				// Write out the cell data by appending strings - this is significantly faster than stringWithFormat.
+				if (csvCellIsNumeric) {
+					[csvString appendString:csvCell];
+				} else {
+					[csvString appendString:enclosingString];
+					[csvString appendString:csvCell];
+					[csvString appendString:enclosingString];
+				}
+			}
+			if (j < [csvRow count] - 1) [csvString appendString:fieldSeparatorString];
+		}
+		
+		// Append the line ending to the string for this row
+		[csvString appendString:lineEndString];
+		
+		// Write it to the fileHandle
+		[fileHandle writeData:[csvString dataUsingEncoding:tableEncoding]];
+	}
+	
+	// Close the progress sheet if it's present
+	if ( !silently ) {
+		[NSApp endSheet:singleProgressSheet];
+		[singleProgressSheet orderOut:nil];
+	}
+	
+	return TRUE;
+}
+
+- (NSArray *)arrayForCSV:(NSString *)csv terminatedBy:(NSString *)terminated
+			  enclosedBy:(NSString *)enclosed escapedBy:(NSString *)escaped lineEnds:(NSString *)lineEnds
+/*
+ loads a csv string into an array
+ */
+{
+	NSMutableString *tempTerminated, *tempLineEnds;
+	NSMutableArray *tempArray = [NSMutableArray array];
+	NSMutableArray *tempRowArray = [NSMutableArray array];
+	NSMutableString *mutableField;
+	NSScanner *scanner;
+	NSString *scanString;
+	NSMutableString *tempString = [NSMutableString string];
+	NSMutableArray *linesArray = [NSMutableArray array];
+	BOOL isEscaped, br;
+	int fieldCount = nil;
+	int x,i,j;
+
+	//repare tabs and line ends
+	tempTerminated = [NSMutableString stringWithString:terminated];
+	[tempTerminated replaceOccurrencesOfString:@"\\t" withString:@"\t"
+									   options:NSLiteralSearch
+										 range:NSMakeRange(0, [tempTerminated length])];
+	[tempTerminated replaceOccurrencesOfString:@"\\n" withString:@"\n"
+									   options:NSLiteralSearch
+										 range:NSMakeRange(0, [tempTerminated length])];
+	[tempTerminated replaceOccurrencesOfString:@"\\r" withString:@"\r"
+									   options:NSLiteralSearch
+										 range:NSMakeRange(0, [tempTerminated length])];
+	terminated = [NSString stringWithString:tempTerminated];
+	tempLineEnds = [NSMutableString stringWithString:lineEnds];
+	[tempLineEnds replaceOccurrencesOfString:@"\\t" withString:@"\t"
+									 options:NSLiteralSearch
+									   range:NSMakeRange(0, [tempLineEnds length])];
+	[tempLineEnds replaceOccurrencesOfString:@"\\n" withString:@"\n"
+									 options:NSLiteralSearch
+									   range:NSMakeRange(0, [tempLineEnds length])];
+	[tempLineEnds replaceOccurrencesOfString:@"\\r" withString:@"\r"
+									 options:NSLiteralSearch
+									   range:NSMakeRange(0, [tempLineEnds length])];
+	lineEnds = [NSString stringWithString:tempLineEnds];
+	
+	//array with one line per object
+	scanner = [NSScanner scannerWithString:csv];
+	[scanner setCharactersToBeSkipped:nil];
+	
+	while ( ![scanner isAtEnd] ) {
+		[tempString setString:@""];
+		br = NO;
+		
+		while ( !br ) {
+			scanString = @"";
+			[scanner scanUpToString:lineEnds intoString:&scanString];
+			[tempString appendString:scanString];
+			[scanner scanString:lineEnds intoString:&scanString];
+			
+			//test if lineEnds-character is escaped
+			isEscaped = NO;
+			j = 1;
+			if ( ![escaped isEqualToString:enclosed] && ![escaped isEqualToString:@""] ) {
+				while ( ((j*[escaped length])<=[tempString length]) &&
+					   ([[tempString substringWithRange:NSMakeRange(([tempString length]-(j*[escaped length])),[escaped length])] isEqualToString:escaped]) ) {
+					isEscaped = !isEscaped;
+					j++;
+				}
+			}
+			if ( !isEscaped || [scanner isAtEnd] ) {
+				//end of row
+				br = YES;
+			} else {
+				//lineEnds-character was escaped
+				[tempString appendString:scanString];
+			}
+		}
+		
+		// Skip blank lines
+		if (![tempString length]) continue;
+		
+		// Add the line to the array
+		[linesArray addObject:[NSString stringWithString:tempString]];
+	}
+	
+	for ( x = 0 ; x < [linesArray count] ; x++ ) {
+		
+		//separate fields
+		[tempRowArray removeAllObjects];
+		[tempRowArray addObjectsFromArray:[self arrayForString:[linesArray objectAtIndex:x] enclosed:enclosed escaped:escaped terminated:terminated]];
+		if ( x == 0 ) {
+			fieldCount = [tempRowArray count];
+		} else {
+			while ( [tempRowArray count] < fieldCount ) {
+				[tempRowArray addObject:[NSString stringWithString:[prefs objectForKey:@"nullValue"]]];
+			}
+		}
+		for ( i = 0 ; i < [tempRowArray count] ; i++ ) {
+			
+			// Insert a NSNull object if the cell contains an unescaped null character or an unescaped string
+			// which matches the NULL string set in preferences.
+			if ( [[tempRowArray objectAtIndex:i] isEqualToString:@"\\N"] || [[tempRowArray objectAtIndex:i] isEqualToString:[prefs objectForKey:@"nullValue"]] ) {
+				[tempRowArray replaceObjectAtIndex:i withObject:[NSNull null]];
+				
+			} else {
+				
+				//strip enclosed and escaped characters
+				mutableField = [NSMutableString stringWithString:[tempRowArray objectAtIndex:i]];
+				
+				//strip enclosed characters
+				if ( [mutableField length] >= (2*[enclosed length]) ) {
+					if ( [[mutableField substringToIndex:[enclosed length]] isEqualToString:enclosed] ) {
+						[mutableField deleteCharactersInRange:NSMakeRange(0,[enclosed length])];
+					}
+					if ( [[mutableField substringFromIndex:([mutableField length]-[enclosed length])] isEqualToString:enclosed] ) {
+						[mutableField deleteCharactersInRange:NSMakeRange(([mutableField length]-[enclosed length]),[enclosed length])];
+					}
+				}
+				if ( [mutableField length] >= [enclosed length] ) {
+					if ( [[mutableField substringFromIndex:([mutableField length]-[enclosed length])] isEqualToString:enclosed] ) {
+						[mutableField deleteCharactersInRange:NSMakeRange(([mutableField length]-[enclosed length]),[enclosed length])];
+					}
+				}
+				//strip escaped characters
+				if ( ![enclosed isEqualToString:@""] ) {
+					[mutableField replaceOccurrencesOfString:[NSString stringWithFormat:@"%@%@", escaped, enclosed] withString:enclosed options:NSLiteralSearch range:NSMakeRange(0, [mutableField length])];
+				} else {
+					[mutableField replaceOccurrencesOfString:[NSString stringWithFormat:@"%@%@", escaped, terminated] withString:terminated options:NSLiteralSearch range:NSMakeRange(0, [mutableField length])];
+				}
+				if ( ![lineEnds isEqualToString:@""] ) {
+					[mutableField replaceOccurrencesOfString:[NSString stringWithFormat:@"%@%@", escaped, lineEnds] withString:lineEnds options:NSLiteralSearch range:NSMakeRange(0, [mutableField length])];
+				}
+				if ( ![escaped isEqualToString:@""] && ![escaped isEqualToString:enclosed] ) {
+					[mutableField replaceOccurrencesOfString:[NSString stringWithFormat:@"%@%@", escaped, escaped] withString:escaped options:NSLiteralSearch range:NSMakeRange(0, [mutableField length])];
+				}
+				//add field to tempRowArray
+				[tempRowArray replaceObjectAtIndex:i withObject:[NSString stringWithString:mutableField]];
+			}
+		}
+		//add row to tempArray
+		[tempArray addObject:[NSArray arrayWithArray:tempRowArray]];
+	}
+	
+	return [NSArray arrayWithArray:tempArray];
+}
+
+
+/*
+ Takes an array and writes it in XML format to the supplied NSFileHandle
+ */
+- (BOOL)writeXmlForArray:(NSArray *)array orQueryResult:(CMMCPResult *)queryResult toFileHandle:(NSFileHandle *)fileHandle tableName:(NSString *)table withHeader:(BOOL)header silently:(BOOL)silently
+{
+	NSStringEncoding tableEncoding = [CMMCPConnection encodingForMySQLEncoding:[[tableDocumentInstance encoding] cString]];
+	NSMutableArray *xmlTags = [NSMutableArray array];
+	NSMutableArray *xmlRow = [NSMutableArray array];
+	NSMutableString *xmlString = [NSMutableString string];
+	NSMutableString *xmlItem = [NSMutableString string];
+	NSString *dataConversionString;
+	int i,j, startingRow, totalRows, progressBarWidth, lastProgressValue;
+	
+	if (queryResult != nil && [queryResult numOfRows]) [queryResult dataSeek:0];
+	
+	// Updating the progress bar can take >20% of processing time - store details to only update when required
+	progressBarWidth = (int)[singleProgressBar bounds].size.width;
+	lastProgressValue = 0;
+	[singleProgressBar setDoubleValue:0];
+	[singleProgressBar displayIfNeeded];
+	
+	// Set up an array of encoded field names as opening and closing tags
+	if (array == nil) {
+		[xmlRow setArray:[queryResult fetchFieldNames]];	
+	} else {
+		[xmlRow setArray:[array objectAtIndex:0]];
+	}
+	for ( j = 0; j < [xmlRow count]; j++ ) {
+		[xmlTags addObject:[NSMutableArray array]];
+		[[xmlTags objectAtIndex:j] addObject:[NSString stringWithFormat:@"\t\t<%@>",
+											  [self htmlEscapeString:[[xmlRow objectAtIndex:j] description]]]];
+		[[xmlTags objectAtIndex:j] addObject:[NSString stringWithFormat:@"</%@>\n",
+											  [self htmlEscapeString:[[xmlRow objectAtIndex:j] description]]]];
+	}
+	
+	if ( !silently ) {
+		
+		// Set the progress text
+		[singleProgressText setStringValue:NSLocalizedString(@"Writing...", @"text showing that app is writing text file")];
+		[singleProgressText displayIfNeeded];
+		
+		// Open progress sheet
+		[NSApp beginSheet:singleProgressSheet
+		   modalForWindow:tableWindow modalDelegate:self
+		   didEndSelector:nil contextInfo:nil];
+	}
+	
+	// Output the XML header if required
+	if ( header ) {
+		[xmlString setString:@"<?xml version=\"1.0\"?>\n\n"];
+		[xmlString appendString:@"<!--\n-\n"];
+		[xmlString appendString:@"- Sequel Pro dump\n"];
+		[xmlString appendString:[NSString stringWithFormat:@"- Version %@\n",
+								 [[NSBundle mainBundle] objectForInfoDictionaryKey:@"CFBundleVersion"]]];
+		[xmlString appendString:@"- http://code.google.com/p/sequel-pro\n-\n"];
+		[xmlString appendString:[NSString stringWithFormat:@"- Host: %@ (MySQL %@)\n",
+								 [tableDocumentInstance host], [tableDocumentInstance mySQLVersion]]];
+		[xmlString appendString:[NSString stringWithFormat:@"- Database: %@\n", [tableDocumentInstance database]]];
+		[xmlString appendString:[NSString stringWithFormat:@"- Generation Time: %@\n", [NSDate date]]];
+		[xmlString appendString:@"-\n-->\n\n"];
+		[fileHandle writeData:[xmlString dataUsingEncoding:tableEncoding]];
+	}
+	
+	// Write an opening tag in the form of the table name
+	[fileHandle writeData:[[NSString stringWithFormat:@"\t<%@>\n",
+							[self htmlEscapeString:table]]
+						   dataUsingEncoding:tableEncoding]];
+	
+	// Determine the total number of rows and starting row depending on supplied data format
+	if (array == nil) {
+		startingRow = 0;
+		totalRows = [queryResult numOfRows];
+	} else {
+		startingRow = 1;
+		totalRows = [array count];
+	}
+	
+	// Walk through the array, contructing the XML string.
+	for ( i = 1 ; i < totalRows ; i++ ) {
+		
+		// Update the progress bar
+		[singleProgressBar setDoubleValue:((i+1)*100/totalRows)];
+		if ((int)[singleProgressBar doubleValue] > lastProgressValue) {
+			lastProgressValue = (int)[singleProgressBar doubleValue];
+			[singleProgressBar displayIfNeeded];
+		}
+		
+		// Retrieve the row from the supplied data
+		if (array == nil) {
+			[xmlRow setArray:[queryResult fetchRowAsArray]];
+		} else {
+			[xmlRow setArray:[array objectAtIndex:i]];		
+		}
+		
+		// Construct the row
+		[xmlString setString:@"\t<row>\n"];
+		for ( j = 0 ; j < [xmlRow count] ; j++ ) {
+			
+			// Retrieve the contents of this tag
+			if ([[xmlRow objectAtIndex:j] isKindOfClass:[NSData class]]) {
+				dataConversionString = [[NSString alloc] initWithData:[xmlRow objectAtIndex:j] encoding:tableEncoding];
+				[xmlItem setString:[NSString stringWithString:dataConversionString]];
+				[dataConversionString release];
+			} else {
+				[xmlItem setString:[[xmlRow objectAtIndex:j] description]];
+			}
+			
+			// Add the opening and closing tag and the contents to the XML string
+			[xmlString appendString:[[xmlTags objectAtIndex:j] objectAtIndex:0]];
+			[xmlString appendString:[self htmlEscapeString:xmlItem]];
+			[xmlString appendString:[[xmlTags objectAtIndex:j] objectAtIndex:1]];
+		}
+		[xmlString appendString:@"\t</row>\n"];
+		
+		// Write the row to the filehandle
+		[fileHandle writeData:[xmlString dataUsingEncoding:tableEncoding]];
+	}
+	
+	// Write the closing tag for the table
+	[fileHandle writeData:[[NSString stringWithFormat:@"\t</%@>",
+							[self htmlEscapeString:table]]
+						   dataUsingEncoding:tableEncoding]];
+	
+	// Close the progress sheet if appropriate
+	if ( !silently ) {
+		[NSApp endSheet:singleProgressSheet];
+		[singleProgressSheet orderOut:nil];
+	}
+	
+	return TRUE;
+}
+
+/*
+ Processes the selected tables within the multiple table export accessory view and passes them
+ to be exported.
+ */
+- (BOOL)exportSelectedTablesToFileHandle:(NSFileHandle *)fileHandle usingFormat:(NSString *)type
+{
+	int i;
+	NSMutableArray *selectedTables = [NSMutableArray array];
+	
+	// Extract the table names of the selected tables
+	for ( i = 0 ; i < [tables count] ; i++ ) {
+		if ( [[[tables objectAtIndex:i] objectAtIndex:0] boolValue] ) {
+			[selectedTables addObject:[NSString stringWithString:[[tables objectAtIndex:i] objectAtIndex:1]]];
+		}
+	}
+	
+	return [self exportTables:selectedTables toFileHandle:fileHandle usingFormat:type];
+}
+
+/*
+ Walks through the selected tables and exports them to a file handle.  The export type must be
+ "csv" for CSV format, and "xml" for XML format.
+ */
+- (BOOL)exportTables:(NSArray *)selectedTables toFileHandle:(NSFileHandle *)fileHandle usingFormat:(NSString *)type
+{
+	int i;
+	CMMCPResult *queryResult;
+	NSString *tableName;
+	NSMutableString *infoString = [NSMutableString string];
+	NSMutableString *errors = [NSMutableString string];
+	NSStringEncoding connectionEncoding = [mySQLConnection encoding];
+	NSMutableString *csvLineEnd;
+	
+	// Reset the interface
+	[errorsView setString:@""];
+	[errorsView displayIfNeeded];
+	[singleProgressText setStringValue:NSLocalizedString(@"Writing...", @"text showing that app is writing text file")];
+	[singleProgressText displayIfNeeded];
+	[singleProgressBar setDoubleValue:0];
+	[singleProgressBar displayIfNeeded];
+	
+	// Open the progress sheet
+	[NSApp beginSheet:singleProgressSheet
+	   modalForWindow:tableWindow modalDelegate:self
+	   didEndSelector:nil contextInfo:nil];
+	
+	
+	// Add a dump header to the dump file, dependant on export type.
+	if ( [type isEqualToString:@"csv"] ) {
+		csvLineEnd = [NSMutableString stringWithString:[exportMultipleLinesTerminatedField stringValue]]; 
+		[csvLineEnd replaceOccurrencesOfString:@"\\t" withString:@"\t"
+									   options:NSLiteralSearch
+										 range:NSMakeRange(0, [csvLineEnd length])];
+		[csvLineEnd replaceOccurrencesOfString:@"\\n" withString:@"\n"
+									   options:NSLiteralSearch
+										 range:NSMakeRange(0, [csvLineEnd length])];
+		[csvLineEnd replaceOccurrencesOfString:@"\\r" withString:@"\r"
+									   options:NSLiteralSearch
+										 range:NSMakeRange(0, [csvLineEnd length])];
+		if ([selectedTables count] > 1) {
+			[infoString setString:[NSString stringWithFormat:@"Host: %@   Database: %@   Generation Time: %@%@%@",
+								   [tableDocumentInstance host], [tableDocumentInstance database], [NSDate date], csvLineEnd, csvLineEnd]];
+		}
+	} else if ( [type isEqualToString:@"xml"] ) {
+		[infoString setString:@"<?xml version=\"1.0\"?>\n\n"];
+		[infoString appendString:@"<!--\n-\n"];
+		[infoString appendString:@"- Sequel Pro dump\n"];
+		[infoString appendString:[NSString stringWithFormat:@"- Version %@\n",
+								  [[NSBundle mainBundle] objectForInfoDictionaryKey:@"CFBundleVersion"]]];
+		[infoString appendString:@"- http://code.google.com/p/sequel-pro\n-\n"];
+		[infoString appendString:[NSString stringWithFormat:@"- Host: %@ (MySQL %@)\n",
+								  [tableDocumentInstance host], [tableDocumentInstance mySQLVersion]]];
+		[infoString appendString:[NSString stringWithFormat:@"- Database: %@\n", [tableDocumentInstance database]]];
+		[infoString appendString:[NSString stringWithFormat:@"- Generation Time: %@\n", [NSDate date]]];
+		[infoString appendString:@"-\n-->\n\n\n"];
+		[infoString appendString:[NSString stringWithFormat:@"<%@>\n\n\n",
+								  [self htmlEscapeString:[tableDocumentInstance database]]]];
+	}
+	[fileHandle writeData:[infoString dataUsingEncoding:connectionEncoding]];
+	
+	// Loop through the selected tables
+	for ( i = 0 ; i < [selectedTables count] ; i++ ) {
+		
+		// Update the progress text and reset the progress bar to indeterminate status
+		tableName = [selectedTables objectAtIndex:i];
+		[singleProgressText setStringValue:[NSString stringWithFormat:NSLocalizedString(@"Table %i of %i (%@): fetching data...", @"text showing that app is fetching data for table dump"), (i+1), [selectedTables count], tableName]];
+		[singleProgressText displayIfNeeded];
+		[singleProgressBar setIndeterminate:YES];
+		[singleProgressBar setUsesThreadedAnimation:YES];
+		[singleProgressBar startAnimation:self];
+		
+		// For CSV exports of more than one table, output the name of the table
+		if ( [type isEqualToString:@"csv"] && [selectedTables count] > 1) {
+			[fileHandle writeData:[[NSString stringWithFormat:@"Table %@%@%@", tableName, csvLineEnd, csvLineEnd] dataUsingEncoding:connectionEncoding]];
+		}
+		
+		// Retrieve all the content within this table
+		queryResult = [mySQLConnection queryString:[NSString stringWithFormat:@"SELECT * FROM `%@`", tableName]];
+		
+		// Note any errors during retrieval
+		if ( ![[mySQLConnection getLastErrorMessage] isEqualToString:@""] ) {
+			[errors appendString:[NSString stringWithFormat:@"%@\n", [mySQLConnection getLastErrorMessage]]];
+		}
+		
+		// Update the progress text and set the progress bar back to determinate
+		[singleProgressText setStringValue:[NSString stringWithFormat:NSLocalizedString(@"Table %i of %i (%@): Writing...", @"text showing that app is writing data for table export"), (i+1), [selectedTables count], tableName]];
+		[singleProgressText displayIfNeeded];
+		[singleProgressBar stopAnimation:self];
+		[singleProgressBar setUsesThreadedAnimation:NO];
+		[singleProgressBar setIndeterminate:NO];
+		[singleProgressBar setDoubleValue:0];
+		[singleProgressBar displayIfNeeded];
+		
+		// Use the appropriate export method to write the data to file
+		if ( [type isEqualToString:@"csv"] ) {
+			[self writeCsvForArray:nil orQueryResult:queryResult
+					  toFileHandle:fileHandle
+				  outputFieldNames:[exportMultipleFieldNamesSwitch state]
+					  terminatedBy:[exportMultipleFieldsTerminatedField stringValue]
+						enclosedBy:[exportMultipleFieldsEnclosedField stringValue]
+						 escapedBy:[exportMultipleFieldsEscapedField stringValue]
+						  lineEnds:[exportMultipleLinesTerminatedField stringValue]
+						  silently:YES];
+			
+			// Add a spacer to the file
+			[fileHandle writeData:[[NSString stringWithFormat:@"%@%@%@", csvLineEnd, csvLineEnd, csvLineEnd] dataUsingEncoding:connectionEncoding]];
+		} else if ( [type isEqualToString:@"xml"] ) {
+			[self writeXmlForArray:nil orQueryResult:queryResult
+					  toFileHandle:fileHandle
+						 tableName:tableName
+						withHeader:NO
+						  silently:YES];
+			
+			// Add a spacer to the file
+			[fileHandle writeData:[[NSString stringWithString:@"\n\n\n"] dataUsingEncoding:connectionEncoding]];
+		}
+		
+	}
+	
+	// For XML output, close the database tag
+	if ( [type isEqualToString:@"xml"] ) {
+		[fileHandle writeData:[[NSString stringWithFormat:@"</%@>",
+								[self htmlEscapeString:[tableDocumentInstance database]]]
+							   dataUsingEncoding:connectionEncoding]];
+	}
+	
+	// Close the progress sheet
+	[NSApp endSheet:singleProgressSheet];
+	[singleProgressSheet orderOut:nil];
+	
+	// Show the errors sheet if there have been errors
+	if ( [errors length] ) {
+		[errorsView setString:errors];
+		[NSApp beginSheet:errorsSheet
+		   modalForWindow:tableWindow modalDelegate:self
+		   didEndSelector:nil contextInfo:nil];
+		[NSApp runModalForWindow:errorsSheet];
+		
+		[NSApp endSheet:errorsSheet];
+		[errorsSheet orderOut:nil];
+	}
+	
+	return TRUE;
+}
+
+- (NSString *)htmlEscapeString:(NSString *)string
+/*
+ html escapes a string
+ */
+{
+	NSMutableString *mutableString = [NSMutableString stringWithString:string];
+	
+	[mutableString replaceOccurrencesOfString:@"&" withString:@"&amp;"
+									  options:NSLiteralSearch
+										range:NSMakeRange(0, [mutableString length])];
+	[mutableString replaceOccurrencesOfString:@"<" withString:@"&lt;"
+									  options:NSLiteralSearch
+										range:NSMakeRange(0, [mutableString length])];
+	[mutableString replaceOccurrencesOfString:@">" withString:@"&gt;"
+									  options:NSLiteralSearch
+										range:NSMakeRange(0, [mutableString length])];
+	[mutableString replaceOccurrencesOfString:@"\"" withString:@"&quot;"
+									  options:NSLiteralSearch
+										range:NSMakeRange(0, [mutableString length])];
+	
+	return [NSString stringWithString:mutableString];
+}
+
+- (NSArray *)arrayForString:(NSString *)string enclosed:(NSString *)enclosed
+					escaped:(NSString *)escaped terminated:(NSString *)terminated
+/*
+ split a string by the terminated-character if this is not escaped
+ if enclosed-character is given, ignores characters inside enclosed-characters
+ */
+{
+	NSMutableArray *tempArray = [NSMutableArray array];
+	BOOL inString = NO;
+	BOOL isEscaped = NO;
+	BOOL br = NO;
+	unsigned i, j, start;
+	char enc = nil;
+	char esc = nil;
+	char ter = nil;
+	
+	//we take only first character by now (too complicated otherwise)
+	if ( [enclosed length] ) {
+		enc = [enclosed characterAtIndex:0];
+	}
+	if ( [escaped length] ) {
+		esc = [escaped characterAtIndex:0];
+	}
+	if ( [terminated length] ) {
+		ter = [terminated characterAtIndex:0];
+	}
+	
+	start = 0;
+	
+	for ( i = 0 ; i < [string length] ; i++ ) {
+		if ( inString ) {
+			//we are in a string
+			br = NO;
+			while ( !br ) {
+				if ( i >= [string length] ) {
+					//end of string -> no second enclose character found
+					br = YES;
+				} else if ( [string characterAtIndex:i] == enc ) {
+					//second enclose-character found
+					//enclose-character escaped?
+					isEscaped = NO;
+					j = 1;
+					while ( (i-j>0) && ([string characterAtIndex:(i-j)] == esc) ) {
+						isEscaped = !isEscaped;
+						j++;
+					}
+					if ( !isEscaped ) {
+						inString = NO;
+						br = YES;
+					}
+				}
+				if ( !br )
+					i++;
+			}
+		} else if ( [string characterAtIndex:i] == ter ) {
+			//terminated-character found
+			if ( [enclosed isEqualToString:@""] ) {
+				//check if terminated character is escaped
+				isEscaped = NO;
+				j = 1;
+				while ( (i-j>0) && ([string characterAtIndex:(i-j)] == esc) ) {
+					isEscaped = !isEscaped;
+					j++;
+				}
+				if ( !isEscaped ) {
+					[tempArray addObject:[string substringWithRange:NSMakeRange(start,(i-start))]];
+					start = i + 1;
+				}
+			} else {
+				//add object to array
+				//NSLog([string substringWithRange:NSMakeRange(start,(i-start))]);
+				[tempArray addObject:[string substringWithRange:NSMakeRange(start,(i-start))]];
+				start = i + 1;
+			}
+		} else if ( [string characterAtIndex:i] == enc ) {
+			//enclosed-character found
+			inString = YES;
+		}
+	}
+	
+	//add rest of string to array
+	[tempArray addObject:[string substringWithRange:NSMakeRange(start,([string length]-start))]];
+	
+	return [NSArray arrayWithArray:tempArray];
+}
+
+- (NSArray *)splitQueries:(NSString *)query
+/*
+ splits the queries by ;'s which aren't inside any ", ' or ` characters
+ */
+{
+	NSMutableString *queries = [NSMutableString stringWithString:query];
+	NSMutableArray *queryArray = [NSMutableArray array];
+	char stringType = nil;
+	BOOL inString = NO;
+	BOOL escaped;
+	unsigned lineStart = 0;
+	unsigned i, j, x, currentLineLength;
+	
+	//parse string
+	for ( i = 0 ; i < [queries length] ; i++ ) {
+		if ( inString ) {
+			//we are in a string
+			//look for end of string
+			for ( ; i < [queries length] ; i++ ) {
+				
+				// For the backtick character treat the string as ended
+				if ( ([queries characterAtIndex:i] == '`') && (stringType == '`') ) {
+					
+					inString = NO;
+					break;
+					
+					// Otherwise, prepare to treat the string as ended after a stringType....
+				} else if ( [queries characterAtIndex:i] == stringType ) {
+					
+					// ...but only if the stringType isn't escaped with an *odd* number of escaping characters.
+					escaped = NO;
+					j = 1;
+					currentLineLength = i - lineStart;
+					while ( ((currentLineLength-j) > 0) && ([queries characterAtIndex:i-j] == '\\') ) {
+						escaped = !escaped;
+						j++;
+					}
+					
+					// If an odd number have been found, it really is the end of the string.
+					if ( !escaped ) {
+						inString = NO;
+						break;
+					}
+				}
+			}
+		} else if ( ([queries characterAtIndex:i] == '#') || 
+				   ((i+2<[queries length]) &&
+					([queries characterAtIndex:i] == '-') &&
+					([queries characterAtIndex:i+1] == '-') &&
+					([queries characterAtIndex:i+2] == ' ')) ) {
+			//it's a comment -> delete it
+			x = i;
+			while ( (x<[queries length]) && ([queries characterAtIndex:x] != '\r') && ([queries characterAtIndex:x] != '\n') ) {
+				x++;
+			}
+			[queries deleteCharactersInRange:NSMakeRange(i,x-i)];
+		} else if ( [queries characterAtIndex:i] == ';' ) {
+			//we are at the end of a query
+			[queryArray addObject:[queries substringWithRange:NSMakeRange(lineStart, (i-lineStart))]];
+			while ( ((i+1)<[queries length]) && (([queries characterAtIndex:i+1]=='\n') || ([queries characterAtIndex:i+1]=='\r') || ([queries characterAtIndex:i+1]==' ')) ) {
+				i++;
+			}
+			lineStart = i + 1;
+		} else if ( ([queries characterAtIndex:i] == '\'') ||
+				   ([queries characterAtIndex:i] == '"') ||
+				   ([queries characterAtIndex:i] == '`') ) {
+			//we are entering a string
+			inString = YES;
+			stringType = [queries characterAtIndex:i];
+		}
+	}
+	
+	//add rest of string to array (if last line has not ended with a ";")
+	if ( lineStart < [queries length] ) {
+		[queryArray addObject:[queries substringWithRange:NSMakeRange(lineStart, ([queries length]-lineStart))]];
+	}
+	
+	//return array
+	return [NSArray arrayWithArray:queryArray];
+}
+
+
+//additional methods
+- (void)setConnection:(CMMCPConnection *)theConnection
+/*
+ sets the connection (received from TableDocument) and makes things that have to be done only once 
+ */
+{
+	NSButtonCell *switchButton = [[NSButtonCell alloc] init];
+	
+	prefs = [[NSUserDefaults standardUserDefaults] retain];
+	
+	mySQLConnection = theConnection;
+	
+	//set up the interface
+	[switchButton setButtonType:NSSwitchButton];
+	[switchButton setControlSize:NSSmallControlSize];
+	[[exportDumpTableView tableColumnWithIdentifier:@"switch"] setDataCell:switchButton];
+	[[exportMultipleCSVTableView tableColumnWithIdentifier:@"switch"] setDataCell:switchButton];
+	[[exportMultipleXMLTableView tableColumnWithIdentifier:@"switch"] setDataCell:switchButton];
+	if ( [prefs boolForKey:@"useMonospacedFonts"] ) {
+		[[[exportDumpTableView tableColumnWithIdentifier:@"tables"] dataCell]
+		 setFont:[NSFont fontWithName:@"Monaco" size:[NSFont smallSystemFontSize]]];
+		[[[exportMultipleCSVTableView tableColumnWithIdentifier:@"tables"] dataCell]
+		 setFont:[NSFont fontWithName:@"Monaco" size:[NSFont smallSystemFontSize]]];
+		[[[exportMultipleXMLTableView tableColumnWithIdentifier:@"tables"] dataCell]
+		 setFont:[NSFont fontWithName:@"Monaco" size:[NSFont smallSystemFontSize]]];
+		[[[fieldMappingTableView tableColumnWithIdentifier:@"0"] dataCell]
+		 setFont:[NSFont fontWithName:@"Monaco" size:[NSFont smallSystemFontSize]]];
+		[errorsView setFont:[NSFont fontWithName:@"Monaco" size:[NSFont smallSystemFontSize]]];
+	} else {
+		[[[exportDumpTableView tableColumnWithIdentifier:@"tables"] dataCell]
+		 setFont:[NSFont systemFontOfSize:[NSFont smallSystemFontSize]]];
+		[[[exportMultipleCSVTableView tableColumnWithIdentifier:@"tables"] dataCell]
+		 setFont:[NSFont systemFontOfSize:[NSFont smallSystemFontSize]]];
+		[[[exportMultipleXMLTableView tableColumnWithIdentifier:@"tables"] dataCell]
+		 setFont:[NSFont systemFontOfSize:[NSFont smallSystemFontSize]]];
+		[[[fieldMappingTableView tableColumnWithIdentifier:@"0"] dataCell]
+		 setFont:[NSFont systemFontOfSize:[NSFont smallSystemFontSize]]];
+		[errorsView setFont:[NSFont systemFontOfSize:[NSFont smallSystemFontSize]]];
+	}
+	//	[self reloadTables:self];
+}
+
+#pragma mark -
+#pragma mark tableView datasource methods
+
+- (int)numberOfRowsInTableView:(NSTableView *)aTableView;
+{
+	if ( aTableView == fieldMappingTableView ) {
+		return [[tableSourceInstance fieldNames] count];
+	} else {
+		return [tables count];
+	}
+}
+
+- (void)tableView:(NSTableView *)aTableView 
+  willDisplayCell:(id)aCell 
+   forTableColumn:(NSTableColumn *)aTableColumn 
+			  row:(int)rowIndex
+{
+	if ( [[NSUserDefaults standardUserDefaults] boolForKey:@"useMonospacedFonts"] ) {
+		[aCell setFont:[NSFont fontWithName:@"Monaco" size:[NSFont smallSystemFontSize]]];
+	}
+	else
+	{
+		[aCell setFont:[NSFont systemFontOfSize:[NSFont smallSystemFontSize]]];
+	}
+}
+
+- (id)tableView:(NSTableView *)aTableView
+objectValueForTableColumn:(NSTableColumn *)aTableColumn
+			row:(int)rowIndex
+{
+	if ( aTableView == fieldMappingTableView ) {
+		if ([[aTableColumn identifier] isEqualToString:@"field"]) {
+			return [[tableSourceInstance fieldNames] objectAtIndex:rowIndex];
+			
+		} else if ([[aTableColumn identifier] isEqualToString:@"value"]) {
+			if ([[[aTableColumn dataCell] class] isEqualTo:[NSPopUpButtonCell class]]) {
+				[(NSPopUpButtonCell *)[aTableColumn dataCell] removeAllItems];
+				[(NSPopUpButtonCell *)[aTableColumn dataCell] addItemWithTitle:NSLocalizedString(@"Do not import", @"text for csv import drop downs")];
+				[(NSPopUpButtonCell *)[aTableColumn dataCell] addItemsWithTitles:fieldMappingButtonOptions];
+			}
+			
+			return [fieldMappingArray objectAtIndex:rowIndex];
+		} 
+	} else {
+		if ( [[aTableColumn identifier] isEqualToString:@"switch"] ) {
+			return [[tables objectAtIndex:rowIndex] objectAtIndex:0];
+		} else {
+			return [[tables objectAtIndex:rowIndex] objectAtIndex:1];
+		}
+	}
+}
+
+- (void)tableView:(NSTableView *)aTableView
+   setObjectValue:(id)anObject
+   forTableColumn:(NSTableColumn *)aTableColumn
+			  row:(int)rowIndex
+{
+	if ( aTableView == fieldMappingTableView ) {		
+		[fieldMappingArray replaceObjectAtIndex:rowIndex withObject:anObject];
+		
+	} else {
+		[[tables objectAtIndex:rowIndex] replaceObjectAtIndex:0 withObject:anObject];
+	}
+}
+
+#pragma mark -
+#pragma mark other
+//last but not least
+- (id)init;
+{
+	self = [super init];
+	
+	tables = [[NSMutableArray alloc] init];
+	fieldMappingButtonOptions = [[NSMutableArray alloc] init];
+	
+	return self;
+}
+
+- (void)dealloc
+{
+	//	NSLog(@"TableDump dealloc");
+	
+	[tables release];
+	[importArray release];
+	[fieldMappingButtonOptions release];
+	[fieldMappingArray release];
+	[savePath release];
+	[openPath release];
+	[prefs release];   
+	
+	[super dealloc];
+}
+
+
+@end