Questions tagged [data-merge]

Data-merge is a software function which compiles a final file from multiple sources of information.

Filter by
Sorted by
Tagged with
1
vote
0answers
22 views

Removing “space” in a data merge if not all names have titles to start with

I found a great reference on here for using Grep to remove a double space in a data merge if some names have a middle initial but others do not. But what do you do if the issue is at the start of the ...
2
votes
1answer
33 views

How to import a folder full of pictures, one per page, alphabetically in InDesign

I'm trying to import a folder full of pictures (bar codes), one per page in alphabetical order into InDesign. I've found the following link which shows how to create a script that will turn the ...
0
votes
0answers
25 views

variable data-set for large scale

Im trying to print sheets with multiple numbers on them. I have set up 12 variables on my file that will change from 00001 to 00012 and change with each new set from 00013 to 00024 and so on it ...
0
votes
1answer
27 views

Varying Images per Print

I want to send out a postcard to several thousand people with a specific image on each just for the recipient. I have designed the common background in GIMP and have my series of specific images. ...
1
vote
2answers
62 views

InDesign / Delete entire line if field is empty

I'm working on automating donations and was wondering if, when using Data Merge, it is possible on export to auto remove a line, if those fields don't have any data in them. Per example, After Data ...
1
vote
0answers
366 views

Quickly merge text frames in InDesign

Is there a way to quickly link text frames in InDesign? The only way I know is the one-by-one select the in/out handle on each text frame. My use case: I used data merge to create a merged Indd for a ...
1
vote
0answers
48 views

Best Approaches to streamline production design for assets

I'm looking for some suggestions for how to do best manage a design pipeline that requires lots of assets that need to be created based off a few core templates. For our marketing we have 2-3 core ...
0
votes
1answer
289 views

How to set a variable on selected text only using illustrator?

I am making flashcards using Illustrator and I'd like to select only a one character in a text and set it as variable. I will then populate that letter with a dataset. This one character is ...
0
votes
1answer
205 views

Adobe Illustrator Variable Data - XML & CSV data drops apostrophes and quotation marks in data

I am generating a custom report with custom graph data for each record. Since I need to generate the graph data I am stuck with Illustrator as the program to develop the unique designs for each record....
2
votes
1answer
118 views

Batch Saving Data Sets - Illustrator Error on Data Set Change

I am trying to update all the Data Sets in my Illustrator document so that when I do a Batch Action Save I don't get the following error: The current values have not been captured and will be ...
3
votes
1answer
162 views

Indesign Data Merge & Smart Text Reflow- not deleting blank pages

Apologies if this has already been answered-- I looked and was unable to find anything that addressed my specific issue. My question will make more sense if I briefly explain what I am trying to ...
2
votes
2answers
410 views

Indesign newlines with datamerge

I have an InDesign document with a data source (csv). Part of the template looks like this: <<first-title>><<first-text>><<second-title>><<second-text>>...
1
vote
1answer
513 views

Indesign data merge not working with special characters

Data merge is not importing certain characters correctly. Namely greek letters (Ψ, Ω, etc). I've tried different fonts and still no dice.
0
votes
1answer
69 views

How to change text couple times and save every single one?

Is there a way to make really quickly ID's for events? I have a background for my ID's but I have to make them one at a time and save it for each person on the list. Can I somehow automate this ...
0
votes
1answer
157 views

How do I format a URL image link in my tab-delimited data file to data merge with InDesign templates?

I have a data merge file I created in Excel that I export as a comma-delimited text file to import into an InDesign template. Traditionally, I have imported images from a networked drive by setting ...
0
votes
1answer
467 views

data merge not generating multiple records. Repeats one throughout

I's doing a multiple record data merge in Indesign. I believe that I've set it up correctly and when I preview multiple record layout and preview each page I have all of 125 records viewing correctly ...
0
votes
2answers
2k views

Variables and Data Sets in Adobe Illustrator

