Jump to content
Our response time is longer than usual currently. We're working to answer users as quickly as possible and thank you for your continued patience.

Convert Publisher pages into Photo documents or groups


Recommended Posts

Hi everybody,

I've searched for a similar question but I haven't found it. It's even difficult to express the topic exactly in a title.  I hope I did nothing wrong and that I'll make myself clear as this is not my language.

I'm painting some boards in Affinity Photo. I have to make 31 and I have to put 90 different labels on each for a total of 2790 different labels. Data merge feature in Publisher will help me populate the labels quickly. The problem is that I can't find a way to import them in Photo (and I'm not that much into Publisher yet). Actually I have found several ways but not the practical one I'm looking for, since Publisher cannot export pages separately in Affinity format, while importing an .afpub into Photo won't give you the chance to separate pages as you can do with PDFs. I came up with this:

  • Dragging/placing the .afpub file in Photo document will show only one page. To have all the 90 labels displayed I should duplicate the layer 89 times and select the right page for each. Too long to repeat 2790 times.
  • Copying/pasting every page in a new group in Photo would be at last as long as the previous method.
  • Exporting every page in a raster format would prevent any further edit. It's not that I really need it, but if I'd need I should go back to Publisher and export/import again. Also I'd prefer to deal with text and shapes until the end.
  • A more viable approach would be to export every single page in PSD format, but  having to rely on an external file type instead of the proprietary one sounds cumbersome to me. Also there could be inconsistencies too.

Any ideas on how to import quickly all Publisher document's pages into Photo as individual embedded documents or groups?

Link to comment
Share on other sites

I'm not sure I understand what you're doing, but Photo can Open a .afpub file. True, you can only see one page at a time, but you can navigate from page to page using the page selector on the left edge of the Status Bar at the bottom of the workspace. Wouldn't that accomplish what you need?

-- Walt

Desktop:  Windows 11 Home, version 21H2 (22000.613) 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 
Laptop:  Windows 10 Home, version 21H2 (19044.1706) 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU.
        Affinity Photo 1.10.6 (.1665) and 2.0.0 / Affinity Designer 1.10.6 (.1665)  and 2.0.0 / Affinity Publisher 1.10.6 (.1665)  and 2.0.0
iPad Pro M1, 12.9", iPadOS 16.1.1, Apple Pencil 2, Magic Keyboard

      Affinity Photo 1.10.6 and 2.0.2 / Affinity Designer 1.10.6 and 2.0.2 / Affinity Publisher 2.0.2

Link to comment
Share on other sites

Just now, walt.farrell said:

I'm not sure I understand what you're doing, but Photo can Open a .afpub file. True, you can only see one page at a time, but you can navigate from page to page using the page selector on the left edge of the Status Bar at the bottom of the workspace. Wouldn't that accomplish what you need?

Thanks for your reply, but I already knew that. I'll try to be more specific. I'll create the labels in Publisher with the help of data merge that will output a new 90 pages document (one page for any label). In my Photo document I need to place and distribute all the 90 labels, so all the 90 pages. As I said, If I import the afpub (basically all Affinity formats are the same if I recall correctly) into Photo, I should duplicate the embedded document 89 times and set each of the layers to show a different page to have all the 90 different labels on my board. That's pretty time consuming considering I should repeat it 2759 times to complete all my boards.

Another approach would be to use the Data Merge Layout Tool to create all the labels in a single page, but since their background will change too (I have 6 different colors) I should edit them nonetheless. Maybe faster but not as much as I'd like. With the other method I could set 6 master pages to differentiate the background.

 

Link to comment
Share on other sites

53 minutes ago, Clau_S said:

I'll create the labels in Publisher with the help of data merge that will output a new 90 pages document (one page for any label). In my Photo document I need to place and distribute all the 90 labels, so all the 90 pages.

I don't understand. Are you saying that you want all 90 labels on each of the 90 pages of the document or something else?

Regardless, can you explain why you need to do whatever it is that you want to do in AP instead of in APub?

Affinity Photo 1.10.5, Affinity Designer 1.10.5, Affinity Publisher 1.10.5;  2020 iMac 27"; 3.8GHz i7, Radeon Pro 5700, 32GB RAM; macOS 10.15.7
Affinity Photo 
1.10.5.280 & Affinity Designer 1.10.5 for iPad; 6th Generation iPad 32 GB; Apple Pencil; iPadOS 15.7

Link to comment
Share on other sites

4 minutes ago, R C-R said:

I don't understand. Are you saying that you want all 90 labels on each of the 90 pages of the document or something else?

Regardless, can you explain why you need to do whatever it is that you want to do in AP instead of in APub?

Sorry if I wasn't clear. I have to make 31 boards (they are 31 different versions of the same board game). Each board will be made in a dedicated afphoto document. All of these will be single page documents and I need to place the respective 90 labels (coming from a publisher file -this is the 90 pages document) on any document. So there will be 2790 labels for 31 boards in total. 90 labels for each board.

I work in AP because it's an artistic/graphic job and I need Photo tools. Also I know Photo pretty well compared to Publisher. Anyway, working in Publisher (with the integrated Photo persona) wouldn't change the situation since I should still find a way to have all the labels laid out in a single page avoiding as much as possible time consuming tasks or the need for further edits.

I already made the same job last year but working on a few boards, one board at a time and with a lot of time for each. So I did the labels manually (also data merge wasn't a feature in Publisher yet). This time I have many boards and I need to hurry up. So I was looking for the fastest way. If Publisher had the ability to export any page individually as an affinity file or there was a way to load pages as individual groups (or if there is a way in publisher to copy all layers, from all pages, at once) my job would be easier.

Link to comment
Share on other sites

Are all the labels the same for each board? If so, perhaps Symbols (Designer, or Designer Persona of Publisher) would be a good approach.

-- Walt

Desktop:  Windows 11 Home, version 21H2 (22000.613) 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 
Laptop:  Windows 10 Home, version 21H2 (19044.1706) 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU.
        Affinity Photo 1.10.6 (.1665) and 2.0.0 / Affinity Designer 1.10.6 (.1665)  and 2.0.0 / Affinity Publisher 1.10.6 (.1665)  and 2.0.0
iPad Pro M1, 12.9", iPadOS 16.1.1, Apple Pencil 2, Magic Keyboard

      Affinity Photo 1.10.6 and 2.0.2 / Affinity Designer 1.10.6 and 2.0.2 / Affinity Publisher 2.0.2

Link to comment
Share on other sites

7 minutes ago, walt.farrell said:

Are all the labels the same for each board? If so, perhaps Symbols (Designer, or Designer Persona of Publisher) would be a good approach.

Unfortunately, as I wrote in my opening post, they are 2790 different labels. The structure is pretty the same for every labels set, but the text is different. I made a template for labels last year and for every board I edited it adding the texts manually before importing, but copying/pasting 2790 texts would be a suicide. Looking for a solution, I found that Data Merge feature was added to Pub and it's a real bless to me. I just hoped to find a way just as effective to quickly import the labels in my document. At this point I will rely on one of the methods that I said earlier and eventually will ask for a new feature in the proper forum. 

Link to comment
Share on other sites

18 hours ago, Clau_S said:

All of these will be single page documents and I need to place the respective 90 labels (coming from a publisher file -this is the 90 pages document) on any document.

Can you not have the 90 labels on one Publisher Page?

Place the Photo document in a Publisher document then merge the labels onto the photo document?

As an aside: I am thinking in terms of 31 Languages and or 31 Cities.

Mac Pro (Late 2013) Mac OS 11.7.1 
Affinity Designer 2.0.0 | Affinity Photo 2.0.0 | Affinity Publisher 2.0.0 | Beta versions as they appear.

I have never mastered color management, period, so I cannot help with that.

Link to comment
Share on other sites

15 hours ago, Old Bruce said:

Can you not have the 90 labels on one Publisher Page?

Place the Photo document in a Publisher document then merge the labels onto the photo document?

As an aside: I am thinking in terms of 31 Languages and or 31 Cities.

With Data Marge Layout Tool I can make them on a single page, but they would need more further edits 'cause I cannot take advantage of Master Pages flexibility to differentiate backgrounds. I also could place my old empty labels in a grid and use Data Merge Layout Tool to create only text layers, but then I should move any text layer in the corresponding label group. This process would almost take as much time as copy-pasting and I don't know if I could speed it up with a macro.

 

Almost there: 1 Language, 31 different maps.

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...
 Share

×
×
  • Create New...

Important Information

Please note there is currently a delay in replying to some post. See pinned thread in the Questions forum. These are the Terms of Use you will be asked to agree to if you join the forum. | 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.