[
http://mifosforge.jira.com/browse/MIFOSBI-313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukasz Chudy updated MIFOSBI-313:
---------------------------------
Status: Ready for Showcase (was: Ready for Testing / Resolved)
Verified on 13.07.2011
ETL runs correctly after Loan Officer was moved from one branch to another.
> ETL not picking up Loan Officer leaving one branch and joining another
> ----------------------------------------------------------------------
>
> Key: MIFOSBI-313
> URL: http://mifosforge.jira.com/browse/MIFOSBI-313
> Project: mifos business intelligence
> Issue Type: Bug
> Affects Versions: Mifos BI 1.2
> Reporter: johnwoodlock
> Assignee: johnwoodlock
> Priority: Major
> Fix For: Mifos BI 1.3
>
>
> Mifos no longer creates personnel_movement entries. Don't know when this
> started. Guess is 2.1.x
> The personnel_movement table was used by ETL to pick up loan officers going
> to new branches. ETL fell over for Digamber prod because some loan officers
> had moved branch. The ETL thought this new branch was the 'first' branch and
> fell over because of date created problem. Even if it didn't fall over it
> wouldn't have recorded the loan officer branch movements correctly and LO
> reports would likely be wrong.
> Probably not worth fixing mifos. The same info is recorded on the mifos
> audit table 'change_log/change_log_detail' but that has the problem of
> recording changes by the branch name rather than the branch id so problems
> can occur when branch name is edited.
> So, think this will need an ETL upgrade for full fix. Can get ETL to run
> through with a data fix to allow non LO reports to be viewed.
> So, data fix requiredd? and/or full fix required (Binny/Kay).
> If full fix done think I'd put some better 'lookup logic in' to reduce chance
> of problems and clear message about where problem is before running the main
> ETL code.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on "Lean Startup
Secrets Revealed." This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
