Getting Started with xBRL-CSV

[Mike D]

Sorry for such a basic question - if there's a "getting started" guide I haven't managed to find yet, please feel free to point me there.

I'm trying to create an xBRL-CSV package for regulatory reporting (this is DORA, if anyone has direct experience with this). I have the full taxonomy package (available here).  

I also have a set of CSV files that are supposed to constitute the actual report data, in the format specified by the regulator.  These seem to match the formate expected by several "tableTemplates" in various <tablename>.json files in subdirectories of the reporting packages.

What I can't figure out is how to bring these together.  

I can load the "taxonomyPackage.xml" file with all the entry points into Arelle, but it tells me "no relationships for Presentation," "no relationships for Calculation," "no relationshps for Dimension".  I can't figure out how to point it at my CSV's and pull in the data.  If I try to open one of my data files after opening the taxomony file, it complains "No XBRL entry points could be loaded from the provided file."

I feel like I must be doing something obvious incorrectly, but can't figure out what from the documentation (such as it is), and googling provides bad suggestions like using the command line with a "--csvLoader file". which doesn't appear to be a valid option.

Thanks for any help.

Mike

[Austin Matherne]

Hi Mike,

Thanks for reaching out.

Could you let me know whether you’re using Arelle via the command line or the graphical user interface (GUI)? This will help me provide more targeted guidance.

Arelle should be instructed where to load the required taxonomy packages from and then pointed towards the report package zip containing the csv files. If the zip file is structured as a valid report package then Arelle will automatically detect and load the files inside.

As a helpful first step, I recommend trying to load one of the official sample DORA reports in Arelle before working with your own file. This can help confirm that your environment is set up correctly.

For example, from the command line you can load a sample DORA file and the three required taxonomy packages with the following command (you can download the files from here):

> python arelleCmdLine.py --file DUMMYLEI123456789012.CON_FR_DORA010100_DORA_2024-12-31_20241213174803429.zip \
> --package EBA_XBRL_4.0_Reporting_Frameworks_4.0.0.0.zip \
> --package EBA_XBRL_4.0_Dictionary_4.0.0.0.zip \
> --package EBA_XBRL_4.0_Severity_4.0.0.0.zip

In the GUI, taxonomy packages can be loaded using the dialog under Help > Manage packages > Locally:

Hope that helps,

Austin Matherne

[Mike D]

Thanks, Austin,

I'll use either the command line or GUI - whichever works.  The step I'm not clear in is how to execute your statement "...then pointed towards the report package zip containing the csv files."

I'll try loading with the sample file from the GUI to validate setup as suggested.  

Mike

[Austin Matherne]

> The step I'm not clear in is how to execute your statement "...then pointed towards the report package zip containing the csv files."

From the command line you use the "--file" parameter. In the example I provided the report package is the zip file "DUMMYLEI123456789012.CON_FR_DORA010100_DORA_2024-12-31_20241213174803429.zip" that contains the collection of CSV, JSON and other files that collectively make up the report.

From the GUI you would use the file open dialog to open the DUMMY report package zip file.

Either through the command line or GUI, there are two important steps.

1. Provide Arelle with the (3) required taxonomy package archive files.
   • Command line: "--package" param.
   • GUI dialog: Help > Manage packages > Locally.
2. Provide Arelle with the report package archive file.
   • Command line: "--file" param.
   • GUI dialog: File > Open.

Kind regards,

Austin 

[Mike D]

This worked perfectly - thanks!

[Austin Matherne]

Glad to hear it.