BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

How to export or query JSON as an array?
by thufir 17 Feb '20

17 Feb '20

Using Java, I can add JSON easily enough. But how can I get that data back as a JSONArray, or even just a List of JSONObject? https://stackoverflow.com/q/60268157/262852 which is the same question, of course. thanks, Thufir

1 1

How to programatically add JSON?
by thufir 16 Feb '20

16 Feb '20

I know I've gone around on this before, but looking to import data directly from Java. I've set the parser to "json", am only adding JSONObject string data, and not JSONArray, but am getting "resource not found": https://stackoverflow.com/questions/60250724/ What does it mean "resource not found"? The data is certainly valid, because the following will import JSON the fine, in fact it even imports the array: let $database := "blgdfmbljm" for $name in file:list('.', false(), '*.json') let $file := file:read-text($name) let $json := json:parse($file) return db:add($database, $json, $name) dummy data: [{"0":"","1":"z10","2":"y9","3":"x7","4":"atrib6","name":"alice"},{"0":"home5","1":"cell4","name":"sue"},{"0":"phone3","1":"phone2","2":"phone1","name":"joe"},{"name":"people"}] So, I guess a two-fold question: how to import a JSONArray with Java, and how to even know what resource isn't found. Doesn't seem likely to be the JSONObject as I've inspected it just prior to invoking Add. thanks, Thufir

1 0

POJO for import?
by thufir 16 Feb '20

16 Feb '20

I'm looking at the Java examples, but how would I add a POJO, or collection of POJO's, to BaseX? Jaxb looks to certainly be an option to serialize to XML, but what would be some alternate approaches? thanks, Thufir

1 0

how to export to CSV?
by thufir 16 Feb '20

16 Feb '20

What I'm trying to export to, CSV: joe,phone1,phone2,phone3, sue,cell4 ,home5,, alice,atrib6,x7,y9,z10 What needs to be done so that it can be exported to CSV: <ul> <li>joe</li> <ul>phone1</ul> <ul>phone2</ul> <ul>phone3</ul> <li>sue</li> <ul>cell4</ul> <ul>home5</ul> <li>alice</li> <ul>atrib6</ul> <ul>x7</ul> <ul>y9</ul> <ul>z10</ul> </ul> But not sure how to get from the above list, which I can rewrite as XML, to something which BaseX can then export as the desired CSV. I know that it has to be wrapped in <csv> and that <record> is used, as well. Something like: <csv> <record> <Name>Huber</Name> <First_Name>Sepp</First_Name> <Address>Hauptstraße 13</Address> <City>93547 Hintertupfing</City> </record> </csv> is what I see in the documentation, but not sure how to get there. thanks, Thufir

3 4

Flat XML fods database
by thufir 14 Feb '20

14 Feb '20

Hi all, I've loaded a .fods file from Libre Office into BaseX and am looking to identify bold cells. This is totally off-topic to BaseX itself, but does anyone have experience in working with .fods files? thanks, Thufir

3 4

Big files xsd-validation(about 256 Mbytes)
by Курмаз Данила 14 Feb '20

14 Feb '20

Hello, Could you help me? I have a big file in database and i want to validate it by XSD-schema. It doesnt'work, it crashed with error "java heap space". Thanks for help. -- Отправлено из Mail.ru для Android

1 0

Full text and stopwords
by Ben Engbers 13 Feb '20

13 Feb '20

Hi Christian, According to the docs, a stopword list can be used to decrease the size of the full text index. I had no problems when using this list while creating a database. Is it also possible to use this list for other purposes? 1 According to XQueryX 3.1.pdf it is possible to use a sequence of stopwords in a query: /books/book[@number="1"]//p contains text "propagating of errors" using stop words ("a", "the", "of"). How can I use this list in BaseX while building querys? 2 Is it possible to add words to the list, after that is has been loaded? Suppose that it shows that my text contains a lot of names that I want to exclude. How can I add those names to the stopwords list? 3 If I want to create a Wordcloud, I want to use all the words that remain after tokenization and removing all the words from the stopwords list. (I found this item 'https://en.wikibooks.org/wiki/XQuery/Tag_Cloud'. It might be a good starting point for creating a wordcloud) Cheers, Ben

2 2

XDM metadata
by Ben Engbers 13 Feb '20

13 Feb '20

Hi Christian, According to the server protocol, when first sending \04 to the server, the resulting items from the query are returned as strings, prefixed by a single byte. With my RBaseX-package, the result from "for $i in 1 to 2 return <xml>Text { $i }</xml>" is "0b" "<xml>Text 1</xml>" "0b" "<xml>Text 2</xml>" When sending \1F the strings should be prefixed by the XDM metadata. In my case however, the output is the samen as with \04. Is it possible to get the same output for querys in the basexgui so that I can see which output should be expected? This is the last remaining problem in my package. If I can resolve it, I can upload a new version. Cheers, Ben

2 2

file:move() fails when moving to another file system
by Zimmel, Daniel 12 Feb '20

12 Feb '20

Hi, I am able to file:copy() or file:write() a file from a Linux system to a Windows mount (via cifs). I am not able to file:move() to the same target. The error says "file:io-error: Die Operation ist nicht erlaubt" BaseX version is 9.2.1 Is this a bug or a known restriction with moving things around in Java? Thanks, Daniel

3 6

basexclient "Failed to construct terminal"
by Ben Engbers 11 Feb '20

11 Feb '20

Hi, It probably has been asked before but I found nothing on this topic. Whenever I try to start basex or basexclient on my Fedora 31 linux distribution, I get this output: BaseX 9.3.1 [Client] Probeer 'help' om informatie te krijgen. [ERROR] Failed to construct terminal; falling back to unsupported java.lang.NumberFormatException: For input string: "0x100" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) at java.lang.Integer.parseInt(Integer.java:580) at java.lang.Integer.valueOf(Integer.java:766) at jline.internal.InfoCmp.parseInfoCmp(InfoCmp.java:59) at jline.UnixTerminal.parseInfoCmp(UnixTerminal.java:233) at jline.UnixTerminal.<init>(UnixTerminal.java:64) at jline.UnixTerminal.<init>(UnixTerminal.java:49) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at java.lang.Class.newInstance(Class.java:442) at jline.TerminalFactory.getFlavor(TerminalFactory.java:209) at jline.TerminalFactory.create(TerminalFactory.java:100) at jline.TerminalFactory.get(TerminalFactory.java:184) at jline.TerminalFactory.get(TerminalFactory.java:190) at jline.console.ConsoleReader.<init>(ConsoleReader.java:240) at jline.console.ConsoleReader.<init>(ConsoleReader.java:232) at jline.console.ConsoleReader.<init>(ConsoleReader.java:220) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.basex.util.ConsoleReader$JLineConsoleReader.<init>(ConsoleReader.java:146) at org.basex.util.ConsoleReader.get(ConsoleReader.java:55) at org.basex.BaseX.console(BaseX.java:166) at org.basex.BaseX.<init>(BaseX.java:152) at org.basex.BaseXClient.<init>(BaseXClient.java:35) at org.basex.BaseXClient.main(BaseXClient.java:22) 'basex help' gives this output: Gestopt bij /home/bengbers/, 1/5: [XPDY0002] element(help): Context is undeclared. Am I missing something? Cheers, Ben

3 9

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk