We are in the process of updating and repackaging the database, and associated tools. We hope this will increase the usability of the CropStoreDB System as a whole. This should be made available in the new year.
The input templates and associated files are generated as a universal starting point in discussions for curating data into the CropStoreDB Database. Please feel free to use them for any other purpose for which you might find them useful.
DB, and should be the first point of interaction with those generating and curating data. These are based on the database structure with input worksheets corresponding to CropStoreDB tables. This should be done after consulting the front "INTRO" worksheet associated with each of the UITs.
Database Input Templates (DBIT) are used by the database curator and are a direct representation of the CropStoreDB tables in Excel format. These are populated using data submitted via UITs, with additional provenance information added by the curator. The DBITs are then saved as Comma Separated Value (.csv) files for direct loading into the MySQL database by the database curator. The input workbooks are organised into sets of inter-related worksheets that correspond to the main CropStoreDB modules.
If you have any questions, or would like some assistance in curating your data please contact Pierre Carion.