how to export Core Data to CSV

Question

I will like to use CHCSVParser to export my Core data to CSV. I know how to get all the value from entity, but I don't know how to write to CSV.

Can anybody teach me how to write to CSV with CHCSVParser?

// Test listing all Infos from the store
NSFetchRequest *fetchRequest = [[NSFetchRequest alloc] init];
NSEntityDescription *entity = [NSEntityDescription 
                               entityForName:@"NoteLog" inManagedObjectContext:context];
[fetchRequest setEntity:entity];

NSArray *fetchedObjects = [context executeFetchRequest:fetchRequest error:&error];
for (NoteLog *noteInfo in fetchedObjects) {

    NSLog(@"Name: %@", noteInfo.city );
    NSLog(@"Name: %@", noteInfo.country);
    NSLog(@"Name: %@", noteInfo.datetime);
    NSLog(@"Name: %@", noteInfo.notelatitude);
    NSLog(@"Name: %@", noteInfo.notelongtitude);
    NSLog(@"Name: %@", noteInfo.state);
    NSLog(@"Name: %@", noteInfo.text);        
}

Ryan Poolos · Accepted Answer · 2012-05-13 15:23:57Z

8

A CHCSVWriter has several methods for constructing CSV files:

-writeField: accepts an object and writes its -description (after being properly escaped) out to the CSV file. It will also write field seperator (,) if necessary. You may pass an empty string (@"") or nil to write an empty field.

-writeFields: accepts a comma-delimited and nil-terminated list of objects and sends each one to -writeField:.

-writeLine is used to terminate the current CSV line. If you do not invoke -writeLine, then all of your CSV fields will be on a single line.

-writeLineOfFields: accepts a comma-delimited and nil-terminated list of objects, sends each one to -writeField:, and then invokes -writeLine.

-writeLineWithFields: accepts an array of objects, sends each one to -writeField:, and then invokes -writeLine.

-writeCommentLine: accepts a string and writes it out to the file as a CSV-style comment.

In addition to writing to a file, CHCSVWriter can be initialized for writing directly to an NSString.

Something Like this should work for you.

CHCSVWriter *writer = [[CHCSVWriter alloc] initForWritingToString];

for (NoteLog *noteInfo in fetchedObjects) {

    [writer writeLineOfFields:noteInfo.city, noteInfo.country, noteInfo.datetime, noteInfo.notelatitude, noteInfo.notelongtitude, noteInfo.state, noteInfo.text, nil];     
}  

NSLog(@"My CSV File: %@",writer.stringValue);

edited May 13, 2012 at 15:23

answered May 13, 2012 at 13:59

Ryan Poolos

18.6k5 gold badges67 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Desmond Over a year ago

hi Rayan, Will you beable to give me an example ? all i need is the to export all the data out and thats it

Ryan Poolos Over a year ago

Added some code for your particular case. If you paste that in you should get a nice CSV output in your console. From there I trust you know how to put it in a file and do whatever you want with it.

Ryan Poolos Over a year ago

Glad to hear :) Happy coding.

user1489709 Over a year ago

hi i was trying your code but seems that "initForWritingToString" has been replaced in CHCSVParser. can u help me out. I have the same issue

Ryan Poolos Over a year ago

It no longer writes to a string. Now it only writes directly to a path. initForWritingToCSVFile:(NSString *)path So just give it a path where you'd like your CSV file saved. You could store it somewhere temporary and read it to a string using stringWithContentsOfFile: if you really need it in a string.

Mic Fok · Accepted Answer · 2014-01-26 22:15:10Z

8

The answer above seems to be deprecated, the author replaced the method with another it seem. This worked for me, hope it helps:

NSOutputStream *stream = [[NSOutputStream alloc] initToMemory];
CHCSVWriter *writer = [[CHCSVWriter alloc] initWithOutputStream:stream encoding:NSUTF8StringEncoding delimiter:','];

for (Type *instance in fetchedResults) {
    [writer writeLineOfFields:@[instance.propertyA, instance.B]];
}
[writer closeStream];

NSData *buffer = [stream propertyForKey:NSStreamDataWrittenToMemoryStreamKey];
NSString *output = [[NSString alloc] initWithData:buffer encoding:NSUTF8StringEncoding];

answered Jan 26, 2014 at 22:15

Mic Fok

83711 silver badges12 bronze badges

3 Comments

Luke Irvin Over a year ago

what is fetchedResults?

alexey.m Over a year ago

@LukeIrvin, an array of database entities. See the original post - NSArray *fetchedObjects = [context executeFetchRequest:fetchRequest error:&error];

Steven Over a year ago

Any idea how to use writeLineOfFields with swift?

Collectives™ on Stack Overflow

how to export Core Data to CSV

2 Answers 2

5 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related