Importing Ecoinvent database in MySQL format, Mac OS X 10.6
Posted: 08 Jan 2012 00:55
Dear OpenLCA users,
I recently decided to learn OpenLCA, as I have to do the LCA of the product I am designing for my master project.
I was given by my school a copy of the Ecoinvent database already converted from Ecospold files through OpenLCA in MySQL files. I was told that I could simply copy this database folder in the "openlca-data" folder popping up in my home directory, and that OpenLCA will read the database, when connected to the MySQL local server. It did not work : I could copy the folder, but OpenLCA could not see the Processes.
When looking on this documentation website, I saw that the "openlca-data/data" folder was indeed containing the database when using Windows. I use Mac OS X 10.6 and wonder if the database is supposed to be stored somewhere else. I tried to create a mock process in the virgin database created from the MySQL connection in the left column of the sowtware, but could not retrieve it in the "openlca-data" folder. I could not find any "openlca-data/data" folder, even empty, and no "open-lca/.metadata" or "open-lca/export-templates" folder either, although I could see them on Windows screenshots that were provided to me.
Do you any idea how I can solve this problem ?
To summarize > I want to import an Ecoinvent database already imported once through OpenLCA from Ecospold format and converted in MySQL files. I have the folder ready, and would like to now where I have to copy it to have the database read by the software.
Thank you in advance for your answer,
Best regards, and happy 2012 to all of you,
Michka
I recently decided to learn OpenLCA, as I have to do the LCA of the product I am designing for my master project.
I was given by my school a copy of the Ecoinvent database already converted from Ecospold files through OpenLCA in MySQL files. I was told that I could simply copy this database folder in the "openlca-data" folder popping up in my home directory, and that OpenLCA will read the database, when connected to the MySQL local server. It did not work : I could copy the folder, but OpenLCA could not see the Processes.
When looking on this documentation website, I saw that the "openlca-data/data" folder was indeed containing the database when using Windows. I use Mac OS X 10.6 and wonder if the database is supposed to be stored somewhere else. I tried to create a mock process in the virgin database created from the MySQL connection in the left column of the sowtware, but could not retrieve it in the "openlca-data" folder. I could not find any "openlca-data/data" folder, even empty, and no "open-lca/.metadata" or "open-lca/export-templates" folder either, although I could see them on Windows screenshots that were provided to me.
Do you any idea how I can solve this problem ?
To summarize > I want to import an Ecoinvent database already imported once through OpenLCA from Ecospold format and converted in MySQL files. I have the folder ready, and would like to now where I have to copy it to have the database read by the software.
Thank you in advance for your answer,
Best regards, and happy 2012 to all of you,
Michka