Questions tagged [data-merge]
Data-merge is a software function which compiles a final file from multiple sources of information.
82
questions
1
vote
1
answer
58
views
InDesign Data Merge multiple records: prevent results outside of page margins
I am trying to create PDFs for printing on pre-cut name labels (in this case 14-up on an A4 page - with 15mm margins top and bottom, 5mm margins left and right, and a 2mm gutter).
However InDesign ...
- 11
0
votes
2
answers
63
views
Indesign Grep function to break email addresses on @ symbol
I'm trying to fit email addresses in a staff directory and wish to have the emails break on @ in order to have them look more consistent. I'm importing the email addresses via a data merge as well ...
- 103
0
votes
1
answer
262
views
Data Variable Error "filter cannot complete because of an unknown error"
Hello, I'm a beginner in design, and I'm having trouble with applying the data variable function in Adobe Illustrator. I've searched extensively but couldn't find a solution. When I try to apply it to ...
1
vote
0
answers
108
views
InDesign: Reposition Data Merge elements based on Data
This is a long shot, but I'm at a new job, learning InDesign, and wondering if I can automate something in a set of reports I'll regularly be generating.
The organization I work for partners with ...
- 11
0
votes
1
answer
128
views
InDesign: Create a flipbook-style effect with a custom image on each page using parent pages?
I'd like to 'animate' an image at the bottom of the page of an existing book, so people can flip through and see the image change.
I could probably do this to a new document with data-merge, but I ...
- 173
0
votes
1
answer
416
views
Adobe Illustrator CS6 Missing SVG Save Option [closed]
According to the following documentation, page 472 :
https://help.adobe.com/archive/en/illustrator/cs6/illustrator_reference.pdf
... I should be able to :
Choose File > Save As, enter a filename,...
- 143
0
votes
1
answer
49
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
1
answer
476
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 ...
- 31
2
votes
2
answers
828
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 ...
- 6,719
0
votes
1
answer
105
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 ...
- 361
1
vote
1
answer
606
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 ...
- 102
2
votes
1
answer
230
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 ...
- 3,278
0
votes
1
answer
296
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
0
answers
325
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 ...
- 11
2
votes
1
answer
1k
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 ...
- 21
0
votes
0
answers
121
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
1
answer
32
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.
...
- 3
1
vote
2
answers
906
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 ...
- 13
-1
votes
2
answers
6k
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
0
answers
4k
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 ...
- 7,012
1
vote
0
answers
58
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 ...
- 161
0
votes
1
answer
2k
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 ...
- 103
0
votes
1
answer
776
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
1
answer
606
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
1
answer
534
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 ...
- 31
2
votes
2
answers
2k
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>>...
- 123
3
votes
5
answers
9k
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.
- 182
0
votes
1
answer
75
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
1
vote
2
answers
896
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 ...
- 81
0
votes
1
answer
1k
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 ...
- 1
0
votes
2
answers
5k
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
2
answers
4k
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 ...
- 371
0
votes
1
answer
1k
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?
...
- 103
0
votes
2
answers
516
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. ...
- 1
0
votes
1
answer
408
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 ...
3
votes
2
answers
4k
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).
...
- 31
0
votes
1
answer
228
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
4
answers
3k
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 ...
- 33
2
votes
2
answers
2k
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>>
...
- 131
-1
votes
2
answers
2k
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 ...
- 290
0
votes
1
answer
222
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 ...
- 197
0
votes
1
answer
443
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 ...
- 991
3
votes
2
answers
458
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 ...
- 31
0
votes
2
answers
8k
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 ...
- 1
0
votes
1
answer
550
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 ...
- 25
2
votes
1
answer
1k
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 ...
- 21
1
vote
2
answers
2k
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 ...
- 11
1
vote
1
answer
679
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 ...
- 19
1
vote
1
answer
2k
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 ...
- 35
0
votes
2
answers
1k
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 ...
- 350