Skip to content

Fail to import database from Excel #1643

@fbusio

Description

@fbusio

Hello, issue when trying to importing a database from an Excel file. Biosphere exchanges not recognized although they were created from the same biosphere database.

Relevant errors

File "C:\ProgramData\miniforge3\envs\ab\Lib\site-packages\activity_browser\ui\core\threading.py", line 42, in run
    raise e
  File "C:\ProgramData\miniforge3\envs\ab\Lib\site-packages\activity_browser\ui\core\threading.py", line 38, in run
    self.run_safely(*self._args, **self._kwargs)
  File "C:\ProgramData\miniforge3\envs\ab\Lib\site-packages\activity_browser\actions\database\database_importer_excel.py", line 139, in run_safely
    importer.automated_import(database_name, linking_dict)
  File "C:\ProgramData\miniforge3\envs\ab\Lib\site-packages\activity_browser\bwutils\importers.py", line 124, in automated_import
    raise LinkingFailed(excs, databases)
activity_browser.bwutils.errors.LinkingFailed: ([{'name': 'Water, unspecified natural origin', 'amount': 21, 'database': 'biosphere-3.12', 'unit': 'cubic meter', 'categories': ('natural resource', 'fossil well'), 'type': 'biosphere'}, {'name': 'AOX, Adsorbable Organic Halides', 'amount': 5.1851635017553646e-05, 'database': 'biosphere-3.12', 'unit': 'kilogram', 'categories': ('water', 'surface water'), 'type': 'biosphere'}, {'name': 'Acetaldehyde', 'amount': 1.1900897253256974e-07, 'database': 'biosphere-3.12', 'unit': 'kilogram', 'categories': ('air', 'urban air close to ground'), 'type': 'biosphere'}, {'name': 'Acetic acid', 'amount': 1.7797135817697626e-07, 'database': 'biosphere-3.12', 'unit': 'kilogram', 'categories': ('air', 'urban air close to ground'), 'type': 'biosphere'}, {'name': 'Acetone', 'amount': 2.780975311262218e-08, 'database': 'biosphere-3.12', 'unit': 'kilogram', 'categories': ('air', 'urban air close to ground'), 'type': 'biosphere'}, {'name': 'Acetylene', 'amount': 7.741207078190615e-10, 'database': 'biosphere-3.12', 'unit': 'kilogram', 'categories': ('air', 'urban air close to ground'), 'type': 'biosphere'}, {'name': 'Aluminium III', 'amount': 1.656618314732788e-08, 'database': 'biosphere-3.12', 'unit': 'kilogram', 'categories': ('air', 'urban air close to ground'), 'type': 'biosphere'}, {'name': 'Ammonia', 'amount': 2.5778568686759977e-06, 'database': 'biosphere-3.12', 'unit': 'kilogram', 'categories': ('air', 'urban air close to ground'), 'type': 'biosphere'}, {'name': 'Antimony ion', 'amount': 2.4462214367082222e-12, 'database': 'biosphere-3.12', 'unit': 'kilogram', 'categories': ('air', 'urban air close to ground'), 'type': 'biosphere'}, {'name': 'Arsenic ion', 'amount': 3.937125129189972e-09, 'database': 'biosphere-3.12', 'unit': 'kilogram', 'categories': ('air', 'urban air close to ground'), 'type': 'biosphere'}], {'biosphere-3.12'})

Version

3.0.0b1169

Installation method

PyPI (pip)

Operating system

Windows 11

Metadata

Metadata

Assignees

No one assigned

    Labels

    betaIssues related to the Activity Browser 3 Beta

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions