FasterCSV (faster_csv) and Question of understanding

Ruby
1

Dear Experts,

I got a question for you: I need to produce a Ruby code which does the
following:

  1. I get a CSV file (more or less like this:
    name,id,in,out,ot,ab,x1,x2,x3,x4)
  2. I need to remove some columns (like the x1…x3)
  3. I need to group them per user (in this case either name or id)
  4. I need to add columns like salary (which I have to calculate first)
  5. I need to add a row with the monthly salary
  6. 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

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

3

Dot Baiki wrote:

  1. 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

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 :slight_smile:

However, thanks for this nice piece of software and advice! Brilliant!

Greetings from West Africa
.baiki

5

Ralf M. wrote:

Dot Baiki wrote:

  1. 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 :slight_smile:

Thanks so much!

Greetings from West Africa
.baiki

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 :slight_smile:

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 :slight_smile: 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

7

I close the thread here. Will post new one: Ruport for Beginner

Thanks.
Baiki