[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Appending to a CSV file

Bil Kleb

7/12/2006 2:18:00 PM

Just got a call from a telecommuting colleague
who's using Ruby to automate a bunch of CEV[1]
CFD[2] simulations.

She says that she can't figure out how to /append/
to a CSV file using Ruby's standard library.

Does anyone have the magic recipe, or should
she be using FasterCSV instead?

Thanks,
--
Bil
http://fun3d.lar...

[1] CEV = Crew Exploration Vehicle
[2] CFD = Computational Fluid Dynamics
13 Answers

Chris Hulan

7/12/2006 5:22:00 PM

0

Bil Kleb wrote:
....
> She says that she can't figure out how to /append/
> to a CSV file using Ruby's standard library.
....

Wouldn't it just be a matter of opening the file in append mode?

cheers
Chris

Chris Hulan

7/12/2006 6:55:00 PM

0

ChrisH wrote:
> Bil Kleb wrote:
> ...
>> She says that she can't figure out how to /append/
>> to a CSV file using Ruby's standard library.
> ...
>
> Wouldn't it just be a matter of opening the file in append mode?
>
> cheers
> Chris

Ok, note to self "read docs before commenting"

it seems CSV only supports 'r','rb','w','wb' for open.
FasterCSV delegates to an IO object and supports all IO's modes.
So it would be the winner

Cheers

--
Posted via http://www.ruby-....

Bil Kleb

7/12/2006 7:26:00 PM

0

ChrisH wrote:
> Bil Kleb wrote:
> ...
>> She says that she can't figure out how to /append/
>> to a CSV file using Ruby's standard library.
> ...
>
> Wouldn't it just be a matter of opening the file in append mode?

It would, but unfortunately CSV doesn't support 'a'
or 'a+', viz, lib/ruby/1.8/csv.rb,

83 def CSV.open(path, mode, fs = nil, rs = nil, &block)
84 if mode == 'r' or mode == 'rb'
85 open_reader(path, mode, fs, rs, &block)
86 elsif mode == 'w' or mode == 'wb'
87 open_writer(path, mode, fs, rs, &block)
88 else
89 raise ArgumentError.new("'mode' must be 'r', 'rb', 'w', or 'wb'")
90 end
91 end

Later,
--
Bil
http://fun3d.lar...

James Gray

7/12/2006 7:26:00 PM

0

On Jul 12, 2006, at 1:55 PM, Chris Hulan wrote:

> it seems CSV only supports 'r','rb','w','wb' for open.
> FasterCSV delegates to an IO object and supports all IO's modes.
> So it would be the winner

Interestingly, this design choice in FasterCSV has been questioned in
the past. I just keep liking it more and more though as issues like
this arise. :)

James Edward Gray II

Chris Hulan

7/12/2006 7:40:00 PM

0

James Gray wrote:
> On Jul 12, 2006, at 1:55 PM, Chris Hulan wrote:
>
>> it seems CSV only supports 'r','rb','w','wb' for open.
>> FasterCSV delegates to an IO object and supports all IO's modes.
>> So it would be the winner
>
> Interestingly, this design choice in FasterCSV has been questioned in
> the past. I just keep liking it more and more though as issues like
> this arise. :)
>
> James Edward Gray II

It does seem a bit odd that CSV limits the modes.

On the other hand, the desired result can be achieved by creating a
new file, copy existing data, add the new data, delete (or rename to be
safe)
the original and rename the new file to the old file name.

I think supporting the append mode is easier all round...

cheers
Chris

--
Posted via http://www.ruby-....

Hal E. Fulton

7/13/2006 2:11:00 AM

0

Bil Kleb wrote:
> ChrisH wrote:
>
>> Bil Kleb wrote:
>> ...
>>
>>> She says that she can't figure out how to /append/
>>> to a CSV file using Ruby's standard library.
>>
>> ...
>>
>> Wouldn't it just be a matter of opening the file in append mode?
>
>
> It would, but unfortunately CSV doesn't support 'a'
> or 'a+', viz, lib/ruby/1.8/csv.rb,

Well, darn.

All I can think of offhand is 1) write the new stuff to a new file
and then 2) use fileutils to append the new file onto the old one.

Disclaimers:

1. I'm not sure fileutils has a good way to do that, but
if it doesn't, there's always system("cat newfile >>oldfile").

2. Obviously be sure the old file is closed before trying to
so anything funny with it.


Hal

Seth Thomas Rasmussen

7/13/2006 1:06:00 PM

0

I'm not very familiar with the CSV lib, but if the heart of the matter
is appending to a CSV file, you hardly need a full-on CSV lib for
something like that.

