Generate personal letters which will be saved in txt format.

More output formats will be added in a different task

From 1st deliverable document:

The input data parser can be configured to accept data in different formats. Although
it is mandatory to import data in Excel format, the system should be ready to be extended in the
future to accept other formats easily

Configure the database and save the citizens read from the input file.

Extracted from the 1st deliverable document:

If a user appears in two different lists, this event will be recorded and informed in a log file. A
user can only be created once. If the data is different from the current data available in the
system, the current data will not be modified and an error will be recorded in the log.

Encrypt user passwords. We can use Jasypt

The service can be extended to handle security aspects

The input data parser can be configured to accept data in different formats. Although it is mandatory to import data in Excel format, the system should be ready to be extended in the future to accept other formats easily.

The system could be extended to emit the letters using other formats like Microsoft Word or PDF.

The txt letters that should be generated should be instead a PDF file. Must look for a library that does that and use it on the code.

Just parse Excel files (without error control).

Both the option to parse from other formats and the error control will be added later on in different tasks.

If the input file contains errors, the system must detect them and report the errors found.

The errors in the excel file should be send to the application log.