Bug 97368 - Unable to import XML Source
Summary: Unable to import XML Source
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Data-XMLsource orcus_bugs
  Show dependency treegraph
 
Reported: 2016-01-25 21:25 UTC by Olivier Hallot
Modified: 2021-11-06 00:00 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
sample XML file to import (810 bytes, text/plain)
2016-01-25 21:25 UTC, Olivier Hallot
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Olivier Hallot 2016-01-25 21:25:31 UTC
Created attachment 122205 [details]
sample XML file to import

I am trying to import a XML source file with command Data - XML Source, and following the information available in 

https://wiki.documentfoundation.org/Development/Calc/XMLSource

The file is very simple and listed below (also attached)

<?xml version="1.0" encoding="UTF-8"?>
<dvdCollection titleCollection="MyCollection"> 
  <dvd> 
    <id>1</id> 
    <category>Adventure</category>
    <titledvd>Raiders of the Lost Ark</titledvd> 
    <release-year>1981</release-year> 
    <director>Steven Spielberg</director> 
    <cast> 
      <actor>Harrison Ford</actor> 
      <actor>Karen Allen</actor> 
      <actor>John Rhys-Davies</actor> 
    </cast> 
  </dvd> 
    <dvd> 
    <id>2</id> 
    <category>Science Fiction</category>
    <titledvd>Interestella</titledvd> 
    <release-year>2014</release-year> 
    <director>Christopher Nolan</director> 
    <cast> 
      <actor>Matthew McConaughey</actor>
      <actor>Anne Hathaway</actor>
      <actor>Matt Damon</actor> 
      <actor>Michael Caine</actor> 
    </cast> .
  </dvd> 
 </dvdCollection>

Issue:
If the file has only one <dvd></dvd> node, I can import and map attributes and non recurring elements. The command does not import the node <cast></cast> even when it allows me to map to a cell (recurring elements).

If the file has two <dvd></dvd> as above, I can't map any element to any cell and thus I can't import the file
Comment 1 m_a_riosv 2016-01-26 02:05:14 UTC
Hi Oliver,

Reproducible.
Win10x64
Version: 5.0.5.1 (x64) Build ID: 7609023f63524a6c8326f6c82e7e23f55a5b7bb5

Verified also the file is well formed in http://www.w3schools.com/xml/xml_validator.asp
Comment 2 geeker 2016-03-10 17:06:31 UTC Comment hidden (obsolete)
Comment 3 Kozak Ivan 2016-04-03 09:42:26 UTC
Reproducible on Ubuntu 14.04 with sample XML file.
Version: 5.0.5.2 (x86) Build ID: 55b006a02d247b5f7215fc6ea0fde844b30035b3
Comment 4 geeker 2016-04-11 16:42:21 UTC
Reproducible on Win7x64 with sample XML file.
Version: 5.1.2.2 (x64) Build ID: d3bf12ecb743fc0d20e0be0c58ca359301eb705f
Comment 5 QA Administrators 2017-05-22 13:21:58 UTC Comment hidden (obsolete)
Comment 6 m_a_riosv 2017-05-22 15:42:56 UTC Comment hidden (obsolete)
Comment 7 Kozak Ivan 2017-05-23 05:09:26 UTC
Still
Версия: 5.3.3.2
CPU Threads: 4; OS Version: Linux 4.10; UI Render: default; VCL: gtk3; Layout Engine: new; 
Локаль: ru-RU (ru_RU.UTF-8); Calc: group
Comment 8 QA Administrators 2018-05-24 02:46:22 UTC Comment hidden (obsolete)
Comment 9 m_a_riosv 2018-05-25 11:48:26 UTC
Repro.
Version: 6.2.0.0.alpha0+
Build ID: f7f2d03bd6f5aa5dcd0f7976b4a7f2db278c2f03
CPU threads: 4; OS: Windows 10.0; UI render: GL; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-05-25_03:44:49
Locale: en-US (es_ES); Calc: group threaded
Comment 10 QA Administrators 2019-10-01 03:02:40 UTC Comment hidden (obsolete)
Comment 11 Steve Edmonds 2020-02-22 08:26:10 UTC
I can confirm this bug is still present in

Version: 6.3.5.2
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 4.12; UI render: default; VCL: kde5; 
Locale: en-NZ (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 12 Kevin Suo 2021-11-04 12:25:18 UTC
Could someone retest this to see if it is fixed by Kohei's upgrade if Orcus by commit eb07a0e76fe240a184348d96a6cebf7c0a229ac0 today?

This should be done with the Data > XML Source, not by opening the XML direcly with LibreOffice.
Comment 13 m_a_riosv 2021-11-05 21:47:50 UTC
It's Ok for me:
Version: 7.3.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 5c5f36aa73b11356a3bff0a9cc8b5fe8d1a776b9
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL

Seems the library update solves this case.