BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

Start a nNew thread

insert an xml structure in database
by Oleg Duvanayev 12 Apr '16

12 Apr '16

2 2

Re: [basex-talk] XLSX to XML
by Dirk Kirsten 11 Apr '16

11 Apr '16

Hello Florian, please remember to always include the list when replying as it allows others to benefit from our exchange as well and also allows others to help you. I just want to point out, again, that you it doesn't make sense to say "convert the excel file to xml", because it already is XML. Yes, there might be multiple XML files and they reference each other, but this is just a very normal thing for XML and for every reasonably complex system to reference each other. So I guess what you really want is an XQuery module which allows you to easily manipulate xlsx files without the need to worry about internal ooxml format stuff like shared strings. This if course makes a lot of sense! However, as the format is ridiculously complicated it is a hard task to write a general-purpose library for all kinds of manipulations. As Christian indicated we wrote for ourself some small helpers functions which dies the stuff we need in our projects, but is very far from being complete on the xlsx standard. Cheers Dirk On 04/06/2016 12:35 PM, Florian Eckey wrote: > Hello Dirk, > > thanks. That was my idea as well. But the format xlsx is really complicated, because the content (sheet01.xml) in the cells is referenced to an other document (stringValues.xml) using an index. I guess anyone has implemented a simple xquery to convert the excel file to xml? > But if nobody has done that before, i have to spend time for the implementation on my own. :) > > Thanks, best, > Florian > > > > > Am 06.04.16, 12:26 schrieb "Dirk Kirsten" <dk(a)basex.org>: > >> Hello Florian, >> >> xlsx is just a zip file containing many xml files. you can simply unzip >> the xlsx (e.g. by using the BaseX zip module), modify the xml files >> inside using standard XQuery and rezip it again as xslx. >> >> Cheers >> Dirk >> >> On 04/06/2016 12:18 PM, Florian Eckey wrote: >>> Hi guys, >>> >>> are there any ideas how to convert excel's xlsx (not xls) files to xml >>> with XQuery or to use a Java library which can be imported? It looks >>> like BaseX has no internal functions as for instance MarkLogic. >>> >>> Any ideas or example implementations to do that in XQuery or Java? >>> >>> Best, >>> Florian >> -- >> Dirk Kirsten, BaseX GmbH, http://basexgmbh.de >> |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz >> |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: >> | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle >> `-- Phone: 0049 7531 91 68 276, Fax: 0049 7531 20 05 22 >> -- Dirk Kirsten, BaseX GmbH, http://basexgmbh.de |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle `-- Phone: 0049 7531 91 68 276, Fax: 0049 7531 20 05 22

5 4

slow GUI-editor when using package-manager eXPath
by Rob Stapper 10 Apr '16

10 Apr '16

Hi Christian, New tools, new challenges. I've rearranged my source-code in packages/libraries conform the eXPath-specs in BaseX now. But since than the GUI-editor is becoming very slow, even unworkably slow. What is causing this and can you give me any tips how speed up the GUI-editor? I've got 7 libraries now. The one with the largest interface counts 11 entries in file:expath-pkg.xml, all public entries, the smallest library counts one entry. TIA, Rob

3 12

RESTXQ path preference
by Tim Thompson 10 Apr '16

10 Apr '16

Hello, Reading the draft RESTXQ spec[1], I have a question about path preference. Namely, can a bare trailing slash serve as a valid path segment? I am thinking about the pattern used by some linked data services to accommodate httpRange-14[2]. For example, VIAF (Virtual International Authority File), a popular service for library data, uses a trailing slash to differentiate between the URI for a real-world object and the URI for the Web resource that represents it. So, a GET request on the URI http://viaf.org/viaf/71387829 triggers a 303 redirect to http://viaf.org/viaf/71387829/ The RESTXQ implementation in BaseX does not seem to permit this pattern at present. If I create a resource function with a path annotation that ends in a trailing slash, the GET request returns 404. Any chance this feature could be supported? :) Best regards, Tim [1] http://exquery.github.io/exquery/exquery-restxq-specification/restxq-1.0-sp… [2] https://en.wikipedia.org/wiki/HTTPRange-14 -- Tim A. Thompson Metadata Librarian (Spanish/Portuguese Specialty) Princeton University Library

2 2

RESTXQ and Website-Building
by Günter Dunz-Wolff 10 Apr '16

