> AS a bit of background, I doubt its an issue with migrated data since Light¹s > data was migrated manually. > > Ryan > > > On 1/10/11 3:14 AM, "Ramya Toshniwal" <ramya.toshni...@sungard.com> wrote: > >> Trilok, >> >> I got itThis problem I encountered with one of my client also where business >> activities are coming instead of loan purpose. The reason is I guess due to >> incorrect mapping done at the time of migration of data first time. That¹s >> why for loans created through screen, you will always find correct loan >> purpose but for migrated ones the incorrect values. >> >> Please check the case of migrated loans. >> >> Thanks, >> Ramya >> >> >> From: Trilok J. Pandya [mailto:trilok.pan...@lightmicrofinance.com] >> Sent: Monday, January 10, 2011 4:33 PM >> To: Toshniwal, Ramya >> Cc: mifos-develo...@lists.sourceforge.net; >> mifos-iss...@lists.sourceforge.net; mifos-users@lists.sourceforge.net >> Subject: Re: [Mifos-users] Where Is Loan Purpose Stored ? >> >> Ramya, >> >> i get the following but this is not correct. this all are business activity. >> again i want only purpose of loans. as i attach the file. >> >> >> NULL >> 'Buffalo' >> 'GeneralStore' >> 'VehicleInstallment' >> 'Panparlour' >> 'VegetableBusiness' >> 'Goat' >> 'SewingMachine' >> 'Detergentshop' >> 'ClothBusiness' >> 'Vegetable&ScrapMetal' >> 'Vegetable&GeneralStore' >> 'BanglesStore' >> 'ScrapMetal' >> 'Pottery&ClothBusiness' >> 'Agriculture' >> 'GeneralStore&Buffalo' >> >> >> >> >> >> On 10-01-2011 14:51, ramya.toshni...@sungard.com wrote: >> Trilok, >> >> Can you please send me the output of following query. Then only I can help >> you solving your problem. >> >> select distinct >> substring_index(substr(lookup_value.lookup_name,instr(lookup_value.lookup_nam >> e,'.') >> +1),'.',1) as loan_purposes >> from loan_account >> left join lookup_value on >> loan_account.business_activities_id=lookup_value.lookup_id >> >> >> Thanks, >> Ramya >> >> >> >> >> On 07-01-2011 17:10, ramya.toshni...@sungard.com wrote: >> Hi Trilok, >> >> Loan purpose is actually the business_activities_id in loan_account table. >> >> So you can find the corresponding purposes in lookup_value table >> >> >> Select loan_account.account_id,lookup_value.lookup_name >> From loan_account >> Left outer join lookup_value on >> loan_account.business_activities_id=lookup_value.lookup_id >> >> >> Thanks, >> Ramya >> >> >> From: Trilok J. Pandya [mailto:trilok.pan...@lightmicrofinance.com] >> Sent: Friday, January 07, 2011 4:56 PM >> To: Mifos Developer Discussions; mifos-users@lists.sourceforge.net; >> mifos-iss...@lists.sourceforge.net >> Subject: [Mifos-users] Where Is Loan Purpose Stored ? >> >> Hello, >> >> In mifos database , in which table doe the loan purpose values stored to >> particular members ? >> >> like select customer.display_name,customer.customer_id, loan_purpose from >> ........................
-- Ryan Whitney Mifos Technical Program Manager rwhit...@grameenfoundation.org Mifos® - Technology that Empowers Microfinance (www.mifos.org) Our mission is to enable the poor, especially the poorest, to create a world without poverty. <http://grameenfoundation.org/take-action/ingenuity-fund-challenge/> P please consider the environment before printing this e-mail.
<<image.jpg>>
------------------------------------------------------------------------------ Gaining the trust of online customers is vital for the success of any company that requires sensitive data to be transmitted over the Web. Learn how to best implement a security strategy that keeps consumers' information secure and instills the confidence they need to proceed with transactions. http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
