LOAD DATA INTO CORE DATA??

[Howell]

Does anyone know how load data into Core Data easily? Preferably from a file that can be edited easily like a .CSV file or whatever else. Or should I be going about this another way?

Thanks!

[mgwinthrop]

Originally Posted by Howell

Does anyone know how load data into Core Data easily? Preferably from a file that can be edited easily like a .CSV file or whatever else. Or should I be going about this another way?

Thanks!

Here is what I have done for my app.

1) Create the model in XCode (it is essential do this first, because XCode uses a specific naming convention and adds several underlying tables to the actual data model.

2) Run the application in the Simulator and with the app running ... go and copy the database (/users/library/Application Support/iPhone Simulator/User/Applications/<app name> to some other location

3) Open up the database (I use SQLite Manager plugin in Firefox)

4) From here I import my data from a CSV file once I have updated all of my CSV column names to match the table names

5) Look at the CoreDataRecipies sample code for including a pre-populated database (code is in the Delegate.m file)

6) Import the database in your application and you should be good to go.

[asUwish]

Hi,

This is something I'd like to do and your instructions seem clear but i can't find the delegate.m in corerecipies. can you post the links or code?

Thanks!

asUwish

Originally Posted by mgwinthrop

Here is what I have done for my app.

1) Create the model in XCode (it is essential do this first, because XCode uses a specific naming convention and adds several underlying tables to the actual data model.

2) Run the application in the Simulator and with the app running ... go and copy the database (/users/library/Application Support/iPhone Simulator/User/Applications/<app name> to some other location

3) Open up the database (I use SQLite Manager plugin in Firefox)

4) From here I import my data from a CSV file once I have updated all of my CSV column names to match the table names

5) Look at the CoreDataRecipies sample code for including a pre-populated database (code is in the Delegate.m file)

6) Import the database in your application and you should be good to go.

[jazztpt]

Looks like that code is in RecipesAppDelegate.m here:

/**
 Returns the persistent store coordinator for the application.
 If the coordinator doesn't already exist, it is created and the application's store added to it.
 */
- (NSPersistentStoreCoordinator *)persistentStoreCoordinator {
	
    if (persistentStoreCoordinator != nil) {
        return persistentStoreCoordinator;
    }
		
	NSString *storePath = [[self applicationDocumentsDirectory] stringByAppendingPathComponent:@"Recipes.sqlite"];
	/*
	 Set up the store.
	 For the sake of illustration, provide a pre-populated default store.
	 */
	NSFileManager *fileManager = [NSFileManager defaultManager];
	// If the expected store doesn't exist, copy the default store.
	if (![fileManager fileExistsAtPath:storePath]) {
		NSString *defaultStorePath = [[NSBundle mainBundle] pathForResource:@"Recipes" ofType:@"sqlite"];
		if (defaultStorePath) {
			[fileManager copyItemAtPath:defaultStorePath toPath:storePath error:NULL];
		}
	}
	
	NSURL *storeUrl = [NSURL fileURLWithPath:storePath];
	
	NSError *error;
    persistentStoreCoordinator = [[NSPersistentStoreCoordinator alloc] initWithManagedObjectModel: [self managedObjectModel]];
    if (![persistentStoreCoordinator addPersistentStoreWithType:NSSQLiteStoreType configuration:nil URL:storeUrl options:nil error:&error]) {
		// Handle error
		NSLog(@"Unresolved error %@, %@", error, [error userInfo]);
		exit(-1);  // Fail
    }    
		
    return persistentStoreCoordinator;
}