Home | Using Katmandoo | Quick Start Guide | How-to | Task Menu | Table of Contents | See Also | Collapse All

Site

Overview

Site is defined in Katmandoo as the place or slocation where the trial or experiment is conducted. It can be a farm, research station or laboratory etc which are identified by Site Type.

Location identifies location of the site. LocationAcronym is the default "TrialAcronymSuffix" of a site when a new site is added. The Trial Acronym Suffix can be changed as required.

A site must be assigned to the Sub-system so that trial data of the Sub-system can be entered for the site.

Detail

Site For Sub-System

Use one of the following procedure to assign a site to one or more Sub-systems.
  1. In the Site Setup Form, tick the checkbox to allow all the Sub-systems to use the site.
  2. In the Sub-system datagrid of the Site Main Form, click the toolbar button of the datagrid to update the Sub-system List (or use [ Record > Update Sub-system List of Site ])
  3. Update the Site List of Sub-system in the Sub-system Main Form.

Trial Acronym Suffix

When a new Site is added, the location acronym is set as trial acronym suffix for the site. But it is also highly recommended to make the Trial Acronym Suffix unique for each site. It has five characters and is used to generate Trial Acronym of the trial that is conducted in the site.

Click here for updating trial acronym suffix using the Site Setup Form.

Following Import Site Wizard snapshot displays the options that can be used to create Trial Acronym Suffix for the new sites.

Site Import Wizard (Click it to change its size)
  1. This preferred option when selected allows system to generate unique Trial Acronym Suffix for all the new sites being imported from the source file.
  2. If this option is used, the Location Acronym is used for the Trial Acronym Suffix for all the new sites being imported from the source file. Use this option if you already have data that uses Location Acronym (instead of Trial Acronym Suffix) to create Trial Acronym.
  3. But please note that the Trial Acronym Suffix of the existing site can not be updated using Import Site. Use Site Setup Form to update it.

Current Site Manager

Each site has a current (present) site manager who is the responsible Contact for the site. So, when the site manager is changed in any time, the current site manager should be also changed. While creating the site year record for a site, the current site manager of the site is used as default site manager but user can change it as required.

If the site manager information is not available, Unknown Contact should be used.

Click here for information on updating current site manager using the Site Setup Form.

Current Meteorology Station

Each site can have an associated Meteorology station. If meterology station is not available, Unknown Meterology Station should be used.

Click here for updating current meteorology station using the Site Setup Form.

Table Structure

Column Name Description
SiteId (PK) Identification Number that uniquely identifies a property used for the trial.

This is an Integer Auto Number and is generated by the database automatically.
SiteName (AK) Name that uniquely identifies a property used for trial.
SiteTypeId (FK) Id that identifies type of the site.
LocationId (FK) Id of Location that identifies the location where the site is located.

Pre-requisite to add a site

The following information must exist before a site can be added to the database.
Note: Although Unknown Location and Unknown Site Type can be used, it is preferable to add the Location and Organisation before adding a new site. This avoids changing at a later date.

Navigator

The site navigator allows the user to quickly find sites located at a location. The nodes of the navigator are generated using the Location Name and its Postcode which are retrieved from the database. The nodes are sorted into location name order.

Important Note: Katmandoo automatically selects the node that was selected last time (ie before closing the navigator or Katmadoo).

Use [ Task > Trial > Site > Manage Site and Site Year ] to activate the site navigator.
Illustrative snapshot:
Site Navigator (Click it to change its size)
  1. Filter based search (in the snapshot, only the locations starting with "c" are loaded to generate the navigator nodes).
  2. The first location node (.All Location|.All) of the navigator, when clicked all the sites are displayed in the Site Main Form.
  3. Other location nodes are generated by concatenating location names and their postcode separated by "|" (pipe).
  4. Child site node (ie site name) of the Location node.
  5. Site Main Form displaying sites at the selected location (ie .All Location|.All in the snapshot).

Main Form

