Ruby script that reads the Extraction/Export error logs to generate recovery csv files.

gen_recovery_csv.rb

encounters = []
Dir.glob( '*.txt' ).each do |log|
  puts "Reading #{log}"
  input = File.new log, 'r'
  input.each_line do |line|
    if line.include? '):'
      encounter = line.split( '):' )[0].split( ' - ' )[1]
      encounters << encounter unless encounters.include? encounter
    end
  end
  input.close
end

puts "\nGenerating CSV Files..."

file_count = 1
lines_read = 0
master = File.new "recover_all.csv", 'w'
output = File.new "recover_#{file_count}.csv", 'w'
output << "EncounterNo\n"
master << "EncounterNo\n"

encounters.each do |encounter|
  output << "#{encounter}\n"
  master << "#{encounter}\n"
  lines_read += 1
  if lines_read > 2500
    output.close
    file_count += 1
    lines_read = 0
    output = File.new "recover_#{file_count}.csv", 'w'
    output << "EncounterNo\n"
  end
end

master.close
output.close
puts "Done"