Posts made by rohith-n-n

Thanks a lot, worked for me.
In my local environment, I'm able to successfully render a PDF with 12 charts distributed across two pages. However, when I attempt to replicate this within a Docker container, the output changes and I end up with each chart occupying a separate page. Is there any way to fix this?

#Use the jsreport/jsreport image version 4.2.0 as the base image
FROM jsreport/jsreport:latest-full

USER root

RUN npm i handlebars-intl --save
COPY --chown=jsreport:jsreport jsreport.config.json /app
COPY --chown=jsreport:jsreport /data /app/data

CMD [ "npm", "start" ]

I used this docker file and it works fine. But I was using the code you fixed related to preprocessing in xlsx https://forum.jsreport.net/topic/3030/change-in-file-type-after-importing-xlsx-file/6 post install. As I am not able to modify loop.js in node_modules inside docker, is there any way to get those changes now?

This is the dockerfile

Use the jsreport/jsreport image version 4.2.0 as the base image
FROM jsreport/jsreport:latest-full

USER root

COPY . .

CMD [ "npm", "start" ]

I am using jsreport latest docker image and mounted the data and configuration files to container. I am not able to render pdf because of below error

Could not find Chrome (ver. 121.0.6167.85). This can occur if either

1. you did not perform an installation before running the script (e.g. npx puppeteer browsers install chrome) or
2. your cache path is incorrectly configured (which is: /app/.puppeteer-cache).
   For (2), check out our guide on configuring puppeteer at https://pptr.dev/guides/configuration.
   Error: Could not find Chrome (ver. 121.0.6167.85). This can occur if either

#This is docker file

FROM node:18.19.0

WORKDIR /usr/src/app

COPY . .

RUN npm run setup

EXPOSE 9012

CMD [ "node", "server.js" ]

While running pdf template on docker container, I am getting below error. It is working outside docker.

Report "basicCharts" render failed.

Failed to launch the browser process! spawn /usr/bin/chromium-browser ENOENT

TROUBLESHOOTING: https://pptr.dev/troubleshooting

Error: Failed to launch the browser process! spawn /usr/bin/chromium-browser ENOENT

TROUBLESHOOTING: https://pptr.dev/troubleshooting

at ChildProcess.onClose (/usr/src/app/node_modules/@puppeteer/browsers/lib/cjs/launch.js:267:24)
at ChildProcess.emit (node:events:517:28)
at ChildProcess._handle.onexit (node:internal/child_process:290:12)
at onErrorNT (node:internal/child_process:477:16)
at process.processTicksAndRejections (node:internal/process/task_queues:82:21)

The issue was with the data migration. I created new data source for template and it works fine.

I have migrated jsreport from v2 to v4. When I run the charts template, I am getting below error.

Error when processing render request 2
(because) asset encoded as dataURI needs to have file extension jpeg|jpg|gif|png|svg|woff|tff|otf|woff2|eot
Error: Asset encoded as dataURI needs to have file extension jpeg|jpg|gif|png|svg|woff|tff|otf|woff2|eot
at module.exports (/home/rohith/veracode/js-report/node_modules/@jsreport/jsreport-core/lib/shared/createError.js:10:13)
at WorkerReporter.createError (/home/rohith/veracode/js-report/node_modules/@jsreport/jsreport-core/lib/shared/reporter.js:49:12)
at convert (/home/rohith/veracode/js-report/node_modules/@jsreport/jsreport-assets/lib/worker.js:53:24)
at /home/rohith/veracode/js-report/node_modules/async-replace-with-limit/async-replace.js:73:26

Here is the code which was used in v2 working fine:

var logoElement = document.createElement('img');
logoElement.setAttribute('class', 'col-sm logo');
logoElement.setAttribute('src', '{#asset {{logo}} @encoding=dataURI}');

The problem in the original file was executing formulas. During debugging I found many xml chunks throwing error. In each chunk I removed the formula mentioned in the last cell. In the below example(N17). After those changes I was able to render template.

