表格导入

天啦噜404 · 发表于 2017-4-17 11:56:56

因为我在写循环新增数据的时候新增的速度太慢，所以想利用导入功能的方法，请问导入功能的源码在哪

jishuang · 发表于 2017-4-17 13:25:30

/UI2/system/components/justep/excel

/BIZ/SA/excel

天啦噜404 · 发表于 2017-4-17 16:41:38

jishuang 发表于 2017-4-17 13:25
/UI2/system/components/justep/excel

/BIZ/SA/excel

导入的时候把Excel文件里的数据转成什么形式放到data里的

jishuang · 发表于 2017-4-17 17:06:47

/UI2/system/components/justep/excel/importExcel.js

天啦噜404 · 发表于 2017-4-19 14:39:02

jishuang 发表于 2017-4-17 17:06
/UI2/system/components/justep/excel/importExcel.js

data的loaddata属性有没有使用案例？

jishuang · 发表于 2017-4-19 16:20:10

loadData就是传的json数据给data
http://docs.wex5.com/bex5-ui-question-list-10069/

天啦噜404 · 发表于 2017-4-19 17:16:57

jishuang 发表于 2017-4-19 16:20
loadData就是传的json数据给data
http://docs.wex5.com/bex5-ui-question-list-10069/

我用loaddata传的参不是经过ksql返回的table，返回的是String，我把他转成json，但是为什么Grid不显示，是不是我的格式问题，我用的是Cdata，而且列名称定义的还有中文，是不是因为这个呢

Model.prototype.button2Click = function(event) {
var data1 = this.comp("Cdata")
var grid = this.comp("grid1");
this.comp("Cdata").clear()
var c = []
var contex = this.getContext();
biz.Request.sendBizRequest({
// 查询任务书的信息
"context" : contex,
"action" : "queryHospital",
"callback" : function(data) {
if (data.state) {
json = data.response;
}
}
})
var d = JSON.parse(json)
for ( var i in d) {
var j = d[i].FL
var Cname
var rows = {
"CUSTOMMODULE5_ID" : {
"value" : Cname
}
}
for ( var e in j) {
if (j[e].val == 'CUSTOMMODULE5_ID') {
// cID = j[e].val
Cname = j[e].content
}
}
c.push(rows)
}
var a = {
"@type" : "json",
"userdata" : {
"idColumnName" : "CUSTOMMODULE5_ID",
"idColumnType" : "String",
"relationAlias" : "SMOWNERID,报发货所有者,医院_ID,医院",
"relationTypes" : "String,String,String,String",
"sys.count" : 2
},
"row" : c
}
alert(a)
console.log(a)
data1.loadData(a, true)
grid.refresh()

复制代码

天啦噜404 · 发表于 2017-4-19 17:18:41

jishuang 发表于 2017-4-19 16:20
loadData就是传的json数据给data
http://docs.wex5.com/bex5-ui-question-list-10069/

这是action里面的代码

public static String queryHospital() {
String postResp = null;
List<String> list = new ArrayList<String>();
List<String> hezi = new ArrayList<String>();
for (int z = 1; z > 0; z = z + 200) {
try {
// ----------------------------Fetch Auth Token
// ----------------------
String authtoken = "";// If you
// don't
// have
// a
// authtoken please refer
// this wiki
// https://zohocrmapi.wiki.zoho.com/using-authtoken.html
String scope = "crmapi";
String selectColumns = "All";
String newFormat = "2";
String fromIndex = "" + z;
String toIndex = "" + (z + 199);
String targetURL = "https://crm.zoho.com.cn/crm/private/json/CustomModule5/getRecords";
String paramname = "content";
PostMethod post = new PostMethod(targetURL);
post.setParameter("authtoken", authtoken);
post.setParameter("scope", scope);
post.setParameter("newFormat", newFormat);
post.setParameter("selectColumns", selectColumns);
post.getParams().setParameter(HttpMethodParams.HTTP_CONTENT_CHARSET, "utf-8");
post.setParameter("fromIndex", fromIndex);
post.setParameter("toIndex", toIndex);
HttpClient httpclient = new HttpClient();
PrintWriter myout = null;
System.out.println("fromIndex:" + fromIndex + "toIndex:" + toIndex);
// Execute http request
try {
long t1 = System.currentTimeMillis();
int result = httpclient.executeMethod(post);
// System.out.println("HTTP Response status code: " +
// result);
// System.out.println(">> Time taken " +
// (System.currentTimeMillis() - t1));
// writing the response to a file
myout = new PrintWriter(new File("response.xml"));
myout.print(post.getResponseBodyAsString());
// -----------------------Get response as a string
// ----------------
postResp = post.getResponseBodyAsString();
JSONObject json = JSONObject.parseObject(postResp);
JSONObject response = (JSONObject) json.get("response");
JSONObject result1 = (JSONObject) response.get("result");
JSONObject CustomModule5 = (JSONObject) result1.get("CustomModule5");
JSONArray row = (JSONArray) CustomModule5.get("row");
for (int i1 = 0; i1 < row.size(); i1++) {
JSONObject n = row.getJSONObject(i1);
for (int i2 = 0; i2 < n.size(); i2++) {
JSONArray fl = n.getJSONArray("FL");
for (int i3 = 0; i3 < fl.size(); i3++) {
JSONObject name = fl.getJSONObject(i3);
String val = name.getString("val");
String conten = "";
if (val.equals("医院")) {
conten = name.getString("content");
if (!has(conten, hezi)) {
hezi.add(conten);
list.add(n.toJSONString());
}
}
}
}
}
if (row.size() < 200) {
break;
}
System.out.println("大小==========>>" + row.size());
// System.out.println("postResp=======>" + postResp);
} catch (Exception e) {
e.printStackTrace();
} finally {
myout.close();
post.releaseConnection();
}
} catch (Exception e) {
e.printStackTrace();
}
}
// System.out.println(hezi.toString());
// Table str = list.toString();
return list.toString();
}

复制代码

jishuang · 发表于 2017-4-19 17:32:21

string的可以自己newData的方式条件数据，然后setValue赋值

grid不显示参考http://docs.wex5.com/bex5-ui-question-list-10067/

天啦噜404 · 发表于 2017-4-19 18:02:25

jishuang 发表于 2017-4-19 17:32
string的可以自己newData的方式条件数据，然后setValue赋值

grid不显示参考http://docs.wex5.com/bex5-ui- ...

newData太慢了，五百行以上数据浏览器就要蹦

		自动登录	找回密码
密码			注册

[结贴] 表格导入