@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

hi! an example of what you are trying to do is available here https://playground.jsreport.net/w/admin/QiHIBqsq

i guess what you are missing is configuring your chart source to be dynamic, this can be done using excel formulas, check this for a description of the steps to get there https://jsreport.net/learn/dynamic-excel-pivot-table#excel-template

knowing that you will find that the template on the playground example is using this formulas to work and the html-to-xlsx just create the table based on data, so everything combines

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

hi! yes the image also accepts base64 input but in the shape of a base64 data uri, see this example that uses base64 data uri for the image.

hi!

This function cannot be caller directly in a {{#each }} clause like this:
{{#each getFlattenedControlpointArray}}

yes, this is expected, you are passing here a function to the each, which expects an array, if we translate this to javascript execution it will look like this

// it won't do nothing because it expects array to iterate
each(function getFlattenedControlpointArray () {}) 

In order to actually call the function I have to fake a parameter like this
{{#each (getFlattenedControlpointArray 1)}}

in this case your are executing the getFlattenedControlpointArray function the ( and ) are needed for handlebars to execute functions/helpers when we are in the execution of another helper (the #each)

if we translate this to javascript execution it will look like this:

// this time it works because it is executing the `getFlattenedControlpointArray` and passing the return to the each
each(getFlattenedControlpointArray(1)) 

FYI you don't need the pass a fake parameter, it also works with this {{#each (getFlattenedControlpointArray)}}

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

Is this a bug or have I misunderstood something?

it is how the handlebars syntax works, in case you need here is link to handlebars docs that explains this

hope this makes things more clear to you

@nisarg170 I see, but just for clarification, this is a different case for what this thread was open for.

there is no built-in support for multi-tenant support in jsreport, but it is possible by using custom extension code, we do this for example for the jsreportonline service which fetch different parts of our database depending on the tenant that has a session.

the code for this is public and you can check it here

Can you please elaborate the first option?

this option basically means you keep jsreport as simple as possible, just create and design templates in a way that can work generally for all tenants and that templates expect that you just send the data and they will replace such values. you will just need to call jsreport with the data the specific template you want to render needs, how to prepare that data will depend on your app code (means that in your app you will handle the specific logic to query different tenants data/database).

hi! such warning about the invalid source map was fixed since jsreport 3.7.0, which version do you use? perhaps you just need to update to latest version.

@osh-zuri hi! I already have the m1 hardware so I was able to test this.

First, jsreport is only available for the standard linux/amd64 (this means that on Apple Silicon hardware the jsreport docker images should be executed using an additional param --platform=linux/amd64), for an arm build subscribe here for progress.

the thing is that the chrome browser which is shipped on our images does not work on Docker + Apple Sillicon, it needs that we install chromium browser instead and specify some config for jsreport to use that runtime. we already know the steps involved to support this however we decided to do it the next time we update our internal Chrome version (which should be the next minor version probably), subscribe here for updates about it.

thanks.

hi @ABoudreault94 the issue with the survey.jquery.v1.0.68.min.js is that it contains some text that looks like handlebars blocks, so handlebars tries to process it.

the easiest fix is to use the handlebars raw blocks to mark that the asset content should not be processed by handlebars

{{{{rawContent}}}}
        {#asset survey.jquery.v1.0.68.min.js @encoding=utf8}
{{{{/rawContent}}}}

function rawContent (options) {
    return options.fn()
}

see updated playground demo