- BaseX-Talk - mailman.uni-konstanz.de

How to save Table views as spreadsheet
by kalamegham＠gmail.com 21 Dec '16

21 Dec '16

I am new to BaseX which I find as a powerful tool to work on xml data. The BaseX GUI is great. My question is: how can I save the Tables in the visualization as spreadsheet(s). I understand there are multiple views but it should be possible to save them as separate tables or tabs in a single spreadsheet. I apologize if this has been addresses in an earlier talk. I would like to know if there is a way to quickly search the base-talk archives without having to look through them all (arranged by month). Thanks! -R. Kalamegham

4 3

Understanding the WRITEBACK option, help
by Enea Parimbelli 20 Dec '16

20 Dec '16

Dear BaseX folks, I'm having trouble understanding the subtleties of the WRITEBACK option. I found this issue report that seems to describe my case as well but it refers to a rather old baseX version. https://github.com/BaseXdb/basex/issues/848 As I understand it the WRITEBACK option will only work for files directly read from disk and not for those that have been added to a database at time of creation. I have created my database with a input path that already held all the xmls I needed to import: Resource Properties Input Path: /home/enea/tmp/AF PHR extraction ALL DATA Input Size: 74 MB Timestamp: 2016-12-19T08:45:34.841Z Encoding: UTF-8 CHOP: true Does the above still apply to baseX 8.2.3? If the issue has been addressed can you describe how the current implementation works? Is the only workaround to this explicitly calling EXPORT after all the update/insertion/deletion queries to see the modifications reflected in the original files on disk? Thanks for your help, Enea -- *Enea Parimbelli, Ph.D.* Post-doc research fellow | Biomedical informatics lab "Mario Stefanelli" Department of Electrical, Computer and Biomedical Engineering University of Pavia Via Ferrata 5, 27100, Pavia (Italy)

2 2

Waiting for BaseX 8.6?
by Christian Grün 19 Dec '16

19 Dec '16

Hi everyone, I know some of you are waiting for BaseX 8.6, and I promised to make it happen until end of this year. I am afraid we won’t make it in time, but you can definitely expect the new version in January! Until then, as usual, we are looking forward to your feedback on our latest snapshot [1]. All the best, Christian [1] http://files.basex.org/releases/latest/

1 0

BaseX Client for PL/SQL
by Zachary N. Dean 06 Dec '16

06 Dec '16

Hi all, I've seen that quite a few people use BaseX to pull data from RDBMS's. I've started a project (https://github.com/zadean/pl-sql-BaseX) that goes the other direction. Using DB sessions as BaseX client sessions. It's currently only for Oracle (maybe postgres would work with only minor changes?) (other DB's to come. maybe :) ) . Some things just aren't that nice to do in the DB, and the XQuery processors in the DB do their own thing. So, this seemed like a nice way to get the benefits of BaseX from within the DB itself. Hope it comes in handy! Happy coding, Zachary Dean

2 1

xquery for position
by George Sofianos 01 Dec '16

01 Dec '16

Hi, I'm having some issues with finding the position of a value in a for loop. My query is complex so I can't write it in an example here (at least for the moment). I think the XQuery optimizer messes up with it. The result I get from the for loop is something like this for every return entry: <element>2113 - 11953 - 8760</element> where 2113 is the stuck $pos, 11953 is the count $count, and 8760 is the number of values in the sequence I'm looping on. Any Ideas? Can I disable part of the optimizer and see if that is the problem ? p.s1 I'm already using declare option db:inlinelimit '0'; because I've noticed some time ago it helps with compiling the XQuery files (without this, I have cases of very slow or freezing compilations). p.s2 I've also had issues this with Saxon involving $pos.

2 2

Running REST service while in embedded mode?
by Mike Maul 01 Dec '16

01 Dec '16

Is it possible to run basex in embedded mode and also start REST service in another thread?

2 2

C# Client - Updating query
by Chris Speare 29 Nov '16

29 Nov '16

Hi all, Trying to use the C# client available from https://github.com/BaseXdb/basex/tree/master/basex-api/src/main/c%23 to perform an update query, however I must be missing the obvious - query runs and no exceptions are raised, however the XML remains un-changed. Code snippet (as this is held on a different machine): String base_update_query = @"xquery version '3.0'; let $invoice := db:open('{0}')/CommercialDocument[Customer/@id={1}] return replace value of node $invoice/InvoiceNumber with '{2}'"; .... Session session = new Session("localhost", 1984, "admin", "my_pass"); Query q = session.Query( String.Format( base_update_query, String.Concat("billing_run_", billing_run_id), customer_id, invoice_number ) ); .... >From the BaseX logs I then see entries: QUERY[1] xquery version '3.0'; let $invoice := db:open('billing_run_506')/CommercialDocument[Customer/@id=437] return replace value of node $invoice/InvoiceNumber with '28443' so I know the query reached the server, and the response seems to be "not error" as no exception is being raised - however the XML document hasn't been updated. Yet if I run the same query in either the client or web client it works (document updates) - provided I switch the query to "updating" not read-only. Is there a flag I've missed, or is .Query of Session the wrong method to use Kind regards Chris Speare The information contained in the email and any files transmitted with it is confidential and intended for the addressee only. If you have received this email in error please accept our apologies and notify the originator. Any disclosure, copying, distribution or any other use of this communication is strictly prohibited and may be unlawful. We reserve the right to monitor and intercept communications for lawful business purposes. Wireless Innovation Ltd , Unit D2, Churcham Business Park, Churcham, Gloucestershire, GL2 8AX, Great Britain. Company Registration Number 5240202, Place of Registration Companies House Cardiff.

2 4

XQuerry Help on Collections
by Mike Maul 29 Nov '16

29 Nov '16

I'm struggling a bit with XQuery especially in terms of collections. How would one take q query like for $x in doc('src/main/resources/xml/input.xml')//li return data($x) and apply it to a database with a collection of documents? What I'm after is something like: for $x in doc(*)//li return data($x) Also how are namespaces referenced/specified in queries? Finally if anyone as any good XQuery resources would appreciate if if you could pass them along...

2 1

No namespace for multiple commands in POST?
by Arjan Loeffen 27 Nov '16

27 Nov '16

I'm trying to REST POST a sequence of commands in accordance with http://docs.basex.org/wiki/Commands#XML_Syntax I get the error response: *cvc-elt.1: Cannot find the declaration of element 'commands'.* Is there a namespace for <commands> wrapper element? I'd expect it to be http://basex.org/rest but the same message is returned on the qualified name: *cvc-elt.1: Cannot find the declaration of element 'basex:commands'.* Using Basex 8.5.3 Thanks in advance, -- Arjan Loeffen, Armatiek BV 06-12918997

2 1

docker images broken?
by Maximilian Gärber 25 Nov '16

25 Nov '16

Hi, I tried the image on a new server and I get: basex_1 | Creating /srv/BaseXWeb/WEB-INF/web.xml basex_1 | java.nio.file.NoSuchFileException: /srv/BaseXWeb/WEB-INF/web.xml basex_1 | at sun.nio.fs.UnixException.translateToIOException(UnixException.java:86) is the image broken? Regards, Max

1 1