Script to prepare an Fritz!Box Anrufliste.csv to a format suitable for DB import

prepare anrufliste_postgres.sh

#!/usr/bin/env bash

# Remove first line (having the separator indicator)
# Change date from "dd.MM.yy hh:mm" to "yyyy-MM-dd hh:mm:ss" (with second always 00)
# Change duration from "hh:mm" to "hh:mm:ss" (with seconds always 00)

cat |
tail -n +2 |
sed -e 's/;\(..\)\.\(..\)\.\(..\) \(..:..\);/;20\3-\2-\1 \4:00;/g' |
sed -e 's/:\([0-9]\{2\}\)$/:\1:00/g'
  

prepare anrufliste_sqlite.sh

#!/usr/bin/env bash

# Remove separator indicator
# Change date from "dd.MM.yy hh:mm" to "yyyy-MM-dd hh:mm" 
# Change separator ; to ,

grep -v '^sep=;$' |
sed -e 's/;\(..\)\.\(..\)\.\(..\) \(..:..\);/;20\3-\2-\1 \4;/g' |
xsv fmt -d';'