How to import processes with social indicators (soca) from Excel?

Question

Dear openLCA community,

we recently discussed problems when importing processes from Excel and a go around was found: https://ask.openlca.org/3997/why-importing-processes-from-excel-does-not-work

However, i encounter a new problem:

When i try to import a process from Excel with social indicators, like from the soca database, the social indicators only get imported as output flows, but cost data in the output tab and everything in the social aspects tab is missing.

All social indicators and flows do exist in the database i want to import to.

Have i missed something or are soca functionalities maybe not supported by the Excel import yet?

Thanks a lot!

Answer 1

In the meanwhile i figured it out:

At least in my case the more or less convenient way to import and export as well as editing also bigger datasets, is to export them as ILCD zip files and then editing them by using a good xml editor (e.g. Atom https://atom.io/). It takes a while to figure out the structure of ILCD files but after a while it is very efficient working and at least until now it does not produce any issues.