excel表的导入

gungun

excle表是导出时生成的，导入数据的时候报错
java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.justep.system.action.Engine.invokeActions(Native Method) at com.justep.system.action.Engine.invokeActions(Unknown Source) at com.justep.business.server.BusinessServer.doAction(Unknown Source) at com.justep.business.server.BusinessServer.doExcute(Unknown Source) at com.justep.business.server.BusinessServer.excute(Unknown Source) at com.justep.business.server.BusinessServer.excute(Unknown Source) at com.justep.business.server.BusinessServerServlet.execService(Unknown Source) at com.justep.business.server.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at com.justep.x.bs.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:745) Caused by: com.justep.excel.ExcelException: 编码: JUSTEP170004; 提示:  at com.justep.excel.ExcelException.create(ExcelException.java:28) at com.justep.excel.ImportConceptConfig.<init>(ImportConceptConfig.java:28) at com.justep.excel.ImportConfig.<init>(ImportConfig.java:15) at com.justep.excel.ImportGenerator.loadMapping(ImportGenerator.java:85) at com.justep.excel.ImportGenerator.init(ImportGenerator.java:59) at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:109) at Excel.importExcel(Excel.java:91) ... 30 more

jishuang

1.确认excel文件中的第一行是不是表头，如果是表头就设置从第二个开始导入
2.确认mapping文件中设置概念名和关系是否正确

gungun

<mapping>
        <default-config>
                <sheet all="false" start="1" end="1"/>
                <row all="false" start="2" end="100"/>
        </default-config>
        <concept name="SA_OPPerson">
            <primary-key>
                    <key-value cell-number="1"/>
            </primary-key>
                <relation name="fSZQJ" cell-number="2"/>
                <relation name="fUserName" cell-number="3"/>
                <relation name="sCardNO" cell-number="4"/>
                <relation name="fNZJ" cell-number="5"/>
                <relation name="fSFCYWXQJ" cell-number="6"/>
        </concept>       
</mapping>


看着都没有错啊？第一次用不是很熟悉，希望能说的更详细点

jishuang

你要把数据导入到平台的人员表中SA_OPPerson？

gungun

jishuang 发表于 2019-3-11 17:09
你要把数据导入到平台的人员表中SA_OPPerson？

因为这是自动生成的，我以为就是这样，现在已经可以了。修改成对应数据表就行了，
结帖吧！