search

openMF / DataImportTool

An Excel-based tool created using Apache POI to import your existing data into the MifosX platform through REST calls.
16 stars 84 forks source link

Data Import Tool: characters are not reconsigned for provided office #41

Open santoshconflux opened 7 years ago

santoshconflux commented 7 years ago

Reported by Daniel at https://mifosforge.jira.com/browse/MIFOSX-2523 Original Description:

After I exported the clients for a new office, the following error appeared when I tried to download the Excel Sheet to import the groups:

IN THE DATA IMPORT TOOL PAGE: java.lang.IllegalStateException: Expected BEGIN_OBJECT but was STRING at line 1 column 1

IN GIT BASH: $ gradle clean tomcatrunwar The ConfigurationContainer.add() method has been deprecated and is scheduled to be removed in Gradle 2.0. Please use the create() method instead. The TaskContainer.add() method has been deprecated and is scheduled to be removed in Gradle 2.0. Please use the create() method instead. :clean :pmdMain :compileJava warning: [options] bootstrap class path not set in conjunction with -source 1.6 1 warning :processResources :classes :war :tomcatRunWar SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/C:/gradle-1.6/lib/logback-classic-1.0.9.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/C:/Users/Daniel/DataImportTool/build/tmp/tomcatRunWar/work/Tomcat/localhost/DataImportTool/WEB-INF/lib/logback-classic-1.0.13.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [ch.qos.logback.classic.util.ContextSelectorStaticBinder] Started Tomcat Server The Server is running at http://localhost:8070/DataImportTool 08:41:47.313 [http-bio-8070-exec-3] INFO o.o.m.d.http.MifosRestClient - Status: 404 Servlet.service() for servlet [DataImportServlet] in context with path [/DataImportTool] threw exception com.google.gson.JsonSyntaxException: java.lang.IllegalStateException: Expected BEGIN_OBJECT but was STRING at line 1 column 1 at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:176) at com.google.gson.Gson.fromJson(Gson.java:803) at com.google.gson.Gson.fromJson(Gson.java:768) at com.google.gson.Gson.fromJson(Gson.java:717) at com.google.gson.Gson.fromJson(Gson.java:689) at org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:116) at org.openmf.mifos.dataimport.handler.client.GroupDataImportHandler.upload(GroupDataImportHandler.java:133) at org.openmf.mifos.dataimport.web.DataImportServlet.parseAndUpload(DataImportServlet.java:64) at org.openmf.mifos.dataimport.web.DataImportServlet.doPost(DataImportServlet.java:43) at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.IllegalStateException: Expected BEGIN_OBJECT but was STRING at line 1 column 1 at com.google.gson.stream.JsonReader.beginObject(JsonReader.java:374) at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:165)