Daylio Journal Formatter ingests Daylio CSV export and produces Markdown / Gemtext

formatter.rb

require "csv"
require "date"

output = []

File.open("raw.csv").each_line do |input_row|
  begin
    CSV.parse(input_row) do |(date, time, entry)|
        if entry && date != "full_date"
            a = "#{date} #{time}"
            output.push([DateTime.parse(a), entry])
        end
    end
  end
end

output
  .group_by{|(d,e)| d.jd}
  .to_a
  .sort{|(d,e)| d}
  .map do |(date, entries)|
    header = entries.first.first.strftime("# %m/%d/%Y").chomp
    body = entries.sort { |(d,t)| d }.map { |(d,t)| puts d.strftime("\n%H:%M: #{t}").chomp }
    puts "\n" + header + body.join()
  end