Convert exported data from "Baby tracker - feeding, sleep and diaper" to BabyBuddy import format

[wunter8]

My wife and I just switched from using Baby tracker - feeding, sleep and diaper. I wanted to import the data from that app into BabyBuddy, so I wrote this little script. It only works for sleep, feedings, and diapers so far. If someone wants to transfer extra data (like tummy time), just let me know, and I can help you modify the script!

To get the data file, go into the app settings, click on Transfer > Send data, and send an email to yourself. The email will have an attachment (baby_data.abt). Pass in the child id from BabyBuddy and the path to baby_data.abt, and the script will generate diaper.csv, feedings.csv, and sleep.csv that you can import into BabyBuddy!

Note: you must have jq installed (e.g., sudo apt install jq)

#!/usr/bin/env bash

set -euo pipefail

if ! command -v jq &> /dev/null; then
  echo "jq is not installed"
  exit 1
fi

if [ $# -lt 2 ]; then
  echo "Missing arguments"
  echo "Usage: $0 [CHILD_ID] [ABT_FILE]"
  echo "Example: $0 1 ./baby_data.abt"
  exit 1
fi

CHILD_ID=$1
ABT_FILE=$2

unzip "$ABT_FILE" 2>&1 > /dev/null

echo "child_id,time,wet,solid" > diaper.csv

jq -r '.records[] | select(.type == "DIAPERING") | ['$1',.fromDate, (.subtype | contains("PEE")), (.subtype | contains("POO"))] | join(",")' "baby.json" >> diaper.csv
#!/usr/bin/env bash

echo "child_id,start,end,type,method" > feedings.csv

jq -r '.records[] | select(.type == "FEEDING") | ['$1',.fromDate,.toDate,"breast milk",(.subtype | ascii_downcase | sub("_"; " "))] | join(",")' "baby.json" >> feedings.csv
#!/usr/bin/env bash

echo "child_id,start,end" > sleep.csv

jq -r '.records[] | select(.type == "SLEEPING") | ['$1',.fromDate,.toDate] | join(",")' "baby.json" >> sleep.csv

rm "baby.json"

[klyoku]

Thanks for the script!

[khobbits]

I modified the above script to add a bit more detail. In the app I was logging pumping, using the notes and amounts of feeds, and wanted those carried over.

#!/usr/bin/env bash

set -euo pipefail

if ! command -v jq &> /dev/null; then
  echo "jq is not installed"
  exit 1
fi

if [ $# -lt 2 ]; then
  echo "Missing arguments"
  echo "Usage: $0 [CHILD_ID] [ABT_FILE]"
  echo "Example: $0 1 ./baby_data.abt"
  exit 1
fi

#rm -rf monthly_photos/ *.jpg *.csv baby.json

CHILD_ID=$1
ABT_FILE=$2

unzip "$ABT_FILE" 2>&1 > /dev/null

echo "child_id,time,wet,solid" > diaper.csv

jq -r '.records[] | select(.type == "DIAPERING") | ['$1',.fromDate, (.subtype | contains("PEE")), (.subtype | contains("POO"))] | join(",")' "baby.json" >> diaper.csv

echo "child_id,start,end,type,method,amount,notes" > feedings.csv

jq -r '.records[] | select(.type == "FEEDING") | ['$1',.fromDate,.toDate,"breast milk",(.subtype | ascii_downcase | sub("_"; " ")),.amount,(.details | sub(","; "."))] | join(",")' "baby.json" >> feedings.csv

echo "child_id,start,end" > sleep.csv

jq -r '.records[] | select(.type == "SLEEPING") | ['$1',.fromDate,.toDate] | join(",")' "baby.json" >> sleep.csv

echo "child_id,start,end,amount,notes" > pump.csv

jq -r '.records[] | select(.type == "PUMP") | ['$1',.fromDate,.toDate,.amount,(.details | sub(","; "."))] | join(",")' "baby.json" >> pump.csv


rm "baby.json"