User Tools

Site Tools


importing_data

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
importing_data [2021/11/22 15:35]
mina
importing_data [2023/03/01 19:33] (current)
boris
Line 12: Line 12:
   - When new or existing instances have been assigned to each Excel instance, click the Import button.   - When new or existing instances have been assigned to each Excel instance, click the Import button.
  
-Importing an algorithm+**Importing an algorithm**
  
 When data is exported from the parameter database a column named Export Info is appended for each row. The Export Info fields contain the search tags of the instance from where the value is taken. Also, the GUID (global unified ID) of the instance is added to the cell as a comment. When data is exported from the parameter database a column named Export Info is appended for each row. The Export Info fields contain the search tags of the instance from where the value is taken. Also, the GUID (global unified ID) of the instance is added to the cell as a comment.
Line 24: Line 24:
 If there is no instance in the database with matching name and tag, the database will not suggest anything. The user has to manually either choose an instance or create a new one. If there is no instance in the database with matching name and tag, the database will not suggest anything. The user has to manually either choose an instance or create a new one.
  
-Errors and requirements+**Errors and requirements**
  
 The database require that the parameters are defined in the database before values can be imported. For example, if an Excel file contains a parameter named Kd which depends on Element and there are values for Lead, Plutonium and Iodine the database must have a definition for a parameter with this name and with the same dependency. The dependency must contain indices for Lead, Plutonium and Iodine (but can of course contain many others). The database require that the parameters are defined in the database before values can be imported. For example, if an Excel file contains a parameter named Kd which depends on Element and there are values for Lead, Plutonium and Iodine the database must have a definition for a parameter with this name and with the same dependency. The dependency must contain indices for Lead, Plutonium and Iodine (but can of course contain many others).
Line 30: Line 30:
 Some typical errors would be: Some typical errors would be:
  
-There is no definition for the parameter X. This means that there is no definition (for the selected project) with the name X. Note that the database names are case-sensitive. +  - //There is no definition for the parameter X.// This means that there is no definition (for the selected project) with the name X. Note that the database names are case-sensitive. 
-The dependencies are invalid for parameter X. This message appears when the names of (and/or number of) dependencies do not match. +  - //The dependencies are invalid for parameter X.// This message appears when the names of (and/or number of) dependencies do not match. 
-There is no index Y in the database. An index for a specific dependency is missing.+  - //There is no index Y in the database.// An index for a specific dependency is missing. 
 + 
 +---- 
 + 
 +\\ 
 + 
 +[[parameter_database_wiki|Back]]
  
importing_data.1637591752.txt.gz · Last modified: 2021/11/22 15:35 by mina