Some helper scripts for the day to day work with Ubuntu in WSL2
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Holger Frey 6600415495 split recipients in list, cc and bcc section 5 days ago
work_helpers split recipients in list, cc and bcc section 5 days ago
.gitignore first version of excel to changelog script 6 years ago
LICENSE Initial commit 6 years ago
README.md the library PyPDFForm had some API changes, scripts updated accordingly 6 days ago
pyproject.toml archiving travel notes now works as expected 6 days ago

README.md

work-helpers

Some helper scripts for the day to day work. This scripts are exposed on the cli via links in ~/.local/bin.

  • form_inspect [OPTIONS] FORM: inspect a pdf form and add the name of the input fields as values
  • group_schedule: query the calendar for the group meetings and prepare text representaions of the upcoming meetings for emails and wiki entries.
  • nice_path: create a nice path representation from a copied windows path
  • random_password: copies a random password to the clipboard
  • travel_advance_payments: create an "UK-Abschlag" form from an SuperX extract in xlsx format
  • travel_archive_note TRAVELNUMBER: convert an obisidan markdown note of a business travel to pdf for archival
  • travel_final_payment: create a scaffold for the final payment documents of a business travel from an SuperX extract in xlsx format and a markdown note in obsidian

Archived Safeguard Stuff

Some helper scripts for the day to day work used in the safeguard project

  • sensospot_rename: rename sensospot images in a batch
  • sg_mbp_new_version: creates a new version folder, new excel changes files and modifies the overall changelog
  • sg_mbp_release: collect and annotate all files used for a safeguard workbook release
  • sg_list_frms: collect gitea issues and related frm filenames
  • xls2changelog: reformat copied excel data to the safeguard changelog format
  • xls2markdown: reformat copied excel data to a markdown table
  • xls2pylist: reformat copied excel data to a python list

Proposed workflow for Safeguard projects

  1. create a new version in the issues repo folder "E:\Safeguard-MBP-issues" with sg_mbp_new_version
  2. make your required edits in the workbooks and record the changes in the excel changelog files using xls2changelog
  3. edit the changelog file in "E:\Safeguard-MBP-issues"
  4. pack everything together for a release with sg_mbp_release

sg_mbp_release

Before running this command:

  • make the required edits to the workbooks
  • create a new versions folder in "E:\Safeguard-MBP-issues", e.g. "v3.9.49" (try the new sg_mbp_new_version command for this)
  • note the changes in the excel changelogs in the created version folder
  • edit the changelog in "E:\Safeguard-MBP-issues"

The command will collect all data into one folder on the Desktop to be published.