Create image from SQL text

[Matabufalez]

Hello!
I would like to generate an image from a text string stored in the SQL database.

We are currently doing it with another application, but I would like to migrate that into Perspective.
This is one example. Each cell represents one position from the stored value.
i.e. 1=blue
2=green
3=yellow
4= purple

So, How could I do that? I have not seen this question in any thread, and with the default tools I am not able to represent it.
The strings's lenght are not always the same.

Thank you!
Thank you!

[bkarabinchak.psi]

Does it have to be an image? The example you posted looks like a table with equal sized rows/columns and background cell color configured based on data from your db. Could that work?

Also you should post an example of the data in your database. Does your data record the coordinates with the color or is your data literally just a string like blue,blue,blue,green,...

[JordanCClark]

Probably a heatmap would do.

Ignition Exchange

[victordcq]

this might be usefull too

Perspective - Best Way To Display Grid 10,000 x 384

The pypng library is a straight port. The attached script package has the pypng (png) library along with a couple of helper functions to process the DINTs to a list of lists suitable for pypng… File size stays about 480k test_graphics_2021-09-02_1214.zip (24.0 KB) import random # Randomized Sample Data sampleData = [random.randrange(0, 2**32) for j in xrange(120000)] # Process the DINTs to a list of lists suitable for pypng (single-bit depth) data, width, height = graphics.dint.processData(sa…

[JordanCClark]

I forgot about that one. I write a lot of stuff I forget about. lol.

I think we'll need a bit more information on what the output is supposed to look like with variable length input.

[victordcq]

took me a while to find it back, i bookmark to much stuff without adding any tittles to it xd

[Matabufalez]

@bkarabinchak.psi

Does it have to be an image? The example you posted looks like a table with equal sized rows/columns and background cell color configured based on data from your db. Could that work?

Also you should post an example of the data in your database. Does your data record the coordinates with the color or is your data literally just a string like blue,blue,blue,green,...

No matter what output is, but I need to get the colour map somehow, not necessary an image.
This is an example of the stored string:
5_____________________________________________________13__2_______________1________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________5

The underscore repreents blue, and the numbers the colour of the data.

Which one of the two solutions could be better for this application?
Heatmap or Pypng library?