The purpose of this evolving project is to create a platform for freelance professionals where they can manage their projects. Currently it is mainly focused on my own translation and review projects (English to Turkish).
Initially I used PostgreSQL to create a database and several procedures, functions and triggers. Then I added an Email Scraper that collects certain relevant information from my email account.
Managing my translation jobs and their purchase orders and payments, tracking open and closed projects, payment orders, payment due dates and statuses.
Collecting some basic information from my job emails.
PostgreSQL: Detailed information on each table and function, procedure can be found in the PostgreSQL folder. Email Scraper: This code allows the user to enter a certain date and extract certain information (sender, subject, due date) from emails that are sent on that date from a given domain. The relevant information is then stored in a notepad file. I used the web page https://www.datacourses.com/ for reference for the application of the email library of Python and also used the re (regex) library. The scraper avoids the reply emails and collects the relevant information only once.
projects table with calculated price based on job_type, rate_percentages, no match and fuzzy inputs
current purchase orders
table showing payment status
