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

creating a product price list using data merge

Community Beginner ,
Jul 31, 2023 Jul 31, 2023

I am trying to find a solution to improve work flow in the company I work for, and researching whether data merge could work in this case. There is a product price list that is updated fairly regular, the currecnt process can be a bit laborious and error prone.

So I was hoping we could set up a excel doc that they fill out with new products/ price updates then we simply export the file. I tried the a set up below with no luck. Is there a way to do this correctly? 
Thanks

helenb35342640_0-1690792949056.png

 

  

TOPICS
How to
730
Translate
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
Participant ,
Jul 31, 2023 Jul 31, 2023

You have to export the Excel sheet as tab-delimited (.txt) or comma-delimited (.csv) and import this as data source using the Data Merge panel in InDesign. Then you can set the placeholders. Should be no problem.

Translate
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 Beginner ,
Jul 31, 2023 Jul 31, 2023
LATEST

This is how it comes out how its set up now, it just takes the first line of info.  

helenb35342640_0-1690793775059.png

 

Translate
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