Google可视化代码正在抛出一个密码错误。

Question

我正在从获得数据，并试图将其显示在一个表中。代码正在抛出“The .zfa.c是未定义的”错误。我看不出密码有什么问题。

/*Table */
google.load('visualization', '1.0', {packages:['table']});
// Set a callback to run when the Google Visualization API is loaded.
google.setOnLoadCallback(drawNewTable);
function drawNewTable() {
var json = {cols: [{id:'campaign',label:'campaign',type:'string'},{id:'source',label:'source',type:'string'},{id:'medium',label:'medium',type:'string'},{id:'sessions',label:'sessions',type:'number'}],rows:[["FAC 2005-74 addresses contractor past performance reporting, contractor compensation","todays_acquisition_news_05302014","email",8.0],["GAO sustains protest, finding agency revised requirements","todays_acquisition_news_05292014","email",8.0],["GSA Announces OASIS Awards","todays_acquisition_news_05202014","email",6.0],["Governance Key to IT Program Success","todays_acquisition_news_05192014","email",6.0],["Revised FAC-C Addresses Competency Gaps, Uniform Standards","todays_acquisition_news_05192014","email",4.0],["FAR change could boost small business subcontracting, advocates say","todays_acquisition_news_05272014","email",3.0],["GAO examines sequestration?s effects","todays_acquisition_news_05292014","email",3.0],["GSA OIG finds PBS should have notified Congress when supplementing Recovery Act funding.","todays_acquisition_news_04282014","email",3.0],["Rung to leave GSA for OMB.","todays_acquisition_news_05152014","email",3.0],["Air Force may consider partnership to develop new launch rocket","todays_acquisition_news_05222014","email",2.0],["Boeing subcontractor pleads guilty in bribery scheme.","todays_acquisition_news_05142014","email",2.0],["Commentary questions whether contracting officers are using FAR part 1 authorities.","todays_acquisition_news_05302014","email",2.0],["Contractor improperly charged labor rates, DoD OIG finds","todays_acquisition_news_05212014","email",2.0],["Digital Service team would help agencies address IT gaps","todays_acquisition_news_05272014","email",2.0],["Senate hearing addresses DoD's acquisition reform efforts.","todays_acquisition_news_05012014","email",2.0],["poll","todays_acquisition_news_05302014","email",2.0],["Administration Threatens Veto of FY2015 Defense Authorization Act","todays_acquisition_news_05202014","email",1.0],["Administration Threatens Veto of FY2015 Defense Authorization Act-readmore","todays_acquisition_news_05202014","text-email",1.0],["Agencies have bolstered suspension and debarment programs","todays_acquisition_news_05222014","email",1.0],["Air Force asking industry to help reduce supply chain costs, official says.","todays_acquisition_news_04182014","email",1.0]]}
var data_newtable = new google.visualization.DataTable(json);
var data_table = new google.visualization.Table(document.getElementById('emailTable_div'));
data_table.draw(data_newtable, null);
};

Answer 1

json文件格式错误(cols，id.应该像弦乐一样)。应改为以下内容：

var json = {
    'cols': [
        {'id': 'campaign', 'label':'campaign',  'type':'string'},
        {'id':'source',    'label':'source',    'type':'string'},
        {'id':'medium',    'label':'medium',    'type':'string'},
        {'id':'sessions',  'label':'sessions',  'type':'number'}
    ],
    'rows':
        [{ 'c':[{ 'v': "FAC 2005-74 addresses contractor past performance reporting, contractor compensation"}, {'v': "todays_acquisition_news_05302014"}, {'v': "email"},{'v': 8.0}]}]
}

更新：您可以使用addColumn()和addRow()而无需更改json：

var data_newtable = new google.visualization.DataTable();

for (var i = 0; i < json.cols.length; ++i) {
    data_newtable.addColumn(json.cols[i].type, json.cols[i].label, json.cols[i].id);
}

for (var i = 0; i < json.rows.length; ++i) {
    data_newtable.addRow(json.rows[i]);
}

见jsbin的例子。