Python script for importing data from .csv, .xls, or .xlsx to MySql database.
Requirements
Setup
$ virtualenv <envname> -p python3
$ source <envname>/bin/activate
$ pip install -r requirements.txt
Running script
$ python import.py -t spreadsheet -d data/users.xlsx -s source
-t (type)
spreadsheet, csv
-d (dataset)
Path to dataset
-s (sheet name)
Used if the dataset type in use is a spreadsheet