abesimpson
04-15-2008, 11:13 AM
I have been searching for code that will convert a specifically hard coded named csv file to an xml file of the same name.xml. I have found the following code (written by a J Norris) which purports to do this, but in a Ruby(?) scripting language, whatever that is.
#!/usr/bin/ruby
require 'csv'
print "CSV file to read: "
input_file = gets.chomp
print "File to write XML to: "
output_file = gets.chomp
print "What to call each record: "
record_name = gets.chomp
csv = CSV::parse(File.open(input_file) {|f| f.read} )
fields = csv.shift
puts "Writing XML..."
File.open(output_file, 'w') do |f|
f.puts '<?xml version="1.0"?>'
f.puts '<records>'
csv.each do |record|
f.puts " <#{record_name}>"
for i in 0..(fields.length - 1)
f.puts " <#{fields[i]}>#{record[i]}</#{fields[i]}>"
end
f.puts " </#{record_name}>"
end
f.puts '</records>'
end # End file block - close file
Thanks for any help in directing me to a solution.
#!/usr/bin/ruby
require 'csv'
print "CSV file to read: "
input_file = gets.chomp
print "File to write XML to: "
output_file = gets.chomp
print "What to call each record: "
record_name = gets.chomp
csv = CSV::parse(File.open(input_file) {|f| f.read} )
fields = csv.shift
puts "Writing XML..."
File.open(output_file, 'w') do |f|
f.puts '<?xml version="1.0"?>'
f.puts '<records>'
csv.each do |record|
f.puts " <#{record_name}>"
for i in 0..(fields.length - 1)
f.puts " <#{fields[i]}>#{record[i]}</#{fields[i]}>"
end
f.puts " </#{record_name}>"
end
f.puts '</records>'
end # End file block - close file
Thanks for any help in directing me to a solution.