Report / Printing manager for the web

View: New views
4 Messages — Rating Filter:   Alert me  
< Prev | 1 - 2 | Next >

Re: Report / Printing manager for the web

by Michael Check :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I started looking at Jasper reports but got frustrated that I was
searching through the site and couldn't find samples and examples.  I
downloaded the system but couldn't figure out if there was a web
component for displaying the reports as html then exporting as PDF and
CSV...

Do you know if it will display reports to the screen, suitable for
printing or exporting?

How would the 4D -> Mysql -> JDBC -> Jasper work for web reports with
A4D?  If I request the data in A4D, it would push the information to
mysql in temp tables then pull them via jdbc into jasper?  Then
displayed In html on screen?

I found DBxtra which I thought has a nice on screen reporting
interface and a good developer report creator...

http://www.dbxtra.com/index.htm

Has anyone tried unfuddle?  It is a nice 2.0 front end trac, basically
with muiltiple project support.  They have a really slick report
generator for the tickets where you can create and save reports using
a js interface.  Redmine also has a nice searching and presentation
interface that would be interested as a reporting mechanism.

This particular application uses ExtJS almost exclusively.  So we
would really like something that integrates with Ext and presents a
javascript interface like unfuddle and redmine.

As a sidenote, we use unufddle here for a couple of our projects and
it works well with the integrated wiki and messaging system.  The
ticketing system is nice too, but it needs custom fields.  It has
built in svn and git!  It is really a developer tool though, we have
clients that try to use the ticketing portion and it is too confusing
for them.

Michael Check

On Wed, May 13, 2009 at 9:00 PM, Mehboob Alam <media4d@...> wrote:

>
> Try this combination:
>
> 4D -> MySQL
> MySQL -> JDBC
> JDBC -> Jasper Reports
>
> MySQL:
> http://www.pluggers.nl/myconnect_plugin.html
>
> Jasper:
> http://www.jaspersoft.com/JasperSoft_JasperReports.html
>
> Unfortunately, 4Dv11 does not support JDBC, and the future there is uncertain. Hence my 4D -> MySQL suggestion.
>
> sincerely,
> mehboob alam


--
Thanks,

Michael Check
_______________________________________________
Active4D-dev mailing list
Active4D-dev@...
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/

Parent Message unknown Re: Report / Printing manager for the web

by Mehboob Alam :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


I use unfuddle.. trying to figure out how to use it for 4D code..

I havent gone too deep inside JasperReports, but my main goals are PDF reports, and I like the XML report definition aspects of this.

sincerely,
mehboob alam


Electricity is actually made up of extremely tiny particles called electrons, that you cannot see with the naked eye unless you have been drinking. - Dave Barry


--- On Thu, 5/14/09, Michael Check <michaelr.check@...> wrote:

> From: Michael Check <michaelr.check@...>
> Subject: Re: [Active4d-dev] Report / Printing manager for the web
> To: active4d-dev@...
> Date: Thursday, May 14, 2009, 11:16 AM
> I started looking at Jasper reports
> but got frustrated that I was
> searching through the site and couldn't find samples and
> examples.  I
> downloaded the system but couldn't figure out if there was
> a web
> component for displaying the reports as html then exporting
> as PDF and
> CSV...
>
> Do you know if it will display reports to the screen,
> suitable for
> printing or exporting?
>
> How would the 4D -> Mysql -> JDBC -> Jasper work
> for web reports with
> A4D?  If I request the data in A4D, it would push the
> information to
> mysql in temp tables then pull them via jdbc into
> jasper?  Then
> displayed In html on screen?
>
> I found DBxtra which I thought has a nice on screen
> reporting
> interface and a good developer report creator...
>
> http://www.dbxtra.com/index.htm
>
> Has anyone tried unfuddle?  It is a nice 2.0 front end
> trac, basically
> with muiltiple project support.  They have a really
> slick report
> generator for the tickets where you can create and save
> reports using
> a js interface.  Redmine also has a nice searching and
> presentation
> interface that would be interested as a reporting
> mechanism.
>
> This particular application uses ExtJS almost
> exclusively.  So we
> would really like something that integrates with Ext and
> presents a
> javascript interface like unfuddle and redmine.
>
> As a sidenote, we use unufddle here for a couple of our
> projects and
> it works well with the integrated wiki and messaging
> system.  The
> ticketing system is nice too, but it needs custom
> fields.  It has
> built in svn and git!  It is really a developer tool
> though, we have
> clients that try to use the ticketing portion and it is too
> confusing
> for them.
>
> Michael Check
>
> On Wed, May 13, 2009 at 9:00 PM, Mehboob Alam <media4d@...>
> wrote:
> >
> > Try this combination:
> >
> > 4D -> MySQL
> > MySQL -> JDBC
> > JDBC -> Jasper Reports
> >
> > MySQL:
> > http://www.pluggers.nl/myconnect_plugin.html
> >
> > Jasper:
> > http://www.jaspersoft.com/JasperSoft_JasperReports.html
> >
> > Unfortunately, 4Dv11 does not support JDBC, and the
> future there is uncertain. Hence my 4D -> MySQL
> suggestion.
> >
> > sincerely,
> > mehboob alam
>
>
> --
> Thanks,
>
> Michael Check
> _______________________________________________
> Active4D-dev mailing list
> Active4D-dev@...
> http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
> Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
>


     
_______________________________________________
Active4D-dev mailing list
Active4D-dev@...
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/

