34 questions
1
vote
1
answer
94
views
XBRL validation error: xbrldie:PrimaryItemDimensionallyInvalidError
Based on taxonomy I have I try to present answers in following table structure:
Based on my current understanding (which may be wrong as I am relatively new to xbrl) I build XBRL instance:
<...
- 2,033
0
votes
0
answers
31
views
How to overcome file lock error when using Arelle with Python?
installed arelle with pip install arelle-release. Mandatory dependencies seem to be present.
After importing and initialising Cntlr, I attempted to load the target document but I am receiving a ...
2
votes
1
answer
2k
views
Extract information from financial statements from XBRL files in Python?
I am trying to parse and get information from XBRL files, and it seems there are a number of open source packages that have the ability to parse XBRL files in python. However, documentation on using ...
- 55
1
vote
0
answers
204
views
Using XBRL platform Arelle as AWS lambda function
I am trying to call Arelle in an AWS lambda function. I fail because Arelle wants to read/write the input XBRL file and the taxonomy to the read-only file sytem.
I want to request the facts. The ...
- 11
0
votes
1
answer
242
views
Cannot trigger opening of Internet browser report from within Arelle
Using arelle 1.2020.05.10 (64-bit) git master branch, with Python 3.6.9.
Installed Edgar Renderer 36.0.2 git master branch.
Opening a iXBRL file either from local machine or through URL does not open ...
- 2,463
0
votes
1
answer
159
views
Cannot open Arelle menu view to use SEC's EdgarRenderer
I have installed Arelle through git and using master branch.
Further on I am looking to use "SEC's EdgarRenderer" and made a git clone (also from it's master branch).
I copied in the ...
- 2,463
0
votes
1
answer
123
views
Getting error about bad escape during start of Arelle
I am trying to get Arelle working on Ubuntu linux 18.04 with Python 3.6.9.
Step-1: (Download Arelle software):
git clone https://github.com/Arelle/Arelle.git -b lxml
Step-2 Install Python LXML:
apt-...
- 2,463
0
votes
1
answer
413
views
How to set up Arelle to export xbrl into other postgres schema than `public`?
Here is a documentation about xbrl data exporting into postgres. Also there are XBRL-US and Abstract Model sql scripts for postgres db. The documentation also points out that export can be done into ...
- 33.3k
0
votes
1
answer
656
views
How speed up xbrl file parsing in python lxml?
I am trying to parse xbrl file (1.35Gb) via arelle. During debug I spot that execution holds on line ModelDocument.py:157. It holds more than 30 minutes. Python process take about 8Gb RAM and slowly ...
- 33.3k
1
vote
2
answers
186
views
How to split a large XBRL file?
I have xbrl file which is ~50Gb long. When I try to open it via arelle I got MemoryError. Is there a way to split xbrl file into smaller pieces? Does xbrl specification supports this?
- 33.3k
0
votes
1
answer
272
views
How set up arelle for large xbrl files?
Here is a github repository to reproduce the issue.
A main problem is memory Arelle memory usage. Even small files (AppropriationsAccountPackage.xbrl - 46Mb) take about 7+Gb RAM memory and failed to ...
- 33.3k
1
vote
1
answer
395
views
Arelle software not installing
I am attempting to install the Arelle XBRL software and these are the steps I am following.
Download the Windows 64 bit version from http://arelle.org/pub/applications/
Double click on installer
As ...
- 336
1
vote
0
answers
172
views
Company ratio calculation using arelle
Trying to generate the ratio calculation of a company using arelle where the formulas are written in a sphinx file.
The input that we are giving is an xbrl zip and the expected output is a ratio ...
1
vote
1
answer
1k
views
Use Arelle to export XLSX file
I'm trying to use Arelle to export a XLSX file from a zip of XBRL files. It works just fine when I use the EdgarRenderer plugin.
./arelleCmdLine -f data/goog-20151231.xml.zip --plugins ...
- 501
1
vote
0
answers
155
views
Arelle Webserver - How to extract the actual label text [not the Standard tag text ] from XBRL filing?
I use Arelle Webserver different views to extract tags from XBRL filing. However it looks like they do not extract the actual lable text. Is there a way to extract the actual label text [not the ...
- 113
1
vote
1
answer
289
views
Use Arelle web service with php
I used Arelle web service for getting fact list of xbrl files with the CURL in PHP language, but the answer of this web service has a long time(13 sec), are any suggestion to speed up web service ...
user7454626
2
votes
1
answer
1k
views
Get specific value from XBRL document
I've been using Gepsio to try and churn my way through standard SEC XBRL filings through their EDGAR system, and despite my numerous attempts to figure this out, it seems I'm at a loss.
When you ...
- 88
3
votes
2
answers
3k
views
Arelle Webserver - How to extract the income statement from an XBRL filing?
I am trying to extract financial statement information based on type of the statement.
Let me explain to you in a little more details.
I want to extract the income statement, balance sheet and cash ...
- 51
1
vote
1
answer
736
views
Syntax error when trying to import Cntlr from arelle module
My goal is to use Arelle (open-source platform for XBRL community) to parse XBRL docs from the SEC.
I am following instructions found here.
I successfully git cloned Arelle's code into the Lib ...
- 491
2
votes
1
answer
320
views
NSIS RMDir failing to delete user created files in ProgramData
We have a Windows application with a component that writes to the ProgramData folder. When the uninstaller is run, the files that are generated by this component are not removed. Using UAC::...
- 23
5
votes
1
answer
19k
views
How to restore postgres db from gzip file using psql? (arelle: XBRL SEC DB)
I downloaded the xbrldb_SEC_pg_2014-11-02.pg.gzip postgres pg_dump file from arelle.org. I then ran the schema ddl file in pgAdminIII and it recreated all of the databases, functions, etc.
When I try ...
- 69
1
vote
1
answer
497
views
How to combine facts , factTable and pre output views generated using Arelle's webservice api
I have started exploring Arelle for XBRL parsing. I am calling Arelle's webservice Api through java to get the various views/outputs it can generate like facts, factTable, pre etc.
In the final ...
- 81
3
votes
1
answer
976
views
How do I get started with analyzing XBRL in python?
How do i get started analyzing XBRL data?
I've heard python-xbrl should have some problems, and I'm having difficulties finding documention and examples.
I've heard that Arelle is supposed to be ...
- 708
0
votes
1
answer
230
views
extract elasticsearch date from a <start-date>/<duration> XBRL-JSON format
I am storing XBRL JSON using elasticsearch.
This xBRL-JSON OIM spec describes the oim:period property:
Otherwise, an ISO 8601 time interval representing the {interval}
property, expressed in one ...
- 20.9k
4
votes
1
answer
4k
views
How to extract financial statements only from XBRL files using Arelle's Python API?
Somehow, with the broken documentation on Arelle's python API as of date, I managed to make the API work and successfully load an XBRL file.
Anyways, my question is:
How do I extract only the ...
- 500
6
votes
1
answer
4k
views
getting XBRL data with Arelle
After looking over the documentation for arelle on their website, I found the answer. To retrieve the data you need, you can use arelleCmdLine to export a csv specifying relevant data with --...
- 491
0
votes
0
answers
1k
views
Import Error in python when non root user
I am having an issue which has been driving me crazy. I am trying to run a python script as a non root user but when I try to execute the script I get the following error.
Traceback (most recent ...
- 1,172
0
votes
1
answer
212
views
Specify a dir subdirectory from within a zip file without extracting in Windows CMD
If i am running a program (in this case arelle) from the GUI and if i want to open a zip that contains a subdirectory with subfolders the program opens a userform after i choose the zip file prompting ...
- 83
-1
votes
2
answers
4k
views
Python UnicodeDecodeError: 'utf-8' cant decode byte 0x81
I am trying to use arelle to read a zip file of an XBRL filling.
This is done by giving the command:
C:\a>python arelleCmdLine.py -f C:\Python33\sec\2010\03\0000002809-0001047469-10
-002778-xbrl....
- 83
5
votes
0
answers
322
views
Arelle locate ratio extraction command that i cannot understand to find in docs(~2pages)
The basic command while we are working with Command Line Operation in Arelle is:
python arelleCmdLine.py arguments
provided we go with the cmd to the folder that arelle is installed.
I have devoted ...
- 1,496
1
vote
1
answer
1k
views
Arelle automate small procedure to trasfer data to Excel by using Python
If we do these simple steps we will use Arelle to fetch data from the SEC EDGAR database into the Arelle program.
The steps are:
Open Arelle and click the Open web file which is an icon-button on ...
- 1,496
0
votes
1
answer
317
views
Arelle test formula
I loaded a Formula Linkbase in Arelle and want to test if the formulas are right. So I opend the "Formula Parameters and Trace Options" (Tools -> Formula -> Parameters)
When I fill the textboxes and ...
- 117
2
votes
1
answer
10k
views
Run .exe with extra parameters as Windows Service with sc create
I'm trying run following in my command prompt:
sc create mynewservice binpath="C:\Program Files\Arelle\arelleCmdLine.exe" --webserver localhost:10100
This won't succeed since there is the : ...
- 2,631
0
votes
1
answer
556
views
Arelle Xbrl validation - unable to start web service - socket error 10013
I'm using the Arelle project to implement validation of my Xbrl files.
http://arelle.org/documentation/api-web-services/
When i try to start the webserver that i can call from my code i receive ...
- 2,631