Getting Started
Application to send birthday and anniversary wish emails easily and elegantly (Download, Configure and go).
Refer this to know Why Choose Wishing Application
- Java 8
- Excel file with name, email, dob and hire date columns
Download the binary from the release and place it under a folder ( E:\wishing-app for example) lets call it WISHING_APP_HOME
Place the excel file (With minimum name, email, dob and hire date columns) under WISHING_APP_HOME
Create application.properties file under WISHING_APP_HOME as follows
## workbook 1
app.name1.wish_file=file:population_report.xlsx
app.number1.excel_sheet=1
app.name1.column=1
app.email1.column=2
app.dob1.column=3
app.hire1.column=4
## Email Configuratin details
spring.mail.default-encoding=UTF-8
spring.mail.host=smtp.gmail.com
[email protected]
spring.mail.password=GmailPAssword
spring.mail.port=587
spring.mail.protocol=smtp
spring.mail.test-connection=false
spring.mail.properties.mail.smtp.auth=true
spring.mail.properties.mail.smtp.starttls.enable=true
spring.mail.debug=true
logging.file.name=logs/wishing-app.log
The above configuration would run the job every day at 10:00 AM, if you want to change the schedule, add app.schedule.corn property in application.properties.
For example, following would kick off the job daily at 12:30
app.schedule.corn = 0 30 12 * * ?
Here is how keys are mapped to excel columns
And that's it, you are good to go. Double click wishing-app-2.0.0, It will run the application in background
Alternatively you can go to command prompt and execute the java -jar wishing-app-2.0.0.jar command to execute it in foreground
