#csva

Chupeta

Odbc to Csv/txt/html extractor

Install (Ubuntu)

You will need:

• wxpython
• pyodbc
• pyaml

File association

Put the applicaton path in the ~/.profile

Edit the file chupeta.desktop changing the "Exec=" line to inclute the path where the application is installed

Associate the mime file to the application

sudo cp chupeta.desktop /usr/share/applications/

sudo cp cyx_mime.xml /usr/share/mime/packages/

sudo update-mime-database /usr/share/mime

(See https://coderwall.com/p/qjda2q/create-new-mime-type-and-assign-an-icon-to-it-in-ubuntu and https://askubuntu.com/questions/525953/use-custom-command-to-open-files )

Install the Odbc driver

Sqlite:

sudo apt-get install libsqliteodbc

Postgresql:

sudo apt-get install odbc-postgresql

Mysql:

• Download from: https://dev.mysql.com/downloads/connector/odbc/
• Follow the instructions in: https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-binary-unix-tarball.html

Configure the Driver

Edit the file /etc/odbc.ini

[DevDb]
Description	= Postgresql connecton to Development database
Driver		= PostgreSQL Unicode
Database	= devdb
Servername	= 192.168.0.300
Username	= postgres
Password	= blablublapombo
Port		= 5432

See the files in testdb/ for a complete example of configuration to Sqlite databases