FROM CHATGPT TO CSV TO JSON

Question

Hello there. I am preparing prompts and ask from CHATGpt to suggest a full system(processes, flows, inputs/outputs, global, input and dependent parameters for my project database. I get 3 CSV's inventrory, mapping and parameters. Running script in Pychamp to transform CSV to JSON.zip. When importing to my database, via IPC server or import/other the tree architecture, flows and process are ok but inputs/outputs tab is missing info and units do not work and dependent parameters tab is empty with no formulas or values. All parameters from CSV's have been placed as global and input parameters window contains the same info in all processes. I guess unit value windows is not working because flows are not derived from the database. It seems JSON.zip is not structured in a manner that OPENLCA recognizes or the csv are not structured well. Is there a python script or transformation mediator to translate imported data in a proper way? Is it a fault of the software? 

Thank you

Answer 1

Well I would say it is not a fault of openLCA if ChatGPT is not able to reproduce openLCA's JSON-LD format correctly - typically some finetuning is needed to make meaningful openLCA datasets from AI systems, and ensuring that the datasets meet the technical format requirements is only one side of the story - but it seems you are already on a good way..

Comments

Thank you for the response and I have an update. I have reproduced a script by the help of a python professional but what I understand is that part of the python script should match CSV headings to JSON-LD format "headings" so to much with the database. The developer needs the JSON-LD mapping code in order to match the headings and the data imported. Of course "UNIT" tab is not bringing any info because the INPUT has not been retrieved by the database, but this can be fixed easily. Some say it has to go through SIMAPRO first and get the exported JSON file from there in order for OPENLCA to work. So far no solution.

---

SimaPro does not export JSON, so "Some say it has to go through SIMAPRO first and get the exported JSON file from there" is incorrect.