EasyCSV2SQLite
By Say Goodnight Software
Open the Mac App Store to buy and download apps.
Description
*** NOW OPEN SOURCED AT GITHUB! ***
https://github.com/pj4533/EasyCSV2SQLite
EasyCSV2SQLite makes it easy to convert comma delimited text files to sqlite databases. The primary use would be to include datasets inside development projects. To further enable this, EasyCSV2SQLite will generate objective-c code necessary to read the created SQLite database.
EasyCSV2SQLite is a very simple application, but does its job well!
- each column is a VARCHAR(255)
- line endings for the CSV file can be LF/CR/CRLF
- first line used as column headers
- objective-c code generated for reading database
- uses NSScanner rather than componentsSeparatedByString so it properly parses commas in quotation marks
The code generation was initially based on code from a blog post at dBlog.com.au. Thanks to them for showing how easy it is to read SQLite from objective-c!
Screenshots
Customer Reviews
Doesn't convert ...
Couldn't get it to create a sqlite db - just made a zero kb file with a sqlite extension. 10.7
didnt work
Useless for me. Uploaded a cvs file and i got a 0 bytes file.
Developer should fix it or explain how the application works.
Could not get it to work.
Could not get it to work. Needs better instructions and field labeling.
- Free
- Category: Developer Tools
- Released: Aug 03, 2011
- Version: 1.0
- Size: 0.2 MB
- Language: English
- Seller: Paul Gray
- © 2011 Paul James Gray
Requirements: OS X 10.6 or later, 64-bit processor
