The Automated Vocabulary Delivery System is designed to help users systematically build their vocabulary by automating the process of storing, retrieving, and delivering vocabulary words and their meanings. This system utilizes Selenium with Java for automation and integrates with Jenkins for scheduling and email notifications.
Key Features
1. **Vocabulary Management:**
- Stores vocabulary words and their meanings in an Excel file.
- Uses the Apache POI library to read and write data dynamically.
2. **Automated Delivery:**
- Retrieves five new vocabulary words daily from the Excel file.
- Tracks processed and unprocessed words to ensure no repetition.
3. **Jenkins Integration:**
- Automates the daily delivery schedule.
- Sends vocabulary words and their meanings via email or Microsoft Teams using Jenkins' email notification feature.
4. **Dynamic Workflow:**
- Skips already processed words.
- Delivers only unprocessed words, ensuring a seamless learning experience.
Technology Stack
Programming Language:- Java
Automation Framework:- Selenium(Data Driven)
Data Handling:- Apache POI Library
Scheduler:- Jenkins
Email Integration:- Jenkins Email Extension Plugin
Build Tool:- Maven
Workflow
1. Data Handling
- Vocabulary words and meanings are stored in an Excel file (e.g., `vocabulary.xlsx`).
- Apache POI library is used for:
- Reading unprocessed words from the Excel file.
- Writing updates to mark words as processed.
2. Daily Processing Logic
- Reads the Excel file to identify the next five unprocessed words.
- Updates their status as "processed" after sending.
3. Email/Team Notifications
- Retrieves the daily set of five words.
- Formats the content into an email-friendly structure.
- Sends the email to the user’s inbox or posts to a Microsoft Teams channel.
4. Jenkins Integration
- A Jenkins pipeline schedules the script to run daily.
- Jenkins triggers the script and handles email notifications using pre-configured SMTP settings.
Implementation Details
Benefits
- Fully automated system for consistent vocabulary learning.
- Reduces manual effort in tracking and delivering vocabulary words.
- Highly customizable for different use cases or word delivery platforms
#Automation #Programming #JavaDevelopment #SeleniumAutomation #JenkinsPipeline #ApachePOI #JavaProjects #AutomationTesting #ExcelAutomation