Importing Data (stand register)

• Iptim is now designed to handle stand registers and sample plot inventories separately.
• This tutorial will show how to import both stand registers.

__

File to use in this tutorial

We strongly suggest the use of the following file in this tutorial.

• sampleplots.xls  (100 KB)

Before continuing, you may want to open the file above. You may observe three worksheets (stand, sample plot, tree), each one including data of stands, sample plots and trees.

• The 'stand' worksheet includes the following data: estate, stand_id, area, soil_class, soil_preparation, tree_especies, planting_date, and inventory_date.
• The 'sample plot' worksheet includes the following data: estate, stand_id, plot_id and plot_size.
• The 'tree' worksheet includes the following data: estate, stand_id, plot_id, tree_id, tree_diameter, tree_height.

Importing data from an Excel file

Importing the data into the system

To import the data into the system:

1. Click on the Project browser window in the Project module.
   
2. Select a dataset with a stand register structure (make sure that the data set had been created with, for example, a "stand register" template. For more info go to Project Browser).
3. Click on more on the right-hand side.
4. Select import.
5. Choose the data type. For this example we will select Microsoft Excel 97-2003 Worksheet (xls).
6. Press the button + to add a new archive at the right-hand side of your screen.
7. Select the file and open it.
8. Click on Next. 

__

Mapping of data sheets to data levels (stand register)

It is time to tell Iptim what kind of information is included on each worksheet of the Excel file. As you can see, there are two windows:

• The window at the left shows the predetermined data levels of the template chosen when creating the project and data set that we are using in this example.
• The window at the right shows the name of the worksheets of the Excel file that is being imported.
• In this example we will only map the stand register information in the Excel file (on the right) with the "stand" data level of the template (on the left).

1. Click on the stand on the window at the left (the template's data levels) and click on stand on the window at the right (the worksheet in the Excel file).
2. Click on Map (or double-click in any of the two above selections). On the left-hand window, you will see that the field will change to "stand : stand" indicating that the data in the worksheet 'stand' has been mapped to the stand data level of the template.
3. Click on Next.

 

It is now time to help Iptim understand the meaning of each column in the stand register worksheet. You are now seeing two windows:

1. If you want to map a variable, select the variable on the right window that you want to map, and then select the corresponding variable on the left window.
2. Click on Map (or double click).
3. After you have mapped all variables, press Next.

What if my worksheet variable doesnt have a corresponding predetermined variable?

1. Select the variable of the worksheet that you want to add (e.g. "estate").
2. Press New Property.
3. Select the type of variable
   1. Numeric variable
   2. Text variable
   3. Date variable
   4. Category variable
   5. Option variable
4. Add a Display name.
5. Add a name.
6. Depending on the type of variable you might have additional options to consider.
7. Press Accept.