DB with MS Word .docx files breaks on base-uri()
Thursday, 27 February 2020 · 2 messages · last reply 28 Feb 2020
MS
Majewski, Steven Dennis (sdm7g)27 Feb 2020 20:35 #
With a database containing MS Word .docx zip (and other) files:
collection('BOV') ! base-uri(.)
Returns =>
Error:
Stopped at ., 1/29:
[XQST0046] URI '/BOV/DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/[Content_Types].xml' is invalid.
I’m guessing it doesn’t like the brackets as part of a URI, but since I’m adding the whole docx container, I can’t specify a different path when creating the DB.
collection('BOV') !
db:path(.)
However, works as a workaround:
DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/[Content_Types].xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/_rels/.rels DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/_rels/document.xml.rels DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/document.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/footer3.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/header1.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/footer1.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/endnotes.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/footnotes.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/_rels/header1.xml.rels DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/header2.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/_rels/footer2.xml.rels DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/footer2.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/theme/theme1.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/settings.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/styles.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/customXml/itemProps1.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/numbering.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/customXml/_rels/item1.xml.rels DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/customXml/item1.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/docProps/core.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/fontTable.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/webSettings.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/stylesWithEffects.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/docProps/app.xml DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.tei DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.dc.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/[Content_Types].xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/_rels/.rels DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/_rels/document.xml.rels DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/document.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/footer3.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/header1.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/footer2.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/footer4.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/footer1.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/footnotes.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/endnotes.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/theme/theme1.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/settings.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/styles.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/numbering.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/customXml/_rels/item1.xml.rels DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/customXml/itemProps1.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/customXml/item1.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/docProps/core.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/fontTable.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/webSettings.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/docProps/app.xml DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.dc.xml
DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.tei
...CG
Christian Grün28 Feb 2020 14:17 #
Hi Steve,
your observation reminded me of a GitHub issue that has been opened quite a while ago. I have added a pointer to your message in that issue [1], I hope we’ll find a good solution for that inconsistency. We have repeatedly postponed the fix, as it might introduce
incompatibilities with existing instances of BaseX database instances.
Cheers
Christian
[1] https://github.com/BaseXdb/basex/issues/1172#issuecomment-592507115
Quoted text · Steven Dennis (sdm7g) · 73 lines
On Thu, Feb 27, 2020 at 8:35 PM Majewski, Steven Dennis (sdm7g) <sdm7g at virginia.edu> wrote: > > With a database containing MS Word .docx zip (and other) files: > > collection('BOV') ! base-uri(.) > > Returns => > > Error: > Stopped at ., 1/29: > [XQST0046] URI '/BOV/DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/[Content_Types].xml' is invalid. > > > I’m guessing it doesn’t like the brackets as part of a URI, but since I’m adding the whole docx container, I can’t specify a different path when creating the DB. > > collection('BOV') ! db:path(.) > However, works as a workaround: > > > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/[Content_Types].xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/_rels/.rels > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/_rels/document.xml.rels > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/document.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/footer3.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/header1.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/footer1.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/endnotes.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/footnotes.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/_rels/header1.xml.rels > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/header2.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/_rels/footer2.xml.rels > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/footer2.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/theme/theme1.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/settings.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/styles.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/customXml/itemProps1.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/numbering.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/customXml/_rels/item1.xml.rels > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/customXml/item1.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/docProps/core.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/fontTable.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/webSettings.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/word/stylesWithEffects.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.docx/docProps/app.xml > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.tei > DCP-66/2015_AUG_BOV_RETREAT_MINS/2015_AUG_BOV_RETREAT_MINS.dc.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/[Content_Types].xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/_rels/.rels > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/_rels/document.xml.rels > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/document.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/footer3.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/header1.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/footer2.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/footer4.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/footer1.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/footnotes.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/endnotes.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/theme/theme1.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/settings.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/styles.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/numbering.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/customXml/_rels/item1.xml.rels > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/customXml/itemProps1.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/customXml/item1.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/docProps/core.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/fontTable.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/word/webSettings.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.docx/docProps/app.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.dc.xml > DCP-66/2010_FEB_BOARD_MINUTES/2010_FEB_BOARD_MINUTES.tei > ... >
Written for BaseX 9.3. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery