Crop data reader
CLEM.FileCrop
Reads external crop and forage data

The Data reader components are used to read external data for use by CLEM. They can be placed anywhere within the simulation branch of the APSIM simulation. It is recommended to place them with the activities using them or below the CLEM component.
This Data reader is used to read crop and forage inputs.

The following parameters are used to define this component

The name of the data file. Include the full path of the database if not contained in the same folder as the APSIMX file.
This reader can read delimited ASCII text files or Excel spreadsheets.
The specified file cannot be open some other applications (e.g. Excel) when you run your simulation.

Name of the excel worksheet containing the crop or forage data if reading an Excel spreadsheet.
This property is ignored when not reading spreadsheets and can be left blank.
The following columns are expected in the table. The column name referring to the data can be supplied such that any table can be used to provide data.
Each row of the table must contain a year and month column, with crop name and amount harvested columns.
The row must also contain a column to identify the land id. This column allows you to provide multiple instances of a crop in the table. For example there may be one for irrigated and one for fertilised that are used in different fields of your simulation farm.
Finally, the percent nitrogen is an optional column to provide the nitrogen content of the crop or left blank if not available.

The name of the column in the specified table identifying the crop to be used.
Default: CropName

The name of the column in the specified table containing the land id, or particular version of the crop data. This will be linked to the land id supplied for the selected Land type.
Default: SoilNum

The name of the column in the specified table containing year data.
Default: Year

The name of the column in the specified table containing month data.
Default: Month

The name of the column containing amount (kg) produced or harvested in the month.
Default: AmtKg

The name of the column containing nitrogen percent of the product produced. This is an optional column that will determine the changes in quality (Nitrogen content) of the harvested material and plant growth.
Default: [Blank]

The name of the column containing a Harvest tag used to manage multiple harvests between rotations.
FirstLast identify the start and end of a multi-harvest sequence


Text files should be provided as Tab delimited

The following conditions must be met
- Column names in excel files cannot contain spaces
- There must not be any extra details (e.g. text) other than empty records in rows and columns outside the data area of the spreadsheet.
See also