Differences

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

--- importing_data [2021/11/22 15:34]
mina created
+++ importing_data [2023/03/01 19:33] (current)
boris
@@ Line 2: / Line 2: @@
 === Importing data from excel ===
-{{:import_pdb.png?550 }}
+{{ :import_pdb.png?550}}
 In short, importing data is done through the following steps.
-In the right section of the screen, the user selects the file which contains the data to be imported.
+  - In the right section of the screen, the user selects the file which contains the data to be imported.
-The file is analysed by the database. For each sheet in the Excel file, a tab is created in the left section. All instances found for in each sheet are then listed in the leftmost column (Excel) of a table under the corresponding tab.
+  - The file is analysed by the database. For each sheet in the Excel file, a tab is created in the left section. All instances found for in each sheet are then listed in the leftmost column (Excel) of a table under the corresponding tab.
-Each instance found in the Excel file must now either be matched to an instance already in the database (which will be overwritten) or to a new instance. The database column offers drop down menus where all database instances with the same name as the Excel instance are presented. To create a new instance rather than overwriting an existing instance, click the Create button. If there is an error associated with the import of a given instance, this error is listed in the rightmost column. For an explanation of common errors, see below.
+  - Each instance found in the Excel file must now either be matched to an instance already in the database (which will be overwritten) or to a new instance. The database column offers drop down menus where all database instances with the same name as the Excel instance are presented. To create a new instance rather than overwriting an existing instance, click the Create button. If there is an error associated with the import of a given instance, this error is listed in the rightmost column. For an explanation of common errors, see below.
-If either a Excel or a database instance are selected, the bottom table will display their values.
+  - If either a Excel or a database instance are selected, the bottom table will display their values.
-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.
@@ 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.
-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).
@@ Line 30: / Line 30: @@
 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]]

Ecolego Wiki

User Tools

Site Tools

Differences

Page Tools