Bug 105356 - Calc can not import xml file?
Summary: Calc can not import xml file?
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.3.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-01-16 06:51 UTC by diri
Modified: 2017-01-25 19:32 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description diri 2017-01-16 06:51:18 UTC 
Trying to import xml file, size is 6751 kb. Can not assign cells - Calc does nothing for more than an hour with recent hardware. Works fine with Excel within seconds.

dtd:
<!ELEMENT xml (product+)>
<!ELEMENT product (orderNumber, supplierNumber, supplier, name, variant, year, category, is_bike, stock, pack_unit, vat, uvp, uvp_groups, config, properties, images, downloads, links, shortDescription, longDescription, geometrie, material, translations)>
<!ELEMENT orderNumber (#PCDATA)>
<!ELEMENT supplierNumber (#PCDATA)>
<!ELEMENT supplier (#PCDATA)>
<!ELEMENT name (#PCDATA)>
<!ELEMENT variant (#PCDATA)>
<!ELEMENT year (#PCDATA)>
<!ELEMENT category (#PCDATA)>
<!ELEMENT is_bike (#PCDATA)>
<!ELEMENT stock (#PCDATA)>
<!ELEMENT pack_unit (#PCDATA)>
<!ELEMENT vat (#PCDATA)>
<!ELEMENT uvp (#PCDATA)>
<!ELEMENT uvp_groups (uvp_04, uvp_05, uvp_06, uvp_07, uvp_08, uvp_09, uvp_10, uvp_11, uvp_12, uvp_13, uvp_14, uvp_15, uvp_16, uvp_EK-CH)>
<!ELEMENT uvp_04 (#PCDATA)>
<!ATTLIST uvp_04
          type CDATA #REQUIRED>
<!ELEMENT uvp_05 (#PCDATA)>
<!ATTLIST uvp_05
          type CDATA #REQUIRED>
<!ELEMENT uvp_06 (#PCDATA)>
<!ATTLIST uvp_06
          type CDATA #REQUIRED>
<!ELEMENT uvp_07 (#PCDATA)>
<!ATTLIST uvp_07
          type CDATA #REQUIRED>
<!ELEMENT uvp_08 (#PCDATA)>
<!ATTLIST uvp_08
          type CDATA #REQUIRED>
<!ELEMENT uvp_09 (#PCDATA)>
<!ATTLIST uvp_09
          type CDATA #REQUIRED>
<!ELEMENT uvp_10 (#PCDATA)>
<!ATTLIST uvp_10
          type CDATA #REQUIRED>
<!ELEMENT uvp_11 (#PCDATA)>
<!ATTLIST uvp_11
          type CDATA #REQUIRED>
<!ELEMENT uvp_12 (#PCDATA)>
<!ATTLIST uvp_12
          type CDATA #REQUIRED>
<!ELEMENT uvp_13 (#PCDATA)>
<!ATTLIST uvp_13
          type CDATA #REQUIRED>
<!ELEMENT uvp_14 (#PCDATA)>
<!ATTLIST uvp_14
          type CDATA #REQUIRED>
<!ELEMENT uvp_15 (#PCDATA)>
<!ATTLIST uvp_15
          type CDATA #REQUIRED>
<!ELEMENT uvp_16 (#PCDATA)>
<!ATTLIST uvp_16
          type CDATA #REQUIRED>
<!ELEMENT uvp_EK-CH (#PCDATA)>
<!ATTLIST uvp_EK-CH
          type CDATA #REQUIRED>
<!ELEMENT config (Farbe | Variante | Steurrohrlaenge | Groesse | Option)+>
<!ELEMENT properties (Ausstattung | Filter)+>
<!ELEMENT images (image*)>
<!ELEMENT image (#PCDATA)>
<!ATTLIST image
          type CDATA #IMPLIED>
<!ELEMENT downloads (download?)>
<!ELEMENT links (links?)>
<!ATTLIST links
          name CDATA #IMPLIED>
<!ELEMENT shortDescription (#PCDATA)>
<!ELEMENT longDescription (#PCDATA)>
<!ELEMENT geometrie (#PCDATA)>
<!ELEMENT material (#PCDATA)>
<!ELEMENT translations (EN)>
<!ELEMENT EN (geometrie?, name?, shortDescription?, longDescription?)>
<!ELEMENT Farbe (#PCDATA)>
<!ELEMENT Variante (#PCDATA)>
<!ELEMENT download (#PCDATA)>
<!ATTLIST download
          name CDATA #REQUIRED>
<!ELEMENT Groesse (#PCDATA)>
<!ELEMENT Filter (Einsatzbereich | Federweg | Kategorie | Bekleidung | Laufradgroesse)+>
<!ELEMENT Laufradgroesse (#PCDATA)>
<!ELEMENT Einsatzbereich (#PCDATA)>
<!ELEMENT Federweg (#PCDATA)>
<!ELEMENT Kategorie (#PCDATA)>
<!ELEMENT Ausstattung (Antrieb | Bremse | Gabel | Griffe | Kassette | Laufrad | Lenker | Lieferumfang | Reifen | Rotor | Sattel | Sattelstuetze | Schalthebel | Schaltwerk | Steuersatz | Steckachse | Umwerfer | Vorbau | Batterie | Kettenfuehrung | Kurbel | City_Kit | Display | AMG_Riding_Package | Suspension_Setup | Pedale | Sattelstuetze-_Option | Federelement | Zubehoer)+>
<!ELEMENT Steuersatz (#PCDATA)>
<!ELEMENT Federelement (#PCDATA)>
<!ELEMENT Steckachse (#PCDATA)>
<!ELEMENT Option (#PCDATA)>
<!ELEMENT Bremse (#PCDATA)>
<!ELEMENT Griffe (#PCDATA)>
<!ELEMENT Kassette (#PCDATA)>
<!ELEMENT Kurbel (#PCDATA)>
<!ELEMENT Rotor (#PCDATA)>
<!ELEMENT Schalthebel (#PCDATA)>
<!ELEMENT Umwerfer (#PCDATA)>
<!ELEMENT Schaltwerk (#PCDATA)>
<!ELEMENT Sattel (#PCDATA)>
<!ELEMENT Reifen (#PCDATA)>
<!ELEMENT Laufrad (#PCDATA)>
<!ELEMENT Lenker (#PCDATA)>
<!ELEMENT Vorbau (#PCDATA)>
<!ELEMENT Sattelstuetze-_Option (#PCDATA)>
<!ELEMENT Gabel (#PCDATA)>
<!ELEMENT Sattelstuetze (#PCDATA)>
<!ELEMENT AMG_Riding_Package (#PCDATA)>
<!ELEMENT Suspension_Setup (#PCDATA)>
<!ELEMENT Pedale (#PCDATA)>
<!ELEMENT Zubehoer (#PCDATA)>
<!ELEMENT Antrieb (#PCDATA)>
<!ELEMENT Batterie (#PCDATA)>
<!ELEMENT Display (#PCDATA)>
<!ELEMENT Kettenfuehrung (#PCDATA)>
<!ELEMENT City_Kit (#PCDATA)>
<!ELEMENT Lieferumfang (#PCDATA)>
<!ELEMENT Bekleidung (#PCDATA)>
<!ELEMENT Steurrohrlaenge (#PCDATA)>

xsd:
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
  <xs:element name="xml">
    <xs:complexType>
      <xs:sequence>
        <xs:element ref="product" maxOccurs="unbounded"/>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="product">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="orderNumber" type="xs:string"/>
        <xs:element name="supplierNumber" type="xs:string"/>
        <xs:element name="supplier" type="xs:string"/>
        <xs:element name="name" type="xs:string"/>
        <xs:element name="variant" type="xs:string"/>
        <xs:element name="year" type="xs:string"/>
        <xs:element name="category" type="xs:string"/>
        <xs:element name="is_bike" type="xs:string"/>
        <xs:element name="stock" type="xs:string"/>
        <xs:element name="pack_unit" type="xs:string"/>
        <xs:element name="vat" type="xs:string"/>
        <xs:element name="uvp" type="xs:string"/>
        <xs:element ref="uvp_groups"/>
        <xs:element ref="config"/>
        <xs:element ref="properties"/>
        <xs:element ref="images"/>
        <xs:element ref="downloads"/>
        <xs:element ref="links"/>
        <xs:element name="shortDescription" type="xs:string"/>
        <xs:element name="longDescription" type="xs:string"/>
        <xs:element name="geometrie" type="xs:string"/>
        <xs:element name="material" type="xs:string"/>
        <xs:element ref="translations"/>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_groups">
    <xs:complexType>
      <xs:sequence>
        <xs:element ref="uvp_04"/>
        <xs:element ref="uvp_05"/>
        <xs:element ref="uvp_06"/>
        <xs:element ref="uvp_07"/>
        <xs:element ref="uvp_08"/>
        <xs:element ref="uvp_09"/>
        <xs:element ref="uvp_10"/>
        <xs:element ref="uvp_11"/>
        <xs:element ref="uvp_12"/>
        <xs:element ref="uvp_13"/>
        <xs:element ref="uvp_14"/>
        <xs:element ref="uvp_15"/>
        <xs:element ref="uvp_16"/>
        <xs:element ref="uvp_EK-CH"/>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_04">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_05">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_06">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_07">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_08">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_09">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_10">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_11">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_12">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_13">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_14">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_15">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_16">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="uvp_EK-CH">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="config">
    <xs:complexType>
      <xs:choice maxOccurs="unbounded" minOccurs="0">
        <xs:element name="Farbe" type="xs:string"/>
        <xs:element name="Variante" type="xs:string"/>
        <xs:element name="Steurrohrlaenge" type="xs:string"/>
        <xs:element name="Groesse" type="xs:string"/>
        <xs:element name="Option" type="xs:string"/>
      </xs:choice>
    </xs:complexType>
  </xs:element>
  <xs:element name="properties">
    <xs:complexType>
      <xs:choice maxOccurs="unbounded" minOccurs="0">
        <xs:element ref="Ausstattung"/>
        <xs:element ref="Filter"/>
      </xs:choice>
    </xs:complexType>
  </xs:element>
  <xs:element name="images">
    <xs:complexType>
      <xs:sequence minOccurs="0">
        <xs:element ref="image" minOccurs="0" maxOccurs="unbounded"/>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="image">
    <xs:complexType mixed="true">
      <xs:attribute name="type" type="xs:string"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="downloads">
    <xs:complexType>
      <xs:sequence minOccurs="0">
        <xs:element ref="download" minOccurs="0"/>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="links">
    <xs:complexType mixed="true">
      <xs:sequence minOccurs="0">
        <xs:element ref="links" minOccurs="0"/>
      </xs:sequence>
      <xs:attribute name="name" type="xs:string"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="translations">
    <xs:complexType>
      <xs:sequence>
        <xs:element ref="EN"/>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="EN">
    <xs:complexType>
      <xs:sequence minOccurs="0">
        <xs:element name="geometrie" type="xs:string"/>
        <xs:element name="name" type="xs:string"/>
        <xs:element name="shortDescription" type="xs:string"/>
        <xs:element name="longDescription" type="xs:string"/>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="download">
    <xs:complexType mixed="true">
      <xs:attribute name="name" type="xs:string" use="required"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="Filter">
    <xs:complexType>
      <xs:choice maxOccurs="unbounded" minOccurs="0">
        <xs:element name="Einsatzbereich" type="xs:string"/>
        <xs:element name="Federweg" type="xs:string"/>
        <xs:element name="Kategorie" type="xs:string"/>
        <xs:element name="Bekleidung" type="xs:string"/>
        <xs:element name="Laufradgroesse" type="xs:string"/>
      </xs:choice>
    </xs:complexType>
  </xs:element>
  <xs:element name="Ausstattung">
    <xs:complexType>
      <xs:choice maxOccurs="unbounded" minOccurs="0">
        <xs:element name="Antrieb" type="xs:string"/>
        <xs:element name="Bremse" type="xs:string"/>
        <xs:element name="Gabel" type="xs:string"/>
        <xs:element name="Griffe" type="xs:string"/>
        <xs:element name="Kassette" type="xs:string"/>
        <xs:element name="Laufrad" type="xs:string"/>
        <xs:element name="Lenker" type="xs:string"/>
        <xs:element name="Lieferumfang" type="xs:string"/>
        <xs:element name="Reifen" type="xs:string"/>
        <xs:element name="Rotor" type="xs:string"/>
        <xs:element name="Sattel" type="xs:string"/>
        <xs:element name="Sattelstuetze" type="xs:string"/>
        <xs:element name="Schalthebel" type="xs:string"/>
        <xs:element name="Schaltwerk" type="xs:string"/>
        <xs:element name="Steuersatz" type="xs:string"/>
        <xs:element name="Steckachse" type="xs:string"/>
        <xs:element name="Umwerfer" type="xs:string"/>
        <xs:element name="Vorbau" type="xs:string"/>
        <xs:element name="Batterie" type="xs:string"/>
        <xs:element name="Kettenfuehrung" type="xs:string"/>
        <xs:element name="Kurbel" type="xs:string"/>
        <xs:element name="City_Kit" type="xs:string"/>
        <xs:element name="Display" type="xs:string"/>
        <xs:element name="AMG_Riding_Package" type="xs:string"/>
        <xs:element name="Suspension_Setup" type="xs:string"/>
        <xs:element name="Pedale" type="xs:string"/>
        <xs:element name="Sattelstuetze-_Option" type="xs:string"/>
        <xs:element name="Federelement" type="xs:string"/>
        <xs:element name="Zubehoer" type="xs:string"/>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>
Comment 2 diri 2017-01-24 03:49:19 UTC 
Hi,

I took approach mentioned (https://wiki.documentfoundation.org/Development/Calc/XMLSource) like it's most likely way gone by every normal user.

This form opens and shows elements but, there is no chance to assign cells. It stands and simply does nothing. All elements are grayed out.

I'm happy about one chance in this situation:
Cancel works.

Best regards,

diri
Comment 3 Buovjaga 2017-01-24 16:55:28 UTC 
Ok, let's close. You need to look into the Python solution.
Comment 4 diri 2017-01-24 17:25:56 UTC 
That's no solution for trivial users. Let's go back to MS Office.
Comment 5 Buovjaga 2017-01-24 17:48:48 UTC 
(In reply to diri from comment #4)
> That's no solution for trivial users. Let's go back to MS Office.

Ok. Maybe, if you could have shared the XML this bug report could be kept open. But I understood it contains private information as you did not attach it.
There is already a similar report bug 97368 but it has the XML attached.
Comment 6 diri 2017-01-25 19:30:15 UTC 
I'm very sorry but, there's a non-disclosure agreement related to data in xml. I'm not sure about data already provided because it's "only" desciptive. It should not be that private to solve a problem.

Think about 20.000 - 30.000 products in xml. Some of them have all attributes, some only several ones.

As I wrote before:
In Excel it's displayed correct within one or two seconds (depends on hardware used). In Calc nothing happens except opening windows "assign cells".


Thanks,

diri
Comment 7 diri 2017-01-25 19:32:18 UTC 
Addendum:

Data already provided show a much more complicated structur as mentioned in other bugreport. When even such trivial structures are not imported there seems to be something very wrong ...

Kind regards,

diri