rlib-users — RLIB Users Mailing List

Re: [Rlib-users] Couldn't compile rlib

[Bob D. <bd...@si...>]

Hi Graham,

I'm currently working on auto* support in rlib.. expected this weekend..
but in order to get it working for you in the short term....

hym...
what does locate xmlmemory.h and locate php.4 return??

I would suggest changing the include path in the RLIB make file to
include those paths..

rlib does require libxml2 to be installed... I don't know if we mention
that anywhere in the site.....

- Bob

On Thu, 2003-09-25 at 11:53, Graham Waller wrote:
> Hi
> 
> I just tried compiling rlib on a SunCobalt Raq4 but it failed with a number
> of file not found messages (eg. php.h, xmlmemory.h etc).  I am guessing that
> this is a path issue: should I be compiling rlib in any particular place?
> The files that it cannot found are in /usr/local/include/php and
> /usr/local/include/libxml2 respectively.
> 
> If these questions are rather basic, please excuse my ignorance as I am not
> a linux guru, just someone who hacks about with it until it does what I
> need, usually :).
> 
> Regards
> Graham
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
> 

[Rlib-users] Couldn't compile rlib

[Graham W. <ma...@bl...>]

Hi

I just tried compiling rlib on a SunCobalt Raq4 but it failed with a number
of file not found messages (eg. php.h, xmlmemory.h etc).  I am guessing that
this is a path issue: should I be compiling rlib in any particular place?
The files that it cannot found are in /usr/local/include/php and
/usr/local/include/libxml2 respectively.

If these questions are rather basic, please excuse my ignorance as I am not
a linux guru, just someone who hacks about with it until it does what I
need, usually :).

Regards
Graham

Re: [Rlib-users] differing page layouts

[Bob D. <bd...@si...>]

CVS HEAD has support for multiple reports

I'm currenrly working on auto* support plus a spec file..
Also.. I'm working on some code refactoring...

but.. At some point next week I'll make the next official release..

Hopefully this will work for you.. if it does maybe you would like to
put together an example for the documentation?.. Maybe for the web
site..

btw.. this is how you do it


$rlib =	rlib_init($sql_host, $sql_users, $sql_password, $sql_database);
rlib_add_query_as($rlib, "select * from example", "example");
rlib_add_query_as($rlib, "select * from example order by name",
"example2");

rlib_add_query_as($rlib, "select * from example", "example3");
rlib_add_report($rlib, "report.xml");
rlib_add_report($rlib, "report.xml", "example2");
rlib_add_report($rlib, "report2.xml", "example3");
rlib_set_output_format($rlib, $format);
rlib_execute($rlib);
rlib_finalize($rlib);
header(	rlib_get_content_type($rlib));
rlib_spool($rlib);

NOTE:: rlib_add_report can now take an optional 3rd paramater to say
what data source to use for the main loop

Cheers,

- Bob



On Sat, 2003-09-13 at 22:07, A Vision wrote:
> Of course!  I haven't learned how to work it yet, so I am slightly behind!
> 
> 
> >From: Bob Doan <bd...@si...>
> >To: A Vision <av...@ho...>
> >CC: rli...@li...
> >Subject: Re: [Rlib-users] differing page layouts
> >Date: Sat, 13 Sep 2003 21:57:04 -0400
> >
> >Hi,
> >
> >RLIB is very close to being able to do this.  In fact, it should be able
> >to do this in a weeks time or so.. I'm working on it now (along with a
> >few other things)
> >
> >In your case you would have 2/3 XML definition files one cover, one main
> >report, and then possible one more for the legal.
> >
> >Take for example the example provided in the manual
> >
> >$rlib = rlib_init($sql_host, $sql_users, $sql_password, $sql_database);
> >rlib_add_query_as($rlib, "select * from example", "example");
> >rlib_add_report($rlib, "report.xml");
> >rlib_set_output_format($rlib, $format);
> >rlib_execute($rlib);
> >rlib_finalize($rlib);
> >header( rlib_get_content_type($rlib));
> >rlib_spool($rlib);
> >
> >We would change it up just a bit
> >
> >$rlib = rlib_init($sql_host, $sql_users, $sql_password, $sql_database);
> >rlib_add_query_as($rlib, "select * from example", "example");
> >rlib_add_report($rlib, "cover_page.xml");
> >rlib_add_report($rlib, "main_report.xml");
> >rlib_add_report($rlib, "legal_stuff.xml");
> >rlib_set_output_format($rlib, $format);
> >rlib_execute($rlib);
> >rlib_finalize($rlib);
> >header( rlib_get_content_type($rlib));
> >rlib_spool($rlib);
> >
> >There are a few problems with this however for more complicated
> >stuff.... Like the ability to set rlib internal variable (pageno, line
> >count, detail line count.. ect.. back to one)
> >
> >The other problem is we need to ability to have different main loop
> >queries for the different reports..
> >
> >Anyway... would you be up for trying a beta of this when its ready?
> >
> >- Bob
> >
> >
> >On Sat, 2003-09-13 at 10:42, A Vision wrote:
> > > This a "can rlib do this"
> > >
> > > I have a report that needs to be deployable in a single PDF.  When 
> >printed
> > > page 1 must be a cover letter, the rest of the pages must be landscape.
> > > Then one additional page must be appended as a letter with microscopic
> > > legalese.
> > >
> > > Yuck.
> > >
> > > If this is doable, where can I scrounge up an example of multiple page
> > > layouts?
> > >
> > > _________________________________________________________________
> > > Need more e-mail storage? Get 10MB with Hotmail Extra Storage.
> > > http://join.msn.com/?PAGE=features/es
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This sf.net email is sponsored by:ThinkGeek
> > > Welcome to geek heaven.
> > > http://thinkgeek.com/sf
> > > _______________________________________________
> > > Rlib-users mailing list
> > > Rli...@li...
> > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > >
> >
> 
> _________________________________________________________________
> Fast, faster, fastest: Upgrade to Cable or DSL today!   
> https://broadband.msn.com
> 
> 

