From: Ralf Mueller on
Dot Baiki wrote:
> 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
>
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

From: Dot Baiki on
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
--
Posted via http://www.ruby-forum.com/.

From: James Edward Gray II on
On Sep 7, 2009, at 10:06 AM, Dot Baiki wrote:

> 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???

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 Gray II


From: Dot Baiki on
James Edward Gray 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 Gray 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
--
Posted via http://www.ruby-forum.com/.

From: Dot Baiki on
Ralf Mueller wrote:
> Dot Baiki wrote:
>> 5. 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
--
Posted via http://www.ruby-forum.com/.