jsreport forum

odirleiborgert

Hello, I was able to solve the problem with jan_blaha's solution by setting up Azure Blog Storage.

odirleiborgert

I have a docker on azure with jsreport 2.5.0.
I created the reports from his. and after a few days it disappeared.
Is there any setting I must pass in the environment variables or something I'm failing?

odirleiborgert

I fixed the error "Protocol error (Page.printToPDF): Target closed." replacing 'chrome-pdf' with 'phantom-pdf'

odirleiborgert

How to format text? Font, color, and others...

    <sheetData>
        <row>
            <c t="inlineStr"><is><t>{{ title }}</t></is></c>
        </row>
        <row>
            <c t="inlineStr"><is><t>{{ subtitle }}</t></is></c>
        </row>
    </sheetData>

odirleiborgert

Hi People.

I created a "webApp" in Azure and installed JsReport 2.5, but reports that use PDF I can not render.

If you use the engine "phantom-pdf" the error is:

Server Error.
There was an unexpected error in the request processing.

If you use the "chrome-pdf" engine, the error is:

Error: Chromium revision is not downloaded. Run "npm install" or "yarn install"
    at Launcher.launch (/home/site/wwwroot/node_modules/puppeteer/lib/Launcher.js:119:15)

If you use the engine "xlsx" success is guaranteed for the file.

The installed packages are:
package.json

  "dependencies": {
    "jsreport": "2.5.0",
    "jsreport-phantom-pdf": "^2.2.0",
    "moment": "^2.24.0",
    "moment-timezone": "^0.5.25"
  }

Template

<html>
    <head>
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
    </head>
    <body>
        Test
    </body>
</html>

odirleiborgert

Thanks @bjrmatos

odirleiborgert

My problem is "Not working division"

My code in playground https://playground.jsreport.net/w/odirleiborgert/FX3V9W_z

odirleiborgert

Hi @jan_blaha ,
Thanks for your time dedicated to helping me, I was able to run your code, I will investigate my code better and I will answer here when I find my problem.

odirleiborgert

Hi @jan_blaha

The output of the debug. I am trying to generate a file with 1,100,000 rows. With 1,000,000 lines working normally.

read ECONNRESET
logs:
+0      Starting rendering request 16 (user: null)
+2      Rendering template { name: excel, recipe: xlsx, engine: handlebars, preview: true }
+2      Data item not defined for this template.
+2      Resources not defined for this template.
+34     Executing script script
+168787 Base url not specified, skipping its injection.
+168787 Rendering engine handlebars
Error: read ECONNRESET
    at TCP.onStreamRead (internal/stream_base_commons.js:111:27)

odirleiborgert

Thanks @jan_blaha, worked perfectly.

odirleiborgert

Hi People

I am making a request for jsreport api to mount my PDF, the request is in ajax (Axios + Vue) and I am returning the code below in the response.data, however I am having difficulty making the user download or view this PDF.

response.data

JVBERi0xLjQKJdPr6eEKMSAwPC9DcmVh...........yZWYKMjc4OTUKJSVFT0Y=

odirleiborgert

Hi @jan_blaha

I'm using the 'xlsx' recipe. I made the memory change that happened to me, I ran a new test with 1200000 lines and I'm copying the log for you to see.

2019-05-20T11:22:52.735Z - info: Starting rendering request 11 (user: null)
2019-05-20T11:22:52.736Z - info: Rendering template { name: excel, recipe: xlsx, engine: handlebars, preview: false }
2019-05-20T11:25:25.471Z - info: fs store is loading data
2019-05-20T11:25:26.446Z - info: Starting rendering request 12 (user: null)
2019-05-20T11:25:26.447Z - info: Rendering template { name: excel, recipe: xlsx, engine: handlebars, preview: true }
2019-05-20T11:25:26.522Z - info: Starting rendering request 13 (user: null)
2019-05-20T11:25:26.524Z - info: Rendering template { name: excel, recipe: xlsx, engine: handlebars, preview: true }
2019-05-20T11:25:40.200Z - warn: Error when processing render request read ECONNRESET Error: read ECONNRESET
    at TCP.onStreamRead (internal/stream_base_commons.js:162:27)
2019-05-20T11:25:40.200Z - warn: Error during processing request at http://localhost:5488/api/report
2019-05-20T11:25:40.209Z - warn: Error when processing render request read ECONNRESET Error: read ECONNRESET
    at TCP.onStreamRead (internal/stream_base_commons.js:162:27)
2019-05-20T11:25:40.210Z - warn: Error when processing render request read ECONNRESET Error: read ECONNRESET
    at TCP.onStreamRead (internal/stream_base_commons.js:162:27)
2019-05-20T11:25:40.210Z - warn: Error during processing request at http://localhost:5488/api/report/excel
2019-05-20T11:25:40.210Z - warn: Error during processing request at http://localhost:5488/api/report/excel

My template:

{{xlsxRemove "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row" 1}}

{{#each envios.result}}

    {{#xlsxAdd "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row"}}
        <row>
            <c t="inlineStr" s="{{@root.$removedItem.c.[0].$.s}}"><is><t>{{id}}</t></is></c>
            <c t="inlineStr" s="{{@root.$removedItem.c.[1].$.s}}"><is><t>{{data_hora}} {{ 11 }}</t></is></c>
            <c t="inlineStr" s="{{@root.$removedItem.c.[2].$.s}}"><is><t>{{status}}</t></is></c>
        </row>
    {{/xlsxAdd}}
    
{{/each}}

{{{xlsxPrint}}}

My script:

var request = require('request')

function beforeRender(req, res, done) {
    
    var url = 'http://localhost:5000/list';
    
    var options = {
        url: url,
        timeout: 600000
    }
    
    request.get(
        options, 
        function (err, resp, body) {
            
            if (err) {
                return done(err)
            }
            
            req.data = JSON.parse(body)
    
            done()
        }
    ) 
}

odirleiborgert

Hi People,

I'm generating an "xlsx" file and it contains over 1 million lines, and I need to separate it into tabs inside the XLSX, how could I do that?

And I'm also having another problem ... when I try to render more than 1 million records the following error occurs.

{
  "message": "read ECONNRESET",
  "stack": "Error: read ECONNRESET\n    at TCP.onStreamRead (internal/stream_base_commons.js:162:27)"
}

My POST for http://localhost:5488/api/report

{
	"template": {
		"name": "excel"
	},
	"templatingEngines": {
		"timeout": 600000,
		"strategy": "dedicated-process"
	}
}

Posts made by odirleiborgert