Search found 16 matches

by ELCD_user
09 Nov 2016 15:44
Forum: Databases
Topic: ELCD
Replies: 1
Views: 1278

ELCD

Hello everybody, hello Andreas, I am pretty certain it used to be possible to download the ELCD from https://nexus.openlca.org/databases It can't see it there any more. Screenshot from 9Nov2016 attached. Agrobalyse, USDA, NEEDS, Bioenergiedat are there. The ELCD is missing. Why is that? Best wishes ...
by ELCD_user
28 Apr 2015 10:08
Forum: openLCA 1.4
Topic: mySQL query browser
Replies: 1
Views: 3393

mySQL query browser

Hello
I have generated a new database in openLCA 1.4.1 with the reference data inserted. I then opened the mySQL query browser and did a SELECT * FROM openlca_version; I would expect the query returns '1.4.1' but instead I get '3'. Any ideas why that is?
Regards
Ludwig
SQL_query_browser.png
SQL_query_browser.png (45.81 KiB) Viewed 3393 times
by ELCD_user
06 Aug 2013 11:53
Forum: Datasets
Topic: style sheet declaration for ILCD data sets
Replies: 0
Views: 2898

style sheet declaration for ILCD data sets

Dear all If a new data set is generated in openLCA (1.3) and exported to an xml file in ILCD format, the *.xml file lacks the style sheet declaration in the header: <?xml-stylesheet type='text/xsl' href='../../stylesheets/process2html.xsl'?> is missing (shown for a process data set). However, if the...
by ELCD_user
25 Jul 2013 11:55
Forum: Databases
Topic: Problems with ELCD import
Replies: 12
Views: 11741

Re: Problems with ELCD import

I see. I downloaded the ELCDIII again recently and there seem to be minor changes all the time.
Many thanks
Ludwig
by ELCD_user
23 Jul 2013 16:49
Forum: Databases
Topic: Problems with ELCD import
Replies: 12
Views: 11741

Re: Problems with ELCD import

Many thanks Andreas. ''..why a product flow has a certain LCIA impact as a flow property'': Did you mean the EDIP1997 flow properties? I am grateful if you can point out any obvious errors or shortcomings in the ELCD. Attached the mySQL number-of-rows-in-tables-analysis extended to the latest Nexus ...
by ELCD_user
15 Jul 2013 17:02
Forum: Databases
Topic: Problems with ELCD import
Replies: 12
Views: 11741

Re: Problems with ELCD import

Out of curiosity I have now looked at all mySQL tables with mySQL query select count(*) from tbl_.... and found 9 tables where there are differences between orginal ELCDIII.zip database and the Nexus pack version:
comparison.png
comparison.png (128.37 KiB) Viewed 8541 times
Why is that? Regards
Ludwig
by ELCD_user
15 Jul 2013 13:27
Forum: Databases
Topic: Problems with ELCD import
Replies: 12
Views: 11741

Re: Problems with ELCD import

Many thanks Andreas. Under the latest Nexus plugin version 1.5 importing Nexus databases is fine. There still is a minor error message, my log file is http://www.soton.ac.uk/~lg1e08/Nexus_log.html Between the two ELCD versions I noticed differences in the unit groups: 1) Original ELCD database: 20 u...
by ELCD_user
11 Jul 2013 17:54
Forum: Databases
Topic: Problems with ELCD import
Replies: 12
Views: 11741

Re: Problems with ELCD import

Sara, were you able to import the corrected ELCD nexus database into openLCA? Regards
Ludwig
by ELCD_user
08 Jul 2013 10:37
Forum: Databases
Topic: Problems with ELCD import
Replies: 12
Views: 11741

Re: Problems with ELCD import

Great that Andreas is looking into this. Much appreciated. I checked and also found that the unit group 'UBP, Ecological scarcity method' with UUID ea76b8b2-9712-4d51-96e8-8cc388273ae9.xml is referenced in 'Highly radioactive waste' but does not exist in the ELCDIII.zip database. I then installed th...
by ELCD_user
04 Jul 2013 12:30
Forum: Datasets
Topic: reference data in openLCA
Replies: 0
Views: 3001

reference data in openLCA

Hi community If a new database is generated in openLCA v1.3 the user has three options: openLCA_new_database_options.png If 'Complete reference data' is chosen, I believe more than 9000 flows are inserted into the new database (mySQL query: select count(*) from tbl_flows ). Where do these flows come...