[Mifos-developer] LOAN TRANSACTION IMPORT
Zayyad A. Said
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.readLoanRepayment(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(SimpleApplicationEventMulticaster.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: zay...@intrasofttechnologies.com
Schedule Meetings: https://calendly.com/zayyadsaid
Zayyad A. Said
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: zay...@intrasofttechnologies.com
Schedule Meetings: https://calendly.com/zayyadsaid
-----Original Message-----
From: Vishwas Babu [mailto:vis...@confluxtechnologies.com]
Sent: 30 October 2018 11:55 PM
To: d...@fineract.apache.org
Cc: mifos-d...@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 < zay...@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: zay...@intrasofttechnologies.com
>
> Schedule Meetings: https://calendly.com/zayyadsaid
>
> [image: Description: Email banner]
>
>
>
--
Sent from my iPad
Zayyad A. Said
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: zay...@intrasofttechnologies.com
Schedule Meetings: https://calendly.com/zayyadsaid
