Import XML from Excel

Community Beginner ,
Jun 10, 2020

Copy link to clipboard

Copied

Hi all, 

 

I have an Excel sheet with 2500 rows and 4 columns.

I want to import each row as a paragraph in the Primary Text Frame.

 

The columns are : reference, name, date, description.

I have made a xsd file like this:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <xsd:element name="Root">
    <xsd:complexType>
      <xsd:sequence>
        <xsd:element minOccurs="0" maxOccurs="unbounded" name="Article">
          <xsd:complexType>
            <xsd:sequence>
              <xsd:element name="reference" type="xsd:string"/>
              <xsd:element name="name" type="xsd:string"/>
              <xsd:element name="date" type="xsd:string" />
              <xsd:element name="description" type="xsd:string" />
            </xsd:sequence>
          </xsd:complexType>
        </xsd:element>
      </xsd:sequence>
    </xsd:complexType>
  </xsd:element>
</xsd:schema>

Then linked each Excel column to the mapping file and exported to XML data.

 

In IndDesign, when I import the XML file, only the first occurence is placed on the page.

 

What am I missing?

TOPICS
Import and export

Views

59

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

Import XML from Excel

Community Beginner ,
Jun 10, 2020

Copy link to clipboard

Copied

Hi all, 

 

I have an Excel sheet with 2500 rows and 4 columns.

I want to import each row as a paragraph in the Primary Text Frame.

 

The columns are : reference, name, date, description.

I have made a xsd file like this:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <xsd:element name="Root">
    <xsd:complexType>
      <xsd:sequence>
        <xsd:element minOccurs="0" maxOccurs="unbounded" name="Article">
          <xsd:complexType>
            <xsd:sequence>
              <xsd:element name="reference" type="xsd:string"/>
              <xsd:element name="name" type="xsd:string"/>
              <xsd:element name="date" type="xsd:string" />
              <xsd:element name="description" type="xsd:string" />
            </xsd:sequence>
          </xsd:complexType>
        </xsd:element>
      </xsd:sequence>
    </xsd:complexType>
  </xsd:element>
</xsd:schema>

Then linked each Excel column to the mapping file and exported to XML data.

 

In IndDesign, when I import the XML file, only the first occurence is placed on the page.

 

What am I missing?

TOPICS
Import and export

Views

60

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
Jun 10, 2020 0

Have something to add?

Join the conversation