Jump to content
You must now use your email address to sign in [click for more info] ×

Picture files names table of content -- how to?


Recommended Posts

Hello everybody!

I'm new to this forum as well as the Affinity Publisher.

I'm working on an art book, which is going to have about 80 pictures (art). I would like to create a Table Of Content (TOC) with titles of the pictures. The file names are titles. Is there any way to create TOC of picture-titles/file-names automatically in Affinity Publisher? If this topic/tutorial was already discussed on this forum, please point me to the right direction. I will greatly appreciate your help. Thank you!

Link to comment
Share on other sites

Hi @2fish and welcome to the forums.

You can create as many TOCs as you need, you just have to create a separate paragraph format for each TOC.

AMD Ryzen 7 5700X | INTEL Arc A770 LE 16 GB  | 32 GB DDR4 3200MHz | Windows 11 Pro 23H2 (22631.3085)
AMD A10-9600P | dGPU R7 M340 (2 GB)  | 8 GB DDR4 2133 MHz | Windows 10 Home 22H2 (1945.3803) 

Affinity Suite V 2.3.1 & Beta 2.(latest)
Better translations with: https://www.deepl.com/translator  
Need a system wide color picker? Try Microsoft's (New) Power Toys
Need a robust PDF Solution? Have a look at Stirling PDF

There's nothing you get used to faster than working slowly!

Link to comment
Share on other sites

Hi @2fish and another welcome to the forums,

If you download and take a look at the Publisher manual @MikeTO has created he goes into great detail about how to create a TOC on Pages 158 - 171.

Here is a link where you can download the manual in PDF format, hopefully, this will be a good introduction. If the titles physically appear in the text itself and have their own text style then you will be able to use these to create a TOC. As far as I'm aware filenames on their own won't be sufficient if they don't form part of the text.

Affinity Designer 2.3.1.2217 | Affinity Photo 2.3.1.2217 | Affinity Publisher 2.3.1.2217
Affinity Designer Beta 2.4.0.2279 | Affinity Photo Beta 2.4.0.2279 | Affinity Publisher Beta 2.4.0.2279

Affinity Designer 1.7.3 | Affinity Photo 1.7.3 | Affinity Publisher 1.10.8
MacBook Pro 16GB, macOS Monterey 12.6.8

Link to comment
Share on other sites

28 minutes ago, Hangman said:

Hi @2fish and another welcome to the forums,

If you download and take a look at the Publisher manual @MikeTO has created he goes into great detail about how to create a TOC on Pages 158 - 171.

Here is a link where you can download the manual in PDF format, hopefully, this will be a good introduction. If the titles physically appear in the text itself and have their own text style then you will be able to use these to create a TOC. As far as I'm aware filenames on their own won't be sufficient if they don't form part of the text.

Thank you Hangman for your help!
I have familiarized myself with the principal of creating TOC. My Idea is to have just pictures without any text/titles, but can be found by page numbers in TOC. Maybe, as you're suggesting, "the titles physically appear in the text itself and have their own text style" but be "hidden"? This way the pages have minimalistic look but function as intended. 

Link to comment
Share on other sites

If the amount of images is remarkable and the project is well planned, one option would be to use Publisher Data Merge to fetch the images and image file names from an Excel sheet. The field that picks the filename could then have a paragraph style with invisible fill color and the text field receiving the filename would be grouped with the picture frame so that it can be easily moved together with the image. 

Then, when you do the layout, you would copy the images from the generated merged image publication and position and size the images in the actual layout, and then create a separate TOC for the images. The following screenshot shows just the merged file where each image is on a separate page:

image.png.584ec259ed4824b8061e478c27758843.png

If you have lots of images, you could use the Merge Data Layout tool and merge e.g. 100 images per page and then copy paste the generated image packages (above the filename and image itself wrapped in a picture frame control and grouped in MyImage groups) into the publication layout. 

On Windows you can use Windows Explorer to copy filenames onto Clipboard (Ctrl + Shift + C, or Copy as path from the context menu) and then place in Excel sheet:

image.png.14381e655d20018c1f68a1f7a22e5a8c.png

You could of course use the same method to include whatever image data, as Windows is capable of showing lots of file related (e.g. EXIF) data as extra columns in context of filenames listed in Details view of Windows Explorer. [You would need e.g. the free PowerToys Text Extractor to grab text on screen in table format); for professional projects, I would recommend e.g. xplorer2]. When using an Excel sheet, you could also easily include image captions to be used in context of images. 

The following shows how captions could be added as Comments in Windows Explorer and then copy pasted onto an Excel sheet:

image.png.eead7efc8671e6811df61933b04e3219.png

You might be able to do something similar also on macOS.

Link to comment
Share on other sites

Here's a very easy way to make a TOC of images. I recommend using linked images instead of embedded to keep your file size low.

  1. For each of the 80 images:
    1. Copy the image to the clipboard
    2. Draw a text frame to accompany the image - make it larger than the image, at least temporarily
    3. Choose Heading 1 (or whatever heading style you want)
    4. Paste the copied image into the frame and scale it to the size you want it to appear in the TOC - if you don't scale it, the TOC will include it at full size
    5. Optional: Enter text to the left or right of the image
    6. Hide this text frame with Layer > Hide or by clicking the layer visibility toggle in the Layers panel
  2. Insert the TOC

