FasterCVS Question/Problem

[Eric Marthinsen]

Hello-

I'm using FasterCSV to export order records for our fulfillment partner.
Here's a boiled-down snippet of my code:

FasterCSV.open(filename, "w", :encoding => 'N') do |csv|
orders.each do |order|
order.items.each do |item|
csv << [
item.sku.sku,
item.quantity,
order.customer.first_name,
order.customer.last_name
]
end
end
end

If I had one order with two items, I'd expect the output to look like
this:

SKU001,1,John,Smith
SKU002,1,John,Smith

However, the output actually looks like this:

"SKU001,SKU002",1,John,Smith

It seems to be taking the common information and collapsing it onto a
single row. Does anyone know how to get the output to resemble what I
was expecting?

Thanks in advance,
Eric

 

[James Gray]

Hello-
Howdy.

I'm using FasterCSV to export order records for our fulfillment
partner.
Here's a boiled-down snippet of my code:

FasterCSV.open(filename, "w", :encoding => 'N') do |csv|
orders.each do |order|
order.items.each do |item|
csv << [
item.sku.sku,

This line seems fishy. You call sku() twice here.

item.quantity,
order.customer.first_name,
order.customer.last_name
]
end
end
end

If I had one order with two items, I'd expect the output to look like
this:

SKU001,1,John,Smith
SKU002,1,John,Smith

However, the output actually looks like this:

"SKU001,SKU002",1,John,Smith

It seems to be taking the common information and collapsing it onto a
single row. Does anyone know how to get the output to resemble what I
was expecting?

I expect the output to be what you so as well. I ran this code as saw
the output we both expected:

#!/usr/bin/env ruby -wKU

require "rubygems"
require "faster_csv"

Customer = Struct.newfirst_name, :last_name)
Order = Struct.newcustomer, :items)
Item = Struct.newsku, :quantity)

customer = Customer.new("John", "Smith")
orders = [Order.new(customer, %w[SKU001 SKU002].map { |s|
Item.new(s, 1) })]

FasterCSV.open("example.csv", "w", :encoding => "N") do |csv|
orders.each do |order|
order.items.each do |item|
csv << [ item.sku,
item.quantity,
order.customer.first_name,
order.customer.last_name ]
end
end
end

__END__

Does that help?

James Edward Gray II

 

[Eric Marthinsen]

Hi James-

Thanks for your reply (and the great library). It turns out this one was
human error. The FasterCSV library is working flawlessly. Someone had
entered the string "SKU001,SKU002" as the sku, so the output is exactly
what one would expect it to be. Incidentally, I called sku twice because
My Item object has a Sku child which has a sku accessor. Not the best
naming convention.

Regards,
Eric

 

[James Gray]

Hi James-

Thanks for your reply (and the great library). It turns out this one
was
human error. The FasterCSV library is working flawlessly. Someone had
entered the string "SKU001,SKU002" as the sku, so the output is
exactly
what one would expect it to be. Incidentally, I called sku twice
because
My Item object has a Sku child which has a sku accessor. Not the best
naming convention.

I'm glad to hear that you got it figured out. Good luck with the
project.

James Edward Gray II