Home

Java DB CSV Import

Features

• Optional import from CSV, JSON or XML format
• GUI and console mode
• Importmodes: Clear beafore insert, Insert new entries, Update existing entries, Update and Insert
• Use any import encoding
• Use your own csv separator
• Use your own csv string quote
• An indentation for JSON and XML accepted
• Option to read files for Blobs and Clobs instead of inline BASE64 code
• Optional zipped input
• Optional create new table
• Automatic update of application on user request
• GUI internationalisation(i18n) for english and german
• Password secured preferences in GUI mode

Description

Java tool to import db data from csv, json or xml files.
Oracle DB, MySQL DB, PostgreSQL DB, Firebird DB, SQLite DB, Derby DB and HSQL DB are supported.
Includes and uses JavaUtilities library (see wiki, https://sourceforge.net/projects/java-utilities-no-dependencies/).
This tool does NOT include the needed db drivers, but they only have to be downloaded and configured once.

See also DbCsvExport project: https://sourceforge.net/projects/dbcsvexport/
The DbCsvImport Project is also available at GitHub: https://github.com/hudeany/dbcsvimport

The needed db drivers are not included in the jar-file or the project.
Those can be downloaded at following locations:
MySQL (mysql-connector-java-5.1.xx-bin.jar): https://dev.mysql.com/downloads/connector/j/
Oracle (ojdbc6.jar): http://www.oracle.com/technetwork/apps-tech/jdbc-112010-090769.html
(Oracle download needs registration)
PostgreSQL: https://jdbc.postgresql.org/download.html
Firebird: http://www.firebirdsql.org/en/jdbc-driver (make sure to use the "...full...".jar, because of this drivers J2EE dependencies)
Apache Derby: https://db.apache.org/derby/derby_downloads.html
SQLite: https://bitbucket.org/xerial/sqlite-jdbc/downloads
* HSQL: http://hsqldb.org/download

When using the DbCsvImport.jar for the first import, the console version asks for the driver location and stores it in %HOME%/.DbCsvImport.config file for later uses.
In GUI mode the file %HOME%/.DbCsvImport.config is also created, but contains no data. The driver location can be selected in GUI.

Optional parameter log files for the imported data file are available, which include information about the import parameters like separator or statistics.

If DB is only available via SSH-tunnel any local port may be used for db connection.

Import progress is shown in GUI and console mode (use parameter -v for verbose output).

The import encoding may be adjusted and also the language format for numeric and date values.

DB user password may be entered in console mode as a parameter or is asked interactively in console, so it doesn't appear in bash history.

Console parameter -update checks the local version with latest available version on github.com and asks for download and installation. Same does the "Check Update" button in GUI.

GUI mode can store a bunch of preferences sets for repeated imports in a convenient way.

Help Page