Scott edited bulk upload.md  over 9 years ago

Commit id: 0380f4bb2d12fcbb0c340a3d6e597d719f2189e4

deletions | additions      

       

* 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:  * [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. 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.  * [yields_by_doi.csv](https://docs.google.com/spreadsheets/d/1ExLosMvX05jHWO9UYVE4Dxcl2ZbUgPc0KYoUPruaOtM/export?format=csv&gid=0) [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. 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) [traits.csv](https://docs.google.com/spreadsheets/d/1Bv4dAPKU6YDJ6yB0DC4bAmHoGxSLgKybMpTR7qBvCu0/export?format=csv&gid=0) Use this template if you are uploading trait data  and you wish to specify the citation in the file by author, year, and title. **This template must be modified before it  can be downloaded used.** In particular, the column headings `[trait variable 1]` ... `[trait variable n]` must be replace by actual variable names that _exactly_ match names of variables  in .xls format _[These templates include both the database that have been marked to be recognized as trait variables. The number of these trait variable columns may need to be increased or decreased to accomodate the data set. Some trait variables allow or even require corresponding covariate information to be included. Again, the column headings `[covariate `]` ... `[covariate n]` must be changed to actually covariate variable names, and the number of these columns may need to be increased or decreased to match the available information. As with the yield data templates, some columns may also need to be deleted.  * [traits\_by\doi.csv](https://docs.google.com/spreadsheets/d/1Bv4dAPKU6YDJ6yB0DC4bAmHoGxSLgKybMpTR7qBvCu0/export?format=csv&gid=0) As with the corresponding yield data template, use this template if you are uploading trait data and you wish to specify the  citation in the file  by doi and by author/year/title; currently this isn't allowed.]_ or if you plan to specify the citation interactively (in which case delete the `citation_doi` column).  3. Use the web interface to upload your data set and insert it into the database.  For now, only the steps needed to upload yields data will be outlined in order to make this case simpler.