InDesign Data Merge - Advanced Tutorial (Multiple records per page)

Поділитися
Вставка
  • Опубліковано 27 лип 2024
  • Download the project files at pagination.com/datamerge
    Most mentioned InDesign Data Merge Limitations:
    - Cannot group products;
    - Cannot use multiple product templates;
    - Cannot insert a page break when the category changes
    To overcome these limitations, try Pagination - The Turnkey Database Publishing Service (pagination.com/) that allows you to create data-driven PDF and InDesign files in a jiffy.
  • Навчання та стиль

КОМЕНТАРІ • 46

  • @m4dn3wt
    @m4dn3wt 3 роки тому +6

    You saved my day! It has been years that I haven't used data merge and that helped me create multiple tags for our storefronts saving the day. Cheers to you and the team that developed this material!

  • @eldesarrollador_
    @eldesarrollador_ 5 років тому +5

    I love you!! You save like 100 years of manual work

  • @SpacePigeon11
    @SpacePigeon11 2 роки тому +1

    This saved me A LOT of time and struggle thank you so much!

  • @mauriciodavida8921
    @mauriciodavida8921 4 роки тому +1

    This is gold. Thank you!

  • @ccpipe
    @ccpipe 3 роки тому +1

    Now that's interesting, will definitely give it a go, thanks a lot :)

  • @SEANCmedia
    @SEANCmedia 3 роки тому +1

    This worked for me! Thank you so much!!!

  • @RussellZahradnik
    @RussellZahradnik 3 роки тому +1

    This helped a lot! Thank you!

  • @carolynquan2764
    @carolynquan2764 10 місяців тому

    Thank you so much! I really needed this tutorial for a new job I’m starting soon 😅

  • @ChapitZulkefli
    @ChapitZulkefli 4 роки тому +1

    thanks for the guide. keep it up.

  • @MarkSubramaniam
    @MarkSubramaniam Рік тому +2

    The fixed dimensions of the template can be solved by applying an 'Object Style' to the text frame. In the Object Styles options you can use the 'Auto Size' feature to automatically set the height of the width of the text frame.

  • @lolesmarston7230
    @lolesmarston7230 3 роки тому +1

    WOW thanks a lot! really useful

  • @prasad65899
    @prasad65899 4 роки тому +1

    very nice tutorial .... Thank you brother

  • @alejandrogarzon8534
    @alejandrogarzon8534 4 роки тому +1

    U are awesome, thanks

  • @claralabelle8855
    @claralabelle8855 Рік тому

    Thank so much for all

  • @filipegomes7830
    @filipegomes7830 Рік тому +1

    Terrific!

  • @mosesmurali9754
    @mosesmurali9754 2 роки тому +1

    Thank you sir for your effort to make understanding easier. God bless you si

  • @NismoTNR
    @NismoTNR 4 роки тому +1

    VERY GOOD TUTORIAL! thank you very much!!!

  • @franktielemans6624
    @franktielemans6624 4 роки тому +2

    Another datamerge restriction is that you can't add paragraphs with bullets and numbering.
    When you choose to remove blank lines from empty fields, the record is gone, but the bullets or numbers are not!

  • @alfredvos1623
    @alfredvos1623 3 роки тому

    Hi, thanks for this helpful video. Is it possible to link to a PDF (and page in that pdf) in the excel sheet instead of linking to an image? Thanks!

  • @paulomfernandes
    @paulomfernandes Рік тому +1

    Muito bom a explicação, por mais que eu não entendi nada do que você falou. Obrigado pelo vídeo!

  • @anneschoffelmeer1871
    @anneschoffelmeer1871 3 роки тому +4

    Thank you for this advanced tutorial, really helpfull!
    Since it's been a while that this video was published... Is it still not possible to do product grouping with Data Merge? If not, do you have a tip or advise how to tackle this with Data Merge, or would you use a third party plugin for Indesign?

  • @jdosses
    @jdosses Рік тому

    Golden.

  • @zohirulislam6956
    @zohirulislam6956 4 роки тому +1

    Thanks you very much its very helpful Video, But i want to know how to make any barcode layout by using Data Merge.

  • @hannablom5803
    @hannablom5803 Рік тому +1

    I'm totally new to data merge and have only started trying to use it today. I was trying to make a data merge from an excel file (csv) where the short text within a single box was about to change. I ran into some problems though and I don't know exactly why, I only have a theory. In my document I have 14 pages, but there was only one of them that had a placeholder with the data merge header drawn into it, and I wanted the other pages to remain still and not being altered or copied. Is that possible to do in some way?? Or is every single page inside the document always copied or altered with data merge?
    The thing that happened was that the entire document, the 14 pages, multiplied for each time the page with the data merge variable created its new page, meaning I ended up with a 5010 page document 🫤
    Do you have a fixer for this?
    Really appreciate it- and thanks for a great video 🙏🌸

  • @jesicasaia8748
    @jesicasaia8748 3 роки тому

    Do you know how to do if we want to merge different workspaces from one Illustrator file?

  • @mavicariri
    @mavicariri 4 роки тому +1

    Thanks you very much for this video, its really useful! I still have a problem: "multiple records" options is not available in my document. I mean I can't change from "single records" to "multiple records", that field appears in grey with no option to interact. Any clue why this happen? Thanks!

    • @emilygoater5173
      @emilygoater5173 3 роки тому

      I had the same issue, I only managed to get this to work with single page files not facing pages. community.adobe.com/t5/indesign/data-merge-multiple-records-per-page-greyed-out/td-p/4195947?page=1

  • @biggirlgames5573
    @biggirlgames5573 3 роки тому

    Is there any way to merge data randomly from each list into each field?

  • @andreshiwa7442
    @andreshiwa7442 2 роки тому +2

    I'm using the latest AdobeIndesign CC on a Mac, in my tests, after the select the data source (csv) even choosing ALL RECORDS to merge the option RECORDS TO MERGE still disabled, and I can not select multiple records. I tried several times, but the option to select multiple records remain disabled. 🙁

    • @pagination.com-databasepub4901
      @pagination.com-databasepub4901  2 роки тому

      Is your document set up as spreads?
      Data merge does not work with spreads, only single pages.
      To change it go to File>Document Setup. In the dialog box deselect "facing pages".
      If the master page where you tagged the data has two pages, delete one.

  • @lindsaydane2603
    @lindsaydane2603 4 місяці тому

    I am putting together a program for a rewards ceremony. each page has two columns, which contain 15 names each. below the name is the department name. the dept name can be up to 3 lines. when the dept name is 1 line, I end up with two empty lines of space in that text field, instead of the text field auto resizing. how can I fix this?

  • @nemesis666first
    @nemesis666first Рік тому

    The problem is, if an image is out of the bounds of the page, the merged file will contain the image out the bound... How can we ask to the soft to CUT these images to the boundaries of the page ?

  • @christinan4112
    @christinan4112 4 роки тому

    It works!!
    But it replaces the greek words with under dash, although I tried all the possible ways (fonts, txt, csv, windows, ms-dos, ASCII, unicode).
    Can anyone help me with this? thx!

    • @lucareginato5562
      @lucareginato5562 4 роки тому

      maybe greek alphabet glyphs are missing from the font you are using?
      helpx.adobe.com/indesign/kb/error-fonts-currently-available-incopy.html

    • @christinan4112
      @christinan4112 4 роки тому

      @@lucareginato5562 thank you for your concern, but I tried several fonts (even myriad pro, which is one of the most "greek friendly" type font).
      Every time I save the excel as a txt or csv, a message informs me that the workbook contains features that will not work or may be removed

  • @ebrahimbham9542
    @ebrahimbham9542 2 роки тому

    I want to download this video to keep. How?

  • @designraid4416
    @designraid4416 2 роки тому

    I can't get (creating link for image)

  • @edwinjangao
    @edwinjangao 5 років тому

    Datamerge has trouble reading soecial characters. How to solve this?

    • @lucareginato5562
      @lucareginato5562 5 років тому +1

      Try saving the spreadsheet as Unicode .txt

  • @kota7219
    @kota7219 3 роки тому

    can i import Image from Internet by placing Web Link of Image??
    Please help

    • @snicksabea
      @snicksabea 2 роки тому

      No. Has to be a file on your computer placed near the InDesign folder.

  • @ilyassab8324
    @ilyassab8324 5 років тому +1

    when i use @images get error

    • @snicksabea
      @snicksabea 2 роки тому

      Think you have to put ‘ in front of the @ so ‘@

  • @pagination.com-databasepub4901

    Most mentioned InDesign Data Merge Limitations:
    - Cannot group products;
    - Cannot use multiple product templates;
    - Cannot insert a page break when the category changes
    To overcome these limitations, try Pagination - The Turnkey Database Publishing Service (pagination.com/) that allows you to create data-driven PDF and InDesign files in a jiffy.

    • @snap-n-shoot
      @snap-n-shoot Рік тому

      Cannot connect a URL link to text record....