gistfile1.txt

require 'csv'
hash = {}

CSV::read('./datafile.csv') do |line|
hash[line[0]] = { :location => line[1], :device_type => line[3]}
end

#       device[line[0]] = {:location => line[1], :device_type => line[2]}
#       end

#Dir['/var/www/html/cacti/reports/1/1/*.csv'].each do |line|

Dir['./report.csv'].each do |line|

        date   = `cat #{line} | head -30 | grep "Start" | awk -F: '{print $2}'`
        date   =  date.gsub(/\s+/, "")
        header = "hostname interface date in_avg in_avg"

        report = `cat #{line} | grep "Monday"`
        report = report.gsub('Monday',"#{date}").gsub(' - Traffic','').gsub('"','')



#       open("/var/www/html/cacti/reports-parsed/interface-#{date}.csv", 'w') { |f|
        open("./interface-#{date}.csv", 'w') { |f|

                f.puts header}
        report.each_line { |line|
                fields = line.split(',')
                      hostname = fields[0].split('-')[0]
                      hostname = hostname.gsub(/\s+/, "")
                      interface = fields[0].split('-')[1]
                      interface = interface.gsub(/\s+/, "")
                inavg = "#{fields[8]}".gsub('k','').gsub(/\s+/, "").gsub('NA','')
                outavg = "#{fields[11]}".gsub('k','').gsub(/\s+/, "").gsub('NA','')

                location = hash[hostname][:location]

                output = "#{hostname},#{interface},#{fields[2]},#{inavg},#{outavg},#{location},#{location}"
 #               open("/var/www/html/cacti/reports-parsed/interface-#{date}.csv", 'a') { |f|
                open("./interface-parsed-#{date}.csv", 'a') { |f|
                f.puts output}
        }
end