Scott edited bulk upload.md  over 9 years ago

Commit id: ac0fa0a305b1a35bfef230144f3576621e93f84b

deletions | additions      

       

1. Use the web interface   * to enter metadata (new sites, citations, treatments, managements);  * to obtain a template appropriate for your data set. _[Decide whether to really do this. A draft template would simply be a header line with all possible fields. Users would be instructed to remove the fields they don't need.]_  2. Fill in the template with your data. There are four templates to choose from:  * If [yields.csv](https://docs.google.com/spreadsheets/d/1maK1uKr6i9KERaYdU5zSiXcBndQoiG4Vgn2DTnqdfbA/export?format=csv&gid=0) Use this template if  you are uploading yield data and you wish to specify the citation in the file by author, year, and title, use the template [yields.csv](https://docs.google.com/spreadsheets/d/1maK1uKr6i9KERaYdU5zSiXcBndQoiG4Vgn2DTnqdfbA/export?format=csv&gid=0). title.  If your data includes SE and cultivar information and you do not plan to add any additional information interactively, you will be able to use this template "as-is". Otherwise, you will need to delete one or more columns: (a) If your data has no SE information, delete both the `SE` and the `n` column. (b) If your data set has a single uniform value for the site, species, cultivar, treatment, access_level, or date, then these values may be entered interactively through the web interface; in this case you should delete the corresponding column(s) from the template. (c) Note that cultivar information can't be specified interactively unless species information is as well; delete the cultivar column if and only if either have not cultivar information or you are specifying both the species and the cultivar information interactively. * If [yields_by_doi.csv](https://docs.google.com/spreadsheets/d/1ExLosMvX05jHWO9UYVE4Dxcl2ZbUgPc0KYoUPruaOtM/export?format=csv&gid=0) Use this template if  you are uploading yield data and you wish to specify the citation in the file by doi use the template [yields_by_doi.csv](https://docs.google.com/spreadsheets/d/1ExLosMvX05jHWO9UYVE4Dxcl2ZbUgPc0KYoUPruaOtM/export?format=csv&gid=0). doi.  Again, if you do not have data for all of the columns listed in the template, or if you plan to specify some of the data interactively, you will have to delete one or more columns. (You may also use this template if all of the data in your data set pertains to a single citation and you wish to specify that citation interactively. In this case, you must delete the `citation_doi` column.) * [traits.csv](https://docs.google.com/spreadsheets/d/1lans4FMJ8avn34dcKkMzkEavqyZu6I4WuPP9oqeepc4/export?format=csv&gid=0) and can be downloaded in .xls format _[These templates include both citation by doi and by author/year/title; currently this isn't allowed.]_  3. Use the web interface to upload your data set and insert it into the database.