Skip to main content
Join the official 2020 Python Developers SurveyStart the survey!

This package demonstrates building and publishing Python Packages with GitHubs infrastructure

Project description

hetzner-fix-report

Fixes Hetzner CSV reports by cleaning the CSV and merging project name from PDF.

Installation

Preliminary libraries

Debian, Ubuntu, and friends

sudo apt-get install build-essential libpoppler-cpp-dev pkg-config python-dev

Fedora, Red Hat, and friends

sudo yum install gcc-c++ pkgconfig poppler-cpp-devel python-devel redhat-rpm-config

Python package

This project is hosted on PyPI and can therefore be installed easily through pip:

pip install hetzner_fix_report

Dependending on your setup you may need to add --user after the install.

Usage

Single report

Use the command line interface to combine a csv and pdf file:

hetzner-fix-report Hetzner_2020-01-05_RXXXXXXXXXX.csv Hetzner_2020-01-05_RXXXXXXXXXX.pdf

Or shorten it using brace expansion:

hetzner-fix-report Hetzner_2020-01-05_RXXXXXXXXXX.{csv,pdf}

If you want to save the enriched csv output, use either the -o parameter as explained in the program's help or redirect output to a file using >.

Batchwise processing

When in a directory that holds multiple csv and pdf files the following shell script should call the tool and save its output within a newly created subdirectory:

mkdir -p fix
for csv in *.csv; do pdf=${csv%%.*}.pdf; hetzner-fix-report -o "fix/$csv" "$csv" "$pdf"; done

Original & enriched format

Hetzner's original CSV reports have the problem of being unprecise and not machine readable. This is especially noticeable in the long multiline comment column that may is mostly human readable. Currently the PDF report contains additional information about the entry's (server/backup) associated project. Since this information is not contained within the CSV reports I wanted to fix this. The enriched format has the following keys and examplary values:

Key Example
id 2520725
name my-server
project My Project
type cx31
quantity 1
usage_hours 42
price 8.9
price_netto 4.9
price_max 2.49
day_from 2020-06-01
day_to 2020-06-30
is_backup False
is_server True
is_ceph False

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for hetzner-fix-report, version 0.5.0
Filename, size File type Python version Upload date Hashes
Filename, size hetzner_fix_report-0.5.0-py3-none-any.whl (6.4 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size hetzner_fix_report-0.5.0.tar.gz (10.1 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page