This project implements 3 tickets to confirm the correctness of a student's working hours.
- Download the newest version of Pentaho from https://sourceforge.net/projects/pentaho/files/latest/download
- Move the unzipped folder called something like "data integration" to your Applications directory
- Open a terminal and navigate to
/Applications/data-integration/Data\ Integration.app\Contents\MacOS
- In this folder you have to execute the
./JavaApplicationStub
- Now, the application should open
- After the software started, you can add the 3 tickets from the java folder to the software (open file option in the software)
- Open the data-integration folder, right-click the Data Integration symbol
- Click "Show Package Contents" (Packetinhalte anzeigen)
- Navigate to
Contents/MacOS/JavaApplicationStub
execute the JavaApplicationStub exec - After the software started, you can add the 3 tickets from the java folder to the software (open file option in the software)
Ticket 1: Checks, that working hours are <= 20 per week in lecture period
Ticket 2: Checks, that the working time of 8 hours per day has not been exceeded
Ticket 3: Checks, that working time is not over 5 hours without a break of at least 15 minutes
Ticket 1:
- Add your working times in correct csv format into the "Read Arbeitszeiten" text file input
- Preview rows to detect potential errors
- Add the Vorlesungszeiten.csv to the "Read Vorlesungszeiträume" text file input (note that only semesters from 2019-2024 are included)
- Run the ticket
- Look into "Preview data" tab to see your results, if your times are correct or should be revised
Ticket 2:
- Add your working times in correct csv format into the "Read Arbeitszeiten" text file input
- Preview rows to detect potential errors
- Run the ticket
- Look into "Preview data" tab to see your results, if your times are correct or should be revised
Ticket 3:
- Add your working times in correct csv format into the "Read Arbeitszeiten" text file input
- Preview rows to detect potential errors
- Run the ticket
- Look into "Preview data" tab to see your results, if your times are correct or should be revised
Kunde,Tag,Uhrzeit Von,Uhrzeit Bis,Tätigkeit
Example:SDM,01.03.2023,8:00,12:00,Arbeiten am Reporting Projekt
- "Uhrzeit Von" and "Uhrzeit Bis" need the format HH:mm
- You also have to reload your fields
If you have issues trying to run the application, use following steps:
- Be sure, that you are using java version 8 (
java -version
) - Increase the max memory limit with the command
export PENTAHO_DI_JAVA_OPTIONS="-Xmx2g -XX:MaxPermSize=256m"
- Call the commands with sudo
- Execute the
spoon.sh
file in the data-integration folder to execute the application - View problem: Change your Mac appearance to light mode to avoid view problems and restart the application