HOME > Data Input

DATA INPUT

• Instructions
• User Input Templates
• Database Input Templates
• Scripts / Loading

All the information on this page is in support of the paper to be submitted in January 2010 describing the CropStoreDB Database. More detailed information will be made available following acceptance of the paper.

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.

Instructions

A series of MS-Excel User Input Template (UIT) workbooks have been developed as the primary data entry tool for CropStoreDB, 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.

User Input Templates / Database Input Templates

Module	Key tables	User Input Templates (UIT)	Database Input Templates (DBIT)
cs_PLANT	plant_populations, plant_lines, plant_varieties, plant_variety_details...		Contact Pierre Carion
cs_TRAITS	plant_trials, trait_scores, occassions, trait_descriptors, design_factors, ...		Contact Pierre Carion
cs_LINKAGE_MAP	linkage_maps, linkage_groups, map_positions, ...		Contact Pierre Carion
cs_QTL	qtl, qtl_jobs, processed_trait_datasets		Contact Pierre Carion
cs_GENETIC MARKER	marker_assays, primers, clones, marker_sequence_assignments, ...	under development	Contact Pierre Carion
cs_GENOTYPE_SCORES	population_genotypes, population_locus_alleles plant_line_assigned_genotypes...		Contact Pierre Carion
cs_ADDITIONAL_INFORMATION	cs_images, cs_publications, cs_institutions, cs_people, ...	under development	Contact Pierre Carion
preloaded data	countries, restriction_enzymes	Contact Pierre Carion	Contact Pierre Carion

Scripts / Loading

A series of formalised loading script are being considered to facilitate local implementations of the CropStoreDB Schema. In the mean time please contact the database administrator Pierre Carion who can assist in loading your data.

This Page Was Last Edited: 06-May-2010

Sponsored by: BBSRC (UK)
Hosted by: Rothamsted Research
Maintained by: Pierre Carion
Edited by: Graham King
Last updated: November 2009
  

Rothamsted Research provides no express or implied warranties of any kind, including but not limited to those of merchantability, fitness for a particular purpose and non-infringement of the proprietary rights, such as copyrights, patents and trade secrets, of third parties. Rothamsted Research makes every effort to ensure the quality and accuracy of the material on these web pages. However, it accepts no liability for the contents of these web pages, including any third party material.