Repository files navigation

Python script for importing data from .csv, .xls, or .xlsx to MySql database. It requires the headers to run an insertquery to database using the headers as the fields.

Requirements

• python 2+
• virtualenv
• mysql-connector-python
• xlrd

Setup

$ virtualenv <envname> -p python3$ source <envname>/bin/activate$ pip install -r requirements.txt

Running script

$ python import.py -h$ python import.py -t spreadsheet -f data/users.xlsx -s source -H hostname.com -U username -P pwd -D db_name$ python import.py -t csv -f data/users.csv -H hostname.com -U username -P pwd -D db_name

-t (type)

spreadsheet, csv

-f (file)

Path to dataset file

-s (sheet name)

Used if the dataset type in use is a spreadsheet

-H (host name)

Database host name

-U (username)

Database username

-P (password)

Database password

-D (database name)

Database name