(540) 710-6199 | rappahannockcasa.com | 509 Lafayette Blvd, Fredericksburg, VA 22401
This project is the result of a semester's worth of collaboration among UMW students. The goal of the project was to create a web application that better suits the needs of Rappahannock CASA, specifically as a system to manage their donors and donations.
Ethan Bostick
Garrett McKenzie
Maximilian (Max) Redman
Joshua (Josh) Byrne
Carter Walker
James Heathcock
AI backed automated email generation
Importing donation and donor data through excel files.
Exporting donor and donation data to an excel file.
Automatic report generation that gives insight into donation and donor trends downloadable to PDF.
Option to manually add and remove donors as well as donations.
Ability to explore stored donation and donor information while taking advantages of preset optional filters.
Ability to create, track, and edit fundraising events.
Ability to create new admin users with permission to access the system.
We reccomend using Chrome for this application. Microsoft Edge as well as Safari are also supported. Other browsers may have unknown issues if this application is used with them.
Note that these instructions assume that you have already created a new siteground project such that you have an accessible site link and access to the siteground site tools.
-
For set-up, you will need to SSH into the siteground host. To do this begin by clicking the "devs" dropdown and from there selecting the "SSH Keys Manager" button.
-
Next, create an SSH key and copy it to a file.
-
On your local machine run the command "ssh-add path/to/file"
-
Return to siteground and click the kebab menu for the SSH key you just created. Then select the "SSH Creditials" option.
-
Use these credentials to SSH into siteground utilizing the command "ssh username.hostname -p port".
-
Once you are on siteground, navigate to public_html underneath the directory with the same name as your site.
-
Run the command "git init"
-
Run the command "git pull https://github.com/Garrett-Mckenzie/CASA.git"
-
Navigate to the "python" directory
-
Run the command "python -m pip install -r requirements.txt"
-
Move back to the "public_html" directory. In this directory you will need to create a .env and .api_env file. If you Dr. Polack then these files will be in the files we submitted for the final. If you are not Dr. Polack, then you need to add your own information into these files. Go to the ".env example" section for an example.
-
Navigate back to the directory "/home/username" and vim into the .bashrc file.
-
In the .bashrc put in the lines below
export OPENBLAS_NUM_THREADS=1
export OMP_NUM_THREADS=1
export NUMEXPR_NUM_THREADS=1
-
:wq out of the .bashrc file.
-
Run the command "exit" to leave siteground as everything should now be setup filewise.
-
Now to setup the database, go back to the siteground site tools webpage and select the "mysql" option under the "site" dropdown.
-
Select database and go through the steps to create a new database.
-
Create a user and grant them access to the database.
-
Navigate to phpMyAdmin found under phpMyAdmin.
-
Import the database using the "casadb.sql" file.
-
Update the dbinfo file found in the database directory of publich_html through the "File Manager" tab.
-
Everything should now be set up.
In ".env" SMTP_SERVER=
SMTP_PORT=
SMTP_USER=
SMTP_PASS=
In ".api_env"
OPENAI_API_KEY=
The project remains under the GNU General Public License v3.0.
Thank you to Dr. Polack and Rappahannock CASA for the opportunity to work on this project.