[Rlib-users] Re: rlib

[Bob D. <bd...@si...>]

Hym...

I think its cause of the mysql_init problem I told you about on rlib-devel

CVS HEAD has the correct MYSQL stuff.. 

- Bob

On Mon, 2003-09-15 at 10:25, Justin Hammond wrote:
> I did a bit more debuging with the sample script you provided in the doco:
> <?
> dl ("libr.so");
> $query = "SELECT * FROM members";
> $rlib = rlib_init("localhost", "root", "xxxx", "secure");
> $format = "PDF";
> rlib_add_query_as($rlib, $query, "topline");
> rlib_add_query_as($rlib, "select name from def", "header");
> rlib_add_report($rlib, "report_plu.xml");
> rlib_set_output_format($rlib, $format);
> rlib_execute($rlib);
> rlib_finalize($rlib);
> header(rlib_get_content_type($rlib));
> rlib_spool($rlib);
> ?>
> 
> 
> and put some debuging statements around the sql connect statements:
> Tring  - PDF - header - topline
> Couldn't connect to MySql: Access denied for user: 'PDF@localhost' (Using
> password: YES)
> Could not connect to MYSQL
> 
> Fatal error: Could not load engine.. check logs in /root/rlib.php on line 10
> 
> 
> something funky is going on... I dont know php that well to be able to
> figure it out any further, can you give me any tips?
> 
> Justin Hammond wrote:
> > hey,
> > I wanted to give your rlib a whirl, but alas, couldn't get it working.
> > firstly, it wouldn't link correctly. I use mysql 4.1 and u have to use
> > mysql_real_connect instead of mysql_connect
> > second, you should specify that you need to have the shared version of
> > cpdflib installed, the static version wont link with rlib either.
> >
> > finally, its still not working. I think its partly due to the
> > hardcoded usernames/db etc etc etc
> >
> > attached is a small patch that I tried to use to get it working.
> >
> > any hints I can use to try and get it running?
> 
> 

Re: [Rlib-users] differing page layouts

[Bob D. <bd...@si...>]

Hi,

RLIB is very close to being able to do this.  In fact, it should be able
to do this in a weeks time or so.. I'm working on it now (along with a
few other things)

In your case you would have 2/3 XML definition files one cover, one main
report, and then possible one more for the legal.

Take for example the example provided in the manual

$rlib = rlib_init($sql_host, $sql_users, $sql_password, $sql_database);
rlib_add_query_as($rlib, "select * from example", "example");
rlib_add_report($rlib, "report.xml"); 
rlib_set_output_format($rlib, $format); 
rlib_execute($rlib); 
rlib_finalize($rlib); 
header( rlib_get_content_type($rlib)); 
rlib_spool($rlib);

We would change it up just a bit

$rlib = rlib_init($sql_host, $sql_users, $sql_password, $sql_database);
rlib_add_query_as($rlib, "select * from example", "example");
rlib_add_report($rlib, "cover_page.xml"); 
rlib_add_report($rlib, "main_report.xml"); 
rlib_add_report($rlib, "legal_stuff.xml"); 
rlib_set_output_format($rlib, $format); 
rlib_execute($rlib); 
rlib_finalize($rlib); 
header( rlib_get_content_type($rlib)); 
rlib_spool($rlib);

There are a few problems with this however for more complicated
stuff.... Like the ability to set rlib internal variable (pageno, line
count, detail line count.. ect.. back to one)

The other problem is we need to ability to have different main loop
queries for the different reports..

Anyway... would you be up for trying a beta of this when its ready?

- Bob


On Sat, 2003-09-13 at 10:42, A Vision wrote:
> This a "can rlib do this"
> 
> I have a report that needs to be deployable in a single PDF.  When printed 
> page 1 must be a cover letter, the rest of the pages must be landscape.  
> Then one additional page must be appended as a letter with microscopic 
> legalese.
> 
> Yuck.
> 
> If this is doable, where can I scrounge up an example of multiple page 
> layouts?
> 
> _________________________________________________________________
> Need more e-mail storage? Get 10MB with Hotmail Extra Storage.   
> http://join.msn.com/?PAGE=features/es
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
> 

[Rlib-users] differing page layouts

[A V. <av...@ho...>]

This a "can rlib do this"

I have a report that needs to be deployable in a single PDF.  When printed 
page 1 must be a cover letter, the rest of the pages must be landscape.  
Then one additional page must be appended as a letter with microscopic 
legalese.

Yuck.

If this is doable, where can I scrounge up an example of multiple page 
layouts?

_________________________________________________________________
Need more e-mail storage? Get 10MB with Hotmail Extra Storage.   
http://join.msn.com/?PAGE=features/es