Is there a simpler example about the use of XML in InDesign?

Contributor ,
Jan 07, 2022 Jan 07, 2022

Copy link to clipboard

Copied

Is there a simpler example about the use of XML in InDesign?
I want to learn how to use XML in InDesign. I read the Adobe help document, and it is too advanced but not practical.
Is there a simpler example to share?
Do I need to build a DTD first?
For example, I now have a basic student information form info.xlsx

I want to use XML to realize the import, and in the future, users can add or delete in Excel, or modify the table.
My InDesign file is automatically updated.

I want to use XML to achieve, not variable data (or called data merging)
What should I do, can you help me?
DTD can be in any form, as you think

 

It is best to provide InDesign files
Thank you so much

6602.jpg

 

My xlsx file is here 

 

TOPICS
Feature request , How to , Import and export , Performance , Scripting , Server developers

Views

166

Likes

Translate

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
Contributor ,
Jan 07, 2022 Jan 07, 2022

Copy link to clipboard

Copied

If the table in my Excel file has 10 rows,
For example, my ID file is like the following, how to read the table in the excel file
My ID table has only 2 rows, will the remaining rows be added automatically?

 

ID File

 

62666.jpg

Likes

Translate

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
Guru ,
Jan 07, 2022 Jan 07, 2022

Copy link to clipboard

Copied

Here's a brief description of how to prepare an XML file for InDesign from Excel.

For details, read Designer's Guide to Adobe InDesign and XML by James Maivald.

Likes

Translate

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
Contributor ,
Jan 07, 2022 Jan 07, 2022

Copy link to clipboard

Copied

Thank you very much~
I found this too, and it's pretty good.
Unfortunately, I can't connect to youtube

Likes

Translate

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
Contributor ,
Jan 07, 2022 Jan 07, 2022

Copy link to clipboard

Copied

Likes

Translate

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
LEGEND ,
Jan 08, 2022 Jan 08, 2022

Copy link to clipboard

Copied

Do you really want to use XML? I think you may have latched onto this even though it isn't what you need. Did you look into using the regular, pretty simple, data merge? This is based on CSV files, which can be exported from Excel in seconds.

Likes

Translate

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
Adobe Community Professional ,
Jan 08, 2022 Jan 08, 2022

Copy link to clipboard

Copied

>>, and in the future, users can add or delete in Excel, or modify the table. My InDesign file is automatically updated.

 

If this is your goal, InDesign can link to an Excel file and update a table without any need for XML.

David Creamer
Adobe Certified Instructor, Adobe Certified Professional, and Adobe Certified Expert

Likes

Translate

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
Contributor ,
Jan 08, 2022 Jan 08, 2022

Copy link to clipboard

Copied

Using and updating Excel is just one example I gave.
Since I don't understand XML, I think it's magic.
I want to learn and understand XML, maybe I will use it later.

-----

Also, I want to ask, why can't I edit the post I just made
at community.adobe.com

 

Likes

Translate

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
Contributor ,
Jan 08, 2022 Jan 08, 2022

Copy link to clipboard

Copied

Here comes the problem, I modified my XML file,
My InDesign files won't update automatically?
I need to reimport?

Likes

Translate

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
Adobe Community Professional ,
Jan 08, 2022 Jan 08, 2022

Copy link to clipboard

Copied

LATEST

You may want to look at Adobe FrameMaker too. It's XML features surpass InDesign's. 

David Creamer
Adobe Certified Instructor, Adobe Certified Professional, and Adobe Certified Expert

Likes

Translate

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