You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by "Zayyad A. Said" <za...@intrasofttechnologies.com> on 2018/11/01 07:57:54 UTC
RE: LOAN TRANSACTION IMPORT
Hi,
Still no luck with this, I cant locate LoanRepaymentImport handler.
The closest I could get is fineract-provider/WEB-INF/classes/org/apache/fineract/portfolio/loanaccount/handler/LoanRepaymentCommandHandler.class
I decompiled the same but I can’t see import command.
Will appreciate further guidance to have this resolved.
Thanks & Regards;
*******
Zayyad A. Said | Chairman & C.E.O
Cell No.: +254 716 615274 | Skype: zsaid2011
Email: <ma...@intrasofttechnologies.com> zayyad@intrasofttechnologies.com
Schedule Meetings: <https://calendly.com/zayyadsaid> https://calendly.com/zayyadsaid
Description: Email banner
From: Zayyad A. Said [mailto:zayyad@intrasofttechnologies.com]
Sent: 31 October 2018 01:39 PM
To: dev@fineract.apache.org; vishwas@confluxtechnologies.com
Cc: mifos-developer@lists.sourceforge.net
Subject: RE: LOAN TRANSACTION IMPORT
Hi Vishwas,
Thanks for your response.
Kindly advise where we can locate the LoanRepaymentImportHandler for us to change the type.
Thanks & Regards;
*******
Zayyad A. Said | Chairman & C.E.O
Cell No.: +254 716 615274 | Skype: zsaid2011
Email: <ma...@intrasofttechnologies.com> zayyad@intrasofttechnologies.com
Schedule Meetings: <https://calendly.com/zayyadsaid> https://calendly.com/zayyadsaid
Description: Email banner
-----Original Message-----
From: Vishwas Babu [mailto:vishwas@confluxtechnologies.com]
Sent: 30 October 2018 11:55 PM
To: dev@fineract.apache.org
Cc: mifos-developer@lists.sourceforge.net
Subject: Re: LOAN TRANSACTION IMPORT
Hi Zayyad ,
Changing the expected type of the repayment and loan Ids to long instead of Int in LoanRepaymentImportHandler would resolve the issue you are facing
Regards,
Vishwas
On Tuesday, October 30, 2018, Zayyad A. Said < <ma...@intrasofttechnologies.com> zayyad@intrasofttechnologies.com> wrote:
> Devs,
>
>
>
> Am experiencing a challenge importing loan payments.
>
>
>
> I tried with version 18.03.01, I get this error in catalina log:
>
>
>
> Exception in thread "SimpleAsyncTaskExecutor-258" java.lang.NumberFormatException:
> For input string: "1010000000001"
>
> at java.lang.NumberFormatException.forInputString(
> NumberFormatException.java:65)
>
> at java.lang.Integer.parseInt(Integer.java:583)
>
> at java.lang.Integer.parseInt(Integer.java:615)
>
> at org.apache.fineract.infrastructure.bulkimport.
> importhandler.loanrepayment.(LoanRepaymentImportHandler.java:78)
>
> at org.apache.fineract.infrastructure.bulkimport.
> importhandler.loanrepayment.LoanRepaymentImportHandler.readExcelFile(
> LoanRepaymentImportHandler.java:70)
>
> at org.apache.fineract.infrastructure.bulkimport.
> importhandler.loanrepayment.LoanRepaymentImportHandler.process(
> LoanRepaymentImportHandler.java:60)
>
> at org.apache.fineract.infrastructure.bulkimport.service.
> BulkImportEventListener.onApplicationEvent(BulkImportEventListener.java:
> 144)
>
> at org.apache.fineract.infrastructure.bulkimport.service.
> BulkImportEventListener.onApplicationEvent(BulkImportEventListener.java:
> 48)
>
> at org.springframework.context.event.
> SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticas
> ter.java:93)
>
> at java.lang.Thread.run(Thread.java:745)
>
>
>
> I also tried with version 17.07.01 using the data import tool but I
> noted that once you upload the file the loan account number changes to
> *2147483647* which causes it to fail with an error “*id:Loan with
> identifier 2147483647 does not exist*”.
>
>
>
> Can anyone advise me how we can sort out this issue? We have a huge
> migration exercise that we are carrying out and the client needs all
> transaction history.
>
>
>
> Regards;
>
>
>
> *********
>
> *Zayyad A. Said | Chairman & C.E.O*
>
>
>
> Cell No.: +254 716 615274 | Skype: *zsaid2011*
>
> Email: <ma...@intrasofttechnologies.com> zayyad@intrasofttechnologies.com
>
> Schedule Meetings: <https://calendly.com/zayyadsaid> https://calendly.com/zayyadsaid
>
> [image: Description: Email banner]
>
>
>
--
Sent from my iPad
Re: LOAN TRANSACTION IMPORT
Posted by Santosh Math <sa...@confluxtechnologies.com>.
Hi All,
Created a ticket for this:
https://issues.apache.org/jira/browse/FINERACT-659
Shruthi, is someone working on this?
On Fri, Nov 2, 2018 at 10:57 AM Shruthi M R <sh...@confluxtechnologies.com>
wrote:
> Santosh, kindly create a bug for this in FINERACT, priority will be high
> for this.
>
> Thank You,
>
> *Shruthi M R*
> Senior Software Engineer - Conflux Technologies
> shruthi@confluxtechnologies.com | Skype: Shruthi Rajaram | Mobile:
> +91-8277012716
>
>
> On Thu, Nov 1, 2018 at 4:09 PM Ippez Robert <ip...@gmail.com> wrote:
>
>> Hi Zayyad,
>> You can find that file here "
>>
>> *fineract-provider\src\main\java\org\apache\fineract\infrastructure\bulkimport\importhandler\loanrepayment\LoanRepaymentImportHandler.java*
>> "
>>
>> Hope this helps you.
>> Thanks
>> Regards
>> Ippez Robert
>>
>> On Thu, Nov 1, 2018 at 10:58 AM Zayyad A. Said <
>> zayyad@intrasofttechnologies.com> wrote:
>>
>> > Hi,
>> >
>> >
>> >
>> > Still no luck with this, I cant locate LoanRepaymentImport handler.
>> >
>> >
>> >
>> > The closest I could get is
>> >
>> *fineract-provider/WEB-INF/classes/org/apache/fineract/portfolio/loanaccount/handler/LoanRepaymentCommandHandler.*
>> > class
>> >
>> >
>> >
>> > I decompiled the same but I can’t see import command.
>> >
>> >
>> >
>> > Will appreciate further guidance to have this resolved.
>> >
>> >
>> >
>> > Thanks & Regards;
>> >
>> >
>> >
>> > *********
>> >
>> > *Zayyad A. Said | Chairman & C.E.O*
>> >
>> >
>> >
>> > Cell No.: +254 716 615274 | Skype: *zsaid2011*
>> >
>> > Email: zayyad@intrasofttechnologies.com
>> >
>> > Schedule Meetings: https://calendly.com/zayyadsaid
>> >
>> > [image: Description: Email banner]
>> >
>> >
>> >
>> > *From:* Zayyad A. Said [mailto:zayyad@intrasofttechnologies.com]
>> > *Sent:* 31 October 2018 01:39 PM
>> > *To:* dev@fineract.apache.org; vishwas@confluxtechnologies.com
>> > *Cc:* mifos-developer@lists.sourceforge.net
>> > *Subject:* RE: LOAN TRANSACTION IMPORT
>> >
>> >
>> >
>> > Hi Vishwas,
>> >
>> >
>> >
>> > Thanks for your response.
>> >
>> >
>> >
>> > Kindly advise where we can locate the LoanRepaymentImportHandler for us
>> to
>> > change the type.
>> >
>> >
>> >
>> > Thanks & Regards;
>> >
>> >
>> >
>> > *********
>> >
>> > *Zayyad A. Said | Chairman & C.E.O*
>> >
>> >
>> >
>> > Cell No.: +254 716 615274 | Skype: *zsaid2011*
>> >
>> > Email: zayyad@intrasofttechnologies.com
>> >
>> > Schedule Meetings: https://calendly.com/zayyadsaid
>> >
>> > [image: Description: Email banner]
>> >
>> > -----Original Message-----
>> > From: Vishwas Babu [mailto:vishwas@confluxtechnologies.com]
>> > Sent: 30 October 2018 11:55 PM
>> > To: dev@fineract.apache.org
>> > Cc: mifos-developer@lists.sourceforge.net
>> > Subject: Re: LOAN TRANSACTION IMPORT
>> >
>> >
>> >
>> > Hi Zayyad ,
>> >
>> >
>> >
>> > Changing the expected type of the repayment and loan Ids to long instead
>> > of Int in LoanRepaymentImportHandler would resolve the issue you are
>> facing
>> >
>> >
>> >
>> > Regards,
>> >
>> > Vishwas
>> >
>> >
>> >
>> > On Tuesday, October 30, 2018, Zayyad A. Said <
>> > zayyad@intrasofttechnologies.com> wrote:
>> >
>> >
>> >
>> > > Devs,
>> >
>> > >
>> >
>> > >
>> >
>> > >
>> >
>> > > Am experiencing a challenge importing loan payments.
>> >
>> > >
>> >
>> > >
>> >
>> > >
>> >
>> > > I tried with version 18.03.01, I get this error in catalina log:
>> >
>> > >
>> >
>> > >
>> >
>> > >
>> >
>> > > Exception in thread "SimpleAsyncTaskExecutor-258"
>> > java.lang.NumberFormatException:
>> >
>> > > For input string: "1010000000001"
>> >
>> > >
>> >
>> > > at java.lang.NumberFormatException.forInputString(
>> >
>> > > NumberFormatException.java:65)
>> >
>> > >
>> >
>> > > at java.lang.Integer.parseInt(Integer.java:583)
>> >
>> > >
>> >
>> > > at java.lang.Integer.parseInt(Integer.java:615)
>> >
>> > >
>> >
>> > > at org.apache.fineract.infrastructure.bulkimport.
>> >
>> > > importhandler.loanrepayment.(LoanRepaymentImportHandler.java:78)
>> >
>> > >
>> >
>> > > at org.apache.fineract.infrastructure.bulkimport.
>> >
>> > > importhandler.loanrepayment.LoanRepaymentImportHandler.readExcelFile(
>> >
>> > > LoanRepaymentImportHandler.java:70)
>> >
>> > >
>> >
>> > > at org.apache.fineract.infrastructure.bulkimport.
>> >
>> > > importhandler.loanrepayment.LoanRepaymentImportHandler.process(
>> >
>> > > LoanRepaymentImportHandler.java:60)
>> >
>> > >
>> >
>> > > at org.apache.fineract.infrastructure.bulkimport.service.
>> >
>> > >
>> BulkImportEventListener.onApplicationEvent(BulkImportEventListener.java:
>> >
>> > > 144)
>> >
>> > >
>> >
>> > > at org.apache.fineract.infrastructure.bulkimport.service.
>> >
>> > >
>> BulkImportEventListener.onApplicationEvent(BulkImportEventListener.java:
>> >
>> > > 48)
>> >
>> > >
>> >
>> > > at org.springframework.context.event.
>> >
>> > > SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticas
>> >
>> > > ter.java:93)
>> >
>> > >
>> >
>> > > at java.lang.Thread.run(Thread.java:745)
>> >
>> > >
>> >
>> > >
>> >
>> > >
>> >
>> > > I also tried with version 17.07.01 using the data import tool but I
>> >
>> > > noted that once you upload the file the loan account number changes to
>> >
>> > > *2147483647* which causes it to fail with an error “*id:Loan with
>> >
>> > > identifier 2147483647 does not exist*”.
>> >
>> > >
>> >
>> > >
>> >
>> > >
>> >
>> > > Can anyone advise me how we can sort out this issue? We have a huge
>> >
>> > > migration exercise that we are carrying out and the client needs all
>> >
>> > > transaction history.
>> >
>> > >
>> >
>> > >
>> >
>> > >
>> >
>> > > Regards;
>> >
>> > >
>> >
>> > >
>> >
>> > >
>> >
>> > > *********
>> >
>> > >
>> >
>> > > *Zayyad A. Said | Chairman & C.E.O*
>> >
>> > >
>> >
>> > >
>> >
>> > >
>> >
>> > > Cell No.: +254 716 615274 | Skype: *zsaid2011*
>> >
>> > >
>> >
>> > > Email: zayyad@intrasofttechnologies.com
>> >
>> > >
>> >
>> > > Schedule Meetings: https://calendly.com/zayyadsaid
>> >
>> > >
>> >
>> > > [image: Description: Email banner]
>> >
>> > >
>> >
>> > >
>> >
>> > >
>> >
>> >
>> >
>> >
>> >
>> > --
>> >
>> > Sent from my iPad
>> >
>>
>>
>> --
>> Ippez Roberts
>> Founder/C.E.O - Swift3 Technologies (U) Ltd
>> "Redefining Next Generation I/O Systems"
>> P.O.Box 155, Moyo
>> UGANDA.
>> Tel: +256788725408/770602630
>> Skype ID: ippez.robert1
>> Email: ippezrobert@gmail.com
>>
>
--
Thanks & Regards
Santosh Math
*QA Engineer*
*Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/>*
| *Office*: +91-080-41208662 |
*Address*: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block,
Bengaluru, Karnataka, 560043 INDIA
Re: LOAN TRANSACTION IMPORT
Posted by Ippez Robert <ip...@gmail.com>.
Hi Zayyad,
You can find that file here "
*fineract-provider\src\main\java\org\apache\fineract\infrastructure\bulkimport\importhandler\loanrepayment\LoanRepaymentImportHandler.java*
"
Hope this helps you.
Thanks
Regards
Ippez Robert
On Thu, Nov 1, 2018 at 10:58 AM Zayyad A. Said <
zayyad@intrasofttechnologies.com> wrote:
> Hi,
>
>
>
> Still no luck with this, I cant locate LoanRepaymentImport handler.
>
>
>
> The closest I could get is
> *fineract-provider/WEB-INF/classes/org/apache/fineract/portfolio/loanaccount/handler/LoanRepaymentCommandHandler.*
> class
>
>
>
> I decompiled the same but I can’t see import command.
>
>
>
> Will appreciate further guidance to have this resolved.
>
>
>
> Thanks & Regards;
>
>
>
> *********
>
> *Zayyad A. Said | Chairman & C.E.O*
>
>
>
> Cell No.: +254 716 615274 | Skype: *zsaid2011*
>
> Email: zayyad@intrasofttechnologies.com
>
> Schedule Meetings: https://calendly.com/zayyadsaid
>
> [image: Description: Email banner]
>
>
>
> *From:* Zayyad A. Said [mailto:zayyad@intrasofttechnologies.com]
> *Sent:* 31 October 2018 01:39 PM
> *To:* dev@fineract.apache.org; vishwas@confluxtechnologies.com
> *Cc:* mifos-developer@lists.sourceforge.net
> *Subject:* RE: LOAN TRANSACTION IMPORT
>
>
>
> Hi Vishwas,
>
>
>
> Thanks for your response.
>
>
>
> Kindly advise where we can locate the LoanRepaymentImportHandler for us to
> change the type.
>
>
>
> Thanks & Regards;
>
>
>
> *********
>
> *Zayyad A. Said | Chairman & C.E.O*
>
>
>
> Cell No.: +254 716 615274 | Skype: *zsaid2011*
>
> Email: zayyad@intrasofttechnologies.com
>
> Schedule Meetings: https://calendly.com/zayyadsaid
>
> [image: Description: Email banner]
>
> -----Original Message-----
> From: Vishwas Babu [mailto:vishwas@confluxtechnologies.com]
> Sent: 30 October 2018 11:55 PM
> To: dev@fineract.apache.org
> Cc: mifos-developer@lists.sourceforge.net
> Subject: Re: LOAN TRANSACTION IMPORT
>
>
>
> Hi Zayyad ,
>
>
>
> Changing the expected type of the repayment and loan Ids to long instead
> of Int in LoanRepaymentImportHandler would resolve the issue you are facing
>
>
>
> Regards,
>
> Vishwas
>
>
>
> On Tuesday, October 30, 2018, Zayyad A. Said <
> zayyad@intrasofttechnologies.com> wrote:
>
>
>
> > Devs,
>
> >
>
> >
>
> >
>
> > Am experiencing a challenge importing loan payments.
>
> >
>
> >
>
> >
>
> > I tried with version 18.03.01, I get this error in catalina log:
>
> >
>
> >
>
> >
>
> > Exception in thread "SimpleAsyncTaskExecutor-258"
> java.lang.NumberFormatException:
>
> > For input string: "1010000000001"
>
> >
>
> > at java.lang.NumberFormatException.forInputString(
>
> > NumberFormatException.java:65)
>
> >
>
> > at java.lang.Integer.parseInt(Integer.java:583)
>
> >
>
> > at java.lang.Integer.parseInt(Integer.java:615)
>
> >
>
> > at org.apache.fineract.infrastructure.bulkimport.
>
> > importhandler.loanrepayment.(LoanRepaymentImportHandler.java:78)
>
> >
>
> > at org.apache.fineract.infrastructure.bulkimport.
>
> > importhandler.loanrepayment.LoanRepaymentImportHandler.readExcelFile(
>
> > LoanRepaymentImportHandler.java:70)
>
> >
>
> > at org.apache.fineract.infrastructure.bulkimport.
>
> > importhandler.loanrepayment.LoanRepaymentImportHandler.process(
>
> > LoanRepaymentImportHandler.java:60)
>
> >
>
> > at org.apache.fineract.infrastructure.bulkimport.service.
>
> > BulkImportEventListener.onApplicationEvent(BulkImportEventListener.java:
>
> > 144)
>
> >
>
> > at org.apache.fineract.infrastructure.bulkimport.service.
>
> > BulkImportEventListener.onApplicationEvent(BulkImportEventListener.java:
>
> > 48)
>
> >
>
> > at org.springframework.context.event.
>
> > SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticas
>
> > ter.java:93)
>
> >
>
> > at java.lang.Thread.run(Thread.java:745)
>
> >
>
> >
>
> >
>
> > I also tried with version 17.07.01 using the data import tool but I
>
> > noted that once you upload the file the loan account number changes to
>
> > *2147483647* which causes it to fail with an error “*id:Loan with
>
> > identifier 2147483647 does not exist*”.
>
> >
>
> >
>
> >
>
> > Can anyone advise me how we can sort out this issue? We have a huge
>
> > migration exercise that we are carrying out and the client needs all
>
> > transaction history.
>
> >
>
> >
>
> >
>
> > Regards;
>
> >
>
> >
>
> >
>
> > *********
>
> >
>
> > *Zayyad A. Said | Chairman & C.E.O*
>
> >
>
> >
>
> >
>
> > Cell No.: +254 716 615274 | Skype: *zsaid2011*
>
> >
>
> > Email: zayyad@intrasofttechnologies.com
>
> >
>
> > Schedule Meetings: https://calendly.com/zayyadsaid
>
> >
>
> > [image: Description: Email banner]
>
> >
>
> >
>
> >
>
>
>
>
>
> --
>
> Sent from my iPad
>
--
Ippez Roberts
Founder/C.E.O - Swift3 Technologies (U) Ltd
"Redefining Next Generation I/O Systems"
P.O.Box 155, Moyo
UGANDA.
Tel: +256788725408/770602630
Skype ID: ippez.robert1
Email: ippezrobert@gmail.com