User Tools

Site Tools


importing_parameters_time_series_and_options

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_parameters_time_series_and_options [2014/06/05 14:42]
erik
importing_parameters_time_series_and_options [2015/08/13 15:48]
erik
Line 1: Line 1:
-In order to import values, the data must be organised according to the [[Excel file format]. The easiest way to achieve a correct syntax is to first [[exporting parameters time series and options|export]] the parameters to +In order to import values, the data must be organised according to the [[Excel file format]]. The easiest way to achieve a correct syntax is to first [[exporting parameters time series and options|export]] the parameters to 
  
   - Click the **Import** button in the [[wp>​toolbar]] of the [[user interface#​data input screens]]. ​   - Click the **Import** button in the [[wp>​toolbar]] of the [[user interface#​data input screens]]. ​
Line 12: Line 12:
  
  
- 
- 
- 
-<​h2>​Import window</​h2>​ 
-<img class="​topThumbnail"​ src="​../​files/​ImportFromExcelWindow.png"/>​ 
- 
-In the list to the left, all available [[Parameter instance|parameter instances]] are presented. These can be moved to the model by using the arrow buttons. The table in the center shows all parameters that will be imported, either updating existing parameter values or creating new parameters in the model. ​ 
- 
-<​h3>​Selecting parameters</​h3>​ 
- 
-<img class="​Screenshot"​ src="​../​files/​ImportDatabase.png"/>​ 
- 
-The list to the left of the window displays all [[Parameter|parameters]] and [[Lookup table|lookup tables]] that can be imported. Below the list a field allows you to search for [[Block|blocks]] with a specific name. By clicking the **more** button, more search options are shown. ​ 
- 
-Use the arrow buttons to move parameters to the table on the right. ​ 
- 
-<​h3>​Automatic matching</​h3>​ 
- 
-When parameters are selected, the current project will be searched for matching parameters with the following precedence: 
- 
-1. If the [[GUID]] of the parameter in the database/​Excel matches the [[GUID]] of a [[Parameter|parameter]]([[Scenario|scenario]]) 
-2. If the [[Tag|tags]] of the parameter in the database matches the sub-system of the parameter and (if applicable) the tag matches a [[Scenario|scenario]]. 
- 
-Example 1: The model contains a parameter named _rho_ which is located in the sub-system _Rurh.Soil_. The database lists three parameters named _rho_ with the following tags: 
- 
-1. _rho (Rurh, Lake, Conservative)_ 
-2. _rho (Rurh, Soil, Experimental)_ ​ 
-3. _rho (Paris, Soil)_ 
- 
-In this case the model parameter will be matched with database parameter no 2, as it contains tags for both sub-system Rurh and Soil.  
- 
-Example 2: The parameter _rho_ is [[Scenario|scenario dependent]] and has the following scenarios: _Conservative_,​ _Experimental_.The database lists four parameters named _rho_ with the following tags: 
- 
-1. _rho (Rurh, Lake, Conservative)_ 
-2. _rho (Rurh, Soil, Conservative)_ 
-3. _rho (Rurh, Lake, Experimental)_ ​ 
-4. _rho (Rurh, Soil, Experimental)_ ​ 
-5. _rho (Rurh, Soil)_ 
- 
-In this case the model parameter will be matched with database parameters no 2,4 and 5:  
- 
-* _Rurh.Soil.rho\[Conservative\]_ to 2. 
-* _Rurh.Soil.rho\[Experimental\]_ to 4. 
-* _Rurh.Soil.rho\[_default\] to 5. 
- 
-<​h3>​Creating or updating</​h3>​ 
- 
-<img class="​Screenshot"​ src="​../​files/​ImportModel.png"/>​ 
- 
-For each parameter that has been selected the user is given two options: either update an existing parameter in the model, or create a new parameter. ​ 
- 
-Two thick lines divide the table into three sections: 
- 
-* The first section shows the parameter as defined in the database/​Excel. ​ 
-* The second section relates to updating an existing parameter. Tic the checkbox next to the column **Selected parameter** to choose this option. ​ 
-* The third section relates to creating a new an existing parameter. Tic the checkbox next to the column **Create parameter** to choose this option. ​ 
- 
-<​h4>​Updating parameters</​h4>​ 
- 
-A parameter can be updated if it has the same dependencies in the model as in the database/​Excel (the name does not matter - only values are imported).  ​ 
- 
-1. Select the box next to the column **Selected parameter** 
-2. Click the in **Selected parameter** field. A window will appear to select an existing parameter from the model. 
-3. If the parameter is scenario dependent, you can select a specific [[Scenario|scenario]] to overwrite. ​ 
- 
-<​h4>​Creating new parameters</​h4>​ 
- 
-Before a parameter can be created, the dependencies of the parameter must already exist in the model. Refer to [[Importing index lists to Ecolego]]. 
- 
-1. Select the box next to the column **Create parameter** 
-2. Enter a name for the parameter in the field **Create parameter** 
-3. Select a sub-system for the parameter by clicking the field **Sub-system**. ​ 
- 
-<​h2>​Finalizing the import</​h2>​ 
- 
-Click the **Import** button in the bottom of the window to import the selected parameters to the model. ​ 
- 
- 
-Once you have selected a name and location for the Excel file, the **Export** button will be activated. Click the button to finalize the export and close the window. ​ 
- 
-<​h2>​See also</​h2>​ 
- 
-* [[Excel parameter format]] 
-* [[Synchronizing parameters]] 
-* [[Exporting and importing data]] 
  
importing_parameters_time_series_and_options.txt ยท Last modified: 2015/08/13 14:48 (external edit)