Help

CSV Reader Tool: Step-by-Step Installation Guide

Follow these instructions to install the CSV Reader Tool on your server.

Step 1: Install Server Dependencies

Connect to your server via SSH and verify that Python 3 is installed:

Bash

python3 --version

If Python 3 is present, run the following commands to install the required dependencies (Ubuntu/Debian environment):

Bash

sudo apt-get update
sudo apt-get install python3-pip -y
sudo pip3 install numpy pandas

Step 2: Configure Virtual Host (CGI Support)

Ensure your Apache virtual host file is configured to execute CGI scripts. Update your site's VHost configuration file to include the following directives:

Apache

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/public_html/">
    Options +ExecCGI
    AllowOverride All
    Require all granted
</Directory>

Note: Remember to restart Apache after modifying your virtual host configuration:

Bash

sudo systemctl restart apache2

Step 3: Upload Application Files

Upload all application files to your Web Server Document Root directory (e.g., public_html/).

Step 4: Configure cgi-bin Permissions

Set the correct permissions on the cgi-bin directory so Apache can execute the scripts:

Bash

chmod -R 0755 /var/www/website/public_html/cgi-bin/

Step 5: Configure upload Directory Permissions

Set write permissions on the upload directory to allow Apache to store processed files:

Bash

chmod -R 0775 /var/www/website/public_html/upload/

Step 6: Verify Installation

Navigate to your application domain in a web browser to test the script, verify file uploads, and ensure all features execute correctly.