Publisher export per page to JPEG and PDF with file name from Data Merge

[get in shape]

Hi there,

We have designed a event image in Designer and via File > Edit in Publisher brought it into Publisher.
From Publisher we have done a Data Merge from a CSV file on a text field. This has given us as we wanted a few hundred pages with a unique text field on the image. 

Now our challenge is to export all this pages at once into separate files preferable in JPG and PDF each file saved with the unique info of the text field. Other option is to do first all into separate files as JPG and then after that do the same for PDF.

Is this possible to achieve?

Thank you

[walt.farrell]

Within Publisher you can only export a single file.

Within Designer you can export multiple files using the Export Persona, but you would need to handle each Page of your generated Publisher document separately; you can't do them all at once.

Or, you could Export a multi-page PDF using File > Export using either Publisher or Designer. Then you could Open that PDF in Designer, which will give you a file with one Artboard per PDF page. You could then export all the Artboards to separate files in one operation using the Export Persona in Designer.

[get in shape]

Hi there,

What do you mean with handle each page of your generated Publisher document separately?
Btw is it possible in Publisher to change the default value from Area from All Pages to Current Page?

The reason we brought the image made in Affinity Designer into Affinity Publisher is to have the Data Merge option on a text field. 
Do you mean that after this Data Merge operation we have to bring it back to Affinity Designer again?

And we need both file types, JPG and PDF.

 

[Old Bruce]

22 minutes ago, get in shape said:

Do you mean that after this Data Merge operation we have to bring it back to Affinity Designer again?

Walt probably means you would take the Publisher file and export it as a PDF. Then in Designer you open that PDF and it will have each PDF page as a separate Artboard. Now in Designer you can set up a pair of export formats to generate each Artboard (the original individual pages from Publisher) as a JPEG and as a PDF. You do this in the Export Persona of Designer.

The hard part is the naming of the Artboards.

[walt.farrell]

57 minutes ago, get in shape said:

What do you mean with handle each page of your generated Publisher document separately?

I mean that if you open the generated .afpub file in Designer, you would need to navigate to each Page, and for each Page you would need to use the Export Persona. You cannot export all the Pages as individual files. That function simply does not exist, for files with Pages.

It does exist, for pages with Artboards. But Data Merge will not create Artboards, only Pages.

[get in shape]

58 minutes ago, walt.farrell said:

I mean that if you open the generated .afpub file in Designer, you would need to navigate to each Page, and for each Page you would need to use the Export Persona. You cannot export all the Pages as individual files. That function simply does not exist, for files with Pages.

It does exist, for pages with Artboards. But Data Merge will not create Artboards, only Pages.

Thank you for your clarification.

[get in shape]

1 hour ago, Old Bruce said:

Walt probably means you would take the Publisher file and export it as a PDF. Then in Designer you open that PDF and it will have each PDF page as a separate Artboard. Now in Designer you can set up a pair of export formats to generate each Artboard (the original individual pages from Publisher) as a JPEG and as a PDF. You do this in the Export Persona of Designer.

The hard part is the naming of the Artboards.

Ok the Publisher file is exported as a PDF and opened in Designer. 
Now i'm on the Export Persona of Designer but have no idea what do next. Never looked at Export Persona of Designer. 
What should I do next?

[get in shape]

Well I have tried a few things on the slices tab and did an Export but every time I get one JPG and one PDF file with all artboard in it.

 

[walt.farrell]

53 minutes ago, get in shape said:

What should I do next?

After switching to the Export Persona:

1. In the Layers panel, you select all the Artboards (named Page 1, Page 2, etc.) and click the Create Slices button at the bottom of the panel.
2. In the Slices panel, you make sure they're still all selected, and you click Export Slices. But before that, you need to select the kind of file you're going to be Exporting, and that's beyond what I can explain right now. Someone else might have a good explanation, or you might check the Help, or watch some of the Tutorial videos.

[get in shape]

Thank you that was the missing step for now. 
I managed exporting all Artboards as separate files, JPG and PDF, at once.

There is a standard slice in the panel that was/is confusing me and I thought I had to do the settings on there. 

I can see there are a lot of options and possibility's Exporting. A long way to learn everything. 

 

11 hours ago, Old Bruce said:

Walt probably means you would take the Publisher file and export it as a PDF. Then in Designer you open that PDF and it will have each PDF page as a separate Artboard. Now in Designer you can set up a pair of export formats to generate each Artboard (the original individual pages from Publisher) as a JPEG and as a PDF. You do this in the Export Persona of Designer.

The hard part is the naming of the Artboards.

Naming for sure is the hard part and any help or ideas are very welcome.

[David in Яuislip]

You can rename slices in the Export Persona like this

or use Ghostscript to produce both sets with little effort from the pdf, quite handy if you only have Publisher
gswin64 -dSAFER -sDEVICE=pdfwrite -o NewTitleGS_%d.pdf ExtractingPagesAndImages.pdf
gswin64 -dSAFER -sDEVICE=jpeg -dJPEGQ=85 -o NewTitleGS_%d.jpg ExtractingPagesAndImages.pdf
Results
96312	NewTitleGS_1.pdf		154812	NewTitle.pdf
95441	NewTitleGS_2.pdf		154833	NewTitle_2.pdf
95419	NewTitleGS_3.pdf		154566	NewTitle_3.pdf
				
145405	NewTitleGS_1.jpg		148746	NewTitle_1.jpg
143307	NewTitleGS_2.jpg		146235	NewTitle_2.jpg
143722	NewTitleGS_3.jpg		146502	NewTitle_3.jpg

For a few hundred files use %03d rather than %d and you'll get NewTitleGS_001.pdf etc

[get in shape]

Thank you for your reply. I'll give it a try.

The way I solved renaming a few hunderd files is by using File Explorer - Excel - Command Promt.

-Go to File Explorer 
-Open the  directory where all Export Persona files are saved
-In the location bar click and make sure the full path is selected
-Now type CMD and Enter and the Command Promt will open on saved location
-Type dir /B
-With the mouse select all files and use CTRL+C to copy
-Leave the Command Promt open
-Open Excel and with CTRL+V paste all the file names starting at A2
-Rename cells A1>Old - B1>Change - C1>New 
-In cell C2 copy this Formula and drag it down: =CONCATENATE("ren ",CHAR(34),A2,CHAR(34)," ",CHAR(34),B2,CHAR(34))
-Make changes in column B
-Select all data from cell C2 to the end and use CTRL+C to copy
-Go back to the Command Promt and scroll down
-With CTRL+V paste all data into the Command Promt and press Enter