Example xml chunk:
<calcChain xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><c r="B12" i="5" l="1"/><c r="B11" i="5"/><c r="B10" i="5"/><c r="B9" i="5"/><c r="B8" i="5"/><c r="B7" i="5"/><c r="B6" i="5"/><c r="B5" i="5"/><c r="B4" i="5"/><c r="B3" i="5"/><c r="B2" i="5"/><c r="B1" i="5"/><c r="M21" i="1"/><c r="L21" i="1"/><c r="M20" i="1"/><c r="L20" i="1"/><c r="M19" i="1"/><c r="L19" i="1"/><c r="E19" i="1"/><c r="D19" i="1"/><c r="M18" i="1"/><c r="L18" i="1"/><c r="E18" i="1"/><c r="D18" i="1"/><c r="M17" i="1"/><c r="L17" i="1"/><c r="E17" i="1"/><c r="D17" i="1"/><c r="F17" i="1" s="1"/><c r="E16" i="1"/><c r="D16" i="1"/><c r="F16" i="1" s="1"/><c r="E15" i="1"/><c r="D15" i="1"/><c r="F15" i="1" s="1"/><c r="M14" i="1"/><c r="L14" i="1"/><c r="N14" i="1" s="1"/><c r="E14" i="1"/><c r="D14" i="1"/><c r="M13" i="1"/><c r="L13" i="1"/><c r="E13" i="1"/><c r="D13" i="1"/><c r="M12" i="1"/><c r="L12" i="1"/><c r="E12" i="1"/><c r="D12" i="1"/><c r="M11" i="1"/><c r="L11" i="1"/><c r="E11" i="1"/><c r="D11" i="1"/><c r="F11" i="1" s="1"/><c r="M10" i="1"/><c r="L10" i="1"/><c r="E10" i="1"/><c r="D10" i="1"/><c r="M9" i="1"/><c r="L9" i="1"/><c r="L15" i="1" s="1"/><c r="E9" i="1"/><c r="D9" i="1"/><c r="E8" i="1"/><c r="E23" i="1" s="1"/><c r="D8" i="1"/><c r="C4" i="1"/><c r="D23" i="1" l="1"/><c r="F9" i="1"/><c r="N9" i="1"/><c r="F10" i="1"/><c r="N10" i="1"/><c r="N11" i="1"/><c r="F12" i="1"/><c r="N12" i="1"/><c r="F13" i="1"/><c r="N13" i="1"/><c r="F14" i="1"/><c r="F18" i="1"/><c r="N18" i="1"/><c r="F19" i="1"/><c r="N19" i="1"/><c r="N20" i="1"/><c r="L22" i="1"/><c r="N21" i="1"/><c r="F6" i="1"/><c r="L23" i="1"/><c r="N6" i="1" s="1"/><c r="F8" i="1"/><c r="N17" i="1"/></calcChain>

I tried to replicate the same issue but I am not able to perform B5=SUM(B2:B4). I have updated xlsx template. Please check.

Thank you!!

I used the code you have pushed to master, previous error is resolved. But now I am facing below issue

Invalid character in entity name
Line: 1
Column: 4873
Char:
Error: Invalid character in entity name
Line: 1
Column: 4873
Char:
at error (/home/js-report/node_modules/xml2js-preserve-spaces/node_modules/sax/lib/sax.js:651:10)
at strictFail (/home/js-report/node_modules/xml2js-preserve-spaces/node_modules/sax/lib/sax.js:677:7)
at SAXParser.write (/home/js-report/node_modules/xml2js-preserve-spaces/node_modules/sax/lib/sax.js:1491:13)

Thanks a lot @bjrmatos. When can I expect release?

Here is the playground link https://playground.jsreport.net/w/rohith-n-n/2arq~FiC

Hi, previously I was having v2 of jsreport and this was working fine. Now I have migrated jsreport to v3. When I am trying to run now, its giving me this below error,

Error while executing xlsx recipe
(because) error when evaluating engine handlebars for template anonymous
(because) parse error on line 11:
...iginalFormula=''Raw Data'!B2'}}</f><v>0<
-----------------------^
Expecting 'EQUALS', got 'INVALID'
(sandbox.js line 124:18).

The error is coming because in Raw Data (sheet) data is not getting populated.
I tried one thing, created new excel sheet and uploaded it, this time data got populated in the sheet. But this was just test xlsx file.
The v2 xlsx template is bit complex and creating new one similar to it is difficult so I want to use v2 xlsx template only and populate data. Can you please help me in this as I am stuck here.

Thank you!!

I created blank excel sheet and imported, I am able to put the data in xlsx template. But If I use old template it is not working. Is there any way to migrate old xlsx template as it contains more data and it is very complex to create new template similar to old one. Can you please help?

Thank You.

I migrated jsreport version from v2 to v3. Handlebar files are migrated to html, but when I import xlsx template, content type changed from .html to .xlsx. I am not able to preview template after importing.

Error while running the template. Failing during xlsx transformation.

xlsx generation was finished rootId=afgcssie77y8tl, id=afgcssie77y8tl
info: xlsx transformation is starting rootId=afgcssie77y8tl, id=afgcssie77y8tl
error: Error when processing render request 5
(because) invalid character in entity name
Line: 1
Column: 4327
Char:
Error: Invalid character in entity name
Line: 1
Column: 4327
Char:
at error (/home/js-report/node_modules/xml2js-preserve-spaces/node_modules/sax/lib/sax.js:651:10)
at strictFail (/home/js-report/node_modules/xml2js-preserve-spaces/node_modules/sax/lib/sax.js:677:7)
at SAXParser.write (/home/js-report/node_modules/xml2js-preserve-spaces/node_modules/sax/lib/sax.js:1491:13)

I migrated jsreport version from v2 to v3 and then v3 to v4. Few templates are working fine, but I am facing parse error while running few templates. When I use v2, I am able to download report.

Error while executing xlsx recipe
(because) error when evaluating engine handlebars for template anonymous
(because) parse error on line 11:
...iginalFormula=''Raw Data'!B2'}}</f><v>0<
-----------------------^
Expecting 'EQUALS', got 'INVALID'

(sandbox.js line 124:18).