Using existing Sqlite DB with Core Data

[Bialetti]

I'm trying to implement a Core Data project which will have a database of locations.

I have the data in a csv file and also as a sqlite db. I would like to include the sqlite db with core data but this is not possible due to Core Data's treatment of sqlite (It includes two extra tables prefixed by Z_ amongst other things).

Has anyone got a working example of how to create a Core Data Sqlite DB that I can copy my existing information into or do they know how to convert a CSV file into a Core Data DB. The answers I found online don't include any detail they just give generic instructions such as "parse it into core data from csv without code examples or instruction".

Any help would be appreciated. As a newcomer I'm surprised that such an incompatability exists in the Core Data architecture.

[churn]

You must write a separate small conversion program (command line) to read your data from CSV or your existing sqlite db, create Core Data objects, and then save.

[thewitt]

Remember that CoreData can use any data store - and just so happens to use SQLite on the iPhone.

You can continue to use your SQLite database directly on the iPhone if you want - there is no requirement to convert to CoreData.

I don't know of any conversion utilities or examples, sorry.

-t

[Bialetti]

Thanks thewitt.

Does anyone have any suggestions for importing their data in to CoreData?

In every language I've ever done this is exceptionally easy - strange how Apple's own examples don't provide a way of importing the information into a Core Data store.

Has anybody on the forum any experience of doing this or does everyone use native sqlite or fmdb?

Originally Posted by thewitt

Remember that CoreData can use any data store - and just so happens to use SQLite on the iPhone.

You can continue to use your SQLite database directly on the iPhone if you want - there is no requirement to convert to CoreData.

I don't know of any conversion utilities or examples, sorry.

-t

[preethaAjayan]

THis may be helpful.

Core Data Tutorial: How To Preload/Import Existing Data | Ray Wenderlich