Re: [Rlib-users] Dataset for "Basic Charting" example grN columns, why duplicates?

[Jeff K. <jt...@ya...>]

Attached is chart_csv_example.csv. It is a recreation of http://rlib.sicompos.com/examples.php  "Basic Charting" with a python script loading three CSV files. The main data chart.csv file is known to be incorrect.

There is also one fix to the report definition, a missing parenthesis, included as chart.xml.patch.

And actually, no I had not seen [1]. I had no idea there was even an RLIB Wiki!

Thanks,
Jeff


[1] http://newrlib.sicom.com/~rlib/index.php/Documentation_Breaks_Variables


--- On Tue, 10/6/09, Bob Doan <bd...@si...> wrote:

> From: Bob Doan <bd...@si...>
> Subject: Re: [Rlib-users] Dataset for "Basic Charting" example grN columns, why duplicates?
> To: "Jeff Kowalczyk" <jt...@ya...>
> Cc: rli...@li...
> Date: Tuesday, October 6, 2009, 12:59 PM
> Jeff,
> 
> I would need to see your output and XML file to see what
> exactly is
> going on.  Ideally send me a tarball of the whole
> thing.
> 
> Also.. Did you read this:
> 
> http://newrlib.sicom.com/~rlib/index.php/Documentation_Breaks_Variables
> 
> - Bob
> 
> -- 
> Bob Doan
> Vice President of Information Technology
> SICOM Systems
> bd...@si...
> 800-547-4266 x217
> 
> On Sat, 2009-10-03 at 00:06 +0000, Jeff Kowalczyk wrote:
> > As an RLIB evaluation for an upcoming report-writing
> project, I am reproducing
> > the "Basic Charting" example [1], using the provided
> chart.xml report
> > definition, and the columns from the plaintext
> representation.
> > 
> > I need some information on the g0_name...g4_name
> columns. I have a nearly
> > correct chart.csv, but extra grouping levels that the
> original doesn't have. I
> > presume there will be some duplicate columns, but I
> haven't figured out which
> > and why.
> > 
> > Can someone post the chart.csv that corresponds to the
> original example?
> > 
> > Thanks,
> > Jeff
> > 
> > [1] http://rlib.sicompos.com/examples.php
> "Basic Charting"
> > 
> > I have a working python script:
> > 
> > $ cat chart.py
> > import rlib
> > rpt = rlib.open()
> > rpt.add_datasource_csv("chart_csv")
> > rpt.add_datasource_csv("chart_m_csv")
> > rpt.add_datasource_csv("chart_header_csv")
> > rpt.add_query_as("chart_csv", "chart.csv",
> "products")
> > rpt.add_query_as("chart_header_csv",
> "chart_header.csv", "header")
> > rpt.add_query_as("chart_m_csv", "chart_m.csv", "m")
> > rpt.add_report("chart.xml")
> > rpt.set_output_format_from_text("pdf")
> > rpt.execute()
> > rpt.spool()
> > 
> > $ python chart.py > chart.pdf
> > 
> > The supporting datasets work fine:
> > 
> > $ cat chart_header.csv 
> > "report_name","name","name2",
> > "Financial Summary Report ","Some Company INC","Expert
> Managers Of Restaurants",
> > 
> > $ cat chart_m.csv 
> > "start_date","end_date"
> > "2003-09-07","2003-09-10"
> > 
> > I won't post the charts.csv here for space, see:
> > http://www.privatepaste.com/12cf7IxcEw
> > 
> > I would greatly appreciate suggestions and corrections
> on the proper use of the
> > g0_name...g4_name columns. If can explain why there
> are extra grouping levels,
> > that would be very helpful.
> > 
> > Thanks again.
> > 
> > 
> >
> ------------------------------------------------------------------------------
> > Come build with us! The BlackBerry&reg; Developer
> Conference in SF, CA
> > is the only developer event you need to attend this
> year. Jumpstart your
> > developing skills, take BlackBerry mobile applications
> to market and stay 
> > ahead of the curve. Join us from November 9-12,
> 2009. Register now!
> > http://p.sf.net/sfu/devconf
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
> 
> 
>