Workbook Loading Options

Under WISHING_APP_HOME lets create data folder.

Under WISHING_APP_HOME/data folder lets add all the worksheets you have

Lets say you have got two files to load, and those files are workbook1.xlsx and workbook2.csv

In this case app.count.wish_files=2 should be defined in your application.properties

Workbook level keys

• app.count.wish_files : Number of wish files to load
• app.name<index>.wish_file : Name of the wish file at [index], could csv or xlsx
• app.number<index>.excel_sheet : Excel sheet number in the given workbook at [index], default is 1, applicable to excel files only

Column level keys in a given sheet

• app.name<index>.column : Column index for name column (mandatory)
• app.email<index>.column : Column index for email column (mandatory)
• app.dob<index>.column : Column index for dob column, these cells should be date and not text (at least one of dob or hire date column is required)
• app.hire<index>.column : Column index for hire date column, these cells should be date and not text (at least one of dob or hire date column is required)
• app.dob<index>.date_format : Date format of dob in csv file, default is yyyy-MM-dd
• app.hire<index>.date_format : Date format of hire in csv file, default is yyyy-MM-dd

app.count.wish_files=2
## workbook 1
app.name1.wish_file=file:data/workbook1.xlsx
app.number1.excel_sheet=1
app.name1.column=1
app.email1.column=2
app.dob1.column=3
app.hire1.column=4

#[email protected]
#app.name1.cc=

## workbook 2
app.name2.wish_file=file:data/workbook2.csv
app.number2.excel_sheet=1
app.name2.column=1
app.email2.column=2
app.dob2.column=3
app.hire2.column=4
app.hire2.date_format=dd-MM-yyyy
app.dob2.date_format=dd-MM-yyyy

#[email protected]
#app.name2.cc=

Note

1. Email and date (Either dob or hire date) combination uniquely identify a wish.
2. You may optionally define workbook level configuration for app.name<index>.from and app.name<index>.cc
3. In the image below, newer release supports app.count.wish_files instead of app.count.excel_files

Various Options

1. We can load birthday report (name, email, dob) and anniversary (name, email, hire) report in separate excel files
2. We can load birthday report from sheet x and anniversary report from sheet y of same excel file
3. we can load an excel file having both birthday and anniversary data in same sheet (name, email, dob, hire).
4. We can load any combination of above.

Next

Configurations Unleashed