baiki
September 7, 2009, 5:06pm
1
Dear Experts,
I got a question for you: I need to produce a Ruby code which does the
following:
I get a CSV file (more or less like this:
name,id,in,out,ot,ab,x1,x2,x3,x4)
I need to remove some columns (like the x1…x3)
I need to group them per user (in this case either name or id)
I need to add columns like salary (which I have to calculate first)
I need to add a row with the monthly salary
and… a PDF to print this correctly
And now? Ruby + FasterCSV + ???PDF???
Please, do not come up with Ruport because I tried this for 7 days now.
success = 0
Are there better solutions (please no Jasper, OpenRPT etc.)
Regards,
Baiki
baiki
September 7, 2009, 7:02pm
2
On Sep 7, 2009, at 10:06 AM, Dot Baiki wrote:
And now? Ruby + FasterCSV + ???PDF???
FasterCSV can definitely help you read an manipulate the data as you
have described.
Please, do not come up with Ruport because I tried this for 7 days
now.
success = 0
Have your tried handling the PDF generation using Prawn
(http://prawn.majesticseacreature.com/
)? Hopefully it can do what you need.
James Edward G. II
baiki
September 7, 2009, 8:49pm
3
Dot Baiki wrote:
I need to add a row with the monthly salary
Baiki
I wrote a CSV-handling library for similar purposes (e.g. grouping,
extcsv.rubyforge.org ). Maybe it’s helpfull.
In case you use it and run into problems, drop me a line.
regards
Ralf
baiki
September 8, 2009, 1:54pm
4
James Edward G. II wrote:
On Sep 7, 2009, at 10:06 AM, Dot Baiki wrote:
And now? Ruby + FasterCSV + ???PDF???
FasterCSV can definitely help you read an manipulate the data as you
have described.
Please, do not come up with Ruport because I tried this for 7 days
now.
success = 0
Have your tried handling the PDF generation using Prawn
(http://prawn.majesticseacreature.com/
)? Hopefully it can do what you need.
James Edward G. II
OK, seems like I don’t have to buy Crystal Reports (hi hi hi hi). I have
downloaded Prawn and will start to play around (or mess around?) with
today
However, thanks for this nice piece of software and advice! Brilliant!
Greetings from West Africa
.baiki
baiki
September 8, 2009, 2:03pm
5
Ralf M. wrote:
Dot Baiki wrote:
I need to add a row with the monthly salary
Baiki
I wrote a CSV-handling library for similar purposes (e.g. grouping,
extcsv.rubyforge.org ). Maybe it’s helpfull.
In case you use it and run into problems, drop me a line.
regards
Ralf
Hallöchen and hello Ralf
Great, thanks a lot! Just visited your page and I definitely have to
consider your solution as well. Since I am a bloody beginner, it’ll take
a decade to really understand everything but it’s worth it
Thanks so much!
Greetings from West Africa
.baiki
baiki
September 9, 2009, 2:47pm
6
Dot Baiki wrote:
James Edward G. II wrote:
On Sep 7, 2009, at 10:06 AM, Dot Baiki wrote:
And now? Ruby + FasterCSV + ???PDF???
FasterCSV can definitely help you read an manipulate the data as you
have described.
Please, do not come up with Ruport because I tried this for 7 days
now.
success = 0
Have your tried handling the PDF generation using Prawn
(http://prawn.majesticseacreature.com/
)? Hopefully it can do what you need.
James Edward G. II
OK, seems like I don’t have to buy Crystal Reports (hi hi hi hi). I have
downloaded Prawn and will start to play around (or mess around?) with
today
However, thanks for this nice piece of software and advice! Brilliant!
Greetings from West Africa
.baiki
Hello Sir James Edward G. II,
Well, now I know who I am talking to Respect! However, I checked all
the suggestions: Ruport, Ruby, CSV, fastercsv, prawn, extcvs.
All so beautiful. However, right now I have at least three lines in my
code
#!/usr/bin/ruby
require ‘rubygems’
require ‘ruport’
Hope I go in the right direction. Let you know when I have success (or
questions).
Greetings
baiki
September 10, 2009, 3:54pm
7
I close the thread here. Will post new one: Ruport for Beginner
Thanks.
Baiki