Re: Report / Printing manager for the web

by Michael Check :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I read on the nug list that there were some macros that v11 allowed
one to script directly to the command line on save and with certain
actions, giving you the ability to write a script wrapper to the svn
command line.  I think I read someone was doing that, or trying it.
Obviously only for methods since the rest of the application design
environment is still, IMO, in the dark ages and can't interface with
modern configuration management tools.

svn and git work great with a4d, of course.  Just use the unfuddle server repos.

We're still using our own svn server running locally on a server here
for the paranoid.  We wrote a couple of scripts that post-commit issue
fixes and commits to the unfuddle rest API in the project we use.

As far as using svn with 4D, what we do is version the entire
structure (still using 2004) and do as much coding outside of 4D as
possible (with A4D).  When we make structure and method changes in 4D,
we note them and commit the structure.  That will work with unfuddle,
but it requires some diligence in recording what happened when since
certain A4D files won't work with certin revs of the structure.  Maybe
this is a better application for git since it revs the entire project
every time.

Still looking for a report manager that let's us create interactive
reports (field selections, titles, etc.) at runtime that will display
to the browser screen and can be printed, exported and PDF'd.  If
anyone has other suggestions from experience or otherwise, I'd
appreciate hearing it.  This has just got to be a problem that has
been solved over and over again, right?

Michael Check

On Fri, May 15, 2009 at 9:47 AM, Mehboob Alam <media4d@...> wrote:

