Hi,
I am trying to store an EBA DPM (3.2) Taxonomy to my SQLite database using the XBRL Database plugin.
I can load and validate the taxonomy as expected, but when I try to save it to my database, I get a missing tables exception (The following tables are missing: dFact, dFilingIndicator, dInstance, mConcept, mDomain, mMember, mModule, mOwner, mTemplateOrTable). I can't however find the structure or contents of these tables in any of the Arelle documentation, nor in the script itself (XbrlDpmSqlDB.py).
Any ideas where I might be able to find the structure of these tables so I can manually create them in my database?
Thanks,
Jon
[xpDB:exception] Loading XBRL DB: XPDBException: [sqlDB:MissingTables] exception: The following tables are missing: dFact, dFilingIndicator, dInstance, mConcept, mDomain, mMember, mModule, mOwner, mTemplateOrTable
[' File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\__init__.py", line 111, in backgroundStoreIntoDB\n insertIntoDB(cntlr.modelManager.modelXbrl,\n', ' File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\XbrlDpmSqlDB.py", line 102, in insertIntoDB\n xbrlDbConn.verifyTables()\n', ' File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\XbrlDpmSqlDB.py", line 203, in verifyTables\n raise XPDBException("sqlDB:MissingTables",\n']
[xpDB:exception] Loading XBRL DB: XPDBException: [sqlDB:MissingTables] exception: The following tables are missing: dFact, dFilingIndicator, dInstance, mConcept, mDomain, mMember, mModule, mOwner, mTemplateOrTable
[' File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\__init__.py", line 111, in backgroundStoreIntoDB\n insertIntoDB(cntlr.modelManager.modelXbrl,\n', ' File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\XbrlDpmSqlDB.py", line 102, in insertIntoDB\n xbrlDbConn.verifyTables()\n', ' File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\XbrlDpmSqlDB.py", line 203, in verifyTables\n raise XPDBException("sqlDB:MissingTables",\n']