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
0
votes
1answer
43 views

When printing layout page it does not show the actual cards

I am designing a game cards. I merged the layout of the single master card with csv file,as you can see on the pictures below. After that I made a printing layout page using rectangle frame tool and ...
0
votes
0answers
39 views

Photoshop Customize Font-Size and Line Break for Variable Data Set

I am completely new to this so forgive my lack of technical jargon. I want to create a template file for a thumbnail with customizable text that allows for submission of values passed through a ...
0
votes
1answer
47 views

Opening some PDF files in Photoshop shows “Import PDF” prompt, some don't. Why?

I have just started using Data Sets and all of my interchangeable graphics were saved from Photoshop as Photoshop PDFs without layers. Now I run the export data sets command and the process stops to ...
2
votes
2answers
79 views

InDesign data merge: only show comma if second address field has value

Is there a way to only show a comma in my data merged document if there is a second address value present? The addresses in the CSV don't have commas to begin with and are entered as: 123 Main Street ...
0
votes
1answer
37 views

Merge flat photos together

I have a series of images taken under a microscope. As the field of view isn't big enough I would like to merge all the pictures together. I've tried with "Photo merge" under Photoshop but ...
1
vote
1answer
84 views

Indesign Catalog with data merge

i'm working on a tools catalog made in CorelDRAW but i want to move it in Indesign. The catalog is separated by multiple categories from mechanical tools to wood and plastic products, electrical and ...
2
votes
1answer
68 views

InDesign Data Automation for Books, not Catalogs

I have a use case where I’d like to use a bunch of small pieces of data from a database, in random places inside a large book. My book has hundreds of photos (with captions and credits) and over a ...
0
votes
0answers
21 views

Photoshop - Text Moving Around in Batch Variables?

I’ve been trying to create certificates with name/designation/institution categories in photoshop, but when I import the datasets and glance through the previews, the text layers seem to have moved ...
0
votes
1answer
57 views

Inserting Dates Using Paragraph Style

Hello, so I’m making a planner and I want to add dynamic dates, so what I did is customizing a paragraph style with a numbering list, it works fine until I start the second column, apparently, it's ...
1
vote
0answers
60 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
425 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
30 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
252 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 ...
0
votes
1answer
5k views

How best to join multiple SVG Files info 1?

While I do realize that this question has bee n asked, and answered, the answers seems to have very mixed results, and unfortunately, the reasoning for the joining in the posts I have found appear to ...
1
vote
0answers
2k 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
52 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
723 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
481 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
283 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
277 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
840 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
2answers
2k 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
72 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 ...
1
vote
2answers
482 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
566 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
3k 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
2k 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
691 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
392 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
259 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
2k 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
108 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
2k 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
1k 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
165 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
284 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
309 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
6k 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
474 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
690 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
591 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
1k 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
893 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
792 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
478 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
681 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 ...