Posts made by 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;
}

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();
});

}
´´´

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();
});

}
´´´

deleted folders in jsreport, how can I recover them

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

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

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

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"

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

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

Puedes ayudarme

a mi me sale "excel no puede abrir el archivo porque el formato o la extension no son validos"

Hi guys, can you help me?
I want to send a file excel (.xlsx) by mail (nodemailer), but I see this error.

function beforeRender(req, res, done) {
    require('request')({ 
      url:"http://#######/detalle.js", 
      json:true 
    }, function(err, response, body){
        console.log(JSON.stringify(body))
       req.data = { detalle: body };
        done();
    });
    return;
}

function afterRender(req, res, done) {
    var mailer = require("nodemailer");

    var smtpTransport = mailer.createTransport('smtps://Joseantonio%40gmail.com:###@smtp.gmail.com');

    var mail = {
        from: "Jose <@gmail.com>",
        to: "josesito@gmail.com",
        subject: "Enviado desde Jsreport",
        text: "Reporte ",
        html: "<b>Reporte excel</b>",
        attachments: [
        {  
            filename: 'Reporte.xlsx',
            content: new Buffer(res.content)
        }],
    }

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

        return done();
    });
}

---------This error appears

Error while executing templating engine. Cannot read property 'xl/worksheets/sheet2.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/sheet2.xml' of undefined
    at Array.add (evaluate-template-engine-helpers.js:199:42)
    at Array.<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>:5:94)
    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:80:11)
    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)

I installed it like this, is it okay?

sistemas@noroil-s02:~$ npm install nodemailer
▀ ╢░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╟
WARN engine nodemailer@6.1.0: wanted: {"node":">=6.0.0"} (current: {"node":"4.2.6","npm":"3.5.2"})
WARN engine nodemailer@6.1.0: wanted: {"node":">=6.0.0"} (current: {"node":"4.2./home/sistemas
└── nodemailer@6.1.0

npm WARN enoent ENOENT: no such file or directory, open '/home/sistemas/package.json'
npm WARN sistemas No description
npm WARN sistemas No repository field.
npm WARN sistemas No README data
npm WARN sistemas No license field.

• the result of the command npm ls nodemailer

sistemas@noroil-s02:~$ npm ls nodemailer
/home/sistemas
└── nodemailer@6.1.0

the same error keeps coming, or maybe install badly nodemailer. I can not solve it, help me

Error while executing user script. Unable to find module nodemailer
Searched paths:
nodemailer
/app/nodemailer
.

77 |
78 | function afterRender(req, res, done) {

79 | var mailer = require('nodemailer');
| ^
80 |
81 | var smtpTransport = nodemailer.createTransport('smtps://malca.kike.9%40gmail.com:6XK1x&7Z@smtp.gmail.com');
82 |

Error: Unable to find module nodemailer
Searched paths:
nodemailer
/app/nodemailer

at doRequire (/app/node_modules/jsreport-core/lib/render/safeSandbox.js:232:11)
at _require (/app/node_modules/jsreport-core/lib/render/safeSandbox.js:72:14)
at Object.apply (/app/node_modules/vm2/lib/contextify.js:288:34)
at Object.afterRender (evaluate-user-script.js:79:18)
at __runAfter (/app/node_modules/jsreport-scripts/lib/scriptEvalChild.js:120:26)
at Object.apply (/app/node_modules/vm2/lib/contextify.js:288:34)
at evaluate-user-script.js:110:1
at ContextifyScript.Script.runInContext (vm.js:59:29)
at VM.run (/app/node_modules/vm2/lib/main.js:212:72)
at run (/app/node_modules/jsreport-core/lib/render/safeSandbox.js:183:19)

Again error is coming out, I'm using this code to send mail, okay?

´´´
function afterRender(req, res, done) {
var mailer = require('nodemailer');

var smtpTransport = mailer.createTransport('smtps://user%40gmail.com:pass@smtp.gmail.com');

var mail = {
    from: "Jan Blaha <malca.kike.9@gmail.com>",
    to: "marlon.50294@gmail.com",
    subject: "Sending email from node.js",
    text: "See the attached report",
    html: "<b>See the attached report</b>",
    attachments: [
    {  
        filename: 'Report.pdf',
        content: new Buffer(res.content)
    }],
}

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

    return done();
});

}
´´´

the same thing keeps coming

is configured with this code

{
   "extensions": {
     "scripts": {
       "allowedModules": ["request"]
     }
   }
}

I'm trying to send an email, and install the nodemailer, but I get this error when I run, help !.

Error while executing user script. Unable to find module nodemailer
Searched paths: 
nodemailer
/app/nodemailer
. 

  77 | 
  78 |  function afterRender(req, res, done) {
> 79 |     var mailer = require('nodemailer');
     |                  ^
  80 | 
  81 |     var smtpTransport = mailer.createTransport('smtps://user%40gmail.com:pass@smtp.gmail.com');
  82 | 


Error: Unable to find module nodemailer
Searched paths: 
nodemailer
/app/nodemailer

    at doRequire (/app/node_modules/jsreport-core/lib/render/safeSandbox.js:232:11)
    at _require (/app/node_modules/jsreport-core/lib/render/safeSandbox.js:72:14)
    at Object.apply (/app/node_modules/vm2/lib/contextify.js:288:34)
    at Object.afterRender (evaluate-user-script.js:79:18)
    at __runAfter (/app/node_modules/jsreport-scripts/lib/scriptEvalChild.js:120:26)
    at Object.apply (/app/node_modules/vm2/lib/contextify.js:288:34)
    at evaluate-user-script.js:110:1
    at ContextifyScript.Script.runInContext (vm.js:59:29)
    at VM.run (/app/node_modules/vm2/lib/main.js:212:72)
    at run (/app/node_modules/jsreport-core/lib/render/safeSandbox.js:183:19)