Hi Srini,

Below query will do the job for you

1> Assumption, repayment frequency and center meeting frequency are same
2> Calender is always attached at center level.
3> All the loan with such issue belongs to the clients under group,
group under center

Caution!!, please test the query before running on production data.

INSERT INTO m_calendar_instance (entity_id, calendar_id , entity_type_enum)
SELECT ln.id AS entity_id,
       ci.calendar_id AS calendar_id,
       3 AS entity_type_enum
FROM m_loan ln
INNER JOIN m_group gp ON gp.id = ln.group_id
INNER JOIN m_group center ON center.id = gp.parent_id
INNER JOIN m_calendar_instance ci ON ci.entity_id = center.id
AND ci.entity_type_enum = 4
LEFT JOIN m_calendar_instance ciforloan ON ciforloan.entity_id = ln.id
AND ciforloan.entity_type_enum = 3
WHERE ln.group_id IS NOT NULL
  AND ln.loan_type_enum = 3
  AND ciforloan.entity_id IS NULL


Thanks
Nayan Ambali


Thanks and Regards,
Nayan Ambali
+91 9591996042
skype: nayangambali


On Wed, Nov 5, 2014 at 4:07 PM, srinivasa Rao Yedida
<[email protected]> wrote:
> Dear All
>
> Can I get any support for regarding this issue
>
> Thanks
> Srinivasarao Yedida
>
> On Fri, Oct 31, 2014 at 5:36 PM, srinivasa Rao Yedida <[email protected]>
> wrote:
>>
>> Hi
>>
>> I uploaded many JLG loans through data Import tool and all the loans
>> disbursed to clients, I was given all the loans "without Sync repayments
>> with meeting details"
>>
>> Issues:
>>
>> now when I change center meeting Sch from present schedule date to
>> expecting schedule date, loan repayment schedule not responding
>>
>> Can please help me any one "how to sync all existed the loans"  (loan
>> status is disbursed)
>>
>>
>> Thanks
>>
>> Srinviasa Rao yedida
>
>
>
> ------------------------------------------------------------------------------
>
> Mifos-developer mailing list
> [email protected]
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer

------------------------------------------------------------------------------
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users

Reply via email to