Bug 36610 - xml IMPORT
Summary: xml IMPORT
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-04-26 09:13 UTC by Fernand
Modified: 2012-08-31 10:04 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
filer to import xml data into LO spreadsheet (10.83 KB, text/xml)
2011-04-26 09:13 UTC, Fernand
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Fernand 2011-04-26 09:13:38 UTC
Created attachment 46091 [details]
filer to import xml data into LO spreadsheet

For importing xml data (mostly SQL dumps) into a LO spreadsheet there is only one useable filter available (StarXpert_Xml2Calc.xsl). This filter works fine until all "elements" are present.
With the attached filter

<titre>TEST1</titre>
<code>57600</code>
<ville>Mans</ville>
<titre>TEST2</titre>
<code>53500</code>
<ville>Ours</ville>

makes a nice Spreadsheet
titre;code;ville
TEST1;57600;Mans
TEST2;53500;Ours

but

<titre>TEST1</titre>
<code>57600</code>
<ville>Mans</ville>
<titre>TEST2</titre>
<ville>Ours</ville>
makes a spreadsheet with moved columns
titre;code;ville
TEST1;57600;Mans
TEST2;Ours

Please correct the filter, or gives me gints to do it myself. In the xsl file you find French comments, when you need a translation to English giove me a gint.
After i can publish the filter as a extension
Comment 1 Cor Nouws 2011-09-07 13:43:56 UTC
Hi Fernand,

(In reply to comment #0)

> Please correct the filter, or gives me gints to do it myself. In the xsl file
> you find French comments, when you need a translation to English giove me a
> gint.
> After i can publish the filter as a extension

I guess you mean to ask for a 'hint'?
Pls write to the developer list or ask on IRC.: the people will be glad to help you.

(irc and such mentioned here:
  http://wiki.documentfoundation.org/Development )

Thanks!
Comment 2 Björn Michaelsen 2011-12-23 12:05:50 UTC
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 3 Florian Reisinger 2012-08-14 13:59:37 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 4 Florian Reisinger 2012-08-14 14:00:48 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 5 Florian Reisinger 2012-08-14 14:05:31 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 6 Florian Reisinger 2012-08-14 14:07:32 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian