Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
0

Data Merge: Place Setting cards

New Here ,
Nov 27, 2017 Nov 27, 2017

Copy link to clipboard

Copied

I'm trying to figure out how to do the data merge with place cards. I've attached a screenshot of what needs to be filled out but I can't quite seem to figure it out.

When I import the CSV and apply it, there's always a "first name" and "last name" that appears and it also repeats the first name twice?

I'm exporting from Google sheets so I wonder if that's the issue?

Hope someone can help! I have to input 180 names...each page is a card (hopefully that information helps)

Screen Shot 2017-11-27 at 3.52.31 PM.png

Views

3.9K
Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

New Here , Feb 26, 2019 Feb 26, 2019

In your csv/excel file, duplicate the names twice and title the duplicate names something else like this:

Screen Shot 2019-02-26 at 3.04.18 PM.png

Then, in InDesign, it will look like this.

Screen Shot 2019-02-26 at 3.06.48 PM.png

Screen Shot 2019-02-26 at 3.06.55 PM.pngScreen Shot 2019-02-26 at 3.07.00 PM.png

Votes

Translate
Valorous Hero ,
Nov 27, 2017 Nov 27, 2017

Copy link to clipboard

Copied

Are they single cards, 2-up, and intended to be cut apart?

In any case, you can only have a single set of place holders. Else you will get what you are describing.

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 27, 2017 Nov 27, 2017

Copy link to clipboard

Copied

I’m guessing that it is folded, as in a “tent card”… A random example:

075d27ef40d82d0b427d0d941b4cb069.jpg

merge.png

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Nov 28, 2017 Nov 28, 2017

Copy link to clipboard

Copied

I ran it the way you pointed out and it turned out like this... and created 4 different files?Screen Shot 2017-11-28 at 11.45.59 AM.png

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 28, 2017 Nov 28, 2017

Copy link to clipboard

Copied

Notice how my image showed what was going on in InDesign’s Data Merge panel, and the source .CSV file? Please provide more detail on your setup. I think the issue is how you are working with the data set and fields.

EDIT: Animated GIF example

merge.gif

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 26, 2019 Feb 26, 2019

Copy link to clipboard

Copied

LATEST

In your csv/excel file, duplicate the names twice and title the duplicate names something else like this:

Screen Shot 2019-02-26 at 3.04.18 PM.png

Then, in InDesign, it will look like this.

Screen Shot 2019-02-26 at 3.06.48 PM.png

Screen Shot 2019-02-26 at 3.06.55 PM.pngScreen Shot 2019-02-26 at 3.07.00 PM.png

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 27, 2017 Nov 27, 2017

Copy link to clipboard

Copied

I need some more information. Your cards have the first name and last name placeholder on each card twice so I would expect the first name and the last name to appear twice. Can you describe what you're hoping to achieve?

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Nov 28, 2017 Nov 28, 2017

Copy link to clipboard

Copied

Stephen Marsh is correct. I need to have them tented. Indeed the first name and last name appears twice. I need to make 180 tented place cards (with 180 different names) and both sides need to have the same information.

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines