On 2012-10-05 02:22, Jay Lozier wrote:
Some of the XML files I import have nested lists, i.e not flat. I like
to define how these are imported.
The file also has a lot of fields I don't want imported (not shown). So
by using a filter I get what I want displayed how I want.
On 10/04/2012 08:11 AM, Andreas Säger wrote:
Mark Stanton wrote
I hope not, XML is supposed to be a self defining file format surely?
It's a meta-file format. You (who defines all the XML tags) are the one and
only person able to develop import and export software for your particular
flavour of XML.
How would you translate this into a spreadsheet? Is BLAH a row, a column?
What is scramble? How to deal with the attributes?
Nobody ever tells us anything about his/her user-defined file formats such
as CSV or XML. So most of the topics becaome lengthy and some remain
A general importer ought to be easy, no?
Google reveals plenty of examples about how to write XLST scritpts to
import/export user-defined XML formats into/from ODF. This is development
work just like writing macros or setting up a database.
In all those years since OOo 1.0 nobody wrote a generic XML-to-Calc tool. I
would search in the database world for existing XML tools for database
engines. Once you have the data in a connectable database, you have it it in
Calc and Writer as well.
View this message in context:
Sent from the Users mailing list archive at Nabble.com.
My understanding the problem with importing a generic XML file is that
the document definition does not a (defacto) "standard" that one can
write an import script for? If the XML file uses a known definition (ODF
for example) then it is easier to write an import script because there
is a "standard" defining the document internals.
The extension of this is, if the file format is well documented, even if
it is proprietary, then writing an import script is possible because
there exists a specification for the format. The only issue then is
whether one has the complete format specification.
<?xml version="1.0" encoding="UTF-8"?>
<name>AE-United Arab Emirates</name>
<name>MNA-Middle East & N Africa</name>
For unsubscribe instructions e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy