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: <mailto:[email protected]> [email protected] Schedule Meetings: <https://calendly.com/zayyadsaid> https://calendly.com/zayyadsaid Description: Email banner -----Original Message----- From: Vishwas Babu [mailto:[email protected]] Sent: 30 October 2018 11:55 PM To: [email protected] Cc: [email protected] 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 < <mailto:[email protected]> [email protected]> 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: <mailto:[email protected]> > [email protected] > > Schedule Meetings: <https://calendly.com/zayyadsaid> > https://calendly.com/zayyadsaid > > [image: Description: Email banner] > > > -- Sent from my iPad
