EXPORTEXCEL导出报错

MENG1

mainData是复合主键，导出时报错：
2020-08-06 14:13:12 excute stream action, params:{"accept":"application/json","action":"exportExcel","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"config":{"@type":"xml","xml":"<root><config><show-label>true</show-label><start-row>1</start-row></config><concept><relation metaName=\"userName\" width=\"\" metaLabel=\"姓名\" metaCellNo=\"1\" type=\"String\" excelCellNo=\"1\"/><relation metaName=\"courseName\" width=\"\" metaLabel=\"课程名称\" metaCellNo=\"2\" type=\"String\" excelCellNo=\"2\"/><relation metaName=\"courseType\" width=\"\" metaLabel=\"课程类型（1岗位课程2培训班课程3公共课程）\" metaCellNo=\"3\" type=\"Integer\" excelCellNo=\"3\"/><relation metaName=\"credits\" width=\"\" metaLabel=\"学分\" metaCellNo=\"4\" type=\"Decimal\" excelCellNo=\"4\"/><relation metaName=\"cHours\" width=\"\" metaLabel=\"学时\" metaCellNo=\"5\" type=\"Decimal\" excelCellNo=\"5\"/><relation metaName=\"finishTime\" width=\"\" metaLabel=\"获得学分时间\" metaCellNo=\"6\" type=\"DateTime\" excelCellNo=\"6\"/><relation metaName=\"stuStutas\" width=\"\" metaLabel=\"学习状态（1已完成2学习中3未学习）\" metaCellNo=\"7\" type=\"Integer\" excelCellNo=\"7\"/><relation metaName=\"trainingClass\" width=\"\" metaLabel=\"培训班名称\" metaCellNo=\"8\" type=\"String\" excelCellNo=\"8\"/></concept></root>"},"data":{"@type":"table","rows":[{"cHours":{"value":"1.0"},"courseName":{"value":"以习近平新时代中国特色社会主义经济思想为指导，引领经济高质量发展（上）"},"courseType":{"value":2},"credits":{"value":"1.0"},"finishTime":{"value":"2020-03-27T16:38:37.000Z"},"identityCard":{},"isDel":{"value":0},"stuStutas":{"value":1},"trainingClass":{"value":"新技术与经济网上专题培训班"},"unit":{"value":"炼化工程公司/工程建设公司/信息化和档案管理部"},"userCode":{"value":"E0337675"},"userName":{"value":"孟思远"},"userdata":{"id":{"value":"mengsy58645:189673772"},"isModified":false}},{"cHours":{"value":"1.0"},"courseName":{"value":"以习近平新时代中国特色社会主义经济思想为指导，引领经济高质量发展（下）"},"courseType":{"value":2},"credits":{"value":"1.0"},"finishTime":{"value":"2020-03-27T17:23:10.000Z"},"identityCard":{},"isDel":{"value":0},"stuStutas":{"value":1},"trainingClass":{"value":"新技术与经济网上专题培训班"},"unit":{"value":"炼化工程公司/工程建设公司/信息化和档案管理部"},"userCode":{"value":"E0337675"},"userName":{"value":"孟思远"},"userdata":{"id":{"value":"mengsy58645:189673773"},"isModified":false}}],"userdata":{"idColumnDefine":"Courserecord","idColumnName":"Courserecord","idColumnType":"String,Integer","model":"/Score/Score/data","relationAlias":"cHours,courseName,courseType,credits,finishTime,identityCard,isDel,stuStutas,trainingClass,unit,userCode,userName","relationTypes":"Decimal,String,Integer,Decimal,DateTime,String,Integer,Integer,String,String,String,String","relations":"Courserecord.cHours,Courserecord.courseName,Courserecord.courseType,Courserecord.credits,Courserecord.finishTime,Courserecord.identityCard,Courserecord.isDel,Courserecord.stuStutas,Courserecord.trainingClass,Courserecord.unit,Courserecord.userCode,Courserecord.userName","sys.count":2,"sys.rowid":"Courserecord","updateMode":"whereVersion"}},"excelType":"excel2007","from":"UI"},"process":"/SA/excel/system/systemProcess"}
com.justep.exception.BusinessException: 编码: JUSTEP150144; 提示: 列"Courserecord"的类型"String,Integer"不支持; 可能的原因: 支持的类型有String,Integer,Float,Double,Date,Time,DateTime,Decimal,Text,Object,Blob
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.util.Utils.check(Unknown Source)
at com.justep.system.data.impl.TableImpl.createColumnMetaData(Unknown Source)
at com.justep.system.data.impl.TableImpl.addColumns(Unknown Source)
at com.justep.system.data.impl.TableImpl.createTable(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.createTable(Unknown Source)
at com.justep.system.data.TableUtils.createTable(Unknown Source)
at com.justep.system.transform.Row2Table.createTable(Unknown Source)
at com.justep.system.transform.Json2Table.transform(Unknown Source)
at com.justep.system.transform.ParameterTransform.transTableParamByJson(Unknown Source)
at com.justep.system.transform.ParameterTransform.transParamByJson(Unknown Source)
at com.justep.system.transform.ParameterTransform.helpTransform(Unknown Source)
at com.justep.system.transform.ParameterTransform.transform(Unknown Source)
at com.justep.system.transform.RequestTransform.transParamValue(Unknown Source)
at com.justep.system.transform.RequestTransform.transActionParams(Unknown Source)
at com.justep.system.transform.RequestTransform.transform(Unknown Source)
at com.justep.system.action.Engine.translateParameters(Unknown Source)
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)

jishuang

导出的时候怎么设置的？

MENG1

导出设置

jishuang

没有设置导出主键也没有设置Courserecord列还报错？导出DB看看

MENG1

对，设置为DB之后，可以了，但是只导出了UI层的数据，同时计算列导不出来了

jishuang

useConfigDlg设置为true看看导出时默认选择的有哪些列？