Export SQLite to CSV

Export.m

    FMDatabase *db = [FMDatabase databaseWithPath:[Utility getDatabasePath]];
    [db open];
    FMResultSet *results = [db executeQuery:@"SELECT * FROM tblScores"];
    //CHCSVWriter *csvWriter = [[CHCSVWriter alloc] initForWritingToCSVFile:[NSHomeDirectory() stringByAppendingPathComponent:@"demo.csv"]];
    NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *documentsDirectory = [paths objectAtIndex:0]; // Get documents folder
    NSString *document = [[NSString alloc] initWithFormat:@"%@/demo.csv", documentsDirectory];
    CHCSVWriter *csvWriter = [[CHCSVWriter alloc] initForWritingToCSVFile:document];
    
    while([results next]) {
        //NSDictionary *resultRow = [results resultDict];
        NSDictionary *resultRow = [results resultDictionary];
        NSArray *orderedKeys = [[resultRow allKeys] sortedArrayUsingSelector:@selector(compare:)];
        //iterate over the dictionary
        for (NSString *columnName in orderedKeys) {
            id value = [resultRow objectForKey:columnName];
            [csvWriter writeField:value];
        }
        //[csvWriter writeLine];
        [csvWriter finishLine];
    }
    //[csvWriter closeFile];
    [csvWriter closeStream];

https://github.com/davedelong/CHCSVParser

http://stackoverflow.com/questions/4656887/how-to-export-sqlite-file-into-csv-file-in-iphone-sdk