Skip to main content

XBRL-XML to XBRL-CSV converter for EBA Taxonomy (version 4.1)

Project description

PyPI version Python versions License Build status

Overview

XBridge is a Python library for converting XBRL-XML files into XBRL-CSV files using the EBA (European Banking Authority) taxonomy. It provides a simple, reliable way to transform regulatory reporting data from XML format to CSV format.

The library currently supports EBA Taxonomy version 4.2 and includes support for DORA (Digital Operational Resilience Act) CSV conversion. The library must be updated with each new EBA taxonomy version release.

Key Features

  • XBRL-XML to XBRL-CSV Conversion: Seamlessly convert XBRL-XML instance files to XBRL-CSV format

  • Command-Line Interface: Quick conversions without writing code using the xbridge CLI

  • Python API: Programmatic conversion for integration with other tools and workflows

  • EBA Taxonomy 4.2 Support: Built for the latest EBA taxonomy specification

  • DORA CSV Conversion: Support for Digital Operational Resilience Act reporting

  • Configurable Validation: Flexible filing indicator validation with strict or warning modes

  • Decimal Handling: Intelligent decimal precision handling with configurable options

  • Type Safety: Fully typed codebase with MyPy strict mode compliance

  • Python 3.9+: Supports Python 3.9 through 3.13

Prerequisites

  • Python: 3.9 or higher

  • 7z Command-Line Tool: Required for loading compressed taxonomy files (7z or ZIP format)

    • On Ubuntu/Debian: sudo apt-get install p7zip-full

    • On macOS: brew install p7zip

    • On Windows: Download from 7-zip.org

Installation

Install XBridge from PyPI using pip:

pip install eba-xbridge

For development installation, see CONTRIBUTING.md.

Quick Start

XBridge offers two ways to convert XBRL-XML files to XBRL-CSV: a command-line interface (CLI) for quick conversions, and a Python API for programmatic use.

Command-Line Interface

The CLI provides a quick way to convert files without writing code:

# Basic conversion (output to same directory as input)
xbridge instance.xbrl

# Specify output directory
xbridge instance.xbrl --output-path ./output

# Continue with warnings instead of errors
xbridge instance.xbrl --no-strict-validation

# Include headers as datapoints
xbridge instance.xbrl --headers-as-datapoints

CLI Options:

  • --output-path PATH: Output directory (default: same as input file)

  • --headers-as-datapoints: Treat headers as datapoints (default: False)

  • --strict-validation: Raise errors on validation failures (default: True)

  • --no-strict-validation: Emit warnings instead of errors

For more CLI options, run xbridge --help.

Python API - Basic Conversion

Convert an XBRL-XML instance file to XBRL-CSV using the Python API:

from xbridge.api import convert_instance

# Basic conversion
input_path = "path/to/instance.xbrl"
output_path = "path/to/output"

convert_instance(input_path, output_path)

The converted XBRL-CSV files will be saved as a ZIP archive in the output directory.

Python API - Advanced Usage

Customize the conversion with additional parameters:

from xbridge.api import convert_instance

# Conversion with custom options
convert_instance(
    instance_path="path/to/instance.xbrl",
    output_path="path/to/output",
    headers_as_datapoints=True,  # Treat headers as datapoints
    validate_filing_indicators=True,  # Validate filing indicators
    strict_validation=False,  # Emit warnings instead of errors for orphaned facts
)

Loading an Instance

Load and inspect an XBRL-XML instance without converting:

from xbridge.api import load_instance

instance = load_instance("path/to/instance.xbrl")

# Access instance properties
print(f"Entity: {instance.entity}")
print(f"Period: {instance.period}")
print(f"Facts count: {len(instance.facts)}")

How XBridge Works

XBridge performs the conversion in several steps:

  1. Load the XBRL-XML instance: Parse and extract facts, contexts, scenarios, and filing indicators

  2. Load the EBA taxonomy: Access pre-processed taxonomy modules containing tables and variables

  3. Match and validate: Join instance facts with taxonomy definitions

  4. Generate CSV files: Create XBRL-CSV files including:

    • Data tables with facts and dimensions

    • Filing indicators showing reported tables

    • Parameters (entity, period, base currency, decimals)

  5. Package output: Bundle all CSV files into a ZIP archive

