Project only for ASIM - Excel CSV Creator & Daily Report-Generator

1. We have 32 backups from the same database as .sql-files.
From one table of this database we need all instances in one csv-file (with the same codepage as stated in the sql-file ).

So basicly you must:
- import 1st backup on your sql-server
- export the table "contracts" to "csv for Excel"
- repeat for all 31 other backups
- put everything together in one big csv-file that is readable in Excel (pls maintain german umlaute)

2. There should be a menu-item (i.e. "Report"); clicking this asks for the date "Welches Datum?"; the current date is proposed but can be changed by choosing a date in a calendar.

The report should consist of:

1. All customers that have been added at the given date.
2. All contracts that have been added at the given date
3. All contracts that have been modified at the given date

1. Fields for customer:
- Number, company, name, first-name, street, house-no, post-code, city

2+3. Fields for contract:
- contractNo, property-name, customer-no, customer-name, status, expert-name, no_of_bill, total_amount

related contract-actions:
- action-Type (WBA/HZ), wall-lenght

related payments
- paymentNo, paymentDate, payment-amount, method


All this report as a table in a html-page (so it can be printed as PDF or copied to Excel)