>
> I use unfuddle.. trying to figure out how to use it for 4D code..
>
> I havent gone too deep inside JasperReports, but my main goals are PDF reports, and I like the XML report definition aspects of this.
>
> sincerely,
> mehboob alam
>
>
> Electricity is actually made up of extremely tiny particles called electrons, that you cannot see with the naked eye unless you have been drinking. - Dave Barry
>
>
> --- On Thu, 5/14/09, Michael Check <michaelr.check@...> wrote:
>
>> From: Michael Check <michaelr.check@...>
>> Subject: Re: [Active4d-dev] Report / Printing manager for the web
>> To: active4d-dev@...
>> Date: Thursday, May 14, 2009, 11:16 AM
>> I started looking at Jasper reports
>> but got frustrated that I was
>> searching through the site and couldn't find samples and
>> examples.  I
>> downloaded the system but couldn't figure out if there was
>> a web
>> component for displaying the reports as html then exporting
>> as PDF and
>> CSV...
>>
>> Do you know if it will display reports to the screen,
>> suitable for
>> printing or exporting?
>>
>> How would the 4D -> Mysql -> JDBC -> Jasper work
>> for web reports with
>> A4D?  If I request the data in A4D, it would push the
>> information to
>> mysql in temp tables then pull them via jdbc into
>> jasper?  Then
>> displayed In html on screen?
>>
>> I found DBxtra which I thought has a nice on screen
>> reporting
>> interface and a good developer report creator...
>>
>> http://www.dbxtra.com/index.htm
>>
>> Has anyone tried unfuddle?  It is a nice 2.0 front end
>> trac, basically
>> with muiltiple project support.  They have a really
>> slick report
>> generator for the tickets where you can create and save
>> reports using
>> a js interface.  Redmine also has a nice searching and
>> presentation
>> interface that would be interested as a reporting
>> mechanism.
>>
>> This particular application uses ExtJS almost
>> exclusively.  So we
>> would really like something that integrates with Ext and
>> presents a
>> javascript interface like unfuddle and redmine.
>>
>> As a sidenote, we use unufddle here for a couple of our
>> projects and
>> it works well with the integrated wiki and messaging
>> system.  The
>> ticketing system is nice too, but it needs custom
>> fields.  It has
>> built in svn and git!  It is really a developer tool
>> though, we have
>> clients that try to use the ticketing portion and it is too
>> confusing
>> for them.
>>
>> Michael Check
>>
>> On Wed, May 13, 2009 at 9:00 PM, Mehboob Alam <media4d@...>
>> wrote:
>> >
>> > Try this combination:
>> >
>> > 4D -> MySQL
>> > MySQL -> JDBC
>> > JDBC -> Jasper Reports
>> >
>> > MySQL:
>> > http://www.pluggers.nl/myconnect_plugin.html
>> >
>> > Jasper:
>> > http://www.jaspersoft.com/JasperSoft_JasperReports.html
>> >
>> > Unfortunately, 4Dv11 does not support JDBC, and the
>> future there is uncertain. Hence my 4D -> MySQL
>> suggestion.
>> >
>> > sincerely,
>> > mehboob alam
>>
>>
>> --
>> Thanks,
>>
>> Michael Check
>> _______________________________________________
>> Active4D-dev mailing list
>> Active4D-dev@...
>> http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
>> Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
>>
>
>
>
> _______________________________________________
> Active4D-dev mailing list
> Active4D-dev@...
> http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
> Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
>



--
Thanks,

Michael Check
_______________________________________________
Active4D-dev mailing list
Active4D-dev@...
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/

Re: Minimising Availability Errors (Apache-4D)

by Peter Jakobsson-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi

I just wanted to update this thread with recent experiences. Also, my  
customer has asked my to look at this for the next 3 days while I'm  
on site to try to solve the issue of Apache returning 503 errors to  
the browser. The problem seems to be Apache receiving socket errors  
instantaneously back from 4D Client Web server. The measured error  
rate is about 0.05 %, however there are occassional reports from  
users that they get 503 errors in the browser and the problem is  
reproducible.

SCENARIO:

Apache fronted 4D Client 2004 + Active 4D. Running on Windows 2003  
Server
4D Server database server


On 13 May 2009, at 10:39, Peter Schumacher wrote:
> wouldn't it help to create more web processes "on stock" and keep  
> them running? Just create 2000 processes and let them run. In the  
> idle state they don't consume anything.
>


We tried using SET DATABASE PARAMETER(Client Minimum Web Process) set  
to 2000, however this didn't appear to improve the number of socket  
errors measurable.

LISTENERS v WEB PROCESSES

I'm not knowledgeable enough about low level TCP comms to understand  
this distinction and thereby know what to try. The "processes"  
created by the SET DATABASE PARAMETER(Client Minimum Web Process) are  
not visible in runtime explorer, whereas the ones creates in reponse  
to an actual request are. Does that mean we are actually setting the  
number of "listeners" by using this command ?

I remember when using ITK in the old day's, you could actually set  
the number of listeners explicitly. It's not clear to me what the  
equivalent is in 4D. We've also been thinking of looking at Rob  
Laveauxs NTK, in particular the bullet point that says..

"... high performance, non blocking sockets"

If anyone can shed light, particularly on the distinction between  
"processes" and "listeners" and socket handling in general, if would  
be welcomed.

Regards

Peter

_______________________________________________
Active4D-dev mailing list
Active4D-dev@...
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
< Prev | 1 - 2 | Next >