CSV-Reader-Tool

A CSV Reader Tool written in Python 3

To install the CSV Reader Tool please follow the instruction as follow.

Step - 1

Connect to SSH on your server and install the dependencies required to the script to work:

Check if you have Python 3 first using this command

python3 --version

If you have Python 3 type this command to install them on a Ubuntu server

sudo apt-get install python-pip
sudo pip install numpy
sudo pip install pandas

Step - 2

Make sure your vhost file can run CGI scripts by making your virtual host file look like the following lines:

ScriptAlias /cgi-bin/ /var/www/website/public_html/cgi-bin/
<Directory "/var/www/website/public_html/cgi-bin/">
    AllowOverride All
    Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
    Require all granted
    AddHandler cgi-script .cgi .py
</Directory>

<Directory /var/www/website/>
    Options +ExecCGI
    AllowOverride All
    Require all granted
</Directory>

Step - 3

Upload your files to the document root directory (public_html)

Step - 4

Make sure the cgi-bin folder have the correct permissions. The permission should be 0755.

Step - 5

Make sure the correct permission are set on the upload folder (0775). The writing permission is needed to allow Apache to write to the directory.

Step - 6

Test the script to make sure it works on your server and to ensure you have installed everything correctly.