IEFC - Forest long term monitoring trials database - FORESTRIALS - Data management
Manage your data in FORESTRIALS database
You can upload information in the database FORESTRIALS by creating an Excel file (in .ods or .xls or .xlsx format). If you are not sure about the names of the various fields in the database, you can check them here.
1. IF YOU UPLOAD A SPREADSHEET, the sheet names must match the table names and the column names must be on first row.*The Excel file must contain 3 sheets with the name plot, species and data. Refer to the 6th point for the sample. If there is no data to add/update/delete, create the respective sheet without data in it.*
2. If the value of NULL is No, It has to be filled with a value. In this case NULL or Empty is not allowed.
3. If there are value mentioned in the Type, it has to be in that particular Value Range. Eg: country, Objective, Type of Soil
4. Field names are Case Sensitive and exactly should match the fields in the input file.
5. Column order does not matter. Dates must be formated like this: 1999-02-27. Latitude and longitude (WGS84) must be in decimals with a dot as a separator. In case of update records, you must not have any columns labeled 'Last_update' and 'owner', they exist for internal purposes only.To update field of type SET (list of option), you can separate the various options with a coma
6. To help you to prepare data files, you can download this calcsheet.
If youwish to make any comments about this database, to add a modality in ENUM type fields or to acquire a password to upload your own data, you can do so at webmestre