Skip to content

Instantly share code, notes, and snippets.

# i3 config file (v4)
# Please see https://i3wm.org/docs/userguide.html for a complete reference!
# Set default border and layout sizes
set $border px 2
set $window_gaps px 2
# Set workspace layout to tabbed by default
workspace_layout tabbed
@xoquox
xoquox / Shopify to myHermes Export Converter
Last active February 16, 2023 16:45
A short Miller script for converting to Shopify oders_export.csv to the Hermes (Germany) CSV format for address import.
#!/bin/bash
mlr --csv --ofs ';' filter '${Shipping Name} != ""' \
then put '${Vorname (20)} = regextract(${Shipping Name},"([^\s]+)"); ${Nachname/Firmenname (30)} = regextract(${Shipping Name}, "(\S+)$"); ${Hausnummer (5)} = regextract(${Shipping Address1}, "\d+"); ${Strasse (27)} = regextract(${Shipping Address1}, "\D+")' \
then put '${Tel. Vorwahl (6)} = ""; ${Telefonnummer (14)} = ""; ${E-Mail-Adresse (70)} = ""; $Paketklasse = ""; $Sperrgutkennzeichen = "0"; $Nachnahmebetrag = ""; $Zusatzinformation = ""' \
then rename 'Shipping Zip','PLZ (10)','Shipping City','Ort (30)','Name','Kundenreferenznummer (20)','Shipping Address2','Adresszusatz (50)' \
then cut -o -f 'Vorname (20)','Nachname/Firmenname (30)','Adresszusatz (50)','Strasse (27)','Hausnummer (5)','PLZ (10)','Ort (30)','Tel. Vorwahl (6)','Telefonnummer (14)','E-Mail-Adresse (70)','Kundenreferenznummer (20)','Paketklasse','Sperrgutkennzeichen','Nachnahmebetrag','Zusatzinformation' \
orders_export.csv
// ==UserScript==
// @name Conexio Stettfeld
// @version 1.0
// @description Better Conexio
// @match http://bbodwfpdb57wipmt.myfritz.net/*
// @run-at document-start
// ==/UserScript==
(function() {