App::csv2sqlite - Import CSV files into a SQLite database
csv2sqlite doggies.csv kitties.csv pets.sqlite # configure CSV parsing as necessary: csv2sqlite -o sep_char=$'\t' plants.tab plants.sqlite
Import CSV files into a SQLite database (using DBIx::TableLoader::CSV).
Each csv file specified on the command line will became a table in the resulting sqlite database.
- --csv-file (or --csv)
The csv files to load
- --csv-opt (or -o)
A hash of key=value options to pass to Text::CSV
- --dbname (or --database)
The file path for the SQLite database
- --encoding (or -e)
The encoding of the csv files (a shortcut for
--loader-opt file_encoding=$enc); (Strings will be stored in the database in UTF-8.)
- --loader-opt (or -l)
A hash of key=value options to pass to DBIx::TableLoader::CSV
- specific DBIx::TableLoader options?
- confirm using a pre-existing database?
- more tests
- allow specifying table names for csv files
You can find documentation for this module with the perldoc command.
The following websites have more information about this module, and may be of help to you. As always, in addition to those websites please use your favorite search engine to discover more resources.
- Search CPAN
The default CPAN search engine, useful to view POD in HTML format.
- RT: CPAN's Bug Tracker
The RT ( Request Tracker ) website is the default bug/issue tracking system for CPAN.
- CPAN Ratings
The CPAN Ratings is a website that allows community ratings and reviews of Perl modules.
- CPAN Testers
The CPAN Testers is a network of smokers who run automated tests on uploaded CPAN distributions.
- CPAN Testers Matrix
The CPAN Testers Matrix is a website that provides a visual overview of the test results for a distribution on various Perls/platforms.
- CPAN Testers Dependencies
The CPAN Testers Dependencies is a website that shows a chart of the test results of all dependencies for a distribution.
Please report any bugs or feature requests by email to
bug-app-csv2sqlite at rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=App-csv2sqlite. You will be automatically notified of any progress on the request by the system.
git clone https://github.com/rwstauner/App-csv2sqlite.git
Randy Stauner <firstname.lastname@example.org>
This software is copyright (c) 2012 by Randy Stauner.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.