Example MVE for facebook messenger counter

countmessages.rb

require 'nokogiri'
require 'axlsx'

catalog = ARGV[0]
user_name = Nokogiri::HTML(File.open("#{catalog}/index.htm")).title.split(' - Profile')[0]

friends = Hash.new

Dir.chdir("#{catalog}/messages") do
  messages_files = Dir.glob("*.html")

  messages_files.each do |file|
    content = File.open(file).read
	
    doc = Nokogiri::HTML(content)
    friend_name = doc.title.split("Conversation with ")[1]

    friends[friend_name] ||= 0

    puts "Analyzing conversation with: #{friend_name}"

    conversation = doc.css('.message')
	
	puts "Length #{conversation.length}"
		
    conversation.each do |conversation_node|
      if conversation_node['class'] == 'message'
		friends[friend_name] += 1
      end
    end
  end
end

ranking = friends

package = Axlsx::Package.new
package.workbook.add_worksheet(name: "Friends ranking") do |sheet|
  sheet.add_row ["Friends ranking"]
  sheet.add_row ['ID', 'Friend name', 'total count']
  rank = 1
  ranking.each do |friend_name, friend_data|
    sheet.add_row [rank, friend_name,
                  friend_data]
    rank += 1
  end
end

package.serialize('facebook_messages.xlsx')