Organizing a Database¶
Processes and flows in FLCAC repositories are categorized by NAICS 2 and four digit NAICS codes. See this section for more information on Categorization.
The Commons Core Database contains an empty NAICS folder structure and the data quality matrices. This database can be combined with pre-existing or new openLCA databases to make organization easier.
Drag and drop processes and flows into different folders in openLCA.
New folders and subfolders can be created by right clicking on an existing folder and selecting “Add new child category”.
Import/Export LCI Data from Excel/openLCA¶
It is possible to copy/paste to and from excel and a process inventory (i.e., the 'Inputs/Outputs tab of a process)
Review this section of the openLCA manual
Developing EPD Results in openLCA with FLCAC Data¶
The openLCA EPD feature allows users to combine results representing different modules into an EPD structure.
To use this feature, import relevant FLCAC repositories and a compatible LCIA method. Develop module/stage processes for the desired product (i.e., A1, A2, etc.). Create product systems for each stage, run LCIA results, and then save the results. Lastly, create a new EPD and add the module results
Connect a Database to a GitHub Repository¶
To work collaboratively or share openLCA databases, you may connect a local database to a GitHub repository.
Follow these steps to connect an openLCA database to a GitHub Repository:
Create a new GitHub repository
Generate a GitHub Classic Token (Settings --> Developer Settings)
Set the expiration (no expiration is recommended)
Check the box to allow full control of private repos
Save the token (it cannot be regenerated)
Right click on the openLCA database that you would like to connect
Select ‘Repository’, select ‘Connect’
Enter the following fields:
URL = GitHub repository url
Username = GitHub username
Your database should now be connected to your GitHub repository. This connection is indicated by the url following the database name.
Password for pushing/pulling = token
Pushing and Pulling Data To and From the a GitHub Repository
Right click on the database connected to a GitHub repository, select ‘Repository’
Functions:
Commit: Record of local changes to the repository
Push: Updates the collaboration server repository with local changes
Fetch: Record of changes that have been made
Merge: Combines changes if there are remote and local updates
Pull: Updates local repository with changes