Jump to content
MickRose

Data merge initial thoughts (split)

Recommended Posts

I can't work it out either. I have a 10 record xlsx file called Book1.xlsx which has loaded okay. But how do I show where the data is meant to go?

image.png.298dc99ca0398229a8a7de8b57de920b.png


Windows 10 Pro, I5 3.3G PC 16G RAM

Share this post


Link to post
Share on other sites

Have a look at the Fields panel. Mark your text where your data should go and double-click the appropriate field in the Fields panel. For better visualization Menu -> Text -> Highlight Fields.


------
Windows 10 | i5-8500 CPU | Intel UHD 630 Graphics | 8 GB RAM | Latest Retail and Beta versions of complete Affinity range installed

Share this post


Link to post
Share on other sites

I briefly checked it out and was left scratching my head. I am sure it will make more sense when I actually research how it works in Publisher. It was not clear or evident though as I thought it should be when looking at it. I am not new to this so thought I could/should be able to figure it out quickly. I tried loading a csv file with a little over 9000 records. It did not show me the fields available for merge. I thought maybe I need to hit generate to bring that up. Well that was not the right move, took ages for it to go through the data and was left with a large publisher file with I am assuming 9000+ pages. Again going in completely blind so it may work well once I understand Affinities method, but it certainly did not stand out obviously.

Share this post


Link to post
Share on other sites

I really appreciate  - in my software on Windows 10 it does not have typical field choices or database selection. It looks like this (ignore cursor) I am just trying to show my workspace and the choices:

datamerge fields.png

Share this post


Link to post
Share on other sites
14 minutes ago, undercovergypsy said:

in my software on Windows 10 it does not have typical field choices or database selection.

 

You set up the data connection in the Data Merge Manager:

data-merge-manager.jpg.f3d0fe429b14cd83e9d91334f964a6b4.jpg

 

Fields are inserted from 'View > Studio > Fields'

data-merge-fields.jpg.7dd04f9888fedc7c96bfb52a76d3a223.jpg

Cheers,
d.


Affinity Designer 1.8.5 (beta 1.9.0.852)   |   Affinity Photo 1.8.5 (beta 1.9.0.852)   |   Affinity Publisher 1.8.5 (beta 1.9.0.863)
Affinity Designer for iPad 1.8.4   |   Affinity Photo for iPad 1.8.4

Windows 10 (1809) 64-bit - Core i7 - 16GB - Intel HD Graphics 4600 & NVIDIA GeForce GTX 960M
iPad pro 9.7" + Apple Pencil

Share this post


Link to post
Share on other sites

Working great for me for 8up business cards - made a template - tested - NICE!

Screen Grab 2020-10-14 at 17.21.24.png


Mac Pro Cheese-grater (Early 2009)
2.93 GHz 6-Core Intel Xeon
48 GB 1333 MHz DDR3 ECC Ram
NVIDIA GeForce GT 630 - 2 GB
Ugee 19" Graphics Tablet Monitor
Mac OS Mojave 10.14.6

Affinity Designer, Photo and Publisher 1.8.3 + Latest Betas when available

Currently out of work
www.bingercreative.co.uk

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.