Output Structure

The output ZIP file contains:

  • META-INF/: JSON report package metadata

  • reports/: CSV files for each reported table

  • filing-indicators.csv: Table reporting indicators

  • parameters.csv: Report-level parameters

Documentation

Comprehensive documentation is available at docs.xbridge.meaningfuldata.eu.

The documentation includes:

  • API Reference: Complete API documentation

  • Quickstart Guide: Step-by-step tutorials

  • Technical Notes: Architecture and design details

  • FAQ: Frequently asked questions

Taxonomy Loading

If you need to work with the EBA taxonomy directly, you can load it using:

python -m xbridge.taxonomy_loader --input_path path/to/FullTaxonomy.7z

This generates an index.json file containing module references and pre-processed taxonomy data.

Configuration Options

convert_instance Parameters

  • instance_path (str | Path): Path to the XBRL-XML instance file

  • output_path (str | Path | None): Output directory for CSV files (default: current directory)

  • headers_as_datapoints (bool): Treat table headers as datapoints (default: False)

  • validate_filing_indicators (bool): Validate that facts belong to reported tables (default: True)

  • strict_validation (bool): Raise errors on validation failures; if False, emit warnings (default: True)

Troubleshooting

Common Issues

7z command not found

Install the 7z command-line tool using your system’s package manager (see Prerequisites).

Taxonomy version mismatch

Ensure you’re using the correct version of XBridge for your taxonomy version. XBridge 1.5.x supports EBA Taxonomy 4.1.

Orphaned facts warning/error

Facts that don’t belong to any reported table. Set strict_validation=False to continue with warnings instead of errors.

Decimal precision issues

XBridge automatically handles decimal precision from the taxonomy. Check the parameters.csv file for applied decimal settings.

For more issues, see our FAQ or open an issue.

Contributing

We welcome contributions! Please see CONTRIBUTING.md for:

  • Development setup instructions

  • Code style guidelines

  • Testing requirements

  • Pull request process

Before contributing, please read our Code of Conduct.

Changelog

See CHANGELOG.md for a detailed history of changes.

Support

Security

For security issues, please see our Security Policy.

License

This project is licensed under the Apache License 2.0 - see the LICENSE file for details.

Authors & Maintainers

MeaningfulData - https://www.meaningfuldata.eu/

Maintainers:

Acknowledgments

This project is designed to work with the European Banking Authority (EBA) taxonomy for regulatory reporting

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

eba_xbridge-1.5.0rc4.tar.gz (12.3 MB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

eba_xbridge-1.5.0rc4-py3-none-any.whl (15.1 MB view details)

Uploaded Python 3

File details

Details for the file eba_xbridge-1.5.0rc4.tar.gz.

File metadata

  • Download URL: eba_xbridge-1.5.0rc4.tar.gz
  • Upload date:
  • Size: 12.3 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/2.2.1 CPython/3.12.3 Linux/6.11.0-1018-azure

File hashes

Hashes for eba_xbridge-1.5.0rc4.tar.gz
Algorithm Hash digest
SHA256 aa44b4076a92444cea8b68a2af9be914360c40b76c98d1321dd26922c4b2e3ba
MD5 4db5b61434851cb29d075ad4627ccc41
BLAKE2b-256 38b50bfe10692dff2b2ee4d295c83b40588a76dac3811f536c831c93d52d2c39

See more details on using hashes here.

File details

Details for the file eba_xbridge-1.5.0rc4-py3-none-any.whl.

File metadata

  • Download URL: eba_xbridge-1.5.0rc4-py3-none-any.whl
  • Upload date:
  • Size: 15.1 MB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/2.2.1 CPython/3.12.3 Linux/6.11.0-1018-azure

File hashes

Hashes for eba_xbridge-1.5.0rc4-py3-none-any.whl
Algorithm Hash digest
SHA256 b665e467efd4e622787c38876fb5a80006d51c23c7e3cb0e646de38f2e4962bc
MD5 7a17d7bbe953886a3e9f62613af6a2ab
BLAKE2b-256 2fa7b14e8376df8c20f8d35603dee5acf4caabba1e8c839003deea9c9082feba

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page