jsreport forum

MarlonFH

Hello, how can I use the same script to bring different information to fill in each excel sheet?

function beforeRender(req, res, done) {

    req.options = req.options || {}
    req.options.preview = false

    require('request')({ 
      url:"http://XX.XXX.XXX.XXX:8080/lib/jsonpa.php?tp=cartera1",      
      json:true 
    }, function(err, response, body){
        console.log(JSON.stringify(body))
       
       req.data = Object.assign({}, req.data, { cartera1: body })      
       done();
    });
  
    require('request')({       
       url:"http://XX.XXX.XXX.XXX:8080/lib/jsonpa.php?tp=cartera2",      
      json:true 
    }, function(err, response, body){
        console.log(JSON.stringify(body))      
      
       req.data = Object.assign({}, req.data, { cartera2: body })
       done();
    });


    return;
}

o

function beforeRender(req, res, done) {

    req.options = req.options || {}
    req.options.preview = false

    require('request')({ 
           url:"http://XX.XXX.XXX.XXX:8080/lib/jsonpa.php?tp=cartera1",     
      json:true 
    }, function(err, response, body){
        console.log(JSON.stringify(body))
       
       req.data = Object.assign({}, req.data, { cartera1: body })      
       done();
    });  
    return;
}

function beforeRender2(req, res, done) {

    req.options = req.options || {}
    req.options.preview = false

    require('request')({ 
           url:"http://XX.XXX.XXX.XXX:8080/lib/jsonpa.php?tp=cartera2",     
      json:true 
    }, function(err, response, body){
        console.log(JSON.stringify(body))
       
       req.data = Object.assign({}, req.data, { cartera2: body })      
       done();
    });  
    return;
}

MarlonFH

When I send email with attachments, it is sent 2 times, why?

´´´
function beforeRender(req, res, done) {

req.options = req.options || {}
req.options.preview = false

require('request')({ 
  url:"http:", 
  json:true 
}, function(err, response, body){
    console.log(JSON.stringify(body))
   
   req.data = Object.assign({}, req.data, { terpel: body })
   done();
});
return;

}

function afterRender(req, res, done) {
if (req.options && req.options.preview) {
return done()
}
var mailer = require("nodemailer");

var smtpTransport = mailer.createTransport(
'smtps://example%40hotmail.com:Sistemas@hotmail.com'
);

var mail = {
    from: "Marlon<example@hotmail.com>",    
    to: "example@hotmail.com",
    subject: "Formato ",
    text: "Formato " ,
    html: "Buenos días,",
    attachments: [
    {  
        filename: "Formato".xlsx",
        content: new Buffer(res.content)
    }],

}

smtpTransport.sendMail(mail, function(error, response){
    smtpTransport.close();
    if(error){
        return done(error);
    }
    return done();
});

}
´´´

MarlonFH

When I send email with attachments, it is sent 2 times, why?

´´´
function beforeRender(req, res, done) {

req.options = req.options || {}
req.options.preview = false

require('request')({ 
  url:"http:", 
  json:true 
}, function(err, response, body){
    console.log(JSON.stringify(body))
   
   req.data = Object.assign({}, req.data, { terpel: body })
   done();
});
return;

}

function afterRender(req, res, done) {
if (req.options && req.options.preview) {
return done()
}
var mailer = require("nodemailer");

var smtpTransport = mailer.createTransport(
'smtps://example%40hotmail.com:Sistemas@hotmail.com'
);

var mail = {
    from: "Marlon<example@hotmail.com>",

,
    to: "example@hotmail.com",
    subject: "Formato ",
    text: "Formato " ,
    html: "Buenos días,",
    attachments: [
    {  
        filename: "Formato".xlsx",
        content: new Buffer(res.content)
    }],

}

smtpTransport.sendMail(mail, function(error, response){
    smtpTransport.close();
    if(error){
        return done(error);
    }
    return done();
});

}
´´´

MarlonFH

deleted folders in jsreport, how can I recover them

MarlonFH

hello, delete the folders in JSReport, how can I restore or recover them

MarlonFH

Hi, I'm doing a report for excel (xlsx), but when it was executed with json, I get the following error:

Error while executing templating engine. Cannot read property 'xl/worksheets/sheet7.xml' of undefined. Error on line 199:42.

  197 | 
  198 |   function add (filePath, xmlPath) {
> 199 |     var obj = this.ctx.root.$xlsxTemplate[filePath]
      |                                          ^
  200 |     var collection = safeGet(obj, xmlPath)
  201 | 
  202 |     var xml = escape(this.tagCtx.render(this.ctx.data).trim(), this.ctx.root)


TypeError: Cannot read property 'xl/worksheets/sheet7.xml' of undefined
    at Object.add (evaluate-template-engine-helpers.js:199:42)
    at Object.<anonymous> (evaluate-template-engine-helpers.js:429:17)
    at eval (eval at createFunctionContext (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/compiler/javascript-compiler.js:257:23), <anonymous>:6:91)
    at prog (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/runtime.js:221:12)
    at execIteration (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/helpers/each.js:51:19)
    at Object.<anonymous> (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/helpers/each.js:61:13)
    at Object.eval [as main] (eval at createFunctionContext (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/compiler/javascript-compiler.js:257:23), <anonymous>:5:34)
    at main (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/runtime.js:175:32)
    at ret (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/runtime.js:178:12)
    at ret (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/compiler/compiler.js:526:21)

My code is this:

{{#each informe}}

{{#xlsxAdd "xl/worksheets/sheet7.xml" "worksheet.sheetData[0].row"}}  
<row >  
    <c t="inlineStr"><is><t>{{empaque}}</t></is></c>  
    <c t="inlineStr"><is><t>{{zona}}</t></is></c>  
  
</row>  
{{/xlsxAdd}}  
{{/each}}
{{{xlsxPrint}}}

I uploaded a jsreport template

MarlonFH

Thank you very much, you saved me, that was the problem. Thank you

MarlonFH

if it works, and send mail
when I open this file I get the message "excel can not open the file because the format or extension of this are not valid"

MarlonFH

Do you have an example of sending mail with an excel file?

MarlonFH

Do you have an example of sending mail with an excel file?

MarlonFH

@MarlonFH

Posts made by MarlonFH