Jump to content
ivan lavosky

Automatic data filling based on Excel

Recommended Posts

Hi,

I am using Affinity Designer.

I want to create around 200 namecards with different name and other personal data printed on it. 

I have created the base template for the namecards and I also already had the names and data of the people that will be printed to that namecards.

Is there any way to automatically fetch the personal data from other source like Excel into Affinity Designer? So my namecards would be automatically filled with the prepared data.

 

Thanks for your help

Share this post


Link to post
Share on other sites

Hi ivan lavosky and Welcome to the Forums,

We don't have data merge just yet.  It's something that should be coming to Publisher at some point and might make it's way into Designer if the Dev team feel it fits with Designer.

 

Share this post


Link to post
Share on other sites

This is for Publisher (not Designer) but you can currently get the beta version of Publisher for free so you might want to try it. (Or anyone else that wants to try it)

Set up a new document page the size of your namecard

Add a blank text frame and change the font, font size etc to what you want printed.

Outside of Publisher take your Excel file (or whatever) and create a text file with the names and data that you want printed on each namecard.

In that text file end each person's data with a unique set of characters like xxxxxx

Back in Publisher in the text frame select Text > Insert Text From File and insert the text file you just created.

Use Text > Find to find and replace all occurrences of xxxxxx with a page break command

Then Shift-Click the text flow arrow of the text frame to automagically add a new page for all the data records in your text file.

Hopefully you will end up with 200 namecards ready to print but I don't have the time to create 200 data records to test this out so consider the above a working theory of how I would try it, you may need to make adjustments along the way.


Due to the fact that Boris Johnson is now our Prime Minister, punctuation, spelling and grammar will never be worried about ever again.  We now have far bigger problems to be worried about.

Share this post


Link to post
Share on other sites

Another possibility is to store/export your Affinity Designer namecard layout with some embeded name place holders (#name# etc.) into some portable text editable format like SVG/EPS and then use some script or scripting language to do your own data merge handling with that namecard file then.


☛ Affinity Designer 1.8.4 ◆ Affinity Photo 1.8.4 ◆ OSX El Capitan

Share this post


Link to post
Share on other sites

Hi there,

I've just tried the idea to use Affinity Publisher with excel file to propagate files with unique text.

Unfortunately, I cannot upload any data file (I tried: xlsx, csv,  ods). Is this feature available in Beta version of the Publisher?

 

 

Share this post


Link to post
Share on other sites
5 hours ago, OdFori said:

Any update?

This function is not yet supported.

You will know it's available when it appears in one of the beta releases, probably for Publisher not Designer if I had to guess.


-- 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.8.5.703 and 1.9.0.891 Beta   / Affinity Designer 1.8.5.703 and 1.9.0.891 Beta  / Affinity Publisher 1.8.5.703 and 1.9.0.887 Beta.

Share this post


Link to post
Share on other sites

If the case is only to print name cards, do this workarround:

  1. design your card with no test data (name aso.)
  2. print it as many cards you need (with no name on the card)
  3. Use MS Word and Excel to print the card data with label Print
    match the position so it fits to the printed name cards from Designer
  4. Overprint the in Word created labels on the printout of Designer

This method is known well in the printing industry

But, it would be great if the Designer could read SQL / ODBC (or at least Excel or CSV files) data in future :)

 

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.