To display sites in the Site Main Form, follow the steps below:
Illustrative snapshot:
Main Form of Site (Click it to change its size)
  1. Site Navigator with location nodes (in the snapshot, only the locations starting with "c" are loaded to generate the navigator nodes).
  2. Site node which is the child node of the location node in the site navigator.
  3. Site Main Form displaying the sites at the selected location.
    • Use [ View > Arrange columns in Main Form ] to change default order of displayed. Alternately it can be changed by editing the column list of the Misc Group SiteSetupDataGrid.
    • Click here for an illustration of the main form template.
  4. Site subform displays Virtual column information of the selected site (ie "Condobolin Agriculture Research and Advisory Station" in the snapshot).
  5. Site Year records of the selected site (ie "Condobolin Agriculture Research and Advisory Station" in the snapshot).
  6. Click to bulk insert site year for the the selected one or more sites.
  7. List of the Sub-systems that can use the selected site (ie "Condobolin Agriculture Research and Advisory Station" in the snapshot).
  8. Click to update Sub-systems that can use the selected site.

Setup Form

To add a new site, follow the steps below:
Illustrative snapshot:
New Site Setup Form (Click it to change its size)

  1. Site Name (a new site). In this example, since the actual site name of the trial is not available, location name is used as the site name.
  2. Click Reload From Database to reload Locations from the database.
  3. Click Reload From Database to reload Site Types from the database.
  4. Click Add new to add new Site Type.
  5. Trial Acronym Suffix. In the snapshot, when the location "Cudal|2864" is selected, system sets its Location Acronym as the Trial Acronym Suffix of the new site Cudal.
  6. Site Manager of the site for the current year. Click on Apply Filter (Apply Filter) to narrow the list. Click Reload From Database to to reload the Contacts from the database.
  7. Current Met Station used for the Site to track meteorology information. Click on Apply Filter (Apply Filter) to narrow the list. Click Reload From Database to reload Meteorology Stations from the database.
  8. Check (recommended) this check-box to allow all the Sub-system to use the new site.
  9. Enter start and End Year to create Site Years records of the Site for the years.
To edit an existing site, follow the steps below :
Illustrative snapshot:
Site Setup Form (Click it to change its size)
  1. The Site Name is disabled as it has dependant data. Click here for information on editing restricted value.
  2. The Current Site Manager and Current Met Station can be changed as required.
  3. While editing site information, the bulk inserting site year is not available in the form. But use [ Record > Bulk Insert Site Year ] can be used to bulk insert Site Years for the selected site.
  4. Virtual column name (in second step of the wizard). Click here for information on the Virtual column data entry datagrid.
    • Important Note: If there is not any virtual column for SiteFactor table, then second page is disabled.
  5. A value for the displayed Virtual column can be entered on this part of the data grid.

Bulk Insert Site Year

Use [ Record > Bulk Insert Site Year ] to add site year records of the selected site for more than one year.
Bulk Insert Site Year Form (Click it to change its size)
  1. Check this option to insert site year records for all the listed sites in the site main form. If this option is selected then 2 & 3 are disabled.
  2. Select a Site to add the site year records.
  3. Select the Site Manager who is the site manager for the given period ie start year to end year.
  4. Enter the Starting Year which should be less than or equal to the ending year.
  5. Enter Ending Year.
In the snapshot, whether option 1 or 2+3 is selected, the site years for the 2006 and 2007 will be added when the [ Insert Site Year records and exit ] button is clicked.

Merge Site data

To merge data of a site into another site use [ Record > Merge Site data ] in the  Site main form.
Illustrative snapshot:
Merge Site
  1. Read this important note!
  2. Master Site is the one that will hold data of the Slave Site.
  3. Master SiteId replaces all the Slave SiteIds in the database.
  4. Trial Acronym Suffix of Master Site.
  5. Slave Site.
  6. Trial Acronym Suffix of Slave Site.
  7. Authorised token.
  8. User must enter the exact authorised token (case-sensitive) to merge data.
    • Tips: Copy the token to a text file. Next time, copy the token from the text file and paste here and just change the Id.
  9. After carefully entering all the required information, click [ Merge... ] button. 
IMPORTANT NOTE: 

Change Trial Acronym Suffix

Use [ Record > Change Trial Acronym Suffix ] (in Site Main form) when you need to change current Trial Acronym Suffix with new Trial Acronym Suffix.

Important Note: User must inform all the users of the current database about the change of Trial Acronym Suffix because existing Trial Acronyms of the selected site are also changed. This can potentially cause data mismatch between Katmandoo and external data files (generated by Katmandoo for data entry files, Labels, KollecTrait etc).

Export/ Import

Export
Import

See Also