Bulk-rename of processes

Question

Hello,

i want rename all processes in a certain category (folder) in my ecoinvent database. I want to add for example the suffix "-old". I managed to do that with a script and the IPC Server but the ecoinvent Database seems to be too big to run it like this. Is that possible with the integrated python version in openLCA? or d you have any other suggestions how to do that?

Greetings

Answer 1

it is not too difficult in SQL:

- give the folder a unique name (such as "the_old_process_folder")

- use this SQL script (in openLCA, tools, developer tools, sql):

update tbl_processes set name = name || '-old' where f_category = (select id from tbl_categories where name = 'the_old_process_folder')

You need to close and reopen the database to see an effect in the navigation tree.