导出表值流星烈焰

Export table values Meteor Blaze

本文关键字:烈焰 流星 导出表      更新时间:2023-09-26

我在将表格导出为流星/火焰中的csv时遇到了一些困难。我是以下: [http://rafaelquintanilha.com/export-your-json-data-to-csv-format/][1]。

我有一个触发导出按钮的模板事件

Template.export.onCreated( () => {
  Template.instance().subscribe('table');
});
Template.export.helpers({
  exportContacts() {
    return Contacts.find();
  }
});
Template.export.events({
  'click .export-data' () {
    MyAppExporter.exportAllContacts();
  }
});

它在全局帮助程序中调用导出所有联系人()

 MyAppExporter = {
    exportAllContacts: function() {
        var self = this;
        Meteor.call("exportContacts", function(error, data) {
            if ( error ) {
                alert(error);
                return false;
            }
            var csv = Papa.unparse(data);
            self._downloadCSV(csv);
        });
    },
    _downloadCSV: function(csv) {
        var blob = new Blob([csv]);
        var a = window.document.createElement("a");
        a.href = window.URL.createObjectURL(blob, {type: "text/plain"});
        a.download = "contacts.csv";
        document.body.appendChild(a);
        a.click();
        document.body.removeChild(a);
    }
}

并且帮助程序正在调用流星.方法导出联系人

  Meteor.methods({
    exportContacts: function() {
        let fields = [
            "Email",
            “Some Contact",
            "Created Date",
            "Hard Bounce",
            "Unsubscribed"
        ];
        let data = [];
        let contacts = Contacts.find().fetch();
    for(let i = 0; i < contacts.length; i++) {
      let contact = contacts[i];
      let contactString = JSON.stringify(contact);
        _.each(contactString, function(c) {
        console.log("Inside Loop", contactString);
            data.push([
                c.contact.emailAddress,
                c.contact.someContact,
                c.contact.creationDate,
                c.contact.hardBounceBack,
                c.contact.unsubscribed
            ]);
        console.log("DATA", data)
        return {fields: fields, data: data};
        });
    }
  }
});

我不断收到"电子邮件地址未定义导出联系人.js:20:17

20160426-22:00:47.957(-4)? Inside Loop {"_id":"dRnXRdZrbR9CYdmBx","contact":[{"emailAddress":"fred@weasly.com","someContact":"No","creationDate":"N/A","hardBounceBack":"N/A","unsubscribed":"N/A"}]}
I20160426-22:00:48.029(-4)? Exception while invoking method 'exportContacts' ReferenceError: emailAddress is not defined
I20160426-22:00:48.029(-4)?     at server/methods/exportContacts.js:20:17
I20160426-22:00:48.029(-4)?     at Function._.each._.forEach (packages/underscore.js:142:22)
I20160426-22:00:48.029(-4)?     at _loop (server/methods/exportContacts.js:17:7)

但我似乎无法弄清楚如何访问联系人。我正在注销它(见上面的日志)。任何帮助将不胜感激。

添加的日志let contacts = Contacts.find().fetch();控制台.log(联系人)

I20160427-09:06:23.484(-4)? CONTACTS [ { _id: 'dRnXRdZrbR9CYdmBx', contact: [ [Object] ] },
I20160427-09:06:23.484(-4)?   { _id: 'LHmW4R9PLM5D7cZxr', contact: [ [Object] ] },
I20160427-09:06:23.484(-4)?   { _id: 'jBdqQXz2b8itXJowX', contact: [ [Object] ] },
I20160427-09:06:23.484(-4)?   { _id: 'bnDvNGX3i879z4wr2', contact: [ [Object] ] } ]

c.联系方式[0].电子邮件地址已注销

I20160427-09:22:08.142(-4)? Inside Loop {"_id":"dRnXRdZrbR9CYdmBx","contact":[{"emailAddress":"fred@weasly.com","someContact":"No","creationDate":"N/A","hardBounceBack":"N/A","unsubscribed":"N/A"}]}
I20160427-09:22:08.217(-4)? Exception while invoking method 'exportContacts' TypeError: Cannot read property '0' of undefined
I20160427-09:22:08.217(-4)?     at server/methods/exportContacts.js:21:7
I20160427-09:22:08.217(-4)?     at Function._.each._.forEach (packages/underscore.js:142:22)
I20160427-09:22:08.217(-4)?     at _loop (server/methods/exportContacts.js:18:7)
I20160427-09:22:08.218(-4)?     at [object Object].exportContacts (server/methods/exportContacts.js:15:46)

在 _.each 循环中,您访问了错误的数据项。您也可以使用 _.each 循环而不是外部 for 循环。如果您这样做:

let contacts = Contacts.find().fetch();
_.each(contacts, function(contact) {
  _each(contact.contact, function(c) {
      data.push(
          {
              "email": c.emailAddress,
              "contact": c. someContact,
              "creationDate" : c.creationDate,
              "bounceBack": c.hardBounceBack,
              "unsubscribed": c.unsubscribed
          }            
  })
})

这应该可以解决您的问题。这样,您将循环访问从提取返回的外部联系人,然后循环访问每个元素的联系人数组。这应该是获取您正在寻找的数据的最直接方法。

你的问题是这一行:_.each(contactString, function(c) {

它应为:_.each(contact, function(c) {

:)