Table with names of attached images

Question

Hi everybody,

I am struggling with a table that I am automatically creating from a csv (or json) file. The table displays just fine. In this table I have the name of an attached image and I also managed to actually show the image in each of the table cells.

Since these thumbnails are fairly small I would like to change it so taht if the image gets clicked it actually shows in full size. Just if I would add a usual image to a page as thumbnail.

Does anybody has an idea how I could get this working?

SELECT *,
FORMATWIKI("{cell:width=300px|height=200px}", T1.'EWSimage', "{cell}") AS 'EWSimage'
FROM T1

This part actually shows the image, but I am not faimilar enough with FORMATWIKI to get a popup working.

Stiltsoft support · Answer

Hi @Steffen Klein ,

We've discussed your question in the team and got an idea that maybe you are really on Data Center (not Cloud!) as @marc -Collabello--Phase Locked- has mentioned and you are trying to use markup.

!image.jpg|thumbnail! - The image is displayed as a thumbnail on the page (only works with images that are attached to the page). Users can click on the thumbnail to see the full-sized image. Thumbnails must be enabled by the site administrator for this to work.

Then to get thumbnails that are enlarged when clicking you'll use smth like this:

||heading 1||heading 2||heading 3||

|cell A1|cell A2|cell A3|

The image.jpg is attached to the page.

Now please take a look at the screenshot below:

The first table was created with the help of the markup given above and is wrapped in the Table Transformer macro with the following SQL query:

SELECT *,
FORMATWIKI("{cell:width=300px|height=200px}", T1.'heading 3', "{cell}") AS 'heading 3'
FROM T1

As you can see, both cells in the 'heading 3' column have the same size.

The second table was created using the same markup and it is not wrapped in any other macros. As you see, the cells in the 'heading 3' column are adjusted automatically by Confluence regarding of their contents.

When I click on the cell image (thumbnail), the full size preview opens for me in both tables (with and without the Table Transformer macro).

So, as I've mentioned before, the macro isn't supposed to prevent native Confluence features from working. And the FORMATWIKI function is used just to format your table, to adjust it and make it neat.

If this is your case, please don't use the macro and check if your thumbnails are working properly without it.

Barbara Szczesniak · Answer

@Steffen Klein Welcome to the Atlassian Community!

If you are actually using Cloud, rather than Server or Data Center, I'm not sure why you are creating the table from csv or json. Are you using these methods to attach the files to your page?

If the files are already attached to the page, you could use the Gallery macro or the Attachments macro. The Gallery macro shows images as thumbnails you can click on to show an expanded view.

Stiltsoft support · Answer

Hi @Steffen Klein ,

Not sure that I got the issue right: how are your images are displayed in your cells? What do you mean that you have links to your images? Is it smth like https://confluence.stiltsoft.com/download/attachments/121867046/image-2024-4-25_15-5-15.png?api=v2 (when you navigate to the Attachments section, right-click and Copy Link Address as...)?

For me in the Data Center environment such link opens a full size view and for Cloud it downloads the image no matter if your table is inside of the Table Transformer macro or outside of it. I've tested on a manually created table with inserted links.

From the SQL query I can see that you use it to set the specific width and height of your cells (for such kinds of formatting the FORMATWIKI is indeed usually used).

If you have a manually created table with inserted images, the Table Transformer macro doesn't prevent the full size view showing (both on Data Center and Cloud).

So, if you remove the Table Transformer macro, are your images being shown in a proper way?