If there's more than one image on a page of the book then of course you need only draw one frame per page.

I'm going to add this idea to my manual, it's kind of cool that you can do this.

Download a free manual for Publisher 2.3 from this forum - expanded 260-page PDF

Affinity 2.3.1 for macOS Sonoma 14.3, MacBook Pro 14" (M1 Pro)

 

Link to comment
Share on other sites

35 minutes ago, MikeTO said:

I'm going to add this idea to my manual, it's kind of cool that you can do this.

That is not working for me, Mike. (Only tested on Windows, and on .2212 so far.)

-- Walt
Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases
PC:
    Desktop:  Windows 11 Pro, version 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 

    Laptop:  Windows 11 Pro, version 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU.
iPad:  iPad Pro M1, 12.9": iPadOS 17.3, Apple Pencil 2, Magic Keyboard 
Mac:  2023 M2 MacBook Air 15", 16GB memory, macOS Sonoma 14.3

Link to comment
Share on other sites

56 minutes ago, walt.farrell said:

That is not working for me, Mike. (Only tested on Windows, and on .2212 so far.)

If the image isn't showing up in the TOC then you might have accidentally hidden the image layer instead of the text frame layer. Or you might have turned off "Include inline pins" in the TOC panel.

Here's a messy example. The images are embedded to make it easier to share but it's a tiny doc.

test.afpub

Edited by MikeTO
Added more detail

Download a free manual for Publisher 2.3 from this forum - expanded 260-page PDF

Affinity 2.3.1 for macOS Sonoma 14.3, MacBook Pro 14" (M1 Pro)

 

Link to comment
Share on other sites

7 hours ago, lacerto said:

If the amount of images is remarkable and the project is well planned, one option would be to use Publisher Data Merge to fetch the images and image file names from an Excel sheet. The field that picks the filename could then have a paragraph style with invisible fill color and the text field receiving the filename would be grouped with the picture frame so that it can be easily moved together with the image. 

Then, when you do the layout, you would copy the images from the generated merged image publication and position and size the images in the actual layout, and then create a separate TOC for the images. The following screenshot shows just the merged file where each image is on a separate page:

image.png.584ec259ed4824b8061e478c27758843.png

If you have lots of images, you could use the Merge Data Layout tool and merge e.g. 100 images per page and then copy paste the generated image packages (above the filename and image itself wrapped in a picture frame control and grouped in MyImage groups) into the publication layout. 

On Windows you can use Windows Explorer to copy filenames onto Clipboard (Ctrl + Shift + C, or Copy as path from the context menu) and then place in Excel sheet:

image.png.14381e655d20018c1f68a1f7a22e5a8c.png

You could of course use the same method to include whatever image data, as Windows is capable of showing lots of file related (e.g. EXIF) data as extra columns in context of filenames listed in Details view of Windows Explorer. [You would need e.g. the free PowerToys Text Extractor to grab text on screen in table format); for professional projects, I would recommend e.g. xplorer2]. When using an Excel sheet, you could also easily include image captions to be used in context of images. 

The following shows how captions could be added as Comments in Windows Explorer and then copy pasted into Excel sheet:

image.png.eead7efc8671e6811df61933b04e3219.png

You might be able to do something similar also on macOS.

Thanks a lot for your help! I have macOS, so will see what I can do with it. But it looks like exactly what I want. I'll work with it and report back. 

2 hours ago, MikeTO said:

Here's a very easy way to make a TOC of images. I recommend using linked images instead of embedded to keep your file size low.

  1. For each of the 80 images:
    1. Copy the image to the clipboard
    2. Draw a text frame to accompany the image - make it larger than the image, at least temporarily
    3. Choose Heading 1 (or whatever heading style you want)
    4. Paste the copied image into the frame and scale it to the size you want it to appear in the TOC - if you don't scale it, the TOC will include it at full size
    5. Optional: Enter text to the left or right of the image
    6. Hide this text frame with Layer > Hide or by clicking the layer visibility toggle in the Layers panel
  2. Insert the TOC

If there's more than one image on a page of the book then of course you need only draw one frame per page.

I'm going to add this idea to my manual, it's kind of cool that you can do this.

Thank you very much, that looks great! I'll work with it and see what I can accomplish, due to my little experience working with Affinity P. I'll report back. 

Link to comment
Share on other sites

This was a really fun example to add to the manual - it's cool that we can include images in a TOC so easily.

For the manual I also reversed the images and page numbers in the example using the option to do so in the TOC panel which provided a real-world example of when you might want to reverse the page numbers.

I wouldn't use this pictorial index approach myself, unless Serif adds the ability to alpha sort TOCs, a feature that is occasionally requested. ID has this feature and I think it would be useful for pictorial TOCs because there's no way to include a pinned image in an index. But if we could alpha sort a TOC, I could use this for something like a sculpture index. I'd have to include some text with the images to use alpha sorting but I'd need that for an index anyway.

