Jump to content
Foundx

Automation on Affinity Publisher

Recommended Posts

Hello, 

I have not bought a copy of Affinity Publisher yet. I wish to know if there's a way to automate task or import a csv into the software. I wish to layout notebooks of around 100 pages, each page is identical, except for: eg. A different quote (or a different clipart) at the exact placement with the same font and format. Can this task be automated or coded (I just learned some basic Python) in Affinity Publisher? 

Share this post


Link to post
Share on other sites
3 minutes ago, Foundx said:

Hello, 

I have not bought a copy of Affinity Publisher yet. I wish to know if there's a way to automate task or import a csv into the software. I wish to layout notebooks of around 100 pages, each page is identical, except for: eg. A different quote (or a different clipart) at the exact placement with the same font and format. Can this task be automated or coded (I just learned some basic Python) in Affinity Publisher? 

Some of what you want is simple using Master Pages with the correct placement of text frames and the use of Paragraph Styles and then the Quotes can be placed by using a single text file but the images would need to placed by hand.


MacBook Pro (13-inch, Mid 2012) Mac OS 10.12.6 || Mac Pro (Late 2013) Mac OS 10.14.6

Affinity Designer 1.9.0 | Affinity Photo 1.9.0 | Affinity Publisher 1.9.0 | Beta versions as they appear.

Share this post


Link to post
Share on other sites
33 minutes ago, Old Bruce said:

Some of what you want is simple using Master Pages with the correct placement of text frames and the use of Paragraph Styles and then the Quotes can be placed by using a single text file but the images would need to placed by hand.

Thanks Bruce. Do you mean I can import a single text file with 100 rows of quotes and name of the person, and it can be split into 100 pages in the master page format?

Share this post


Link to post
Share on other sites
1 minute ago, Foundx said:

Thanks Bruce. Do you mean I can import a single text file with 100 rows of quotes and name of the person, and it can be split into 100 pages in the master page format?

For example, if I set the master page to look like this, can I easily import a list of quotes and a list of famous people who said that quote and they can appear correctly on each page?

Screenshot_20200824-020437_Chrome.jpg

Share this post


Link to post
Share on other sites

I am going to watch this topic as I want to do something very similar and would love to have titles for all these photographs I want to lay out in a book, one per page, auto populated to a text field beneath each image. I hope someone can explain if this is possible and if so how (in layman's terms!)

Thanks!

ScreenHunter 193.jpg


I like turtles!

Windows 10

Pentax K1ii and K3-ii

Sony RX10 Mkiii

Canon G5x

Mavic Mini drone

A partridge

A pear tree (occupied)

Share this post


Link to post
Share on other sites
20 hours ago, Foundx said:

For example, if I set the master page to look like this, can I easily import a list of quotes and a list of famous people who said that quote and they can appear correctly on each page?

You would set up a Paragraph style (I would name it) The Quote one of the attributes must be to start in a new frame and another must be that the Next Style is Author and one of the attributes of that is that the next style must be The Quote. This works for two paragraphs per page. You have "You can change the world by being yourself" and "Yoko Ono" as your two paragraphs.

A text file with the format of 

Quote

Person

Different Quote

Name

... etc.

is generated by what ever software, your original question of importing a coma separated values file would need to be fixed so instead of comas there are paragraph returns. The text file in imported into the Publisher document and all the text is selected and now for the fun part you select The Quote in the Styles by right clicking on It and choose Apply "The Quote" then next style from the context menu.

882202532_ScreenShot2020-08-24at8_04_18AM.png.5df6a6aabbacc9fb4c2ea6b38196ad63.png


MacBook Pro (13-inch, Mid 2012) Mac OS 10.12.6 || Mac Pro (Late 2013) Mac OS 10.14.6

Affinity Designer 1.9.0 | Affinity Photo 1.9.0 | Affinity Publisher 1.9.0 | Beta versions as they appear.

Share this post


Link to post
Share on other sites

Oy vey, that looks hard but I'll give it a try. Thanks!


I like turtles!

Windows 10

Pentax K1ii and K3-ii

Sony RX10 Mkiii

Canon G5x

Mavic Mini drone

A partridge

A pear tree (occupied)

Share this post


Link to post
Share on other sites
2 hours ago, Phil_rose said:

Oy vey, that looks hard but I'll give it a try. Thanks!

The above example only really works for text files with two (2) paragraphs per page/column/frame. If you have some where you need more than 2 Paragraphs you need the same number of styles and they all have to follow one another. 


MacBook Pro (13-inch, Mid 2012) Mac OS 10.12.6 || Mac Pro (Late 2013) Mac OS 10.14.6

Affinity Designer 1.9.0 | Affinity Photo 1.9.0 | Affinity Publisher 1.9.0 | Beta versions as they appear.

Share this post


Link to post
Share on other sites
5 minutes ago, Old Bruce said:

If you have some where you need more than 2 Paragraphs you need the same number of styles and they all have to follow one another. 

Perhaps you could use tags at the start of each paragraph, and then use Find and Replace to assign the actual Paragraph Text Styles?


-- Walt

Windows 10 Home, version 2004 (19041.388),
   Desktop: 16GB memory, Intel Core i7-6700K @ 4.00GHz, GeForce GTX 970
   Laptop:  8GB memory, Intel Core i7-3625QM @ 2.30GHz, Intel HD Graphics 4000 or NVIDIA GeForce GT 630M
Affinity Photo 1.9.1.979 and 1.9.1.979 Beta   / Affinity Designer 1.9.1.979 and 1.9.1.971 Beta  / Affinity Publisher 1.9.1.979 and 1.9.1.967 Beta

Share this post


Link to post
Share on other sites
46 minutes ago, walt.farrell said:

Perhaps you could use tags at the start of each paragraph, and then use Find and Replace to assign the actual Paragraph Text Styles?

That is my preferred way of working with average text but I think for a bulk import of text from a CSV file this is easier. Different cat so to speak.


MacBook Pro (13-inch, Mid 2012) Mac OS 10.12.6 || Mac Pro (Late 2013) Mac OS 10.14.6

Affinity Designer 1.9.0 | Affinity Photo 1.9.0 | Affinity Publisher 1.9.0 | Beta versions as they appear.

Share this post


Link to post
Share on other sites
3 minutes ago, Old Bruce said:

That is my preferred way of working with average text but I think for a bulk import of text from a CSV file this is easier. Different cat so to speak.

It just seemed that if one is getting into multiple text styles, with the need to set them up for "apply x then next style" as you mentioned, that things start becoming complex in the style definitions. (I like your solution, by the way.)

Tagging might alleviate some of the setup issues, and substituting a few Find/Replace operations with a (perhaps) smaller set of text styles might be worth the experiment.


-- Walt

Windows 10 Home, version 2004 (19041.388),
   Desktop: 16GB memory, Intel Core i7-6700K @ 4.00GHz, GeForce GTX 970
   Laptop:  8GB memory, Intel Core i7-3625QM @ 2.30GHz, Intel HD Graphics 4000 or NVIDIA GeForce GT 630M
Affinity Photo 1.9.1.979 and 1.9.1.979 Beta   / Affinity Designer 1.9.1.979 and 1.9.1.971 Beta  / Affinity Publisher 1.9.1.979 and 1.9.1.967 Beta

Share this post


Link to post
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

Please note the Annual Company Closure section in the Terms of Use. 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.