#27 ILCD import of non-standard ILCD categories

Version_1.3.0
closed-fixed
msrocka
None
2
2013-02-15
2011-07-15
No

I have exported a process from GaBi in ILCD format but without going through the standard GaBi mapping onto reference ILCD flows. When I check the ILCD xml file the category information is present. When I import the ILCD file into OpenLCA no categories are created for the elementary flows resulting in seemingly duplicated elementary flows for substances present under multiple categories.

The export from GaBi without the ILCD mapping can be accomplished by first deleting the following files from C:\Program Files\GaBi 4\SysData
· ILCDArchive.zip
· ILCDFoldermapping.csv
· ILCDGUIDmapping.csv

Ideally I would share the data I exported here, but the license prevents this. The process I tested on was the crude oil mix for Germany.

Screenshot of showing the database containing the single process I imported, the category structure, and the duplicated elementary flows:

1 Attachments

Discussion

  • Troy Hawkins

    Troy Hawkins - 2011-07-15
     
    Attachments
  • Troy Hawkins

    Troy Hawkins - 2011-07-20
    • priority: 5 --> 2
     
  • Troy Hawkins

    Troy Hawkins - 2011-07-20

    I have done some further investigation since making this post. I have confirmed that the category (and subcategory) information is present in the ILCD file I have imported. For example:

    <classificationInformation>
    <common:classification name="GaBiCategories" classes="../GaBiCategories.xml">
    <common:class level="0" classId="085997fa-8a2e-441f-bba4-f44dc3c3c73d">Resources</common:class>
    <common:class level="1" classId="d257ad14-55a9-4bbb-b546-6a92c0021346">Material resources</common:class>
    <common:class level="2" classId="85579c70-3f2b-4e36-ac6d-7187673f7417">Non renewable elements</common:class>
    </common:classification>
    </classificationInformation>

    I have also opened the MySQL flows table after importing into OpenLCA and found that all of the elementary flows have only "Flows" as their category. Thus it seems the category information has not been captured for elementary flows upon import.

    Interestingly, the more specific category information is present for the valuable substances (as can be seen in the attached screenshot).

     
  • msrocka

    msrocka - 2011-08-16
    • assigned_to: nobody --> m_sr
    • status: open --> open-accepted
     
  • Troy Hawkins

    Troy Hawkins - 2011-10-14

    The problem seems to be with the way OpenLCA handles the classification system for elementary flows on import. I used JEdit to do the following find/replace operations on the batch of ILCD elementary flows in the ILCD zip file. After doing this, rezipping, and importing the elementary flows seem to be handled correctly. One issue I did identify is that the flows didn't show up in OpenLCA right after the import. But after closing and reopening OpenLCA, the flows were visible.

    Replace:
    <common:classification name="GaBiCategories" classes="../GaBiCategories.xml">
    with:
    <common:elementaryFlowCategorization>

    and also
    </common:classification>
    with
    </common:elementaryFlowCategorization>

    to properly close out the tags

    as well as
    <common:class level="0" classId=".*"
    with
    <common:category level="0"

    as well as
    <common:class level="1" classId=".*"
    with
    <common:category level="1"

    as well as
    <common:class level="2" classId=".*"
    with
    <common:category level="2"

    as well as
    <common:class level="3" classId=".*"
    with
    <common:category level="3"

    as well as
    <common:class level="4" classId=".*"
    with
    <common:category level="4"

    as well as
    <common:class level="5" classId=".*"
    with
    <common:category level="5"

    and
    </common:class>
    with
    </common:category>

     
  • msrocka

    msrocka - 2013-02-15
    • status: open-accepted --> closed-fixed
    • milestone: --> Version_1.3.0
     
  • msrocka

    msrocka - 2013-02-15

    this was more an issue of the GaBi export: elementary flows should use the elementaryFlowCategorization tag for categorisation (see the attached picture from the ILCD schema). However, openLCA accepts now the classification tag and the elementaryFlowCategorization for the elementary flow categories.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks