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 > ... >

⚡Generated with XQuery