honorelsu · December 31, 2014 16:27
diff --git a/ops.rb b/ops.rb
 require 'CSV'

 input_path = ARGV[0]
 output_path = ARGV[1]

 class OutputRow
 	attr_accessor :dcs_tags, :alarm_hihi_enabled, :alarm_hihi, :alarm_hihi_pri, :alarm_high_enabled, :alarm_high, :alarm_high_pri,
 	:alarm_lolo_enabled, :alarm_lolo, :alarm_lolo_pri, :alarm_low_enabled, :alarm_low, :alarm_low_pri

 	def csv_row
 		#Put strings in order they should appear in the csv
 		[self.dcs_tags, self.alarm_high_enabled, self.alarm_high, self.alarm_high_pri, self.alarm_hihi_enabled, self.alarm_hihi, self.alarm_hihi_pri,
 		self.alarm_low_enabled, self.alarm_low, self.alarm_low_pri, self.alarm_lolo_enabled, self.alarm_lolo, self.alarm_lolo_pri]
 	end
 end

 #Convert tags to uppercase
 def handle_tag_names(output_row, tag)
 	return
 	output_row.send("tag_name=","#{tag.upcase}")
 end

 def handle_alarms(output_row, limit, value)
 	return if(limit.nil?) || limit =~ /op/i || limit.empty?
 	output_row.send("alarm_#{limit.downcase}=", value)
 	output_row.send("alarm_#{limit.downcase}_enabled=", "T")
 end

 def handle_priority(output_row, alarmtype, priority)
 	return if(alarmtype.nil?) || alarmtype =~ /op/i || alarmtype.empty?
 	output_row.send("alarm_#{alarmtype.downcase}_pri=", "#{priority.upcase}")
 end

 output_rows = []
 prev_row = nil

 CSV.foreach(input_path, headers: true, encoding: 'ISO-8859-1') do |row|
 	if row["DCS Tag Name"] != nil
 		ro = OutputRow.new
 		#keep getting an error here, I understand mostly why, but cannot overcome it
 		handle_tag_names(ro, row["DCS Tag Name"])
 		#ro.tag_desc = row["Tag Service Description"]
 		#ro.tag_eng_units = row["Tag Eng Units"]
 		handle_alarms(ro, row["Alarms::Limit Type"], row["Alarms::Limit Value"])
 		handle_priority(ro, row["Alarms::Limit Type"], row["Alarms::Alarm Priority"])
 		prev_row = ro
 		output_rows << ro
 	else
 		# other logic to fill out alarm columns for previous row
 		handle_alarms(prev_row, row["Alarms::Limit Type"], row["Alarms::Limit Value"])
 		handle_priority(prev_row, row["Alarms::Limit Type"], row["Alarms::Alarm Priority"])
 	end
 end

 CSV.open(output_path, "w") do |output_csv|
 	#column headers for output csv
 	headers = ["tag_name","alarm_hihi_enabled","alarm_hihi","alarm_hihi_pri","alarm_high_enabled","alarm_high","alarm_high_pri","alarm_lolo_enabled",
 		"alarm_lolo","alarm_lolo_pri","alarm_low_enabled","alarm_low","alarm_low_pri"]
 	output_csv << headers
 	output_rows.each do |output_row|
 		output_csv << output_row.csv_row
 	end
 end

 # def csv_to_array(file_location)
 # 	csv = CSV::parse(File.open(file_location, 'r') {|f| f.read})
 # 	fields = csv.shift
 # 	csv.collect {|record| Hash[*fields.zip(record).flatten]}
 # end

 # test = csv_to_array('opslimit2.csv')

 #DCS Tag Name,Tag Service Description,Tag Eng Units,Alarms::Limit Type,Alarms::Limit Value,Alarms::Alarm Priority
diff --git a/opsexport.csv b/opsexport.csv
	require 'CSV'

	input_path = ARGV[0]
	output_path = ARGV[1]

	class OutputRow
	attr_accessor :dcs_tags, :alarm_hihi_enabled, :alarm_hihi, :alarm_hihi_pri, :alarm_high_enabled, :alarm_high, :alarm_high_pri,
	:alarm_lolo_enabled, :alarm_lolo, :alarm_lolo_pri, :alarm_low_enabled, :alarm_low, :alarm_low_pri

	def csv_row
	#Put strings in order they should appear in the csv
	[self.dcs_tags, self.alarm_high_enabled, self.alarm_high, self.alarm_high_pri, self.alarm_hihi_enabled, self.alarm_hihi, self.alarm_hihi_pri,
	self.alarm_low_enabled, self.alarm_low, self.alarm_low_pri, self.alarm_lolo_enabled, self.alarm_lolo, self.alarm_lolo_pri]
	end
	end

	#Convert tags to uppercase
	def handle_tag_names(output_row, tag)
	return
	output_row.send("tag_name=","#{tag.upcase}")
	end

	def handle_alarms(output_row, limit, value)
	return if(limit.nil?) \|\| limit =~ /op/i \|\| limit.empty?
	output_row.send("alarm_#{limit.downcase}=", value)
	output_row.send("alarm_#{limit.downcase}_enabled=", "T")
	end

	def handle_priority(output_row, alarmtype, priority)
	return if(alarmtype.nil?) \|\| alarmtype =~ /op/i \|\| alarmtype.empty?
	output_row.send("alarm_#{alarmtype.downcase}_pri=", "#{priority.upcase}")
	end

	output_rows = []
	prev_row = nil

	CSV.foreach(input_path, headers: true, encoding: 'ISO-8859-1') do \|row\|
	if row["DCS Tag Name"] != nil
	ro = OutputRow.new
	#keep getting an error here, I understand mostly why, but cannot overcome it
	handle_tag_names(ro, row["DCS Tag Name"])
	#ro.tag_desc = row["Tag Service Description"]
	#ro.tag_eng_units = row["Tag Eng Units"]
	handle_alarms(ro, row["Alarms::Limit Type"], row["Alarms::Limit Value"])
	handle_priority(ro, row["Alarms::Limit Type"], row["Alarms::Alarm Priority"])
	prev_row = ro
	output_rows << ro
	else
	# other logic to fill out alarm columns for previous row
	handle_alarms(prev_row, row["Alarms::Limit Type"], row["Alarms::Limit Value"])
	handle_priority(prev_row, row["Alarms::Limit Type"], row["Alarms::Alarm Priority"])
	end
	end

	CSV.open(output_path, "w") do \|output_csv\|
	#column headers for output csv
	headers = ["tag_name","alarm_hihi_enabled","alarm_hihi","alarm_hihi_pri","alarm_high_enabled","alarm_high","alarm_high_pri","alarm_lolo_enabled",
	"alarm_lolo","alarm_lolo_pri","alarm_low_enabled","alarm_low","alarm_low_pri"]
	output_csv << headers
	output_rows.each do \|output_row\|
	output_csv << output_row.csv_row
	end
	end

	# def csv_to_array(file_location)
	# csv = CSV::parse(File.open(file_location, 'r') {\|f\| f.read})
	# fields = csv.shift
	# csv.collect {\|record\| Hash[*fields.zip(record).flatten]}
	# end

	# test = csv_to_array('opslimit2.csv')

	#DCS Tag Name,Tag Service Description,Tag Eng Units,Alarms::Limit Type,Alarms::Limit Value,Alarms::Alarm Priority
No results found