Hi Stebbins Thank you very much, I will put it to the test right away Regards
Austin Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 ________________________________ From: Stebbins Tugara <stebbyt...@gmail.com> Sent: Tuesday, September 11, 2018 7:18:07 PM To: A good place to start for users or folks new to Mifos. Subject: Re: [Mifos-users] Bulk Importation of Data on Version 18 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<mailto:akos...@outlook.com>> wrote: Dear Kumaranath Please advise status of this request for assistance. Thank you Regards Austin Sent from Mail<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3FLinkId%3D550986&data=02%7C01%7C%7C75b94f67380e447a425a08d618024093%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636722795282321894&sdata=j4tKVm4O0xojLBXqn%2BMUldCVjXST1r1wCGul%2BiTcg3Y%3D&reserved=0> for Windows 10 ________________________________ From: Kumaranath Fernando <kumaranathferna...@gmail.com<mailto:kumaranathferna...@gmail.com>> Sent: Saturday, August 25, 2018 2:17:01 PM To: mifos-users@lists.sourceforge.net<mailto: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<mailto: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<mailto: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 [X] 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<mailto: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<https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fsdm.link%2Fslashdot&data=02%7C01%7C%7C75b94f67380e447a425a08d618024093%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636722795282321894&sdata=zqbYj9Ot0msX4Je38i00fQIGFwnrg4Gct8bUVi2e4o0%3D&reserved=0>_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net<mailto:Mifos-users@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/mifos-users<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fmifos-users&data=02%7C01%7C%7C75b94f67380e447a425a08d618024093%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636722795282321894&sdata=wqX%2FV%2FBcb8yPB5EFwwQJFcE2LscrvNXJr2RuQoQplrM%3D&reserved=0>
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