File.open(my_csv) {|f| f.puts new_record} # think it oughta be as
simple as that
File.open(my_csv) {|f| f.puts *new_records} # puts can take a list, too

Bil Kleb wrote:
> ChrisH wrote:
> > Bil Kleb wrote:
> > ...
> >> She says that she can't figure out how to /append/
> >> to a CSV file using Ruby's standard library.
> > ...
> >
> > Wouldn't it just be a matter of opening the file in append mode?
>
> It would, but unfortunately CSV doesn't support 'a'
> or 'a+', viz, lib/ruby/1.8/csv.rb,
>
> 83 def CSV.open(path, mode, fs = nil, rs = nil, &block)
> 84 if mode == 'r' or mode == 'rb'
> 85 open_reader(path, mode, fs, rs, &block)
> 86 elsif mode == 'w' or mode == 'wb'
> 87 open_writer(path, mode, fs, rs, &block)
> 88 else
> 89 raise ArgumentError.new("'mode' must be 'r', 'rb', 'w', or 'wb'")
> 90 end
> 91 end
>
> Later,
> --
> Bil
> http://fun3d.lar...

Seth Thomas Rasmussen

7/13/2006 1:07:00 PM

0

Sorry about my last post sort of skipping over the whole matter of the
write mode.. you're smarter than me, though, I'm sure you'll be fine.
;-p


Bil Kleb wrote:
> ChrisH wrote:
> > Bil Kleb wrote:
> > ...
> >> She says that she can't figure out how to /append/
> >> to a CSV file using Ruby's standard library.
> > ...
> >
> > Wouldn't it just be a matter of opening the file in append mode?
>
> It would, but unfortunately CSV doesn't support 'a'
> or 'a+', viz, lib/ruby/1.8/csv.rb,
>
> 83 def CSV.open(path, mode, fs = nil, rs = nil, &block)
> 84 if mode == 'r' or mode == 'rb'
> 85 open_reader(path, mode, fs, rs, &block)
> 86 elsif mode == 'w' or mode == 'wb'
> 87 open_writer(path, mode, fs, rs, &block)
> 88 else
> 89 raise ArgumentError.new("'mode' must be 'r', 'rb', 'w', or 'wb'")
> 90 end
> 91 end
>
> Later,
> --
> Bil
> http://fun3d.lar...

greg.kujawa

7/13/2006 1:47:00 PM

0

I haven't used the CSV module before either, but looking into it this
test script I came up with parses a CSV source file, writing it to a
new array. Then you can append to that new array and write the results
back to the original CSV file. It's not pretty and might not be the
most Rubyish way of getting the job done but it worked for me using
Ruby 1.8.2 on Win32. Try it out and let me know...

require 'csv'

# test.csv consists of three comma delimited fields, something like:
#
# 1,"Greg","Admin"
# 2,"Joe","User"
# 3,"Jim","Admin"

new_array = []
temp_array = []

reader = CSV.open('test.csv', 'r') do |row|
(0...row.nitems).each do |item|
temp_array.push(row[item].data)
end
new_array << temp_array
temp_array = []
end

new_items = [4,"Jane","User"]
new_array << new_items

CSV.open('test.csv', 'w') do |writer|
new_array.each do |row|
writer << row
end
end


Bil Kleb wrote:
> ChrisH wrote:
> > Bil Kleb wrote:
> > ...
> >> She says that she can't figure out how to /append/
> >> to a CSV file using Ruby's standard library.
> > ...
> >
> > Wouldn't it just be a matter of opening the file in append mode?
>
> It would, but unfortunately CSV doesn't support 'a'
> or 'a+', viz, lib/ruby/1.8/csv.rb,
>
> 83 def CSV.open(path, mode, fs = nil, rs = nil, &block)
> 84 if mode == 'r' or mode == 'rb'
> 85 open_reader(path, mode, fs, rs, &block)
> 86 elsif mode == 'w' or mode == 'wb'
> 87 open_writer(path, mode, fs, rs, &block)
> 88 else
> 89 raise ArgumentError.new("'mode' must be 'r', 'rb', 'w', or 'wb'")
> 90 end
> 91 end
>
> Later,
> --
> Bil
> http://fun3d.lar...

Chris Hulan

7/13/2006 3:07:00 PM

0

Bil Kleb wrote:
....
> She says that she can't figure out how to /append/
> to a CSV file using Ruby's standard library.
....

Not sure if you read ruby-forum (http://www.ruby-...)
but a response ther indicates that you can do this via the CSV::Writer:

File.open('csvout.csv', 'a'){ |outfile|
CSV::Writer.generate(outfile) do |csv|
csv << ['c1', nil, '', '"', "\r\n", 'c2']
end
}


Cheers
Chris