Teams has Attendance Reports for meetings. The data folder has some examples. For a recurring meeting this program generates an aggregate overview for all meeting reports passed as an argument.
Missing Features:
- Skip failed file instead of fail completely.
Bugs:
- Error messages go to stdout, not stderr.
Teams, open the meeting, and export the attendance report. This is a .csv file, in (stupid) UTF-16 format. The data folder has some examples.
To generate the summary report, execute:
teams-attendance --utf16 *.csvWithout the --utf16 option UTF-8 is assumed. To convert UTF-16 to UTF-8 you can also use iconv.
To replace the e-mails with a more readable name and company, use a UserMap file. Below is an example usermap.txt,
that maps emails found in the .csv report to Jan or Johnny an their company. If the .csv report contains an e-mail
not in the usermap, output is the same as without UserMap.
UserMap {name = "Jan", company = "UN", eMails = ["jan.janssens.ext@un.int","sdc@smallco.co.uk"]}
UserMap {name = "Johnny", company = "Scotch", eMails = ["Johnny.Walker@scotch.aero"]}
To generate using the UserMap:
teams-attendance --utf16 -u usermap.txt *.csvUsing test files in data folder:
stack run -- -h
stack run -- --utf16 $(find data/*.csv)
stack run -- --utf16 -u data/UserMap.txt $(find data/*.csv)stack path --local-bin
stack installOpen https://www.stackage.org/lts-20.12 and search for the type, e.g. optparse. You may find a package optparse-applicative, add that to package.yaml packages list.
Update the resolver field of the stack.yaml to use the latest LTS Haskell, then stack build.
Best to comment out all libraries in package.yaml first.
Note also stack.yaml of the “global project” (e.g. ~/.stack/global-project/stack.yaml).