I've created a document with around 50 Art Boards. I've added a Data Set which is just updating ONE art board. My questions is, can I get the Data Set to work across ALL the art boards. OR - can ...
1
vote
2answers
1k views

InDesign: images using Data Merge

Probably missing something simple. I'm trying to set up a post card template that has a couple hundred images that I'm trying to merge: I set up the .csv correctly, to the best of my knowledge: but ...
0
votes
1answer
430 views

How to set the background color by data source?

i have multiple vcards, where each person has a different background color. what is the best approach, to have all the vcard data in a data source file and also control the color by this file? ...
0
votes
2answers
303 views

Create multiple playing card designs with variable text data

I'm creating a card game, and have 220 cards to design and export as CMYK PDFs for offset printing. Each card will have the same design but different text. I've saved the text for each card in Excel. ...
0
votes
1answer
225 views

how to populate only complete data with easy catalog

I am working with Easy Catalog by 65bit for the first time. Right now I am merging data by setting up field markers. I have included a screen shot of an Excel spreadsheet for reference purposes. I ...
2
votes
2answers
1k views

Conditional text in InDesign data merge

I'm using InDesign to data merge a mail list with a letter. Some entries are single addresses, others are married addresses; in the salutation the customer wants to greet the reader by first name(s). ...
0
votes
1answer
98 views

Mapping Excel data with id’s into InDesign

Is there a way when mapping from Excel into InDesign to assign id’s to the data that is being mapped? For instance, see the image below and record id 15. If we have a column header labelled “id”, can ...
3
votes
2answers
1k views

How to auto delete a space left after a data merge in InDesign?

I have an InDesign document which is filled from the data in a CSV file using data merge. The CSV has columns for First Name, Middle Name & Last Name, but some of the data in the CSV isn't filled ...
2
votes
2answers
1k views

Indesign - How to create a conditional space between fields in a data merge

When performing a data merge in InDesign, is there a way to conditionally include a space between fields? Something like as follows: <<Title>>[conditional space here]<<Name>> ...
-1
votes
2answers
813 views

Merging layers with various blend modes [closed]

I tried to merge three layers with Blend Modes - Normal, Dissolve, Screen respectively. But the image completely differs from what it should be. How do I merge layers with various Blend Modes in ...
0
votes
1answer
143 views

Indesign Data Merge. Manipulate single Target File From Master Document without creating Individual .indd.

I'm curious if there is an option to manipulate a single Document/Data-Set from the Data-Merge-Sets without the need to export all the Files to individual .indd's. In My special case i'd like to ...
0
votes
1answer
246 views

Data Merge fouling up Single Quotes

While using InDesign's Data Merge feature, I've noticed that all my single-quotes are getting turned into other non-English characters. For example, here's a snippet of the source .csv file: And ...
2
votes
2answers
207 views

How can I merge a heap of text into an image using Photoshop 2017 CC?

I have a templated PSD image that I want to use to build a heap of "memes" (for want of a better word). I have a heap of tips in text format. Most of them are 1-2 sentences at the most. I want to ...
0
votes
2answers
4k views

How to make 150+ certificates, each with a different name

I have a "Certificate of Recognition" PSD file with a blank line for the name portion. Is there a way to input all the participants' names without duplicating a certificate for each person ...
0
votes
1answer
452 views

Datamerge - Excel to Indesign [duplicate]

I have a problem with a data merge. On several tutorials if they selected the CSV file, all the data loads up separately but when I select the CSV file, all data loads like this: So I can't load ...
2
votes
1answer
573 views

InDesign, Data Merge and Variable Text Wrap

