Dale,

I applied the sql script (attached) to your data and the ETL ran and I
could see data for all the reports (however, sometimes I had to use a
future date to pick up data e.g. center schedule by loan officer).

At a command prompt you type

mysql -uUSERNAME -pPASSWORD  mifos < dalefix.sql

or you can copy the lines from the attached file and run it in any sql
GUI you have.

The problem was the use of single quotes in some of the office names
(i.e. its a bug).  However, if you can live without single quotes in
the office name the attached sql fix is all you need to do (it
translates single quotes for `)



As I said previously, I use Mifos BI 1.3.1 and I think you should (and
probably have to) too.

You can get the latest Mifos BI release here (1.3.1):
Mifos BI 
https://ci.mifos.org/hudson/job/bi-1.3.x-archive/lastSuccessfulBuild/artifact/mifos_bi-1.3.1.zip

There's not a single install for mifos BI 1.3.1 but since you have
already installed Mifos BI 1.2 you can upgrade just by unzipping the
downloaded zip and following these instructions.

1/ In your biserver-ce\pentaho-solutions    delete directories
commonActions, Dashboards, DashboardsMenu, dataAccess, standardReports

2/ from unzipped directory mifos_bi-1.3.1\reports    copy directories
commonActions, Dashboards, DashboardsMenu, dataAccess, standardReports
into you biserver-ce\pentaho-solutions

3/ from unzipped directory mifos_bi-1.3.1\reports\CDFReportingTemplate
   copy *.html into your
biserver-ce\pentaho-solutions\system\pentaho-cdf

4/ from unzipped directory mifos_bi-1.3.1\reports\CDFReportingTemplate
   copy *.jpg into your
biserver-ce\pentaho-solutions\system\pentaho-cdf\resources\style\images

5/ in your biserver-ce\tomcat\webapps\pentaho\WEB-INF\classes
delete directory org

6/ from unzipped directory mifos_bi-1.3.1\reports\i18n    copy
directory org into your
biserver-ce\tomcat\webapps\pentaho\WEB-INF\classes

7/ in pentaho server, do a Tools/Refresh/Repository Cache before
testing any reports


It's a hassle copying and deleting files but hopefully you'll be fine.
 If not, or if there are still issues with your reporting, let me know
and I'll send you back my skype details or some other way that I can
share the screen with you.


John

On Mon, Jul 23, 2012 at 3:21 PM, Dale Fuertes <[email protected]> wrote:
> 23 July 2012
>
>
> Hi John,
>
> Here is the backup file (zip) and log file. Earlier was not zipped, just
> knew of the 750kb limit.
>
> Thanks so much.
>
>
>
> Regards,
>
> Dale A. Fuertes-Pham
> Email:    [email protected]
>
>
>

Attachment: dalefix.sql
Description: Binary data

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users

Reply via email to