Hello Austin, >From my experience working with the tool, it seems you have created Account Number preference for your SAVINGS. The Data Import Tool can not handle Alphanumeric account numbers like the one i see in your error "For input string: "AS000000001".
Kindly delete the account number preference found in Admin-> System -> Account Number Pref so that savings accounts are created without the prefix "AS" and it should work. Please note that deleting the number preference will not affect already created savings accounts (only new entries) and performing a template download from the Data Tool will still give you an error. A clean way is to close all the previous savings accounts or if you are tech savvy you can locate the entries in mysql database and perform an bulk update to remove any leading or trailing characters in the column account_number. Hope this helps, thank you. Stebbins. On Wed, Aug 29, 2018 at 12:15 PM Austin Kosero <akos...@outlook.com> wrote: > Dear Kumaranath > > Please advise status of this request for assistance. > > > > Thank you > > > > Regards > > > > Austin > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 > > > ------------------------------ > *From:* Kumaranath Fernando <kumaranathferna...@gmail.com> > *Sent:* Saturday, August 25, 2018 2:17:01 PM > *To:* mifos-users@lists.sourceforge.net > *Subject:* Re: [Mifos-users] Bulk Importation of Data on Version 18 > > In addition, the excel template along with data... > > On Sat, Aug 25, 2018 at 4:45 PM Kumaranath Fernando < > kumaranathferna...@gmail.com> wrote: > >> Could kindly attach the catalin.log file for further investigations, >> please? >> >> Regards, >> Kumaranath Fernando >> >> On Sat, Aug 25, 2018 at 1:07 PM Austin Kosero <akos...@outlook.com> >> wrote: >> >>> Hi >>> >>> I am trying to bulk import data and have hit a snag, kindly assist >>> >>> >>> >>> When trying to import Savings Account upon clicking the upload button I >>> get a status message below >>> >>> >>> >>> I created a savings account via the keyboard and attempted to download >>> the upload template , this was unsuccessful and I received the message below >>> Whitelabel Error Page >>> >>> This application has no explicit mapping for /error, so you are seeing >>> this as a fallback. >>> >>> Sat Aug 25 07:06:49 UTC 2018 >>> >>> There was an unexpected error (type=Internal Server Error, status=500). >>> >>> For input string: "AS000000001" >>> >>> >>> >>> Regards >>> >>> >>> >>> Austin >>> >>> Sent from Mail >>> <https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3FLinkId%3D550986&data=02%7C01%7C%7C21d9188985b34786570c08d60a83c3e1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636707958374974448&sdata=Grx5hxukUM1jbS6%2BkR2Edx%2FNCeED%2FCl09EcrfaWUZY8%3D&reserved=0> >>> for Windows 10 >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Check out the vibrant tech community on one of the world's most >>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >>> <https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fsdm.link%2Fslashdot&data=02%7C01%7C%7C21d9188985b34786570c08d60a83c3e1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636707958374984459&sdata=hpQ4iVPQk9PizQECaNq0tz6pgvtj810nQU6XNp3GR3g%3D&reserved=0> >>> _______________________________________________ >>> Mifos-users mailing list >>> Mifos-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>> <https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fmifos-users&data=02%7C01%7C%7C21d9188985b34786570c08d60a83c3e1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636707958374994464&sdata=PfDh7L1faluOvyud8SPXd2jk5UHf%2BktyUhA%2BugqPJpA%3D&reserved=0> >>> >> > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Mifos-users mailing list > Mifos-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users >
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
