How can I import data from external source in a openLCA db?

Question

Hi all,

I have collected data from different sources and I have reorganized them with some python scripts. I would like to import these data in openLCA and I was looking for the best way to organize them. I have tried EcoSpold2 XML and Excel .xlsx files, but both of them are not working. In particular, the XML is recognized as correct format but raises a warning, while with the .xlsx openLCA seems busy but at the end is not importing anything, and the log files do not show any error. 

It seems to me that create a XML or xlsx file from my data is the most convenient way in my case, please correct me if I am wrong. And I really don't know where I can find such specific documentation about the input file structure.

Thank you for the support.

Answer 1

Hi, "excel" is of course a quite unspecified format, as is "XML". If you use python, the openLCA API can be useful, or organise your data in the form of the JSON-LD format specified in the openLCA schema.