general forum

• 

  JSreport sometime generate an error font
  • Ngô Duy

  11
  11
  Posts
  242
  Views

  

  The thing is that jsreport doesn't deal with fonts or pdf printing. Both are done by chrome which we have no influence on. So unfortunately I have no clue.

  If you are able to print a pdf with a single letter that is wrong like you mention and email it to me. I could take a look inside if I find out something.

• A

  Snowflake integration issue
  • Anandanr

  2
  2
  Posts
  37
  Views

  

  Your code badly mixes callbacks with async/await promises.
  The beforeRender already finishes, but your callbacks to connection.execute haven't been invoked yet.
  Try to take your code outside the jsreport into a plain nodejs file and debug it to get a better understanding. This isn't about jsreport but proper javascript coding. You need to set to req.data before the function beforeRender actually exits.

• T

  Disable SSL verification
  • tyler-shuhnicki

  2
  2
  Posts
  25
  Views

  

  Does this config help?

  "extensions": { "extensions": { "chrome-pdf": { "launchOptions": { "args": ["--ignore-certificate-errors"] } },
• A

  Missing helper: "asset" (jsreport-core)
  jsreport-core asset missing-helper • • agus-gabrielli

  4
  4
  Posts
  66
  Views

  

  Sorry, typo. It should be jsreport-assets

• A

  Xlsx chart from the html table
  • AqMarek

  4
  4
  Posts
  90
  Views

  

  @AqMarek there is no snippet when it comes to this example, generating a chart from scratch (i mean with no previous chart created in the document itself) is a bit complex. the main and general approach we take to deal with these kinds of rich objects in docx, xlsx is that we expect these objects to exist in the document, as part of the template and in runtime we just configure it or tweak it to achieve the desired result in the final document.

  this approach works really well and it seems it works for all the users so far (i mean i just remember just a few moments users wanted to generate something from scratch without it existing in the document itself). is it something stopping you to use this approach? i mean creating a xlsx document that works as a template and that in runtime we just process it to get the desired output, this can be done by using the xlsx recipe (not the html-to-xlsx recipe), like this example

• R

  How to change jsreport logo to our own logo
  • reshmajacob93

  8
  8
  Posts
  159
  Views

  R

  Ok sir .Also sir i have one doubt ,

  Our Application is Multi-Tenant Application so each client have their own folder in jsreport studio for keeping their templates and also one global templates and global Helper (where we use to store templates and helpers common for all client}.This is our folder structure in studio. Right now we are developing our application in development and later on we will deploy those global folders and global helper to production so how to export only specific folder (global folder and global helper) from Development (jsreport studio) to Production (Jsreport studio) .

  Folder structure in Development is like this,

  Folder Structure in Production is like this,

  We are using mongo db for storing templates. Right now we are exporting the whole templates from dev to production (By right click on the studio then it will generate an export file) and manually change the client templates in production but it is very hectic work.Is there any other way to deploy only specific folder from dev to production?

  So,

  If i export only global templates and global helper from dev to production should i have to manually change the parent shortid of this imported global folders from dev in production and manually assign the root folder short id of production folder?

  Could you please suggest me any solution about how to deploy templates from development server to production ?

  Is exporting templates from devdeopment to production is the right way for deployment?

  Right now we are keeping export file for backup in our respository. Suppose if while importing old export file to production due to any eror and if it can't be able to import old export .So in such case how to view the content of export file?
• S

  Azure app service with docker, timeout when waiting for worker
  • srijken

  8
  8
  Posts
  149
  Views

  

  The 3.8.0 contains all kinds of things...
  https://jsreport.net/blog/release-380
  https://github.com/jsreport/jsreport/releases

  The 3.8.0 default image includes updated chrome and the updated alpine base image.
  In our experience chrome in some versions isn't working as it should. Sometimes its performance degrades for example.

• R

  How to throw error from jsreport engine if it fails to render report (Rendering async report)?
  • reshmajacob93

  4
  4
  Posts
  248
  Views

  R

  Thank you sir

• S

  Umlaut symbols rendered as �
  • sergikoff

  12
  12
  Posts
  141
  Views

  

  Yes, a full database is typically better for multi-instance in prod.

  I've tried to replicate the problem closely to what you write, but without success.

  I've done the following, please try the same or try to isolate the problem.

  Dockerfile

  FROM jsreport/jsreport:3.5.0 RUN npm install @jsreport/jsreport-postgres-store

  Running it

  docker run -p 5488:5488 -e store_provider=postgres -e blobStorage_provider=postgres -e extensions_postgresStore_host=host.docker.internal -e extensions_postgresStore_port=5432 -e extensions_postgresStore_database=jsreport -e extensions_postgresStore_user=postgres -e extensions_postgresStore_password=password myjsreport

  Export from playground your shared workspace
  Import fully into running app

  From the postman/advanced rest client, I send the following request

  { "template": { "name": "body.html" }, "options": { "reports": { "save": true } } }

  Then I open back studio, check stored reports, and the encoding is correct.

• E

  How to add image to excel report?
  • Eugene-Hodasevich

  2
  2
  Posts
  163
  Views

  

  html-to-xlsx recipe doesn't support images.
  We have this feature in the backlog if you want to upvote it or follow it.
  https://github.com/jsreport/jsreport/issues/711

  You need to use the xlsx recipe until it gets implemented.

• R

  how to return pdf from dynamic xml file content
  • RjSingh1529

  2
  2
  Posts
  34
  Views

  

  I'm sorry but I don't get what you mean.

  Do you have random XML content and do you want to convert it into pdf?
  How that should look in the end?

• 

  How is jsreport-fs-store-aws-s3-persistence helpful in jsreports?
  • Vishnu Menon

  2
  2
  Posts
  39
  Views

  

  That is a big jump from 1 to the latest. You will need to migrate first to v2 and then to v3.

  Here are the migration notes for v2
  https://jsreport.net/blog/jsreport-v2-released
  https://jsreport.net/learn/v2-breaking-changes
  Note to install v2, just update your package.json and set a v2 version and run npm i

  Here are the migration notes for v3
  https://jsreport.net/blog/jsreport-300-released
  https://jsreport.net/learn/v3-migration-guide

  You may have it easier if you, while still in v1, export from s3 to the local fs store and perform the update with fs.

  And if you don't have hundreds of entities, you may have it easier to start with v3 from scratch and just copy-paste the entities' contents.

  If you want to use s3 as the template store, here is the latest doc
  https://jsreport.net/learn/fs-store#aws-s3

  Good luck!

• D

  Jsreport getting down
  • Dhurba123a

  6
  6
  Posts
  131
  Views

  D

  Okay, Thanks. We'll check

• 

  Clickable image in subtemplate (merged) doesn't work
  pdf-utils chrome-pdf • • Marián Horňák

  4
  4
  Posts
  161
  Views

  

  It's published now
  https://jsreport.net/blog/release-380

• D

  How to handle if the src given in docx Hyperlink image is not available.
  • Dhurba123a

  4
  4
  Posts
  82
  Views

  

  yes, right now it just throws an error, there is no special handling on this. perhaps we can consider implementing some kind of fallbackSrc when this happens, but this can also be done right now using helpers.

  here is link that shows how to implement a custom fallback https://playground.jsreport.net/w/anon/qM203vEC

  you need to update the helper call in your hyperlink to be like this

  and in your template have this helper:

  const jsreport = require('jsreport-proxy') const axios = await jsreport.npm.require('axios@0.24.0') async function docxImageWithFallback (options) { const src = options.hash.src if (src.startsWith('data:')) { return src } try { console.log('sending request...') const response = await axios({ url: src, responseType: 'arraybuffer', method: 'GET' }) const contentType = response.headers['content-type'] || response.headers['Content-Type'] if (!contentType) { throw new Error(`Empty content-type for remote image at "${src}"`) } const extensionsParts = contentType.split(';')[0].split('/').filter((p) => p) if (extensionsParts.length === 0 || extensionsParts.length > 2) { throw new Error(`Invalid content-type "${contentType}" for remote image at "${src}"`) } // some servers returns the image content type without the "image/" prefix imageExtension = extensionsParts.length === 1 ? extensionsParts[0] : extensionsParts[1] imageBuffer = Buffer.from(response.data) imgDataUri = `data:image/${imageExtension};base64,${imageBuffer.toString('base64')}` } catch (err) { imgDataUri = 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAK8AAAAtCAIAAABXiKzxAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAgdSURBVHhe7Zj9T1NXGMeX/brsD1iWJZtZtv2wDbVoeRNqQUFaaXlTQJGIjGWmugW2xfoSDA6WaRHHL84tEzZXnNJoeNFVnVQddQhVpC6jikuj7iaGGg3l7fJ2u3PPObf3lRYEEmTnk/7Afc5zzrnP83w5L/clFYHAQdRA4CFqIPAQNRB4iBoIPEQNBB6iBgIPUQOBh6iBwEPUQOAhaiDwEDUQeIgaCDxzpoaCgoL6+vqurq7e3t47d+40Njbu2LFjxYoVuJnwIjAHatBoNC0tLQElXC6X0WjEfoQFz2zVoNVqwUqAi69En8+Xk5ODvQkLm+dXg1qtXhWfcOHiJVz2QKCnp8disezcubO8vLy9vR1bA4F7vb3xCQm42/SxOH2039NUjB9faEw2t4+GyaAcJdi2AHkeNSQb0nWH618/+XdOWx/DMDDIQENDw8qVK7EHBCgDNQG+qjmKrdPH6gb5oxxm/PgCU+b0gRz4KZfDbq8tw8aFyIzVkF2y99XmJ69cGHj5/MBpahwVu7u7WyIFxNmzZ5HDH3cfLI+KxdZFR5MXhOhtwk8yzKwYaHctflzAzEwNEQWfvtE6+NrlwSWND3WVP3j+fYyKfeDAAewhBlw0kMPQREC9q3pZbDxuWFyEUYPF5Qcrg8uCHxcwM1DD8ui49073vNU6pG74S7s2OTo6+vFjrIbCwkLsJCYpKam/vx84gO3E2DnyZuOj94t24bawSJKoN1tdFLBA/D6PvUKPGrCf3UmxOzPXQehO+71Bb1Q6j13QSrmsJtyIMFmdXj/a5lHfXNwgm6uVfRYgkwScjScYjr7C7vFxfcEeYjVz76cUj0xuwtzgv2324Dv7KWdNLohCOQEhmJ4aIiMjUrOWln3/4bXhJVeGDfls7WNiYh49eoRmKy0tRY4S0tPTR0dHgcPo+ISx3f/O1eG3rwxn7/4aN4dGGLFKb/WAUGmfG2y9dgc6kvmccA+Gfiy0z+v1upvYg4apyQs80E5tB6XlvYP18XudbJsHDgXWcS5ZxbArbnaghIK3QM3Sub4pLjGbzQ4KWMAJx2w2BXWDyTWZzVY3G4jbCtpLiuE4aBiagtGgV6C9TViSCvGEVwPrDofDbxzwA2mg+PkYYNdQhFdDanpmwonrS9tGVM6RiLaReNsd3KBStbW1sRMHAi0tLdgkprq6Gjl4HzyMztj0wU8dy50j7/7er98gzZoCwohRPig7VzIkDr+rAvyNshEsGAAUFHoH/+NNsF4eK/s3bBN6ozMeZUeXlxr27CpsRsISKU/YzCIrlhhRIIBiO1QP/3p6NKzHBkdVmGMaahBFywYktNSioNhshSSMGlKNGZG/UcucdPR1Ouri4whHv/4YX/iKigp2WsiuXdItIC8v79mzZ6j151MNwLJ89Vr1uQcRTjq1xoZ8QiFKIiqSR7CgBhH5sehh8lDtMfAgh3zkpdPD6iATzJvPKbrICGyyuSAzU0OxQJocQpvCHOHVIPKH7vy/DoC1yF5bThg1JB9vXXF9NMbxVL19rypmlVqTpE1ag9tUKnB06OnpATMDxsbGamtrjUZjXFxcSkrKwYMHg1IYGhrKyMxCXaLKvov5c3TNuX/UajWyTIk4SpPVDRUPTD6v21FbJt3L+VChQQHko1A62AGVW7Gw0AhLJc88i2InHkknxTEEr6DQLptA6CP3l78Pa5FOqUAoNaxLM0a1DSZ2jMWXKqwx4L6wf/9+i8WCzokIcEro6+sbHh7GzxCwhOA+QA0ffaHpGFt/zbdaq8WmqZBHmWuqsTndXnz6AjsxXNxlftBAw31fhM3C+iuUDnaYWg1o7fi/q2Fz8faEjvH0GwNxyTps4jh06BCYEDAwMHDmzJngcVICTdOVlZW4DyS2tHJN57ihlYqNi8OmqRBGyR7GBEc0vRkWSHBuEIaKl120C8uQp2px7hRzrYaNW4sSXRMZXWMJxg3YBBF+ZAR0dnYmJibW1dVRFDU5OYmMT548aW5uzs7Oxn041py8kXxzIuOkEz+HQBil1QPG5G4FLDB9qFGeDTM8RvmcgkuVyWa3oTMHTBVwD7ahI+YMTpGiuVhmpoZpnSLFc0hNehubD2yQ+8+LGjTaxJSrPuPtyaRv+UNfVVUVmEpIR0cHaoqMjNTpdLm5uQaDQfFYoCk/lg5Gc01uKtmNTSEQRYnyhe9k+M5Iu2tkfgicXtrngdsFusP5XTUFoA2mKtjmcHO3eq784W+YsrRCBdGUi9uMJMg7iaJRvGFK5oAziC/FQR+5/7yoAZBXdXzdLSa7m1n346WYAtPnh4/C9+AZZQL7jp1Iyy/MKtqesfVjw5ZthvxC45Zt4G9gwb9tn2z+sizt1/asbib9NrPpl8t49NBIohR9r6FBYrhPRkrZk7jDj1V4n4Gpohyz+vokTavJ5kGDgfUImwQodQr/9Uk8B/CH/wGcu4Mvr9x/vtQQFR2db2013GYyu5nP7jI03gcw40zgyINAyi0mtYvRhfyt72I2uJmNbialrjV21fS+T0+R+dkiTxWBI4waAGDNz9t3UH/uXnnPEBIBYmxi4si9wYyOwfybQ2F/m9ufZto6taY9YDvB44YFqoFyKCy9s4KoYWrCqyHIulTd/fv3kRTATdK8Z49mtXZtcsp0fgkaDR5lWpTV4q/P+GgwlxA1TM0M1ABIS0s7derU+fPni4qKsGlegBUDu7BbsqHPBUQNUzMzNRAWN0QNBB6iBgIPUQOBh6iBwEPUQOAhaiDwEDUQeIgaCDxEDQQeogYCh0r1H3rynmXRZBCKAAAAAElFTkSuQmCC' } return docxImage.call(this, { ...options, hash: { ...options.hash, src: imgDataUri } }) }
• 

  PDF cannot display the correct charset even utf8 was set at html meta tag
  • oppaweb

  5
  5
  Posts
  6257
  Views

  

  Dear @bjrmatos
  How about Debian and Centos ?
  I'm facing JSREPORT generate &nbsp become Â

• F

  Scheduling module is recovering a running schedule?
  scheduling • • fmmich

  8
  8
  Posts
  2633
  Views

  

  Thank you for isolating the problem.
  I verify this is a bug, I've fixed it now and we will ship the fix with the next release.
  I apologize for the inconvenience.

• M

  How do I call a component via its' shortid?
  • msageryd

  4
  4
  Posts
  102
  Views

  M

  That's great!
  I was looking for an API like this, figured it should exists somewhere.

  Is there any documentation for tha jsreport-APIs?

• R

  Instalation of JSREPORT
  • Richzao

  2
  2
  Posts
  92
  Views

  

  You can just hit enter and let it fill the default 5488.
  But installing jsreport app into c:\windows\system32... can cause all kinds of permission problems. I recommend installing it in a normal directory.

• M

  Syntax for calling helper function from {{#each ..}}
  • msageryd

  3
  3
  Posts
  99
  Views

  M

  Of course, I should have thought of that.
  Thank you for explaining.