[consulting] consulting Digest, Vol 46, Issue 11
Paolo Teodorani
teodorani at gmail.com
Wed Nov 18 17:46:45 UTC 2009
I'm currently diving into using Pentaho to achieve what you are looking for.
Might look an overkill but after a bit of learning turns out to be a great
solution.
On Wed, Nov 18, 2009 at 6:06 PM, <consulting-request at drupal.org> wrote:
> Send consulting mailing list submissions to
> consulting at drupal.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.drupal.org/mailman/listinfo/consulting
> or, via email, send a message with subject or body 'help' to
> consulting-request at drupal.org
>
> You can reach the person managing the list at
> consulting-owner at drupal.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of consulting digest..."
>
>
> Today's Topics:
>
> 1. a clients needs good reporting software to use with Drupal --
> any suggestions? (Sam Cohen)
> 2. Re: a clients needs good reporting software to use with
> Drupal -- any suggestions? (Vivek Khurana)
> 3. Re: a clients needs good reporting software to use with
> Drupal -- any suggestions? (Adam Gregory)
> 4. Re: a clients needs good reporting software to use with
> Drupal -- any suggestions? (Mark Schoonover)
> 5. Re: a clients needs good reporting software to use with
> Drupal -- any suggestions? (Sam Cohen)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 18 Nov 2009 10:55:21 -0500
> From: Sam Cohen <sam at samcohen.com>
> Subject: [consulting] a clients needs good reporting software to use
> with Drupal -- any suggestions?
> To: "A list for Drupal consultants and Drupal service/hosting
> providers" <consulting at drupal.org>
> Message-ID:
> <a0b404fa0911180755w5015ca2bp1f133da719b818a3 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi all,
>
> I have a nonprofit client -- with limited budget -- that has a need to
> collect a lot of data on their constituents around the country.
>
> Drupal is perfect for collecting this data, but here's the catch. They
> need
> the ability to generate reports based on this data, such as graphic
> representations, things Views doesn't do.
>
> I told them they'd be able to export a spreadsheet and then run reports,
> but
> they want the ability to run reports and crunch numbers right form the
> site.
>
>
> Have any of you run into this or have any suggestions? I'm wondering if
> there might be some third party options that I may be able to integrate.
> Or
> perhaps some sort of software that I can install on the server that can
> read
> right from the database (of course, I'd have to teach it CCK logic)
>
> Or if there's a non-drupal solution that anyone knows of, that would be
> helpful too.
>
> Thanks,
> Sam
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.drupal.org/pipermail/consulting/attachments/20091118/aad01ade/attachment-0001.html
>
> ------------------------------
>
> Message: 2
> Date: Wed, 18 Nov 2009 22:09:17 +0530
> From: Vivek Khurana <hiddenharmony at gmail.com>
> Subject: Re: [consulting] a clients needs good reporting software to
> use with Drupal -- any suggestions?
> To: "A list for Drupal consultants and Drupal service/hosting
> providers" <consulting at drupal.org>
> Message-ID:
> <91bea30d0911180839x19d16449uda068d41e282be5d at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On Wed, Nov 18, 2009 at 9:25 PM, Sam Cohen <sam at samcohen.com> wrote:
> >
> > Hi all,
> >
> > Or if there's a non-drupal solution that anyone knows of, that would be
> > helpful too.
>
>
> I recently built a reporting solution for the client using drupal and
> jasper. We had clearly defined reports so we used iReports to design
> the reports and generate a jrxml file. This jrxml file is used to
> generate the reports every weekend via a cron job. I used ant based
> scripts to run Jasper server and generate the reports in pdf.
>
> regards
> Vivek
>
> --
> The hidden harmony is better than the obvious!!
>
>
> ------------------------------
>
> Message: 3
> Date: Wed, 18 Nov 2009 11:43:50 -0500
> From: Adam Gregory <arcaneadam at gmail.com>
> Subject: Re: [consulting] a clients needs good reporting software to
> use with Drupal -- any suggestions?
> To: "A list for Drupal consultants and Drupal service/hosting
> providers" <consulting at drupal.org>
> Message-ID:
> <1855f6860911180843k377ac0a8ucef73422a2bf3791 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> CiviCRM. Period. It is hefty and has a slight learning curve, but it is
> simply a top notch CRM designed with Non-profits in mind.
> Http://civicrm.org
>
> -----
> Adam A. Gregory
> Blog: AdamAGregory.com
> Twitter: twitter.com/adamgregory
> Skype: aagregory2
> Cell: 706.761.7375
>
>
> On Wed, Nov 18, 2009 at 10:55 AM, Sam Cohen <sam at samcohen.com> wrote:
>
> >
> > Hi all,
> >
> > I have a nonprofit client -- with limited budget -- that has a need to
> > collect a lot of data on their constituents around the country.
> >
> > Drupal is perfect for collecting this data, but here's the catch. They
> > need the ability to generate reports based on this data, such as graphic
> > representations, things Views doesn't do.
> >
> > I told them they'd be able to export a spreadsheet and then run reports,
> > but they want the ability to run reports and crunch numbers right form
> the
> > site.
> >
> > Have any of you run into this or have any suggestions? I'm wondering if
> > there might be some third party options that I may be able to integrate.
> Or
> > perhaps some sort of software that I can install on the server that can
> read
> > right from the database (of course, I'd have to teach it CCK logic)
> >
> > Or if there's a non-drupal solution that anyone knows of, that would be
> > helpful too.
> >
> > Thanks,
> > Sam
> >
> >
> > _______________________________________________
> > consulting mailing list
> > consulting at drupal.org
> > http://lists.drupal.org/mailman/listinfo/consulting
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.drupal.org/pipermail/consulting/attachments/20091118/73888471/attachment-0001.html
>
> ------------------------------
>
> Message: 4
> Date: Wed, 18 Nov 2009 08:45:06 -0800
> From: "Mark Schoonover" <mark at thetajoin.com>
> Subject: Re: [consulting] a clients needs good reporting software to
> use with Drupal -- any suggestions?
> To: "A list for Drupal consultants and Drupal service/hosting
> providers" <consulting at drupal.org>, "A list for Drupal
> consultants and
> Drupal service/hosting providers" <consulting at drupal.org>
> Message-ID: <1258562706.20706.1345876341 at webmail.messagingengine.com>
> Content-Type: text/plain; charset="us-ascii"
>
> Sam,
>
> There are a couple of approaches to this project. Both Postgres &
> MySQL support ODBC drivers for Windows access to Drupal
> databases. I'm guessing that your client is using/wants to use
> Excel for their reports. Excel can connect to the Drupal database
> via the ODBC driver.
>
> Another approach for pure reporting would be to use somthing like
> Business Objects over ODBC to create the needed reports.
>
> Using Java, there's BIRT through Eclipse too.
>
> Hope this helps.
> Regards,
> Mark Schoonover
>
> --
> http://www.thetajoin.com - The Drupal Hosting & Performance Company
> Email: mark at thetajoin.com :: Voice: 619-928-4473 :: Fax: 619-374-3130
>
>
>
> On Wed, 18 Nov 2009 10:55 -0500, "Sam Cohen" <sam at samcohen.com>
> wrote:
>
> Hi all,
> I have a nonprofit client -- with limited budget -- that has a
> need to collect a lot of data on their constituents around the
> country.
> Drupal is perfect for collecting this data, but here's the
> catch. They need the ability to generate reports based on
> this data, such as graphic representations, things Views
> doesn't do.
> I told them they'd be able to export a spreadsheet and then
> run reports, but they want the ability to run reports and
> crunch numbers right form the site.
> Have any of you run into this or have any suggestions? I'm
> wondering if there might be some third party options that I
> may be able to integrate. Or perhaps some sort of software
> that I can install on the server that can read right from the
> database (of course, I'd have to teach it CCK logic)
> Or if there's a non-drupal solution that anyone knows of, that
> would be helpful too.
> Thanks,
> Sam
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.drupal.org/pipermail/consulting/attachments/20091118/12390bce/attachment-0001.html
>
> ------------------------------
>
> Message: 5
> Date: Wed, 18 Nov 2009 12:05:52 -0500
> From: Sam Cohen <sam at samcohen.com>
> Subject: Re: [consulting] a clients needs good reporting software to
> use with Drupal -- any suggestions?
> To: "A list for Drupal consultants and Drupal service/hosting
> providers" <consulting at drupal.org>
> Message-ID:
> <a0b404fa0911180905i1cce0897r9cdf28989becbbb0 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Having used CiviCRM fairly extensively, I was going to reply that they have
> minimal reporting capability, but I decided to check out their site first
> and to my surprise there's now CiviReport http://civicrm.org/civireport ,
> which I assume is part of the new 3.0 release. (or somehow I missed it in
> 2.0)
>
> That may be exactly what I'm looking for. CiviCRM really is a pretty
> amazing project. My only problem with it, as a consultant, is the enormous
> learning curve there is for clients and the amount of training I need to
> build in.
>
> Sam
>
> On Wed, Nov 18, 2009 at 11:43 AM, Adam Gregory <arcaneadam at gmail.com>
> wrote:
>
> > CiviCRM. Period. It is hefty and has a slight learning curve, but it is
> > simply a top notch CRM designed with Non-profits in mind.
> > Http://civicrm.org
> >
> > -----
> > Adam A. Gregory
> > Blog: AdamAGregory.com
> > Twitter: twitter.com/adamgregory
> > Skype: aagregory2
> > Cell: 706.761.7375
> >
> >
> > On Wed, Nov 18, 2009 at 10:55 AM, Sam Cohen <sam at samcohen.com> wrote:
> >
> >>
> >> Hi all,
> >>
> >> I have a nonprofit client -- with limited budget -- that has a need to
> >> collect a lot of data on their constituents around the country.
> >>
> >> Drupal is perfect for collecting this data, but here's the catch. They
> >> need the ability to generate reports based on this data, such as graphic
> >> representations, things Views doesn't do.
> >>
> >> I told them they'd be able to export a spreadsheet and then run reports,
> >> but they want the ability to run reports and crunch numbers right form
> the
> >> site.
> >>
> >> Have any of you run into this or have any suggestions? I'm wondering if
> >> there might be some third party options that I may be able to integrate.
> Or
> >> perhaps some sort of software that I can install on the server that can
> read
> >> right from the database (of course, I'd have to teach it CCK logic)
> >>
> >> Or if there's a non-drupal solution that anyone knows of, that would be
> >> helpful too.
> >>
> >> Thanks,
> >> Sam
> >>
> >>
> >> _______________________________________________
> >> consulting mailing list
> >> consulting at drupal.org
> >> http://lists.drupal.org/mailman/listinfo/consulting
> >>
> >>
> >
> > _______________________________________________
> > consulting mailing list
> > consulting at drupal.org
> > http://lists.drupal.org/mailman/listinfo/consulting
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.drupal.org/pipermail/consulting/attachments/20091118/05c4ebda/attachment.html
>
> ------------------------------
>
> _______________________________________________
> consulting mailing list
> consulting at drupal.org
> http://lists.drupal.org/mailman/listinfo/consulting
>
>
> End of consulting Digest, Vol 46, Issue 11
> ******************************************
>
--
Paolo Teodorani
Twin snc di Teodorani Paolo & C.
via Dante di Nanni, 29
47822 Santarcangelo di R. (RN)
Tel. +39 3358089645
email.: teodorani at gmail.com - info at twinlogix.com
http://www.twinlogix.com (finally a good looking website !)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/consulting/attachments/20091118/f5bb3333/attachment-0001.html
More information about the consulting
mailing list