Jump to content

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

Link to comment
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.

Link to comment
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.10.5 ◆ Affinity Photo 1.10.5 ◆ OSX El Capitan

Link to comment
Share on other sites

  • 3 months later...
  • 8 months later...
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

   Desktop: new:  Windows 11 Home, version 21H2 (22000.613) 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090  (old: 16GB memory, Intel Core i7-6700K @ 4.00GHz, GeForce GTX 970 )
   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.5 (.1342) and 1.10.5.1342 Beta   / Affinity Designer 1.10.5 (.1342) and 1.10.5.1342 Beta  / Affinity Publisher 1.10.5 (.1342) and 1.10.5.1282 Beta
 iPad Pro M1, 12.9", iPadOS 15.4.1, Apple Pencil 2, Magic Keyboard

  Affinity Photo 1.10.5 (.280) and 1.10.2 (.266) Beta / Affinity Designer 1.10.5 (.21) and 1.10.3 (.19) Beta 

Link to comment
Share on other sites

  • 7 months later...

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 :)

 

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.