general forum

• 

  XLSX odd error
  • AB-D

  6
  6
  Posts
  14606
  Views

  

  I apologize for not mentioning the actual typo. You got it right then.

  {{#xlsxReplace "xl/styles.xml"}} {#asset style.xml} {{/xlsxReplace}}

  This is actually older v2 syntax. Its still compatible with v3, but now we use the following
  https://jsreport.net/learn/assets

  {{#xlsxReplace "xl/styles.xml"}} {{asset "style.xml"}} {{/xlsxReplace}}

  However, virtually identical files with the extra curly bracket will also work.
  It also does not explain why the same file was working locally but not on the test server

  I have tried replicating the issue and getting some hypotheses why it works for you on one server and not on the other, but unfortunately, I don't know.

• I

  Heroku error
  • Ish Modi

  2
  2
  Posts
  5832
  Views

  

  Try the following
  https://stackoverflow.com/a/55090914/1660996

• 

  Create PDF from Word template - unoconv deprecated
  • SigTill

  3
  3
  Posts
  8240
  Views

  

  Since as of nov 12 2021 unoconv is deprecated. Its not a speed issue, more of a consern security-vice to be able to have the newer version that atleast have recent changes and are still being maintaned. Not sure if there are any added functionality. Would be nice to see where this upgrade is on the roadmap of jsreport.

  Thank you for the fast reply, great support as always for a great product!

• I

  413 request entity too large
  • Ish Modi

  2
  2
  Posts
  6495
  Views

  

  You need to configure your web server/nginx properly.
  https://www.cyberciti.biz/faq/linux-unix-bsd-nginx-413-request-entity-too-large/
  https://medium.com/@svsh227/error-413-request-entity-too-large-in-nginx-with-client-max-body-size-changes-in-nginx-6aacd525fe11

• R

  Missing Helper issue
  • rsemler6789

  3
  3
  Posts
  6342
  Views

  R

  Thanks so much for the quick response! The fix you recommended worked beautifully, and thanks for explaining the differences between v2 and v3 and how it handles the helpers.

• J

  New version of Jsreport V2 to fix the vm2 issue
  • JoeyLi-1

  3
  3
  Posts
  8326
  Views

  J

  Hahaha! Your reply is almost the same as I can expect. However, it is reasonable. The security issue can not be just ignored due to code check tool. I can try to use "overrides" of NPM to upgrade vm2 directly. Maybe we could upgrade to Jsreport V3 as well later.
  Thank you! Have a nice day! @jan_blaha

• I

  change the name of the pdf file
  • Ish Modi

  4
  4
  Posts
  12184
  Views

  

  @Ish-Modi it all depends on the pdf viewer you use, in the studio we use the standard pdf viewer which has the limitation I described.

  in your app, you don't need to use the same pdf viewer, although it is handy to let the browser handle the preview, it will have the same limitation. instead, you can check other pdf viewers which allow this customization. I think pdf.js is one of those that don't have this problem and will let you have a download button with a custom name. another solution is to add to your app a custom download button that triggers download from jsreport-client.

• H

  How to use each loop in header pdf util
  • Happy Patel

  2
  2
  Posts
  7326
  Views

  

  hi @Happy-Patel

  it looks your code is the right way, there are multiple ways you can simplify it, one way is that instead of adding pdf page item per property value, you just use a single call with all the properties. then in the header you are sure your data is in the 0 index, and can create just a single function for all your properties access.

  if you need to conditionally render something based on the avatar you can still do it in the header, from the main you can just propagate the avatar value (without the if) no matter if it is undefined or not

  here is a demo
  https://playground.jsreport.net/w/anon/EoeNYCW3

• R

  This topic is deleted!
  • Radhika14

  1
  1
  Posts
  12
  Views

  No one has replied

• S

  Create exe file using pkg
  • sahil12197

  3
  3
  Posts
  6586
  Views

  S

  As you suggested using the pkg tool it is hard to create an exe file, can you provide an alternative way to achieve my requirements?

  Thanks @bjrmatos26 in advance for your time and help.

• Z

  Custom node flags when launching JSReport via windows service
  windows server windows service • • zhwatts

  2
  2
  Posts
  6758
  Views

  

  I don't have a lot of experience with windows services..
  However, have you tried using environment variables like described here
  https://serverfault.com/a/1103091

• M

  Docker - Embedding assets as links dont work
  • mdudek

  2
  2
  Posts
  4460
  Views

  

  Thanks for the nice problem description. It is a bug. I've pushed the fix which we should release at the end of the next week. Please use assets without link encoding till then.

• 

  Free License
  license • • mvedana

  2
  2
  Posts
  5713
  Views

  

  Yes. The free license has no other limits than the template count.

• M

  Clone sheet and populate data
  • maverickbrown

  4
  4
  Posts
  7175
  Views

  

  I see yes.
  The thing is that in this case, the sheet includes references to other files that you need to clone as well.
  For example, the filters are defined in the xl/tables xmls. So you need to clone this as well and update the references.
  I know its tedious work, but we don't have API that could do this for you at this moment.
  You gonna need to unzip the xlsx and check the references in worksheets/sheet*.xml and clone the references xmls as well.

• 

  Syncing Errors using Azure Blob Storage
  • Rogier Doekes

  10
  10
  Posts
  16605
  Views

  

  I apologize. I've read the docs now and the maximum leaseDuration in azure is 60s which is the default. So we can't change this. Please skip the lock options.

  If the other configs won't help. Please check if you have the storage in the same Azure region as the app.
  Also azure provides low-latency premium storage, maybe it will work faster and eliminate the problem.
  Another option is to map some file system azure provides and use plain jsreport fs store.

• M

  AWS S3 template store with prefix
  aws-s3 templates • • Marcel-Schmid

  4
  4
  Posts
  9971
  Views

  

  The prefix config is now supported in @jsreport/jsreport-fs-store-aws-s3-persistence 3.1.0

  "fs-store-aws-s3-persistence": { "bucket": "...", "accessKeyId": "...", "secretAccessKey": "...", "prefix": "someBucketInFolder" .... }
• M

  feature suggestions/documentation improvements
  • MolallaComm

  3
  3
  Posts
  8182
  Views

  M

  Thanks for the example and reply. Turns out, we were still using 3.6.2 and while it had the component feature in the UI, i think it was maybe buggy. As soon as I updated to 3.11.3, passing parameters works as documented. Posting this just in case anyone else runs into it. Should have known to upgrade to latest before trying a new feature!

• B

  xlxs template - cell data-type is not defined by Excell
  • bstornext

  2
  2
  Posts
  6254
  Views

  

  This is defined in the cell s attribute which is a reference to the styles.xml.

  <row> <c s="1"><v>11</v></c> </row>

  You can either find out the right s value in an existing xlsx template you use or use xlsx helpers to update the styles.xml. Like here

  https://playground.jsreport.net/w/anon/nOIQZfMt

  {{#xlsxAdd "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row"}} <row> <c s="1"><v>11</v></c> </row> {{/xlsxAdd}} {{#xlsxReplace "xl/styles.xml" "styleSheet.cellXfs"}} <cellXfs count="2"> <xf numFmtId="0" fontId="0" fillId="0" borderId="0" xfId="0"/> <xf numFmtId="2" fontId="0" fillId="0" borderId="0" xfId="0" applyNumberFormat="1"/> </cellXfs> {{/xlsxReplace}} {{{xlsxPrint}}}

  As always with xlsx transformations, it requires you to check how the XML structure looks like inside existing xlsx files and replicate the same with xlsx helpers.

• H

  How can we restart page numbers
  • Happy Patel

  2
  2
  Posts
  5826
  Views

  

  If you use pdf utils to merge header with page numbers, you aren't limited and you can code any algorithm for page numbering you like.

• S

  This topic is deleted!
  • sahil12197

  1
  1
  Posts
  29
  Views

  No one has replied