NAME

App::csv2sqlite - Import CSV files into a SQLite database

VERSION

version 0.004

SYNOPSIS

csv2sqlite doggies.csv kitties.csv pets.sqlite

# configure CSV parsing as necessary:
csv2sqlite -o sep_char=$'\t' plants.tab plants.sqlite

DESCRIPTION

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.

OPTIONS

--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

TODO

• specific DBIx::TableLoader options?

• confirm using a pre-existing database?

• more tests

• allow specifying table names for csv files

SUPPORT

Perldoc

You can find documentation for this module with the perldoc command.

perldoc App::csv2sqlite

Websites

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.

  http://search.cpan.org/dist/App-csv2sqlite

• RT: CPAN's Bug Tracker

  The RT ( Request Tracker ) website is the default bug/issue tracking system for CPAN.

  http://rt.cpan.org/NoAuth/Bugs.html?Dist=App-csv2sqlite

• CPAN Ratings

  The CPAN Ratings is a website that allows community ratings and reviews of Perl modules.

  http://cpanratings.perl.org/d/App-csv2sqlite

• CPAN Testers

  The CPAN Testers is a network of smokers who run automated tests on uploaded CPAN distributions.

  http://www.cpantesters.org/distro/A/App-csv2sqlite

• 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.

  http://matrix.cpantesters.org/?dist=App-csv2sqlite

• CPAN Testers Dependencies

  The CPAN Testers Dependencies is a website that shows a chart of the test results of all dependencies for a distribution.

  http://deps.cpantesters.org/?module=App::csv2sqlite

Bugs / Feature Requests

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.

Source Code

https://github.com/rwstauner/App-csv2sqlite

git clone https://github.com/rwstauner/App-csv2sqlite.git

AUTHOR

Randy Stauner <rwstauner@cpan.org>

COPYRIGHT AND LICENSE

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.