* .xls
* .xlsx
* .cvs
* .txt
1. 标记注册,在uncertain.xml中注册导入标记
<uncertain-engine name="hec">
<packages>
<package-path classPath="aurora_plugin_package/aurora.plugin.dataimport"/>
...
</packages>
</uncertain-engine>
2. screen文件,HTML标准的文件上传
<form name="upload" action="upload.svc" enctype="multipart/form-data" method="post">
<input name="CONTENT" type="file"/>
<input type="submit"/>
</form>
3. svc文件
<a:service xmlns:a="http://www.aurora-framework.org/application">
<a:init-procedure outputPath="/parameter">
<a:model-query model="sys.get_sys_import_head_id" rootPath="header"/>
<a:import-excel header_id="${/model/header/record/@header_id}"/>
</a:init-procedure>
</a:service>
Table 1.
|
属性名
|
类型
|
描述
|
必须
|
默认值
|
|---|
|
header_id
|
in
|
fnd_interface_headers表中的header_id
|
true
|
|
|
dataSourceName
|
in
|
导入数据库的dataSourceName
|
false
|
|
|
user_id
|
in
|
当前用户user_id
|
false
|
${/session/@user_id}
|
|
separator
|
in
|
导入文本类型时的分隔符
|
false
|
，
|
|
template_code
|
in
|
模板code
|
false
|
|
|
job_id
|
in
|
任务id
|
false
|
|
|
attribute1
|
in
|
扩展字段1
|
false
|
|
|
attribute2
|
in
|
扩展字段2
|
false
|
|
|
attribute3
|
in
|
扩展字段3
|
false
|
|
|
attribute4
|
in
|
扩展字段4
|
false
|
|
|
attribute5
|
in
|
扩展字段5
|
false
|
|
poi3.7和以前的版本不兼容，要删除3.7之前版本的poi相关jar
dom4j-1.6.1.jar
geronimo-stax-api_1.0_spec-1.0.jar
poi-3.7-20101029.jar
poi-ooxml-3.7-20101029.jar
xmlbeans-2.3.0.jar
xerces_2_5_0.jar
Comments
0 Responses to the article暂时没有评论。