Loading a CSV into Core Data managed sqlite db

Question

I have a CSV file containing data. I want to load it into a Core Data managed sqlite db.

I just ran one of the sample Core Data Xcode apps and noticed it created the db file. I noticed table names all started with Z and the primary keys were stored in separate table so from this am I right in presuming that just importing the CSV data directly into the db using sqlite3 command line might mess up primary keys.

Do I need to write a program to read in the CSV line by line and then create objects for each row and persist them to the db. Anyone got any code for this? And can I write a desktop client to do this using Core Data. If so will the db be fine to use in IPhone core data app?

Can I then just include the prefilled db in my project and it will be deployed with the app correctly or is there something else I should do.

Answer 1

Use NSScanner to read your CSV file into the NSManagedObject instances in your Core Data store.

Answer 2

I have some categories on NSString for reading and writing CSV files from/to NSArrays. I'll post them online and edit my answer with a link to it.

Answer 3

Hi I wanna read CSV file that is on my domain. I want to convert show that csf file data into a UITable View. I am a beginner.please give code example.