pawelpluta / kup-script Goto Github PK

Generate CSV that will contain input for hour report, including KUP

During filtering and aggregating report data, commit date is used. It rather should use file creation date instead.

• check, how to filter git log by file creation date (if it is possible)
• use file creation date in report

Some workstations are using different formats of date. It might be better to check, if date is only value in line.

Some files are automatically generated and probably should not be included in the KUP report.

An example is a package-lock.json containing the versions of dependencies pulled in by npm. It needs to be committed as it is used in the CI to enforce repeatable builds.

We could provide a blacklist in the shouldBeIncludedInKUP function in the format-kup-report.awk file. It would need to receive the file name.

If the idea is ok I can provide a pull request.

Force use of tab character as awk split operator

The extension can be added to the isProperties function in format-kup-report.awk.

On some workstations with default language different than polish, it might encode arguments provided to VBA script (names, surnames).

Fixing it would require probably changing language during template generation, but its a little bit hacky.

Workaround

1. execute the script and provide parameters for VBA script as described in the readme
2. after generation of report, open templates directory and open YYYY-MM_yourname.doc file
3. change displayed values that are misformatted (usually part of name/surnames are missing - your or your supervisor)
4. save template
5. after generating report once more, it will contain fixed names

First column in generated report contains verbose project name. It could be shortened to project name only.
Note: it works when authentication is done by user/password credentials.

Include headers with column description in CSV