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

Import structured CSV data (into textbox not to multiple pages) using Merge Data (or other method)

Explorer ,
Dec 02, 2024 Dec 02, 2024

We would like to import structured data from a website to a print document. (artactuel.lu)

The developers could export the content the way me (graphic designer) an InDesign need it.

These 2 screenshots show the existing print document and a table I created to show the data structure.

I would at first like to know if this is possible. Any more detailed suggestions are welcome.
(sorry for may bad english)

existing print document (first issue layouted by hand)existing print document (first issue layouted by hand)expand imageData structureData structureexpand image

TOPICS
Import and export
462
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

correct answers 2 Correct answers

LEGEND , Dec 03, 2024 Dec 03, 2024

If it's TEXT ONLY - no Anchored / InLine graphics - then there is a 3rd option - InDesign Tagged Text.

 

It's kind of HTML - and you could export text fully styled from your database. 

 

You can then skip missing parts and still have everything styled correctly. 

 

There are not much specification about it - so the best approach is to prepare a sample layout in InDesign and export and then check contents of the produced file. 

 

There is also 4th option - IDML - but that would be rather too extr

...
Translate
Explorer , Dec 03, 2024 Dec 03, 2024

Oh yes that's cool!
I think Tagged Text is my solution. Thank you.
I have to experiment a little bit more...

Translate
LEGEND ,
Dec 02, 2024 Dec 02, 2024
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
Explorer ,
Dec 03, 2024 Dec 03, 2024

Thank you, the thread gave me some answers.
I can not find out how to merge my data into one single text box instead of multiple pages.

I was able to import my data and format it more or less to my needs but I always end up with multiple pages containing one line of the Excell sheet. I would like to to have the lines separated by a Return.

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
Explorer ,
Dec 03, 2024 Dec 03, 2024

I am a Step further.
Still have to find out how to get nice multiple lines seperated by line breake for the info part...

Screenshot 2024-12-03 at 10.50.53.jpgexpand image

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
LEGEND ,
Dec 03, 2024 Dec 03, 2024

As discussed in the thread provided - import it as a table - then convert to text - no need for DataMerge. 

 

You can either use my method - style each column first then convert to text - or convert to text then use Next Style method. 

 

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
Explorer ,
Dec 03, 2024 Dec 03, 2024

Ok, thank you, I now understand your method of importing a table and styling columns (next style will not work in my case as the data is 'irregular').
But isn't that a pity as my data will be exported out of  a website database and so can be exported errorless and formated in a precisely needed way. (for the moment I am just testing with a handbuild table to find out what InDesign needs and give this information to the developers)

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
LEGEND ,
Dec 03, 2024 Dec 03, 2024
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
Explorer ,
Dec 03, 2024 Dec 03, 2024

Ok I got that. Thank you.
2 questions:

  1. So do I understand right that Data merge does not do the import into one Textbox thing I asked for above?
  2. Is it possible to include the paragraph style information in the tab-delimited file? Even if it would be a very complicate file (remember we will produce this file out of a web database)

 

This will not be a one shot Job. I or even somebody else, will have to do this regurlarly. So I want be shure to use the right method and I want to automate it as much as possible. I want as much work to be done on the developers side during export.

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
LEGEND ,
Dec 03, 2024 Dec 03, 2024

If it's TEXT ONLY - no Anchored / InLine graphics - then there is a 3rd option - InDesign Tagged Text.

 

It's kind of HTML - and you could export text fully styled from your database. 

 

You can then skip missing parts and still have everything styled correctly. 

 

There are not much specification about it - so the best approach is to prepare a sample layout in InDesign and export and then check contents of the produced file. 

 

There is also 4th option - IDML - but that would be rather too extreme solution for you. 

 

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
Explorer ,
Dec 03, 2024 Dec 03, 2024

Oh yes that's cool!
I think Tagged Text is my solution. Thank you.
I have to experiment a little bit more...

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 Expert ,
Dec 03, 2024 Dec 03, 2024
LATEST

Here is the reference on tagged text--it's old but hasn't changed.

 

David Creamer: Community Expert (ACI and ACE 1995-2023)
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