Generate screenshot of a dashboard chart for a PDF

General
, , ,
1

Good morning, I have been looking for a way to take or remove the image of a chart from my dashboard and have that image inserted into the structure of the PDF that I am putting together, I have searched for information and nothing in particular has helped me with what I want to achieve. do,
I wanted to ask you if you had any knowledge of this process that you could share with me since I made a flow that crashed the node red and I had to format it, I am from scratch, I have used the node-red-contrib-web-page-screenshot library, but It crashes when it is with ID or Class, and without selecting normal it only takes a gray screen,
I apologize for the inconvenience in advance and I appreciate any possible documentation you may provide me with.

2

Did you try a forum search,? There was a question like this asked in the past few days.

1 Like
3

If I explored most of the forum with those solutions, some do not fit what I am looking for or want to achieve and other topics are still not resolved and are like me, that is why I proceeded to open a topic to see if anyone else would have any information on another page, to gather documentation, sorry for the inconvenience.

4
  1. what version of Node-red and node.js are you using?
  2. what platform are you running NR on?

If I understand you, you currently have a graph on your dashboard but you want to put that chart in a pdf. This might help you Generate chart images in Node-Red for email or chat messages (flow) - Node-RED

It might be worth a try to see if you can adapt it for what you want to do.

1 Like
5

I was not able to take a screenshot of a specific flow but I was able to take a screenshot of the entire dashboard, which for me is something, thanks to you for the information provided my dear colleague, I share the example flow with you, it is not very well organized but it works perfectly, in case anyone is looking for a solution that will help them,
What I did was convert the screenshot into base64 and store it in a global variable, and in the pdf format that I have, I called the global variable so that I could attach it there, without further ado, I would like to thank you for your help.

imagen_2024-02-23_125432133
imagen_2024-02-23_1254321331234Ă—391 33.5 KB

flow:

