Importing .CSV files

Question

Hello, 

I have troubles in importing .csv files : I have dowloaded the french databases Base Impacts from Ademe, which is encoded in csv. However, when I try to import the files into OpenLCA, it seems to work but nothing happens and there is no error message. 

Here are the files that I try to import (I have unziped the files) : 

Thank you in advance!

Answer 1

The csv import is for SimaPro exports, and for processes only; if you check the files from Base Impacts, they are very different in structure, which means they cannot be imported directly.

Comments

Is there a template for how the csv file should look like? I exported a SimaPro csv from EUCIA Eco Impact Calculator, but when I try to import it to OpenLCA, it gets imported with all the data empty. Even the title is gone - I get a completely empty process in OpenLCA. Could this be because the csv is not accurately structured? What structure does OpenLCA require in the csv file, i.e. what data should be in which column etc.?

---

The SimaPro csv files are not at all tables, but rather "telegram style": you have keywords and then some information and then an "end" to indicate that a next section comes, e.g. "process" starts a process data set. You can check this when you export a csv from SimaPro. It is indeed a bit tricky, the whole format is not - to my knowledge - documented anywhere, and changes a bit over the years, from version to version. We have built the import looking at export csv examples, with supoprt from PRé when we were still reselling SimaPro.