convert.rb

require 'csv'

head = <<-HEAD
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
<data-set xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
HEAD

foot = <<-FOOT
</data-set>
FOOT

def record(action, site, vendor, ap)
  <<-RECORD
  <record>
    <Action>#{action}</Action>
    <SiteID>#{site}</SiteID>
    <VendorID>#{vendor}</VendorID>
    <APCode>#{ap}</APCode>
  </record>
  RECORD
end

File.open("Vendor.xml", "w") do |file|
  file << head
  CSV.foreach("import.csv", headers: true) do |row|
    file << record(row[0].strip, row[1].strip, row[2].strip, row[3].strip)
  end
  file << foot
end