Loading a CSV into Core Data managed sqlite db
core-data, csv, iphone, sqlite
Solution
Use `NSScanner` to read your CSV file into the `NSManagedObject` instances in your Core Data store.
Problem
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.