I am working on card game with many, many cards. These cards have variable icons on them (example: some cards have the moon icon and some don't) I am using data merge to place the images where needed ...
1
vote
2answers
1k views

InDesign combines all csv separated columns as one field in data merge

I am trying to import an Excel CSV into InDesign Data Merge. Everytime I try to export the csv, it appears in Data Merge as only one field, with fields separated by semicolons, although in Excel I ...
1
vote
1answer
587 views

How to select all visible text-elements and make them separate variables?

I want to translate a huge amount of illustrations from Illustrator. The Variable-Tool offers a great opportunity to transform text into XML that can be read by translation software and re-imported ...
1
vote
1answer
724 views

How to delete unused data sets after a batch export to separate files?

I read the answers to the following question: Illustrator variables / data-driven documents: how to batch-export one file for each data set? So now I have multiple files created...awesome! But now I ...
0
votes
2answers
695 views

Messed fonts while data merging in Indesign

I am transalting a 15-page brochure to 23 languages and I keep running into obstacles. While I finally managed to get data to merge properly I seem to get another problem which is messed up text after ...
0
votes
0answers
626 views

Data merging multiple pages with multiple text fieds in a Brochure [InDesign CC]

I have this InDesign CC document that is a multipage brochure (15 to be exact) that has a lot of text on every page. I need to know if there's a way to switch the data in every page with data merge to ...
1
vote
2answers
378 views

InDesign: Data Merging from spread sheet for timetables

Ok So my job is creating timetables for bus routes having them in DL leaflet form and A4 pdf from for online. Currently I build them both individually (Which is obviously very time consuming) so I ...
-1
votes
1answer
1k views

How to automatically Import data from MS excel CELLS to table cells?

i have a huge MS excel file with 120 columns and 20 rows. I want to import all the data from excel cells into table cells in CorelDraw (or may be other graphic design software). Here there are two ...
0
votes
1answer
623 views

Indesign catalog with categories with content from spreadsheet

TL;DR: Does anyone know how to show on InDesign file one table field that represents "Category" and under that all other table entries that have that same "category"? Details: I have to create ...
1
vote
1answer
181 views

How do you save each file created by Indesign Data Merge

I have used data merge to create 100 PDFs, how do I save each one individually with its own name?
0
votes
2answers
2k views

Why does Indesign combine my csv columns into a single entry, when data merging?

I'm data merging a csv file into a indesign file to export buisness cards. However when I select the csv for data merging, Indesign reads the file and should display the columns in the file as seperat ...
7
votes
2answers
780 views

Multiple-page, varied-information Data Merge in InDesign?

Can I use Data Merge in InDesign to input various information from a .cvs file into multiple pages of a resource directory? The idea is sustainability for the customer... lay it out once and then ...
0
votes
5answers
1k views

Faster merge software than Indesign Data merge

We have created an Indesign document for 450.000 letters we need to send. Included in this letter is a Datamatrix barcode. We are trying to merge the data, but it takes forever, we can only do batches ...
1
vote
1answer
1k views

Updating all image and data links in an Indesign Book

I'm fairly sure that this is impossible but I thought I'd ask anyway. I have an Indesign Book file composed of a large number of documents, each with multiple image and .csv links. The linked files (...
0
votes
0answers
95 views

Responsive data merge in InDesign?

I'm using InDesign's Data Merge feature for the first time and am wondering if there is anyway for the text being input into InDesign from a .csv file can be responsive in size. For example, if the ...
1
vote
1answer
90 views

InDesign data merge template not following path

I'm creating a curved path which is being used as a placeholder for data merge content. I create the path, click on it, then double-click the field in the data merge window. It places <<...
0
votes
1answer
178 views

Auto-centering elements when using Data Merge

I'm using data merge to fill in data of a master template. I have a group of three placeholders: a circle (colors vary), a number on top of it, and variable-length text (a name) to the right. As ...
5
votes
3answers
8k views

Illustrator: Edit text in multiple text boxes at the same time

I have two text boxes that I need to have identical text, but in different fonts. Is there any way I can edit only the text content of both at the same time (keeping the fonts different).
1
vote
1answer
711 views

InDesign Data Merge with hyperlinks [closed]

I want to run a data merge with text and photos and I want to be able to hyperlink the photo to a website. I have about 400 entries with the data merge that will each be on a separate page but I can't ...