deletions | additions
diff --git a/bulk upload.md b/bulk upload.md
index 54bea88..f405e4f 100644
--- a/bulk upload.md
+++ b/bulk upload.md
...
# BETYdb: Bulk Data Upload
Currently the web interface does not support bulk data upload, although this is a planned feature for BETY 2.0.
For bulk data upload, or for a complete view of the tables in BETY, a blank spreadsheet can be found
[online](https://spreadsheets0.google.com/spreadsheet/pub?hl=en&hl=en&key=0Ai_PDCcY5g2JdFN1UDJJdjNsZk9RM0Z6bnFDdlQ0clE&output=html) and can be downloaded in .xls format [spreadsheet](https://spreadsheets0.google.com/spreadsheet/pub?hl=en&hl=en&key=0Ai_PDCcY5g2JdFN1UDJJdjNsZk9RM0Z6bnFDdlQ0clE&output=xls).
There are three phases for a basic bulk upload of data :
...
* to enter metadata (new sites, citations, treatments, managements)
* obtain a template appropriate for your data set.
2. Fill in the template with your data.
* [traits.csv](https://docs.google.com/spreadsheets/d/1lans4FMJ8avn34dcKkMzkEavqyZu6I4WuPP9oqeepc4/export?format=csv&gid=0) and can be downloaded in .xls format
* [yields.csv](https://docs.google.com/spreadsheets/d/1maK1uKr6i9KERaYdU5zSiXcBndQoiG4Vgn2DTnqdfbA/export?format=csv&gid=0).
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.
For clarity, in what follows, the term "field" wll be used to refer to the heading used in the uploaded CSV file and the term "column" or "attribute" to refer to an attribute of a yield datum in the yields table of the database.
* ### **Required fields**:
1. Citation
* If only one citation for the entire dataset exists, this may be specified interactively by choosing a citation on the citations page
* otherwise, specify in the CSV table using either (doi) or (author, year, first n characters of (title)) for some number n; or perhaps (author, year, first 3 words of (title))
* For citations, if citation_ doi is available, then the rest of fields pertaining to the citation may be left blank. However, if the citation_ doi is not available, then citation_ author, citation_ year, and citation_ title must all be entered.
2. site: use sitename
3. species: use scientificname
4. treatment: use name date: require one of the forms "2003-07-25", "2003-07", or "2003".
5. mean: must be one of the fields of the CSV table, though for uploads of yields data, we will by default call this field "yield" in the provided templates
6. n: required if and only if an SE column is given
7. SE: required if and only if an n column is given; this datum will be inserted into the stat column, and the statname will be set to "SE" access_level
Of these, the citation, site, species, treatment, and access_level may be specified interactively when uploading the dataset (if they are uniform for the whole set) rather than appearing as a field or set of fields of the CSV file. As noted above, for citations, this is done outside of the upload wizard by choosing a citation on the citations page.
### **Data for Yields**
1. mean: must be one of the fields of the CSV table, though for uploads of yields data, we will by default call this field "yield" in the provided templates
2. n: required if and only if an SE column is given
3. SE: required if and only if an n column is given; this datum will be inserted into the stat column, and the statname will be set to "SE" access_level
### **Data for Traits**
1. , , ... :
These column names should be replaced with values from \ref{tab:traits} (or see the [variables table](https://www.betydb.org) for a comprehensive listing).
2. , , ...
these columns should be replaced with values from \ref{tab:covariates}.
3. To enter n and SE, add additional columns " n" and " SE" as needed.
* **Optional fields**:
1. n and SE: as noted above, if one of these is present, the other must be as well; if SE is given, the value will go into the stat column of the yields table, and the statname column will be set to "SE"
