配置实现-导入数据配置举例

以importTest.xml为例：

<?xmlversion="1.0" encoding="utf-8"?>

<root>

  <myquery title="导入测试问题">

    <select>

     <column name="funid" title="所属模块" type="select" urlformatstring="sql:selectname,id from s_fun">

      </column>

      <column name="iclass"title="严重程度"type="select" urlformatstring="严重,1;次要,2;一般,3;新需求,4">

      </column>

      <column name="iflag"title="当前状态"type="select" urlformatstring="发现,0;确认1;解决,2;关闭,3">

      </column>

       <column name="rdate"title="发现日期"type="calcscript" value="getdate"usefields="this">

        getDate("{0}")

      </column>    

     <column name="optime" title="操作时间" value="getdate"></column>

      <column name="userid"title="操作人员"value="useraccount"></column>

    </select>

    <fromtype="xls"></from>

    <import isparameter="true">

      <table name="s_test" title="测试问题" isbase="true">

        <column name="rdate"title="发现日期"datatype="date" isnull="false"scope="all"></column>

        <column name="funid"title="所属模块"datatype="string" isnull="false"scope="add"></column>

        <column name="title"title="标题"datatype="string" maxlength="250" isnull="false"scope="add">

          问题,BUG

        </column>

        <column name="notes"title="描述"datatype="string" isnull="false" scope="all">

          问题描述,BUG描述

        </column>

        <column name="iclass" title="严重程度" datatype="string" scope="all">

        </column>

        <column name="iflag"title="当前状态"datatype="string" scope="add">

          状态

        </column>

        <column name="optime"datatype="date" scope="add"></column>

        <column name="userid"datatype="string" scope="add"></column>

        <wherekeycolumnnames="id">

          <column name="funid">

            and funid={0}

          </column>

          <column name="title">

            and title={0}

          </column>

        </where>

      </table>

      <javascript>

        <![CDATA[function getDate(value) {

            if (!value) {

                return "";

            }

            if (value.indexOf("T") !=-1) {

                return value.substr(0,value.indexOf("T"));

            } else if (value.search(/[\-\/\.]+/) !=-1) {

                return value;

            } else if (value.length == 8) {

                var year = value.substr(0, 4);

                var month = value.substr(4, 2);

                var day = value.substr(6, 2);

                newDate = new Date(year, month -1, day);

                if (newDate.toString() =="NaN") {

                    return "";

                }

                else {

                    return year + "-"+ month + "-" + day;

                }

            } else {

                return "";

            }

        }]]>

      </javascript>

      <notes>

        <![CDATA[请选择本地对应的Excel文件（文件后缀为.xls或.xlsx或.xlsm或.xlsb或.xml）；<br />

        文件必须是满足导入需求的定制格式文件；<br />

        选择文件与选择的导入目标必须一致否则会导致数据错误；]]>

      </notes>

    </import>

  </myquery>

</root>

欢迎访问：​​http://121.18.78.216​​ 适易查询分析、工作流、内容管理及项目管理演示平台