无法导入exce数据

zhaixin

JUSTEP170004的错误是概念定义信息无效
检查mapping文件中的<concept name="DEMO_TABLE1">使用的是这个概念吗

imxueqiong

改为  concept name="XXB"   (我自己建立的概念名称）后，还是一样的错误，只有最后一句不同
at (http://127.0.0.1:8080/x5/$v1bc62f7eb52f44d19954494fe61c4243/UI/system/components/excel/excel.js?language=zh_CN:728)
at (http://127.0.0.1:8080/x5/$va542e375f81b448daa1a85d58deff63a/UI/system/components/excel/excel.js?language=zh_CN:728)

zhaixin

概念名是大小写敏感的，确认一下写的是否正确
mapping文件中还有没有删除
15.                 <relation name="fDate" value-type="date" cell-number="5"/>
16.                 <relation name="fDateTime" value-type="datetime" cell-number="6"/>         
如果还有错误发控制台错误信息

imxueqiong

我查看了一下，之前那两行代码是删除了的。现在的代码如下：
<?xml version="1.0" encoding="UTF-8"?>
<mapping>
        <default-config>
                <sheet all="false" start="1" end="1"/>
                <row all="false" start="2" end="6"/>
        </default-config>
        <concept name="XBB">
<!--                <primary-key>-->
<!--                        <key-value cell-number="1"/>-->
<!--                </primary-key>-->
                <relation name="fX" cell-number="1"/>
                <relation name="fXZ" cell-number="2"/>
                <relation name="fC" cell-number="3"/>
                <relation name="fMJ" cell-number="4"/>
        </concept>
</mapping>



编码: JUSTEP170004; 提示:
--------------------------------------------------------------------------------

java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
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.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
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:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.excel.ExcelException: 编码: JUSTEP170004; 提示:
at com.justep.excel.ExcelException.create(ExcelException.java:28)
at com.justep.excel.ImportConceptConfig.(ImportConceptConfig.java:28)
at com.justep.excel.ImportConfig.(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:88)
... 26 more

at (http://127.0.0.1:8080/x5/$v02c3f2ef072d4d648270d2a29853c17a/UI/system/components/excel/excel.js?language=zh_CN:728)

imxueqiong

控制台错误信息：
2014-4-15 23:31:03 org.apache.catalina.core.AprLifecycleListener init
信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\X5.2.6_dev\X5.2.6\jdk\bin;.;C:\Windows\system32;C:\Windows;C:\Program Files\NVIDIA Corporation\PhysX\Common;C:\Program Files\Intel\iCLS Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT
2014-4-15 23:31:03 org.apache.coyote.http11.Http11Protocol init
严重: Error initializing endpoint
java.net.SocketException: Unrecognized Windows Sockets error: 0: JVM_Bind
        at java.net.PlainSocketImpl.socketBind(Native Method)
        at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
        at java.net.ServerSocket.bind(ServerSocket.java:319)
        at java.net.ServerSocket.<init>(ServerSocket.java:185)
        at java.net.ServerSocket.<init>(ServerSocket.java:141)
        at org.apache.tomcat.util.net.DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:50)
        at org.apache.tomcat.util.net.JIoEndpoint.init(JIoEndpoint.java:538)
        at org.apache.coyote.http11.Http11Protocol.init(Http11Protocol.java:176)
        at org.apache.catalina.connector.Connector.initialize(Connector.java:1014)
        at org.apache.catalina.core.StandardService.initialize(StandardService.java:680)
        at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:795)
        at org.apache.catalina.startup.Catalina.load(Catalina.java:524)
        at org.apache.catalina.startup.Catalina.load(Catalina.java:548)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:261)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2014-4-15 23:31:03 org.apache.catalina.startup.Catalina load
严重: Catalina.start
LifecycleException:  Protocol handler initialization failed: java.net.SocketException: Unrecognized Windows Sockets error: 0: JVM_Bind
        at org.apache.catalina.connector.Connector.initialize(Connector.java:1016)
        at org.apache.catalina.core.StandardService.initialize(StandardService.java:680)
        at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:795)
        at org.apache.catalina.startup.Catalina.load(Catalina.java:524)
        at org.apache.catalina.startup.Catalina.load(Catalina.java:548)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:261)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2014-4-15 23:31:03 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 305 ms
