Store to XBRL DB - DPM

135 views
Skip to first unread message

Jon

unread,
Sep 25, 2023, 6:12:29 AM9/25/23
to Arelle-users
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'] 
Reply all
Reply to author
Forward
0 new messages