====== Parameter database toolbox Wiki ======

The [[Parameter database toolbox|Parameter database toolbox]] provides a connection between [[Ecolego|Ecolego]] and a [[Parameter database|parameter database]]
.
===== Logging in =====

Before a connection can be made to the database, Ecolego must be given the location of the database as well as the credentials of the user. This is done in the [[preferences#Database|Database preferences screen]]

To login click on the {{:DatabaseLoginButton.png}}.

===== Selecting project =====

When you have logged into the database, you will be given access to [[Project_(Parameter_database)|projects]] that have been associated with your [[user]] by the system administrator who manages the database. You select which project you want to work from the drop-down list that appears next to the login button once logged in.

===== Roles =====

Depending on your [[|role]] for the selected project you will have different possibilities to alter and view data in the database. A small symbol will indicate which [[role]] you have for the specific project:

===== Model development =====

When Ecolego is connected to a parameter database Ecolego will help the user to confirm to the naming convention of the parameter database. While equations are typed, parameter names as defined in the database will be presented to the user. If these names are used the parameter values can be imported directly. For more information see [[Expression_editing_tool|Expression editing tool]].

===== Exporting data =====

In short:

  - Select **File|Export|Export Parameters to the Database**.
  - Select the [[Parameter|parameter]]/[[Lookup_table|lookup table]] values that you wish to export.
  - Choose whether to update values of existing [[Parameter_instance|parameter instances]] or if you wish to create new ones. New [[Parameter_instance|instances]] should be [[Tag|tagged]] so that they can be easily identified.

More information available [[Exporting_parameters_to_the_database|here]].

===== Importing data =====

In short:

  - Select **File|Import|Import Parameters from the Database**.
  - Find the [[Parameter_instance|instances]] that you wish to import.
  - Choose whether to overwrite values of existing objects in the model or if you wish to create new [[Parameter|parameters]]/[[Lookup_table|lookup tables]].

More information available [[Importing_parameters_to_Ecolego|here]].

===== Importing dependencies =====

|Note|When the [[Radionuclide_toolbox|Radionuclide toolbox]] is available, Ecolego will automatically import [[Radionuclide|radionuclides]] from the nuclide database.|

When importing parameter values, the [[Index_list|index lists]] of the [[Model|model]] determine which data is imported. It is therefore important that the names of the [[index_list#Index|indices]] in the model are the same as in the database.

It can therefore be good practise (and time saving) to import dependencies from the database rather than creating them manually.

In short:

  - Select **File|Import|Import Index-lists from the Database**.
  - Select which index lists you wish to import.
  - For each index list, select which indices to import.

More information available [[Importing_index_lists_to_Ecolego|here]]. [[Preferences#Database|Database preferences screen]]

===== See also =====

  * [[Exporting_parameters_to_the_database|Exporting parameters to the database]]
  * [[Preferences#Database|Database preferences screen]]
  * [[Importing_parameters_from_the_database|Importing parameters from the database]]
  * [[Importing index lists to Ecolego|Importing index lists to Ecolego]]
  * [[start|Ecolego Wiki]]