Generate CSV of file created/modified times

created-times.rb

# USAGE:
# 1. Save this file to your Desktop (Cmd-S, click Desktop in the left sidebar)
# 2. Open Terminal.app (Cmd-space, type "terminal", hit enter)
# 3. Type this, exactly: ruby ~/Desktop/created-times.rb
# 4. You should see some output about checking directories and how many files were loaded.
# 5. A media-.......csv file will appear on your Desktop, which can be loaded with Excel

require 'time'

extensions = ["jpg", "jpeg", "mov", "heic", "mp4"]

directories = ["Pictures", "Movies"]

files = directories.map { |directory|
  extensions.map { |extension|
    to_check = File.join(ENV['HOME'], directory, '**', "*.#{extension}")
    puts "Checking #{to_check}"
    Dir.glob(to_check)
  }
}.flatten

outfile = "media-#{Time.now.to_i}.csv"

File.open(File.join(ENV['HOME'], "Desktop", outfile), "w") do |out|
  out.puts "created, modified, filename"

  files.each_with_index do |file, i|
    puts "Loaded #{i} files" if i % 1000 == 0

    stat = File.stat(file)
    out.puts [stat.ctime.strftime("%Y-%m-%d %H:%M:%S"),
              stat.mtime.strftime("%Y-%m-%d %H:%M:%S"),
              file].map{ |col| "\"#{col}\"" }.join(",")
  end
end

puts "Wrote #{outfile} to desktop"