Export the parameters with UUIDs and descriptions in an excel

Question

Hi,

Is it possible to export the parameters and their UUIDs and descriptions in an excel sheet?

When I follow Tools -> Parameters ; I can't copy/paste the table, and there aren't the UUIDs.

I tried with the function "select * from tbl_parameters" in the SQL developer window, but then I can't see the description of the parameters.

Thank you

Alix

Answer 1

Here is a link to a Python script that can be executed in openLCA and should write that table to a CSV file: https://gist.github.com/msrocka/0f89231fd3e3e98000b11b18dd748d54

Comments

Thank you very much. I had to change some of my parameters' description, it didn't manage the "³" and "°" and always stopped at the first parameters with ³ in description. Now it's perfectly working!

---

thank you for this skript!

is there any way to load the parameters in the csv file to open LCA (overwriting existing parameters in the database?

I would like to use the skript above to export all parameters and after applying some changes, I would like to load them back to openLCA.



Thanks a lot!