/pdf-to-csv

Convert pdf to csv

Primary LanguageJavaScriptApache License 2.0Apache-2.0

pdf-to-csv

Setup

Using Python 3.6+

Environment Setup

  • Linux Systems:

    sudo pip3 install virtualenv

virtualenv -p python3 venv --no-site-packages

source venv/bin/activate

pip3 install -r requirements.txt
    deactivate

  • Windows Systems:

    pip3 install virtualenv

virtualenv -p python3 venv --no-site-packages

venv\Scripts\activate

pip3 install -r requirements.txt
    venv\Scripts\deactivate

    If getting issue in installing virtualenv on windows, use administrator privileges

SQL Setup

Run dump.sql to setup sql

Running

  1. Activate your venv
  2. Go to ./app and run app.py
  3. Open http://127.0.0.1:5000/ in browser.

To change any default variables go to ./app/params.py and change any of the following

# parameters used throughout the program

# SQL connection
host = "localhost"
username = "root"
password = ""
db_name = "bsdb"
# table name in SQL
table_name = "BalanceSheet"

# file location for upload and download temps
local_pdf = r'in.pdf'
local_csv = r'out.csv'

CREDITS

Kuldeep Singh Sidhu

Github: github/singhsidhukuldeep https://github.com/singhsidhukuldeep

Website: Kuldeep Singh Sidhu (Website) http://kuldeepsinghsidhu.com

LinkedIn: Kuldeep Singh Sidhu (LinkedIn) https://www.linkedin.com/in/singhsidhukuldeep/