[
    {
        "id": "fa1432119f33bbfb",
        "type": "inject",
        "z": "67c61941.053d58",
        "name": "",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "",
        "payload": "",
        "payloadType": "date",
        "x": 420,
        "y": 1500,
        "wires": [
            [
                "08d8e18d7ce7c0ee"
            ]
        ]
    },
    {
        "id": "08d8e18d7ce7c0ee",
        "type": "puppeteer-browser-launch",
        "z": "67c61941.053d58",
        "timeout": "7000",
        "slowMo": 0,
        "headless": true,
        "debugport": 0,
        "devtools": false,
        "cookies": "",
        "name": "",
        "x": 620,
        "y": 1500,
        "wires": [
            [
                "2671441d86f84188"
            ]
        ]
    },
    {
        "id": "e17eeca2886e7d9e",
        "type": "puppeteer-page-goto",
        "z": "67c61941.053d58",
        "name": "LINK",
        "url": "http://127.0.0.1:1880/ui/#!/21?socketid=H38GHI0t_eSHpxjMAAAL",
        "urltype": "str",
        "waitUntil": "networkidle2",
        "x": 610,
        "y": 1380,
        "wires": [
            [
                "89479f5b9ca016a9"
            ]
        ]
    },
    {
        "id": "89479f5b9ca016a9",
        "type": "puppeteer-page-screenshot",
        "z": "67c61941.053d58",
        "name": "",
        "fullpage": true,
        "x": 130,
        "y": 1240,
        "wires": [
            [
                "363b82550dbd1544",
                "65ba01c8108db452"
            ]
        ]
    },
    {
        "id": "2671441d86f84188",
        "type": "puppeteer-page-viewport",
        "z": "67c61941.053d58",
        "name": "",
        "width": "1920",
        "height": "1000",
        "scale": 1,
        "x": 620,
        "y": 1440,
        "wires": [
            [
                "e17eeca2886e7d9e"
            ]
        ]
    },
    {
        "id": "3749cf6b2b9cbcea",
        "type": "puppeteer-browser-close",
        "z": "67c61941.053d58",
        "name": "",
        "x": 820,
        "y": 1320,
        "wires": [
            [
                "029730d8083b07b0"
            ]
        ]
    },
    {
        "id": "363b82550dbd1544",
        "type": "function",
        "z": "67c61941.053d58",
        "name": "Select Last Value",
        "func": "msg.topic = \"SELECT * FROM plc.oee_kpi ORDER BY Fecha DESC LIMIT 1;\";\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 170,
        "y": 1400,
        "wires": [
            [
                "ba45e10e55eb771c"
            ]
        ]
    },
    {
        "id": "ba45e10e55eb771c",
        "type": "mysql",
        "z": "67c61941.053d58",
        "mydb": "fb05e811b8b0da75",
        "name": "",
        "x": 330,
        "y": 1400,
        "wires": [
            [
                "33f2686f507a65bb"
            ]
        ]
    },
    {
        "id": "33f2686f507a65bb",
        "type": "function",
        "z": "67c61941.053d58",
        "name": "FORMATO DE TABLA",
        "func": "//datatime\nvar time = new Date().toLocaleString(\"co\");\nvar imagePath = global.get('image')\n\n\t// Ahora 'data' contiene el contenido de la imagen en un Buffer\n\n//Average/Valor Promedio\nvar a = msg.payload[0][\"Tipodefalla\"];\nvar b = msg.payload[0][\"Turno\"];\nvar c = msg.payload[0][\"Tiemposdeparada\"];\nvar d = msg.payload[0][\"Tiemposdereparacion\"];\nvar e = msg.payload[0][\"Tiempodearranque\"];\n\n\n\nmsg.payload = {\n\tpageOrientation: 'LANDSCAPE',\n\tcontent: [\n\t\t{\n\t\t\timage: 'data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBxIPEBUSEBAVFRUWFxgXFxcXFRUVFxgYFhUWFhUVFxgYHSggGBonHRYXITIhJikrLi8uGB8zODMsNygtLisBCgoKDg0OGxAQGy8lICYrMi0tLTctLi0tLS0tLS0tLS0vLS8tLS0tLS01LS0tLS0tLS0tLS0tLS0tLS0tLS0tLf/AABEIAHIBuwMBIgACEQEDEQH/xAAbAAEAAgMBAQAAAAAAAAAAAAAABQYBBAcDAv/EAEUQAAEDAQQECQoEBAYDAQAAAAEAAhEDBBIhMQUGQVEWIlJhcYGRkrITMjM0U3JzobHBBxRC0RUjwtJDYoKi4fBUs/Ek/8QAGgEAAgMBAQAAAAAAAAAAAAAAAAQBAgMFBv/EADURAAIBAgMEBwgCAgMAAAAAAAABAgMRBCExEkFRkRQyYXGh0fAFEyIzUoGxwRXhQvEjJDT/2gAMAwEAAhEDEQA/AOuaU05Rszg2qXSRMBpOExj8+xanC+y739wqB/ED1hnwx4nqsrm1sXONRxVshadWSk0jonC+y739wpwvsu9/cK52iy6bU7OX9lffyOicL7Lvf3CthuslnOTiehpXM19UapYZH/1RLG1rZW5f2WjXe86Zwhocp3dKcIaHKd3Sqcx14AjIrKX/AJOv2cn5jFy4cIKG93dK3LbbGUWhzyYJgQJVDKtetfom+99imaOOqzpVJO14pW+9+3sJPXhDQ5Tu6VjhBQ3u7pVQRLfylfs5PzAttTWSg3ZUPQwleHDCy739wqtrwtFnDxjnsKtH2pV3pcn5lJbW4tfC+y739wr7o612Vxi+5vO5rgFzmrTLSQc1hbrHVOzl/Zh76R1uy2unWaH03hzTtH0O48xWyuR2C3VLO+/SddO3cQDMEbQul6F0m21URUEA5ObM3Xbvv1p3D4lVcnkzWnUUst5m2aVpUXXXkzE4AnNePCGhynd0qE1k9Yd0N+ii1zq/tCtCrKKtZPg/M1Lfwhocp3dK27FbWVgXMmAYMiFRFZtVaguvbIvAgkbYIgGN0g9hWmEx1SrVUJWt67QLAiIuuBq261so03VKhhrcznmQB8yFE8L7Lvf3CvXXL1Kr/o/9rFzZI4nETpz2Y20v4swqVHF2R0ThfZd7+4V92fWizVHtY0ulxDRLCBJMAT0rnC29C+s0fiM8bVhHGVHJLLl/ZRVpXOlW7SlOg4NeTJE4CcJj7HsXhwhocp3dKi9a/Sj3B4nqDWWIx9WnVlCNrLsfmNFv4QUN7u6V51dZ6DcxU6QwkKqL6WS9qVuC5PzIdyycMLLvf3CnC+y739wqoWuxh2LRDvqokhbQ9oVJK+Xj5mE6k4uzOl2bWay1P8W7jHHBb8zhCladRrgHNIIIkEGQQcQQRmFyBSmgtNPsrxBJpk8ZmzGJIHKW9PHO9pr7hGv9R1BF42eu2o0PYZa4SCNoXsukMBRVt07Z6JIdVBIwLW8YggwQYyPMVBa5acLT+XpOIP8AiESDiAQ0HoMkjo3qmEpGvjNl7MEYVK1nZHReF9l3v7hThfZd7+4VzpZS/TavZyfmZ+/kdE4X2Xe/uFblj03Rq5OLZyvgtntVCsVjjjOGOwbv+VurB+06ieST5+YxBy/yOiIqxq/pQtIpPPFODTuOxvQrOuth68a8NqP3XBlzQ0npOnZmh1UkAmBAJM5qO4X2Xe/uFan4gehp+8fCVRktiMTOFTZVhepVlGVkdE4X2Xe/uFS1gtjK7A+mZaeYjHaMVyVdF1J9Tb7z/Epw2JnUnsytp5E0qspSsyfRET5uEREAEREAUH8QPWGfDHieqwulaY1eZa3h73uaQ0NhsRgSdo51ocCKPtan+39lzK2FqSqOS39orOnJybRRFlXrgRR9rU/2/so7TmqjaFI1adRzrvnNcBiJAkEREYnIrGWFqxV2vEo6UkrlVWUWEuZkpox8sjcfrit1fOqNkZXe9jnEG7eEbYMH6hWrg1T5bvkqLBVavxRtbvHaTvFFVcrXrX6JvvfYrHBqny3fJb+krCK7Q1xIgzhG4jb0pujg6sKVWLSvJK2fC/mXsUhFaODVPlu+ScGqfLd8kt/G1+C5gVdFaODVPlu+ScGqfLd8kfxtfguYFJ0nSlt7aPooxX/SmgKbKFV95xu03HZ+lpI+ioCn3E6K2ZitZfFcKxak2407R5Mni1BEf5hJafqOvmVdX3RrGm5rxm0hw3S0zB5sFaE9iSlw9MzjLZdy8a1+lb7g+rlCqb1sYfKMdsLYHSHGfEO1QiwxytiJ9/6Q+FP6ojGp0M+rlAKa1WeRVcJwLThvIIj5EowLtiIetU0QWpERemJIHXSqG2N4P6nMA6Q8Ox6mlc5V819qgWdrYMufI3cVp/dUNcjGv/l+yFK/WMKS1bpB9rog8u91tBePm0KNUxqjTLrZTgebeJ6Lrh9wsKSvOPevyZxV5IsetfpR7g8T1Cq4aR0Q2u+85xGAGEbCTtWvwap8t3yVsTga1SrKUUrN8R8q6K0cGqfLd8k4NU+W75LH+Nr8FzIKuonSVKHXht+qv3Bqny3fJQuteh2UKAeHOJvgYxtB5uZSsDWp/E0rb8zOqrxZUUWEQJl21Ct5cx9Fx83jN6Dg4dRg/wCrmVj0nbBQovqH9Iw5zk0dZIVB1OrllrYMeOHNOMbCZO/zVNa/WohtOkDnLjiNmDZHSTjzLo0azjh296y8hqE7U78CmPqFxLnGSTJO8nMr5RFzRUyt3R1lnjkYAwN16AY6QCD1rTYwucGtEkkADeSYA7V0t2h2tsootGLRIO92ZPWZ7VpChKrGWzuXjwNqMbu/AqaIRCLmDQBV20XavLUg6QXZOjlDfu2HrVJVh1UreeyNzuvIz8uwroezamzW2eK/GfmSa/4gehp+8fCVRlefxA9DT94+EqjJnGfOfchOt1wui6k+pt95/iXOl0XUn1NvvP8AEjA/M+37RNDrE+iIuwNhERABERABERABaGmqN+z1WzEsOPQJ+y31raR9DU9x3hKrJXViGro5IVhZWF55HPLJqF60fhu8TV0Fc+1C9aPw3eJq6CuxgvlfdjdDqhEUXp/SoslK/F4khrRMSc8+gFMykoraehq2krslEXP+Gto5FLsd/es8NrR7Ol3Xf3pbptL0mZe/iX9Fz/hraORS7rv7k4a2j2dLuu/uU9MpcfAn38C6aVeG0KpLbwFNxLZiQGnCdk5Lk6lNJ6fr2kXXuAbgbrRAw6yT1lRaQxVaNWScdxhVmpPIwsOyPQfovpSOgNH/AJm0NYRLfOdhIug4g9OA60uoub2VvM0ruxbdaWuijexgODnAQ29xMgSSJgkDHLPfAq060MJpNOEB2PWCBHWVVlX2krYhvjZ+Fv0dBhb+gal20MwzJ+YIWgs03lpBESDInKRiJ7EpTnsTUuDT8SDoaLzpPDgHAyCAR0HEL0Xru4kpX4g1+NSpgjJziNuJAaejA9ip6mtb7T5S1v3MhowjzRj08YuUKuHiJbVWT7RGo7yZlWPUSjNpLp81h65ICrat/wCH1KXVX4yA1vNxi4nr4o7VOGV60SaSvNF1WVW9ZNYjZXCnTYC8tDpd5oBJEQMSeKd2YzUHw1tHIpd13966c8VThLZb8GMyqxi7M6AioHDa0ezpd1396xw1tHs6Xdd/cq9MpcfBlffwOgKta9uH5YCcS9sDoBlQnDW0cil3Xf3qH0lpSraSDVdMZAAACTsA+uaxr4uEoOMd/reVnWi4tI00WEXNFiX1V9cpdJ8Dl665Wi/a3YyGBrctwkjtcVu6h2K9VdVIwYIB2XndWwfUKv6Tr+UrVHyDL3EERBEmCI5oTDyoLtlfkjR5U+9musLKJczLDqRYvKWi+cqYnrdIaM/e7F0KFWtR7GGWc1I41R26OK0kNHOPOPWVZSuzhIbNJduY7SVolL07ZvJV3AZO4w65n5grQUtrHbW1agDcQ0ETvM4xzYZqJXnsSoqtLY0v68S4Ujq/Uu2huGcjtH/Cjl6WWpce1xE3XAx1gqlKWxUjLg0wJX8QPQ0/ePhKoyvP4g+hp+8fCVRl1cZ859yFK3XC6LqT6m33n+Jc6XRdSfU2+8/xKcF8z7ftE0OsT6Ii642EREAEREAEREAFq6R9DU9x3hK2lq6R9DU9x3hKhgcjCysBZXnY6HOLJqF60fhu8TV0Fc+1C9aPw3eJq6CuxgvlfdjdDqBVbX/0DPif0uVpVW1/9Az4n9LlriPlS7i1XqMoiwiLiCRlFuWTRNes2/TpOc2YkRmOkr6r6Fr0xL6RaMpMZ7s1Li0tprLju56Ftl8DRRbH5B+4dq9qejj+p3YsnUjxJVOT3GpZ6LqjgxjS5xMABdH1c0KLIw4zUdF84xhMNbzCTjt+ld0NaRZXS2m04QSQL0bQHRIyGGWCsNLWKkYvBzd5gEdGBn5JzB1sOvik7Pt9WGadLZzepuaZp3qD8BgL2P8Alx7YBVKV9p1G1WSMWuG0bMsQVRLRSLHFpzBjs2qntSOcKi0at+1zzND5REXKAt2r1pv0QNrOL1Zj5fRb1stIpU31HZMaXHqEwOdVfVy1+Tq3Tk+G9f6fqR1r017t92m2iDi7jO90ZT0nwlegw2J/6209Y5ffd+iJS2VcpNWoXuLnZkknpJkr4WUXOEAug6j0btlnHjPcccIiG4d1c9aCcgSdgGJPMF1rRtm8jSZTw4rQDExIGMTzyncBG82+C/JvQWdyla/est+E3xvVbVl199Zb8Jvjeq0scR82XrcZ1OuzCysKRpaCtLmhzaDiCAQZbiCJBzWSi3orlUm9CPRSfB+1f+O//b+69KGrNqf/AIJb7xaPurKlUf8Ai+TJ2ZcCIW3orRr7VUuUxzuJyaN5/barFo7Utxxr1I/ysxOzNxEbxgD0q3WSxsotuU2Brdw++9M0sHKTvPJeJrCi3qa1Giyx2chokU2uccgXEAkk85hcsAXVNP1Qyy1ieQ4d4XR9VysqcdZOKW5evwFfcgsrC+6LZcBzhIt2MCy2PSFWi0NZUgARGBHPAIKVrdVeCHVCQcwSY7MlrwkJJ1pNWcnbvduVzoGUX3QoOqGGNLjzY579y+HCDBVd19wBAUQIegErr069Z6JO109rZVKVz1qaX2Gk/ccetpAVMXYxTvUvxSYpW6xhdD1IeDZAAcQ9080mfuueq1al6TZRZUZUMCWuEAkkkEOmPdb2lRhakYVLydlYKLtIvSKL/j9Dlnuu/ZY/j9Dlnuu/ZdLpdD64815jhKoor+P0OWe679k/j9Dlnuu/ZHS6H1x5rzAlUWtZLYysCWOmDB2EdRWytoyUldO6AIiKwBaukfQ1Pcd4StpaukfQ1Pcd4SoYHIwsrAWV52OhziyahetH4bvE1dBXPtQvWj8N3iaugrsYL5X3Y3Q6oVW1/wDQM+J/S5WlVbX/ANAz4n9LlriPlS7i1XqMoaIi4gkdE1G9UHvu+ylNJ2TytMt25t5iMv261F6jeqf63fZWFdmlFSoqL0aH4dVHOnNjAiPksq16Y0OK3HZAft2B3TzqsWizPpmHtLTz/bf1Lz2Iws6D+LNcd39ffxJPNfK+l8pcC86H9Azo+5UBrNZrtW+Bg4f7hgflB7VP6H9Azo+5WdJWMVqZac82ncdnUvR1qPvsMorWya77Iko6L7tFB1Nxa4QQvMmMSvOvLJkHy5wAk5BRFutbq1Q1HmSftgPkvS22q/gPNHzWomqUHFZitWe07IIsr6o0nVHBrGlziYAGZK0MSZ1RsHlrSCQS2nxjukeYO36FdICi9X9Fiy0Q3C+cXnn3TtAyClV2sNSdOFnrvHacNmJz/X31lvwm+Koq2rJr76y34TfFUVbXMxHzZetwrU6zC6xof1al8NnhC5OV1fQvq1H4TPCEx7P1l9v2a4fVm6iIumMhERAETrSf/wAdXoHiC5gui68eqH32fVc6XJxrvUXd+2KV+sZW3omkX16QaJN9m2MnAn5Baak9W/W6Pvj6FKwV5LvX5RktUdLfZmOMljSTtLQSsfk6fs2d1v7LYRd/ZR0DAC5/XPGd0n6ldBVE0m0Cs8AQLx8RXK9rK8YPt9fgDWREXEIJ7S1DymjcBN1oeMeS7jHqF5UBdO0AwOsrQcQb4PQXOXPdK6PdZqrqbgcPNPKbsI3/ALyuxWTdOnU4xX4F68dGaa2LBVuv5jh+y8ESzV1YwTs7lgRalitV8QfO+q20k007MeTTV0ERFUknNU3fzHjZd/q/5KtCq2qfpX+79wrSvRezf/Ou9/kkIiJ8AvOtSD2uacnAg9BEL0RAFS4EU/bO7rU4D0/bO7rVbUS/RaP0/nzM/dQ4EDoXVtlkqGo2o5xLS3EACCQTl0BTyItYQjBWirIuopKyCjNOaJba2BjnFsOvAiDsI29Kk0UyipKz0BpNWZUuA9P2zu61OA9P2zu61W1Fl0al9KKe6hwNHRGj22akKbCSJJk5knNbyItoxUVZaGiVgvOrTa4Q4AjcRK9EUvMCKraDou/QW4zgT2QcAOgLwqat0z5r3DsP2U4iWlg6EtYLlb8AeFloCmxrASYESvdETCSSsgNS22GnWHHbJ2EYEdf2UJatUW1D6ZwGwQ3/AKVZkWU8PSnLalFX4kNJqzKlwHp+2d3WpwHp+2d3Wq2oo6NS+lFPdQ4FTZqRSBxqvI3Q0fNTOi9DUbMP5bcTm5xlxz27BjshSaK0KFODvFJEqEVogiKJ0lpunZnhj2vJInihsYkjaRuVp1IwV5OxrCEpu0VdnhpvVxlrqCo57mkNu4AEEAkjP3io/gPT9s7utUlX1iosa1wD3h14cUDAtiQbxHKC9qWm6DqRqX4DYkEcYE5CBn1JfZw85PRvXUHhZdZxZEDUinONZ56mqy2WiKbGsbMNaGic4AAE9ijbJrDQqvuAuaZgFwADs8scOuM15VdZ6THOYWVJa4tMBkS0kGONlgphPDwW1FpJ5XLRws07KOepPIoCrrRRY5zSypLSQYDI4pIw43MvurrJQa8M4xmOMA0tE5g4zhtgLTpNL6kW6PV+lk4ijaelqbqrqcHiNvl5u3C2GmQZn9Y2b1qDWagX3ePHLui7053vkpdemtZL/REaFSWkXxN7S+jxaaRpucWgkGRGYPOoHgPT9s7utU5R0rSdVdRBN5u+IdhPFM44Lyo6ZpvovrBrg1hgg3ZJhpAEGMbwGazkqE3eVm8/DXkZyw7ebjw8dOZEcB6ftnd1q99HapU6FVtQVXOLTIBDQt+lpyk6i6tDgGEAggXpJAGRjEkbV6u0qwWfy9113dxb3nXd8Z86qoYdfEraX+y39xHRWn1d9vvwJJFBWfWWg+ZD2gCZcBvAjik44r30ZpulaDdbea7YHQCeiCR1Z4LWOIpSaSkjWVCpG7cXkSyhLToBtR7n+UIvGYgbc/ms23WClRqGm5r5EYgNjEAz507dy9K+nKLaQqi89pddhoEgwTiHERkqVfcVfhnZ2z7iPc1LJ7Lz0Nbgyz2juwJwZZ7R3YF5u1toyP5dXHmp4YEyePzR1qcs1UPY14mHNDhOcETisYYbCTyikwqUp0+srHxYbKKNMMBJAnE85k/VeOk9GUrS27VbMYggwQSIwP2OCj2a1USQA2piYBhkdPnSt2w6Xp1nPaA5pZnejEAwSIJw/wCFvCdFpU4tW0sTOhUiryjkQ9TUmkSbtVwGwQ0/NfPAin7d3dat86yUrrnBtQhrg3ANxvBxDhLsuIefLBbNk03Rqtc4Ei6284OEEDqwPUdoWUY4WTsrevTM5YOUVdwZDjUen7Z3datmnqqBnXcRztb9VI6N0tTtDXOaHNDPOvwIBEzIJEYHsWqdZrPfu8eOXd4uXTe+SiVPCWTklZ6Exws7tRi7rU+eDLfau7AnBlvtXdgW/wDxJnlm0gCS5t4OEXYgnOZybuWi/WSkG3iyp5xbENnAAk+dEYhQ8PhI6pePreuZaNGo9E/X+iR0dYG0Gw3EnN207luqM0VpZlpvXGuF2JvXf1TEQTySpNNUdjYXu9N1isouLtJWYREWpUIiIAIiIAIiIAIiIAIiIAIiIAIiIAIiIAIiIAIiIAIiIAIiIAKp6wU3OtlMMDS4sEBwBb+vMHBWxeRpNJvXRIyMCe1YV6PvVFXtZ38Gv2a0anu23a+TRSLToh1B1EcU1Hnbi3AsDGmc8Se1ar6D3se8ZhxvtbgGjY6BskkYZLoL6LSQS0EjIkAx0blgUGgkhok5mBJnOSl5YGLyTy/q3Pf23t2jUcc1qs/7vy3eJTtLWqlaKdNlnpRUkZMA/SQW4Z4kdhXnSouq2urSY9oeTUeLzQ4FrKl12JBiDUb0zzK5U7HTYS5tNoJzIAByj6L7ZZ2B14NaHY4gCcTJx6h2K3RHKW1N8stE0t/aU6XaOzBc896fDsKK6oG16sva3+Y7NgfPHdzGFi1Ppte80iQ0uBuPZnBvDqzOMYYYq9GyUznTZ3QvipYqbnBzqbSRgCWhUeDk7/Ete3LXttv4d5dYyN84vmuzsvu45bim1g6o6qWtxNGkbrRgIFncYG4DYvu0Wug6zMp06f8AN4gJuCZHnG9mZI2b1dBSaDeDROUwJ7eoLzbZKbXXhTaHbw0Thl9VaWElnaSzunlxb0zXEhYuOV46Wtnw4lCZY6orFgJNRgvbzLQ0wN5EjsXsysfygpNBJfVOABMgMpwMM8SMFexRaDeuid8Ce1fDbJTBkU2gjc0KvQmr2lrfx/dsnzJ6de146W8Ch33U2VaTmFgeGkB0jFtRrh50ZgO6SAFvO0lT/IihJvzuw9Jez6FcKlnY4y5jSecA/VfP5Sn7NndH7KeiSV1GWqa03PMjpkXa8dGnrvRSbPWp+Tc2o+ZYAAxgDg4FpEmBeiN+K2NX6sWhjWgPBESWQ5oAcc9hyxxzzVvbZWDJjRswaFiz2SnTm4xrZMmABKmOFkpRe0su+/5fr7WiWLi4tJPPtXlcqmkarGaRLqolgiRF7OlAw6SFoWhoNOq9jSGOqtu4Rsqm71AhXx9mY4y5jSd5aCUNBhF242BkIEdnWolg3Ju7ybb04qxMcYopfDuS14O5z+1VWmnF5rnXmkQwNgBrw4TAnEtw5lbtB6Sp1GNptJvMptkERkA0welb/wCUp+zZ3W/svSnQY3zWNHQAPotKVCdOW1tLk/y22Z1sRCpHZs+a/SSOeaLfBHHa3FubA6ejAwtplhq1HPdSnF5puAnJ8yT/AJcPort+Vp+zZ3R+y+2UWtm60Cc4AErKGBslGUslwuv3bkjWWNTbcY693kc8aIo1RufT8NdbmlLFUoi/VLWufxQ1kAXQBeJAER5ojee26/lafs290f8Adp7V9PpNMEtBjKQDHRuQsD8Nm+7m3+yXjs01Hvz7vIoVO9TL6YpuYalO7ddIJyOEgE3rrgBtJjFZNtYKTabaLSbrrziJfeLnEEOiQBgY6tivjqLSQS0EjIkAkbcCvCrYKT3FzqTSSIJIEkHNDwcllGXhu19buzQFjIvrR8d5U7FWbQqWeo/zfJuMtE+c6rhhtF4SNhUfaR/JaYzqVI2TxaeSv9Wx03tuOptLRkIEDGcNy+jZmEAFjYGQuiB0bkPBSa2drLu7vIOmxvtbOffuz88yE1VdJq8drvMyZcjz88BKsS8qdJrfNaBO4AfReqcpQcIKLd+fG++78ROrNTm5JfjhbdZeAREWhmEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAEREAf/2Q==',\n\t\twidth:50},\n\t\t{text: 'Curso: Interfaz MySQL con PLC vĂ­a Node-RED', style: 'header'},\n\t\t{text: 'Tema: GeneraciĂłn de Informes en pdf', style: 'header'},\n\t\t{text:'Reporte generado el: '+time+' \\n\\n' },\n\t\t\n\t\t'Ahora puede generar informes personalizados de sus datos en Node-RED. Este es solo un informe de muestra generado para explicar la funciĂłn. Se puede personalizar el informe segĂşn sus preferencias.',\n\t\t{text: 'Valores del mundo real de la tabla de la base de datos MySQL llamada `plc.tanklevel`', style: 'subheader'},\n\t\t'La siguiente tabla muestra los valores provenientes del PLC',\n\t\n\t    {text: 'Valores PLC', style: 'subheader'},\n\t\t{\n\t\t\tstyle: 'tableExample',\n\t\t\ttable: {\n\t\t\t\tbody: [\n\t\t\t\t\t[{text:'OEE_ME', style: 'tableHeader'}, {text:'RECHAZO', style: 'tableHeader'}, {text:'ENERGIA_ACTUAL', style: 'tableHeader'}, {text:'AIRE_ACTUAL', style: 'tableHeader'},{text:'GAS_ACTUAL', style: 'tableHeader'}],\n\t\t\t\t\t[\"\"+a+\"\", \"\"+b+\"\", \"\"+c+\"\",\"\"+d+\"\",\"\"+e+\"\"]\n\n\t\t\t\t\n\t\t\t\t]\n\t\t\t},\n\t\t\t\n\t\t},\n\t\t{\n\t\t\timage: 'data:image/jpeg;base64,\"'+imagePath+'\"',\n\t\t\twidth: 700\n\t\t},\n\t\t\t\t\t\t\n\t\t\n\t\t\n\t\t\n\t\t{text: 'Hardware usado', style: 'subheader'},\n\t    {\n\t\t\tul: [\n\t\t\t\t{text: 'Siemens S7-1200 con OPC UA'},\n\t\t\t\t{text: 'PLC Ethernet cable'},\n\t\t\t\t{text: '24VDC Power supply'},\n\t\t\t]\n\t\t},\n\t\t\n\t\t\t{text: 'Software usado', style: 'subheader'},\n\t    {\n\t\t\tul: [\n\t\t\t\t{text: 'TIA Portal v17'},\n\t\t\t\t{text: 'IOT', color: 'purple'},\n\t\t\t\t//{text: 'Prototipo'},\n\t\t\t]\n\t\t},\n\t\t\n\t\t/*{text: 'VisĂ­tenos (Hipervinculado)', style: 'header'},\n\t\t{\n\t\t\tul: [\n\t\t\t\t//{text: 'Escuela de aprendizaje electrĂłnico', color: 'purple' ,link: 'http://learn.codeandcompile.com' },\n\t\t\t\t{text: 'YouTube', color: 'purple', link: 'https://www.youtube.com/channel/UC4rqWPxMnjbOAhKfbse-5Wg/featured' },\n\t\t\t\t{text: 'Instagram', color: 'purple', link: '' },\n\t\t\t]\n\t\t},*/\n\t\t\t{\n\t\t\ttext: '\\n Este documento se genera Ăşnicamente con fines de capacitaciĂłn. Los datos dentro de este documento no provienen de ninguna fuente comprometida. Para cualquier informaciĂłn contactar con Soporte',\n\t\t\tstyle: ['quote', 'small']\n\t\t}\n\n\n    ],\n    \tstyles: {\n\t\theader: {\n\t\t\tfontSize: 18,\n\t\t\tbold: true,\n\t\t\tmargin: [0, 0, 0, 10]\n\t\t\t\n\t\t},\n\t\tsubheader: {\n\t\t\tfontSize: 16,\n\t\t\tbold: true,\n\t\t\tmargin: [0, 10, 0, 5]\n\t\t},\n\t\ttableExample: {\n\t\t\tmargin: [0, 5, 0, 15],\n\t\t\talignment: 'center'\n\t\t},\n\t\ttableHeader: {\n\t\t\tbold: true,\n\t\t\tfontSize: 13,\n\t\t\tcolor: 'black'\n\t\t},\n\t\t\tquote: {\n\t\t\titalics: true\n\t\t}\n    \t}\n};\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 400,
        "y": 1240,
        "wires": [
            [
                "0666a43e7b8d954e"
            ]
        ]
    },
    {
        "id": "029730d8083b07b0",
        "type": "file",
        "z": "67c61941.053d58",
        "name": "",
        "filename": "C:\\Users\\Cristian Torres\\Desktop\\Reportes\\Informe.pdf",
        "filenameType": "str",
        "appendNewline": true,
        "createDir": true,
        "overwriteFile": "true",
        "encoding": "none",
        "x": 1000,
        "y": 1240,
        "wires": [
            []
        ]
    },
    {
        "id": "0666a43e7b8d954e",
        "type": "pdfmake",
        "z": "67c61941.053d58",
        "name": "",
        "outputType": "Buffer",
        "inputProperty": "payload",
        "options": "{}",
        "outputProperty": "payload",
        "x": 660,
        "y": 1240,
        "wires": [
            [
                "029730d8083b07b0"
            ]
        ]
    },
    {
        "id": "585ccd1f08c8c921",
        "type": "function",
        "z": "67c61941.053d58",
        "name": "function 199",
        "func": "global.set('image', msg.payload)\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 450,
        "y": 1200,
        "wires": [
            []
        ]
    },
    {
        "id": "65ba01c8108db452",
        "type": "base64",
        "z": "67c61941.053d58",
        "name": "",
        "action": "",
        "property": "payload",
        "x": 260,
        "y": 1200,
        "wires": [
            [
                "585ccd1f08c8c921"
            ]
        ]
    },
    {
        "id": "fb05e811b8b0da75",
        "type": "MySQLdatabase",
        "name": "",
        "host": "127.0.0.1",
        "port": "3306",
        "db": "plc",
        "tz": "",
        "charset": "UTF8"
    }
]

Note: this flow uses puppet which uses chrome or chromium so if you plan to use this same flow in a different browser it will not work for you.

6

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.