procon-webbot

Webbot for entering timesheets from CSV to ProCon using Selenium written in Python.

Limitations

At the moment it is possible to enter a timesheet for the current month, only. Furthermore it is not possible to divide the hours into several units. The working time is copied to a fixed unit.

Only Firefox is supported.

Prerequisites

Webdriver for Selenium

Download geckodriver and install it for your operating system.

Python packages

pip install -r requirements.txt

Certificate database

If your company is unable to provide a complete certificate chain, you may need to provide intermediate certificates yourself. All certificates from the certs subdirectory are put into a nss database which is used by Firefox then:

./create_cert_db.sh

Usage

Username and password have to be set via environment variables, e. g.

export PROCON_USERNAME=hartarbeiterhar
export PROCON_PASSWORD=ja3kqfJRd2gW

All other parameter can be set via environment variables or command line arguments:

Environment variable	Command line argument	Description	Default
`PROCON_URL`	`--url`	Base URL of ProCon	—
`PROCON_COST_CENTER`	`--costcenter`	Name of costcenter as displayed in ProCon	—
`PROCON_COLUMN_NAME_DATE`	`--column-name-date`	Name of date column in CSV file	—
`PROCON_COLUMN_NAME_START`	`--column-name-start`	Name of start column in CSV file	—
`PROCON_COLUMN_NAME_END`	`--column-name-end`	Name of end column in CSV file	—
`PROCON_COLUMN_NAME_PAUSE`	`--column-name-pause`	Name of pause column in CSV file	—
`PROCON_CSV_FORMAT_DATE`	`--csv-format-date`	Name of pause column in CSV file	`%d.%m.%Y`
`PROCON_CSV_FORMAT_TIME`	`--csv-format-time`	Name of pause column in CSV file	`%H:%M`
`PROCON_CSV_DELIMITER`	`--csv-delimiter`	Name of pause column in CSV file	`;`
`PROCON_CSV_QUOTE_CHAR`	`--csv-quote-char`	Name of pause column in CSV file	`"`

For example:

export PROCON_URL=https://procon.goetterbote.de/
export PROCON_COST_CENTER="123 SK0815 Migration to Cloud"

Imagine you have a CSV file with the following content:

Datum;Tag;Ein;Aus;Pause;Total;Total (dezimal)
01.03.2021;Mo;08:00;17:00;01:00;08:00;08.00

Then you would set in addition:

export PROCON_COLUMN_NAME_DATE="Datum"
export PROCON_COLUMN_NAME_START="Ein"
export PROCON_COLUMN_NAME_END="Aus"
export PROCON_COLUMN_NAME_PAUSE="Pause"

Finally you can execute the webbot:

./procon-webbot.py timesheet.csv