So + 1 for alpha sorting of TOCs - I could easily add sculpture and symbol "indexes" to my history book using the TOC feature.

Download a free manual for Publisher 2.3 from this forum - expanded 260-page PDF

Affinity 2.3.1 for macOS Sonoma 14.3, MacBook Pro 14" (M1 Pro)

 

Link to comment
Share on other sites

4 hours ago, 2fish said:

Thanks a lot for your help! I have macOS, so will see what I can do with it. But it looks like exactly what I want.

Basically it seems to be supported similarly on macOS (though it probably is not possible to add data columns in the file system itself, similarly as on Windows). If you do not have Excel, you can use Numbers.

Here's a video demo on how you could do it (Full Path could be used if the image files are not in the same folder as the Publisher file where the TOC is to be created):

After having copy pasted each image group into the actual layout, you can create a TOC that uses ImageName paragraph style to fetch TOC page numbers for image locations in the publication.

You could easily use the same method to additionally autocreate e.g. square or ellipsoid miniature images to be used in context of TOC.

Link to comment
Share on other sites

@lacerto, it seems you did not need the folder path but the full image paths only. You can copy them directly from a bunch of selected files in the Finder  via right-click + option key:

copypaths.jpg.b8000278fae274eff035ed7159f9d672.jpg

macOS 10.14.6 | MacBookPro Retina 15" | Eizo 27" | Affinity V1 only

Link to comment
Share on other sites

9 hours ago, MikeTO said:

This was a really fun example to add to the manual - it's cool that we can include images in a TOC so easily.

For the manual I also reversed the images and page numbers in the example using the option to do so in the TOC panel which provided a real-world example of when you might want to reverse the page numbers.

I wouldn't use this pictorial index approach myself, unless Serif adds the ability to alpha sort TOCs, a feature that is occasionally requested. ID has this feature and I think it would be useful for pictorial TOCs because there's no way to include a pinned image in an index. But if we could alpha sort a TOC, I could use this for something like a sculpture index. I'd have to include some text with the images to use alpha sorting but I'd need that for an index anyway.

So + 1 for alpha sorting of TOCs - I could easily add sculpture and symbol "indexes" to my history book using the TOC feature.

 

5 hours ago, lacerto said:

Basically it seems to be supported similarly on macOS (though it probably is not possible to add data columns in the file system itself, similarly as on Windows). If you do not have Excel, you can use Numbers.

Here's a video demo on how you could do it (Full Path could be used if the image files are not in the same folder as the Publisher file where the TOC is to be created):

 

After having copy pasted each image group into the actual layout, you can create a TOC that uses ImageName paragraph style to fetch TOC page numbers for image locations in the publication.

You could easily use the same method to additionally autocreate e.g. square or ellipsoid miniature images to be used in context of TOC.

 

2 hours ago, thomaso said:

@lacerto, it seems you did not need the folder path but the full image paths only. You can copy them directly from a bunch of selected files in the Finder  via right-click + option key:

copypaths.jpg.b8000278fae274eff035ed7159f9d672.jpg

Thanks a lot for your help! I'm new to this app, so it will take me a some time to process it all and learn how to use it. 😀👍👍👍

Link to comment
Share on other sites

5 hours ago, thomaso said:

via right-click + option key:

Ah, thanks! It is good to be able to copy the mere filenames or the full paths so there is no need to do separation or combination in Excel.

2 hours ago, 2fish said:

Thanks a lot for your help! I'm new to this app, so it will take me a some time to process it all and learn how to use it. 😀👍👍👍

You're welcome. Data Merge is easily one of the most powerful features of Affinity Publisher and worth learning!

Link to comment
Share on other sites

Posted (edited)

Reporting back. Dealing with database looks too complicated for me at this point. I'll keep working on it, but for now this is what I did: 

  1. Created a master page with one picture frame per page. 
  2. Added pages and applied master page to them.
  3. Automatically populated picture frames with pictures.
  4. Created frame texts per image on a master page and assigned style Heading 2 to them.
  5. This is the most teddies: clicking on an image, I exposed a file name. I highlighted and copied a file name, and pasted it to its frame text. I repeated it with every image...
  6. Created TOC with Heading 2. All image names/file names appeared in TOC.
  7. In the master page, I made Frame texts invisible.

It would be great if Affinity comes up with a solution for creating frame texts from corresponding image names automatically. 

ScreenShot2024-01-05at12_44_45AM.thumb.png.5e6ebe73127445ee242153155e92c1d8.png

Screen Shot 2024-01-05 at 12.49.30 AM.pngScreen Shot 2024-01-05 at 12.42.28 AM.png

 

Screen Shot 2024-01-05 at 1.10.47 AM.png

Edited by 2fish
Link to comment
Share on other sites

1 hour ago, 2fish said:

Dealing with database looks too complicated for me at this point. I'll keep working on it, but for now this is what I did: 

Yes, it can be complex (and can support pretty complex configurations). That is often the cost of powerful features.

1 hour ago, 2fish said:

It would be great if Affinity comes up with a solution for creating frame texts from corresponding image names automatically. 

 

Yes, a badly missed and much asked feature.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.