2014-4-15 23:31:03 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2014-4-15 23:31:03 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/6.0.29
[JUSTEP_HOME in UIServer]: D:\X5.2.6_dev\X5.2.6
[JUSTEP_HOME in BusinessServer]: D:\X5.2.6_dev\X5.2.6
2014-04-15 23:31:05 BusinessServer debug mode --> true
许可信息
版本：开发版
2014-04-15 23:31:05 加载模块：/SA/OPM/system ...
2014-04-15 23:31:05 加载模块：/SA/OPM ...
2014-04-15 23:31:05 加载模块：/SA ...
2014-04-15 23:31:05 加载模块：/system/logic/action ...
2014-04-15 23:31:05 加载模块：/system/logic ...
2014-04-15 23:31:05 加载模块：/system ...
2014-04-15 23:31:05 加载模块：/system/data ...
2014-04-15 23:31:05 加载模块：/system/ontology ...
2014-04-15 23:31:05 加载模块：/system/logic/fn ...
2014-04-15 23:31:05 加载模块：/SA/OPM/logic/action ...
2014-04-15 23:31:05 加载模块：/SA/OPM/logic ...
2014-04-15 23:31:05 加载模块：/system/logic/code ...
2014-04-15 23:31:05 加载模块：/SA/OPM/logic/code ...
2014-04-15 23:31:05 加载模块：/SA/OPM/logic/code/orgSynchronize ...
2014-04-15 23:31:06 加载模块：/system/config ...
2014-04-15 23:31:06 BusinessServer started
2014-4-15 23:31:06 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor host-manager.xml
2014-4-15 23:31:06 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor manager.xml
2014-4-15 23:31:06 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory docs
2014-4-15 23:31:06 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory examples
2014-4-15 23:31:06 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
2014-4-15 23:31:06 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
2014-4-15 23:31:06 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory ROOT
2014-4-15 23:31:06 org.apache.coyote.http11.Http11Protocol start
严重: Error starting endpoint
java.net.SocketException: Unrecognized Windows Sockets error: 0: JVM_Bind
        at java.net.PlainSocketImpl.socketBind(Native Method)
        at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
        at java.net.ServerSocket.bind(ServerSocket.java:319)
        at java.net.ServerSocket.<init>(ServerSocket.java:185)
        at java.net.ServerSocket.<init>(ServerSocket.java:141)
        at org.apache.tomcat.util.net.DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:50)
        at org.apache.tomcat.util.net.JIoEndpoint.init(JIoEndpoint.java:538)
        at org.apache.tomcat.util.net.JIoEndpoint.start(JIoEndpoint.java:565)
        at org.apache.coyote.http11.Http11Protocol.start(Http11Protocol.java:203)
        at org.apache.catalina.connector.Connector.start(Connector.java:1087)
        at org.apache.catalina.core.StandardService.start(StandardService.java:534)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
2014-4-15 23:31:06 org.apache.catalina.startup.Catalina start
严重: Catalina.start:
LifecycleException:  service.getName(): "Catalina";  Protocol handler start failed: java.net.SocketException: Unrecognized Windows Sockets error: 0: JVM_Bind
        at org.apache.catalina.connector.Connector.start(Connector.java:1094)
        at org.apache.catalina.core.StandardService.start(StandardService.java:534)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
2014-4-15 23:31:06 org.apache.catalina.startup.Catalina start
信息: Server startup in 3348 ms
2014-4-15 23:31:06 org.apache.catalina.core.StandardServer await
严重: StandardServer.await: create[8005]:
java.net.BindException: Address already in use: JVM_Bind
        at java.net.PlainSocketImpl.socketBind(Native Method)
        at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
        at java.net.ServerSocket.bind(ServerSocket.java:319)
        at java.net.ServerSocket.<init>(ServerSocket.java:185)
        at org.apache.catalina.core.StandardServer.await(StandardServer.java:373)
        at org.apache.catalina.startup.Catalina.await(Catalina.java:662)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:614)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
2014-4-15 23:31:06 org.apache.coyote.http11.Http11Protocol pause
信息: Pausing Coyote HTTP/1.1 on http-8080

jishuang

imxueqiong 发表于 2014-4-15 23:33
控制台错误信息：
2014-4-15 23:31:03 org.apache.catalina.core.AprLifecycleListener init
信息: The APR ...

这个错误是tomcat中的端口冲突了，改一下端口，或者看看tomcat是不是启动了多次，关了重新启动
修改端口参考http://bbs.justep.com/forum.php? ... 4&pid=165038302

imxueqiong

问题解决了，通过远程协助，发现了问题的原因是我的<concept name="XBB">写错了，而是<concept name="KM_XBB">   ，还有一个原因是我导入的excel表的表头下面有空行，把空行删了就可以导入了！