Jump to content

Recommended Posts

Hello.

I created a diploma design for my school and was wondering how I could add all the learners names.  Every page needs to have a different name as it is an diploma for another learner.
The trouble comes when I need to insert hundreds of names and what the different diplomas goes for.  That could take hours.  Is there a way to automate this?  Is there a way to have all the names of the learners and what they get diplomas for in a list,  like in excel, and then automatically import them (line 1 goes to page 1,  line 2 goes to page 2 ........ line 159 goes to page 159 etc.)?

Share this post


Link to post
Share on other sites

This sort of thing is entirely possible in APub.

Design the certificate. Place the certificate design on the Master Page of a document that is not using Facing pages.

Switch the the first page of the document. I would add a layer at this point for the text. Add a single text frame where the names go. Make a paragraph that centers the text. Set the paragraph style to begin on the next page like so:

capture-002379.png.1e20f42d10f508e770913c8559361398.png

Then simply import the text. It will overflow and I find it distracting, so I shut it off at the lower right corner of the text frame. Then shift-click the flow icon and all the pages will be built automatically. Takes mere seconds.

I have attached a simple example as a ZIP. It contains the APub file, the certificate graphic and a text file.

Certificate.zip


My computer is a nothing-special Toshiba laptop with unremarkable specs running Windows 10 64-bit.

Share this post


Link to post
Share on other sites

BTW, to get the names Excel file into a text format, you can either export as plain text from Excel. 

You can also copy the names and paste into a text editor, but then you will also need to replace the tabs that will be between what was columns with plain spaces...


My computer is a nothing-special Toshiba laptop with unremarkable specs running Windows 10 64-bit.

Share this post


Link to post
Share on other sites
On 12/20/2018 at 2:00 PM, MikeW said:

This sort of thing is entirely possible in APub.

Design the certificate. Place the certificate design on the Master Page of a document that is not using Facing pages.

Switch the the first page of the document. I would add a layer at this point for the text. Add a single text frame where the names go. Make a paragraph that centers the text. Set the paragraph style to begin on the next page like so:

capture-002379.png.1e20f42d10f508e770913c8559361398.png

Then simply import the text. It will overflow and I find it distracting, so I shut it off at the lower right corner of the text frame. Then shift-click the flow icon and all the pages will be built automatically. Takes mere seconds.

I have attached a simple example as a ZIP. It contains the APub file, the certificate graphic and a text file.

Certificate.zip

This is fabulous! Great! 

Question: will this work if we use different styles? I mean, for instance, sometimes I need to personalize names and sessions the guy attended. With data merge it's a piece of cake. But this way I'd need to create 2 boxes, right? One for each text file... Did you try this? (i'll do it and let you know what happens)

Share this post


Link to post
Share on other sites
9 minutes ago, AleMello said:

This is fabulous! Great! 

Question: will this work if we use different styles? I mean, for instance, sometimes I need to personalize names and sessions the guy attended. With data merge it's a piece of cake. But this way I'd need to create 2 boxes, right? One for each text file... Did you try this? (i'll do it and let you know what happens)

Nope, I didn't try that.

It may be possible, though, to use two text styles that are linked via the Next Style setting, then after the names and sessions are in, to highlight the entire text and to apply using Apply Next style (or whatever it is named as I don't have APub open).

But otherwise, flowing two text files ought to work out...


My computer is a nothing-special Toshiba laptop with unremarkable specs running Windows 10 64-bit.

Share this post


Link to post
Share on other sites

I've tried my idea. Didn't work.

In page 1 I created a new text box. SHIFT-clicked the upper box the flow icon and Publisher created the pages.But it added a "empty" page between each name tag. Probably because the text format I have in Mac.

870498692_ScreenShot2019-01-01at12_02_57.thumb.png.e70e52bb14c13da71fea8a266c620622.png

Then I SHIFT-clicked the second text box flow icon and Publisher added a lot of new pages. I'd expect it would follow the page count. And, again, and empty page between sessions...

916251324_ScreenShot2019-01-01at12_03_09.thumb.png.4581b93a00d4e6ac78d3ef7d9d68b465.png

Probably I need to work on styles, perhaps asking Publisher to flow to next frame. Just don't know how to work the text file for this. Paragraphs, right?

Share this post


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

I've tried my idea. Didn't work.

...

Probably I need to work on styles, perhaps asking Publisher to flow to next frame. Just don't know how to work the text file for this. Paragraphs, right?

The text style with the Start in next frame should be whatever is the last text "record" that appears in the text file. So if the Session the attendee was at is the second text, it should have that paragraph setting.

I literally sat down with my first cup of coffee for the day at my last response. I'll give something a whirl in a bit and see if I can do something.

In the meantime, a sample of dummy data would be great. That way I don't need to invent something that may not apply. Just a couple made up records that follow your data file format.

Mike


My computer is a nothing-special Toshiba laptop with unremarkable specs running Windows 10 64-bit.

Share this post


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

The text style with the Start in next frame should be whatever is the last text "record" that appears in the text file. So if the Session the attendee was at is the second text, it should have that paragraph setting.

I literally sat down with my first cup of coffee for the day at my last response. I'll give something a whirl in a bit and see if I can do something.

In the meantime, a sample of dummy data would be great. That way I don't need to invent something that may not apply. Just a couple made up records that follow your data file format.

Mike

Don't worry. And let's leave that for tomorrow. BTW Happy New Year. 
I'll work on the text file later and send it to you.

Best regards from Brazil

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×