haunts 0.1.0

How it works

The command will try to access a Google Spreatsheet you must own (write access required), specifically it will read a single sheet inside the spreadsheet.

Month sheet definition

The referenced sheet must contains a set of columns (with headers defined below) but orders matters not. Also: additional columns can be added and they will be ignored.

The partition in multiple sheets is designed to keep every month in a separate sheet, but this is not strictly checked.

Sheet format should be:

Date

(date)

The day where the event will be created

Spent

(number)

How long the event will last

Project

(number)

Project name (see below)

Activity

(string)

Summary of the event

Details

(string, optional)

Additional text for the event description

Event id

(string)

Leave this empty. It will be filled with the id of the generated event

Link

(text)

Leave this empty. It will be filled with a link to the event inside Google Calendar. Put an I manually if you want to ignore an entry and avoid event creation.

Action

(char)

See below. If emtpy: it will be filled with an I when an event is created

Configuring projects

The spreadsheet must also contains a configuration sheet (default name is config, can be changed in the .ini) where you must put two columns (with headers):

id

The id of the Google Calendar associated to this project. You must have write access to this calendar.

name

The name of the project, like an alias to the calendar

A project name can be associated to the same calendar id multiple times.

Values in the name columns are the only valid values for the Project column introduced above

How events will be filled

Let says you run something like this:

haunts --day=2021-07-08 July

haunts will access the sheet named July in the spreadsheet configured in the .ini file. Only rows where the Date filed will match the --day parameter will be considered.

For every rows that match, haunts will:

• Generate a new event, starting from a default time (this can be configured in the .ini). The event will last for Spent hours

• The next event will start where the previous ended

• If the event will be successfully created, an I will be placed in the Action column. This will make other execution of haunts to ignore the line.

• Other columns will be read or filled as described above.

OK, but why “haunts”?!

An haunt is a monster from Dungeond&Dragons, which was translated to italian as “Presenza”.

But “presenza” is the same term used in italian for “participation”, so how we call our worklogs.

And filling worklogs haunt us.