10 Apr '16

Hi, I'm planning to relaunch my website (kleist-digital.de) with OpenShift as BaseX-Server. After some difficulties and a lot of help from Christian and Andy the server is running now. I took a look at RESTXQ and it seems quite interesting to build the whole frontend for my app with it. Some questions I have: 1. I'm working with a basic layout for all pages. This basic layout-file includes header, footer and changing content. What is the best approach with RESTXQ. How to build a modular concept with RESTXQ? 2. Is there any site-structure preferred? 3. Most of the site is dynamic. But I need also static files like images, css, javascript. Where to put them best (so that the Openshift-Server can handle them)? Thanks for any advice and help. Günter

4 3

Is Basex scanning static before each http-request?
by Lars Johnsen 08 Apr '16

08 Apr '16

Hi all It seems that BaseX is scanning the webapp directory including static for each request. Is that right? And is it possible to turn it off ? Best, Lars

3 3

node-basex
by kleist-digital 08 Apr '16

08 Apr '16

Hi Andy, me again. Just saw, that you’ve also written a node-based Basex-Client. My frontend is a node-app. So far I’m using AJAX-calls, to communicate via the REST-Interface with the Basex-Server, in generell I use the run command to execute different queries. Are there any advantages (disadvantages) to change to a classical Server-Client Scenario (performance, less resources, security)? You know, I want to use it in an OpenShift-Environment for the future. Thanks for any advice. Günter

2 3

XQUERY3 option
by George Sofianos 08 Apr '16

08 Apr '16

Hello, I wonder if there is any way at the moment to run scripts with xquery version 1 only. I can't find a way to set XQUERY3 option to false. I have some scripts that fail to run (process runs forever) with BaseX and I want to see if the version is causing this. I have set xquery version "1.0" encoding "UTF-8"; as the first line of my script, but it doesn't seem to do anything as well. Also is there any way to see where BaseX is consuming so much time/processing power? I can use a profiler but It's not easy to see what part of the script is causing this huge delay. Thanks.

2 3

Symlinked files with RESTXQ
by Lars Johnsen 08 Apr '16

08 Apr '16

Dear all What must be done to access symlinked files when using BaseX as http server? The scenario is that a fairly large collection of audio-files are accessed using BaseX which serves them up over http. However, it seems that symlinking (the folder with audio files exists as a symlinked copy in the static directory of the BaseX web folder) prevents the browser from accessing them. Is there a parameter in the settings I have overlooked? Best, Lars G. Johnsen National Library of Norway

3 2

Fwd: RESTXQ and Website-Building
by Günter Dunz-Wolff 08 Apr '16

08 Apr '16

Hi Christian, thanks for the tipp. I haven't noticed the files so far at all. I will have a closer look and I think a lot of questions :) Günter P.S.: Sorry for the second email, I didn't send it to the list. > > > >> Am 07.04.2016 um 17:55 schrieb Christian Grün <christian.gruen(a)gmail.com>: >> >> Hi Günter, >> >> This is just a quick reply, but you could have a look at the DBA >> XQuery code embedded with BaseX. Here, similar problems have been >> resolved: All pages have the same layout, static files are served as >> well, etc. >> >> Feel free to ask if you need some more help with the code. It’s >> definitely not perfect; for example, the function-based generation of >> buttons, tables, etc. is just one of many options, and I am convinced >> there should be better alternatives. >> >> Christian >> >> >> On Thu, Apr 7, 2016 at 5:08 PM, Günter Dunz-Wolff >> <kleist(a)mail.dunzwolff.de> wrote: >>> Hi, >>> >>> I'm planning to relaunch my website (kleist-digital.de) with OpenShift as BaseX-Server. After some difficulties and a lot of help from Christian and Andy the server is running now. >>> >>> I took a look at RESTXQ and it seems quite interesting to build the whole frontend for my app with it. Some questions I have: >>> >>> 1. I'm working with a basic layout for all pages. This basic layout-file includes header, footer and changing content. What is the best approach with RESTXQ. How to build a modular concept with RESTXQ? >>> >>> 2. Is there any site-structure preferred? >>> >>> 3. Most of the site is dynamic. But I need also static files like images, css, javascript. Where to put them best (so that the Openshift-Server can handle them)? >>> >>> Thanks for any advice and help. >>> >>> Günter >> >

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk